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);
}
