private void GenderRemoteFile(DateTime dt) { string directoryPath = Path.Combine(LisConfig.GetPdfRootPath(), DateTime.Now.ToString("yyyy-MM-dd")); DirectoryInfo di = new DirectoryInfo(directoryPath); DirectoryInfo[] sectionDirectories = di.GetDirectories(); string[] filePaths; int sectionNo; foreach (DirectoryInfo d in sectionDirectories) { if (int.TryParse(d.Name, out sectionNo)) { filePaths = Directory.GetFiles(d.FullName); CombinePDF(filePaths, dt, sectionNo); } } }
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); }