/// <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));
}
}
