protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
int total = lblTotal.Text == "" ? 0 : Regex.Replace(lblTotal.Text, "[^0-9]", "").ToInt();
if (total > base.EXCEL_SIZE_Key)
{
UCModalError.ShowMessageError = SysMessage.ExcelSizeError;
UCModalError.ShowModalError();
UpdatePanelSearch.Update();
}
else
{
ExportBiz export = new ExportBiz();
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("ลำดับ", "RUN_NO");
columns.Add("ประเภทการชำระ", "PETITION_TYPE_NAME");
columns.Add("บัตรประชาชน", "ID_CARD_NO");
columns.Add("ชื่อ", "FIRST_NAME");
columns.Add("นามสกุล", "LASTNAME");
columns.Add("เลขที่ใบสั่งจ่าย", "group_request_no");
columns.Add("รหัสรอบสอบ", "TESTING_NO");
columns.Add("วันที่ออกใบสั่งจ่าย", "CREATED_DATE");
columns.Add("วันที่ชำระเงิน", "payment_date");
columns.Add("เลขที่ใบเสร็จ", "RECEIPT_NO");
List <HeaderExcel> header = new List <HeaderExcel>();
header.Add(new HeaderExcel
{
NameColumnsOne = "หน่วยงานจัดสอบ ",
ValueColumnsOne = ddlGroupExam.SelectedItem.Text,
NameColumnsTwo = "สนามสอบ ",
ValueColumnsTwo = ddlExamPlaceCode.SelectedItem.Text
});
header.Add(new HeaderExcel
{
NameColumnsOne = "วันที่สั่งจ่าย(เริ่ม) ",
ValueColumnsOne = txtStartDate.Text,
NameColumnsTwo = "วันที่สั่งจ่าย(สิ้นสุด) ",
ValueColumnsTwo = txtEndDate.Text
});
var biz = new BLL.PaymentBiz();
var res = biz.GetPaymentDetailByGroup(base.UserProfile.MemberType, ddlGroupExam.SelectedValue.ToString(),
ddlExamPlaceCode.SelectedValue.ToString(), Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), 1, base.EXCEL_SIZE_Key, false, base.UserProfile.CompCode);
export.CreateExcel(res.DataResponse.Tables[0], columns, header, base.UserProfile);
}
}
catch { }
}
private void BindDataInGridView(Boolean CountAgain)
{
var biz = new BLL.PaymentBiz();
// var resultPage = txtNumberGvSearch.Text.ToInt();
int Rpage = (txtNumberGvSearch.Text.Trim() == "") ? 0 : txtNumberGvSearch.Text.Trim().ToInt();
int resultPage = (Rpage == 0) ? 1 : txtNumberGvSearch.Text.Trim().ToInt();
resultPage = resultPage == 0 ? 1 : resultPage;
if ((rowPerpage.Text.Trim() == null) || (rowPerpage.Text.Trim() == "") || (Convert.ToInt32(rowPerpage.Text.Trim()) == 0))
{
rowPerpage.Text = (PageSize == 0)? Convert.ToString(PAGE_SIZE_Key): PageSize.ToString();
}
else
{
PageSize = Convert.ToInt32(rowPerpage.Text);
}
if (CountAgain)
{
#region Page
var CountPage = biz.GetPaymentDetailByGroup(base.UserProfile.MemberType, ddlGroupExam.SelectedValue.ToString(),
ddlExamPlaceCode.SelectedValue.ToString(), Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), resultPage, PageSize, true, base.UserProfile.CompCode);
if (CountPage.DataResponse != null)
{
if (CountPage.DataResponse.Tables[0].Rows.Count > 0)
{
Int64 totalROWs = Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString());
VisibleGV(gvSearch, totalROWs, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
}
else
{
VisibleGV(gvSearch, 0, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
txtTotalPage.Text = "1";
}
}
#endregion Page
}
var res = biz.GetPaymentDetailByGroup(base.UserProfile.MemberType, ddlGroupExam.SelectedValue.ToString(),
ddlExamPlaceCode.SelectedValue.ToString(), Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), resultPage, (PageSize == 0) ? PAGE_SIZE_Key : PageSize, false, base.UserProfile.CompCode);
if (res.IsError)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
bludDiv.Visible = true;
DataSet ds = res.DataResponse;
gvSearch.Visible = true;
gvSearch.DataSource = res.DataResponse;
gvSearch.DataBind();
UpdatePanelSearch.Update();
if (res.DataResponse.Tables[0].Rows.Count > 0)
{
btnExportExcel.Visible = true;
}
else
{
btnExportExcel.Visible = false;
}
}
}