Beispiel #1
0
 public PrintFormatController(string filePath, ref DBAccessProc.Schema.TrainManagementDataSet dataset)
 {
     try
     {
         m_sFilePath = filePath + "\\" + DateTime.Now.ToString("yyyyMMdd");
         if (!Directory.Exists(m_sFilePath))
         {
             Directory.CreateDirectory(m_sFilePath);
         }
         m_ReExamResultDs           = dataset;
         m_ReExamResultDs.Namespace = "";
     }
     catch (Exception ex)
     {
         System.Windows.MessageBox.Show("初始化PrintFormatController时失败,错误:" + ex.Message + ",位置:" + ex.StackTrace);
     }
 }
Beispiel #2
0
        /// <summary>
        /// 打印相关
        /// </summary>
        /// <param name="sXslFile"></param>
        /// <param name="printFiles"></param>
        public string PrintDoc(string sXslFile, string printFiles, int id)
        {
            string htmlFileName = string.Empty;

            try
            {
                if (id == 0)
                {
                    htmlFileName = printFiles + @"\" + DateTime.Now.ToString("yyyy-MM-dd") + ".html";
                }
                else
                {
                    htmlFileName = printFiles + @"\" + DateTime.Now.ToString("yyyy-MM-dd") + "detail.html";
                }
                FileInfo htmlFile = new FileInfo(htmlFileName);
                if (htmlFile.Exists)
                {
                    if (System.Windows.MessageBox.Show(@"统计单已经存在,是否重新生成?", "提示",
                                                       System.Windows.MessageBoxButton.OKCancel, System.Windows.MessageBoxImage.Information) == System.Windows.MessageBoxResult.OK)
                    {
                        htmlFile.Delete();
                    }
                    else
                    {
                        return(htmlFileName);
                    }
                }
                //generate report
                string   reportFileName = "";
                DataView dview          = null;
                DBAccessProc.Schema.TrainManagementDataSet dataset = new DBAccessProc.Schema.TrainManagementDataSet();
                if (id == 0)
                {
                    dview = trainMangeDataSet.TraProcessInfoDataTable.DefaultView;
                    //dview.RowFilter = "PID_NO='" + sPidNo + "'AND EXAMID_NO='" + sExamidNo + "'AND EXAM_DT = '" +
                    //				  sExamDt + "'";
                    dview.Sort = "seq_no asc";
                    DataTable dv = dview.ToTable();
                    for (int i = 0; i < dv.Rows.Count; i++)
                    {
                        dataset.TraProcessInfoDataTable.ImportRow(dv.Rows[i]);
                    }
                }
                else
                {
                    dview = trainMangeDataSet.TraProcessPointsDataTable.DefaultView;
                    //dview.RowFilter = "PID_NO='" + sPidNo + "'AND EXAMID_NO='" + sExamidNo + "'AND EXAM_DT = '" +
                    //				  sExamDt + "'";
                    dview.Sort = "seq_no asc";
                    DataTable dv = dview.ToTable();
                    for (int i = 0; i < dv.Rows.Count; i++)
                    {
                        dataset.TraProcessPointsDataTable.ImportRow(dv.Rows[i]);
                    }
                }

                //PrintFormatController pfc = new PrintFormatController(m_sDBConn, m_sFilePath, seqNo, sExamidNo, sPidNo, "RE", "", nPrintFormatOption);
                var pfc = new PrintFormatController(printFiles, ref dataset);
                if (pfc != null)
                {
                    reportFileName = pfc.GePrtKm2ExamResultHtml(sXslFile, "统计表", id);
                }
                return(reportFileName);
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message, @"系统错误");
                return("");
            }
        }