//载入窗体 private void datereport_Load(object sender, EventArgs e) { string sComboData; try { if (loading.ibb_flag == "1") { DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs); OleDbDataReader dbReader = DbHelper.ExecuteDataReader("select * from report where report_type!='0' order by proc_name "); while (dbReader.Read()) { sComboData = dbReader.GetString(0).ToString().Trim() + " - " + dbReader.GetString(1).ToString().Trim(); combo.Items.Add((object)sComboData); } } else if (loading.ibb_flag == "2") { DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs); OleDbDataReader dbReader = DbHelper.ExecuteDataReader("select * from report_xft where report_type!='0' order by report_num "); while (dbReader.Read()) { sComboData = dbReader.GetString(0).ToString().Trim() + " - " + dbReader.GetString(1).ToString().Trim(); combo.Items.Add((object)sComboData); } } else if (loading.ibb_flag == "3") { DbHelper = new MyDbHelper(MyDbHelper.connectstring_prec); OleDbDataReader dbReader = DbHelper.ExecuteDataReader("select * from report_bf where report_type!='0' order by report_num "); while (dbReader.Read()) { sComboData = dbReader.GetString(0).ToString().Trim() + " - " + dbReader.GetString(1).ToString().Trim(); combo.Items.Add((object)sComboData); } } } catch (Exception ex) { MyLog.Log("3", "向combox读取数据失败:" + ex.Message); } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } }
private void pictureBox1_Click(object sender, EventArgs e) { reflow_control r_con = new reflow_control(); string reportNum, beginDate, endDate; //根据列表中报表编号找到对应的数据库表中数据表名,模板名,SHEET名 string sTableName = ""; string sModelName = ""; string sSheetName = ""; string sReportName = ""; string sProcName = ""; int iRowNum = listView.Items.Count; //进度条代码 proBar.Value = 0; proBar.Maximum = iRowNum * 10; proBar.Step = 1; for (int i = 0; i < iRowNum; i++) { beginDate = listView.Items[i].SubItems[1].Text.Trim(); endDate = listView.Items[i].SubItems[2].Text.Trim(); reportNum = listView.Items[i].SubItems[0].Text.Substring(0, 2); string strCmd = ""; try { string constr = ""; if (loading.ibb_flag == "1") { strCmd = "select * from report where REPORT_NUM = " + reportNum; constr = MyDbHelper.connectstring_cardqs; } else if (loading.ibb_flag == "2") { strCmd = "select * from report_xft where REPORT_NUM = " + reportNum; constr = MyDbHelper.connectstring_cardqs; } else if (loading.ibb_flag == "3") { strCmd = "select * from report_bf where REPORT_NUM = " + reportNum; constr = MyDbHelper.connectstring_prec; } DbHelper = new MyDbHelper(constr); OleDbDataReader dbReader = DbHelper.ExecuteDataReader(strCmd); if (dbReader.Read()) { sTableName = dbReader.GetString(4).ToString(); sModelName = dbReader.GetString(2).ToString(); sSheetName = dbReader.GetString(3).ToString(); sReportName = dbReader.GetString(1).ToString(); sProcName = dbReader.GetString(5).ToString(); } try { r_con.RunProcedure(sProcName.Trim(), beginDate, endDate, constr); } catch (Exception errorRunPro) { MessageBox.Show(errorRunPro.ToString()); } //写EXCEL文件 r_con.WriteExcelFile(sModelName, sTableName, sSheetName, beginDate, endDate, constr);//将表中内容放入EXCEL listView.Items[i].SubItems[3].Text = "完成统计"; proBar.Value = (i + 1) * 10; } catch (Exception ex) { MyLog.Log("3", "读取数据失败:" + ex.Message); } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } } }