Exemplo n.º 1
0
 private void button1_Click(object sender, EventArgs e)
 {
     ReportManager rm = new ReportManager();
     PDFManager pm = new PDFManager();
     LisReport lr = new LisReport();
     Hashtable equalFields = new Hashtable();
     string sql = "select receivedate,sectionno,testtypeno,sampleno from ReportForm where SectionNo=" + textBox1.Text.Trim() + " and checkdate='"+dateTimePicker1.Value.ToString("yyyy-MM-dd")+"'";
     DataTable dt = DbHelperSQL.Query(sql).Tables["dt"];
     DataSet ds = pm.GetPrintDataSet("ReportTables.frd");
     foreach (DataRow dr in dt.Rows)
     {
         equalFields.Clear();
         equalFields.Add("receivedate", (DateTime)dr["receivedate"]);
         equalFields.Add("sectionno", (int)dr["sectionno"]);
         equalFields.Add("testtypeno", (int)dr["testtypeno"]);
         equalFields.Add("sampleno", dr["sampleno"].ToString());
         rm.InitLisReport(lr, equalFields);
         pm.GenderPDFReport(lr, "E:\\lis", ds);
     }
 }
Exemplo n.º 2
0
 private void button3_Click(object sender, EventArgs e)
 {
     ReportManager rm = new ReportManager();
     PDFManager pm = new PDFManager();
     LisReport lr = new LisReport();
     Hashtable equalFields = new Hashtable();
     string sql = "select receivedate,sectionno,testtypeno,sampleno from ReportForm where receivedate='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and Sectionno in(3,4,11,14,17,23,29,34,5,19,20,21,25,30,33,35,63,18,2,27,28,62)";
     DataTable dt = DbHelperSQL.Query(sql).Tables["dt"];
     DataSet ds = pm.GetPrintDataSet("ReportTables.frd");
     foreach (DataRow dr in dt.Rows)
     {
         equalFields.Clear();
         equalFields.Add("receivedate", (DateTime)dr["receivedate"]);
         equalFields.Add("sectionno", (int)dr["sectionno"]);
         equalFields.Add("testtypeno", (int)dr["testtypeno"]);
         equalFields.Add("sampleno", dr["sampleno"].ToString());
         rm.InitLisReport(lr, equalFields);
         pm.GenderPDFReport(lr, LisConfig.GetPdfRootPath(), ds);
     }
     //GenderRemoteFile(dateTimePicker1.Value);
 }