Example #1
0
        void InitPreview(string companyName, string SubmitNo)
        {
            try
            {
                Report.ReportTable2 report = new Report.ReportTable2();
                report.sp_SelectTbSubmitWithSubmitNoTableAdapter.Fill(report.___sp_SelectTbSubmitWithSubmitNo_1.sp_SelectTbSubmitWithSubmitNo, companyName, SubmitNo);
                MainPreview.Model = new XtraReportPreviewModel(report);

                report.xrLebelID.Text      = SubmitNo;
                report.xrBarcodeID.Text    = SubmitNo;
                report.xrLebelCompany.Text = companyName;
                report.xrLebelDate.Text    = DateTime.Now.ToShortDateString();
                report.xrLabelCaption.Text = txtReportTitle.Text;

                var submitObj = visaORM.TB_TableSubmit.FirstOrDefault(s => s.FSubmitNo == SubmitNo);
                if (submitObj != null)
                {
                    report.xrLabelSysMemo.Text = submitObj.FSysMemo;
                }


                report.CreateDocument();
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
                Log.WriteLog.WriteErorrLog(ex);
            }
        }
Example #2
0
        void InitPreview(string companyName, string SubmitNo)
        {
            try
            {
                Report.ReportTable2 report = new Report.ReportTable2();
                report.sp_SelectTbSubmitWithSubmitNoTableAdapter.Fill(report.___sp_SelectTbSubmitWithSubmitNo_1.sp_SelectTbSubmitWithSubmitNo, companyName, SubmitNo);
                MainPreview.Model = new XtraReportPreviewModel(report);

                report.xrLebelID.Text = SubmitNo;
                report.xrBarcodeID.Text = SubmitNo;
                report.xrLebelCompany.Text = companyName;
                report.xrLebelDate.Text = DateTime.Now.ToShortDateString();
                report.xrLabelCaption.Text = txtReportTitle.Text;

                var submitObj = visaORM.TB_TableSubmit.FirstOrDefault(s => s.FSubmitNo == SubmitNo);
                if (submitObj != null)
                    report.xrLabelSysMemo.Text = submitObj.FSysMemo;

                report.CreateDocument();
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
                Log.WriteLog.WriteErorrLog(ex);
            }
        }