public ActionResult EditModule(string Set, int Id) { try { using (DataWallContext db = new DataWallContext()) { var Module = db.SysThemeSets.Where(m => m.SysLibraryId == Id).AsNoTracking().FirstOrDefault(); if (Module != null) { SysThemeSet sysModule = new SysThemeSet() { ID = Module.ID, SysSeting = Set, EditTime = DateTime.Now, }; db.Entry(sysModule).State = EntityState.Modified; //不更新的字段 db.Entry(sysModule).Property(x => x.SysStyle).IsModified = false; db.Entry(sysModule).Property(x => x.SysLibraryId).IsModified = false; db.Entry(sysModule).Property(x => x.CrateTime).IsModified = false; db.Entry(sysModule).Property(x => x.IsEnable).IsModified = false; db.Entry(sysModule).Property(x => x.DelState).IsModified = false; db.SaveChanges(); } else { SysThemeSet sysModule = new SysThemeSet() { SysStyle = 1, SysSeting = Set, SysLibraryId = Id, CrateTime = DateTime.Now, EditTime = DateTime.Now, IsEnable = 0, DelState = 0 }; db.SysThemeSets.Add(sysModule); //添加 db.SaveChanges(); } Lg.AddLog("修改主题", "Module", 2, GetUserName()); //推送更新 PushUpdate(Id, "主题更新", 6); return(Json(new { code = "200", msg = "修改成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("内容状态修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联/系管理员!" })); } }
public ActionResult CustDeviceEditEnable(int id, int enable) { try { using (DataWallContext db = new DataWallContext()) { SysCustDevice sysCustDevice = new SysCustDevice() { ID = id, IsEnable = enable, EditTime = DateTime.Now }; db.Entry(sysCustDevice).State = EntityState.Modified; //不更新的字段 db.Entry(sysCustDevice).Property(x => x.CustDeviceName).IsModified = false; db.Entry(sysCustDevice).Property(x => x.Uuid).IsModified = false; db.Entry(sysCustDevice).Property(x => x.DataGuid).IsModified = false; db.Entry(sysCustDevice).Property(x => x.SysLibraryId).IsModified = false; db.Entry(sysCustDevice).Property(x => x.CrateTime).IsModified = false; db.Entry(sysCustDevice).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改客流设备状态", "Other", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("客流设备状态修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联/系管理员!" })); } }
//添加日志 public void AddLog(string Details, string Modular, int Type, string UserName) { string ip = IpHelper.GetWebClientIp(); Action action = new Action(() => { try { using (DataWallContext db = new DataWallContext()) { string city = IpHelper.GetCity(ip); SysLog sysLog = new SysLog(); sysLog.Type = Type; sysLog.Modular = Modular; sysLog.Details = Details; sysLog.UserName = UserName; sysLog.CrateTime = DateTime.Now; sysLog.Ip = ip; sysLog.Address = city; db.SysLogs.Add(sysLog); db.SaveChanges(); } } catch (Exception ex) { LogHelper.ErrorLog(Details + "操作日志添加失败!" + ex.Message); } }); action.BeginInvoke(null, null); }
public ActionResult EditEnable(int id, int enable) { try { using (DataWallContext db = new DataWallContext()) { SysLibrary sysLibrary = new SysLibrary() { ID = id, IsEnable = enable, EditTime = DateTime.Now }; db.Entry(sysLibrary).State = EntityState.Modified; //不更新的字段 db.Entry(sysLibrary).Property(x => x.LibraryName).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryDescribe).IsModified = false; db.Entry(sysLibrary).Property(x => x.Type).IsModified = false; db.Entry(sysLibrary).Property(x => x.City).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryCode).IsModified = false; db.Entry(sysLibrary).Property(x => x.CrateTime).IsModified = false; db.Entry(sysLibrary).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改场馆状态", "Library", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("场馆状态修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联/系管理员!" })); } }
public void CustCountingServlet([FromBody] string value) { try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; //获取传统context HttpRequestBase request = context.Request; //定义传统request对象 string uuid = request["uuid"]; string dataguid = request["dataguid"]; string innum = request["innum"]; string outnum = request["outnum"]; string curtime = request["curtime"]; string accessid = request["accessid"]; using (DataWallContext db = new DataWallContext()) { SysCustDevice sysCustDevice = db.SysCustDevices.Where(s => s.Uuid == uuid & s.DataGuid == dataguid).FirstOrDefault(); if (sysCustDevice != null) { SysCustData sysCustData = new SysCustData() { SysCustDeviceId = sysCustDevice.ID, D_Date = DateTime.Parse(curtime), D_InNum = int.Parse(innum), D_OutNum = int.Parse(outnum) }; db.SysCustDatas.Add(sysCustData); db.SaveChanges(); LogHelper.InfoLog("客流数据插入成功,入馆:" + innum + ";出馆:" + outnum); //推送客流更新 string ToLibraryName = db.SysLibrarys.Find(sysCustDevice.SysLibraryId).LibraryName; int type = 3; var msg = "客流数据更新"; MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new { msg = msg, action = "Other", type = type })); } else { LogHelper.ErrorLog("客流设备不存在;uuid:" + request["uuid"] + ",dataguid:" + request["dataguid"]); } HttpContext.Current.Response.Charset = "GB2312"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.Write("JunYuFr_CustFlow_ReturnCode=0"); HttpContext.Current.Response.End(); } } catch (Exception ex) { LogHelper.ErrorLog("客流数据插入失败:" + ex.ToString()); HttpContext.Current.Response.Charset = "GB2312"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.Write("JunYuFr_CustFlow_ReturnCode=0"); HttpContext.Current.Response.End(); } }
public ActionResult DelLibraryUser(int id, int LibraryId) { try { using (DataWallContext db = new DataWallContext()) { SysLibraryUser sysLibraryUser = db.SysLibraryUsers.FirstOrDefault(u => u.SysUserID == id & u.SysLibraryId == LibraryId); string RoleName = ""; foreach (var item in db.SysUsers.AsNoTracking().FirstOrDefault(u => u.ID == sysLibraryUser.SysUserID).SysUserRoles) { RoleName = item.SysRole.RoleName; } if (RoleName != "Administrator") { db.SysLibraryUsers.Remove(sysLibraryUser); db.SaveChanges(); Lg.AddLog("删除场馆", "Library", 3, GetUserName()); return(Json(new { code = "200", msg = "删除成功!" })); } else { return(Json(new { code = "201", msg = "管理员用户不可删除!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("场馆用户删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult AddLibraryUser(int id, int LibraryId) { try { using (DataWallContext db = new DataWallContext()) { if (db.SysLibraryUsers.Where(lu => lu.SysUserID == id && lu.SysLibraryId == LibraryId).AsNoTracking().Count() == 0) { SysLibraryUser sysLibraryUser = new SysLibraryUser() { SysUserID = id, SysLibraryId = LibraryId }; db.SysLibraryUsers.Add(sysLibraryUser); db.SaveChanges(); Lg.AddLog("添加场馆", "Library", 1, GetUserName()); return(Json(new { code = "200", msg = "添加成功!" })); } else { return(Json(new { code = "201", msg = "用户已存在于该场馆用户列表中!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("场馆用户添加失败:" + ex.Message); return(Json(new { code = "201", msg = "添加失败,请重试或联/系管理员!" })); } }
public ActionResult CustDeviceAdd(FormCollection CustDevice) { try { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); if (libList.Count == 0) { return(Json(new { code = "202", msg = "当前用户未分配可管理场馆,请联系系统管理员!" })); } ViewData["datalist"] = libList; //客流设备 if (CustDevice["Library"] != null) { string CustDeviceName = CustDevice["CustDeviceName"]; if (db.SysCustDevices.Where(d => d.CustDeviceName == DbFunctions.AsNonUnicode(CustDeviceName)).AsNoTracking().Count() >= 1) { return(Json(new { code = "202", msg = "设备名已存在!" })); } int LibraryId = int.Parse(CustDevice["Library"]); string LibraryName = db.SysLibrarys.Find(LibraryId).LibraryName; string Uuid = PingYinHelper.GetFirstSpell(LibraryName + CustDevice["CustDeviceName"]) + DateTime.Now.Millisecond; string DataGuid = System.Guid.NewGuid().ToString("D"); SysCustDevice sysCustDevice = new SysCustDevice() { CustDeviceName = CustDevice["CustDeviceName"], Uuid = Uuid, DataGuid = DataGuid, SysLibraryId = LibraryId, CrateTime = DateTime.Now, EditTime = DateTime.Now, IsEnable = 0, DelState = 0 }; db.SysCustDevices.Add(sysCustDevice); //添加客流设备 db.SaveChanges(); Lg.AddLog("添加客流设备", "Other", 1, GetUserName()); return(Json(new { code = "200", msg = "添加成功!" })); } else { return(Json(new { code = "202", msg = "请选择内容所属场馆!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("客流设备添加失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联系管理员!" })); } }
//添加用户 public void Add(SysUser sysUser) { using (DataWallContext db = new DataWallContext()) { db.SysUsers.Add(sysUser); db.SaveChanges(); } }
public ActionResult DelAdditionalData(int id, int page) { try { using (DataWallContext db = new DataWallContext()) { SysAdditionalData sysAdditionalData = new SysAdditionalData() { ID = id, DelState = 1, EditTime = DateTime.Now }; db.Entry(sysAdditionalData).State = EntityState.Modified; //不更新的字段 db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.PeopleNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.BookNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.StillPeopleNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.StillBookNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.DataDatetime).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.SysLibraryId).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.IsEnable).IsModified = false; db.SaveChanges(); int npage = 0; int Count = db.SysAdditionalDatas.Where(u => u.DelState == 0).Count(); double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10)); if (MaxPage > page) { npage = page; } else { if (Count <= 10) { npage = 1; } else { npage = page - 1; } } Lg.AddLog("删除额外数据", "Other", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("额外数据删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult UserEdit(FormCollection User) { try { if (Check("UserEdit", int.Parse(User["ID"]), User["UserName"])) { using (DataWallContext db = new DataWallContext()) { SysUser sysUser = new SysUser() { ID = int.Parse(User["ID"]), UserName = User["UserName"], Email = User["Email"], EditTime = DateTime.Now }; db.Entry(sysUser).State = EntityState.Modified; //修改密码 if (!string.IsNullOrEmpty(User["Password"])) { sysUser.Password = MD5Helper.MD5Encrypt32(User["Password"]); } //不修改密码 else { //不更新的字段 db.Entry(sysUser).Property(x => x.Password).IsModified = false; } //不更新的字段 db.Entry(sysUser).Property(x => x.CrateTime).IsModified = false; db.Entry(sysUser).Property(x => x.IsEnable).IsModified = false; db.Entry(sysUser).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改用户", "User", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } } else { return(Json(new { code = "202", msg = "用户名已存在!" })); } } catch (Exception ex) { if (User.Count > 0) { LogHelper.ErrorLog("用户修改失败:" + ex.Message); } return(Json(new { code = "201", msg = "修改失败,请重试或联系管理员!" })); } }
public ActionResult DelLibrary(int id, int page) { try { using (DataWallContext db = new DataWallContext()) { SysLibrary sysLibrary = new SysLibrary() { ID = id, DelState = 1, EditTime = DateTime.Now }; db.Entry(sysLibrary).State = EntityState.Modified; //不更新的字段 db.Entry(sysLibrary).Property(x => x.LibraryName).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryDescribe).IsModified = false; db.Entry(sysLibrary).Property(x => x.Type).IsModified = false; db.Entry(sysLibrary).Property(x => x.City).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryCode).IsModified = false; db.Entry(sysLibrary).Property(x => x.CrateTime).IsModified = false; db.Entry(sysLibrary).Property(x => x.IsEnable).IsModified = false; db.SaveChanges(); int npage = 0; int Count = db.SysLibrarys.Where(u => u.DelState == 0).AsNoTracking().Count(); double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10)); if (MaxPage > page) { npage = page; } else { if (Count <= 10) { npage = 1; } else { npage = page - 1; } } Lg.AddLog("删除场馆", "Library", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("场馆删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult CustDeviceEdit(FormCollection CustDevice) { try { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); if (libList.Count == 0) { return(Json(new { code = "202", msg = "当前用户未分配可管理场馆,请联系系统管理员!" })); } ViewData["datalist"] = libList; //客流设备 if (CustDevice["Library"] != null) { SysCustDevice sysCustDevice = new SysCustDevice() { ID = int.Parse(CustDevice["ID"]), CustDeviceName = CustDevice["CustDeviceName"], SysLibraryId = int.Parse(CustDevice["Library"]), EditTime = DateTime.Now }; db.Entry(sysCustDevice).State = EntityState.Modified; //不更新的字段 db.Entry(sysCustDevice).Property(x => x.Uuid).IsModified = false; db.Entry(sysCustDevice).Property(x => x.DataGuid).IsModified = false; db.Entry(sysCustDevice).Property(x => x.CrateTime).IsModified = false; db.Entry(sysCustDevice).Property(x => x.IsEnable).IsModified = false; db.Entry(sysCustDevice).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改客流设备", "Other", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } else { return(Json(new { code = "202", msg = "请选择内容所属场馆!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("客流设备修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联系管理员!" })); } }
public ActionResult UserAdd(FormCollection User) { try { if (Check("UserAdd", 0, User["UserName"])) { using (DataWallContext db = new DataWallContext()) { //用户 SysUser sysUser = new SysUser(); sysUser.UserName = User["UserName"]; sysUser.Email = User["Email"]; sysUser.Password = MD5Helper.MD5Encrypt32(User["Password"]); sysUser.IsEnable = 0; sysUser.CrateTime = DateTime.Now; sysUser.EditTime = DateTime.Now; sysUser.DelState = 0; db.SysUsers.Add(sysUser); //权限 var sysUserRoles = new List <SysUserRole> { new SysUserRole { SysUserID = sysUser.ID, SysRoleId = 2 } }; sysUserRoles.ForEach(s => db.SysUserRoles.Add(s)); //添加 db.SaveChanges(); Lg.AddLog("添加用户", "User", 1, GetUserName()); return(Json(new { code = "200", msg = "添加成功!" })); } } else { return(Json(new { code = "202", msg = "用户名已存在!" })); } } catch (Exception ex) { if (User.Count > 0) { LogHelper.ErrorLog("用户添加失败:" + ex.Message); } return(Json(new { code = "201", msg = "添加失败,请重试或联/系管理员!" })); } }
//删除用户 public bool Delete(int id) { using (DataWallContext db = new DataWallContext()) { var delSysUser = db.SysUsers.FirstOrDefault(u => u.ID == id); if (delSysUser != null) { db.SysUsers.Remove(delSysUser); db.SaveChanges(); return(true); } else { return(false); } } }
public ActionResult EditEnable(int id, int enable) { try { using (DataWallContext db = new DataWallContext()) { string RoleName = ""; foreach (var item in db.SysUsers.AsNoTracking().FirstOrDefault(u => u.ID == id).SysUserRoles) { RoleName = item.SysRole.RoleName; } if (RoleName != "Administrator") { SysUser sysUser = new SysUser() { ID = id, IsEnable = enable, EditTime = DateTime.Now }; db.Entry(sysUser).State = EntityState.Modified; //不更新的字段 db.Entry(sysUser).Property(x => x.UserName).IsModified = false; db.Entry(sysUser).Property(x => x.Email).IsModified = false; db.Entry(sysUser).Property(x => x.Password).IsModified = false; db.Entry(sysUser).Property(x => x.CrateTime).IsModified = false; db.Entry(sysUser).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改用户状态", "User", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } else { LogHelper.ErrorLog("管理员状态修改失败"); return(Json(new { code = "201", msg = "超级管理员用户不可进行该操作!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("用户状态修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联/系管理员!" })); } }
public ActionResult AdditionalDataEditEnable(int id, int enable) { try { using (DataWallContext db = new DataWallContext()) { SysAdditionalData sysAdditionalData = new SysAdditionalData() { ID = id, IsEnable = enable, EditTime = DateTime.Now }; db.Entry(sysAdditionalData).State = EntityState.Modified; //不更新的字段 db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.PeopleNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.BookNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.StillPeopleNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.StillBookNum).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.DataDatetime).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.SysLibraryId).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改额外数据状态", "Other", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("额外数据状态修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联/系管理员!" })); } }
public ActionResult LibraryAdd(FormCollection Library) { try { if (Check("LibraryAdd", 0, Library["LibraryName"])) { using (DataWallContext db = new DataWallContext()) { int Type = int.Parse(Library["Type"]); SysProgramInfo sysProgramInfo = db.SysProgramInfos.AsNoTracking().FirstOrDefault(); List <SysLibrary> sysLibraryList = db.SysLibrarys.AsNoTracking().Where(s => s.DelState == 0).ToList(); switch (Type) { case 0: if (sysLibraryList.Where(s => s.Type == 0).Count() >= sysProgramInfo.MasterNum) { return(Json(new { code = "202", msg = "总馆数量已达上限" })); } break; case 1: if (sysLibraryList.Where(s => s.Type == 1).Count() >= sysProgramInfo.BranchNum) { return(Json(new { code = "202", msg = "分馆数量已达上限" })); } break; } //场馆 int FatherLibraryId = 0; if (Type == 0) { FatherLibraryId = 0; } else { if (Library["FatherLibraryId"] == null) { return(Json(new { code = "201", msg = "请选择上级场馆" })); } FatherLibraryId = int.Parse(Library["FatherLibraryId"]); } string LibraryName = Library["LibraryName"]; string LibraryCode = PingYinHelper.GetFirstSpell(Library["LibraryName"]) + DateTime.Now.Millisecond; SysLibrary sysLibrary = new SysLibrary() { City = "上海", LibraryName = LibraryName, FatherLibraryId = FatherLibraryId, LibraryDescribe = HttpUtility.UrlDecode(Library["Describe"]).Replace("'", "‘"), Type = Type, LibraryCode = LibraryCode, CrateTime = DateTime.Now, EditTime = DateTime.Now, IsEnable = 0, DelState = 0 }; db.SysLibrarys.Add(sysLibrary); //添加 db.SaveChanges(); //添加管理员为管理用户 int SysLibraryId = sysLibrary.ID; List <SysLibraryUser> sysLibraryUsers = new List <SysLibraryUser> { new SysLibraryUser { SysUserID = 1, SysLibraryId = SysLibraryId } }; sysLibraryUsers.ForEach(s => db.SysLibraryUsers.Add(s)); //添加 db.SaveChanges(); Lg.AddLog("添加场馆", "Library", 1, GetUserName()); return(Json(new { code = "200", msg = "添加成功!" })); } } else { return(Json(new { code = "202", msg = "场馆已存在!" })); } } catch (Exception ex) { if (Library.Count > 0) { LogHelper.ErrorLog("场馆添加失败:" + ex.Message); } return(Json(new { code = "201", msg = "添加失败,请重试或联系管理员!" })); } }
public ActionResult DelUser(int id, int page) { try { using (DataWallContext db = new DataWallContext()) { string RoleName = ""; foreach (var item in db.SysUsers.AsNoTracking().FirstOrDefault(u => u.ID == id).SysUserRoles) { RoleName = item.SysRole.RoleName; } if (RoleName != "Administrator") { SysUser sysUser = new SysUser() { ID = id, DelState = 1, EditTime = DateTime.Now }; db.Entry(sysUser).State = EntityState.Modified; //不更新的字段 db.Entry(sysUser).Property(x => x.UserName).IsModified = false; db.Entry(sysUser).Property(x => x.Email).IsModified = false; db.Entry(sysUser).Property(x => x.Password).IsModified = false; db.Entry(sysUser).Property(x => x.CrateTime).IsModified = false; db.Entry(sysUser).Property(x => x.IsEnable).IsModified = false; db.SaveChanges(); int npage = 0; int Count = db.SysUsers.Where(u => u.DelState == 0).AsNoTracking().Count(); double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10)); if (MaxPage > page) { npage = page; } else { if (Count <= 10) { npage = 1; } else { npage = page - 1; } } Lg.AddLog("删除用户", "User", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } else { LogHelper.ErrorLog("管理员删除失败"); return(Json(new { code = "201", msg = "超级管理员用户不可进行该操作!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("用户删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult DelUserAll(string idList, int page) { try { using (DataWallContext db = new DataWallContext()) { //获取待删除用户id集 string[] sArray = idList.Split(','); int[] IdList = new int[sArray.Length]; for (int i = 0; i < sArray.Length; i++) { IdList[i] = Int32.Parse(sArray[i]); } for (int i = 0; i < IdList.Length; i++) { int id = IdList[i]; string RoleName = ""; foreach (var item in db.SysUsers.AsNoTracking().FirstOrDefault(u => u.ID == id).SysUserRoles) { RoleName = item.SysRole.RoleName; } if (RoleName != "Administrator") { SysUser sysUser = new SysUser() { ID = id, DelState = 1, EditTime = DateTime.Now }; db.Entry(sysUser).State = EntityState.Modified; //不更新的字段 db.Entry(sysUser).Property(x => x.ID).IsModified = false; db.Entry(sysUser).Property(x => x.UserName).IsModified = false; db.Entry(sysUser).Property(x => x.Email).IsModified = false; db.Entry(sysUser).Property(x => x.Password).IsModified = false; db.Entry(sysUser).Property(x => x.CrateTime).IsModified = false; db.Entry(sysUser).Property(x => x.IsEnable).IsModified = false; db.SaveChanges(); } } int npage = 0; int Count = db.SysUsers.Where(u => u.DelState == 0).AsNoTracking().Count(); double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10)); if (MaxPage > page) { npage = page; } else { if (Count <= 10) { npage = 1; } else { if ((Count % 10) <= page) { npage = page - 1; } } } Lg.AddLog("删除用户", "User", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("用户删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult DelLibraryAll(string idList, int page) { try { using (DataWallContext db = new DataWallContext()) { //获取待删除场馆id集 string[] sArray = idList.Split(','); int[] IdList = new int[sArray.Length]; for (int i = 0; i < sArray.Length; i++) { IdList[i] = Int32.Parse(sArray[i]); } for (int i = 0; i < IdList.Length; i++) { int id = IdList[i]; SysLibrary sysLibrary = new SysLibrary() { ID = id, DelState = 1, EditTime = DateTime.Now }; db.Entry(sysLibrary).State = EntityState.Modified; //不更新的字段 db.Entry(sysLibrary).Property(x => x.LibraryName).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryDescribe).IsModified = false; db.Entry(sysLibrary).Property(x => x.Type).IsModified = false; db.Entry(sysLibrary).Property(x => x.City).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryCode).IsModified = false; db.Entry(sysLibrary).Property(x => x.CrateTime).IsModified = false; db.Entry(sysLibrary).Property(x => x.IsEnable).IsModified = false; db.SaveChanges(); } int npage = 0; int Count = db.SysLibrarys.Where(u => u.DelState == 0).AsNoTracking().Count(); double MaxPage = Convert.ToDouble(Convert.ToDouble(Count + 10) / Convert.ToDouble(10)); if (MaxPage > page) { npage = page; } else { if (Count <= 10) { npage = 1; } else { if ((Count % 10) <= page) { npage = page - 1; } } } Lg.AddLog("删除场馆", "User", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("场馆删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }
public ActionResult LibraryEdit(FormCollection Library) { try { if (Check("LibraryEdit", int.Parse(Library["ID"]), Library["LibraryName"])) { using (DataWallContext db = new DataWallContext()) { int LbraryId = int.Parse(Library["ID"]); int Type = int.Parse(Library["Type"]); SysProgramInfo sysProgramInfo = db.SysProgramInfos.AsNoTracking().FirstOrDefault(); List <SysLibrary> sysLibraryList = db.SysLibrarys.AsNoTracking().Where(s => s.DelState == 0).ToList(); switch (Type) { case 0: if (sysLibraryList.Where(s => s.Type == 0).Count() >= sysProgramInfo.MasterNum) { if (sysLibraryList.Where(s => s.Type == 0 & s.ID == LbraryId & s.DelState == 0).Count() < 1) { return(Json(new { code = "202", msg = "总馆数量已达上限" })); } } break; case 1: if (sysLibraryList.Where(s => s.Type == 1).Count() >= sysProgramInfo.BranchNum) { if (sysLibraryList.Where(s => s.Type == 1 & s.ID == LbraryId & s.DelState == 0).Count() < 1) { return(Json(new { code = "202", msg = "分馆数量已达上限" })); } } break; } //场馆 int FatherLibraryId = 0; if (Type == 0) { FatherLibraryId = 0; } else { if (Library["FatherLibraryId"] == null) { return(Json(new { code = "201", msg = "请选择上级场馆" })); } FatherLibraryId = int.Parse(Library["FatherLibraryId"]); if (int.Parse(Library["ID"]) == FatherLibraryId) { return(Json(new { code = "202", msg = "不可以选择自身为上级场馆" })); } } string LibraryName = Library["LibraryName"]; string LibraryCode = PingYinHelper.GetFirstSpell(Library["LibraryName"]) + DateTime.Now.Millisecond; SysLibrary sysLibrary = new SysLibrary() { ID = LbraryId, LibraryName = Library["LibraryName"], LibraryDescribe = HttpUtility.UrlDecode(Library["Describe"]).Replace("'", "‘"), FatherLibraryId = FatherLibraryId, Type = int.Parse(Library["Type"]), EditTime = DateTime.Now }; db.Entry(sysLibrary).State = EntityState.Modified; //不更新的字段 db.Entry(sysLibrary).Property(x => x.City).IsModified = false; db.Entry(sysLibrary).Property(x => x.LibraryCode).IsModified = false; db.Entry(sysLibrary).Property(x => x.CrateTime).IsModified = false; db.Entry(sysLibrary).Property(x => x.IsEnable).IsModified = false; db.Entry(sysLibrary).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改场馆", "Library", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } } else { return(Json(new { code = "202", msg = "场馆已存在!" })); } } catch (Exception ex) { if (Library.Count > 0) { LogHelper.ErrorLog("场馆修改失败:" + ex.Message); } return(Json(new { code = "201", msg = "修改失败,请重试或联系管理员!" })); } }
public ActionResult AdditionalDataEdit(FormCollection AdditionalData) { try { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); if (libList.Count == 0) { return(Json(new { code = "202", msg = "当前用户未分配可管理场馆,请联系系统管理员!" })); } ViewData["datalist"] = libList; //额外数据 if (AdditionalData["Library"] != null) { int BookNum = 0; int StillPeopleNum = 0; int StillBookNum = 0; int LibraryId = int.Parse(AdditionalData["Library"]); string ToLibraryName = db.SysLibrarys.Find(LibraryId).LibraryName; if (AdditionalData["Type"] == "0") { BookNum = 0; StillPeopleNum = 0; StillPeopleNum = 0; int type = 3; var msg = "客流数据更新"; MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new { msg = msg, action = "Other", type = type })); } else { BookNum = int.Parse(AdditionalData["BookNum"]); StillPeopleNum = int.Parse(AdditionalData["StillPeopleNum"]); StillBookNum = int.Parse(AdditionalData["StillBookNum"]); int type = 4; var msg = "借还数据更新"; MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new { msg = msg, action = "Other", type = type })); } SysAdditionalData sysAdditionalData = new SysAdditionalData() { ID = int.Parse(AdditionalData["ID"]), PeopleNum = int.Parse(AdditionalData["PeopleNum"]), BookNum = BookNum, StillPeopleNum = StillPeopleNum, StillBookNum = StillBookNum, DataDatetime = DateTime.Parse(AdditionalData["DataDatetime"]), SysLibraryId = int.Parse(AdditionalData["Library"]), EditTime = DateTime.Now }; db.Entry(sysAdditionalData).State = EntityState.Modified; //不更新的字段 db.Entry(sysAdditionalData).Property(x => x.Type).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.CrateTime).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.IsEnable).IsModified = false; db.Entry(sysAdditionalData).Property(x => x.DelState).IsModified = false; db.SaveChanges(); Lg.AddLog("修改额外数据", "Other", 2, GetUserName()); return(Json(new { code = "200", msg = "修改成功!" })); } else { return(Json(new { code = "202", msg = "请选择内容所属场馆!" })); } } } catch (Exception ex) { LogHelper.ErrorLog("额外数据修改失败:" + ex.Message); return(Json(new { code = "201", msg = "修改失败,请重试或联系管理员!" })); } }
public ActionResult UploadExcel(int Type) { int location = 0; try { var file = Request.Files[0]; var filecombin = file.FileName.Split('.'); if (file == null || String.IsNullOrEmpty(file.FileName) || file.ContentLength == 0 || filecombin.Length < 2) { return(Json(new { code = "201", msg = "上传出错请检查文件名或文件内容" })); } using (ExcelPackage package = new ExcelPackage(file.InputStream)) { int count = package.Workbook.Worksheets.Count; ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; //获取表格的列数和行数 int rowCount = worksheet.Dimension.Rows; int ColCount = worksheet.Dimension.Columns; var sysAdditionalDatas = new List <SysAdditionalData>(); //插入数据 using (DataWallContext db = new DataWallContext()) { for (int row = 2; row <= rowCount; row++) { location = row; int PeopleNum = 0; int BookNum = 0; int StillPeopleNum = 0; int StillBookNum = 0; DateTime DataDatetime = DateTime.Now; switch (Type) { case 0: PeopleNum = int.Parse(worksheet.Cells[row, 3].Value.ToString()); DataDatetime = DateTime.Parse(worksheet.Cells[row, 4].Value.ToString()); break; case 1: PeopleNum = int.Parse(worksheet.Cells[row, 3].Value.ToString()); BookNum = int.Parse(worksheet.Cells[row, 4].Value.ToString()); StillPeopleNum = int.Parse(worksheet.Cells[row, 5].Value.ToString()); StillBookNum = int.Parse(worksheet.Cells[row, 6].Value.ToString()); DataDatetime = DateTime.Parse(worksheet.Cells[row, 7].Value.ToString()); break; } SysAdditionalData sysAdditionalData = new SysAdditionalData() { PeopleNum = PeopleNum, BookNum = BookNum, StillPeopleNum = StillPeopleNum, StillBookNum = StillBookNum, DataDatetime = DataDatetime, SysLibraryId = int.Parse(worksheet.Cells[row, 2].Value.ToString()), CrateTime = DateTime.Now, EditTime = DateTime.Now, DelState = 0, Type = Type }; sysAdditionalDatas.Add(sysAdditionalData); //数据检查 if (!CheckLibraryId(worksheet.Cells[row, 2].Value.ToString(), worksheet.Cells[row, 1].Value.ToString())) { return(Json(new { code = "201", msg = "场馆不存在或您没有场馆" + worksheet.Cells[row, 1].Value.ToString() + "(ID:" + worksheet.Cells[row, 2].Value.ToString() + ")" + "的数据导入权限" })); } //推送客流更新 string ToLibraryName = db.SysLibrarys.Find(sysAdditionalData.SysLibraryId).LibraryName; int type = 3; var msg = "客流数据更新"; MyHub.Show(ToLibraryName, JsonConvert.SerializeObject(new { msg = msg, action = "CustData", type = type })); } sysAdditionalDatas.ForEach(s => db.SysAdditionalDatas.Add(s)); db.SaveChanges(); } Lg.AddLog("导入额外数据", "Other", 1, GetUserName()); return(Json(new { code = "200", msg = "导入成功" })); } } catch (Exception ex) { LogHelper.ErrorLog("数据导入失败:" + ex.Message); return(Json(new { code = "201", msg = "导入失败,请检查内容格式,错误行号:" + location })); } }