计算金额
今天给大家分享的功能是计算金额
效果图:
数据库数据:
MVC代码:
public ActionResult SelectMoney(int ID)//计算配件采购明细的金额总和
{
var Money = myModels.B_PurchaseDetail.Where(m => m.PurchaseID == ID).Sum(m => m.Money);
return Json(Money, JsonRequestBehavior.AllowGet);
}
JQuery代码:
function Money(data) {
var ID = data.PurchaseID;
var money = 0;
$.ajaxSettings.async = false;
$.post("SelectMoney", { ID: ID }, function (data) {
money = data;
});
if (money != 0) {
return "<label>" + money + ".00</label>";
} else {
return "<label>0.00</label>";
}
}