public void ReadData2Access()
{
ReadOracleData ROD = new ReadOracleData();
OracleConnection conn = ROD.NewConn();
DataSet Table_DataSet;
Table_DataSet = ROD.ReadDataToDataSet(conn, "select item,inhalt,gruppe from datos_ini", "");
string item, inhalt, gruppe;
io.AccessDbclass("delete from datos_ini", db_dir);
foreach (DataRow ini_Row in Table_DataSet.Tables[0].Rows)
{
item = ini_Row["item"].ToString();
inhalt = ini_Row["inhalt"].ToString();
gruppe = ini_Row["gruppe"].ToString();
insert_sql = "insert into datos_ini(item,inhalt,gruppe) values ('" + item + "',\"" + inhalt + "\",'" + gruppe + "')";
io.AccessDbclass(insert_sql, db_dir);
}
Table_DataSet.Dispose();
conn.Close();
}
public void Check_database_para(bool is_first, int exec)
{
if (io.execute_or_not("para_check", db_dir, Convert.ToInt32(io.readconfig("IT3K_OPTION", "OPTION_CHECK")), is_first, exec))
{
int ini_diff = 0, table_diff = 0;
string result = "错误", output = "";
OracleConnection conn = ROD.NewConn();
DataSet Table_DataSet;
for (int i = 0; i < 9; i += 2)
{
Table_DataSet = ROD.ReadDataToDataSet(conn, SQL_stat[i], "");
if ((i == 6 || i == 8) && Table_DataSet.Tables[0].Rows[0].ItemArray[0].ToString() == "")
{
table_diff = -1;
}
else
{
if (Table_DataSet != null && !Table_DataSet.HasErrors && Table_DataSet.Tables.Count == 1)
{
table_diff = Convert.ToInt32(Table_DataSet.Tables[0].Rows[0].ItemArray[0]);
}
}
Table_DataSet.Reset();
Table_DataSet = ROD.ReadDataToDataSet(conn, SQL_stat[i + 1], "");
if (Table_DataSet != null && !Table_DataSet.HasErrors && Table_DataSet.Tables.Count == 1)
{
ini_diff = Convert.ToInt32(Table_DataSet.Tables[0].Rows[0].ItemArray[0]);
}
if (table_diff < ini_diff)
{
result = "正常";
}
output += output_stat[i] + "在数据表中存在" + table_diff + "天的数据,但参数设置的是小于" + ini_diff + "天, 检测结果:" + result + ".\r\n";
Table_DataSet.Reset();
result = "错误";
table_diff = ini_diff = 0;
}
conn.Close();
if (output.Length > 255)
{
output = output.Substring(0, 254);
}
if (result == "正常")
{
show_flag = 'N';
}
else
{
show_flag = 'E';
}
in_or_up = insert_or_update("para_check");
if (in_or_up)
{
insert_sql = "insert into Status_Now(para_name,para_value,para_group,flag,description,create_date,para_title,details) values ('para_check','" + result + "','IT3K_Para','" + show_flag + "','','" + DateTime.Now.ToString() + "','IT3K_para','" + output + "')";
io.AccessDbclass(insert_sql, db_dir);
}
else
{
insert_sql = "insert into Status_Histroy select * from (select para_name,para_value,para_group,flag,description,create_date,para_title,details from Status_Now where para_name = 'para_check')";
io.AccessDbclass(insert_sql, db_dir);
insert_sql = "update Status_Now set para_value='" + result + "',flag = '" + show_flag + "',create_date = '" + DateTime.Now.ToString() + "',details = '" + output + "' where para_name = 'para_check'";
io.AccessDbclass(insert_sql, db_dir);
}
}
}
