public IActionResult Index() { //签约公司 var companyInfoDtos = _commonDataService.CompanyInfos(); var selectListItems = companyInfoDtos.Select(s => new SelectListItem(s.CompanyName, s.CompanyCode)).ToList(); selectListItems.Insert(0, new SelectListItem("缺省", "-99")); selectListItems.Insert(0, new SelectListItem("请选择", "")); ViewBag.Company = selectListItems; //订单来源(采购大类) var types = _commonDataService.GetRelevanceInfos(5).ToList(); var typesListItem = types.Select(s => new SelectListItem(s.Value, s.Key)).ToList(); typesListItem.Insert(0, new SelectListItem("请选择", "0")); ViewBag.Types = typesListItem; //物料分类 var productCategoryDtos = _commonDataService.GetProductCategorys(level: 1, type: "MaterialClass"); var productListItem = productCategoryDtos.Select(s => new SelectListItem(s.Name, s.ProductCatID)).ToList(); productListItem.Insert(0, new SelectListItem("请选择", "")); ViewBag.productCategories = productListItem; //支出类型一级 var payOutTypes = _commonDataService.GetDicInfos(723).ToList(); var payOutTypeListItem = payOutTypes.Select(s => new SelectListItem(s.DictName, s.DictId.ToString())).ToList(); payOutTypeListItem.Insert(0, new SelectListItem("请选择", "0")); ViewBag.payOutTypes = payOutTypeListItem; return(View()); }
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)); }