public static int GetRowCount(int i_range_type, DateTime dt_start, DateTime dt_end)
{
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
long arg_0F_0 = dt_start.Ticks;
long arg_17_0 = dt_end.Ticks;
try
{
dBConn = DBConnPool.getLogConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
switch (i_range_type)
{
case 0:
dbCommand.CommandText = "select count(id) from logrecords";
break;
case 1:
dbCommand.CommandText = string.Concat(new string[]
{
"select count(id) from logrecords where ticks >= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# and ticks <= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# "
});
break;
case 2:
dbCommand.CommandText = string.Concat(new string[]
{
"select count(id) from logrecords where ticks <= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# or ticks >= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# "
});
break;
}
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
object obj = dbCommand.ExecuteScalar();
dbCommand.Dispose();
int result;
if (obj == null || obj is DBNull || Convert.ToInt32(obj) < 1)
{
result = -1;
return(result);
}
result = Convert.ToInt32(obj);
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public static DataTable GetSearchResult(int i_range_type, DateTime dt_start, DateTime dt_end, int i_pagenum, int i_pagesize, int i_total)
{
DateTime now = DateTime.Now;
DataTable dataTable = new DataTable();
DataColumn dataColumn = new DataColumn("insert_time");
dataColumn.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn);
DataColumn dataColumn2 = new DataColumn("eventid");
dataColumn2.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn2);
DataColumn dataColumn3 = new DataColumn("parametervalue");
dataColumn3.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn3);
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
long arg_95_0 = dt_start.Ticks;
long arg_9D_0 = dt_end.Ticks;
string text = "";
switch (i_range_type)
{
case 0:
text = " 2=2 ";
break;
case 1:
text = string.Concat(new string[]
{
" 2=2 and ticks >= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# and ticks <= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# "
});
break;
case 2:
text = string.Concat(new string[]
{
" 2=2 and (ticks <= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# or ticks >= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# )"
});
break;
}
try
{
dBConn = DBConnPool.getLogConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
if (i_pagenum == 0 && i_pagesize == 0)
{
dbCommand.CommandText = "select ticks,eventid,logpara from logrecords where " + text + " order by id desc";
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader = dbCommand.ExecuteReader();
while (dbDataReader.Read())
{
string value = Convert.ToDateTime(dbDataReader.GetValue(0)).ToString("yyyy-MM-dd HH:mm:ss");
string @string = dbDataReader.GetString(1);
string string2 = dbDataReader.GetString(2);
DataRow dataRow = dataTable.NewRow();
dataRow["insert_time"] = value;
dataRow["eventid"] = @string;
dataRow["parametervalue"] = string2;
dataTable.Rows.Add(dataRow);
}
dbDataReader.Close();
}
else
{
if (LogInfo.m_type == i_range_type && DateTime.Compare(LogInfo.mdt_start, dt_start) == 0 && DateTime.Compare(LogInfo.mdt_end, dt_end) == 0)
{
long num;
long num2;
if (i_pagenum * i_pagesize > i_total)
{
num = Convert.ToInt64(LogInfo.ht_cache[(i_pagenum - 1) * i_pagesize + 1]);
num2 = Convert.ToInt64(LogInfo.ht_cache[i_total]);
}
else
{
num = Convert.ToInt64(LogInfo.ht_cache[(i_pagenum - 1) * i_pagesize + 1]);
num2 = Convert.ToInt64(LogInfo.ht_cache[i_pagenum * i_pagesize]);
}
dbCommand.CommandText = string.Concat(new object[]
{
"select * from logrecords where id >= ",
num2,
" and id <= ",
num,
" order by id desc"
});
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader2 = dbCommand.ExecuteReader();
while (dbDataReader2.Read())
{
string value2 = Convert.ToDateTime(dbDataReader2.GetValue(1)).ToString("yyyy-MM-dd HH:mm:ss");
string string3 = dbDataReader2.GetString(2);
string string4 = dbDataReader2.GetString(3);
DataRow dataRow2 = dataTable.NewRow();
dataRow2["insert_time"] = value2;
dataRow2["eventid"] = string3;
dataRow2["parametervalue"] = string4;
dataTable.Rows.Add(dataRow2);
}
dbDataReader2.Close();
}
else
{
LogInfo.m_type = i_range_type;
LogInfo.mdt_start = dt_start;
LogInfo.mdt_end = dt_end;
LogInfo.ht_cache = new Hashtable();
dbCommand.CommandText = "select id from logrecords where " + text + " order by id desc";
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader3 = dbCommand.ExecuteReader();
int num3 = 1;
while (dbDataReader3.Read())
{
LogInfo.ht_cache.Add(num3, dbDataReader3.GetValue(0));
num3++;
}
dbDataReader3.Close();
new DataTable();
long num5;
long num6;
if (i_pagenum * i_pagesize > i_total)
{
int num4 = i_pagenum * i_pagesize - i_total;
string.Concat(new object[]
{
"select top ",
i_pagesize - num4,
" id from (select top ",
i_pagesize - num4,
" id from logrecords where ",
text,
" order by id asc) order by id desc"
});
num5 = Convert.ToInt64(LogInfo.ht_cache[(i_pagenum - 1) * i_pagesize + 1]);
num6 = Convert.ToInt64(LogInfo.ht_cache[i_total]);
}
else
{
num5 = Convert.ToInt64(LogInfo.ht_cache[(i_pagenum - 1) * i_pagesize + 1]);
num6 = Convert.ToInt64(LogInfo.ht_cache[i_pagenum * i_pagesize]);
if (i_pagenum * i_pagesize > i_total / 2)
{
string.Concat(new object[]
{
"select top ",
i_pagesize,
" id from (select top ",
i_total - i_pagenum * i_pagesize + i_pagesize,
" id from logrecords where ",
text,
" order by id asc) order by id desc"
});
}
else
{
string.Concat(new object[]
{
"select id from (select top ",
i_pagesize,
" id from (select top ",
i_pagenum * i_pagesize,
" id from logrecords where ",
text,
" order by id desc) order by id asc) order by id desc"
});
}
}
dbCommand.CommandText = string.Concat(new object[]
{
"select * from logrecords where id >= ",
num6,
" and id <= ",
num5,
" order by id desc"
});
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader4 = dbCommand.ExecuteReader();
while (dbDataReader4.Read())
{
string value3 = Convert.ToDateTime(dbDataReader4.GetValue(1)).ToString("yyyy-MM-dd HH:mm:ss");
string string5 = dbDataReader4.GetString(2);
string string6 = dbDataReader4.GetString(3);
DataRow dataRow3 = dataTable.NewRow();
dataRow3["insert_time"] = value3;
dataRow3["eventid"] = string5;
dataRow3["parametervalue"] = string6;
dataTable.Rows.Add(dataRow3);
}
dbDataReader4.Close();
}
}
dbCommand.Dispose();
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
Console.WriteLine("million sencods is : " + (DateTime.Now - now).TotalMilliseconds.ToString());
return(dataTable);
}
public static DataTable GetPrePage(int i_key, int i_range_type, DateTime dt_start, DateTime dt_end, int i_pagenum, int i_pagesize, int i_total)
{
DateTime now = DateTime.Now;
DataTable dataTable = new DataTable();
DataColumn dataColumn = new DataColumn("insert_time");
dataColumn.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn);
DataColumn dataColumn2 = new DataColumn("eventid");
dataColumn2.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn2);
DataColumn dataColumn3 = new DataColumn("parametervalue");
dataColumn3.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dataColumn3);
DataColumn dataColumn4 = new DataColumn("id");
dataColumn4.DataType = Type.GetType("System.Int32");
dataTable.Columns.Add(dataColumn4);
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
long arg_BF_0 = dt_start.Ticks;
long arg_C7_0 = dt_end.Ticks;
string text = "";
switch (i_range_type)
{
case 0:
text = string.Concat(new object[]
{
" 2=2 id > ",
i_key,
" and ticks <= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# "
});
break;
case 1:
text = string.Concat(new object[]
{
" 2=2 id > ",
i_key,
" and ticks >= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# and ticks <= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# "
});
break;
case 2:
text = string.Concat(new object[]
{
" 2=2 id > ",
i_key,
" and (ticks <= #",
dt_start.ToString("yyyy-MM-dd HH:mm:ss"),
"# or ticks >= #",
dt_end.ToString("yyyy-MM-dd HH:mm:ss"),
"# )"
});
break;
}
try
{
dBConn = DBConnPool.getLogConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
long num = 0L;
long num2 = 0L;
DataTable dataTable2 = new DataTable();
string commandText;
if (i_pagenum * i_pagesize > i_total)
{
int num3 = i_pagenum * i_pagesize - i_total;
commandText = string.Concat(new object[]
{
"select top ",
i_pagesize - num3,
" id from (select top ",
i_pagesize - num3,
" id from logrecords where ",
text,
" order by id asc) order by id desc"
});
}
else
{
commandText = string.Concat(new object[]
{
"select id from ( select top ",
i_pagesize,
" id from logrecords where ",
text,
" order by id asc ) order by id desc"
});
}
dbCommand.CommandText = commandText;
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader = dbCommand.ExecuteReader();
if (dbDataReader.HasRows)
{
dataTable2 = DBConn.ConvertOleDbReaderToDataTable(dbDataReader);
}
dbDataReader.Close();
DataRow[] array = dataTable2.Select("", "id DESC");
if (array.Length > 0)
{
num2 = Convert.ToInt64(array[0]["id"]);
num = Convert.ToInt64(array[array.Length - 1]["id"]);
}
dbCommand.CommandText = string.Concat(new object[]
{
"select * from logrecords where id >= ",
num,
" and id <= ",
num2,
" order by id desc"
});
if (DBUrl.SERVERMODE)
{
dbCommand.CommandText = dbCommand.CommandText.Replace("#", "'");
}
DbDataReader dbDataReader2 = dbCommand.ExecuteReader();
while (dbDataReader2.Read())
{
string value = Convert.ToDateTime(dbDataReader2.GetValue(1)).ToString("yyyy-MM-dd HH:mm:ss");
string @string = dbDataReader2.GetString(2);
string string2 = dbDataReader2.GetString(3);
int num4 = Convert.ToInt32(dbDataReader2.GetValue(0));
DataRow dataRow = dataTable.NewRow();
dataRow["insert_time"] = value;
dataRow["eventid"] = @string;
dataRow["parametervalue"] = string2;
dataRow["id"] = num4;
dataTable.Rows.Add(dataRow);
}
dbDataReader2.Close();
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
Console.WriteLine("million sencods is : " + (DateTime.Now - now).TotalMilliseconds.ToString());
return(dataTable);
}
public int Update()
{
if (this.id < 1)
{
return(-1);
}
if (this.device_id < 1)
{
return(-1);
}
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
if (DBUrl.SERVERMODE)
{
string commandText = "update device_sensor_info set sensor_nm=?sensor_nm,max_humidity=?max_humidity,min_humidity=?min_humidity,max_temperature=?max_temperature,min_temperature=?min_temperature,max_press=?max_press,min_press=?min_press,sensor_type=?sensor_type,location_type=?location_type where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("?sensor_nm", this.sensor_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_humidity", this.max_humidity, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_humidity", this.min_humidity, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_temperature", this.max_temperature, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_temperature", this.min_temperature, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_press", this.max_press, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_press", this.min_press, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?sensor_type", this.sensor_type, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?location_type", this.sensor_locationtype, dbCommand));
}
else
{
string commandText = "update device_sensor_info set sensor_nm=?,max_humidity=?,min_humidity=?,max_temperature=?,min_temperature=?,max_press=?,min_press=?,sensor_type=?,location_type=? where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("@sensor_nm", this.sensor_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_humidity", this.max_humidity, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_humidity", this.min_humidity, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_temperature", this.max_temperature, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_temperature", this.min_temperature, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_press", this.max_press, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_press", this.min_press, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@sensor_type", this.sensor_type, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@location_type", this.sensor_locationtype, dbCommand));
}
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
DBCacheStatus.Device = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Device"
});
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
private static void preparedatadb()
{
if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL"))
{
DbCommand dbCommand = null;
DbDataReader dbDataReader = null;
DBConn dBConn = new DBConn();
try
{
dBConn.con = new MySqlConnection(string.Concat(new object[]
{
"Database=",
DBUrl.DB_CURRENT_NAME,
";Data Source=",
DBUrl.CURRENT_HOST_PATH,
";Port=",
DBUrl.CURRENT_PORT,
";User Id=",
DBUrl.CURRENT_USER_NAME,
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
dBConn.con.Open();
dBConn.setInUse();
dbCommand = dBConn.con.CreateCommand();
dbCommand.CommandText = "SELECT table_name FROM INFORMATION_SCHEMA.TABLES where (table_name like '%_auto_info%' or table_name like '%_data_daily%' or table_name like '%_data_hourly%' or table_name like 'rackthermal_hourly20%' or table_name like 'rackthermal_daily20%') and table_schema = '" + DBUrl.DB_CURRENT_NAME + "' ";
dbDataReader = dbCommand.ExecuteReader();
while (dbDataReader.Read())
{
string text = Convert.ToString(dbDataReader.GetValue(0));
if (!DBTools.ht_tablename.ContainsKey(text))
{
DBTools.ht_tablename.Add(text, text);
}
}
dbDataReader.Close();
dbCommand.Dispose();
dBConn.Close();
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get DynaDB Connection Error : " + ex.Message + "\n" + ex.StackTrace);
try
{
dbDataReader.Close();
}
catch (Exception)
{
}
try
{
dbCommand.Dispose();
}
catch (Exception)
{
}
try
{
dBConn.Close();
}
catch (Exception)
{
}
}
}
}
public DBWorkThread(int i_type)
{
if (DBUrl.SERVERMODE)
{
string cONNECT_STRING = DBUrl.CONNECT_STRING;
string[] array = cONNECT_STRING.Split(new string[]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
this.con = new MySqlConnection(string.Concat(new string[]
{
"Database=eco",
DBUrl.SERVERID,
";Data Source=",
array[0],
";Port=",
array[1],
";User Id=",
array[2],
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=50;Default Command Timeout=0;charset=utf8;"
}));
this.con.Open();
}
else
{
this.DBTYPE = i_type;
switch (this.DBTYPE)
{
case 0:
break;
case 1:
try
{
this.con = new MySqlConnection(string.Concat(new object[]
{
"Database=",
DBUrl.DB_CURRENT_NAME,
";Data Source=",
DBUrl.CURRENT_HOST_PATH,
";Port=",
DBUrl.CURRENT_PORT,
";User Id=",
DBUrl.CURRENT_USER_NAME,
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
this.con.Open();
DebugCenter.GetInstance().clearStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
goto IL_25B;
}
catch (Exception e)
{
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
DebugCenter.GetInstance().appendToFile("Could not create MySQL connection : \r\n" + CommonAPI.ReportException(0, e, false, " "));
goto IL_25B;
}
break;
default:
goto IL_25B;
}
try
{
int num = 0;
while (TaskStatus.GetDBStatus() == -1 && num < 600)
{
Thread.Sleep(50);
DebugCenter.GetInstance().appendToFile(this.ToString() + "Waiting DBConnection : " + num);
num++;
}
DBConn dynaConnection = DBConnPool.getDynaConnection();
if (dynaConnection != null)
{
this.con = dynaConnection.con;
}
else
{
this.con = null;
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
}
IL_25B:
this.debug = DebugCenter.GetInstance();
}
public int update()
{
int num = -1;
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
try
{
dBConn = DBConnPool.getConnection();
string commandText = "update sys_para set para_value = '" + this.maintenance + "' where para_name = 'LIMITTYPE' and para_type = 'int' ";
string commandText2 = "update sys_para set para_value = '" + this.days + "' where para_name = 'DAYLIMIT' and para_type = 'int' ";
string commandText3 = "update sys_para set para_value = '" + this.recordNum + "' where para_name = 'RECORDSLIMIT' and para_type = 'int' ";
string commandText4 = "update sys_para set para_value = '" + this.pageSize + "' where para_name = 'PAGESIZE' and para_type = 'int' ";
string commandText5 = "update sys_para set para_value = '" + this.saveRange + "' where para_name = 'SAVERANGE' and para_type = 'int' ";
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandText = commandText;
num = dbCommand.ExecuteNonQuery();
if (num < 1)
{
int result = num;
return(result);
}
dbCommand.CommandText = commandText2;
num = dbCommand.ExecuteNonQuery();
if (num < 1)
{
int result = num;
return(result);
}
dbCommand.CommandText = commandText3;
num = dbCommand.ExecuteNonQuery();
if (num < 1)
{
int result = num;
return(result);
}
dbCommand.CommandText = commandText4;
num = dbCommand.ExecuteNonQuery();
if (num < 1)
{
int result = num;
return(result);
}
dbCommand.CommandText = commandText5;
num = dbCommand.ExecuteNonQuery();
dbCommand.Dispose();
DBCacheStatus.SystemParameter = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_SystemParameter"
});
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(num);
}
public static DBConn getLogConnection()
{
string str = "";
DBConn result;
if (DBUrl.SERVERMODE)
{
try
{
DBConn dBConn = new DBConn();
string cONNECT_STRING = DBUrl.CONNECT_STRING;
string[] array = cONNECT_STRING.Split(new string[]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
dBConn.con = new MySqlConnection(string.Concat(new string[]
{
"Database=eco",
DBUrl.SERVERID,
";Data Source=",
array[0],
";Port=",
array[1],
";User Id=",
array[2],
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
dBConn.con.Open();
dBConn.setInUse();
result = dBConn;
return(result);
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get LogDB Connection Error : " + ex.Message + "\n" + ex.StackTrace);
result = null;
return(result);
}
}
bool flag = false;
DBConn dBConn2 = new DBConn();
try
{
try
{
dBConn2.con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "logdb.mdb;Jet OLEDB:Database Password=ecoSensorlog");
dBConn2.con.Open();
flag = true;
}
catch (Exception ex2)
{
str = ex2.Message + "\r\n" + ex2.StackTrace;
int i = 0;
while (i < 4)
{
Thread.Sleep(10);
i++;
try
{
dBConn2.con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "logdb.mdb;Jet OLEDB:Database Password=ecoSensorlog");
dBConn2.con.Open();
flag = true;
break;
}
catch (Exception ex3)
{
str = ex3.Message + "\r\n" + ex3.StackTrace;
}
}
}
if (flag)
{
dBConn2.setInUse();
result = dBConn2;
}
else
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get LogDB Connection Error : " + str);
result = null;
}
}
catch (Exception ex4)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get LogDB Connection Error : " + ex4.Message + "\n" + ex4.StackTrace);
result = null;
}
return(result);
}
public static DBConn getDynaConnection(DateTime dt_inserttime, bool b_create)
{
DBConn result;
lock (DBConnPool._lockdatadb)
{
string str = "";
if (DBUrl.SERVERMODE)
{
try
{
DBConn dBConn = new DBConn();
string cONNECT_STRING = DBUrl.CONNECT_STRING;
string[] array = cONNECT_STRING.Split(new string[]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
dBConn.con = new MySqlConnection(string.Concat(new string[]
{
"Database=eco",
DBUrl.SERVERID,
";Data Source=",
array[0],
";Port=",
array[1],
";User Id=",
array[2],
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
dBConn.con.Open();
dBConn.setInUse();
DebugCenter.GetInstance().clearStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
result = dBConn;
return(result);
}
catch (Exception e)
{
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
DebugCenter.GetInstance().appendToFile("Could not create MySQL connection : \r\n" + CommonAPI.ReportException(0, e, false, " "));
result = null;
return(result);
}
}
if (DBUrl.DB_CURRENT_TYPE.ToUpperInvariant().Equals("MYSQL"))
{
try
{
DBConn dBConn2 = new DBConn();
dBConn2.con = new MySqlConnection(string.Concat(new object[]
{
"Database=",
DBUrl.DB_CURRENT_NAME,
";Data Source=",
DBUrl.CURRENT_HOST_PATH,
";Port=",
DBUrl.CURRENT_PORT,
";User Id=",
DBUrl.CURRENT_USER_NAME,
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
dBConn2.con.Open();
dBConn2.setInUse();
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_Success, false);
result = dBConn2;
return(result);
}
catch (Exception e2)
{
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
DebugCenter.GetInstance().appendToFile("Could not create MySQL connection : \r\n" + CommonAPI.ReportException(0, e2, false, " "));
result = null;
return(result);
}
}
try
{
string text = AppDomain.CurrentDomain.BaseDirectory + "datadb";
if (text[text.Length - 1] != Path.DirectorySeparatorChar)
{
text += Path.DirectorySeparatorChar;
}
if (!Directory.Exists(text))
{
Directory.CreateDirectory(text);
}
DateTime.Now.ToString("yyyyMMdd");
dt_inserttime.ToString("yyyyMMdd");
string text2 = text + "datadb_" + dt_inserttime.ToString("yyyyMMdd") + ".mdb";
if (!File.Exists(text2) && b_create)
{
string sourceFileName = text + "datadb.org";
File.Copy(sourceFileName, text2, true);
}
bool flag2 = false;
try
{
DBConn dBConn3 = new DBConn();
try
{
dBConn3.con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + text2 + ";Jet OLEDB:Database Password=root");
dBConn3.con.Open();
flag2 = true;
}
catch (Exception ex)
{
str = ex.Message + "\r\n" + ex.StackTrace;
int i = 0;
while (i < 4)
{
Thread.Sleep(10);
i++;
try
{
dBConn3.con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + text2 + ";Jet OLEDB:Database Password=root");
dBConn3.con.Open();
flag2 = true;
break;
}
catch (Exception ex2)
{
str = ex2.Message + "\r\n" + ex2.StackTrace;
}
}
}
if (flag2)
{
dBConn3.setInUse();
dBConn3.DBSource_Type = 2;
try
{
StackTrace stackTrace = new StackTrace();
MethodBase method = stackTrace.GetFrame(1).GetMethod();
DBCache.OpenDataDB(dBConn3.GetHashCode(), method.Name);
DBCache.PrintDataDB();
}
catch
{
}
result = dBConn3;
}
else
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get DynaDB Connection Error : " + str);
result = null;
}
}
catch (Exception ex3)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get DynaDB Connection Error : " + ex3.Message + "\n" + ex3.StackTrace);
result = null;
}
}
catch (Exception ex4)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~Get DynaDB Connection Error : " + ex4.Message + "\n" + ex4.StackTrace);
result = null;
}
}
return(result);
}
public int Save()
{
DbCommand dbCommand = null;
DBConn dBConn = null;
try
{
int result;
if (this.gid == null || this.gid.Length < 1 || this.gid.Equals("0"))
{
result = -1;
return(result);
}
if (this.bid == null || this.bid.Length < 1 || this.bid.Equals("0"))
{
result = -1;
return(result);
}
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBUrl.DEFAULT_HOST_PATH + ";Jet OLEDB:Database Password="******"update gatewaytable set eleflag=",
current.ElectricityUsage,
",capacity=",
current.Capacity,
" where slevel=2 and gid='",
this.gid,
"' and bid='",
this.bid,
"' and sid='",
current.SubmeterID,
"' "
});
dbCommand.ExecuteNonQuery();
}
dbCommand.CommandText = string.Concat(new string[]
{
"update gatewaytable set disname = '",
this.bname,
"',location='",
this.location,
"' where slevel = 1 and gid = '",
this.gid,
"' and bid='",
this.bid,
"' "
});
int num = dbCommand.ExecuteNonQuery();
dbCommand.Transaction.Commit();
dbCommand.Dispose();
dBConn.Close();
result = num;
return(result);
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
if (dbCommand != null)
{
try
{
dbCommand.Transaction.Rollback();
dbCommand.Dispose();
}
catch (Exception)
{
}
}
if (dBConn.con != null)
{
try
{
dBConn.Close();
}
catch (Exception)
{
}
}
}
return(-1);
}
public static int CloseAllConnection()
{
if (DBUrl.RUNMODE == 2)
{
DBConn[] array = DBConnPool.dynaConns;
for (int i = 0; i < array.Length; i++)
{
DBConn dBConn = array[i];
if (dBConn.con != null)
{
try
{
dBConn.close();
dBConn.con.Close();
dBConn.con = null;
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("Close DBConnection exception : " + ex.Message + "\n" + ex.StackTrace);
}
}
}
DBConn[] array2 = DBConnPool.dbConns;
for (int j = 0; j < array2.Length; j++)
{
DBConn dBConn2 = array2[j];
if (dBConn2.con != null)
{
try
{
dBConn2.close();
dBConn2.con.Close();
dBConn2.con = null;
}
catch (Exception ex2)
{
DebugCenter.GetInstance().appendToFile("Close DBConnection exception : " + ex2.Message + "\n" + ex2.StackTrace);
}
}
}
return(1);
}
if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL"))
{
return(1);
}
DBConn[] array3 = DBConnPool.dynaConns;
for (int k = 0; k < array3.Length; k++)
{
DBConn dBConn3 = array3[k];
if (dBConn3.con != null)
{
try
{
dBConn3.close();
dBConn3.con.Close();
dBConn3.con = null;
}
catch (Exception ex3)
{
DebugCenter.GetInstance().appendToFile("Close DBConnection exception : " + ex3.Message + "\n" + ex3.StackTrace);
}
}
}
return(1);
}
public int Update()
{
if (this.id < 1)
{
return(-1);
}
if (this.device_id < 1)
{
return(-1);
}
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
if (DBUrl.SERVERMODE)
{
string commandText = "update port_info set port_nm=?port_nm,port_confirmation=?port_confirmation,port_ondelay_time=?port_ondelay_time,port_offdelay_time=?port_offdelay_time,max_voltage=?max_voltage,min_voltage=?min_voltage,max_power_diss=?max_power_diss,min_power_diss=?min_power_diss,max_power=?max_power,min_power=?min_power,max_current=?max_current,min_current=?min_current,shutdown_method=?shutdown_method ,mac=?mac where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("?port_nm", this.port_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?port_confirmation", this.port_confirmation, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?port_ondelay_time", this.port_ondelay_time, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?port_offdelay_time", this.port_offdelay_time, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_voltage", this.max_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_voltage", this.min_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_power_diss", this.max_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_power_diss", this.min_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_power", this.max_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_power", this.min_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_current", this.max_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_current", this.min_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?shutdown_method", this.shutdown_method, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?mac", this.port_mac, dbCommand));
}
else
{
string commandText = "update port_info set port_nm=?,port_confirmation=?,port_ondelay_time=?,port_offdelay_time=?,max_voltage=?,min_voltage=?,max_power_diss=?,min_power_diss=?,max_power=?,min_power=?,max_current=?,min_current=?,shutdown_method=? ,mac=? where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("@port_nm", this.port_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@port_confirmation", this.port_confirmation, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@port_ondelay_time", this.port_ondelay_time, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@port_offdelay_time", this.port_offdelay_time, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_voltage", this.max_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_voltage", this.min_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power_diss", this.max_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power_diss", this.min_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power", this.max_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power", this.min_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_current", this.max_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_current", this.min_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@shutdown_method", this.shutdown_method, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@mac", this.port_mac, dbCommand));
}
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
DBCacheStatus.Device = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Device"
});
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
dbCommand.Dispose();
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public int Update()
{
if (this.id < 1)
{
return(-1);
}
if (this.device_id < 1)
{
return(-1);
}
DBConn dBConn = null;
DbCommand dbCommand = null;
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
if (DBUrl.SERVERMODE)
{
string commandText = "update bank_info set port_nums=?port_nums,bank_nm=?bank_nm,voltage=?voltage,max_voltage=?max_voltage,min_voltage=?min_voltage,max_power_diss=?max_power_diss,min_power_diss=?min_power_diss,max_power=?max_power,min_power=?min_power,max_current=?max_current,min_current=?min_current where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("?port_nums", this.portlists, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?bank_nm", this.bank_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?voltage", this.voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_voltage", this.max_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_voltage", this.min_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_power_diss", this.max_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_power_diss", this.min_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_power", this.max_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_power", this.min_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?max_current", this.max_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?min_current", this.min_current, dbCommand));
}
else
{
if (this.bank_nm != null && this.bank_nm.Equals("\r\n"))
{
string commandText = "update bank_info set port_nums=?,voltage=?,max_voltage=?,min_voltage=?,max_power_diss=?,min_power_diss=?,max_power=?,min_power=?,max_current=?,min_current=? where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("@port_nums", this.portlists, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@voltage", this.voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_voltage", this.max_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_voltage", this.min_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power_diss", this.max_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power_diss", this.min_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power", this.max_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power", this.min_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_current", this.max_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_current", this.min_current, dbCommand));
}
else
{
string commandText = "update bank_info set port_nums=?,bank_nm=?,voltage=?,max_voltage=?,min_voltage=?,max_power_diss=?,min_power_diss=?,max_power=?,min_power=?,max_current=?,min_current=? where id=" + this.id;
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("@port_nums", this.portlists, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@bank_nm", this.bank_nm, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@voltage", this.voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_voltage", this.max_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_voltage", this.min_voltage, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power_diss", this.max_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power_diss", this.min_power_diss, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_power", this.max_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_power", this.min_power, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@max_current", this.max_current, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@min_current", this.min_current, dbCommand));
}
}
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
DBCacheStatus.Device = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Device"
});
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public int UpdateBankThreshold(DBConn conn)
{
if (this.id < 1)
{
return(-1);
}
if (this.device_id < 1)
{
return(-1);
}
DbCommand dbCommand = null;
try
{
if (conn.con != null)
{
dbCommand = DBConn.GetCommandObject(conn.con);
dbCommand.Connection = conn.con;
dbCommand.CommandType = CommandType.Text;
string text = "update bank_info set bank_nm=?,voltage=?,max_voltage=?,min_voltage=?,max_power_diss=?,min_power_diss=?,max_power=?,min_power=?,max_current=?,min_current=? where id=" + this.id;
text = "update bank_info set ";
if (!this.bank_nm.Equals("\r\n"))
{
text = text + "bank_nm='" + this.bank_nm + "',";
}
text = text + "voltage=" + CultureTransfer.ToString(this.voltage);
text = text + ",max_voltage=" + CultureTransfer.ToString(this.max_voltage);
text = text + ",min_voltage=" + CultureTransfer.ToString(this.min_voltage);
text = text + ",max_power_diss=" + CultureTransfer.ToString(this.max_power_diss);
text = text + ",min_power_diss=" + CultureTransfer.ToString(this.min_power_diss);
text = text + ",max_power=" + CultureTransfer.ToString(this.max_power);
text = text + ",min_power=" + CultureTransfer.ToString(this.min_power);
text = text + ",max_current=" + CultureTransfer.ToString(this.max_current);
text = text + ",min_current=" + CultureTransfer.ToString(this.min_current);
text = text + " where id= " + this.id;
dbCommand.CommandText = text;
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
dbCommand.Dispose();
return(result);
}
}
catch (Exception ex)
{
try
{
dbCommand.Dispose();
}
catch
{
}
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
}
return(-1);
}
public int Update()
{
DBConn dBConn = null;
OleDbCommand oleDbCommand = new OleDbCommand();
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
OleDbTransaction transaction = (OleDbTransaction)dBConn.con.BeginTransaction();
oleDbCommand = (OleDbCommand)dBConn.con.CreateCommand();
oleDbCommand.CommandType = CommandType.Text;
oleDbCommand.Transaction = transaction;
oleDbCommand.Parameters.Clear();
oleDbCommand.CommandText = "delete from group_detail where group_id = ? ";
oleDbCommand.Parameters.Add("?", OleDbType.Integer);
oleDbCommand.Prepare();
oleDbCommand.Parameters[0].Value = this.id;
int result;
try
{
oleDbCommand.ExecuteNonQuery();
}
catch
{
oleDbCommand.Transaction.Rollback();
result = -1;
return(result);
}
oleDbCommand.Parameters.Clear();
oleDbCommand.CommandText = string.Concat(new object[]
{
"insert into group_detail (group_id,grouptype,dest_id) values (",
this.id,
",'",
this.group_type,
"',?)"
});
oleDbCommand.Parameters.Add("?", OleDbType.Integer);
oleDbCommand.Prepare();
string[] array = this.members.Split(new string[]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string value = array2[i];
oleDbCommand.Parameters[0].Value = Convert.ToInt64(value);
int num = oleDbCommand.ExecuteNonQuery();
if (num < 0)
{
oleDbCommand.Transaction.Rollback();
result = num;
return(result);
}
}
oleDbCommand.Parameters.Clear();
oleDbCommand.CommandText = "update data_group set groupname= ?, grouptype = ?, linecolor = ?, isselect = ?, thermalflag = ?, billflag = ? where id = " + this.id;
oleDbCommand.Parameters.Add("?", OleDbType.VarChar);
oleDbCommand.Parameters.Add("?", OleDbType.VarChar);
oleDbCommand.Parameters.Add("?", OleDbType.VarChar);
oleDbCommand.Parameters.Add("?", OleDbType.Integer);
oleDbCommand.Parameters.Add("?", OleDbType.Integer);
oleDbCommand.Parameters.Add("?", OleDbType.Integer);
oleDbCommand.Parameters[0].Value = this.group_name;
oleDbCommand.Parameters[1].Value = this.group_type;
oleDbCommand.Parameters[2].Value = this.color;
oleDbCommand.Parameters[3].Value = Convert.ToInt32(this.isselected);
oleDbCommand.Parameters[4].Value = Convert.ToInt64(this.thermalflag);
oleDbCommand.Parameters[5].Value = Convert.ToInt64(this.billflag);
try
{
oleDbCommand.ExecuteNonQuery();
}
catch
{
oleDbCommand.Transaction.Rollback();
result = -1;
return(result);
}
oleDbCommand.Parameters.Clear();
oleDbCommand.Transaction.Commit();
DBCacheStatus.Group = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Group"
});
result = 1;
return(result);
}
}
catch (Exception ex)
{
oleDbCommand.Transaction.Rollback();
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
if (ex.Message.IndexOf(" duplicate values ") > 0)
{
int result = -2;
return(result);
}
}
finally
{
oleDbCommand.Dispose();
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public int UpdateSetting()
{
DBConn dBConn = null;
DbCommand dbCommand = new OleDbCommand();
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
if (DBUrl.SERVERMODE)
{
string commandText = "update smtpsetting set EnableSMTP=?EnableSMTP , ServerAddress=?ServerAddress , PortId=?PortId , EmailFrom=?EmailFrom , EmailTo=?EmailTo , SendEvent=?SendEvent , EnableAuth=?EnableAuth, Account=?Account, UserPwd=?UserPwd ";
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("?EnableSMTP", this.smtp_enable, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?ServerAddress", this.smtp_server, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?PortId", this.smtp_port, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?EmailFrom", this.smtp_from, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?EmailTo", this.smtp_to, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?SendEvent", this.smtp_event, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?EnableAuth", this.smtp_auth, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?Account", this.smtp_account, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("?UserPwd", this.smtp_pwd, dbCommand));
}
else
{
string commandText = "update smtpsetting set EnableSMTP=? , ServerAddress=? , PortId=? , EmailFrom=? , EmailTo=? , SendEvent=? , EnableAuth=?, Account=?, UserPwd=? ";
dbCommand.CommandText = commandText;
dbCommand.Parameters.Add(DBTools.GetParameter("@EnableSMTP", this.smtp_enable, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@ServerAddress", this.smtp_server, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@PortId", this.smtp_port, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@EmailFrom", this.smtp_from, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@EmailTo", this.smtp_to, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@SendEvent", this.smtp_event, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@EnableAuth", this.smtp_auth, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@Account", this.smtp_account, dbCommand));
dbCommand.Parameters.Add(DBTools.GetParameter("@UserPwd", this.smtp_pwd, dbCommand));
}
int num = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
DBCacheStatus.Smtp = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Smtp"
});
int result = num;
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
if (ex.Message.IndexOf(" duplicate values ") > 0)
{
int result = -2;
return(result);
}
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public static int DeleteGroupByID(long l_id)
{
DBConn dBConn = null;
DbCommand dbCommand = null;
try
{
dBConn = DBConnPool.getConnection();
if (dBConn.con != null)
{
dbCommand = DBConn.GetCommandObject(dBConn.con);
dbCommand.CommandType = CommandType.Text;
string commandText = "delete from group_detail where group_id = " + l_id;
dbCommand.CommandText = commandText;
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
dbCommand.CommandText = "delete from groupcontroltask where groupid = " + l_id;
result = dbCommand.ExecuteNonQuery();
dbCommand.CommandText = "delete from taskschedule where groupid = " + l_id;
result = dbCommand.ExecuteNonQuery();
dbCommand.CommandText = "delete from data_group where id = " + l_id;
result = dbCommand.ExecuteNonQuery();
dbCommand.CommandText = "delete from ugp where gid =" + l_id;
dbCommand.ExecuteNonQuery();
DBCacheStatus.Group = true;
DBCacheStatus.GroupTask = true;
DBCacheStatus.User = true;
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_Group"
});
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_GroupTask"
});
DBCacheStatus.DBSyncEventSet(true, new string[]
{
"DBSyncEventName_Service_User"
});
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
if (dBConn != null)
{
dBConn.close();
}
}
return(-1);
}
public static DataTable GetAllBankPD()
{
DataTable dataTable = new DataTable();
DBConn dBConn = null;
DbCommand dbCommand = null;
DbDataAdapter dbDataAdapter = null;
string commandText;
if (DBUrl.DB_CURRENT_TYPE.ToUpper().Equals("MYSQL") || DBUrl.SERVERMODE)
{
commandText = "select * from bank_data_daily" + DateTime.Now.ToString("yyyyMMdd");
try
{
dBConn = DBConnPool.getDynaConnection();
if (dBConn != null && dBConn.con != null)
{
dbDataAdapter = DBConn.GetDataAdapter(dBConn.con);
dbCommand = dBConn.con.CreateCommand();
dbCommand.CommandText = commandText;
dbDataAdapter.SelectCommand = dbCommand;
dbDataAdapter.Fill(dataTable);
dbDataAdapter.Dispose();
dbCommand.Dispose();
dBConn.Close();
}
return(dataTable);
}
catch (Exception)
{
try
{
dbDataAdapter.Dispose();
}
catch
{
}
try
{
dbCommand.Dispose();
}
catch
{
}
try
{
dBConn.Close();
}
catch
{
}
return(dataTable);
}
}
commandText = "select * from bank_data_daily ";
try
{
dBConn = DBConnPool.getDynaConnection(DateTime.Now);
if (dBConn != null && dBConn.con != null)
{
dbDataAdapter = new OleDbDataAdapter();
dbCommand = dBConn.con.CreateCommand();
dbCommand.CommandText = commandText;
dbDataAdapter.SelectCommand = dbCommand;
dbDataAdapter.Fill(dataTable);
dbDataAdapter.Dispose();
dbCommand.Dispose();
dBConn.Close();
}
}
catch (Exception)
{
try
{
dbDataAdapter.Dispose();
}
catch
{
}
try
{
dbCommand.Dispose();
}
catch
{
}
try
{
dBConn.Close();
}
catch
{
}
}
return(dataTable);
}
public void workQueue_DBWork(object sender, WorkQueue <string> .EnqueueEventArgs e)
{
try
{
if (!DBWorkThread.STOP_THREAD)
{
string text = "";
if (TaskStatus.GetDBStatus() == -1)
{
try
{
this.con.Close();
this.con.Dispose();
this.con = null;
}
catch
{
}
}
if (this.con == null)
{
if (DBUrl.SERVERMODE)
{
string cONNECT_STRING = DBUrl.CONNECT_STRING;
string[] array = cONNECT_STRING.Split(new string[]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
this.con = new MySqlConnection(string.Concat(new string[]
{
"Database=eco",
DBUrl.SERVERID,
";Data Source=",
array[0],
";Port=",
array[1],
";User Id=",
array[2],
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=50;Default Command Timeout=0;charset=utf8;"
}));
this.con.Open();
}
else
{
if (DBWorkThread.STOP_THREAD)
{
return;
}
switch (this.DBTYPE)
{
case 0:
break;
case 1:
try
{
this.con = new MySqlConnection(string.Concat(new object[]
{
"Database=",
DBUrl.DB_CURRENT_NAME,
";Data Source=",
DBUrl.CURRENT_HOST_PATH,
";Port=",
DBUrl.CURRENT_PORT,
";User Id=",
DBUrl.CURRENT_USER_NAME,
";Password="******";Pooling=true;Min Pool Size=0;Max Pool Size=150;Default Command Timeout=0;charset=utf8;"
}));
this.con.Open();
DebugCenter.GetInstance().clearStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
goto IL_2A6;
}
catch (Exception e2)
{
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
DebugCenter.GetInstance().appendToFile("Could not create MySQL connection : \r\n" + CommonAPI.ReportException(0, e2, false, " "));
goto IL_2A6;
}
break;
default:
goto IL_2A6;
}
try
{
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBUrl.CURRENT_HOST_PATH + ";Jet OLEDB:Database Password="******"Waiting DBConnection : " + num);
num++;
}
DBConn dynaConnection = DBConnPool.getDynaConnection();
if (dynaConnection != null)
{
this.con = dynaConnection.con;
}
else
{
this.con = null;
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
}
}
try
{
IL_2A6:
if (this.con.State != ConnectionState.Open)
{
try
{
this.con.Close();
this.con.Open();
}
catch (Exception e3)
{
this.con = null;
DebugCenter.GetInstance().setLastStatusCode(DebugCenter.ST_MYSQLCONNECT_LOST, true);
DebugCenter.GetInstance().appendToFile("Could not create MySQL connection : \r\n" + CommonAPI.ReportException(0, e3, false, " "));
}
}
}
catch
{
}
try
{
if (this.cmd != null)
{
this.cmd.Dispose();
}
}
catch (Exception ex2)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex2.Message + "\n" + ex2.StackTrace);
}
try
{
string item = e.Item;
if (item.StartsWith("PDEND"))
{
InSnergyGateway.Need_Calculate_PUE = true;
DBWorkThread.NEEDLOG = true;
}
else
{
if (item.IndexOf("END") > -1)
{
DBCacheStatus.LastInsertTime = DateTime.Now;
DBWorkThread.NEEDLOG = true;
}
else
{
this.cmd = this.con.CreateCommand();
int num2 = this.NeedU2I(item);
if (this.DBTYPE == 1 || DBUrl.SERVERMODE)
{
string commandText = item.Replace("#", "'");
this.cmd.CommandText = commandText;
}
else
{
this.cmd.CommandText = item;
}
text = this.cmd.CommandText;
if (!DBWorkThread.STOP_THREAD)
{
int num3 = this.cmd.ExecuteNonQuery();
if (num3 < 1 && num2 > 0)
{
if (this.DBTYPE == 1 || DBUrl.SERVERMODE)
{
string text2 = this.ChgU2I(item, num2);
text2 = text2.Replace("#", "'");
this.cmd.CommandText = text2;
}
else
{
this.cmd.CommandText = this.ChgU2I(item, num2);
}
text = this.cmd.CommandText;
if (DBWorkThread.STOP_THREAD)
{
return;
}
this.cmd.ExecuteNonQuery();
}
this.cmd.Dispose();
if (TaskStatus.GetDBStatus() == -1)
{
try
{
this.con.Close();
}
catch
{
}
try
{
this.con.Dispose();
}
catch
{
}
this.con = null;
}
}
}
}
}
catch (Exception ex3)
{
if (ex3.GetType().FullName.Equals("MySql.Data.MySqlClient.MySqlException"))
{
string tableName = DBUtil.GetTableName(text);
if (tableName != null && tableName.Length > 0)
{
DBUtil.SetMySQLInfo(tableName);
DebugCenter.GetInstance().appendToFile("MySQL database is marked as crashed, EcoSensor Monitor Service will be shutdown ");
DBUtil.StopService();
}
}
if (ex3.Message.ToLower().IndexOf("fatal error encountered during command execution") < 0)
{
if (text.IndexOf("rack_effect") > 0)
{
try
{
DBTools.Write_DBERROR_Log();
goto IL_56F;
}
catch
{
goto IL_56F;
}
}
if (DBWorkThread.NEEDLOG)
{
try
{
DBTools.Write_DBERROR_Log();
}
catch
{
}
DBWorkThread.NEEDLOG = false;
}
IL_56F:
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex3.Message + "\n" + ex3.StackTrace);
}
try
{
this.cmd.Dispose();
this.con.Close();
}
catch (Exception)
{
}
this.con = null;
}
}
}
finally
{
try
{
if (this.con != null)
{
this.con.Close();
}
this.con = null;
}
catch
{
}
}
}
public int Update(DBConn conn)
{
string text = this.insert_time.ToString("yyyyMMdd");
try
{
long num = Convert.ToInt64(this.power_consumption * 10000.0);
if (DBUrl.SERVERMODE)
{
string item = string.Concat(new object[]
{
"update bank_data_daily",
text,
" set power_consumption = power_consumption + ",
CultureTransfer.ToString((float)num),
" where bank_id = ",
this.bank_id,
" and insert_time = #",
this.insert_time.ToString("yyyy-MM-dd"),
"#"
});
string item2 = string.Concat(new object[]
{
"update bank_data_hourly",
text,
" set power_consumption = power_consumption + ",
CultureTransfer.ToString((float)num),
" where bank_id = ",
this.bank_id,
" and insert_time = #",
new DateTime(this.insert_time.Year, this.insert_time.Month, this.insert_time.Day, DateTime.Now.Hour, 30, 0).ToString("yyyy-MM-dd HH:mm:ss"),
"#"
});
WorkQueue <string> .getInstance_pd().WorkSequential = true;
WorkQueue <string> .getInstance_pd().EnqueueItem(item);
WorkQueue <string> .getInstance_pd().EnqueueItem(item2);
}
else
{
if (DBUrl.DB_CURRENT_TYPE.Equals("MYSQL"))
{
string item3 = string.Concat(new object[]
{
"update bank_data_daily",
text,
" set power_consumption = power_consumption + ",
CultureTransfer.ToString((float)num),
" where bank_id = ",
this.bank_id,
" and insert_time = #",
this.insert_time.ToString("yyyy-MM-dd"),
"#"
});
string item4 = string.Concat(new object[]
{
"update bank_data_hourly",
text,
" set power_consumption = power_consumption + ",
CultureTransfer.ToString((float)num),
" where bank_id = ",
this.bank_id,
" and insert_time = #",
new DateTime(this.insert_time.Year, this.insert_time.Month, this.insert_time.Day, DateTime.Now.Hour, 30, 0).ToString("yyyy-MM-dd HH:mm:ss"),
"#"
});
WorkQueue <string> .getInstance_pd().WorkSequential = true;
WorkQueue <string> .getInstance_pd().EnqueueItem(item3);
WorkQueue <string> .getInstance_pd().EnqueueItem(item4);
}
else
{
List <string> list = new List <string>();
list.Add(string.Concat(this.bank_id));
list.Add(this.insert_time.ToString("yyyy-MM-dd HH:mm:ss"));
list.Add("bank_data_daily");
list.Add(CultureTransfer.ToString((float)num));
MinuteDataProcess.GetInstance().PutItem(list);
List <string> list2 = new List <string>();
list2.Add(string.Concat(this.bank_id));
list2.Add(this.insert_time.ToString("yyyy-MM-dd HH:mm:ss"));
list2.Add("bank_data_hourly");
list2.Add(CultureTransfer.ToString((float)num));
MinuteDataProcess.GetInstance().PutItem(list2);
}
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
return(0);
}
public static void InsertDevicePower(int i_deviceid, double f_power, DateTime dt_inserttime, DBConn conn)
{
try
{
long num = Convert.ToInt64(f_power * 10000.0);
if (DBUrl.SERVERMODE)
{
string item = string.Concat(new object[]
{
"insert into device_auto_info",
dt_inserttime.ToString("yyyyMMdd"),
" (device_id,power,insert_time ) values(",
i_deviceid,
",",
num,
",#",
dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"),
"#)"
});
WorkQueue <string> .getInstance().WorkSequential = true;
WorkQueue <string> .getInstance().EnqueueItem(item);
}
else
{
if (DBUrl.DB_CURRENT_TYPE.Equals("MYSQL"))
{
string item2 = string.Concat(new object[]
{
"insert into device_auto_info",
dt_inserttime.ToString("yyyyMMdd"),
" (device_id,power,insert_time ) values(",
i_deviceid,
",",
num,
",#",
dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"),
"#)"
});
WorkQueue <string> .getInstance().WorkSequential = true;
WorkQueue <string> .getInstance().EnqueueItem(item2);
}
else
{
List <string> list = new List <string>();
list.Add(string.Concat(i_deviceid));
list.Add(dt_inserttime.ToString("yyyy-MM-dd HH:mm:ss"));
list.Add("device_auto_info");
list.Add(string.Concat(num));
PDDataProcess.GetInstance().PutItem(list);
}
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
}
}
public int UpdateSensorThreshold(DBConn conn)
{
if (this.id < 1)
{
return(-1);
}
if (this.device_id < 1)
{
return(-1);
}
DbCommand dbCommand = new OleDbCommand();
try
{
if (conn.con != null)
{
dbCommand = DBConn.GetCommandObject(conn.con);
dbCommand.CommandType = CommandType.Text;
string text = "update device_sensor_info set max_humidity=?,min_humidity=?,max_temperature=?,min_temperature=?,max_press=?,min_press=? where id=" + this.id;
text = "update device_sensor_info set ";
text = text + "max_humidity=" + CultureTransfer.ToString(this.max_humidity);
text = text + ",min_humidity=" + CultureTransfer.ToString(this.min_humidity);
text = text + ",max_temperature=" + CultureTransfer.ToString(this.max_temperature);
text = text + ",min_temperature=" + CultureTransfer.ToString(this.min_temperature);
text = text + ",max_press=" + CultureTransfer.ToString(this.max_press);
text = text + ",min_press=" + CultureTransfer.ToString(this.min_press);
text = text + " where id= " + this.id;
dbCommand.CommandText = text;
int result = dbCommand.ExecuteNonQuery();
dbCommand.Parameters.Clear();
try
{
dbCommand.Dispose();
}
catch
{
}
return(result);
}
}
catch (Exception ex)
{
DebugCenter.GetInstance().appendToFile("DBERROR~~~~~~~~~~~DBERROR : " + ex.Message + "\n" + ex.StackTrace);
try
{
dbCommand.Dispose();
}
catch
{
}
}
finally
{
try
{
dbCommand.Dispose();
}
catch
{
}
}
return(-1);
}