.NET经销商实战(七)——获取商品类型接口开发

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace DealerPlatform.Service.ProductApp.Vo
{
	/// 

	/// 商品类型返回值
	/// 
	public class ProductTypeVo
	{
		public string TypeNo { get; set; }
		public string TypeName { get; set; }
	}
}

public async Task> GetProductType()
		{
			return await Task.Run(() =>
						{
							var productType = ProductRepo.GetList().Where(s => !string.IsNullOrWhiteSpace(s.TypeName)).Select(s => new ProductTypeVo
							{
								TypeNo = s.TypeNo,
								TypeName = s.TypeName,
							}).Distinct().ToList();
							return productType;
						});
		}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace DealerPlatform.Service.ProductApp.Vo
{
	public class BelongTypeVo
	{
		public string SysNo { get; set; }
		// public string BelongTypeNo { get; set; }
		public string BelongTypeName { get; set; }
	}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using AutoMapper;
using DealerPlatform.Core.Repository;
using DealerPlatform.Domain.GlobalDto;
using DealerPlatform.Domain.Models;
using DealerPlatform.Service.ProductApp.Dto;
using DealerPlatform.Service.ProductApp.Vo;

namespace DealerPlatform.Service.ProductApp
{
	public partial class ProductService : IProductService
	{
		public ProductService(
			IRepository productRepo,
			IRepository productSaleRepo,
			IRepository productSaleAreaDiffRepo,
			IRepository productPhotoRepo,
			IMapper mapper)
		{
			ProductRepo = productRepo;
			ProductSaleRepo = productSaleRepo;
			ProductSaleAreaDiffRepo = productSaleAreaDiffRepo;
			ProductPhotoRepo = productPhotoRepo;
			Mapper = mapper;
		}

		public IRepository ProductRepo { get; }
		public IRepository ProductSaleRepo { get; }
		public IRepository ProductSaleAreaDiffRepo { get; }
		public IRepository ProductPhotoRepo { get; }
		public IMapper Mapper { get; }

		/// 

		/// 获取商品数据
		/// 
		/// 
		public async Task> GetProductDto(string systemNo, PageWithSortDto dto)
		{
			dto.Sort ??= "ProductName";
			// int skipNum = (pageIndex - 1) * pageSize;

			// var products = (from p in (await ProductRepo.GetListAsync())
			// 				orderby p.GetType().GetProperty(sort).GetValue(p)
			// 				select p).Skip(skipNum).Take(pageSize).ToList();
			//获取商品主档信息
			var products = await ProductRepo.GetListAsync(dto, s => s.SysNo == systemNo);

			var dtos = Mapper.Map>(products);
			var productPhotos = await GetProductPhotosByProductNo(dtos.Select(s => s.ProductNo).ToArray());
			var productSales = await GetProductSalesByProductNo(dtos.Select(s => s.ProductNo).ToArray());
			dtos.ForEach(s =>
			{
				s.ProductPhoto = productPhotos.FirstOrDefault(c => c.ProductNo == s.ProductNo);
				s.ProductSale = productSales.FirstOrDefault(c => c.ProductNo == s.ProductNo);
			});
			//根据productId取到属性
			return dtos;
		}
		public async Task> GetProductType()
		{
			return await Task.Run(() =>
						{
							var productType = ProductRepo.GetList().Where(s => !string.IsNullOrWhiteSpace(s.TypeName)).Select(s => new ProductTypeVo
							{
								TypeNo = s.TypeNo,
								TypeName = s.TypeName,
							}).Distinct().ToList();
							return productType;
						});
		}
		/// 

		/// 商品类型查询列表
		/// 
		/// 
		public async Task> GetBelongTypesAsync()
		{
			var data = ProductRepo.GetQueryable().Select(s => new BelongTypeVo
			{
				SysNo = s.SysNo,
				BelongTypeName = s.BelongTypeName,
			}).Distinct();
			return data.ToList();
		}
	}
}