Пример #1
0
    protected void BindApprovedPaymentInvoice()
    {
        try
        {
            int       rowcount = ucCustomPagerItems.isCountRecord;
            DataTable dtType   = new DataTable();
            objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Payment Planned", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Priority", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 8, 9 }, "Overdue", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 10, 11 }, "0 To 7 Days", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 12, 13 }, "8 to 14 Days", "HeaderStyle-center");
            objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "After 15 Days", "HeaderStyle-center");

            string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
            int?   sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
            {
                sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
            }
            Int16 AutoCheck = 0;
            if (chkAuto.Checked == true)
            {
                AutoCheck = 1;
            }
            else
            {
                AutoCheck = 0;
            }
            DataTable dt = BLL_POLOG_Register.POLOG_Get_Payment_Processing_Invoice_Search(UDFLib.ConvertStringToNull(ddlCurrency.SelectedValue), Convert.ToInt16(AutoCheck), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection
                                                                                          , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);


            if (ucCustomPagerItems.isCountRecord == 1)
            {
                ucCustomPagerItems.CountTotalRec = rowcount.ToString();
                ucCustomPagerItems.BuildPager();
            }

            //if (dt.Rows.Count > 0)
            //{
            divApprovedinvoice.Visible          = true;
            gvApprovedPaymentinvoice.DataSource = dt;
            gvApprovedPaymentinvoice.DataBind();
            gvApprovedPaymentinvoice.Rows[0].BackColor = System.Drawing.Color.Yellow;
            BindSupplierInvoice(dt.Rows[0]["Supplier_Code"].ToString());
            BindSupplierDetails(dt.Rows[0]["Supplier_Code"].ToString());
            txtSupplierCode.Text = dt.Rows[0]["Supplier_Code"].ToString();
            //}
            //else
            //{
            //    divApprovedinvoice.Visible = false;
            //    gvApprovedPaymentinvoice.DataSource = dt;
            //    gvApprovedPaymentinvoice.DataBind();
            //}
        }
        catch { }
        {
        }
    }