Пример #1
0
        private List <DebtInfo> GetDebtInfo(QueryExpression qe)
        {
            using (FBCommonBLL bll = new FBCommonBLL())
            {
                List <DebtInfo> result = new List <DebtInfo>();
                qe.Include = new string[] { typeof(T_FB_BORROWAPPLYDETAIL).Name };
                qe.OrderBy = new string[] { "PLANREPAYDATE" };

                List <T_FB_BORROWAPPLYMASTER> list = bll.GetEntities <T_FB_BORROWAPPLYMASTER>(qe);

                list   = list.OrderBy(item => item.PLANREPAYDATE).ToList();
                result = list.CreateList(item =>
                {
                    DebtInfo debtInfo = new DebtInfo();
                    decimal?deblt     = item.T_FB_BORROWAPPLYDETAIL.Sum(detail =>
                    {
                        return(detail.UNREPAYMONEY);
                    });
                    debtInfo.Debt       = deblt == null ? 0 : deblt.Value;
                    debtInfo.EmployeeID = item.OWNERID;
                    debtInfo.OrderType  = "T_FB_BORROWAPPLYMASTER";
                    debtInfo.OrderCode  = item.BORROWAPPLYMASTERCODE;
                    return(debtInfo);
                });
                return(result);
            }
        }
        private SDictionaryDrawer(SDictionary <TKey, TValue> _targetDictionary, string _title, float _elementHeight, float _keyWidth, Action _save)
        {
            source     = _targetDictionary;
            saveAction = _save;
            keyWidth   = _keyWidth;

            var dictionaryKeys = _targetDictionary.Keys;

            if (dictionaryKeys == null)
            {
                throw new Exception("目标Dictionary的Keys不应当为空");
            }

            this.keys = new List <KeyValuePair <TKey, TValue> >();

            for (int i = 0; i < dictionaryKeys.Count; ++i)
            {
                keys.Add(new KeyValuePair <TKey, TValue>(
                             dictionaryKeys[i],
                             _targetDictionary[dictionaryKeys[i]]
                             ));
            }

            keyList = keys.CreateList()
                      .SetAddFunction(Add)
                      .SetRemoveAtFunction(Remove)
                      .SetDrawEachFunction(Draw)
                      .SetElementHeight(_elementHeight)
                      .SetOnReordered(OnReorder)
                      .SetHeader(_title, null, null);
        }
Пример #3
0
        public static IList <ITextValueItem> GetTextValueItem(string dictType)
        {
            List <T_SYS_DICTIONARY> listDict = GetDictionary(dictType);

            var result = listDict.CreateList(item =>
            {
                ITextValueItem cbbD = new TextValueItemBase();
                cbbD.Value          = item.DICTIONARYVALUE;
                cbbD.Text           = item.DICTIONARYNAME;
                return(cbbD);
            });

            return(result);
        }
Пример #4
0
        public static IList <OrderStatusData> GetOrderStatus()
        {
            List <T_SYS_DICTIONARY> listDict = GetDictionary("CHECKSTATE");

            var result = listDict.CreateList(item =>
            {
                OrderStatusData cbbD = new OrderStatusData();
                cbbD.Value           = item.DICTIONARYVALUE;
                cbbD.Text            = item.DICTIONARYNAME;
                return(cbbD);
            });

            return(result);
        }
Пример #5
0
        private static IList <ControlTypeData> GetControlTypeData()
        {
            List <T_SYS_DICTIONARY> listDict = GetDictionary("ControlType");

            var result = listDict.CreateList(item =>
            {
                ControlTypeData cbbD = new ControlTypeData();
                cbbD.Value           = item.DICTIONARYVALUE;
                cbbD.Text            = item.DICTIONARYNAME;
                return(cbbD);
            });

            return(result);
        }
