protected void btnExportExcel_Click(object sender, ImageClickEventArgs e) { try { int total = lblTotalrecord.Text == "" ? 0 : lblTotalrecord.Text.ToInt(); if (total > base.EXCEL_SIZE_Key) { this.MasterSite.ModelError.ShowMessageError = SysMessage.ExcelSizeError; this.MasterSite.ModelError.ShowModalError(); UpdatePanelSearch.Update(); } else { ExportBiz export = new ExportBiz(); var biz = new BLL.PaymentBiz(); string IdParameter; if (base.UserProfile.MemberType == 1) { IdParameter = base.UserProfile.Id; } else { IdParameter = base.UserProfile.CompCode; } Dictionary <string, string> columns = new Dictionary <string, string>(); columns.Add("ลำดับ", "RUN_NO"); columns.Add("ใบสั่งจ่ายย่อย", "HEAD_REQUEST_NO"); columns.Add("ประเภทใบสั่งจ่าย", "PETITION_TYPE_NAME"); columns.Add("จำนวนคน", "PERSON_NO"); columns.Add("จำนวนเงิน", "SUBPAYMENT_AMOUNT"); columns.Add("วันที่จ่ายย่อย", "SUBPAYMENT_DATE"); var res = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, 1, base.EXCEL_SIZE_Key, "N"); export.CreateExcel(res.DataResponse, columns); } } catch { } }
protected void BindPage() { PAGE_SIZE = Convert.ToInt32(txtInputMaxrow.Text); var biz = new BLL.PaymentBiz(); var resultPage = txtNumberGvSearch.Text.ToInt(); string IdParameter; if (base.UserProfile.MemberType == 1) { IdParameter = base.UserProfile.Id; } else { IdParameter = base.UserProfile.CompCode; } var res = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, resultPage, PAGE_SIZE, "N"); gvPaymentAssimilate.Visible = true; gvPaymentAssimilate.DataSource = res.DataResponse; gvPaymentAssimilate.DataBind(); boxresult.Visible = true; }
private void GetDataInGridView() { PAGE_SIZE = Convert.ToInt32(txtInputMaxrow.Text); txtNumberGvSearch.Text = "1"; var biz = new BLL.PaymentBiz(); var resultPage = txtNumberGvSearch.Text.ToInt(); string IdParameter; if (base.UserProfile.MemberType == 1) { IdParameter = base.UserProfile.Id; } else { IdParameter = base.UserProfile.CompCode; } if (txtCompany.Text == "") { txtID.Text = ""; } var resCount = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, resultPage, PAGE_SIZE, "Y"); DataSet ds = resCount.DataResponse; DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; int rowcount = Convert.ToInt32(dr["rowcount"].ToString()); double dblPageCount = (double)((decimal)rowcount / PAGE_SIZE); TotalPages = (int)Math.Ceiling(dblPageCount); txtTotalPage.Text = Convert.ToString(TotalPages); var res = biz.GetGroupPayment(IdParameter, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), Convert.ToString(base.UserProfile.MemberType), txtID.Text, resultPage, PAGE_SIZE, "N"); string date1 = txtStartPaidSubDate.Text; string date2 = txtEndPaidSubDate.Text; gvPaymentAssimilate.Visible = true; gvPaymentAssimilate.DataSource = res.DataResponse; gvPaymentAssimilate.DataBind(); if (res.IsError) { this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg; this.MasterSite.ModelError.ShowModalError(); } else { if (gvPaymentAssimilate.Rows.Count == 0) { btnOk.Visible = false; txtNumberGvSearch.Visible = true; lblParaPage.Visible = true; txtTotalPage.Visible = true; btngo.Visible = true; lblTotalrecord.Text = "0"; txtInputMaxrow.Visible = true; lblHeadInputMaxrow.Visible = true; lblHeadTotal.Visible = true; lblTotalrecord.Visible = true; lblEndTotal.Visible = true; txtTotalPage.Text = "1"; CheckBox Chall = (CheckBox)gvPaymentAssimilate.HeaderRow.FindControl("checkall"); Chall.Visible = false; } else { CheckBox Chall = (CheckBox)gvPaymentAssimilate.HeaderRow.FindControl("checkall"); Chall.Visible = true; btnOk.Visible = true; btnExportExcel.Visible = true; } boxresult.Visible = true; UpdatePanelSearch.Update(); if (TotalPages > 1) { txtNumberGvSearch.Visible = true; lblParaPage.Visible = true; txtTotalPage.Visible = true; btnNextGvSearch.Visible = true; btnPreviousGvSearch.Visible = false; btngo.Visible = true; txtInputMaxrow.Visible = true; lblHeadInputMaxrow.Visible = true; lblHeadTotal.Visible = true; lblTotalrecord.Visible = true; lblEndTotal.Visible = true; lblTotalrecord.Text = dr["rowcount"].ToString(); } else if (TotalPages == 1) { txtNumberGvSearch.Visible = true; lblParaPage.Visible = true; txtTotalPage.Visible = true; btnNextGvSearch.Visible = false; btnPreviousGvSearch.Visible = false; btngo.Visible = true; lblTotalrecord.Text = dr["rowcount"].ToString(); txtInputMaxrow.Visible = true; lblHeadInputMaxrow.Visible = true; lblHeadTotal.Visible = true; lblTotalrecord.Visible = true; lblEndTotal.Visible = true; } Detaill.Visible = true; } if (base.UserProfile.MemberType == DTO.RegistrationType.OIC.ToInt() || base.UserProfile.MemberType == DTO.RegistrationType.OICAgent.ToInt()) { btnOk.Visible = false; gvPaymentAssimilate.Columns[0].Visible = false; } }