public static void CheckAlarmMaxHourInDB(int CardID, int InMineHour, int AllowInMineHour, DateTime Time) { try { using (SqlConnection conn = new SqlConnection(Global.DBConnStr)) { conn.Open(); using (SqlCommand comm = new SqlCommand("select Alarm_ID,Time from AlarmMaxHourTable where CardID = " + CardID + " order by Alarm_ID DESC", conn)) { using (SqlDataReader reader = comm.ExecuteReader()) { if (reader.Read()) { try { if (reader.IsDBNull(1)) { DB_Service.ExecuteSQL("insert into AlarmMaxHourTable (CardID,InMineHour,AllowInMineHour,Time) values (" + CardID + "," + InMineHour + "," + AllowInMineHour + ",'" + Time + "')"); } else { DateTime lastTime = reader.GetDateTime(1); TimeSpan ts = Time - lastTime; if (ts.TotalMinutes > 30.0) { DB_Service.ExecuteSQL("insert into AlarmMaxHourTable (CardID,InMineHour,AllowInMineHour,Time) values (" + CardID + "," + InMineHour + "," + AllowInMineHour + ",'" + Time + "')"); } } } catch (Exception ex) { throw ex; } finally { reader.Close(); } } else { DB_Service.ExecuteSQL("insert into AlarmMaxHourTable (CardID,InMineHour,AllowInMineHour,Time) values (" + CardID + "," + InMineHour + "," + AllowInMineHour + ",'" + Time + "')"); } } } } } catch (Exception ex) { throw ex; } }
public static void CheckAlarmMaxPersonInDB(int InMinePersonNum, int AllowMaxPersonNum, DateTime Time) { try { using (SqlConnection conn = new SqlConnection(Global.DBConnStr)) { conn.Open(); using (SqlCommand comm = new SqlCommand("select top 1 Time from AlarmMaxPersonTable order by Alarm_ID DESC", conn)) { using (SqlDataReader reader = comm.ExecuteReader()) { if (reader.Read()) { try { if (reader.IsDBNull(0)) { DB_Service.ExecuteSQL("insert into AlarmMaxPersonTable (RealPersonNum,AllowPersonNum,Time) values (" + InMinePersonNum + "," + AllowMaxPersonNum + ",'" + Time + "')"); } else { DateTime lastTime = reader.GetDateTime(0); TimeSpan ts = Time - lastTime; if (ts.TotalMinutes > 5.0) { DB_Service.ExecuteSQL("insert into AlarmMaxPersonTable (RealPersonNum,AllowPersonNum,Time) values (" + InMinePersonNum + "," + AllowMaxPersonNum + ",'" + Time + "')"); } } } catch (Exception ex) { throw ex; } finally { reader.Close(); } } else { DB_Service.ExecuteSQL("insert into AlarmMaxPersonTable (RealPersonNum,AllowPersonNum,Time) values (" + InMinePersonNum + "," + AllowMaxPersonNum + ",'" + Time + "')"); } } } } } catch (Exception ex) { throw ex; } }