Пример #6
0
        private static IList <BudgetAccountTypeData> GetBudgetAccountTypeData()
        {
            List <T_SYS_DICTIONARY> listDict = GetDictionary("BudgetAccountType");

            var result = listDict.CreateList(item =>
            {
                BudgetAccountTypeData cbbD = new BudgetAccountTypeData();
                cbbD.Value = item.DICTIONARYVALUE;
                cbbD.Text  = item.DICTIONARYNAME;
                return(cbbD);
            });

            return(result);
        }
Пример #7
0
        public bool CheckBeforeSave(FBEntity saveFBEntity)
        {
            List <ValidatorBase> listValidation = vmGroup.ValidateAll();

            if (listValidation.Count > 0)
            {
                List <string> listMgs = listValidation.CreateList(validator =>
                {
                    return(validator.ErrorMessage);
                });
                CommonFunction.ShowErrorMessage(listMgs);
                return(false);
            }
            return(OnSaving(saveFBEntity));
        }
Пример #8
0
        private static List[] ToList(List <List <int> > frequencyItemsTID)
        {
            List[] mangList = new List[frequencyItemsTID.Count];
            int    i = 0, j = 0;

            for (i = 0; i < frequencyItemsTID.Count; i++)
            {
                List list = new List();
                list = list.CreateList();
                Node node = new Node();
                //Tao List cho TID
                if (frequencyItemsTID[i] != null)
                {
                    for (j = 0; j < frequencyItemsTID[i].Count; j++)
                    {
                        node = node.CreateNode(frequencyItemsTID[i][j]);
                        list = list.InsertTail(list, node);
                    }
                }
                mangList[i] = list;
            }
            return(mangList);
        }
