using Ant.Data; using Ant.Frame; using Ant.ORM; using Ant.SuperSocket.Common; using Ant.Service.Common; using Ant.Service.Common.Enums; using Central.Control.Domain; using MES.Production.Entity; using MES.Production.Entity.Entity; using MES.Production.Entity.Enum; using Ant.Service.Mongodb; using MES.Production.Service.IService; using MES.Production.Service.ServiceImp; using Ant.Service.Utility; using ChangFa.Machinery.WebPage.Areas.SysManage.Models; using ChangFa.Machinery.WebPage.Controllers; using MongoDB.Driver.Builders; using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Linq; using System.Text; using System.Web; using System.Web.Mvc; using JsonHelper = Ant.Service.Common.JsonHelper; namespace ChangFa.Machinery.WebPage.Areas.SysManage.Controllers { public class SchoolController : BaseController { [UserAuthorizeAttribute(ModuleAlias = "schoolList", OperaAction = "View")] public ActionResult SchoolList() { try { PageInfo pageInfo = new PageInfo(base.page, base.pagesize, 0, JsonConverter.JsonClass(new List())); #region 处理查询参数 var nameOrProject = Request.QueryString["nameOrProject"]; #endregion #region 加载列表 using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel res = new RequestModel(); res.newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取学校列表" }; var coachList = orm.Queryable(); int pageno = (base.page - 1) * base.pagesize; if (!nameOrProject.IsEmpty()) { coachList = coachList.Where(p => (!string.IsNullOrEmpty(p.Name) && p.Name.Contains(nameOrProject))); } var reslut = coachList.OrderByDesc(p => p.UpdateTime).Skip(pageno).Top(pagesize).ToList(res); if (reslut.IsSuccess) { reslut.RecordNum = coachList.Count(); pageInfo = new PageInfo(base.page, base.pagesize, reslut.RecordNum, JsonConverter.JsonClass(reslut.ResultModel)); } } ViewBag.Search = base.keywords; ViewData["nameOrProject"] = nameOrProject; return View(pageInfo); #endregion } catch (Exception e) { WriteLog(enumOperator.Select, "获取学校列表:", e); throw e.InnerException; } } public ActionResult Delete(string idList) { JsonHelper json = new JsonHelper() { Status = "n", Msg = "删除学校成功" }; try { //是否为空 if (string.IsNullOrEmpty(idList)) { json.Msg = "未找到要删除的学校"; return Json(json); } string[] id = idList.Trim(',').Split(','); for (int i = 0; i < id.Length; i++) { var userId = (id[i]); using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel request = new RequestModel { newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "删除学校" }, Oid = userId.ToString() }; var reslut = orm.DeleteById(request); if (reslut.IsSuccess) { json.Status = "y"; WriteLog(enumOperator.Remove, json.Msg, enumLog4net.WARN); } } } } catch (Exception e) { json.Msg = "删除学校发生内部错误!"; WriteLog(enumOperator.Remove, "删除学校:", e); } return Json(json); } [UserAuthorize(ModuleAlias = "schoolList", OperaAction = "Add,Edit")] [ValidateInput(false)] [HttpPost] public ActionResult Save(YM_School entity) { JsonHelper json = new JsonHelper() { Msg = "保存学校成功", Status = "n", ReUrl = "/Sys/School/SchoolList" }; try { using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel request = new RequestModel(); request.newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "保存学校" }; entity.Updator = entity.Creator; entity.UpdateTime = entity.CreateTime; entity.CertificateFileID = Request.Form["hidfilename"]; if (entity.ID > 0) { request.Oid = entity.ID.ToString(); var reslut = orm.UpdateById(entity, request); if (reslut.IsSuccess) { Ent_SYS_USER userupdate = new Ent_SYS_USER(); userupdate.PersistType = EntityPersistType.Update; userupdate.ACCOUNT = entity.UserName; var pwd = PasswordUtils.MD5_Encrypt(entity.PassWord, 32); userupdate.PASSWORD = pwd; string sqlstr = "UPDATE SYS_USER SET ACCOUNT='" + entity.UserName + "',PASSWORD='" + pwd + "' WHERE DPTID='" + request.Oid + "'"; //SqlDbHelper dbHelper = new SqlDbHelper(); var flag = SqlDbHelper.ExecuteCmd(sqlstr, SqlDbHelper.constr); json.Status = "y"; } else { json.Msg = "保存学校失败"; } } else { var reslut = orm.Save(entity, request); if (reslut.IsSuccess) { entity.Creator = this.CurrentUser.Name; entity.CreateTime = DateTime.Now; Ent_SYS_USER user = new Ent_SYS_USER(); user.CREATEDATE = DateTime.Now; user.CREATEPER = this.CurrentUser.Name; user.UPDATEDATE = DateTime.Now; user.UPDATEUSER = this.CurrentUser.Name; user.ACCOUNT = entity.UserName; user.NAME = entity.Name; var pwd = PasswordUtils.MD5_Encrypt(entity.PassWord, 32); user.PASSWORD = pwd; user.DPTID = reslut.RecordNum.ToString(); user.PINYIN1 = ConvertHzToPz.Convert(entity.Name).ToLower(); user.PINYIN2 = ConvertHzToPz.ConvertFirst(entity.Name).ToLower(); user.USERTYPE = 0; user.ISCANLOGIN = (entity.Status == 1) ? false : true; var reslutuser = orm.Save(user, request); EntSYS_USER_ROLE uSER_ROLE = new EntSYS_USER_ROLE(); uSER_ROLE.FK_USERID = reslutuser.RecordNum; uSER_ROLE.FK_ROLEID = 4; var reslutRole = orm.Save(uSER_ROLE, request); json.Status = "y"; } else { json.Msg = "保存学校失败"; } } } } catch (Exception ex) { json.Msg = "保存学校发生内部错误!"; WriteLog(enumOperator.None, "保存学校:", ex); } return Json(json); } [UserAuthorize(ModuleAlias = "schoolList", OperaAction = "Detail")] public ActionResult Detail(int? id) { YM_School mod = new YM_School(); if (id != null) { using (AntORM orm = new AntORM()) { try { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel request = new RequestModel { newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "查询教练的单个实体方法" }, Oid = id.ToString() }; var reslut = orm.GetEntity(request); if (reslut.IsSuccess) { mod = (YM_School)reslut.ResultModel; } } catch (Exception e) { } } } List items = new List(); items.Add(new SelectListItem { Text = "请选择", Value = "" }); var sysCodes = CommonEnumHelper.LoadDic(CommonCodeType.学校大类); foreach (var item in sysCodes) { items.Add(new SelectListItem { Text = item.NAMETEXT, Value = item.NAMETEXT }); } ViewBag.SchoolBigTypes = items; items = new List(); items.Add(new SelectListItem { Text = "请选择", Value = "" }); sysCodes = CommonEnumHelper.LoadDic(CommonCodeType.学校小类); foreach (var item in sysCodes) { items.Add(new SelectListItem { Text = item.NAMETEXT, Value = item.NAMETEXT }); } ViewBag.SchoolSmallTypes = items; return View(mod); } } }