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 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 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 = "修改失败,请重试或联系管理员!" })); } }
/// <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 DelCustDevice(int id, int page) { try { using (DataWallContext db = new DataWallContext()) { SysCustDevice sysCustDevice = new SysCustDevice() { ID = id, DelState = 1, 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.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 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 DelCustDeviceAll(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]; SysCustDevice sysCustDevice = new SysCustDevice() { ID = id, DelState = 1, 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.IsEnable).IsModified = false; db.SaveChanges(); } int npage = 0; int Count = db.SysAdditionalDatas.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("删除客流设备", "Other", 3, GetUserName()); return(Json(new { code = "200", page = npage, msg = "删除成功!" })); } } catch (Exception ex) { LogHelper.ErrorLog("客流设备删除失败:" + ex.Message); return(Json(new { code = "201", msg = "删除失败,请重试或联/系管理员!" })); } }