Пример #9
0
        /// <summary>
        ///   保存科目设置流水
        /// </summary>
        /// <param name="fbEntityList"></param>
        /// <returns></returns>
        public bool SaveListT_FB_WFSUBJECTSETTING(List <FBEntity> fbEntityList, string strfig)
        {
            List <FBEntity> inActivedlist = fbEntityList.CreateList(item =>
            {
                T_FB_WFSUBJECTSETTING fbEntity = new T_FB_WFSUBJECTSETTING();

                if (strfig == "1")
                {
                    T_FB_SUBJECTCOMPANY SubjectEntity = item.Entity as T_FB_SUBJECTCOMPANY;

                    fbEntity.WFSUBJECTSETTINGID  = Guid.NewGuid().ToString();
                    fbEntity.SUBJECTID           = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                    fbEntity.ACTIVED             = SubjectEntity.ACTIVED;
                    fbEntity.ISMONTHADJUST       = SubjectEntity.ISMONTHADJUST;
                    fbEntity.ISMONTHLIMIT        = SubjectEntity.ISMONTHLIMIT;
                    fbEntity.ISPERSON            = SubjectEntity.ISPERSON;
                    fbEntity.ISYEARBUDGET        = SubjectEntity.ISYEARBUDGET;
                    fbEntity.CONTROLTYPE         = SubjectEntity.CONTROLTYPE;
                    fbEntity.OWNERCOMPANYID      = SubjectEntity.OWNERCOMPANYID;
                    fbEntity.OWNERCOMPANYNAME    = SubjectEntity.OWNERCOMPANYNAME;
                    fbEntity.OWNERDEPARTMENTID   = SubjectEntity.OWNERDEPARTMENTID;
                    fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                    fbEntity.OWNERPOSTID         = SubjectEntity.OWNERPOSTID;
                    fbEntity.OWNERPOSTNAME       = SubjectEntity.OWNERPOSTNAME;
                    fbEntity.CREATEUSERID        = SubjectEntity.CREATEUSERID;
                    fbEntity.UPDATEUSERID        = SubjectEntity.UPDATEUSERID;
                    fbEntity.UPDATEDATE          = DateTime.Now;
                    fbEntity.CREATEDATE          = DateTime.Now;
                    fbEntity.ORDERTYPE           = strfig;//1 公司 2部门 3岗位
                }
                else if (strfig == "2")
                {
                    T_FB_SUBJECTDEPTMENT SubjectEntity = item.Entity as T_FB_SUBJECTDEPTMENT;
                    if (SubjectEntity == null)
                    {
                        T_FB_SUBJECTPOST SubjectEntity1 = item.Entity as T_FB_SUBJECTPOST;

                        fbEntity.WFSUBJECTSETTINGID  = Guid.NewGuid().ToString();
                        fbEntity.SUBJECTID           = SubjectEntity1.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                        fbEntity.ACTIVED             = SubjectEntity1.ACTIVED;
                        fbEntity.LIMITBUDGEMONEY     = SubjectEntity1.LIMITBUDGEMONEY;
                        fbEntity.OWNERCOMPANYID      = SubjectEntity1.OWNERCOMPANYID;
                        fbEntity.OWNERCOMPANYNAME    = SubjectEntity1.OWNERCOMPANYNAME;
                        fbEntity.OWNERDEPARTMENTID   = SubjectEntity1.OWNERDEPARTMENTID;
                        fbEntity.OWNERDEPARTMENTNAME = SubjectEntity1.OWNERDEPARTMENTNAME;
                        fbEntity.OWNERPOSTID         = SubjectEntity1.OWNERPOSTID;
                        fbEntity.OWNERPOSTNAME       = SubjectEntity1.OWNERPOSTNAME;
                        fbEntity.CREATEUSERID        = SubjectEntity1.CREATEUSERID;
                        fbEntity.UPDATEUSERID        = SubjectEntity1.UPDATEUSERID;
                        fbEntity.UPDATEDATE          = DateTime.Now;
                        fbEntity.CREATEDATE          = DateTime.Now;
                        fbEntity.ORDERTYPE           = "3";//1 公司 2部门 3岗位
                    }
                    else
                    {
                        fbEntity.WFSUBJECTSETTINGID  = Guid.NewGuid().ToString();
                        fbEntity.SUBJECTID           = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                        fbEntity.ACTIVED             = SubjectEntity.ACTIVED;
                        fbEntity.LIMITBUDGEMONEY     = SubjectEntity.LIMITBUDGEMONEY;
                        fbEntity.OWNERCOMPANYID      = SubjectEntity.OWNERCOMPANYID;
                        fbEntity.OWNERCOMPANYNAME    = SubjectEntity.OWNERCOMPANYNAME;
                        fbEntity.OWNERDEPARTMENTID   = SubjectEntity.OWNERDEPARTMENTID;
                        fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                        fbEntity.OWNERPOSTID         = SubjectEntity.OWNERPOSTID;
                        fbEntity.OWNERPOSTNAME       = SubjectEntity.OWNERPOSTNAME;
                        fbEntity.CREATEUSERID        = SubjectEntity.CREATEUSERID;
                        fbEntity.UPDATEUSERID        = SubjectEntity.UPDATEUSERID;
                        fbEntity.UPDATEDATE          = DateTime.Now;
                        fbEntity.CREATEDATE          = DateTime.Now;
                        fbEntity.ORDERTYPE           = strfig;//1 公司 2部门 3岗位
                    }
                }
                else if (strfig == "3")
                {
                    T_FB_SUBJECTPOST SubjectEntity = item.Entity as T_FB_SUBJECTPOST;

                    fbEntity.WFSUBJECTSETTINGID  = Guid.NewGuid().ToString();
                    fbEntity.SUBJECTID           = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                    fbEntity.ACTIVED             = SubjectEntity.ACTIVED;
                    fbEntity.LIMITBUDGEMONEY     = SubjectEntity.LIMITBUDGEMONEY;
                    fbEntity.OWNERCOMPANYID      = SubjectEntity.OWNERCOMPANYID;
                    fbEntity.OWNERCOMPANYNAME    = SubjectEntity.OWNERCOMPANYNAME;
                    fbEntity.OWNERDEPARTMENTID   = SubjectEntity.OWNERDEPARTMENTID;
                    fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                    fbEntity.OWNERPOSTID         = SubjectEntity.OWNERPOSTID;
                    fbEntity.OWNERPOSTNAME       = SubjectEntity.OWNERPOSTNAME;
                    fbEntity.CREATEUSERID        = SubjectEntity.CREATEUSERID;
                    fbEntity.UPDATEUSERID        = SubjectEntity.UPDATEUSERID;
                    fbEntity.UPDATEDATE          = DateTime.Now;
                    fbEntity.CREATEDATE          = DateTime.Now;
                    fbEntity.ORDERTYPE           = strfig;//1 公司 2部门 3岗位
                }
                FBEntity a      = new FBEntity();
                a.Entity        = fbEntity;
                a.FBEntityState = FBEntityState.Added;
                a.EntityKey     = null;
                return(a);
            });

            return(FBEntityBLLSaveList(inActivedlist));
        }
