コード例 #1
0
    private void BindGridView(string index)
    {
        _invmstr.InvoiceId = Convert.ToInt16(index);
        _dt = _sobj.SelectInvoiceById(_invmstr);
        foreach (DataRow row in _dt.Rows)
        {
            lblInvoiceNo.Text    = row["InvoiceNo"].ToString();
            lblCustName.Text     = row["CustomerName"].ToString();
            lblCustAddress.Text  = row["Address"].ToString();
            lblCustMobileNo.Text = row["PhoneNo"].ToString();
            lblInvoiceDate.Text  = Convert.ToDateTime(row["CreatedDate"]).ToString("d MMMM, yyyy");
            lblCustEmail.Text    = row["EmailId"].ToString();
            lblSubTotal.Text     = row["SubTotalAmount"].ToString();
            if (row["TaxName1"].ToString() == "")
            {
                lblTaxName1.Visible = false;
                lblTaxRate1.Visible = false;
            }
            else
            {
                lblTaxName1.Text = "Tax (" + row["TaxName1"].ToString() + " %):";
                lblTaxRate1.Text = row["TaxRate1"].ToString();
            }
            if (row["TaxName2"].ToString() == "")
            {
                lblTaxName2.Visible = false;
                lblTaxRate2.Visible = false;
            }
            else
            {
                lblTaxName2.Text = "Tax (" + row["TaxName2"].ToString() + " %):";
                lblTaxRate2.Text = row["TaxRate2"].ToString();
            }
            lblDiscount.Text       = row["DiscountRate"].ToString();
            lblAdditionCharge.Text = row["AdditionCharge"].ToString();
            lblTotalAmount.Text    = row["NetAmount"].ToString();
            lblComment.Text        = row["Comment"].ToString();
            lblSalePersonName.Text = row["SalePersonName"].ToString();
            if (row["PaymentStatus"].ToString() == "True")
            {
                lblPaymentStatus.Text = "Paid";
            }
            else
            {
                lblPaymentStatus.Text = "UnPaid";
            }
        }

        _invdtl.InvoiceId = Convert.ToInt16(index);
        _dt = _sobj.SelectInvoiceDetailById(_invdtl);
        gvItem.DataSource = _dt;
        gvItem.DataBind();
        gvItem.Enabled = false;

        _invpay.InvoiceId = Convert.ToInt16(index);
        _dt = _sobj.SelectInvoicePaymentById(_invpay);
        foreach (DataRow row in _dt.Rows)
        {
            lblPaymentMethod.Text        = row["PaymentMethod"].ToString();
            lblPaymentMethod.Visible     = true;
            lblPaymentMethodName.Visible = true;
            lblPayDate.Text        = Convert.ToDateTime(row["PaymentDate"]).ToString("d MMMM, yyyy");
            lblPayDateName.Visible = true;
            lblPayDate.Visible     = true;
            if (row["CardNo"].ToString() == "")
            {
                lblCardName.Visible = false;
                lblCardNo.Visible   = false;
            }
            else
            {
                lblCardName.Visible = true;
                lblCardNo.Visible   = true;
                lblCardNo.Text      = row["CardNo"].ToString();
            }
        }
    }