/// <summary>
/// 添加时操作
/// </summary>
/// <param name="e"></param>
private void DoForAdd(QueryFBEntitiesCompletedEventArgs e)
{
//beyond
// 清除预算明细
this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETADDDETAIL).Name).Clear();
this.OrderEntity.GetRelationFBEntities(typeof(T_FB_PERSONBUDGETADDDETAIL).Name).Clear();
// 添加预算明细
e.Result.ToList().ForEach(item =>
{
T_FB_DEPTBUDGETADDDETAIL deptDetail = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
deptDetail.T_FB_DEPTBUDGETADDMASTER = this.OrderEntity.Entity as T_FB_DEPTBUDGETADDMASTER;
item.FBEntityState = FBEntityState.Added;
#region beyond
item.GetRelationFBEntities(typeof(T_FB_PERSONBUDGETADDDETAIL).Name).ToList().ForEach(fbpersondetail =>
{
T_FB_PERSONBUDGETADDDETAIL persondetail = fbpersondetail.Entity as T_FB_PERSONBUDGETADDDETAIL;
persondetail.CREATEUSERID = this.OrderEntity.LoginUser.Value.ToString();
persondetail.CREATEUSERNAME = this.OrderEntity.LoginUser.Text;
persondetail.UPDATEUSERID = this.OrderEntity.LoginUser.Value.ToString();
persondetail.UPDATEUSERNAME = this.OrderEntity.LoginUser.Text;
persondetail.T_FB_DEPTBUDGETADDDETAIL = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
fbpersondetail.FBEntityState = FBEntityState.Added;
});
#endregion
deptDetail.T_FB_SUBJECT.T_FB_BUDGETACCOUNT.Clear();
deptDetail.T_FB_SUBJECT.T_FB_BUDGETCHECK.Clear();
});
this.OrderEntity.FBEntity.AddFBEntities <T_FB_DEPTBUDGETADDDETAIL>(e.Result);
this.OrderEntity.FBEntity.SetObjValue("Entity.BUDGETCHARGE", 0);
}
/// <summary>
/// 不可以为负数的保存校验
/// </summary>
/// <returns>returns</returns>
private List <string> CheckSaveA()
{
List <string> msgs = new List <string>();
ObservableCollection <FBEntity> details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETADDDETAIL).Name);
if (details.Count == 0)
{
msgs.Add(ErrorMessage.NoDetailInfo);
return(msgs);
}
details.ToList().ForEach(item =>
{
T_FB_DEPTBUDGETADDDETAIL detail = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
// 判断个人预算是否出现负数的情况
var personDetailList = item.GetEntityList <T_FB_PERSONBUDGETADDDETAIL>().FindAll(itemT => itemT != null);
// 表示没做过任何操作
if (detail.TOTALBUDGETMONEY.Equal(0) && detail.BUDGETMONEY.Equal(0))
{
return;
}
if (detail.TOTALBUDGETMONEY < 0)
{
string errorMessage = string.Format(ErrorMessage.BudgetMoneyZero, detail.T_FB_SUBJECT.SUBJECTNAME);
msgs.Add(errorMessage);
}
if (detail.BUDGETMONEY < 0)
{
msgs.Add(string.Format(ErrorMessage.PersonBudgetMoneyBigger, detail.T_FB_SUBJECT.SUBJECTNAME));
}
//不能大于年度结余
if (detail.USABLEMONEY.LessThan(detail.TOTALBUDGETMONEY))
{
msgs.Add(string.Format(ErrorMessage.BudgetYearMoneyBigger, detail.T_FB_SUBJECT.SUBJECTNAME));
}
personDetailList.ForEach(itemP =>
{
if (itemP.BUDGETMONEY < 0)
{
msgs.Add(string.Format(ErrorMessage.MoneyZero, detail.T_FB_SUBJECT.SUBJECTNAME + "(" + itemP.OWNERNAME + ")", "个人预算金额"));
}
});
});
T_FB_DEPTBUDGETADDMASTER entMaster = this.OrderEntity.FBEntity.Entity as T_FB_DEPTBUDGETADDMASTER;
if (entMaster.BUDGETCHARGE <= 0)
{
msgs.Add("费用总预算必须大于0!");
}
return(msgs);
}
/// <summary>
/// 获取T_FB_DEPTBUDGETADDDETAIL信息
/// </summary>
/// <param name="strDeptBudgetAddDetailId">主键索引</param>
/// <returns></returns>
public T_FB_DEPTBUDGETADDDETAIL GetDeptBudgetAddDetailByID(string strDeptBudgetAddDetailId)
{
if (string.IsNullOrEmpty(strDeptBudgetAddDetailId))
{
return(null);
}
DeptBudgetAddDetailDAL dalDeptBudgetAddDetail = new DeptBudgetAddDetailDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strDeptBudgetAddDetailId))
{
strFilter.Append(" DEPTBUDGETADDDETAILID == @0");
objArgs.Add(strDeptBudgetAddDetailId);
}
T_FB_DEPTBUDGETADDDETAIL entRd = dalDeptBudgetAddDetail.GetDeptBudgetAddDetailRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
public void AddToT_FB_DEPTBUDGETADDDETAIL(T_FB_DEPTBUDGETADDDETAIL t_FB_DEPTBUDGETADDDETAIL)
{
base.AddObject("T_FB_DEPTBUDGETADDDETAIL", t_FB_DEPTBUDGETADDDETAIL);
}
public static T_FB_DEPTBUDGETADDDETAIL CreateT_FB_DEPTBUDGETADDDETAIL(string dEPTBUDGETADDDETAILID, decimal bUDGETMONEY, string cREATEUSERID, global::System.DateTime cREATEDATE, string uPDATEUSERID, global::System.DateTime uPDATEDATE)
{
T_FB_DEPTBUDGETADDDETAIL t_FB_DEPTBUDGETADDDETAIL = new T_FB_DEPTBUDGETADDDETAIL();
t_FB_DEPTBUDGETADDDETAIL.DEPTBUDGETADDDETAILID = dEPTBUDGETADDDETAILID;
t_FB_DEPTBUDGETADDDETAIL.BUDGETMONEY = bUDGETMONEY;
t_FB_DEPTBUDGETADDDETAIL.CREATEUSERID = cREATEUSERID;
t_FB_DEPTBUDGETADDDETAIL.CREATEDATE = cREATEDATE;
t_FB_DEPTBUDGETADDDETAIL.UPDATEUSERID = uPDATEUSERID;
t_FB_DEPTBUDGETADDDETAIL.UPDATEDATE = uPDATEDATE;
return t_FB_DEPTBUDGETADDDETAIL;
}
private void SetPropertyChanged()
{
// 因后台保存是二层结构，所有需要把 A->B->C这种结构变成 A->B, A->C结构
ObservableCollection <FBEntity> detailPersonList = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_PERSONBUDGETADDDETAIL).Name);
ObservableCollection <FBEntity> detailList = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETADDDETAIL).Name);
detailList.ToList().ForEach(item =>
{
#region 部门变化
// 部门预算明细变化事件
item.Entity.PropertyChanged += (senderDept, eDept) =>
{
T_FB_DEPTBUDGETADDDETAIL DeptDetail = senderDept as T_FB_DEPTBUDGETADDDETAIL;
#region
// 部门预算明细的总预算变化时，统计所有明细的预算
if (eDept.PropertyName == "TOTALBUDGETMONEY")
{
decimal?newTotal = detailList.Sum(itemDept =>
{
return((decimal?)itemDept.GetObjValue("Entity.TOTALBUDGETMONEY"));
});
this.OrderEntity.SetObjValue("Entity.BUDGETCHARGE", newTotal);
}
// 改：先填写预算总额，后填个人预算，而部门的公共预算＝预算总额 - 个人预算 2011-12-28
// 个人预算或部门预算变化时，统计个人预算明细 + 部门预算
if (eDept.PropertyName == "TOTALBUDGETMONEY" || eDept.PropertyName == "PERSONBUDGETMONEY")
{
DeptDetail.BUDGETMONEY = DeptDetail.TOTALBUDGETMONEY.Subtract(DeptDetail.PERSONBUDGETMONEY).Value;
}
#endregion
};
#endregion
#region 个人预算明细变化
// 个人预算明细变化
ObservableCollection <FBEntity> obPersonDetail = item.GetRelationFBEntities(typeof(T_FB_PERSONBUDGETADDDETAIL).Name);
obPersonDetail.ToList().ForEach(itemPerson =>
{
T_FB_PERSONBUDGETADDDETAIL persondetail = itemPerson.Entity as T_FB_PERSONBUDGETADDDETAIL;
itemPerson.Entity.PropertyChanged += (senderPerson, ePerson) =>
{
if (ePerson.PropertyName == "BUDGETMONEY")
{
var totalPerson = obPersonDetail.Sum(itemPersonDetail =>
{
// 在个人预算中将会部门预算记录，所以需要判断是否统计的对象是个人预算
T_FB_PERSONBUDGETADDDETAIL pDetail = itemPersonDetail.Entity as T_FB_PERSONBUDGETADDDETAIL;
if (pDetail != null)
{
return(pDetail.BUDGETMONEY);
}
else
{
return(0);
}
});
var itemDept = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
itemDept.PERSONBUDGETMONEY = totalPerson;
}
};
detailPersonList.Add(itemPerson);
});
// 因为在个人预算中需要体现部门公共费用栏，则加入部门公共费用(T记录到个人预算集合中
if (obPersonDetail.Count > 0)
{
var sumEntity = new V_DepartmentSum(item.Entity);
var curItemEntity = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
var sumFBEntity = sumEntity.ToFBEntity();
sumFBEntity.ReadOnly = true;
sumEntity.LIMITBUDGETMONEY = curItemEntity.AUDITBUDGETMONEY.Subtract(obPersonDetail.Sum(itemFB =>
{
var tee = (itemFB.Entity as T_FB_PERSONBUDGETADDDETAIL);
if (tee.LIMITBUDGETMONEY == null)
{
return(0);
}
else
{
return(tee.LIMITBUDGETMONEY);
}
}));
sumFBEntity.FBEntityState = FBEntityState.Unchanged;
obPersonDetail.Insert(0, sumFBEntity);
}
else
{
item.HideDetails = true;
}
#endregion
});
this.EditForm.BindingData();
this.CloseProcess(false);
}
/// <summary>
/// 可为负数的保存校验
/// </summary>
/// <returns>returns</returns>
private List <string> CheckSaveB()
{
List <string> msgs = new List <string>();
ObservableCollection <FBEntity> details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETADDDETAIL).Name);
if (details.Count == 0)
{
msgs.Add(ErrorMessage.NoDetailInfo);
return(msgs);
}
var detailList = details.Select(item => item.Entity as T_FB_DEPTBUDGETADDDETAIL).ToList();
var existBiggerThanZero = detailList.Count(item => item.TOTALBUDGETMONEY > 0) > 0;
var existLessThanZero = detailList.Count(item => item.TOTALBUDGETMONEY < 0) > 0;
if (existBiggerThanZero && existLessThanZero)
{
msgs.Add("预算明细只能全为负数，或全为正数，请确认!");
return(msgs);
}
// 都大于０的
if (!existLessThanZero)
{
return(CheckSaveA());
}
details.ToList().ForEach(item =>
{
T_FB_DEPTBUDGETADDDETAIL detail = item.Entity as T_FB_DEPTBUDGETADDDETAIL;
// 判断个人预算是否出现负数的情况
var personDetailList = item.GetEntityList <T_FB_PERSONBUDGETADDDETAIL>(itemT =>
{
var result = itemT as T_FB_PERSONBUDGETADDDETAIL;
if (result == null)
{
V_DepartmentSum vd = itemT as V_DepartmentSum;
result = new T_FB_PERSONBUDGETADDDETAIL()
{
LIMITBUDGETMONEY = vd.LIMITBUDGETMONEY,
BUDGETMONEY = vd.BUDGETMONEY,
OWNERNAME = vd.OWNERNAME,
OWNERPOSTNAME = vd.OWNERPOSTNAME
};
}
return(result);
});
// 表示没做过任何操作
if (detail.TOTALBUDGETMONEY.Equal(0) && detail.BUDGETMONEY.Equal(0))
{
return;
}
if (detail.TOTALBUDGETMONEY > 0)
{
string errorMessage = string.Format(ErrorMessage.MoneyBiggerThanZero, detail.T_FB_SUBJECT.SUBJECTNAME, FieldDisplayName.BudgetMoney);
msgs.Add(errorMessage);
}
//不能大于当前可用结余AUDITBUDGETMONEY
if (detail.AUDITBUDGETMONEY.Add(detail.TOTALBUDGETMONEY) < 0)
{
msgs.Add(string.Format(ErrorMessage.MoneyBigger, "扣减的预算金额", "可用结余", detail.T_FB_SUBJECT.SUBJECTNAME));
}
personDetailList.ForEach(itemP =>
{
if (itemP.LIMITBUDGETMONEY.Add(itemP.BUDGETMONEY) < 0)
{
msgs.Add(string.Format("科目：{0} 扣减的预算金额不能大于可用结余!", detail.T_FB_SUBJECT.SUBJECTNAME + "(" + itemP.OWNERNAME + ")"));
}
else if (itemP.BUDGETMONEY > 0)
{
msgs.Add(string.Format("科目：{0} 扣减的预算金额不能大于零!", detail.T_FB_SUBJECT.SUBJECTNAME + "(" + itemP.OWNERNAME + ")"));
}
});
});
T_FB_DEPTBUDGETADDMASTER entMaster = this.OrderEntity.FBEntity.Entity as T_FB_DEPTBUDGETADDMASTER;
if (entMaster.BUDGETCHARGE >= 0)
{
msgs.Add("费用总预算必须小于0!");
}
return(msgs);
}
