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