public bool updateSysExecQity_CmdFinish(string mcs_cmd_id, E_CMD_STATUS commandStatus, CompleteStatus cmpStatus, out ASYSEXCUTEQUALITY quality)
{
bool isSuccess = true;
//DBConnection_EF con = DBConnection_EF.GetContext();
//using (DBConnection_EF con = new DBConnection_EF())
quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
//quality.CMD_FINISH_STATUS = E_CMD_STATUS.NormalEnd;
quality.CMD_FINISH_STATUS = commandStatus;
quality.CompleteStatus = cmpStatus;
quality.CMD_FINISH_TIME = DateTime.Now;
quality.CMD_TOTAL_EXCUTION_TIME = getWithNowDifferenceSeconds(quality.CMD_START_TIME);
//sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
sysExeQualityDAO.delete(scApp.getRedisCacheManager(), quality.CMD_ID_MCS);
using (DBConnection_EF con = DBConnection_EF.GetUContext())
{
ASYSEXCUTEQUALITY qualityTemp = sysExeQualityDAO.getByID(con, mcs_cmd_id);
if (qualityTemp == null)
{
sysExeQualityDAO.add(con, quality);
}
}
}
else
{
}
return(isSuccess);
}
private bool addSysExcuteQuality(ASYSEXCUTEQUALITY quality)
{
bool isSuccess = true;
//using (DBConnection_EF con = new DBConnection_EF())
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
// sysExeQualityDAO.add(con, quality);
//}
sysExeQualityDAO.add(scApp.getRedisCacheManager(), quality);
return(isSuccess);
}
public bool updateSysExecQity_PassSecInfo(
string mcs_cmd_id, string vh_id, string start_sec_id, string[] routeSec_Vh2TO, string[] routeSec_From2To)
{
bool isSuccess = true;
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
int sec_cnt2source = 0;
int sec_dis2source = 0;
int sec_cnt2destn = 0;
int sec_dis2destn = 0;
double ohtc_cmd_proc_time = 0;
List <ASECTION> routeSec_Vh2TO_Obj = null;
if (routeSec_Vh2TO != null && routeSec_Vh2TO.Length > 0)
{
routeSec_Vh2TO_Obj = scApp.MapBLL.loadSectionBySecIDs(routeSec_Vh2TO.ToList());
}
//List<ASECTION> routeSec_From2To_Obj = scApp.MapBLL.loadSectionBySecIDs(routeSec_From2To.ToList());
List <ASECTION> routeSec_From2To_Obj = null;
if (routeSec_From2To != null && routeSec_From2To.Length > 0)
{
routeSec_From2To_Obj = scApp.MapBLL.loadSectionBySecIDs(routeSec_From2To.ToList());
}
if (routeSec_Vh2TO_Obj != null)
{
sec_cnt2source = routeSec_Vh2TO_Obj.Count;
sec_dis2source = (int)routeSec_Vh2TO_Obj.Select(sec => sec.SEC_DIS).Sum();
}
if (routeSec_From2To_Obj != null)
{
sec_cnt2destn = routeSec_From2To_Obj.Count;
sec_dis2destn = (int)routeSec_From2To_Obj.Select(sec => sec.SEC_DIS).Sum();
}
ohtc_cmd_proc_time = getWithNowDifferenceSeconds(quality.CMD_INSERT_TIME);
quality.VH_ID = vh_id;
quality.VH_START_SEC_ID = start_sec_id;
quality.SEC_CNT_TO_SOURCE = sec_cnt2source;
quality.SEC_DIS_TO_SOURCE = sec_dis2source;
quality.SEC_CNT_TO_DESTN = sec_cnt2destn;
quality.SEC_DIS_TO_DESTN = sec_dis2destn;
quality.CMD_START_TIME = DateTime.Now;
quality.CMDQUEUE_TIME = ohtc_cmd_proc_time;
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
//}
return(isSuccess);
}
public bool updateSysExecQity_PauseTime(string mcs_cmd_id, double pauseCostlyTime)
{
bool isSuccess = true;
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
quality.TOTALPAUSE_TIME += pauseCostlyTime;
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
//}
return(isSuccess);
}
public bool updateSysExecQity_OCSTime2DestnOnTheWay(string mcs_cmd_id, double OCSCostlyTime)
{
bool isSuccess = true;
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
quality.TOTAL_OCS_TIME_TO_DESTN += OCSCostlyTime;
quality.TOTAL_OCS_COUNT_TO_DESTN++;
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
//}
return(isSuccess);
}
public bool updateSysExecQity_BlockTime2SurceOnTheWay(string mcs_cmd_id, double blockCostlyTime)
{
bool isSuccess = true;
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
quality.TOTAL_BLOCK_TIME_TO_SOURCE += blockCostlyTime;
quality.TOTAL_BLOCK_COUNT_TO_SOURCE++;
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
//}
return(isSuccess);
}
public bool creatSysExcuteQuality(string cmd_id, string cstID, string source, string destination)
{
bool isSuccess = true;
int total_act_vh = scApp.VehicleBLL.getActVhCount();
int total_idle_vh = scApp.VehicleBLL.getIdleVhCount();
int total_parking_vh = scApp.VehicleBLL.getParkingVhCount();
int total_cycling_vh = scApp.VehicleBLL.getCyclingVhCount();
ASYSEXCUTEQUALITY sysExcuteQuality =
buildSysExcuteQualityObj(cmd_id, cstID,
source, destination,
total_act_vh, total_idle_vh, total_parking_vh, total_cycling_vh);
addSysExcuteQuality(sysExcuteQuality);
return(isSuccess);
}
public bool updateSysExecQity_ArrivalSourcePort(string mcs_cmd_id)
{
bool isSuccess = true;
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
quality.MOVE_TO_SOURCE_TIME = getWithNowDifferenceSeconds(quality.CMD_START_TIME);
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
else
{
isSuccess = false;
}
return(isSuccess);
}
public void doCommandFinish(string mcs_cmd_id, CompleteStatus completeStatus, E_CMD_STATUS ohtc_cmd_status)
{
try
{
ASYSEXCUTEQUALITY quality = null;
updateSysExecQity_CmdFinish(mcs_cmd_id, ohtc_cmd_status, completeStatus, out quality);
if (quality != null)
{
SCUtility.TrimAllParameter(quality);
LogManager.GetLogger("SysExcuteQuality").Info(quality.ToString());
}
}
catch (Exception ex)
{
logger.Error(ex, $"Exception ,mcs cmd id:{SCUtility.Trim(mcs_cmd_id, true)} ,complete status:{completeStatus}, cmd status:{ohtc_cmd_status}");
}
}
private ASYSEXCUTEQUALITY buildSysExcuteQualityObj(string cmd_id, string cstID,
string source, string destn,
int total_act_vh, int total_idle_vh, int totla_paking_vh, int total_cycling_vh)
{
ASYSEXCUTEQUALITY quality = new ASYSEXCUTEQUALITY()
{
CMD_ID_MCS = cmd_id,
CMD_INSERT_TIME = DateTime.Now,
CST_ID = cstID,
SOURCE_ADR = source,
DESTINATION_ADR = destn,
TOTAL_ACT_VH_COUNT = total_act_vh,
TOTAL_IDLE_VH_COUNT = total_idle_vh,
PARKING_VH_COUNT = totla_paking_vh,
CYCLERUN_VH_COUNT = total_cycling_vh
};
return(quality);
}
public bool updateSysExecQity_ArrivalDestnPort(string mcs_cmd_id)
{
bool isSuccess = true;
//DBConnection_EF con = DBConnection_EF.GetContext();
//using (DBConnection_EF con = DBConnection_EF.GetUContext())
//{
ASYSEXCUTEQUALITY quality = sysExeQualityDAO.getByID(scApp.getRedisCacheManager(), mcs_cmd_id);
if (quality != null)
{
quality.MOVE_TO_DESTN_TIME = getWithNowDifferenceSeconds(quality.CMD_START_TIME) - quality.MOVE_TO_SOURCE_TIME;
sysExeQualityDAO.update(scApp.getRedisCacheManager(), quality);
}
else
{
isSuccess = false;
}
//}
return(isSuccess);
}
public bool creatSysExcuteQuality(ACMD_MCS cmd_mcs)
{
bool isSuccess = true;
string cmd_id = cmd_mcs.CMD_ID;
string cst_id = cmd_mcs.CARRIER_ID;
string source = cmd_mcs.HOSTSOURCE;
string destn = cmd_mcs.HOSTDESTINATION;
int total_act_vh = scApp.VehicleBLL.getActVhCount();
int total_idle_vh = scApp.VehicleBLL.getIdleVhCount();
int total_parking_vh = scApp.VehicleBLL.getParkingVhCount();
int total_cycling_vh = scApp.VehicleBLL.getCyclingVhCount();
ASYSEXCUTEQUALITY sysExcuteQuality =
buildSysExcuteQualityObj(cmd_id, cst_id,
source, destn,
total_act_vh, total_idle_vh, total_parking_vh, total_cycling_vh);
addSysExcuteQuality(sysExcuteQuality);
return(isSuccess);
}
public void update(RedisCacheManager redisCache, ASYSEXCUTEQUALITY quality)
{
add(redisCache, quality);
}
public void add(RedisCacheManager redisCache, ASYSEXCUTEQUALITY quality)
{
//redisCache.Obj2ByteArraySetAsync(quality.CMD_ID_MCS, quality, timeSpan_1Hour);
redisCache.Obj2ByteArraySetAsync(quality.CMD_ID_MCS, quality);
}
public void update(DBConnection_EF con, ASYSEXCUTEQUALITY quality)
{
con.SaveChanges();
}
public void add(DBConnection_EF con, ASYSEXCUTEQUALITY quality)
{
con.ASYSEXCUTEQUALITY.Add(quality);
con.SaveChanges();
}
