protected void Page_Load(object sender, EventArgs e) { try { RegisterLicenseBiz biz = new RegisterLicenseBiz(); report.Load(Server.MapPath(base.ReportFilePath_Key + "RptRegisterLicense.rpt")); DataTable tb = biz.ReportRegisterLicense(Request.QueryString["licensetype"].ToString(), Request.QueryString["comcode"].ToString(), Request.QueryString["startdate"].ToString(), Request.QueryString["enddate"].ToString()).Tables[0]; if (tb != null && tb.Rows.Count > 0) { report.SetDataSource(tb); report.SetParameterValue("startdate", Request.QueryString["startdate"].ToString()); report.SetParameterValue("enddate", Request.QueryString["enddate"].ToString()); CrystalReportViewer1.ReportSource = report; } else { Response.Write("ไม่พบข้อมูล.."); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { RegisterLicenseBiz biz = new RegisterLicenseBiz(); var res = biz.ReportRegisterLicenseStaticRatio(Request.QueryString["licensetype"].ToString(), Request.QueryString["startdate"].ToString(), Request.QueryString["enddate"].ToString(), Request.QueryString["startdate2"].ToString(), Request.QueryString["enddate2"].ToString()); if (res.IsError) { Response.Write("ไม่พบข้อมูลที่ค้นหา"); } else { report.Load(Server.MapPath("../Reports/RptLicenseStaticRatio.rpt")); report.SetDataSource(res.DataResponse.Tables[0]); report.SetParameterValue("startdate1", Convert.ToDateTime(Request.QueryString["startdate"].ToString()).ToLongDateString()); report.SetParameterValue("enddate1", Convert.ToDateTime(Request.QueryString["enddate"].ToString()).ToLongDateString()); report.SetParameterValue("startdate2", Convert.ToDateTime(Request.QueryString["startdate2"].ToString()).ToLongDateString()); report.SetParameterValue("enddate2", Convert.ToDateTime(Request.QueryString["enddate2"].ToString()).ToLongDateString()); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.DataBind(); } } catch { } }