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