/// <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);
}
