コード例 #1
0
        private void GetIncomeReport()
        {
            ShoppingCart k = new ShoppingCart()
            {
                Flag=Convert.ToInt32(rblIncomeFilter.SelectedValue)
            };
            DataTable dt=k.GetIncomeReport();

            if(dt.Rows.Count>0)
            {
                gvIncomeReport.Visible=true;
                gvIncomeReport.DataSource=dt;
                gvIncomeReport.DataBind();

                object ProductSold;
                ProductSold=dt.Compute("Sum(TotalProducts)" , "" );

                object TotalIncome;
                TotalIncome=dt.Compute("Sum(TotalPrice)" , "" );
            }else {
                gvIncomeReport.Visible = false;
                lblIncome.Text = "No Products Income";
            }
        }