public static DTOResponse OrderStationInfo( IDbConnection dbCon, IDbTransaction dbTrans, OrderStnInfoRequest orderStnInfo) { int jobType = 4; DTOResponse dtoResponse = new DTOResponse(); if (CheckSysScenceOrderDcsState() == false) { dtoResponse.IsSuccess = true; dtoResponse.MessageText = "场景设置不下达!"; return(dtoResponse); } INF_JOBDOWNLOADEntity jobdownloadEntity = new INF_JOBDOWNLOADEntity(); jobdownloadEntity.ID = Utils.GetDateTimeGuid(); jobdownloadEntity.GROUPID = "0"; jobdownloadEntity.JOBID = orderStnInfo.JOBID.ToString(); jobdownloadEntity.EQUIPMENTID = orderStnInfo.STATIONNO; jobdownloadEntity.WAREHOUSEID = "none"; jobdownloadEntity.JOBTYPE = jobType; jobdownloadEntity.ORDERTYPE = 0; jobdownloadEntity.SOURCE = orderStnInfo.STATIONNO; jobdownloadEntity.TARGET = orderStnInfo.DESTINATION; jobdownloadEntity.BRANDID = "0"; jobdownloadEntity.PLANQTY = 0; jobdownloadEntity.PILETYPE = "0"; jobdownloadEntity.PRIORITY = orderStnInfo.PRIORITY; jobdownloadEntity.BARCODE = orderStnInfo.PALLETNO; jobdownloadEntity.TUTYPE = orderStnInfo.PALLETTYPE; jobdownloadEntity.ENTERDATE = Utils.GetTodayNow(); jobdownloadEntity.RESPONDDATE = (string)null; jobdownloadEntity.RESPONDCOUNT = 1; jobdownloadEntity.RESPONDMSG = ""; jobdownloadEntity.STATUS = 0; jobdownloadEntity.WEIGHT = 0; jobdownloadEntity.FULLCOUNT = 0; jobdownloadEntity.EXTENDINFO = ""; jobdownloadEntity.EXTATTR1 = ""; jobdownloadEntity.EXTATTR2 = ""; jobdownloadEntity.EXTATTR3 = ""; jobdownloadEntity.CREATEDATE = Utils.GetTodayNow(); jobdownloadEntity.CREATEUSERID = SysInfo.CurrentUserID; jobdownloadEntity.CREATEUSERNAME = SysInfo.CurrentUserName; long c1 = dbCon.Insert <INF_JOBDOWNLOADEntity>(jobdownloadEntity, false); dtoResponse.IsSuccess = c1 == 1 ? true : false; dtoResponse.MessageText = "下达接口表操作完成:" + dtoResponse.IsSuccess.ToString(); 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); } }
/// <summary> /// 下达任务信息到接口表 /// </summary> /// <param name="dbCon"></param> /// <param name="dbTrans"></param> /// <param name="taskEntity">任务对象</param> /// <param name="jobType"></param> /// <returns></returns> public static DTOResponse OrderTask( IDbConnection dbCon, IDbTransaction dbTrans, TaskEntity taskEntity, int jobType = 1) { DTOResponse dtoResponse = new DTOResponse(); if (CheckSysScenceOrderDcsState() == false) { dtoResponse.IsSuccess = true; dtoResponse.MessageText = "场景设置不下达!"; return(dtoResponse); } INF_JOBDOWNLOADEntity jobdownloadEntity = new INF_JOBDOWNLOADEntity(); jobdownloadEntity.ID = Utils.GetDateTimeGuid(); jobdownloadEntity.GROUPID = "0"; jobdownloadEntity.JOBID = taskEntity.TASKNO; jobdownloadEntity.EQUIPMENTID = ""; jobdownloadEntity.WAREHOUSEID = "none"; jobdownloadEntity.JOBTYPE = jobType; jobdownloadEntity.ORDERTYPE = 0; jobdownloadEntity.SOURCE = taskEntity.SOURCE02; jobdownloadEntity.TARGET = taskEntity.DESTINATION02; jobdownloadEntity.BRANDID = "0"; jobdownloadEntity.PLANQTY = new Decimal?(new Decimal()); jobdownloadEntity.PILETYPE = "0"; jobdownloadEntity.PRIORITY = taskEntity.PRIORITY; jobdownloadEntity.BARCODE = taskEntity.PALLETNO; jobdownloadEntity.TUTYPE = taskEntity.PALLETTYPE; jobdownloadEntity.ENTERDATE = Utils.GetTodayNow(); jobdownloadEntity.RESPONDDATE = (string)null; jobdownloadEntity.RESPONDCOUNT = 1; jobdownloadEntity.RESPONDMSG = ""; jobdownloadEntity.STATUS = 0; jobdownloadEntity.WEIGHT = new Decimal?(new Decimal()); jobdownloadEntity.FULLCOUNT = 0; jobdownloadEntity.EXTENDINFO = ""; jobdownloadEntity.EXTATTR1 = taskEntity.TASKDESC; jobdownloadEntity.EXTATTR2 = taskEntity.CUSTOMCOL01; jobdownloadEntity.EXTATTR3 = taskEntity.TASKNO.ToString(); jobdownloadEntity.CREATEDATE = Utils.GetTodayNow(); jobdownloadEntity.CREATEUSERID = SysInfo.CurrentUserID; jobdownloadEntity.CREATEUSERNAME = SysInfo.CurrentUserName; TaskStatEntity taskstatEntity = new TaskStatEntity(); taskstatEntity.TASKNO = taskEntity.TASKNO; taskstatEntity.STATITEMNAME = "taskcreat"; taskstatEntity.STATITEMDESC = "任务创建"; taskstatEntity.STATITEMVALUE = "0"; taskstatEntity.CREATETIME = Utils.GetDatetime(); taskstatEntity.P01 = taskEntity.CREATEDATE; taskstatEntity.P02 = Utils.GetDatetime(); long c1 = dbCon.Insert <INF_JOBDOWNLOADEntity>(jobdownloadEntity, false); long c2 = dbCon.Insert <TaskStatEntity>(taskstatEntity, false); dtoResponse.IsSuccess = c1 == 1 && c2 == 1 ? true : false; dtoResponse.MessageText = "下达接口表操作完成:" + dtoResponse.IsSuccess.ToString(); return(dtoResponse); }