/// <summary> /// 后台首页 /// </summary> /// <returns></returns> public ActionResult Index() { using (DataWallContext db = new DataWallContext()) { var Cookies = SecurityHelper.DecryptDES(CookieHelper.GetCookieValue("User"), db.SysProgramInfos.AsNoTracking().FirstOrDefault().CookieSecretKey); if (Cookies != "") { UserCookie user = JsonConvert.DeserializeObject <UserCookie>(Cookies); ViewBag.UserName = user.UserName; ViewBag.RoleName = user.RoleName; } else { return(RedirectToAction("Login")); } SysProgramInfo sysProgramInfo = db.SysProgramInfos.AsNoTracking().FirstOrDefault(); ViewBag.Title = "数据墙后台管理系统" + sysProgramInfo.ProgramVersion; //获取菜单 List <SysMenu> menuList = db.SysMenus.Where(m => m.IsEnable == 0 & m.DelState == 0).AsNoTracking().ToList(); ViewData["datalist"] = menuList; //模块菜单 List <SysModule> ModuleMenu = db.SysModules.Where(m => m.IsEnable == 0 & m.DelState == 0 & m.IsAddToMenu == 0).AsNoTracking().ToList(); ViewData["modulelist"] = ModuleMenu; return(View(sysProgramInfo)); } }
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 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 GetModuleSet() { using (DataWallContext db = new DataWallContext()) { var Cookies = SecurityHelper.DecryptDES(CookieHelper.GetCookieValue("Library"), db.SysProgramInfos.AsNoTracking().FirstOrDefault().CookieSecretKey); if (Cookies != null & Cookies != "") { SysLibrary Library = JsonConvert.DeserializeObject <SysLibrary>(Cookies); var Module = db.SysThemeSets.Where(m => m.SysLibraryId == Library.ID).Select(m => new { m.SysSeting, m.SysStyle }).FirstOrDefault(); if (Module != null) { return(Json(new { code = "200", data = Module }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { code = "202", msg = "没有数据" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { code = 202, msg = "验证失败" }, JsonRequestBehavior.AllowGet)); } } }
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 = "添加失败,请重试或联/系管理员!" })); } }
/// <summary> /// 场馆列表页 /// </summary> /// <returns></returns> public ActionResult List(int?page) { using (DataWallContext db = new DataWallContext()) { List <SysLibrary> Liabrary = db.SysLibrarys.Where(u => u.DelState == 0).AsNoTracking().ToList(); ViewBag.DataCout = Liabrary.Count(); ViewBag.Key = db.SysProgramInfos.AsNoTracking().FirstOrDefault().CookieSecretKey; //第几页 int pageNumber = page ?? 1; //每页显示多少条 int pageSize = 10; //根据ID排序 Liabrary = Liabrary.OrderBy(u => u.ID).ToList(); //通过ToPagedList扩展方法进行分页 IPagedList <SysLibrary> pagedList = Liabrary.ToPagedList(pageNumber, pageSize); //if (Users.Count < 10) { // page //} //将分页处理后的列表传给View return(View(pagedList)); } }
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(); } }
/// <summary> /// 获取历史上的今天 /// </summary> /// <returns></returns> public ActionResult History() { try { using (DataWallContext db = new DataWallContext()) { int month = DateTime.Now.Month; int day = DateTime.Now.Day; var History = db.Historys.Where(h => h.month == month & h.day == day & h.pic.Contains(".")).AsNoTracking().ToList(); return(Json(new { code = 201, data = History }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { LogHelper.ErrorLog(ex.Message); return(Json(new { code = 202, data = "服务器错误" }, JsonRequestBehavior.AllowGet)); } }
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 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 SysUser SelectByNamePs(string userName, string passWord) { using (DataWallContext db = new DataWallContext()) { return(db.SysUsers.FirstOrDefault(u => (u.UserName == userName || u.Email == userName) & u.Password == passWord)); } }
//通过用户名查询用户 public SysUser SelectByName(string userName) { using (DataWallContext db = new DataWallContext()) { return(db.SysUsers.FirstOrDefault(u => u.UserName == userName)); } }
//查询所有用户 public IQueryable <SysUser> SelectAll() { using (DataWallContext db = new DataWallContext()) { return(db.SysUsers); } }
/// <summary> /// 添加场馆页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult LibraryAdd() { using (DataWallContext db = new DataWallContext()) { ViewData["datalist"] = db.SysLibrarys.Where(l => l.IsEnable == 0 & l.DelState == 0 & l.Type == 0).AsNoTracking().ToList(); return(View()); } }
//添加用户 public void Add(SysUser sysUser) { using (DataWallContext db = new DataWallContext()) { db.SysUsers.Add(sysUser); db.SaveChanges(); } }
/// <summary> /// 修改密码页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult PwdEdit(string UserName) { using (DataWallContext db = new DataWallContext()) { SysUser sysUser = db.SysUsers.AsNoTracking().FirstOrDefault(u => u.UserName == UserName); return(View(sysUser)); } }
/// <summary> /// 修改用户页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult UserEdit(int id) { using (DataWallContext db = new DataWallContext()) { SysUser sysUser = db.SysUsers.Find(id); return(View(sysUser)); } }
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 = "修改失败,请重试或联/系管理员!" })); } }
/// <summary> /// 获取当前用户可管理场馆 /// </summary> /// <returns></returns> public List <SysLibrary> GetLibraryList() { using (DataWallContext db = new DataWallContext()) { var Cookies = SecurityHelper.DecryptDES(CookieHelper.GetCookieValue("User"), db.SysProgramInfos.AsNoTracking().FirstOrDefault().CookieSecretKey); UserCookie user = JsonConvert.DeserializeObject <UserCookie>(Cookies); var Libids = db.SysLibraryUsers.Where(u => u.SysUserID == user.UserId).Select(u => u.SysLibraryId).ToList(); return(db.SysLibrarys.Where(lib => Libids.Contains(lib.ID) & lib.DelState == 0 & lib.IsEnable == 0).AsNoTracking().ToList()); } }
// GET: Error public ActionResult Error(string Msg) { using (DataWallContext db = new DataWallContext()) { MsgInfo msgInfo = JsonConvert.DeserializeObject <MsgInfo>(SecurityHelper.DecryptDES(Msg, db.SysProgramInfos.FirstOrDefault().CookieSecretKey)); ViewBag.Title = msgInfo.Title; ViewBag.Content = msgInfo.Content; return(View()); } }
/// <summary> /// 客流设备添加页 /// </summary> /// <returns></returns> public ActionResult CustDeviceAdd() { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); ViewData["datalist"] = libList; return(View()); } }
/// <summary> /// 获取用户名 /// </summary> /// <returns></returns> public string GetUserName() { using (DataWallContext db = new DataWallContext()) { //获取当前登陆用户 var Cookies = SecurityHelper.DecryptDES(CookieHelper.GetCookieValue("User"), db.SysProgramInfos.AsNoTracking().FirstOrDefault().CookieSecretKey); UserCookie user = JsonConvert.DeserializeObject <UserCookie>(Cookies); return(user.UserName); } }
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 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 = "删除失败,请重试或联/系管理员!" })); } }
/// <summary> /// 欢迎页 /// </summary> /// <returns></returns> public ActionResult Welcome() { try { using (DataWallContext db = new DataWallContext()) { List <SysLog> logList = db.SysLogs.Where(s => s.Modular != "User").OrderByDescending(u => u.CrateTime).Take(5).AsNoTracking().ToList(); ViewData["datalist"] = logList; TimeSpan Time = DateTime.Now - db.SysProgramInfos.AsNoTracking().FirstOrDefault().FirstRunTime; ViewBag.Time = Math.Round(Time.TotalHours, 0); //获取软件信息 SysProgramInfo sysProgramInfo = db.SysProgramInfos.AsNoTracking().FirstOrDefault(); ViewBag.ProgramVersion = sysProgramInfo.ProgramVersion; string Msg = string.Empty; if (sysProgramInfo.Type == 1) { if (sysProgramInfo.ExpirationDate > DateTime.Now) { Msg = "当前版本为<span style='color:red;font-size:16px'><strong>试用版</strong></span>,到期时间:<span style='color:red;font-size:16px'><strong>" + sysProgramInfo.ExpirationDate.ToString("f") + "</strong></span>"; } else { Msg = "当前版本<span style='color:red;font-size:16px'><strong>已过期</strong></span>,到期时间:<span style='color:red;font-size:16px'><strong>" + sysProgramInfo.ExpirationDate.ToString("f") + "</strong></span>"; } } ViewBag.Msg = Msg; //获取服务器信息 ViewModels.SystemInfo systemInfo = JsonConvert.DeserializeObject <ViewModels.SystemInfo>(Common.SystemInfo.GetSystemInfo()); //可用模块 List <SysModule> Module = db.SysModules.Where(m => m.IsEnable == 0 & m.DelState == 0).AsNoTracking().ToList(); List <SysMenu> Menu = db.SysMenus.Where(m => m.IsEnable == 0 & m.DelState == 0).AsNoTracking().ToList(); foreach (var item in Menu) { SysModule sysModule = new SysModule() { Title = item.MenuName, Describe = item.Describe, Sort = item.Sort }; Module.Add(sysModule); } ViewData["modulelist"] = Module.OrderBy(m => m.Sort).ToList(); return(View(systemInfo)); } } catch (Exception ex) { LogHelper.ErrorLog("欢迎页加载失败:" + ex.Message); return(Json(new { error = "页面加载失败,请联系管理员" })); } }
/// <summary> /// 额外数据修改页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult AdditionalDataEdit(int id) { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); ViewData["datalist"] = libList; SysAdditionalData sysAdditionalData = db.SysAdditionalDatas.Find(id); return(View(sysAdditionalData)); } }
/// <summary> /// 客流设备修改页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult CustDeviceEdit(int id) { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); ViewData["datalist"] = libList; SysCustDevice sysCustDevice = db.SysCustDevices.Find(id); return(View(sysCustDevice)); } }
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 = "删除失败,请重试或联/系管理员!" })); } }
/// <summary> /// 客流设备列表页 /// </summary> /// <returns></returns> public ActionResult CustDeviceList(SearchInfo searchInfo, int?page) { using (DataWallContext db = new DataWallContext()) { //当前用户可管理场馆 List <SysLibrary> libList = GetLibraryList(); ViewData["datalist"] = libList; int[] libids = new int[libList.Count]; for (int i = 0; i < libList.Count; i++) { libids[i] = libList[i].ID; } //全部内容 var list = db.SysCustDevices.Where(u => u.DelState == 0 & libids.Contains(u.SysLibraryId)).AsNoTracking().ToList(); //第几页 int pageNumber = page ?? 1; //条件查询 if (searchInfo != null) { int libraryIds = searchInfo.library; string keywords = searchInfo.keyword; if (keywords == null) { keywords = ""; } if (libraryIds != 0) { list = db.SysCustDevices.Where(u => u.DelState == 0 & u.SysLibraryId == libraryIds & u.CustDeviceName.Contains(keywords)).AsNoTracking().ToList(); } else { list = db.SysCustDevices.Where(u => u.DelState == 0 & libids.Contains(u.SysLibraryId) & u.CustDeviceName.Contains(keywords)).AsNoTracking().ToList(); } } //每页显示的数据数量 int pageSize = 10; ViewBag.DataCout = list.Count(); ViewBag.library = searchInfo.library; ViewBag.keyword = searchInfo.keyword; //通过ToPagedList扩展方法进行分页 IPagedList <SysCustDevice> pagedList = list.OrderByDescending(c => c.CrateTime).ToPagedList(pageNumber, pageSize); return(View(pagedList)); } }