数据相加

在做项目的时候，需要把数据库的某一列数据相加得出一个总额。比如充值金额，要算出个充值总额。我就通过通过for循环相加得出总额。下面的代码可能不太完善，仅供参考。
先把你需要的数据查询出来
控制器方法：

    public ActionResult SelectRecharge(LayuiTablePage layuiTablePage)
            {
                var listStu = (from tbRecharge in myEntities.B__Recharge
                              
                               orderby tbRecharge.RechargeID descending
                               select new pwRecharge//构建的实体类
                               {
                                   RechargeTypeID = tbRechargeType.RechargeTypeID,
                                  
                                   RechargeTypeName = tbRechargeType.RechargeTypeName,
                                  
                                   TransactionNumber = tbRecharge.TransactionNumber,
                                   RechargeAmount = tbRecharge.RechargeAmount,
                                   RechargeHandling = tbRecharge.RechargeHandling,
                                   CollectedBalances = tbRecharge.CollectedBalances,
                                   RechargeState = tbRecharge.RechargeState,
                                   OperationTime = tbRecharge.OperationTime.ToString(),
                                   OperationTimes = tbRecharge.OperationTime,
                                   AuditRemark = tbRecharge.AuditRemark,
                                   OperationIP = tbRecharge.OperationIP,
                               }).ToList();
                
    
    
                ///然后把你要加起来的数据通过for循环相加
                var StrRechargeAmount = 0;
                for (int i = 0; i < listStu.Count(); i++)
                {
                    StrRechargeAmount = StrRechargeAmount + Convert.ToInt32(listStu[i].RechargeAmount);
                }

          ///session储存数据
            Session["StrRechargeAmount"] = StrRechargeAmount;
         ///查询出来的数据通过for循环相加
            var StrRechargeHandling = 0;
            for (int i = 0; i < listStu.Count(); i++)
            {
                StrRechargeHandling = StrRechargeHandling + Convert.ToInt32(listStu[i].RechargeHandling);
            }
            Session["StrRechargeHandling"] = StrRechargeHandling;
            
        }

页面代码：session读取数据

<button type="button" class="btn btn-info btn-sm mr-2">
                            充值总金额: <span class="badge badge-success" id="StrRechargeAmount">@Session["StrRechargeAmount"]</span>
                        </button>