public PagedResultDto <CostAccountOut> GetCostAccountByPage(CostAccountInput queryModel)
{
var dic = EnumHelper.GetValueAndDesc <CommonEnum.EnumCostAccountSplitStep>();
#region expression表达式
var expression = Expression(queryModel);
#endregion
var pageModels = _costAccountRepository.PageListSelect(expression, s => new CostAccountOut()
{
POCode = s.POCode,
POLineNum = s.POLineNum,
DepartID = s.DepartID,
DepartNamePath = s.DepathNamePath,
Period = s.Period,
Amount = s.Amount,
ProjectName = s.ProjectName,
CompanyCode = s.CompanyCode,
CompanyName = s.CompanyName,
ContentType = s.ContentType,
ContentTypeName = s.ContentTypeName,
SubjectCode = s.SubjectCode,
SubjectName = s.SubjectName,
SecondSubjectCode = s.SecondSubjectCode,
SecondSubjetName = s.SecondSubjetName,
Step = s.Step,
StepName = dic[s.Step]
}, queryModel.CurrentPage, queryModel.PageSize
, new Tuple <Expression <Func <CostAccount, object> >, SortOrder>(s => s.POCode, SortOrder.Descending)
, new Tuple <Expression <Func <CostAccount, object> >, SortOrder>(s => s.POLineNum, SortOrder.Ascending));
return(new PagedResultDto <CostAccountOut>(pageModels.Total, pageModels.Items));
}
public PagedResultDto <CostAccountConfigOut> GetAccountConfigsByPage(CostAccountConfigInput queryModel)
{
#region expression表达式
var expression = Expression(queryModel);
#endregion
//var count = _costAccountConfigRepository.Count(expression);
var model = _costAccountConfigRepository.PageListSelect(expression, s => new CostAccountConfig()
{
Id = s.Id,
CompanyCode = s.CompanyCode,
OrderType = s.OrderType,
ContentType = s.ContentType,
ProductCat1 = s.ProductCat1,
ProductCat2 = s.ProductCat2,
PayOutType1 = s.PayOutType1,
PayOutType2 = s.PayOutType2
}, queryModel.CurrentPage, queryModel.PageSize, new Tuple <Expression <Func <CostAccountConfig, object> >, SortOrder>(s => s.Id, SortOrder.Descending));
//签约公司
var companyInfos = _commonDataService.CompanyInfos();
//订单类型
var relevanceInfos = _commonDataService.GetRelevanceInfos(5);
//采购类型
var contentTypes = _commonDataService.GetDicInfos(701);
//物料分类
var productCat1s = _commonDataService.GetProductCategorys(level: 1, type: "MaterialClass");
//物料
var productCat2s = _commonDataService.GetProductCategorys(level: 2, type: "Material");
//支出类型1
var payOutType1s = _commonDataService.GetDicInfos(723);
var payOutType2s = new List <DicInfoDto>();
payOutType1s.ForEach(s =>
{
payOutType2s.AddRange(_commonDataService.GetDicInfos(s.DictId));
});
var models = new List <CostAccountConfigOut>();
foreach (var item in model.Items)
{
var tem = new CostAccountConfigOut()
{
Id = item.Id,
CompanyCode = item.CompanyCode,
CompanyName = item.CompanyCode == "-99" ? "缺省" : companyInfos.Where(s => s.CompanyCode == item.CompanyCode.ToString()).Select(s => s.CompanyName).FirstOrDefault(),
OrderType = item.OrderType,
OrderTypeName = relevanceInfos.Where(s => s.Key == item.OrderType.ToString()).Select(s => s.Value).FirstOrDefault(),
ContentType = item.ContentType,
ContentTypeName = item.ContentType == -99 ? "缺省" : contentTypes.Where(s => s.DictId == item.ContentType).Select(s => s.DictName).FirstOrDefault(),
ProductCat1 = item.ProductCat1,
ProductCat1Name = productCat1s.Where(s => s.ProductCatID == item.ProductCat1.ToString()).Select(s => s.Name).FirstOrDefault(),
ProductCat2 = item.ProductCat2,
ProductCat2Name = item.ProductCat2 == "-99" ? "缺省" : productCat2s.Where(s => s.ProductCatID == item.ProductCat2.ToString()).Select(s => s.Name).FirstOrDefault(),
PayOutType1 = item.PayOutType1,
PayOutType1Name = payOutType1s.Where(s => s.DictId == item.PayOutType1).Select(s => s.DictName).FirstOrDefault(),
PayOutType2 = item.PayOutType2,
PayOutType2Name = item.PayOutType2 == -99 ? "缺省" : payOutType2s.Where(s => s.DictId == item.PayOutType2).Select(s => s.DictName).FirstOrDefault(),
};
models.Add(tem);
}
return(new PagedResultDto <CostAccountConfigOut>(model.Total, models));
}
