public DTOResponse BatchChangeUseState(LocationRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <LocDetailEntity> sqlExpression = dbConn.From <LocDetailEntity>(); sqlExpression.Where(x => request.ListLocatioNo.Contains(x.LOCATIONNO)); sqlExpression.UpdateFields.Add("USESTATE"); sqlExpression.UpdateFields.Add("OPBY"); sqlExpression.UpdateFields.Add("OPDATE"); sqlExpression.UpdateFields.Add("OPMESSAGE"); LocDetailEntity locDetailEntity = new LocDetailEntity(); locDetailEntity.USESTATE = request.USESTATE; locDetailEntity.OPBY = SysInfo.GetCurrentUserInfo(); locDetailEntity.OPDATE = Utils.GetTodayNow(); locDetailEntity.OPMESSAGE = "修改使用状态!"; int count = dbConn.UpdateOnly <LocDetailEntity>(locDetailEntity, sqlExpression); dtoResponse.IsSuccess = count > 0 ? true : false; dtoResponse.MessageText = "操作完成,修改记录" + count.ToString() + "条 " + dtoResponse.IsSuccess.ToString(); HelperOplog.InsertOplog("位置使用状态更改:" + request.USESTATE + "/" + request.ListLocatioNo.ToJson()); HelperOplog.InsertOplog(dtoResponse); return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse ChangeUseState(LocationRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { LocDetailEntity locationDetailEntity = dbConn.Select <LocDetailEntity>((Expression <Func <LocDetailEntity, bool> >)(x => x.LOCATIONNO == request.LOCATIONNO)).FirstNonDefault <LocDetailEntity>(); if (locationDetailEntity == null) { throw new Exception(request.LOCATIONNO + "位置不存在!"); } locationDetailEntity.USESTATE = request.USESTATE; locationDetailEntity.OPBY = SysInfo.GetCurrentUserInfo(); locationDetailEntity.OPDATE = Utils.GetTodayNow(); locationDetailEntity.OPMESSAGE = "修改使用状态!"; int count = dbConn.UpdateOnly <LocDetailEntity>( locationDetailEntity, new string[4] { "USESTATE", "OPBY", "OPDATE", "OPMESSAGE" }, (Expression <Func <LocDetailEntity, bool> >)(x => x.LOCATIONNO == request.LOCATIONNO), (Action <IDbCommand>)null); dtoResponse.IsSuccess = count > 0 ? true : false; dtoResponse.MessageText = "操作成功!" + count.ToString(); return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse OrderSenceMode( SceneRequest request, IDbConnection db, IDbTransaction trans) { DTOResponse dtoResponse = new DTOResponse(); try { SysSceneEntity uldScene1 = OrmLiteReadExpressionsApi.Single <SysSceneEntity>(db, (Expression <Func <SysSceneEntity, bool> >)(x => x.ID == request.ID || x.SCENENO == request.SCENENO)); if (uldScene1 == null) { throw new Exception("获取场景为空!"); } if (uldScene1.SCENENO != request.SCENENO) { throw new Exception("传入的参数与后台不一致!"); } if (uldScene1.USESTATE != 1) { throw new Exception("当前模式" + uldScene1.SCENENO + "管理员未启用!请联系管理员!"); } INF_JOBDOWNLOADEntity jobdownloadEntity1 = new INF_JOBDOWNLOADEntity(); jobdownloadEntity1.ID = Utils.GetDateTimeGuid(); jobdownloadEntity1.GROUPID = "0"; //jobdownloadEntity1.JOBID = uldScene1.P01; //jobdownloadEntity1.EQUIPMENTID = uldScene1.P02; jobdownloadEntity1.WAREHOUSEID = "none"; jobdownloadEntity1.JOBTYPE = 4; jobdownloadEntity1.ORDERTYPE = 0; jobdownloadEntity1.SOURCE = "0"; //jobdownloadEntity1.TARGET = uldScene1.P02; jobdownloadEntity1.BRANDID = "0"; jobdownloadEntity1.PLANQTY = new Decimal?(new Decimal()); jobdownloadEntity1.PILETYPE = "0"; jobdownloadEntity1.PRIORITY = 1; jobdownloadEntity1.BARCODE = "0"; int id = uldScene1.ID; string str1 = id.ToString(); jobdownloadEntity1.TUTYPE = str1; jobdownloadEntity1.ENTERDATE = Utils.GetTodayNow(); jobdownloadEntity1.RESPONDDATE = (string)null; jobdownloadEntity1.RESPONDCOUNT = 1; jobdownloadEntity1.RESPONDMSG = ""; jobdownloadEntity1.STATUS = 0; jobdownloadEntity1.WEIGHT = new Decimal?(new Decimal()); jobdownloadEntity1.FULLCOUNT = 0; jobdownloadEntity1.EXTENDINFO = ""; jobdownloadEntity1.EXTATTR1 = ""; jobdownloadEntity1.EXTATTR2 = ""; jobdownloadEntity1.EXTATTR3 = ""; jobdownloadEntity1.CREATEDATE = Utils.GetTodayNow(); jobdownloadEntity1.CREATEUSERID = SysInfo.CurrentUserID; jobdownloadEntity1.CREATEUSERNAME = SysInfo.CurrentUserName; string emergencyexit = uldScene1.EMERGENCYEXIT; if (!string.IsNullOrEmpty(emergencyexit)) { string str2 = emergencyexit; char[] chArray = new char[1] { ',' }; foreach (string str3 in str2.Split(chArray)) { string item = str3; LocDetailEntity locationDetailEntity = OrmLiteReadExpressionsApi.Single <LocDetailEntity>(db, (Expression <Func <LocDetailEntity, bool> >)(x => x.GROUPNO == item)); if (locationDetailEntity != null) { locationDetailEntity.EMEXIT = "1"; db.UpdateOnly <LocDetailEntity>(locationDetailEntity, (Expression <Func <LocDetailEntity, object> >)(x => new { EMEXIT = x.EMEXIT }), (Expression <Func <LocDetailEntity, bool> >)null, (Action <IDbCommand>)null); } } } uldScene1.SCENESTATE = "1"; uldScene1.OPBY = SysInfo.CurrentUserName; uldScene1.OPDATE = Utils.GetTodayNow(); SysSceneEntity uldScene2 = uldScene1; id = uldScene1.ID; string str4 = "下达" + id.ToString() + "操作成功!"; uldScene2.OPMESSAGE = str4; // uldScene1.P10 = jobdownloadEntity1.ID; string sql = string.Format("UPDATE PROJ_ULDSCENE SET SCENESTATE='0',OPBY='{1}',OPDATE='{2}',OPMESSAGE='{3}' WHERE ID<>{0}", (object)uldScene1.ID, (object)SysInfo.CurrentUserName, (object)Utils.GetTodayNow(), (object)"场景切换"); long num1 = 0; //num1 = (long)db.SaveAll<INF_JOBDOWNLOADEntity>((IEnumerable<INF_JOBDOWNLOADEntity>)new List<INF_JOBDOWNLOADEntity>() //{ // jobdownloadEntity1 //}); int num2 = db.Update <SysSceneEntity>(uldScene1, (Action <IDbCommand>)null); int num3 = db.ExecuteSql(sql); dtoResponse.IsSuccess = true; dtoResponse.MessageText = "下达操作成功!" + num1.ToString() + "/" + num2.ToString() + "/" + num3.ToString(); SysSceneService.logger.Info((object)dtoResponse.ToString()); return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; SysSceneService.logger.Error((object)ex); return(dtoResponse); } }