Пример #10
0
        /// <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));
        }
Пример #11
0
        /// <summary>        
        ///   保存科目设置流水
        /// </summary>
        /// <param name="fbEntityList"></param>
        /// <returns></returns>
        public bool SaveListT_FB_WFSUBJECTSETTING(List<FBEntity> fbEntityList, string strfig)
        {
            List<FBEntity> inActivedlist = fbEntityList.CreateList(item =>
            {
                T_FB_WFSUBJECTSETTING fbEntity = new T_FB_WFSUBJECTSETTING();

                if (strfig == "1")
                {
                    T_FB_SUBJECTCOMPANY SubjectEntity = item.Entity as T_FB_SUBJECTCOMPANY;

                    fbEntity.WFSUBJECTSETTINGID = Guid.NewGuid().ToString();
                    fbEntity.SUBJECTID = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                    fbEntity.ACTIVED = SubjectEntity.ACTIVED;
                    fbEntity.ISMONTHADJUST = SubjectEntity.ISMONTHADJUST;
                    fbEntity.ISMONTHLIMIT = SubjectEntity.ISMONTHLIMIT;
                    fbEntity.ISPERSON = SubjectEntity.ISPERSON;
                    fbEntity.ISYEARBUDGET = SubjectEntity.ISYEARBUDGET;
                    fbEntity.CONTROLTYPE = SubjectEntity.CONTROLTYPE;
                    fbEntity.OWNERCOMPANYID = SubjectEntity.OWNERCOMPANYID;
                    fbEntity.OWNERCOMPANYNAME = SubjectEntity.OWNERCOMPANYNAME;
                    fbEntity.OWNERDEPARTMENTID = SubjectEntity.OWNERDEPARTMENTID;
                    fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                    fbEntity.OWNERPOSTID = SubjectEntity.OWNERPOSTID;
                    fbEntity.OWNERPOSTNAME = SubjectEntity.OWNERPOSTNAME;
                    fbEntity.CREATEUSERID = SubjectEntity.CREATEUSERID;
                    fbEntity.UPDATEUSERID = SubjectEntity.UPDATEUSERID;
                    fbEntity.UPDATEDATE = DateTime.Now;
                    fbEntity.CREATEDATE = DateTime.Now;
                    fbEntity.ORDERTYPE = strfig;//1 公司 2部门 3岗位
                }
                else if (strfig == "2")
                {
                    T_FB_SUBJECTDEPTMENT SubjectEntity = item.Entity as T_FB_SUBJECTDEPTMENT;
                    if (SubjectEntity == null)
                    {
                        T_FB_SUBJECTPOST SubjectEntity1 = item.Entity as T_FB_SUBJECTPOST;

                        fbEntity.WFSUBJECTSETTINGID = Guid.NewGuid().ToString();
                        fbEntity.SUBJECTID = SubjectEntity1.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                        fbEntity.ACTIVED = SubjectEntity1.ACTIVED;
                        fbEntity.LIMITBUDGEMONEY = SubjectEntity1.LIMITBUDGEMONEY;
                        fbEntity.OWNERCOMPANYID = SubjectEntity1.OWNERCOMPANYID;
                        fbEntity.OWNERCOMPANYNAME = SubjectEntity1.OWNERCOMPANYNAME;
                        fbEntity.OWNERDEPARTMENTID = SubjectEntity1.OWNERDEPARTMENTID;
                        fbEntity.OWNERDEPARTMENTNAME = SubjectEntity1.OWNERDEPARTMENTNAME;
                        fbEntity.OWNERPOSTID = SubjectEntity1.OWNERPOSTID;
                        fbEntity.OWNERPOSTNAME = SubjectEntity1.OWNERPOSTNAME;
                        fbEntity.CREATEUSERID = SubjectEntity1.CREATEUSERID;
                        fbEntity.UPDATEUSERID = SubjectEntity1.UPDATEUSERID;
                        fbEntity.UPDATEDATE = DateTime.Now;
                        fbEntity.CREATEDATE = DateTime.Now;
                        fbEntity.ORDERTYPE = "3";//1 公司 2部门 3岗位
                    }
                    else
                    {
                        fbEntity.WFSUBJECTSETTINGID = Guid.NewGuid().ToString();
                        fbEntity.SUBJECTID = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                        fbEntity.ACTIVED = SubjectEntity.ACTIVED;
                        fbEntity.LIMITBUDGEMONEY = SubjectEntity.LIMITBUDGEMONEY;
                        fbEntity.OWNERCOMPANYID = SubjectEntity.OWNERCOMPANYID;
                        fbEntity.OWNERCOMPANYNAME = SubjectEntity.OWNERCOMPANYNAME;
                        fbEntity.OWNERDEPARTMENTID = SubjectEntity.OWNERDEPARTMENTID;
                        fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                        fbEntity.OWNERPOSTID = SubjectEntity.OWNERPOSTID;
                        fbEntity.OWNERPOSTNAME = SubjectEntity.OWNERPOSTNAME;
                        fbEntity.CREATEUSERID = SubjectEntity.CREATEUSERID;
                        fbEntity.UPDATEUSERID = SubjectEntity.UPDATEUSERID;
                        fbEntity.UPDATEDATE = DateTime.Now;
                        fbEntity.CREATEDATE = DateTime.Now;
                        fbEntity.ORDERTYPE = strfig;//1 公司 2部门 3岗位
                    }
                }
                else if (strfig == "3")
                {
                    T_FB_SUBJECTPOST SubjectEntity = item.Entity as T_FB_SUBJECTPOST;

                    fbEntity.WFSUBJECTSETTINGID = Guid.NewGuid().ToString();
                    fbEntity.SUBJECTID = SubjectEntity.T_FB_SUBJECTReference.EntityKey.EntityKeyValues[0].Value.ToString();
                    fbEntity.ACTIVED = SubjectEntity.ACTIVED;
                    fbEntity.LIMITBUDGEMONEY = SubjectEntity.LIMITBUDGEMONEY;
                    fbEntity.OWNERCOMPANYID = SubjectEntity.OWNERCOMPANYID;
                    fbEntity.OWNERCOMPANYNAME = SubjectEntity.OWNERCOMPANYNAME;
                    fbEntity.OWNERDEPARTMENTID = SubjectEntity.OWNERDEPARTMENTID;
                    fbEntity.OWNERDEPARTMENTNAME = SubjectEntity.OWNERDEPARTMENTNAME;
                    fbEntity.OWNERPOSTID = SubjectEntity.OWNERPOSTID;
                    fbEntity.OWNERPOSTNAME = SubjectEntity.OWNERPOSTNAME;
                    fbEntity.CREATEUSERID = SubjectEntity.CREATEUSERID;
                    fbEntity.UPDATEUSERID = SubjectEntity.UPDATEUSERID;
                    fbEntity.UPDATEDATE = DateTime.Now;
                    fbEntity.CREATEDATE = DateTime.Now;
                    fbEntity.ORDERTYPE = strfig;//1 公司 2部门 3岗位
                }
                FBEntity a = new FBEntity();
                a.Entity = fbEntity;
                a.FBEntityState = FBEntityState.Added;
                a.EntityKey = null;
                return a;
            });
            return FBEntityBLLSaveList(inActivedlist);
        }
