コード例 #1
0
    protected void BindGrid()
    {
        try
        {
            objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Verified", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 16, 17 }, "Approved", "HeaderStyle-center");
            int       rowcount = ucCustomPagerItems.isCountRecord;
            DataTable dtType   = ChkType();
            string    urgent   = null;
            if (chkUrgent.Checked == true)
            {
                urgent = "YES";
            }

            string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
            int?   sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
            {
                sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
            }
            ChkStatus();
            //string  ReqsnStatus = hdfSelectedStageValue.Value;
            DataSet ds = BLL_POLOG_Register.POLOG_Get_Pending_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue),
                                                                             UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), CurrStatus, urgent, dtType, 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)
            {
                //btnApprove.Visible = true;
                gvPendinginvoice.DataSource = ds.Tables[0];
                gvPendinginvoice.DataBind();
            }
            else
            {
                // btnApprove.Visible = false;
                gvPendinginvoice.DataSource = ds.Tables[0];
                gvPendinginvoice.DataBind();
                gvPendinginvoice.EmptyDataText = "NO RECORDS FOUND";
            }
        }
        catch { }
        {
        }
    }