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