protected void btnExport_Click(object sender, EventArgs e) { int isfetch = 0; DataTable dtCtpList = BLL_PURC_CTP.Get_Ctp_Contract_List(UDFLib.ConvertStringToNull(uc_SupplierListCTP.SelectedValue), UDFLib.ConvertIntegerToNull(uc_Purc_DepartmentListctp.SelectedValue), UDFLib.ConvertDateToNull(txtEffdtFrom.Text), UDFLib.ConvertDateToNull(txtEffdtTo.Text), UDFLib.ConvertStringToNull(chkQtnStatus.SelectedValue), UDFLib.ConvertIntegerToNull(chkContractStatus.SelectedValue), UDFLib.ConvertIntegerToNull(ctlPortListctp.SelectedValue), UDFLib.ConvertStringToNull(txtItemSearch.Text), null, null, ref isfetch); string[] HeaderCaptions = new string[] { "Contract Code", "Effective Date", "Supplier Name", "Dept Name", "Catalogue Name", "Approved Item", "Not approved items", "Approved By", "Approved Date", "Status" }; string[] DataColumnsName = new string[] { "QTN_Contract_Code", "Effective_Date", "Full_NAME", "Dept_Name", "System_Description", "APPROVED_ITEM_COUNT", "NOT_APPROVED_ITEM_COUNT", "First_Name", "Approved_Date", "QTN_STS" }; string FileHeaderName = "Contract List"; string FileName = "Contract_List"; GridViewExportUtil.ShowExcel(dtCtpList, HeaderCaptions, DataColumnsName, FileName, FileHeaderName); }
protected void BindDataItems() { int is_Fetch_Count = ucCustomPagerctp.isCountRecord; gvContractList.DataSource = BLL_PURC_CTP.Get_Ctp_Contract_List(UDFLib.ConvertStringToNull(uc_SupplierListCTP.SelectedValue), UDFLib.ConvertIntegerToNull(uc_Purc_DepartmentListctp.SelectedValue), UDFLib.ConvertDateToNull(txtEffdtFrom.Text), UDFLib.ConvertDateToNull(txtEffdtTo.Text), UDFLib.ConvertStringToNull(chkQtnStatus.SelectedValue), UDFLib.ConvertIntegerToNull(chkContractStatus.SelectedValue), UDFLib.ConvertIntegerToNull(ctlPortListctp.SelectedValue), UDFLib.ConvertStringToNull(txtItemSearch.Text), ucCustomPagerctp.CurrentPageIndex, ucCustomPagerctp.PageSize, ref is_Fetch_Count); gvContractList.DataBind(); if (ucCustomPagerctp.isCountRecord == 1) { ucCustomPagerctp.CountTotalRec = is_Fetch_Count.ToString(); ucCustomPagerctp.BuildPager(); } }