/// <summary> /// 根据项目代码获取额度核销总金额 /// </summary> /// <param name="code"></param> /// <returns></returns> public decimal GetHXsumByCode(string code) { decimal sum = 0; var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjcode", code)) .Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0)) .Add(ORMRestrictions <System.Int32> .NotEq("FIfpurchase", 1)); IList <ExpenseMstModel> ExpenseMstList = ExpenseMstFacade.Find(dicWhere).Data; if (ExpenseMstList.Count > 0) { for (var i = 0; i < ExpenseMstList.Count; i++) { if (ExpenseMstList[i].FIfKeyEvaluation == 1) { var dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere2).Add(ORMRestrictions <Int64> .Eq("MstPhid", ExpenseMstList[i].PhId)); IList <ExpenseHxModel> ExpenseHxList = ExpenseHxFacade.Find(dicWhere2).Data; if (ExpenseHxList.Count > 0) { for (var j = 0; j < ExpenseHxList.Count; j++) { sum += ExpenseHxList[j].FAmount; } } } } } return(sum); }
/// <summary> /// 通过外键值获取ExpenseHx明细数据 /// </summary> /// <param name="id">外键值</param> /// <returns></returns> public FindedResults <ExpenseHxModel> FindExpenseHxByForeignKey <Int64>(Int64 id) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .Eq("MstPhid", id)); return(ExpenseHxFacade.Find(dicWhere)); }
/// <summary> /// 保存额度核销数据 /// </summary> /// <param name="adddata"></param> /// <param name="updatedata"></param> /// <param name="deletedata"></param> /// <returns></returns> public CommonResult SaveHX(List <ExpenseHxModel> adddata, List <ExpenseHxModel> updatedata, List <string> deletedata) { CommonResult result = new CommonResult(); if (adddata != null && adddata.Count > 0) { for (var i = 0; i < adddata.Count; i++) { ExpenseHxModel Hx = adddata[i]; Hx.PersistentState = PersistentState.Added; ExpenseHxFacade.Save <Int64>(Hx, ""); } } if (updatedata != null && updatedata.Count > 0) { for (var j = 0; j < updatedata.Count; j++) { ExpenseHxModel Hx2 = updatedata[j]; ExpenseHxModel Hx3 = ExpenseHxFacade.Find(Hx2.PhId).Data; Hx3.FHxdateTime = Hx2.FHxdateTime; Hx3.FAmount = Hx2.FAmount; Hx3.FContentCode = Hx2.FContentCode; Hx3.FRemark = Hx2.FRemark; Hx3.FCode = Hx2.FCode; Hx3.FName = Hx2.FName; Hx3.PersistentState = PersistentState.Modified; ExpenseHxFacade.Save <Int64>(Hx3, ""); } } if (deletedata != null && deletedata.Count > 0) { for (var x = 0; x < deletedata.Count; x++) { ExpenseHxFacade.Delete(deletedata[x]); } } return(result); }