用临时列表进行统计

下面我来介绍一下如何用临时列表来进行各种类型的统计。

代码如下图所示：

 

 

public ActionResult nianfentongji(BsgridPage bsgridPage)//年份统计
        {

            List<tongji> myLists = new List<tongji>();//声明一个临时列表
            if (Session["myLists"] != null)
            {
                myLists = Session["myLists"] as List<tongji>;
            }
            var Date = myModel.YW_Sell.OrderByDescending(m => m.Data).Where(m=>m.SellstateID==3).Select(T => T.Data).ToList();
            
            List<string> list2 = new List<string>();//声明一个string临时列表
            for (int i = 0; i < Date.Count; i++)
            {
                string str = Convert.ToDateTime(Date[i]).ToString("yyyy");
                list2.Add(str);//添加到string临时列表
            }
            list2=list2.Distinct().ToList();//获取到的年份去重复
            List<tongji> tongji = new List<VO.tongji>();
            for (int i = 0; i < list2.Count; i++)
            {
                tongji tong = new tongji();
                tong.Name = list2[i];
                tongji.Add(tong);
            }
            for (int i = 0; i < tongji.Count; i++)
            {
                var time = tongji[i].Name;
                
                var list = (from tbSelldetails in myModel.YW_Selldetails
                            join tbSell in myModel.YW_Sell on tbSelldetails.SellID equals tbSell.SellID
                            join tbcommoditydetail in myModel.SYS_commoditydetail on tbSelldetails.CommoditydetailID equals tbcommoditydetail.CommoditydetailID
                            join tbcommodity in myModel.PW_commodity on tbcommoditydetail.commodityID equals tbcommodity.commodityID
                            join tbBrand in myModel.BS_Brand on tbcommodity.BrandID equals tbBrand.BrandID
                            where tbSell.Data.ToString().Trim().Contains(time.Trim())&&tbSell.SellstateID==3
                            select new tongji
                            {
                                bb = tbSelldetails.Amount * tbcommodity.DiscountPrice,
                                Amount = tbSelldetails.Amount,
                                cc = tbSelldetails.Amount * tbcommoditydetail.Stockprice,
                            }).ToList();
                var alldd = (int)list.Sum(m => m.Amount);
                var allbb = (decimal)list.Sum(m => m.bb);
                var allcc = (decimal)list.Sum(m => m.cc);
                tongji listFile = new tongji
                {
                    Name = tongji[i].Name,
                    alldd = alldd,
                    allbb = allbb,
                    allcc = allcc,
                    maolijine = allbb - allcc,
                    maolili1 = ((allbb - allcc) / allbb)
                };
                myLists.Add(listFile);//添加到临时列表
                Session["listFile"] = myLists;

            }
            if (myLists != null)
            {
                int EndIndex = bsgridPage.GetEndIndex();
                if (EndIndex >= myLists.Count)
                {
                    EndIndex = myLists.Count - 1;
                }
                List<tongji> list = new List<tongji>();
                for (int i = bsgridPage.GetStartIndex(); i <= EndIndex; i++)
                {
                    list.Add(myLists[i]);
                }
                Bsgrid<tongji> bsgrid = new Bsgrid<tongji>();
                if (myLists != null)
                {
                    bsgrid.totalRows = myLists.Count;
                }
                else
                {
                    bsgrid.totalRows = 0;
                }
                bsgrid.success = true;

                bsgrid.curPage = bsgridPage.curPage;

                bsgrid.data = list;

                return Json(bsgrid, JsonRequestBehavior.AllowGet);
            }
            return Json("", JsonRequestBehavior.AllowGet);

        }

代码仅跟参考，谢谢。