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