public frmPreviewReport(int id, string reportCode, string site) { InitializeComponent(); using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { ClsReportDocument.reportDoc rptDoc = new ClsReportDocument.reportDoc(); ClsReportDocument cls = new ClsReportDocument(); ReportDocument rpt = new ReportDocument(); if (reportCode == "AV103") { rptDoc = cls.rptDoc("AV103"); rpt = rptDoc.report; rpt.SetParameterValue("@tram_id", id); } else if (reportCode == "AV104") { rptDoc = cls.rptDoc("AV104"); rpt = rptDoc.report; rpt.SetParameterValue("@trvh_id", id); rpt.SetParameterValue("@dept", site); } struReport stRpt = cdc.mst_reports.Where(x => x.mrt_code == reportCode && x.mrt_status == 'A' && DateTime.Today.Date >= x.mrt_effective_date.Value.Date && DateTime.Today.Date <= (x.mrt_expire_date == null ? DateTime.Today.Date : x.mrt_expire_date.Value.Date)) .Select(x => new struReport() { reportNameTH = x.mrt_tname, reportNameEng = x.mrt_ename, reportCode = reportCode, reportDoc = rpt }).FirstOrDefault(); if (report == null) { report = new List <struReport>(); } report.Add(stRpt); if (report != null) { currentReport = report.First(); crystalReportViewer1.ReportSource = _currentReport.reportDoc; } cls.Dispose(); } this.Top = Screen.PrimaryScreen.WorkingArea.Top; this.Left = Screen.PrimaryScreen.WorkingArea.Left; this.Size = Screen.PrimaryScreen.WorkingArea.Size; _propertyReport prop = new _propertyReport() { tpr_id = 0, showSelectCopy = false, defaultCopy = 0, printOutBarcodePrinter = false }; this.propertyReport = prop; this.ShowDialog(); }
public frmPreviewReport(int tpr_id, List <string> reportCode) { InitializeComponent(); _propertyReport prop = new _propertyReport() { tpr_id = tpr_id, reportCode = reportCode }; this.propertyReport = prop; //previewReport(); }
public frmPreviewReport(int tpr_id, List <string> reportCode, bool printOutBarcodePrinter) { InitializeComponent(); _propertyReport prop = new _propertyReport() { tpr_id = tpr_id, reportCode = reportCode, printOutBarcodePrinter = printOutBarcodePrinter }; this.propertyReport = prop; //previewReport(); }
public frmPreviewReport(int tpr_id, List <string> reportCode, bool showSelectCopy, int?defaultCopy) { InitializeComponent(); _propertyReport prop = new _propertyReport() { tpr_id = tpr_id, reportCode = reportCode, showSelectCopy = showSelectCopy, defaultCopy = defaultCopy }; this.propertyReport = prop; //previewReport(); }
public frmPreviewReport(int tpr_id, string queueNo) { InitializeComponent(); ClsReportDocument.reportDoc rptDoc = new ClsReportDocument.reportDoc(); ClsReportDocument cls = new ClsReportDocument(); rptDoc = cls.rptDoc("RG000"); using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { ReportDocument rpt = rptDoc.report; rpt.SetParameterValue("@tpr_id", tpr_id); rpt.SetParameterValue("@print_user", getNameUser()); rpt.SetParameterValue("@mrt_code", "RG000"); //setParameter(ref rpt, _propReport.reportCode.First()); rpt.SetParameterValue("@Queue", queueNo); struReport stRpt = cdc.mst_reports.Where(x => x.mrt_code == "RG000" && x.mrt_status == 'A' && DateTime.Today.Date >= x.mrt_effective_date.Value.Date && DateTime.Today.Date <= (x.mrt_expire_date == null ? DateTime.Today.Date : x.mrt_expire_date.Value.Date)) .Select(x => new struReport() { reportNameTH = x.mrt_tname, reportNameEng = x.mrt_ename, reportCode = "RG000", reportDoc = rpt }).FirstOrDefault(); if (report == null) { report = new List <struReport>(); } report.Add(stRpt); if (report != null) { currentReport = report.First(); crystalReportViewer1.ReportSource = _currentReport.reportDoc; } } this.Top = Screen.PrimaryScreen.WorkingArea.Top; this.Left = Screen.PrimaryScreen.WorkingArea.Left; this.Size = Screen.PrimaryScreen.WorkingArea.Size; _propertyReport prop = new _propertyReport() { tpr_id = tpr_id, showSelectCopy = true, defaultCopy = 1, printOutBarcodePrinter = true }; this.propertyReport = prop; this.Activated += new EventHandler(activateForShowCopy); this.ShowDialog(); //return rpt; //using (InhCheckupDataContext cdc = new InhCheckupDataContext()) //{ // string path = cdc.mst_reports.Where(x => x.mrt_code == "").Select(x => x.mrt_path_file + x.mrt_file_name; // rpt.Load(""); // rpt.SetParameterValue("", ""); // rpt.SetParameterValue("", ""); // rpt.SetParameterValue("", ""); // rpt.SetParameterValue("@Queue", queueNo); //} }