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