public static int InsertRackEffect(string str_sql, DateTime dt_inserttime) { if (DBUrl.SERVERMODE) { WorkQueue <string> .getInstance_rackeffect().WorkSequential = true; WorkQueue <string> .getInstance_rackeffect().EnqueueItem(str_sql); return(1); } if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL")) { WorkQueue <string> .getInstance_rackeffect().WorkSequential = true; WorkQueue <string> .getInstance_rackeffect().EnqueueItem(str_sql); return(1); } DBConn dBConn = null; DbCommand dbCommand = null; try { dBConn = DBConnPool.getThermalConnection(); if (dBConn != null && dBConn.con != null) { dbCommand = dBConn.con.CreateCommand(); } dbCommand.CommandText = str_sql.Replace("'", "#"); dbCommand.ExecuteNonQuery(); dbCommand.Dispose(); dBConn.Close(); return(1); } catch (Exception ex) { try { dbCommand.Dispose(); } catch { } try { dBConn.Close(); } catch { } DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Generate RackEffect Error : " + ex.Message + "\n" + ex.StackTrace); } return(-1); }
public static void DeleteOverallRemainLastSomeHours(int hours, DateTime currentTime) { DateTime dateTime = currentTime.AddHours((double)(-(double)hours)); Convert.ToDateTime(dateTime.ToString("yyyy-MM-dd HH:mm:ss")); string text = "delete from rack_effect where insert_time < #" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "#"; if (DBUrl.SERVERMODE || DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL")) { WorkQueue <string> .getInstance_rackeffect().WorkSequential = true; WorkQueue <string> .getInstance_rackeffect().EnqueueItem(text); return; } DBConn dBConn = null; DbCommand dbCommand = new OleDbCommand(); try { dBConn = DBConnPool.getThermalConnection(); if (dBConn != null && dBConn.con != null) { dbCommand = dBConn.con.CreateCommand(); dbCommand.CommandType = CommandType.Text; dbCommand.CommandText = text; dbCommand.ExecuteNonQuery(); } dbCommand.Dispose(); dBConn.Close(); } catch (Exception ex) { try { dbCommand.Dispose(); } catch { } try { dBConn.Close(); } catch { } DebugCenter.GetInstance().appendToFile("Delete Rack effect: " + ex.Message + "\n" + ex.StackTrace); } }
private static int setExpiry4thermal(string strV, int iType) { DBConn dBConn = null; DbCommand dbCommand = null; try { dBConn = DBConnPool.getThermalConnection(); if (dBConn != null && dBConn.con != null) { dbCommand = dBConn.con.CreateCommand(); switch (iType) { case 0: try { dbCommand.CommandText = "create table sys_info (sysid varchar(255) )"; dbCommand.ExecuteNonQuery(); dbCommand.CommandText = "insert into sys_info (sysid ) values ('" + strV + "' )"; dbCommand.ExecuteNonQuery(); int result = 1; return(result); } catch { int result = -1; return(result); } break; case 1: break; case 2: goto IL_A8; case 3: goto IL_CE; default: goto IL_F4; } try { dbCommand.CommandText = "insert into sys_info (sysid ) values ('" + strV + "' )"; dbCommand.ExecuteNonQuery(); int result = 1; return(result); } catch { int result = -1; return(result); } try { IL_A8: dbCommand.CommandText = "update sys_info set sysid = '" + strV + "'"; dbCommand.ExecuteNonQuery(); int result = 1; return(result); } catch { int result = -1; return(result); } try { IL_CE: dbCommand.CommandText = "update sys_info set sysid = '" + strV + "'"; dbCommand.ExecuteNonQuery(); int result = 1; return(result); } catch { int result = -1; return(result); } } IL_F4 :; } catch { int result = -1; return(result); } finally { try { dbCommand.Dispose(); } catch { } if (dBConn != null) { try { dBConn.close(); } catch { } } } return(-1); }
private static string getExpiryfromthermal() { DBConn dBConn = null; DbCommand dbCommand = null; try { dBConn = DBConnPool.getThermalConnection(); if (dBConn != null && dBConn.con != null) { string result; if (DBUtil.DetermineTableExist(dBConn.con, "sys_info")) { dbCommand = dBConn.con.CreateCommand(); dbCommand.CommandText = "select * from sys_info "; object obj = dbCommand.ExecuteScalar(); if (obj != null && obj != DBNull.Value) { string text = Convert.ToString(obj); if (text.Length == 0) { result = "VALUENULL"; return(result); } try { text = AESEncryptionUtility.Decrypt(text, "evaluate_date-time"); result = text; return(result); } catch { result = "FATAL"; return(result); } } result = "NOVALUE"; return(result); } result = "NOTABLE"; return(result); } } catch (Exception) { string result = ""; return(result); } finally { try { dbCommand.Dispose(); } catch { } if (dBConn != null) { try { dBConn.close(); } catch { } } } return(""); }