protected override void OnLoadDataComplete() { var details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_COMPANYBUDGETSUMDETAIL).Name); List <T_FB_COMPANYBUDGETAPPLYDETAIL> listDetail = new List <T_FB_COMPANYBUDGETAPPLYDETAIL>(); this.OrderEntity.FBEntity.OrderDetailBy <T_FB_COMPANYBUDGETAPPLYDETAIL>(item => { return(item.T_FB_COMPANYBUDGETAPPLYMASTER.OWNERDEPARTMENTID); }); details.ToList().ForEach(item => { var cDetail = (item.Entity as T_FB_COMPANYBUDGETSUMDETAIL).T_FB_COMPANYBUDGETAPPLYDETAIL; item.AddFBEntities <T_FB_COMPANYBUDGETAPPLYDETAIL>(cDetail.ToFBEntityList()); item.OrderDetailBy <T_FB_COMPANYBUDGETAPPLYDETAIL>(detail => { return(detail.T_FB_SUBJECT != null ? detail.T_FB_SUBJECT.SUBJECTCODE : string.Empty); }); listDetail.AddRange(cDetail); }); var detailSum = from item in listDetail group item by item.T_FB_SUBJECT into p select new V_SubjectCompanySum { T_FB_SUBJECT = p.Key, BUDGETMONEY = p.Sum(sumItem => sumItem.BUDGETMONEY), T_FB_COMPANYBUDGETAPPLYDETAIL = listDetail.Where(de => de.T_FB_SUBJECT == p.Key).ToList() }; var detailsTwo = this.OrderEntity.GetRelationFBEntities(typeof(V_SubjectCompanySum).Name); foreach (var ds in detailSum) { FBEntity fbDetail = ds.ToFBEntity(); var listDetails = fbDetail.GetRelationFBEntities(typeof(T_FB_COMPANYBUDGETAPPLYDETAIL).Name); fbDetail.AddFBEntities <T_FB_COMPANYBUDGETAPPLYDETAIL>(ds.T_FB_COMPANYBUDGETAPPLYDETAIL.ToFBEntityList()); fbDetail.OrderDetailBy <T_FB_COMPANYBUDGETAPPLYDETAIL>(item => { return(item.T_FB_COMPANYBUDGETAPPLYMASTER.OWNERDEPARTMENTID); }); detailsTwo.Add(fbDetail); } this.OrderEntity.FBEntity.OrderDetailBy <V_SubjectCompanySum>(item => { return(item.T_FB_SUBJECT.SUBJECTCODE); }); }
protected override void OnLoadDataComplete() { var details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETSUMDETAIL).Name); this.OrderEntity.FBEntity.OrderDetailBy <T_FB_DEPTBUDGETSUMDETAIL>(item => { return(item.T_FB_DEPTBUDGETAPPLYMASTER.OWNERDEPARTMENTID); }); List <T_FB_DEPTBUDGETAPPLYDETAIL> listDetail = new List <T_FB_DEPTBUDGETAPPLYDETAIL>(); details.ToList().ForEach(item => { var cDetail = (item.Entity as T_FB_DEPTBUDGETSUMDETAIL).T_FB_DEPTBUDGETAPPLYDETAIL; item.AddFBEntities <T_FB_DEPTBUDGETAPPLYDETAIL>(cDetail.ToFBEntityList()); item.OrderDetailBy <T_FB_DEPTBUDGETAPPLYDETAIL>(detail => { return(detail.T_FB_SUBJECT.SUBJECTCODE); }); listDetail.AddRange(cDetail); }); var detailSum = from item in listDetail group item by item.T_FB_SUBJECT into p select new V_SubjectDepartmentSum { T_FB_SUBJECT = p.Key, BUDGETMONEY = p.Sum(sumItem => sumItem.TOTALBUDGETMONEY.Value), T_FB_DEPTBUDGETAPPLYDETAIL = listDetail.Where(de => de.T_FB_SUBJECT == p.Key).ToList() }; var detailsTwo = this.OrderEntity.GetRelationFBEntities(typeof(V_SubjectDepartmentSum).Name); foreach (var ds in detailSum) { FBEntity fbDetail = ds.ToFBEntity(); fbDetail.AddFBEntities <T_FB_DEPTBUDGETAPPLYDETAIL>(ds.T_FB_DEPTBUDGETAPPLYDETAIL.ToFBEntityList()); fbDetail.OrderDetailBy <T_FB_DEPTBUDGETAPPLYDETAIL>(item => { return(item.T_FB_DEPTBUDGETAPPLYMASTER.OWNERDEPARTMENTID); }); detailsTwo.Add(fbDetail); } this.OrderEntity.FBEntity.OrderDetailBy <V_SubjectDepartmentSum>(item => { return(item.T_FB_SUBJECT.SUBJECTCODE); }); T_FB_DEPTBUDGETSUMMASTER master = this.OrderEntity.Entity as T_FB_DEPTBUDGETSUMMASTER; this.OrderMessage = "单据的截止提交时间为:" + master.BUDGETARYMONTH.AddDays(-1).ToLongDateString(); }