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