Пример #12
0
        /// <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);
        }
Пример #13
0
        public static bool IsEncapsulated(this Bounds @this, List <Renderer> containers, Vector3 translationVector = default)
        {
            List <Bounds> bounds = containers.CreateList((x) => x.bounds);

            return(IsEncapsulated(@this, bounds, translationVector));
        }
Пример #14
0
        /// <summary>
        /// 可用额度汇总
        /// </summary>
        /// <param name="qe"></param>
        /// <returns></returns>
        public List <FBEntity> QueryQueryBudgetAccount(QueryExpression qe)
        {
            // qe.VisitModuleCode = typeof(T_FB_BUDGETACCOUNT).Name;
            qe.Include = new string[] { "T_FB_SUBJECT" };

            qe.QueryType = "T_FB_BUDGETACCOUNT";
            if (qe.RightType != "QueryBudgetAccount")
            {
                qe.RightType = "QueryBudgetAccount";
            }

            List <T_FB_BUDGETACCOUNT> listBudgetAccount = GetEntities <T_FB_BUDGETACCOUNT>(qe);

            List <T_FB_BUDGETACCOUNT> listBAPerson = listBudgetAccount.FindAll(item =>
            {
                return(!string.IsNullOrEmpty(item.OWNERID));
            });
            List <string> listUserIDs = listBAPerson.CreateList(item =>
            {
                return(item.OWNERID);
            });
            OrganizationBLL          orgbll         = new OrganizationBLL();
            List <VirtualUser>       listUser       = orgbll.GetVirtualUser(listUserIDs);
            List <VirtualCompany>    listCompany    = orgbll.GetVirtualCompany(qe);
            List <VirtualDepartment> listDepartment = orgbll.GetVirtualDepartment(qe);
            List <VirtualPost>       listPost       = orgbll.GetVirtualPost(qe);


            listBudgetAccount.ForEach(item =>
            {
                VirtualCompany vc = listCompany.FirstOrDefault(item2 =>
                {
                    return(item2.ID == item.OWNERCOMPANYID);
                });
                item.OWNERCOMPANYID = vc == null ? "" : vc.Name;

                VirtualDepartment vd = listDepartment.FirstOrDefault(item2 =>
                {
                    return(item2.ID == item.OWNERDEPARTMENTID);
                });
                item.OWNERDEPARTMENTID = vd == null ? "" : vd.Name;

                VirtualPost vp = listPost.FirstOrDefault(item2 =>
                {
                    return(item2.ID == item.OWNERPOSTID);
                });
                item.OWNERPOSTID = vp == null ? "" : vp.Name;

                VirtualUser vu = listUser.FirstOrDefault(item2 =>
                {
                    return(item2.ID == item.OWNERID);
                });
                item.OWNERID = vu == null ? "" : vu.Name;
            });
            listBudgetAccount = listBudgetAccount.OrderByDescending(item => item.BUDGETYEAR)
                                .ThenByDescending(item => item.BUDGETMONTH)
                                .ThenBy(item => item.ACCOUNTOBJECTTYPE)
                                .ThenBy(item => item.OWNERCOMPANYID)
                                .ThenBy(item => item.OWNERDEPARTMENTID)
                                .ThenBy(item => item.OWNERPOSTID)
                                .ThenBy(item => item.OWNERID).ToList();
            return(listBudgetAccount.ToFBEntityList());
        }