protected void Page_Load(object sender, EventArgs e) { lblError.Text = string.Empty; try { string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string date = DateTime.Now.Day.ToString(); string hours = DateTime.Now.Hour.ToString(); string minute = DateTime.Now.Minute.ToString(); string second = DateTime.Now.Second.ToString(); string fileName = year + month + date + hours + minute + second; DisableFormat disable = new DisableFormat(); disable.DisableUnwantedExportFormat(rptView, "PDF"); disable.DisableUnwantedExportFormat(rptView, "WORD"); SqlConnection con = new SqlConnection(); try { con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString(); con.Open(); string projectCode = Request.QueryString["ProjectCode"]; string customerName_LIKE = Request.QueryString["CustomerName_LIKE"]; if (string.IsNullOrWhiteSpace(projectCode)) { throw new Exception("No Project Code."); } DataTable dt_Header = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_Header]", projectCode, customerName_LIKE); DataTable dt_TAT = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_TAT]", projectCode, customerName_LIKE); DataTable dt_Documents = StoredProcedureAsDataTable(con, "[dbo].[Rpt_TAT_Report_FinancingApproval_Documents]", projectCode, customerName_LIKE); rptView.LocalReport.DataSources.Clear(); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_Header", dt_Header)); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_TAT", dt_TAT)); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetTATReportFinancingApproval_Documents", dt_Documents)); rptView.LocalReport.DisplayName = "Report_TAT_FinancingApproval_" + fileName; rptView.LocalReport.Refresh(); rptView.Visible = true; } finally { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } } catch (Exception ex) { lblError.Text = ex.Message + " " + ex.StackTrace; } }
protected void Page_Load(object sender, EventArgs e) { string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string date = DateTime.Now.Day.ToString(); string hours = DateTime.Now.Hour.ToString(); string minute = DateTime.Now.Minute.ToString(); string second = DateTime.Now.Second.ToString(); string fileName = year + month + date + hours + minute + second; DisableFormat disable = new DisableFormat(); disable.DisableUnwantedExportFormat(rptView, "PDF"); disable.DisableUnwantedExportFormat(rptView, "WORD"); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString(); try { con.Open(); string dateFrom = Request.QueryString["SubmitDateFrom"]; string dateTo = Request.QueryString["SubmitDateTo"]; string code = Request.QueryString["ProjectCode"]; string customer = Request.QueryString["Customer"]; string productId = Request.QueryString["MProductTypeId"]; string approve_Date = Request.QueryString["BoDDecisionDate"]; DataTable myDt = new DataTable(); myDt = dtReport(con, dateFrom, dateTo, code, customer, Convert.ToInt32(productId), approve_Date); rptView.LocalReport.DataSources.Clear(); rptView.LocalReport.DataSources.Add( new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", myDt)); rptView.LocalReport.DisplayName = "Report_PAM_" + fileName; rptView.LocalReport.Refresh(); rptView.Visible = true; } catch (Exception ex) { lblError.Text = ex.Message + " " + ex.StackTrace; } finally { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string date = DateTime.Now.Day.ToString(); string hours = DateTime.Now.Hour.ToString(); string minute = DateTime.Now.Minute.ToString(); string second = DateTime.Now.Second.ToString(); string fileName = year + month + date + hours + minute + second; DisableFormat disable = new DisableFormat(); disable.DisableUnwantedExportFormat(rptView, "PDF"); disable.DisableUnwantedExportFormat(rptView, "WORD"); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString(); try { con.Open(); string PeriodStart = Request.QueryString["PeriodStart"]; string PeriodEnd = Request.QueryString["PeriodEnd"]; DataTable dt_perdirectorate = dtReport(con, "[dbo].[Rpt_TAT_Report_CM_perPeriodic_SP]", PeriodStart, PeriodEnd); DataTable dt_TAT = dtReport(con, "[dbo].[Rpt_SUM_TAT_Report_CM_Periodic_SP]", PeriodStart, PeriodEnd); rptView.LocalReport.DataSources.Clear(); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetPeriodic", dt_perdirectorate)); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSetSumTAT", dt_TAT)); rptView.LocalReport.DisplayName = "Report_TAT_CM_perPeriodic_" + fileName; rptView.PageCountMode = PageCountMode.Actual; rptView.LocalReport.Refresh(); rptView.Visible = true; } catch (Exception ex) { lblError.Text = ex.Message + " " + ex.StackTrace; } finally { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } } }
protected void Page_Load(object sender, EventArgs e) { string year = DateTime.Now.Year.ToString(); string month = DateTime.Now.Month.ToString(); string date = DateTime.Now.Day.ToString(); string hours = DateTime.Now.Hour.ToString(); string minute = DateTime.Now.Minute.ToString(); string second = DateTime.Now.Second.ToString(); string fileName = year + month + date + hours + minute + second; DisableFormat disable = new DisableFormat(); disable.DisableUnwantedExportFormat(rptView, "PDF"); disable.DisableUnwantedExportFormat(rptView, "WORD"); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["IIFConnectionString"].ToString(); try { con.Open(); string projectCode = Request.QueryString["ProjectCode_LIKE"]; string CustomerName = Request.QueryString["CustomerName_Like"]; string CmNumber = Request.QueryString["CmNumber_LIKE"]; DataTable dt_perdirectorate = dtReport(con, "[dbo].[Rpt_TAT_Report_CM_perDirectorate_SP]", projectCode, CustomerName, CmNumber); DataTable dt_TAT = dtReport(con, "[dbo].[Rpt_SUM_TAT_Report_CM_perDirectorate_SP]", projectCode, CustomerName, CmNumber); rptView.LocalReport.DataSources.Clear(); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSet_CM_Directorate", dt_perdirectorate)); rptView.LocalReport.DataSources.Add(new ReportDataSource("DataSet_SUM_TAT_Directorate", dt_TAT)); rptView.LocalReport.DisplayName = "Report_TAT_CM_perDirectorate_" + fileName; rptView.LocalReport.Refresh(); rptView.Visible = true; } catch (Exception ex) { lblError.Text = ex.Message + " " + ex.StackTrace; } finally { if (con.State == ConnectionState.Open) { con.Close(); con.Dispose(); } } }