public object Any(SceneRequest request) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); SysSceneService sceneService = new SysSceneService(); DTOResponse response = (DTOResponse)null; if (request.ACTION == 100) { response = sceneService.GetSceneList(request); } else if (request.ACTION != 1) { if (request.ACTION == OPAction.UPDATE) { response = sceneService.SaveEntity(request); } else if (request.ACTION != 3) { if (request.ACTION == 101) { response = sceneService.OrderSenceMode(request); } else { dtoResponseLayUi.code = -1; dtoResponseLayUi.msg = "未定义的操作类型:" + request.ACTION.ToString(); return(dtoResponseLayUi); } } } return(this.ConvertTo(response)); }
public DTOResponse CreateTaskByMen(MoveRequest request) { DTOResponse dtoResponse = new DTOResponse(); IDbConnection dbCon = (IDbConnection)null; IDbTransaction dbTrans = (IDbTransaction)null; try { HelperDbOperation.BeginTransaction(ref dbCon, ref dbTrans); dtoResponse = this.CreateTaskByMen(request, dbCon, dbTrans); LogService.logger.Info((object)dtoResponse.ToString()); return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; LogService.logger.Error((object)ex); return(dtoResponse); } finally { HelperDbOperation.EndTransaction(dtoResponse.IsSuccess, ref dbCon, ref dbTrans); } }
public object Any(BasicRequest request) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); BasicService service = new BasicService(); DTOResponse response = new DTOResponse(); if (request.ACTION == OPAction.QUERY) { response = service.GetList(request); } else if (request.ACTION == OPAction.AFFIRM) { response = service.SaveBasicObject(request); } else if (request.ACTION == OPAction.OP_01) { response = service.GetSysparamsList(request); } else if (request.ACTION == OPAction.OP_02) { response = service.SaveSysparams(request); } else { dtoResponseLayUi.code = -1; dtoResponseLayUi.msg = "未定义的操作类型:" + request.ACTION.ToString(); return(dtoResponseLayUi); } return(this.ConvertTo(response)); }
public DTOResponse GetList(LocationStnRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <LocStationInfoEntity> expression = dbConn.From <LocStationInfoEntity>(); if (!string.IsNullOrEmpty(request.STATIONTYPE) && request.STATIONTYPE != "0") { expression.And(x => x.STATIONTYPE == request.STATIONTYPE); } if (!string.IsNullOrEmpty(request.TECHNO) && request.TECHNO != "000") { expression.And(x => x.TECHNO == request.TECHNO); } List <LocStationInfoEntity> list = dbConn.Select <LocStationInfoEntity>(expression).OrderBy <LocStationInfoEntity, string>((Func <LocStationInfoEntity, string>)(x => x.ID)).ToList <LocStationInfoEntity>(); dtoResponse.ResultObject = (object)list; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); } return(dtoResponse); }
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 SaveSysparams(BasicRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { SysParams entity = HelperSerializer.GetObjectFromJsonString <SysParams>(request.PostData); if (entity == null) { throw new Exception("传入的参数无法解析!"); } using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <SysParams> expression1 = dbConn.From <SysParams>(); expression1.Where(x => x.ID == entity.ID); expression1.UpdateFields.Add("PARAVALUE"); int count1 = dbConn.UpdateOnly <SysParams>(entity, expression1); dtoResponse.TotalCount = count1; dtoResponse.IsSuccess = count1 == 1 ? true : false; //dtoResponse.IsSuccess = dbConn.Update<SysParams>(entity); dtoResponse.MessageText = "操作完成:" + dtoResponse.IsSuccess; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse SaveEntity(SceneRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { SysSceneEntity uldScene = JsonSerializer.DeserializeFromString <SysSceneEntity>(request.PostData); if (request.PostData == null) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = "传入的数据为空!"; return(dtoResponse); } int num = 0; using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) num = dbConn.Update <SysSceneEntity>(uldScene, (Action <IDbCommand>)null); dtoResponse.IsSuccess = true; dtoResponse.MessageText = "保存数据操作成功!" + num.ToString(); return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; SysSceneService.logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse OrderSenceMode(SceneRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection()) { using (IDbTransaction trans = dbConnection.OpenTransaction()) { dtoResponse = this.OrderSenceMode(request, dbConnection, trans); if (dtoResponse.IsSuccess) { trans.Commit(); } else { trans.Rollback(); } 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); } }
public DTOResponse SetP01(LocationStnRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection()) { using (IDbTransaction trans = dbConnection.OpenTransaction()) { request.CONTROLMODE = 1; dtoResponse = this.SetP01(request, dbConnection, trans); if (dtoResponse.IsSuccess) { trans.Commit(); } else { trans.Rollback(); } return(dtoResponse); } } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse RestForArc(CheckRequest request) { DTOResponse dtoResponse = new DTOResponse(); IDbConnection dbCon = (IDbConnection)null; IDbTransaction dbTrans = (IDbTransaction)null; try { HelperDbOperation.BeginTransaction(ref dbCon, ref dbTrans); IDbConnection dbConn = dbCon; Expression <Func <SysCheckEntity, bool> > predicate = (Expression <Func <SysCheckEntity, bool> >)(x => x.ITEMSTATE == 1); foreach (SysCheckEntity uldCheck in dbConn.Select <SysCheckEntity>(predicate).OrderBy <SysCheckEntity, int>((Func <SysCheckEntity, int>)(x => x.ID)).ToList <SysCheckEntity>()) { if (!string.IsNullOrEmpty(uldCheck.ARCITEMVALUE)) { long num = (long)dbCon.ExecuteSql(uldCheck.ARCITEMVALUE); } } dtoResponse.IsSuccess = true; dtoResponse.MessageText = "执行成功!"; return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.ToString(); return(dtoResponse); } finally { HelperDbOperation.EndTransaction(dtoResponse.IsSuccess, ref dbCon, ref dbTrans); } }
public DTOResponse SetP01( LocationStnRequest request, IDbConnection db, IDbTransaction trans) { DTOResponse dtoResponse = new DTOResponse(); try { LocStationInfoEntity stationinfoEntity = db.Single <LocStationInfoEntity>(x => x.STATIONNO == request.STATIONNO); if (stationinfoEntity != null) { //如果是紧急出口EMEXIT==1,0==正常出口,不允许分配 if (stationinfoEntity.EMEXIT == 1) { throw new Exception("紧急出口,不允许分配!"); } stationinfoEntity.LOCATIONX = request.LOCATIONX; stationinfoEntity.PRIORITY = request.PRIORITY; stationinfoEntity.TASKCOUNT = request.TASKCOUNT; stationinfoEntity.P03 = request.P03; stationinfoEntity.P04 = request.P04; stationinfoEntity.OPBY = SysInfo.CurrentUserName; stationinfoEntity.OPDATE = Utils.GetTodayNow(); stationinfoEntity.OPMESSAGE = "设置站台参数!"; stationinfoEntity.CONTROLMODE = new Decimal?((Decimal)request.CONTROLMODE); SqlExpression <LocStationInfoEntity> sqlExpression = db.From <LocStationInfoEntity>(); sqlExpression.Where(x => x.ID == stationinfoEntity.ID); sqlExpression.UpdateFields.Add("LOCATIONX"); sqlExpression.UpdateFields.Add("PRIORITY"); sqlExpression.UpdateFields.Add("TASKCOUNT"); sqlExpression.UpdateFields.Add("P03"); sqlExpression.UpdateFields.Add("P04"); sqlExpression.UpdateFields.Add("OPBY"); sqlExpression.UpdateFields.Add("OPDATE"); sqlExpression.UpdateFields.Add("OPMESSAGE"); sqlExpression.UpdateFields.Add("CONTROLMODE"); db.UpdateOnly <LocStationInfoEntity>(stationinfoEntity, sqlExpression); } SysAlterInfoService.InsertAlterInfo("1", request.STATIONNO + "设置站台参数:" + request.ToJson(), "1"); dtoResponse.ResultObject = (object)new List <LocStationInfoEntity>() { stationinfoEntity }; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "操作成功!"; return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public static DTOResponse GetFileContentMethod(DTONode paramDTONode, string _SystemFiles) { DTOResponse objDTOResponse = new DTOResponse(); try { // Construct path string FullPath = Path.Combine(_SystemFiles, paramDTONode.data).Replace(@"\", @"/"); // Get file if (System.IO.File.Exists(FullPath)) { objDTOResponse.isSuccess = true; objDTOResponse.message = System.IO.File.ReadAllText(FullPath); } } catch (Exception ex) { objDTOResponse.isSuccess = false; objDTOResponse.message = ex.Message; return(objDTOResponse); } return(objDTOResponse); }
public DTOResponse GetList(MsgRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { string str1 = (string)null; string str2 = (string)null; DateTime dt1; DateTime dt2; if (!string.IsNullOrEmpty(request.datetimerange) && request.datetimerange.Length > 10) { string s1 = request.datetimerange.Substring(0, 10); string s2 = request.datetimerange.Substring(13, 10); DateTime.TryParse(s1, out dt1); DateTime.TryParse(s2, out dt2); str1 = dt1.ToString("yyyy-MM-dd HH:mm:ss"); str2 = dt2.ToString("yyyy-MM-dd HH:mm:ss"); } else { DateTime today = DateTime.Today; dt1 = today.AddDays(-7.0); today = DateTime.Today; dt2 = today.AddDays(1.0); str1 = dt1.ToString("yyyy-MM-dd HH:mm:ss"); str2 = dt2.ToString("yyyy-MM-dd HH:mm:ss"); } using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <SysAlterInfoEntity> expression = dbConn.From <SysAlterInfoEntity>(); expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.CREATEDATETIME >= dt1 && x.CREATEDATETIME <= dt2)); if (!string.IsNullOrEmpty(request.MSGTEXT)) { expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGTEXT.Contains(request.MSGTEXT))); } if (!string.IsNullOrEmpty(request.MSGTYPE) && request.MSGTYPE != "0") { expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGTYPE == request.MSGTYPE)); } if (!string.IsNullOrEmpty(request.MSGSTATE)) { expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGSTATE == request.MSGSTATE)); } long num = dbConn.Count <SysAlterInfoEntity>(expression); List <SysAlterInfoEntity> list = dbConn.Select <SysAlterInfoEntity>(expression).OrderByDescending <SysAlterInfoEntity, long>((Func <SysAlterInfoEntity, long>)(x => x.ID)).ToList <SysAlterInfoEntity>().Skip <SysAlterInfoEntity>((request.page - 1) * request.limit).Take <SysAlterInfoEntity>(request.limit).ToList <SysAlterInfoEntity>(); dtoResponse.TotalCount = num; dtoResponse.ResultObject = (object)list; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; MsgService.logger.Error((object)ex); } return(dtoResponse); }
public object Any(PalletRequest request) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); PalletService service = new PalletService(); DTOResponse response = new DTOResponse(); if (request.ACTION == OPAction.QUERY) { response = service.GetList(request); } else if (request.ACTION == OPAction.QUERYDETAIL1) { response = service.GetDetailList(request); } else if (request.ACTION == OPAction.STAT1) { response = service.GetPalletList(request); } else { dtoResponseLayUi.code = -1; dtoResponseLayUi.msg = "未定义的操作类型:" + request.ACTION.ToString(); return(dtoResponseLayUi); } return(this.ConvertTo(response)); }
/// <summary> /// 确认重置站台设置信息 /// </summary> public DTOResponse RestChanelStorestate(MoveRequest request) { DTOResponse dtoResponse = new DTOResponse(); IDbConnection dbCon = (IDbConnection)null; IDbTransaction dbTrans = (IDbTransaction)null; try { HelperDbOperation.BeginTransaction(ref dbCon, ref dbTrans); string msg = "重置站台设置信息"; string sqlUpdateStn = string.Format( @"UPDATE PROJ_STATIONINFO SET USECAPACITY=0,OPDATE='{1}',OPMESSAGE='{2}' WHERE CONTROLNO='{0}'", request.StationNo, Utils.GetDatetime(), msg); int count1 = dbCon.ExecuteSql(sqlUpdateStn); dtoResponse.IsSuccess = count1 > 0 ? true : false; dtoResponse.MessageText = "确认重置" + request.StationNo + "站台状态成功:" + count1 + "个工位"; LogService.logger.Info((object)dtoResponse.ToString()); return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; LogService.logger.Error((object)ex); return(dtoResponse); } finally { HelperDbOperation.EndTransaction(dtoResponse.IsSuccess, ref dbCon, ref dbTrans); } }
public override JobExecuteState ExecuteCustomImp(string strJobKey) { JobExecuteState jobExecuteState1 = new JobExecuteState(); DTOResponse dtoResponse1 = new DTOResponse(); DCSInfService dcsInfService = new DCSInfService(); string str1 = "AcceptWcsUpdateInfEquitmentStaus"; DTOResponse dtoResponse2 = SysParamsService.CheckPrarams(new SysParamsReuqest() { ParamsName = str1 }); bool isSuccess; if (dtoResponse2.IsSuccess) { SysParams resultObject = dtoResponse2.ResultObject as SysParams; if (resultObject == null) { jobExecuteState1.MessageText = "系统参数为空"; return(jobExecuteState1); } if (resultObject.PARAVALUE == "TRUE") { DTOResponse dtoResponse3 = dcsInfService.UpdateEquipmentStatus(); JobExecuteState jobExecuteState2 = jobExecuteState1; isSuccess = dtoResponse3.IsSuccess; string str2 = isSuccess.ToString(); jobExecuteState2.ReturnValue = str2; jobExecuteState1.MessageCode = dtoResponse3.MessageCode; jobExecuteState1.MessageText = dtoResponse3.MessageText; } } string str3 = "UpdateKanbanFormInfEquitmentStaus"; DTOResponse dtoResponse4 = SysParamsService.CheckPrarams(new SysParamsReuqest() { ParamsName = str3 }); if (dtoResponse4.IsSuccess) { SysParams resultObject = dtoResponse4.ResultObject as SysParams; if (resultObject == null) { jobExecuteState1.MessageText = "系统参数为空"; return(jobExecuteState1); } if (resultObject.PARAVALUE == "TRUE") { DTOResponse dtoResponse3 = dcsInfService.UpdateKanbanFormEquipmentStatus(); JobExecuteState jobExecuteState2 = jobExecuteState1; isSuccess = dtoResponse3.IsSuccess; string str2 = isSuccess.ToString(); jobExecuteState2.ReturnValue = str2; jobExecuteState1.MessageCode = dtoResponse3.MessageCode; jobExecuteState1.MessageText = dtoResponse3.MessageText; } } return(jobExecuteState1); }
public DTOResponse GetList(PalletRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <PalletEntity> expression = dbConn.From <PalletEntity>(); if (!string.IsNullOrEmpty(request.STOCKNO)) { expression.And(x => x.STOCKNO == request.STOCKNO); } if (!string.IsNullOrEmpty(request.GROUPNO)) { expression.And(x => x.GROUPNO == request.GROUPNO); } if (!string.IsNullOrEmpty(request.LOCATIONNO)) { expression.And(x => x.LOCATIONNO == request.LOCATIONNO); } if (!string.IsNullOrEmpty(request.PALLETNO)) { expression.And(x => x.PALLETNO == request.PALLETNO); } if (!string.IsNullOrEmpty(request.STATE)) { expression.And(x => x.STATE == int.Parse(request.STATE)); } if (!string.IsNullOrEmpty(request.PLANNO)) { expression.And(x => x.PLANNO == request.PLANNO); } long count = dbConn.Count <PalletEntity>(expression); List <PalletEntity> entityList = dbConn.Select <PalletEntity>(expression) .OrderBy(x => x.ID) .Skip((request.page - 1) * request.limit) .Take(request.limit) .ToList(); dtoResponse.TotalCount = count; dtoResponse.ResultObject = (object)entityList; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponseLayUI Any(Hello reqObj) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); DTOResponse response = new DTOResponse(); response.IsSuccess = true; response.MessageText = reqObj.Name + "调用成功"; return(this.ConvertTo(response)); }
public object any(Inventory reqObj) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); DTOResponse response = new DTOResponse(); response.IsSuccess = true; response.MessageText = reqObj.PH_ID + "调用成功"; return(this.ConvertTo(response)); }
public DTOResponse GetList <T>(DCSInfRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { string str1 = typeof(T).Name.Replace("Entity", ""); string str2 = "SELECT * FROM " + str1; string str3 = " WHERE 1=1"; if (!string.IsNullOrEmpty(request.EQUIPMENTID) && str1 != "INF_JOBFEEDBACK") { str3 += string.Format(" AND EQUIPMENTID='{0}'", (object)request.EQUIPMENTID); } if (!string.IsNullOrEmpty(request.STATUS)) { str3 += string.Format(" AND STATUS={0}", (object)request.STATUS); } if (!string.IsNullOrEmpty(request.JOBID)) { str3 += string.Format(" AND JOBID='{0}'", (object)request.JOBID); } if (!string.IsNullOrEmpty(request.CREATEDATE)) { DateTime dt1; if (DateTime.TryParse(request.CREATEDATE, out dt1)) { str3 += string.Format(" AND CREATEDATE LIKE '{0}%'", dt1.ToString("yyyy-MM-dd")); } else { dt1 = System.DateTime.Today; str3 += string.Format(" AND CREATEDATE LIKE '{0}%'", dt1.ToString("yyyy-MM-dd")); } } string str4 = " ORDER BY AUTOID DESC,CREATEDATE DESC"; long num = dbConn.Count <T>(); string sql = str2 + str3 + str4; DCSInfService.logger.Debug((object)sql); List <T> list = Enumerable.ToList <T>(Enumerable.Take <T>(Enumerable.Skip <T>(dbConn.Select <T>(sql), (request.page - 1) * request.limit), request.limit)); dtoResponse.TotalCount = num; dtoResponse.ResultObject = (object)list; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; DCSInfService.logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse GetList(PlanDetailRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <PlanDetailEntity> expression = dbConn.From <PlanDetailEntity>(); if (request.LINESTATE != null) { expression.And(x => x.LINESTATE == request.LINESTATE); } if (request.PLANTYPE != null) { expression.And(x => x.PLANTYPE == request.PLANTYPE); } if (!string.IsNullOrEmpty(request.PRODUCTTYPE) && request.PRODUCTTYPE != "0") { expression.And(x => x.PRODUCTTYPE == request.PRODUCTTYPE); } if (!string.IsNullOrEmpty(request.PRODUCTNO) && request.PRODUCTNO != "0") { expression.And(x => x.PRODUCTNO == request.PRODUCTNO); } if (!string.IsNullOrEmpty(request.PRODUCTNAME)) { expression.And(x => x.PRODUCTNAME.Contains(request.PRODUCTNAME)); } long count = dbConn.Count <PlanDetailEntity>(expression); List <PlanDetailEntity> entityList = dbConn.Select <PlanDetailEntity>(expression) .OrderByDescending(x => x.ID) .Skip <PlanDetailEntity>((request.page - 1) * request.limit) .Take <PlanDetailEntity>(request.limit) .ToList <PlanDetailEntity>(); dtoResponse.TotalCount = count; dtoResponse.ResultObject = (object)entityList; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
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 SetP01Emplty( LocationStnRequest request, IDbConnection db, IDbTransaction trans) { DTOResponse dtoResponse = new DTOResponse(); try { LocStationInfoEntity stationinfoEntity = db.Single <LocStationInfoEntity>(x => x.STATIONNO == request.STATIONNO); if (stationinfoEntity != null) { stationinfoEntity.WORNO = (string)null; stationinfoEntity.WORLINE = (string)null; stationinfoEntity.WORSTATE = (string)null; stationinfoEntity.OPBY = SysInfo.CurrentUserName; stationinfoEntity.OPDATE = Utils.GetTodayNow(); stationinfoEntity.OPMESSAGE = "清空工单设置"; stationinfoEntity.CONTROLMODE = new Decimal?(new Decimal()); stationinfoEntity.ISCLOSE = 0; SqlExpression <LocStationInfoEntity> sqlExpression = db.From <LocStationInfoEntity>(); sqlExpression.Where(x => x.ID == stationinfoEntity.ID); sqlExpression.UpdateFields.Add("WORNO"); sqlExpression.UpdateFields.Add("WORLINE"); sqlExpression.UpdateFields.Add("WORSTATE"); sqlExpression.UpdateFields.Add("OPBY"); sqlExpression.UpdateFields.Add("OPDATE"); sqlExpression.UpdateFields.Add("OPMESSAGE"); sqlExpression.UpdateFields.Add("CONTROLMODE"); sqlExpression.UpdateFields.Add("ISCLOSE"); db.UpdateOnly <LocStationInfoEntity>(stationinfoEntity, sqlExpression); } SysAlterInfoService.InsertAlterInfo("1", request.STATIONNO + "清空工单设置", "1"); dtoResponse.ResultObject = (object)new List <LocStationInfoEntity>() { stationinfoEntity }; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "操作成功!"; return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse ReturnContent([FromBody] DTONode paramDTONode) { DTOResponse objDTOResponse = new DTOResponse(); // Must be a Super User to proceed if (!UtilitySecurity.IsSuperUser(this.User.Identity.Name, GetConnectionString())) { objDTOResponse.isSuccess = false; objDTOResponse.message = "Must be a Super User to proceed"; return(objDTOResponse); } return(GetFileContentMethod(paramDTONode, _SystemFiles)); }
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); } }
public DTOResponse SetSTATIONSTATE(LocationStnRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { int num = 0; using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { using (IDbTransaction dbTransaction = dbConn.OpenTransaction()) { LocStationInfoEntity stationinfoEntity = OrmLiteReadExpressionsApi.Single <LocStationInfoEntity>(dbConn, (Expression <Func <LocStationInfoEntity, bool> >)(x => x.STATIONNO == request.STATIONNO)); if (stationinfoEntity == null) { throw new Exception("未查询到" + request.STATIONNO + "的信息"); } stationinfoEntity.STATIONSTATE = request.STATIONSTATE; stationinfoEntity.OPBY = SysInfo.CurrentUserName; stationinfoEntity.OPDATE = Utils.GetTodayNow(); stationinfoEntity.OPMESSAGE = "设置状态!"; SqlExpression <LocStationInfoEntity> sqlExpression = dbConn.From <LocStationInfoEntity>(); sqlExpression.Where(x => x.ID == stationinfoEntity.ID); sqlExpression.UpdateFields.Add("STATIONSTATE"); sqlExpression.UpdateFields.Add("OPBY"); sqlExpression.UpdateFields.Add("OPDATE"); sqlExpression.UpdateFields.Add("OPMESSAGE"); num = dbConn.UpdateOnly <LocStationInfoEntity>(stationinfoEntity, sqlExpression); dbTransaction.Commit(); } } dtoResponse.IsSuccess = true; dtoResponse.MessageText = "设置状态成功!" + num.ToString(); return(dtoResponse); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse Validator(DTOTransporteArchivo log) { DTOResponse response = new DTOResponse(); response.Archivo = new DTOArchivo() { Nombre = "file.xls", Id = Guid.NewGuid().ToString(), IdUsuario = "f9587aba-0990-11e7-93ae-92361f002671", FechaCreacion = DateTime.Now.ToString(Configuration.GetValueConf(Constants.DateFormat)), NumFilasImportadas = 534, Tamano = "4687", UrlArchivo = "" }; response.List = new List <DTOValidacionArchivo>() { new DTOValidacionArchivo() { Celda = "A 1", Descripcion = "Valor falso de prueba", FechaCreacion = DateTime.Now.ToString(Configuration.GetValueConf(Constants.DateFormat)), Valor = "Valor falso que no se envió con tíldes y comilla \"dobles\" y 'simples'" } }; return(response); }
public static void InsertOplog(DTOResponse dtoResponse, string keyValue = "") { try { SysOplogEntity oplog = new SysOplogEntity(); oplog.CREATEDATE = System.DateTime.Now; oplog.ENTERDATE = Utils.GetDatetime(); oplog.KEYVALUE = keyValue; oplog.OPMESSAGE = dtoResponse.ToString(); using (IDbConnection dbCon = HelperConnection.GetConnectionFactory().OpenDbConnection()) { dbCon.Insert <SysOplogEntity>(oplog); } } catch (Exception ex) { logger.Error(ex.Message, ex); } }
public DTOResponse UpdateKanbanFormEquipmentStatus() { DTOResponse dTOResponse = new DTOResponse(); try { List <INF_EQUIPMENTSTATUSEntity> list = HelperDbOperation.Select <INF_EQUIPMENTSTATUSEntity>(x => x.WMSLOCNUM == "none"); // from x in HelperDbOperation //select x.WMSLOCNUM == "none"; foreach (INF_EQUIPMENTSTATUSEntity item in list) { DateTime dateTime = DateTime.Parse(item.UPDATEDATE); DateTime now = DateTime.Now; TimeSpan timeSpan = Utils.DateDiff(dateTime, now); if (timeSpan.TotalSeconds < 60.0) { string eQUIPMENTID = item.EQUIPMENTID; string jOBID = item.JOBID; if (eQUIPMENTID.StartsWith("3")) { //dTOResponse = BPCommon.SetOutKanban_zhongxiang(eQUIPMENTID, item.JOBID); //dTOResponse = BPCommon.SetOutKanban_hengxiang(eQUIPMENTID, item.JOBID); } logger.Info(timeSpan.TotalSeconds.ToString() + "秒" + item.EQUIPMENTID + "更新信息:" + item.JOBID + "/" + item.BARCODE + "/" + item.TARGET + "/" + item.TUTYPE); if (eQUIPMENTID.StartsWith("2") && (item.TARGET == eQUIPMENTID || item.TARGET == "1") && int.Parse(item.JOBID) > 0) { //HelperRule.UpdateRkStation(eQUIPMENTID, item.JOBID); } } } dTOResponse.IsSuccess = true; dTOResponse.MessageText = "执行操作成功!"; return(dTOResponse); } catch (Exception ex) { dTOResponse.IsSuccess = false; dTOResponse.MessageText = ex.Message; logger.Error(ex); return(dTOResponse); } }
public DTOResponse GetTaskList(TaskRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { if (request.IsHistory == "1") { return(this.GetHistoryList(request)); } return(this.GetList(request)); } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; TaskService.logger.Error((object)ex); } return(dtoResponse); }