public DTOResponse InsertTaskStat(INF_JOBFEEDBACKEntity jobFeedBack)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
TaskStatEntity projTaskstatEntity = new TaskStatEntity();
projTaskstatEntity.TASKNO = jobFeedBack.JOBID;
projTaskstatEntity.STATITEMNAME = jobFeedBack.FEEDBACKSTATUS;
projTaskstatEntity.STATITEMDESC = jobFeedBack.FEEDBACKSTATUS;
projTaskstatEntity.STATITEMVALUE = "0";
projTaskstatEntity.CREATETIME = Utils.GetDatetime();
projTaskstatEntity.P01 = jobFeedBack.ENTERDATE;
projTaskstatEntity.P02 = Utils.GetDatetime();
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
dbConn.Save <TaskStatEntity>(projTaskstatEntity, false);
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "保存 PROJ_TASKSTAT成功！";
DCSInfService.logger.Info((object)dtoResponse);
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
DCSInfService.logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetDataFromDCS(List <long> jobidList)
{
DTOResponse dTOResponse = new DTOResponse();
try
{
string arg = jobidList.ToInString();
List <object> list = null;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory("DCS").OpenDbConnection())
{
string sql = $"select wjid,rid,sc,tg,paid,st,ts,et,sct from sm_wcs_jb_ts_od where wjid in ({arg}) order by wjid,et";
list = dbConn.Select <object>(sql);
}
List <TaskStatEntity> list2 = new List <TaskStatEntity>();
foreach (dynamic item in list)
{
TaskStatEntity pROJ_TASKSTATEntity = new TaskStatEntity();
pROJ_TASKSTATEntity.TASKNO = item.wjid;
pROJ_TASKSTATEntity.STATITEMNAME = item.paid;
pROJ_TASKSTATEntity.STATITEMDESC = item.rid;
DateTime d = Convert.ToDateTime(item.et);
DateTime d2 = Convert.ToDateTime(item.sct);
pROJ_TASKSTATEntity.STATITEMVALUE = (d2 - d).Seconds.ToString();
pROJ_TASKSTATEntity.P01 = item.et;
pROJ_TASKSTATEntity.P02 = item.sct;
pROJ_TASKSTATEntity.CREATETIME = Utils.GetDatetime();
list2.Add(pROJ_TASKSTATEntity);
}
long num = 0L;
using (IDbConnection dbConn2 = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
num = dbConn2.SaveAll(list2);
}
dTOResponse.IsSuccess = true;
dTOResponse.MessageText = "获取tsorder成功！" + num.ToString();
logger.Info(dTOResponse);
return(dTOResponse);
}
catch (Exception ex)
{
dTOResponse.IsSuccess = false;
dTOResponse.MessageText = ex.Message;
logger.Error(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);
}
