累计计算方法,把数据加载到页面,会自动把页面的数据累计起来,例如把页面上的金额累计出总数,如图
代码如下,把数据查出来
public ActionResult selectConsumptionss(LayuiTablePage layuiTablePage, int ItemNameIDs)
{
List<ConsumptionDetai> listConsumptionDetail = (from tbR in myModel.R_GuestRoomConsumptionDetail
join tbG in myModel.S_GuestRoom on tbR.GuestRoomID equals tbG.GuestRoomID
join tbI in myModel.S_ItemName on tbR.ItemNameID equals tbI.ItemNameID
where tbR.GuestRoomID == ItemNameIDs
select new ConsumptionDetai
{
GuestRoomConsumptionDetailID = tbR.GuestRoomConsumptionDetailID,
GuestRoomID = tbG.GuestRoomID,
RoomNumber = tbG.RoomNumber,
ItemName = tbI.ItemName,
UnitPricess = tbR.UnitPricess.ToString(),
ConsumptionQuantity = tbR.ConsumptionQuantity,
Sum = tbR.Sum.ToString(),
discounties = tbR.discounties,
ConsumptionDate = tbR.ConsumptionDate.ToString(),
}).ToList();
int intTotalRow = listConsumptionDetail.Count();
根据总条数,for循环,会把每条数据的金额都累计起来,用 Session["Sums"] = Sums;来接受数据
decimal? Sums = 0; //累计消费
for (int i = 0; i < listConsumptionDetail.Count; i++)
{
Sums += Convert.ToDecimal(listConsumptionDetail[i].UnitPricess) * Convert.ToDecimal(listConsumptionDetail[i].ConsumptionQuantity) * Convert.ToDecimal(listConsumptionDetail[i].discounties);
}
Session["Sums"] = Sums;
List<ConsumptionDetai> list = listConsumptionDetail.ToList();
return Json(listConsumptionDetail, JsonRequestBehavior.AllowGet);
}
}
再写个方法调用Session["Sums"] = Sums;
public ActionResult showleijis()
{
decimal leijis = Convert.ToDecimal(Session["Sums"]); //调用 Session["Sums"]
return Json(leijis, JsonRequestBehavior.AllowGet);
}
然后到视图这边提交数据
$.post("/KfFroom/FangTaitu/showleijis", function (data) {
$("#LeiJi").val(data);
});