private void LoadProduct()
    {
        try
        {
            DataTable dt = new DataTable();

            dt.Load(mOrder.USP_OrderDetailTemp_GetAllOrderID(Session["WOrderID"].ToString()));

            if (dt.Rows.Count > 0)
            {
                lblTax.Text = dt.Compute("SUM(VAT)", string.Empty).ToString();
                //lblSumOrder.Text = dt.Compute("SUM(Price)", string.Empty).ToString();
                //lblTotal.Text = dt.Compute("SUM(TotalPrice)", string.Empty).ToString();

                lblSumOrder.Text = Convert.ToInt32(dt.Compute("SUM(SubTotal)", String.Empty)).ToString("#,##");
                lblTotal.Text    = Convert.ToInt32(dt.Compute("SUM(TotalPrice)", String.Empty)).ToString("#,##");

                btnBuy.Visible = true;
                // Load
                rptOrder.DataSource = dt;
                rptOrder.DataBind();
            }
        }
        catch
        {
        }
    }
示例#2
0
    private void LoadProduct()
    {
        try
        {
            DataTable dt = new DataTable();
            dt.Load(mOrder.USP_OrderDetailTemp_GetAllOrderID(Session["WOrderID"].ToString()));
            if (dt.Rows.Count > 0)
            {
                lblQuantity.Text = dt.Compute("SUM(Quantity)", string.Empty).ToString();
            }

            // Load
            rptOrder.DataSource = dt;
            rptOrder.DataBind();
        }
        catch
        {
        }
    }