/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, HikinoutlogEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public ActionResult DeviceWatch() { var cacheKey = "DeviceWatch";//缓存键的值 var cacheService = CacheFactory.Cache(); HikinoutlogEntity cacheValue = cacheService.GetCache <HikinoutlogEntity>(cacheKey); if (cacheValue == null) { cacheValue = hikinoutlogbll.GetFirsetData(); //写入缓存 Task.Run(() => { cacheService.WriteCache(cacheValue, cacheKey, DateTime.Now.AddSeconds(6)); }); } return(ToJsonResult(cacheValue)); }
/// <summary> /// 人员通道提交 /// </summary> /// <param name="insert"></param> /// <param name="update"></param> public void UserAisleSave(HikinoutlogEntity insert, HikinoutlogEntity update) { service.UserAisleSave(insert, update); }
/// <summary> /// 通过回调添加通过记录 /// </summary> /// <param name="carlog"></param> public void BackAddPassLog(CarinlogEntity carlog, string DeviceName, string imgUrl) { //开始事物 var res = DbFactory.Base().BeginTrans(); try { List <HikinoutlogEntity> HikList = new List <HikinoutlogEntity>(); HikinoutlogEntity inuser = null; Repository <UserEntity> Userdb = new Repository <UserEntity>(DbFactory.Base()); List <UserEntity> userlist = Userdb.FindList("select * from base_user").ToList(); Repository <DepartmentEntity> Deptdb = new Repository <DepartmentEntity>(DbFactory.Base()); List <DepartmentEntity> Deptlist = Deptdb.FindList("select * from base_department").ToList(); //如果是班车则关联进行人员进厂记录操作 if (carlog.Type == 0) { //将该车1小时内的打卡记录都变为已进场 Repository <CarrideEntity> inlogdb = new Repository <CarrideEntity>(DbFactory.Base()); string sql = string.Format( "select * from BIS_CARRIDE where CID ='{0}' and STATUS=0 and TO_CHAR(SCANCODETIME,'yyyy-MM-dd hh24:mm:ss')>='{1}'", carlog.CID, DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss")); List <CarrideEntity> Inlist = inlogdb.FindList(sql).ToList(); if (Inlist.Count > 0) { for (int i = 0; i < Inlist.Count; i++) { Inlist[i].Status = 1; Inlist[i].ModifyDate = carlog.CreateDate; Inlist[i].ModifyUserId = "System"; Inlist[i].Lid = carlog.ID; UserEntity user = userlist.Where(it => it.UserId == Inlist[i].CreateUserId).FirstOrDefault(); if (user != null) { var dept = Deptlist.Where(it => it.DepartmentId == user.DepartmentId).FirstOrDefault(); //增加海康设备出入表记录 HikinoutlogEntity Hik = new HikinoutlogEntity(); Hik.AreaName = carlog.Address; Hik.DeptId = user.DepartmentId; if (dept != null) { Hik.DeptName = dept.FullName; } else { Hik.DeptName = ""; } Hik.CreateDate = carlog.CreateDate; Hik.CreateUserId = "System"; Hik.CreateUserDeptCode = "00"; Hik.CreateUserOrgCode = "00"; Hik.DeviceName = DeviceName; Hik.DeviceType = 1; Hik.EventType = 2; Hik.ID = Guid.NewGuid().ToString(); Hik.InOut = carlog.Status; Hik.UserId = user.UserId; Hik.UserName = user.RealName; Hik.UserType = 0; Hik.ScreenShot = imgUrl; Hik.IsOut = 0; if (carlog.Status == 1) { string Hikinoutsql = "select * from BIS_HIKINOUTLOG where userid='" + Hik.UserId + "' and InOut=0 order by createdate desc"; Repository <HikinoutlogEntity> Hikinoutlog = new Repository <HikinoutlogEntity>(DbFactory.Base()); //如果是出门则要先找到该人员对应的入场记录进行更改 inuser = Hikinoutlog.FindList(Hikinoutsql).FirstOrDefault(); if (inuser != null) { inuser.IsOut = 1; inuser.InId = Hik.ID; inuser.OutTime = carlog.CreateDate; inuser.ModifyDate = carlog.CreateDate; inuser.ModifyUserId = "System"; } } if (inuser != null) { res.Update <HikinoutlogEntity>(inuser); } res.Insert <HikinoutlogEntity>(Hik); } } res.Update <CarrideEntity>(Inlist); } } else if (carlog.Type == 1) { UserEntity user = userlist.Where(it => it.UserId == carlog.DriverID).FirstOrDefault(); if (user != null) { var dept = Deptlist.Where(it => it.DepartmentId == user.DepartmentId).FirstOrDefault(); //增加海康设备出入表记录 HikinoutlogEntity Hik = new HikinoutlogEntity(); Hik.AreaName = carlog.Address; Hik.DeptId = user.DepartmentId; if (dept != null) { Hik.DeptName = dept.FullName; } else { Hik.DeptName = ""; } Hik.CreateDate = carlog.CreateDate; Hik.CreateUserId = "System"; Hik.CreateUserDeptCode = "00"; Hik.CreateUserOrgCode = "00"; Hik.DeviceName = DeviceName; Hik.DeviceType = 1; Hik.EventType = 2; Hik.ID = Guid.NewGuid().ToString(); Hik.InOut = carlog.Status; Hik.UserId = user.UserId; Hik.UserName = user.RealName; Hik.UserType = 0; Hik.ScreenShot = imgUrl; Hik.IsOut = 0; if (carlog.Status == 1) { string Hikinoutsql = "select * from BIS_HIKINOUTLOG where userid='" + Hik.UserId + "' and InOut=0 order by createdate desc"; Repository <HikinoutlogEntity> Hikinoutlog = new Repository <HikinoutlogEntity>(DbFactory.Base()); //如果是出门则要先找到该人员对应的入场记录进行更改 inuser = Hikinoutlog.FindList(Hikinoutsql).FirstOrDefault(); if (inuser != null) { inuser.IsOut = 1; Hik.IsOut = 1; inuser.InId = Hik.ID; inuser.OutTime = carlog.CreateDate; inuser.ModifyDate = carlog.CreateDate; inuser.ModifyUserId = "System"; } } if (inuser != null) { res.Update <HikinoutlogEntity>(inuser); } res.Insert <HikinoutlogEntity>(Hik); } } else if (carlog.Type == 3) { Repository <CarUserFileImgEntity> visitlog = new Repository <CarUserFileImgEntity>(DbFactory.Base()); string visitsql = "select * from bis_usercarfileimg where baseid='" + carlog.CID + "'"; List <CarUserFileImgEntity> visList = visitlog.FindList(visitsql).ToList(); if (visList.Count > 0) { foreach (var vist in visList) { //增加海康设备出入表记录 HikinoutlogEntity Hik = new HikinoutlogEntity(); Hik.AreaName = carlog.Address; Hik.DeptId = ""; Hik.DeptName = "拜访人员"; Hik.CreateDate = carlog.CreateDate; Hik.CreateUserId = "System"; Hik.CreateUserDeptCode = "00"; Hik.CreateUserOrgCode = "00"; Hik.DeviceName = DeviceName; Hik.DeviceType = 1; Hik.EventType = 2; Hik.ID = Guid.NewGuid().ToString(); Hik.InOut = carlog.Status; Hik.UserId = vist.ID; Hik.UserName = vist.Username; Hik.UserType = 2; Hik.ScreenShot = imgUrl; Hik.IsOut = 0; if (carlog.Status == 1) { string Hikinoutsql = "select * from BIS_HIKINOUTLOG where userid='" + Hik.UserId + "' and InOut=0 order by createdate desc"; Repository <HikinoutlogEntity> Hikinoutlog = new Repository <HikinoutlogEntity>(DbFactory.Base()); //如果是出门则要先找到该人员对应的入场记录进行更改 inuser = Hikinoutlog.FindList(Hikinoutsql).FirstOrDefault(); if (inuser != null) { inuser.IsOut = 1; Hik.IsOut = 1; inuser.InId = Hik.ID; inuser.OutTime = carlog.CreateDate; inuser.ModifyDate = carlog.CreateDate; inuser.ModifyUserId = "System"; } } if (inuser != null) { res.Update <HikinoutlogEntity>(inuser); } res.Insert <HikinoutlogEntity>(Hik); } } } else if (carlog.Type == 4) { //增加海康设备出入表记录 HikinoutlogEntity Hik = new HikinoutlogEntity(); Hik.AreaName = carlog.Address; Hik.DeptId = ""; Hik.DeptName = "物料人员"; Hik.CreateDate = carlog.CreateDate; Hik.CreateUserId = "System"; Hik.CreateUserDeptCode = "00"; Hik.CreateUserOrgCode = "00"; Hik.DeviceName = DeviceName; Hik.DeviceType = 1; Hik.EventType = 2; Hik.ID = Guid.NewGuid().ToString(); Hik.InOut = carlog.Status; Hik.UserId = carlog.ID; Hik.UserName = carlog.DriverName; Hik.UserType = 2; Hik.ScreenShot = imgUrl; Hik.IsOut = 0; if (carlog.Status == 1) { string Hikinoutsql = "select * from BIS_HIKINOUTLOG where userid='" + Hik.UserId + "' and InOut=0 order by createdate desc"; Repository <HikinoutlogEntity> Hikinoutlog = new Repository <HikinoutlogEntity>(DbFactory.Base()); //如果是出门则要先找到该人员对应的入场记录进行更改 inuser = Hikinoutlog.FindList(Hikinoutsql).FirstOrDefault(); if (inuser != null) { inuser.IsOut = 1; Hik.IsOut = 1; inuser.InId = Hik.ID; inuser.OutTime = carlog.CreateDate; inuser.ModifyDate = carlog.CreateDate; inuser.ModifyUserId = "System"; } } if (inuser != null) { res.Update <HikinoutlogEntity>(inuser); } res.Insert <HikinoutlogEntity>(Hik); } else if (carlog.Type == 5) { //危化品车辆 为司机添加进出场记录 //增加海康设备出入表记录 HikinoutlogEntity Hik = new HikinoutlogEntity(); Hik.AreaName = carlog.Address; Hik.DeptId = ""; Hik.DeptName = "危化品人员"; Hik.CreateDate = carlog.CreateDate; Hik.CreateUserId = "System"; Hik.CreateUserDeptCode = "00"; Hik.CreateUserOrgCode = "00"; Hik.DeviceName = DeviceName; Hik.DeviceType = 1; Hik.EventType = 2; Hik.ID = Guid.NewGuid().ToString(); Hik.InOut = carlog.Status; Hik.UserId = carlog.ID; Hik.UserName = carlog.DriverName; Hik.UserType = 2; Hik.ScreenShot = imgUrl; Hik.IsOut = 0; if (carlog.Status == 1) { string Hikinoutsql = "select * from BIS_HIKINOUTLOG where userid='" + Hik.UserId + "' and InOut=0 order by createdate desc"; Repository <HikinoutlogEntity> Hikinoutlog = new Repository <HikinoutlogEntity>(DbFactory.Base()); //如果是出门则要先找到该人员对应的入场记录进行更改 inuser = Hikinoutlog.FindList(Hikinoutsql).FirstOrDefault(); if (inuser != null) { inuser.IsOut = 1; inuser.InId = Hik.ID; inuser.OutTime = carlog.CreateDate; inuser.ModifyDate = carlog.CreateDate; inuser.ModifyUserId = "System"; } } if (inuser != null) { res.Update <HikinoutlogEntity>(inuser); } res.Insert <HikinoutlogEntity>(Hik); } //如果是出门状态 则把之前该车牌的进门状态改为已出门 if (carlog.Status == 1) { string sql = string.Format(@"update bis_carinlog set isleave=1 where carno='{0}' and status=0 and isleave=0", carlog.CarNo); //将该车1小时内的打卡记录都变为已进场 res.ExecuteBySql(sql); } res.Insert <CarinlogEntity>(carlog); res.Commit(); } catch (Exception ex) { res.Rollback(); throw ex; } }
public ActionResult SaveForm(string keyValue, HikinoutlogEntity entity) { hikinoutlogbll.SaveForm(keyValue, entity); return(Success("操作成功。")); }