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