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