protected void ImgExpExcel_Click(object sender, EventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } ChkStatus(); if (Session["sVesselCode"] == "0") { Session["sVesselCode"] = ddlVessel.SelectedValues; } if (Session["sAccountType"] == "0") { Session["sAccountType"] = ddlAccountType.SelectedValues; } if (Session["sAccClassification"] == "0") { Session["sAccClassification"] = ddlAccClassification.SelectedValues; } DataSet ds = BLL_POLOG_Register.POLOG_Get_Purchase_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), (DataTable)Session["sVesselCode"], (DataTable)Session["sAccountType"], (DataTable)Session["sAccClassification"], CurrStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900"), txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.Text) : Convert.ToDateTime("01/01/1900"), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , null, null, ref rowcount); string[] HeaderCaptions = { "PO Status", "PO Date", "PO Code", "ship Ref Code", "Acct", "Amount", "Cur", "PO USD Value", "Invoice USD Amount", "Paid USD Amount", "Outstanding PO Amount", "Supplier Name" }; string[] DataColumnsName = { "Line_Status", "Line_Date", "Office_Ref_Code", "ship_Ref_Code", "Account_Classification", "Line_Amount", "Line_Currency", "PO_USD_Value", "Invoice_USD_Amount", "Paid_USD_Amount", "OutStanding_USD_Amount", "Supplier_Name" }; GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "Purchasing_Report", "Purchasing Report", ""); }
public void BindGridView() { //try //{ objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6 }, "PO", "HeaderStyle-center"); ChkStatus(); int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } if (Session["sVesselCode"] == "0") { Session["sVesselCode"] = ddlVessel.SelectedValues; } if (Session["sAccountType"] == "0") { Session["sAccountType"] = ddlAccountType.SelectedValues; } if (Session["sAccClassification"] == "0") { Session["sAccClassification"] = ddlAccClassification.SelectedValues; } DataSet ds = BLL_POLOG_Register.POLOG_Get_Purchase_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), (DataTable)Session["sVesselCode"], (DataTable)Session["sAccountType"], (DataTable)Session["sAccClassification"], CurrStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900"), txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.Text) : Convert.ToDateTime("01/01/1900"), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { divPurchase.Visible = true; gvPurchase.DataSource = ds.Tables[0]; gvPurchase.DataBind(); Label lblTotOutPOCurAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotOutPOCurAmt1"); Label lblTotPOUSDValue1 = (Label)gvPurchase.FooterRow.FindControl("lblTotPOUSDValue1"); Label lblTotInvUSDAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotInvUSDAmt1"); Label lblTotPaidUSDAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotPaidUSDAmt1"); lblTotOutPOCurAmt1.Text = ds.Tables[1].Rows[0]["OutStanding_USD_Amount"].ToString(); lblTotPOUSDValue1.Text = ds.Tables[1].Rows[0]["PO_USD_Value"].ToString(); lblTotInvUSDAmt1.Text = ds.Tables[1].Rows[0]["Invoice_USD_Amount"].ToString(); lblTotPaidUSDAmt1.Text = ds.Tables[1].Rows[0]["Paid_USD_Amount"].ToString(); } else { divPurchase.Visible = false; gvPurchase.DataSource = ds.Tables[0]; gvPurchase.DataBind(); gvPurchase.EmptyDataText = "NO RECORDS FOUND"; } // } //catch { } //{ //} }