コード例 #1
0
        private void LoadMemberOutstandingList()
        {
            int FinYrId  = Convert.ToInt32(Session["FinYrID"].ToString());
            int MemberId = Convert.ToInt32(ddlMember.SelectedValue);

            if (MemberId != 0)
            {
                BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment();
                DataTable dt = objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId);
                dgvMemberOutstanding.DataSource = dt;
                dgvMemberOutstanding.DataBind();
                PaymentAmount = 1;//Convert.ToDecimal(dt.Compute("Sum(FeesOutstandingAmount)", string.Empty)) +
                //Convert.ToDecimal(dt.Compute("Sum(TaxOutstandingAmount)", string.Empty));
            }
            else
            {
                dgvMemberOutstanding.DataSource = null;
                dgvMemberOutstanding.DataBind();
            }
        }
        private void LoadMemberOutstandingList()
        {
            int FinYrId  = Convert.ToInt32(Session["FinYrID"].ToString());
            int MemberId = Convert.ToInt32(ddlMember.SelectedValue);

            if (MemberId != 0)
            {
                BusinessLayer.Common.MemberPayment objMemberPayment = new BusinessLayer.Common.MemberPayment();
                DataView DV = new DataView(objMemberPayment.GetOutstanding(MemberId, PaymentId, FinYrId));
                DV.RowFilter = "FeesHeadId IN (1,2)";
                DataTable dt = new DataTable();
                dt = DV.ToTable();
                if (dt != null)
                {
                    dgvMemberOutstanding.DataSource = dt;
                    dgvMemberOutstanding.DataBind();
                }
            }
            else
            {
                dgvMemberOutstanding.DataSource = null;
                dgvMemberOutstanding.DataBind();
            }
        }