/// <summary>
/// 用于向 T_FB_SUBJECTCOMPANY EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToT_FB_SUBJECTCOMPANY(T_FB_SUBJECTCOMPANY t_FB_SUBJECTCOMPANY)
{
base.AddObject("T_FB_SUBJECTCOMPANY", t_FB_SUBJECTCOMPANY);
}
/// <summary>
/// 创建新的 T_FB_SUBJECTCOMPANY 对象。
/// </summary>
/// <param name="sUBJECTCOMPANYID">SUBJECTCOMPANYID 属性的初始值。</param>
/// <param name="aCTIVED">ACTIVED 属性的初始值。</param>
/// <param name="oWNERID">OWNERID 属性的初始值。</param>
/// <param name="oWNERPOSTID">OWNERPOSTID 属性的初始值。</param>
/// <param name="oWNERDEPARTMENTID">OWNERDEPARTMENTID 属性的初始值。</param>
/// <param name="oWNERCOMPANYID">OWNERCOMPANYID 属性的初始值。</param>
/// <param name="cREATEUSERID">CREATEUSERID 属性的初始值。</param>
/// <param name="cREATEDATE">CREATEDATE 属性的初始值。</param>
/// <param name="cREATECOMPANYID">CREATECOMPANYID 属性的初始值。</param>
/// <param name="cREATEDEPARTMENTID">CREATEDEPARTMENTID 属性的初始值。</param>
/// <param name="cREATEPOSTID">CREATEPOSTID 属性的初始值。</param>
/// <param name="uPDATEUSERID">UPDATEUSERID 属性的初始值。</param>
/// <param name="uPDATEDATE">UPDATEDATE 属性的初始值。</param>
/// <param name="eDITSTATES">EDITSTATES 属性的初始值。</param>
public static T_FB_SUBJECTCOMPANY CreateT_FB_SUBJECTCOMPANY(global::System.String sUBJECTCOMPANYID, global::System.Decimal aCTIVED, global::System.String oWNERID, global::System.String oWNERPOSTID, global::System.String oWNERDEPARTMENTID, global::System.String oWNERCOMPANYID, global::System.String cREATEUSERID, global::System.DateTime cREATEDATE, global::System.String cREATECOMPANYID, global::System.String cREATEDEPARTMENTID, global::System.String cREATEPOSTID, global::System.String uPDATEUSERID, global::System.DateTime uPDATEDATE, global::System.Decimal eDITSTATES)
{
T_FB_SUBJECTCOMPANY t_FB_SUBJECTCOMPANY = new T_FB_SUBJECTCOMPANY();
t_FB_SUBJECTCOMPANY.SUBJECTCOMPANYID = sUBJECTCOMPANYID;
t_FB_SUBJECTCOMPANY.ACTIVED = aCTIVED;
t_FB_SUBJECTCOMPANY.OWNERID = oWNERID;
t_FB_SUBJECTCOMPANY.OWNERPOSTID = oWNERPOSTID;
t_FB_SUBJECTCOMPANY.OWNERDEPARTMENTID = oWNERDEPARTMENTID;
t_FB_SUBJECTCOMPANY.OWNERCOMPANYID = oWNERCOMPANYID;
t_FB_SUBJECTCOMPANY.CREATEUSERID = cREATEUSERID;
t_FB_SUBJECTCOMPANY.CREATEDATE = cREATEDATE;
t_FB_SUBJECTCOMPANY.CREATECOMPANYID = cREATECOMPANYID;
t_FB_SUBJECTCOMPANY.CREATEDEPARTMENTID = cREATEDEPARTMENTID;
t_FB_SUBJECTCOMPANY.CREATEPOSTID = cREATEPOSTID;
t_FB_SUBJECTCOMPANY.UPDATEUSERID = uPDATEUSERID;
t_FB_SUBJECTCOMPANY.UPDATEDATE = uPDATEDATE;
t_FB_SUBJECTCOMPANY.EDITSTATES = eDITSTATES;
return t_FB_SUBJECTCOMPANY;
}
/// <summary>
/// 保存公司科目维护
/// 级联的去除不可用的部门科目和岗位科目
/// </summary>
/// <param name="fbEntityList"></param>
/// <returns></returns>
public bool SaveListT_FB_SUBJECTCOMPANY(List<FBEntity> fbEntityList)
{
QueryExpression qeSCom = new QueryExpression();
QueryExpression qeTop = qeSCom;
string StrCompanyID = "";//公司ID
bool IsExistPlus = false;
// 找出没有设置年度预算而后又允许年度预算的
List<T_FB_SUBJECTCOMPANY> inActivedlist = fbEntityList.CreateList(item =>
{
T_FB_SUBJECTCOMPANY entity = item.Entity as T_FB_SUBJECTCOMPANY;
if (string.IsNullOrEmpty(StrCompanyID))
{
StrCompanyID = entity.OWNERCOMPANYID;
QueryExpression qe = QueryExpression.Equal("SUBJECTCOMPANYID", entity.SUBJECTCOMPANYID);
var baData = this.InnerGetEntities<T_FB_SUBJECTCOMPANY>(qe);
if (baData.Count() > 0)
{
T_FB_SUBJECTCOMPANY OldSub = new T_FB_SUBJECTCOMPANY();
OldSub = baData.FirstOrDefault();
if (OldSub.ISYEARBUDGET == 0)
{
if (entity.ISYEARBUDGET == 1)
{
QueryExpression qeAccount = QueryExpression.Equal("OWNERCOMPANYID", entity.OWNERCOMPANYID);
QueryExpression qeAccount1 = QueryExpression.Equal("T_FB_SUBJECT.SUBJECTID", entity.T_FB_SUBJECT != null ? entity.T_FB_SUBJECT.SUBJECTID : entity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString());
QueryExpression qeAccount2 = QueryExpression.Equal("ACCOUNTOBJECTTYPE", "1");
QueryExpression qeAccount3 = new QueryExpression();
qeAccount3.PropertyName = "USABLEMONEY";
qeAccount3.PropertyValue = "0";
qeAccount3.Operation = QueryExpression.Operations.LessThanOrEqual;
qeAccount3.Operation = QueryExpression.Operations.LessThan;//是否有问题
qeAccount.RelatedType = QueryExpression.RelationType.And;
qeAccount1.RelatedType = QueryExpression.RelationType.And;
qeAccount2.RelatedType = QueryExpression.RelationType.And;
qeAccount3.RelatedType = QueryExpression.RelationType.And;
qeAccount.RelatedExpression = qeAccount1;
qeAccount2.RelatedExpression = qeAccount1;
qeAccount3.RelatedExpression = qeAccount2;
qeAccount3.QueryType = typeof(T_FB_BUDGETACCOUNT).Name;
//var baDataAccount = this.InnerGetEntities<T_FB_BUDGETACCOUNT>(qeAccount);
//if(baDataAccount.Count() >0)
//{
// //IsExistPlus= true;
//}
}
}
}
}
//return entity.ACTIVED != 1 ? entity : null;
return entity;
});
if (IsExistPlus)
{
return IsExistPlus;
}
//var baData = this.InnerGetEntities<T_FB_SUBJECTCOMPANY>(qeDept);
// 查出公司科目相关的部门科目及岗位科目
inActivedlist.ForEach(item =>
{
qeTop.RelatedExpression = QueryExpression.Equal("T_FB_SUBJECTCOMPANY.SUBJECTCOMPANYID", item.SUBJECTCOMPANYID);
qeTop.RelatedType = QueryExpression.RelationType.Or;
qeTop = qeTop.RelatedExpression;
});
// 将部门科目及岗位科目置为不可用
if (qeSCom.RelatedExpression != null)
{
qeSCom = qeSCom.RelatedExpression;
qeSCom.Include = new string[] { "T_FB_SUBJECTPOST" };
List<T_FB_SUBJECTDEPTMENT> inActiveDataList = GetEntities<T_FB_SUBJECTDEPTMENT>(qeSCom.RelatedExpression);
inActiveDataList.ForEach(item =>
{
item.ACTIVED = 0;
item.T_FB_SUBJECTPOST.ToList().ForEach(itemPost =>
{
itemPost.ACTIVED = 0;
});
});
}
if (fbEntityList.Count > 0)
{
//记录公司部门科目设置修改流水
SaveListT_FB_WFSUBJECTSETTING(fbEntityList, "1");
}
return FBEntityBLLSaveList(fbEntityList);
}
