private void exceloutclass(string savename)
{
string sql = "select para_title,details,ref_value,flag,'',para_type,para_level,'' from Status_Now";
Tool_Class.IO_tool tool = new Tool_Class.IO_tool();
DataTable dt = tool.DbToDatatable(sql);
StringBuilder sb1 = history("syslog_warn");
StringBuilder sb2 = history("instrument_connection");
StringBuilder sb3 = history("disk_size");
StringBuilder sb4 = history("cpu_running");
StringBuilder sb5 = history("memory_running");
StringBuilder sb6 = history("table_count");
StringBuilder sb7 = history("db_size");
StringBuilder sb8 = history("para_check");
StringBuilder sb9 = history("log_error");
StringBuilder sb10 = history("db_backup");
dt.Rows[0][7] = sb1;
dt.Rows[1][7] = sb2;
dt.Rows[2][7] = sb3;
dt.Rows[3][7] = sb4;
dt.Rows[4][7] = sb5;
dt.Rows[5][7] = sb6;
dt.Rows[6][7] = sb7;
dt.Rows[7][7] = sb8;
dt.Rows[8][7] = sb9;
dt.Rows[9][7] = sb10;
tool.DataTableToExcel(dt, savename);
}
private void exceloutclass(string savename)
{
string sql = "select para_title,details,ref_value,flag,'',para_type,para_level,'' from Status_Now";
Tool_Class.IO_tool tool = new Tool_Class.IO_tool();
DataTable dt = tool.DbToDatatable(sql);
StringBuilder sb1 = history("syslog_warn");
StringBuilder sb2 = history("instrument_connection");
StringBuilder sb3 = history("disk_size");
StringBuilder sb4 = history("cpu_running");
StringBuilder sb5 = history("memory_running");
StringBuilder sb6 = history("table_count");
StringBuilder sb7 = history("db_size");
StringBuilder sb8 = history("para_check");
StringBuilder sb9 = history("log_error");
StringBuilder sb10 = history("db_backup");
StringBuilder sb11 = history("check_option");
dt.Rows[0][7] = sb1;
dt.Rows[1][7] = sb2;
dt.Rows[2][7] = sb3;
dt.Rows[3][7] = sb4.Append(sb5);
dt.Rows[4][7] = sb6;
dt.Rows[5][7] = sb7;
dt.Rows[6][7] = sb8;
dt.Rows[7][7] = sb9;
dt.Rows[8][7] = sb10;
dt.Rows[9][7] = sb11;
tool.DataTableToExcel(dt,savename);
}