Пример #1
0
    public static void BindGrvEmpExclaim(GridView gvw, string ExClaim_No)
    {
        EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
        Hashtable           _htParameters           = null;

        try
        {
            _dalEmpExclaimDetailDAL       = new EmpExclaimDetailDAL();
            _htParameters                 = new Hashtable();
            _htParameters["p_ExClaim_No"] = ExClaim_No;

            DataTable dt = new DataTable();
            dt             = _dalEmpExclaimDetailDAL.GetRows(_htParameters);
            gvw.DataSource = dt;
            gvw.DataBind();

            if (dt.Rows.Count > 0)
            {
                decimal total = dt.AsEnumerable().Sum(row => row.Field <decimal>("Total_Cost"));
                gvw.FooterRow.Cells[14].Text            = "Total";
                gvw.FooterRow.Cells[14].HorizontalAlign = HorizontalAlign.Right;
                gvw.FooterRow.Cells[14].Font.Bold       = true;
                gvw.FooterRow.Cells[15].HorizontalAlign = HorizontalAlign.Right;
                gvw.FooterRow.Cells[15].Font.Bold       = true;
                gvw.FooterRow.Cells[15].Text            = total.ToString("N2");
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
Пример #2
0
    private void BindGridClaim()
    {
        EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
        Hashtable           _htParameters           = null;

        try
        {
            _dalEmpExclaimDetailDAL = new EmpExclaimDetailDAL();
            _htParameters           = new Hashtable();

            if (txtExClaim_No.Text != "")
            {
                //Shared.BindGrvEmpExclaim(grvExpenseClaimDetail, txtSPD_No.Text);
                _htParameters["p_ExClaim_No"] = txtExClaim_No.Text;
            }
            else
            {
                _htParameters["p_SPD_No"] = txtSPD_No.Text;
                //Shared.BindGrvEmpExclaim(grvExpenseClaimDetail, txtExClaim_No.Text);
            }

            DataTable dt = new DataTable();
            dt = _dalEmpExclaimDetailDAL.GetRows(_htParameters);
            grvExpenseClaimDetail.DataSource = dt;
            grvExpenseClaimDetail.DataBind();

            if (dt.Rows.Count > 0)
            {
                decimal total = dt.AsEnumerable().Sum(row => row.Field <decimal>("Total_Cost"));
                grvExpenseClaimDetail.FooterRow.Cells[5].Text            = "Total";
                grvExpenseClaimDetail.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
                grvExpenseClaimDetail.FooterRow.Cells[5].Font.Bold       = true;
                grvExpenseClaimDetail.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right;
                grvExpenseClaimDetail.FooterRow.Cells[6].Font.Bold       = true;
                grvExpenseClaimDetail.FooterRow.Cells[6].Text            = total.ToString("N2");
            }
        }
        catch (Exception ex)
        {
            Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
        }
    }