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 { }
}
