private void DataBind(string type)
{
string text = this.dtpFrom.Text;
string text2 = this.dtpTo.Text;
string str = this.txtkey.Text.Replace("'", "''");
string str_sql;
if (type != null)
{
if (type == "0")
{
str_sql = string.Concat(new string[]
{
"select id,Title,Writer,ReportTime,ReportPath from reportinfo where ReportTime between #",
text,
"# and #",
text2,
"# order by ReportTime desc"
});
goto IL_D1;
}
if (type == "1")
{
str_sql = "select id,Title,Writer,ReportTime,ReportPath from reportinfo where title like '%" + str + "%' order by ReportTime desc";
goto IL_D1;
}
if (type == "2")
{
str_sql = "select id,Title,Writer,ReportTime,ReportPath from reportinfo where writer like '%" + str + "%' order by ReportTime desc";
goto IL_D1;
}
}
str_sql = "select id,Title,Writer,ReportTime,ReportPath from reportinfo order by ReportTime desc";
IL_D1:
DataTable dataTable = DBTools.CreateDataTable4SysDB(str_sql);
this.dgvwReport.Rows.Clear();
int num = 1;
foreach (DataRow dataRow in dataTable.Rows)
{
System.DateTime dateTime = (System.DateTime)dataRow["ReportTime"];
object[] values = new object[]
{
num++,
dataRow["id"].ToString(),
dataRow["Title"].ToString(),
dataRow["Writer"].ToString(),
dateTime.ToString("yyyy-MM-dd HH:mm:ss"),
dataRow["ReportPath"].ToString(),
EcoLanguage.getMsg(LangRes.RptMng_OpenHTML, new string[0]),
EcoLanguage.getMsg(LangRes.RptMng_OpenFolder, new string[0])
};
this.dgvwReport.Rows.Add(values);
}
this.dgvwReport.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.dgvwReport.ClearSelection();
}
private System.Collections.ArrayList getAnalysisGroup(EGenRptPara m_pParaWindow)
{
System.Collections.ArrayList arrayList = new System.Collections.ArrayList();
foreach (ListViewItem listViewItem in m_pParaWindow.Grouplist)
{
string text = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[0];
string text2 = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[1];
if (text2.Length == 0)
{
text2 = "0";
}
string text3 = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[2];
string text4 = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[3];
string text5 = listViewItem.SubItems[1].Text;
string text6 = "0,";
string text7 = "0,";
string text8 = "0,";
string text9 = "0,";
string text10 = "0,";
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
System.Text.StringBuilder stringBuilder2 = new System.Text.StringBuilder();
System.Text.StringBuilder stringBuilder3 = new System.Text.StringBuilder();
string key;
switch (key = text3)
{
case "zone":
{
string str_sql = "select racks from zone_info where id in (" + text2 + ") and racks <>''";
DataTable dataTable = DBTools.CreateDataTable4SysDB(str_sql);
text9 = "0,";
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string str_sql2 = "select id,model_nm,fw_version from device_base_info where rack_id in (" + System.Convert.ToString(dataTable.Rows[i]["racks"]) + ") ";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
string text11 = "";
text10 = "0,";
stringBuilder2 = new System.Text.StringBuilder();
stringBuilder3 = new System.Text.StringBuilder();
stringBuilder = new System.Text.StringBuilder();
for (int j = 0; j < dataTable2.Rows.Count; j++)
{
System.Convert.ToString(dataTable2.Rows[j]["id"]);
string modelname = System.Convert.ToString(dataTable2.Rows[j]["model_nm"]);
string fmwareVer = System.Convert.ToString(dataTable2.Rows[j]["fw_version"]);
DevModelConfig deviceModelConfig = DevAccessCfg.GetInstance().getDeviceModelConfig(modelname, fmwareVer);
if (!deviceModelConfig.devcapacity.Equals("N/A"))
{
if (deviceModelConfig.perportreading == 2)
{
stringBuilder2.Append(System.Convert.ToString(dataTable2.Rows[j]["id"]) + ",");
}
else
{
stringBuilder3.Append(System.Convert.ToString(dataTable2.Rows[j]["id"]) + ",");
}
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[j]["id"]) + ",");
}
}
text11 += stringBuilder.ToString();
text10 += stringBuilder2.ToString();
text8 += stringBuilder3.ToString();
if (text11.Length > 0)
{
text11 = text11.Substring(0, text11.Length - 1);
}
if (text10.Length > 0)
{
text10 = text10.Substring(0, text10.Length - 1);
}
string str_sql3 = "select id from port_info where device_id in (" + text10 + ")";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int k = 0; k < dataTable3.Rows.Count; k++)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[k]["id"]) + ",");
}
text7 += stringBuilder.ToString();
text9 = text9 + text11 + ",";
}
text9 = commUtil.uniqueIDs(text9);
if (text9.Length > 0)
{
text6 = text9.Substring(0, text9.Length - 1);
}
text8 = commUtil.uniqueIDs(text8);
if (text8.Length > 0)
{
text8 = text8.Substring(0, text8.Length - 1);
}
text7 = commUtil.uniqueIDs(text7);
if (text7.Length > 0)
{
text7 = text7.Substring(0, text7.Length - 1);
}
break;
}
case "rack":
case "allrack":
{
string str_sql2 = "select id,model_nm,fw_version from device_base_info where rack_id in (" + text2 + ")";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
stringBuilder2 = new System.Text.StringBuilder();
stringBuilder3 = new System.Text.StringBuilder();
stringBuilder = new System.Text.StringBuilder();
for (int l = 0; l < dataTable2.Rows.Count; l++)
{
System.Convert.ToString(dataTable2.Rows[l]["id"]);
string modelname2 = System.Convert.ToString(dataTable2.Rows[l]["model_nm"]);
string fmwareVer2 = System.Convert.ToString(dataTable2.Rows[l]["fw_version"]);
DevModelConfig deviceModelConfig2 = DevAccessCfg.GetInstance().getDeviceModelConfig(modelname2, fmwareVer2);
if (!deviceModelConfig2.devcapacity.Equals("N/A"))
{
if (deviceModelConfig2.perportreading == 2)
{
stringBuilder2.Append(System.Convert.ToString(dataTable2.Rows[l]["id"]) + ",");
}
else
{
stringBuilder3.Append(System.Convert.ToString(dataTable2.Rows[l]["id"]) + ",");
}
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[l]["id"]) + ",");
}
}
text9 += stringBuilder.ToString();
text10 += stringBuilder2.ToString();
text8 += stringBuilder3.ToString();
if (text9.Length > 0)
{
text6 = text9.Substring(0, text9.Length - 1);
}
if (text10.Length > 0)
{
text10 = text10.Substring(0, text10.Length - 1);
}
if (text8.Length > 0)
{
text8 = text8.Substring(0, text8.Length - 1);
}
string str_sql3 = "select id from port_info where device_id in (" + text10 + ")";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int m = 0; m < dataTable3.Rows.Count; m++)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[m]["id"]) + ",");
}
text7 += stringBuilder.ToString();
if (text7.Length > 0)
{
text7 = text7.Substring(0, text7.Length - 1);
}
break;
}
case "dev":
case "alldev":
{
string str_sql2 = "select id,model_nm,fw_version from device_base_info where id in (" + text2 + ")";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
text10 = "0,";
stringBuilder2 = new System.Text.StringBuilder();
stringBuilder3 = new System.Text.StringBuilder();
stringBuilder = new System.Text.StringBuilder();
for (int n = 0; n < dataTable2.Rows.Count; n++)
{
System.Convert.ToString(dataTable2.Rows[n]["id"]);
string modelname3 = System.Convert.ToString(dataTable2.Rows[n]["model_nm"]);
string fmwareVer3 = System.Convert.ToString(dataTable2.Rows[n]["fw_version"]);
DevModelConfig deviceModelConfig3 = DevAccessCfg.GetInstance().getDeviceModelConfig(modelname3, fmwareVer3);
if (!deviceModelConfig3.devcapacity.Equals("N/A"))
{
if (deviceModelConfig3.perportreading == 2)
{
stringBuilder2.Append(System.Convert.ToString(dataTable2.Rows[n]["id"]) + ",");
}
else
{
stringBuilder3.Append(System.Convert.ToString(dataTable2.Rows[n]["id"]) + ",");
}
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[n]["id"]) + ",");
}
}
text10 += stringBuilder2.ToString();
text8 += stringBuilder3.ToString();
text6 += stringBuilder.ToString();
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
if (text10.Length > 0)
{
text10 = text10.Substring(0, text10.Length - 1);
}
if (text8.Length > 0)
{
text8 = text8.Substring(0, text8.Length - 1);
}
string str_sql3 = "select id from port_info where device_id in (" + text10 + ")";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int num2 = 0; num2 < dataTable3.Rows.Count; num2++)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[num2]["id"]) + ",");
}
text7 += stringBuilder.ToString();
if (text7.Length > 0)
{
text7 = text7.Substring(0, text7.Length - 1);
}
break;
}
case "alloutlet":
{
text6 = "0";
text8 = "0";
string str_sql3 = "select a.id,b.model_nm,b.fw_version from port_info a left join device_base_info b on a.device_id=b.id where a.id in (select id from port_info)";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int num3 = 0; num3 < dataTable3.Rows.Count; num3++)
{
string modelname4 = System.Convert.ToString(dataTable3.Rows[num3]["model_nm"]);
string fmwareVer4 = System.Convert.ToString(dataTable3.Rows[num3]["fw_version"]);
DevModelConfig deviceModelConfig4 = DevAccessCfg.GetInstance().getDeviceModelConfig(modelname4, fmwareVer4);
if (!deviceModelConfig4.devcapacity.Equals("N/A") && deviceModelConfig4.perportreading == 2)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[num3]["id"]) + ",");
}
}
text7 += stringBuilder.ToString();
if (text7.Length > 0)
{
text7 = text7.Substring(0, text7.Length - 1);
}
break;
}
case "outlet":
{
text6 = "0";
text8 = "0";
string str_sql3 = "select a.id,b.model_nm,b.fw_version from port_info a left join device_base_info b on a.device_id=b.id where a.id in (select dest_id from group_detail where grouptype='outlet' and group_id=" + text + ")";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int num4 = 0; num4 < dataTable3.Rows.Count; num4++)
{
string modelname5 = System.Convert.ToString(dataTable3.Rows[num4]["model_nm"]);
string fmwareVer5 = System.Convert.ToString(dataTable3.Rows[num4]["fw_version"]);
DevModelConfig deviceModelConfig5 = DevAccessCfg.GetInstance().getDeviceModelConfig(modelname5, fmwareVer5);
if (!deviceModelConfig5.devcapacity.Equals("N/A") && deviceModelConfig5.perportreading == 2)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[num4]["id"]) + ",");
}
}
text7 += stringBuilder.ToString();
if (text7.Length > 0)
{
text7 = text7.Substring(0, text7.Length - 1);
}
break;
}
}
arrayList.Add(string.Concat(new string[]
{
text6,
"|",
text,
"|",
text5,
"|",
text3.ToString(),
"|",
text7,
"|",
text8,
"|",
text4
}));
}
return(arrayList);
}
private System.Collections.ArrayList getAnalysisGroup(BillingRptPara pPara)
{
System.Collections.ArrayList arrayList = new System.Collections.ArrayList();
foreach (ListViewItem listViewItem in pPara.Grouplist)
{
string text = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[0];
string text2 = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[1];
if (text2.Length == 0)
{
text2 = "0";
}
string text3 = System.Convert.ToString(listViewItem.Tag).Split(new char[]
{
'|'
})[2];
string text4 = listViewItem.SubItems[1].Text;
string text5 = "0,";
string text6 = "0,";
string text7 = "0,";
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string key;
switch (key = text3)
{
case "zone":
{
string str_sql = "select racks from zone_info where id in (" + text2 + ") and racks <>''";
DataTable dataTable = DBTools.CreateDataTable4SysDB(str_sql);
text7 = "0,";
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string str_sql2 = "select id as device_ids from device_base_info where rack_id in (" + System.Convert.ToString(dataTable.Rows[i]["racks"]) + ") ";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
string text8 = "";
stringBuilder = new System.Text.StringBuilder();
for (int j = 0; j < dataTable2.Rows.Count; j++)
{
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[j]["device_ids"]) + ",");
}
text8 += stringBuilder.ToString();
if (text8.Length > 0)
{
text8 = text8.Substring(0, text8.Length - 1);
}
text7 = text7 + text8 + ",";
}
text7 = commUtil.uniqueIDs(text7);
if (text7.Length > 0)
{
text5 = text7.Substring(0, text7.Length - 1);
}
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
break;
}
case "rack":
case "allrack":
{
string str_sql2 = "select id as device_ids from device_base_info where rack_id in (" + text2 + ")";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
stringBuilder = new System.Text.StringBuilder();
for (int k = 0; k < dataTable2.Rows.Count; k++)
{
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[k]["device_ids"]) + ",");
}
text7 += stringBuilder.ToString();
if (text7.Length > 0)
{
text5 = text7.Substring(0, text7.Length - 1);
}
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
break;
}
case "dev":
case "alldev":
{
string str_sql2 = "select id,model_nm from device_base_info where id in (" + text2 + ")";
DataTable dataTable2 = DBTools.CreateDataTable4SysDB(str_sql2);
stringBuilder = new System.Text.StringBuilder();
for (int l = 0; l < dataTable2.Rows.Count; l++)
{
stringBuilder.Append(System.Convert.ToString(dataTable2.Rows[l]["id"]) + ",");
}
text5 += stringBuilder.ToString();
if (text5.Length > 0)
{
text5 = text5.Substring(0, text5.Length - 1);
}
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
break;
}
case "alloutlet":
{
text5 = "0";
string str_sql3 = "select a.id,b.model_nm,b.fw_version from port_info a left join device_base_info b on a.device_id=b.id where a.id in (select id from port_info)";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int m = 0; m < dataTable3.Rows.Count; m++)
{
string modelname = System.Convert.ToString(dataTable3.Rows[m]["model_nm"]);
string fmwareVer = System.Convert.ToString(dataTable3.Rows[m]["fw_version"]);
if (DevAccessCfg.GetInstance().getDeviceModelConfig(modelname, fmwareVer).perportreading == 2)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[m]["id"]) + ",");
}
}
text6 += stringBuilder.ToString();
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
break;
}
case "outlet":
{
text5 = "0";
string str_sql3 = "select a.id,b.model_nm,b.fw_version from port_info a left join device_base_info b on a.device_id=b.id where a.id in (select dest_id from group_detail where grouptype='outlet' and group_id=" + text + ")";
DataTable dataTable3 = DBTools.CreateDataTable4SysDB(str_sql3);
stringBuilder = new System.Text.StringBuilder();
for (int n = 0; n < dataTable3.Rows.Count; n++)
{
string modelname2 = System.Convert.ToString(dataTable3.Rows[n]["model_nm"]);
string fmwareVer2 = System.Convert.ToString(dataTable3.Rows[n]["fw_version"]);
if (DevAccessCfg.GetInstance().getDeviceModelConfig(modelname2, fmwareVer2).perportreading == 2)
{
stringBuilder.Append(System.Convert.ToString(dataTable3.Rows[n]["id"]) + ",");
}
}
text6 += stringBuilder.ToString();
if (text6.Length > 0)
{
text6 = text6.Substring(0, text6.Length - 1);
}
break;
}
}
arrayList.Add(string.Concat(new string[]
{
text5,
"|",
text,
"|",
text4,
"|",
text3.ToString(),
"|",
text6
}));
}
return(arrayList);
}
