public bool doCreatHIDZoneQueueByReqStatus(string vh_id, string entry_sec_id, bool canPass, DateTime req_time) { bool isSeccess = true; E_HIDQueueStatus hidQueueStatus = E_HIDQueueStatus.Request; Nullable <System.DateTime> block_time = null; if (canPass) { block_time = req_time; hidQueueStatus = E_HIDQueueStatus.Blocking; } else { hidQueueStatus = E_HIDQueueStatus.Request; } AHIDZONEQUEUE hidObj = new AHIDZONEQUEUE { VEHICLE_ID = vh_id, ENTRY_SEC_ID = entry_sec_id, REQ_TIME = req_time, BLOCK_TIME = block_time, STATUS = hidQueueStatus }; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { HIDQueueDao.add(con, hidObj); } return(isSeccess); }
public AHIDZONEQUEUE getUsingHIDZoneQueueByVhID(string vh) { AHIDZONEQUEUE zone_queue = null; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { zone_queue = HIDQueueDao.getUsingHIDZoneQueue(con, vh); } return(zone_queue); }
public AHIDZONEQUEUE getHIDZoneQueue_FirstReqInPasue(string entry_sec_id) { AHIDZONEQUEUE zone_queue = null; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { zone_queue = HIDQueueDao.getHIDZoneQueue_FirstReqInPasue(con, entry_sec_id); } return(zone_queue); }
public void updateHIDZoneQueue_Pasue(string car_id, string entry_sec_id, bool isPasue) { using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, car_id, entry_sec_id); if (hidObj != null) { hidObj.IS_PASUE = isPasue; con.Entry(hidObj).Property(p => p.IS_PASUE).IsModified = true; HIDQueueDao.Update(con, hidObj); } } }
public bool updateHIDZoneQueue_ReleasTime(string car_id, string entry_sec_id) { bool isSeccess = true; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, car_id, entry_sec_id); if (hidObj != null) { hidObj.RELEASE_TIME = DateTime.Now; hidObj.STATUS = E_HIDQueueStatus.Release; con.Entry(hidObj).Property(p => p.RELEASE_TIME).IsModified = true; con.Entry(hidObj).Property(p => p.STATUS).IsModified = true; HIDQueueDao.Update(con, hidObj); } } return(isSeccess); }
public bool updateHIDZoneQueue_BlockingTime(string vh_id, string current_sec_id) { bool isSeccess = true; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, vh_id, current_sec_id); if (hidObj != null) { hidObj.BLOCK_TIME = DateTime.Now; hidObj.STATUS = E_HIDQueueStatus.Blocking; con.Entry(hidObj).Property(p => p.BLOCK_TIME).IsModified = true; con.Entry(hidObj).Property(p => p.STATUS).IsModified = true; HIDQueueDao.Update(con, hidObj); } } return(isSeccess); }