Example #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                RegistrationBiz biz = new RegistrationBiz();

                report.Load(Server.MapPath(base.ReportFilePath_Key + "RptOutLicense.rpt"));


                var dt = biz.GetLicenseReport(Request.QueryString["LicenseType"].ToString(), Request.QueryString["CompCode"].ToString(), Request.QueryString["DateStart"].ToString(), Request.QueryString["DateEnd"].ToString()).DataResponse.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    report.SetDataSource(dt);

                    string date_st = Utils.ConvertCustom.ConvertToTxtThai(Request.QueryString["DateStart"].ToString(), '/');
                    string date_en = Utils.ConvertCustom.ConvertToTxtThai(Request.QueryString["DateEnd"].ToString(), '/');

                    report.SetParameterValue("startdate", date_st);
                    report.SetParameterValue("enddate", date_en);


                    CrystalReportViewer1.ReportSource = report;
                }
                else
                {
                    Response.Write("ไม่พบข้อมูล");
                }
            }
            catch (Exception ex)
            {
                Response.Write("โปรดติดต่อผู้ดูแลระบบ");
                LoggerFactory.CreateLog().Fatal("LicenseReportViewer", ex);
            }
        }