我不知道如何计算avarage奖金 [英] I dont know how to calculate avarage prize

问题描述

public List<purchaseaccountbll> PurchaseAccountSelection()
        {
            DataTable dt = prl.SelectPurchaseAccount();
            List<purchaseaccountbll> purchase = new List<purchaseaccountbll>();
            foreach (DataRow row in dt.Rows)
            {
                PurchaseAccountBLL a = new PurchaseAccountBLL();
                a.Itemname = row["item_name"].ToString();
                a.Id = Convert.ToInt32(row["purchase_id"]);

                a.Purchase_Unit_Prize = Convert.ToDecimal(row["unit_prize"]);
                a.Purchase_Item_Quantity1 = Convert.ToDecimal(row["quantity"]);
                a.Purchase_Item_Discount1 = Convert.ToDecimal(row["discount"]);
                a.Purchase_Item_Total1 = Convert.ToDecimal(row["item_total"]);

               
                purchase.Add(a);
             }
            return purchase;
             }
       
        
        public List<stockpagebll> StockSelection()
        {
            DataTable dt = prl.StockSelection();
            List<stockpagebll> stock = new List<stockpagebll>();
            foreach (DataRow row in dt.Rows)
            {
                StockpageBLL add = new StockpageBLL();
                add.Id = Convert.ToInt32(row["item_id"]);
               add.Itemname = Convert.ToString(row["itemname"]);
                add.Item_Quantity1 = Convert.ToDecimal(row["quantity"]);
                add.Barcode = Convert.ToString(row["barcode"]);
                add.Category = Convert.ToString(row["category"]);

                add.ItemUnit_Prize1 = Convert.ToDecimal(row["unitPrize"]);
                add.Profit = Convert.ToDecimal(row["profit"]);

                
                StockpageDLL stk = new StockpageDLL(Profit,Id);
                stock.Add(add);

            }

            return stock;
            

        }

推荐答案

如果我理解你的问题，

If I understood your question correctly,

decimal total_prize = 0;
foreach (DataRow row in dt.Rows)
{
    PurchaseAccountBLL a = new PurchaseAccountBLL();
    a.Itemname = row["item_name"].ToString();
    a.Id = Convert.ToInt32(row["purchase_id"]);
    
    a.Purchase_Unit_Prize = Convert.ToDecimal(row["unit_prize"]);
    a.Purchase_Item_Quantity1 = Convert.ToDecimal(row["quantity"]);
    a.Purchase_Item_Discount1 = Convert.ToDecimal(row["discount"]);
    a.Purchase_Item_Total1 = Convert.ToDecimal(row["item_total"]);

    total_prize +=   Convert.ToDecimal(row["unit_prize"]);

    purchase.Add(a);
}
decimal avg = total_prize/dt.Rows.Count;   // this is your average

// user the avg value later...

-KR

-KR

这篇关于我不知道如何计算avarage奖金的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！