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 = "删除失败，请重试或联/系管理员!" }));
}
}
