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 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 UpdateEquipmentStatus()
{
DTOResponse dtoResponse = new DTOResponse();
IDbConnection dbCon = (IDbConnection)null;
IDbTransaction dbTrans = (IDbTransaction)null;
try
{
object obj = HelperDbOperation.ExecuteScalar("SELECT ID FROM PROJ_ULDSCENE WHERE SCENESTATE=1");
HelperDbOperation.BeginTransaction(ref dbCon, ref dbTrans);
List <INF_EQUIPMENTSTATUSEntity> equipmentstatusEntityList = dbCon.Select <INF_EQUIPMENTSTATUSEntity>((Expression <Func <INF_EQUIPMENTSTATUSEntity, bool> >)(x => x.WMSLOCNUM == "none" && x.STATUS == 0));
foreach (INF_EQUIPMENTSTATUSEntity equipmentstatusEntity in equipmentstatusEntityList)
{
if (equipmentstatusEntity.EQUIPMENTSTATUS == "1")
{
string str1 = "0";
string str2 = "故障代码：" + equipmentstatusEntity.EQUIPMENTSTATUS;
string todayNow = Utils.GetTodayNow();
string sql1 = string.Format("UPDATE PROJ_LOCATION_DETAIL SET LOCATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLID='{0}'", (object)equipmentstatusEntity.EQUIPMENTID, (object)str1, (object)str2, (object)todayNow);
int num1 = dbCon.ExecuteSql(sql1);
string sql2 = (string)null;
int num2 = 0;
string sql3 = (string)null;
int num3 = 0;
int num4 = 0;
if (Convert.ToInt32(obj) < 100)
{
sql2 = string.Format("UPDATE PROJ_STATIONINFO SET STATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLNO IN (SELECT GROUPNO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}')", (object)equipmentstatusEntity.EQUIPMENTID, (object)"1", (object)str2, (object)todayNow);
num2 = dbCon.ExecuteSql(sql2);
sql3 = string.Format("UPDATE PROJ_STATIONINFO SET STATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLNO IN (SELECT AREANO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}')", (object)equipmentstatusEntity.EQUIPMENTID, (object)"1", (object)str2, (object)todayNow);
num3 = dbCon.ExecuteSql(sql3);
if (SysParamsService.CheckPrarams("StationErrorUpdateRelate").ToLower() == "true")
{
string sql4 = string.Format("UPDATE PROJ_STATIONINFO SET ISCLOSE={1} WHERE STATIONNO IN ( SELECT RELATENO FROM PROJ_STATIONRELATE WHERE STATIONNO IN ( SELECT AREANO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}'))", (object)equipmentstatusEntity.EQUIPMENTID, (object)0);
num4 = dbCon.ExecuteSql(sql4);
}
}
DCSInfService.logger.Info((object)sql2);
DCSInfService.logger.Info((object)sql3);
DCSInfService.logger.Info((object)(equipmentstatusEntity.EQUIPMENTID + ":" + num1.ToString() + "/" + num2.ToString() + "/" + num3.ToString() + " " + str2));
SysAlterInfoService.InsertAlterInfo("2", equipmentstatusEntity.EQUIPMENTID + "故障恢复！" + str2, "1");
}
else
{
string str1 = "error";
string str2 = "故障代码：" + equipmentstatusEntity.EQUIPMENTSTATUS;
string todayNow = Utils.GetTodayNow();
string sql1 = string.Format("UPDATE PROJ_LOCATION_DETAIL SET LOCATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLID='{0}'", (object)equipmentstatusEntity.EQUIPMENTID, (object)str1, (object)str2, (object)todayNow);
int num1 = dbCon.ExecuteSql(sql1);
string sql2 = (string)null;
int num2 = 0;
string sql3 = (string)null;
int num3 = 0;
int num4 = 0;
if (Convert.ToInt32(obj) < 100)
{
sql2 = string.Format("UPDATE PROJ_STATIONINFO SET STATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLNO IN (SELECT GROUPNO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}')", (object)equipmentstatusEntity.EQUIPMENTID, (object)"0", (object)str2, (object)todayNow);
num2 = dbCon.ExecuteSql(sql2);
sql3 = string.Format("UPDATE PROJ_STATIONINFO SET STATIONSTATE='{1}',OPMESSAGE='{2}',OPDATE='{3}',OPBY='dcs' WHERE CONTROLNO IN (SELECT AREANO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}')", (object)equipmentstatusEntity.EQUIPMENTID, (object)"0", (object)str2, (object)todayNow);
num3 = dbCon.ExecuteSql(sql3);
if (SysParamsService.CheckPrarams("StationErrorUpdateRelate").ToLower() == "true")
{
string sql4 = string.Format("UPDATE PROJ_STATIONINFO SET ISCLOSE={1} WHERE STATIONNO IN ( SELECT RELATENO FROM PROJ_STATIONRELATE WHERE STATIONNO IN ( SELECT AREANO FROM PROJ_LOCATION_DETAIL WHERE CONTROLID='{0}'))", (object)equipmentstatusEntity.EQUIPMENTID, (object)9);
num4 = dbCon.ExecuteSql(sql4);
}
}
DCSInfService.logger.Info((object)sql2);
DCSInfService.logger.Info((object)sql3);
DCSInfService.logger.Info((object)(equipmentstatusEntity.EQUIPMENTID + ":" + num1.ToString() + "/" + num2.ToString() + "/" + num3.ToString() + " " + str2));
SysAlterInfoService.InsertAlterInfo("2", equipmentstatusEntity.EQUIPMENTID + "发生故障！" + str2, "1");
}
string sql = string.Format("UPDATE INF_EQUIPMENTSTATUS SET STATUS=1,MODIFYDATE='{1}' WHERE ID='{0}'", (object)equipmentstatusEntity.ID, (object)Utils.GetDatetime());
dbCon.ExecuteSql(sql);
}
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "执行设备状态更新:" + equipmentstatusEntityList.Count.ToString();
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
DCSInfService.logger.Error((object)ex);
return(dtoResponse);
}
finally
{
HelperDbOperation.EndTransaction(dtoResponse.IsSuccess, ref dbCon, ref dbTrans);
}
}