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