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