protected void ReportResultView_PageIndexChanging(object sender, GridViewPageEventArgs e) { SumChart.Visible = false; ReportResultView.DataSource = ViewState["ReportResultView"] as DataTable; ReportResultView.PageIndex = e.NewPageIndex; ReportResultView.DataBind(); // ViewState["ReportResultView"] = ReportResultView.DataSource as DataTable; }
protected void Page_Load(object sender, EventArgs e) { ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); scriptManager.RegisterPostBackControl(this.ExcelBtn); if (!IsPostBack) { startLabel.Text = DateTime.Now.ToString("dd/MM/yyyy"); endLabel.Text = DateTime.Now.ToString("dd/MM/yyyy"); staCalendar.SelectedDate = DateTime.Today.Date; endCalendar.SelectedDate = DateTime.Today.Date; bindGroupList(); bindReportList(); bindTime(); bindmonthlyreport(); if (ViewState["ReportResultView"] != null) { ReportResultView.DataSource = ViewState["ReportResultView"] as DataTable; ReportResultView.DataBind(); } } }
private void bindreportgrid() { DataTable dt = new DataTable(); if (ReportList.SelectedValue != "-1") { errorLabel.Visible = false; grpPanel.Visible = true; reportPanel.Visible = true; ReportResultView.Visible = true; SumChart.Visible = false; ExcelBtn.Visible = true; ReportNameLabel.Text = ReportList.SelectedItem.Text; int stahrs = Convert.ToInt32(StaTime.SelectedValue); int endhrs = Convert.ToInt32(EndTime.SelectedValue); DateTime st_date = staCalendar.SelectedDate.AddHours(stahrs); // Convert.ToDateTime(startLabel.Text); DateTime end_date = endCalendar.SelectedDate.AddHours(endhrs); //Convert.ToDateTime(endLabel.Text).AddHours(24); if (end_date < st_date) { end_date = st_date; EndTime.SelectedValue = StaTime.SelectedValue; } OracleQuery2 cc2 = new OracleQuery2(); string groupid = GroupList.SelectedValue; if (ReportList.SelectedValue == "1") { dt = cc2.LoadAllSMSReport(st_date, end_date, groupid); } else if (ReportList.SelectedValue == "2") { dt = cc2.LoadSMSReport(st_date, end_date, 1, groupid); } else if (ReportList.SelectedValue == "3") { dt = cc2.LoadSMSReport(st_date, end_date, 0, groupid); } else if (ReportList.SelectedValue == "5") { dt = cc2.LoadManualSMSReport(st_date, end_date); } if (dt != null && dt.Rows.Count > 0) { dt.Columns.Add("SEND_DATE_STR"); foreach (DataRow r in dt.Rows) { r["SEND_DATE_STR"] = ((DateTime)r["SEND_DATE"]).ToString("dd/MM/yyyy HH:mm:ss"); } ReportResultView.DataSource = dt; ReportResultView.DataBind(); NodataLabel.Visible = false; } else { ReportResultView.DataSource = null; ReportResultView.DataBind(); NodataLabel.Visible = true; } } else { errorLabel.Visible = true; } ViewState["ReportResultView"] = dt; }