protected void exportExcel2_Click(object sender, ImageClickEventArgs e) { ExportBiz export = new ExportBiz(); try { int total = lblRec.Text == "" ? 0 : lblRec.Text.ToInt(); if (total > base.EXCEL_SIZE_Key) { UCModalError.ShowMessageError = SysMessage.ExcelSizeError; UCModalError.ShowModalError(); UpdatePanelGv.Update(); } else { Dictionary <string, string> columns = new Dictionary <string, string>(); columns.Add("ลำดับ", "RUN_NO"); columns.Add("เลขบัตรประชาชน", "ID_CARD_NO"); columns.Add("วันที่สมัคร", "CREATED_DATE"); columns.Add("ชื่อ", "FIRSTNAME"); columns.Add("นามสกุล", "LASTNAME"); columns.Add("วันที่สอบ", "TESTING_DATE"); var biz = new BLL.PaymentBiz(); var res = biz.GetApplicantNoPayment(txtTestingDate.Text, txtTestingNo.Text, txtExamPlaceCode.Text, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), H_NOW_REQUEST.Value, 1, base.EXCEL_SIZE_Key, false); int[] colum = new int[] { 9 }; export.CreateExcel(res.DataResponse, columns); } } catch { } }
protected void BindDATAdetail(string GroupNo) { var biz = new BLL.PaymentBiz(); #region Page int PageSizeDetail = (txt_input.Text.Trim() != "") ? txt_input.Text.ToInt() : PageSize; int Rpage = (txt_Page_now.Text.Trim() == "") ? 0 : txt_Page_now.Text.Trim().ToInt(); int resultPage = (Rpage == 0) ? 1 : txt_Page_now.Text.Trim().ToInt(); resultPage = resultPage == 0 ? 1 : resultPage; var CountPage = biz.GetApplicantNoPayment(txtTestingDate.Text, txtTestingNo.Text.Trim(), txtExamPlaceCode.Text.Trim(), Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), GroupNo, resultPage, PageSizeDetail, true); if ((txt_input.Text.Trim() == null) || (txt_input.Text.Trim() == "") || (txt_input.Text.ToInt() <= 0)) { txt_input.Text = PageSizeDetail.ToString(); } else { PageSizeDetail = Convert.ToInt32(txt_input.Text); } if (CountPage.DataResponse != null) { if (CountPage.DataResponse.Tables[0].Rows.Count > 0) { Int32 totalROWs = Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString()); VisibleGV(gvApplicantNoPay, totalROWs, Convert.ToInt32(txt_input.Text), true); if (Rpage == 0) { NPbutton(btn_P, txt_Page_now, btn_N, "", lbltotalP); } } else { VisibleGV(gvApplicantNoPay, 0, Convert.ToInt32(txt_input.Text), true); if (Rpage == 0) { NPbutton(btn_P, txt_Page_now, btn_N, "", lbltotalP); } lbltotalP.Text = "1"; } } #endregion Page var res = biz.GetApplicantNoPayment(txtTestingDate.Text, txtTestingNo.Text, txtExamPlaceCode.Text, Convert.ToDateTime(txtStartPaidSubDate.Text), Convert.ToDateTime(txtEndPaidSubDate.Text), NOW_REQUEST, resultPage, PageSizeDetail, false); if (res.IsError) { var errorMsg = res.ErrorMsg; UCModalError.ShowMessageError = res.ErrorMsg; UCModalError.ShowModalError(); } else { gvApplicantNoPay.DataSource = res.DataResponse; gvApplicantNoPay.DataBind(); gvApplicantNoPay.Visible = true; gv2.Visible = true; exportExcel2.Visible = true; UpdatePanelGv.Update(); } detaiLL.Visible = false; detaiLL.Enabled = false; group_request.Text = Resources.propApplicantNoPay_group_request + GroupNo; }