.NET经销商实战(十二)——优化用户体验，完善产品列表查询

search: async () => {
        clearTimeout(productInfo.timer)
        productInfo.timer = setTimeout(async () => {
          router.push(`productList?keyword=${productInfo.searchText}`)
          // productInfo.products = await getProduct({
          //   searchText: productInfo.searchText,
          //   systemNo: productInfo.systemIndex,
          //   productType: productInfo.typeSelected,
          //   sort: 'ProductName',
          //   pageIndex: 1,
          // })
        }, 1000)
      },

search: async () => {
        clearTimeout(productInfo.timer)
        productInfo.timer = setTimeout(async () => {
          setRouter()
        }, 1000)
      },

const setRouter = () => {
      var url = `/productList?belongType=${productInfo.systemIndex}`
      if (productInfo.searchText?.trim() != '') {
        url += `&keyword=${productInfo.searchText}`
      }
      if (productInfo.typeSelected?.trim() != '') {
        url += `&type=${productInfo.typeSelected}`
      }
      router.push(url)
    }

selectType: async (typeNo: string) => {
        if (productInfo.typeSelected != typeNo) {
          productInfo.typeSelected = typeNo
        }

        setRouter()
        // await productInfo.getProducts(
        //   productInfo.systemIndex,
        //   productInfo.typeSelected,
        //   null
        // )
        console.log('productInfo.typeSelected: ' + productInfo.typeSelected)
      },

public async Task> GetProductDtosAsync(
			string? searchText,
			string? productType,
			string? systemNo = "板材",
			string? props = "",
			string? sort = "",
			int pageIndex = 1,
			int pageSize = 30,
			OrderType orderType = OrderType.Asc)
		{
			Dictionary dicProductProps = new();
			var arrproductProps = props?.Split('^') ?? new string[0];
			foreach (var item in arrproductProps)
			{
				var key = item.Split('_')[0];
				var value = item.Split('_')[1];
				dicProductProps.Add(key, value);
			}
			sort ??= "ProductName";
			var data = await ProductService.GetProductDto(searchText, productType, systemNo, dicProductProps, new PageWithSortDto
			{
				Sort = sort,
				PageIndex = pageIndex,
				PageSize = pageSize,
				OrderType = orderType
			});
			return data;
		}

public async Task> GetProductDto(string searchText, string? productType, string systemNo, Dictionary dicProductProps, PageWithSortDto dto)
		{
			dto.Sort ??= "ProductName";
			int skipNum = (dto.PageIndex - 1) * dto.PageSize;
			var bzgg = dicProductProps.ContainsKey("ProductBZGG") ? dicProductProps["ProductBZGG"] : null;
			dicProductProps.TryGetValue("ProductCd", out string cd);
			dicProductProps.TryGetValue("ProductPp", out string pp);
			dicProductProps.TryGetValue("ProductXh", out string xh);
			dicProductProps.TryGetValue("ProductCz", out string cz);
			dicProductProps.TryGetValue("ProductHb", out string hb);
			dicProductProps.TryGetValue("ProductHd", out string hd);
			dicProductProps.TryGetValue("ProductGy", out string gy);
			dicProductProps.TryGetValue("ProductHs", out string hs);
			dicProductProps.TryGetValue("ProductMc", out string mc);
			dicProductProps.TryGetValue("ProductDj", out string dj);
			dicProductProps.TryGetValue("ProductGg", out string gg);
			dicProductProps.TryGetValue("ProductYs", out string ys);

			// var products = (from p in (await ProductRepo.GetListAsync())
			// 				orderby p.GetType().GetProperty(sort).GetValue(p)
			// 				select p).Skip(skipNum).Take(pageSize).ToList();
			//获取商品主档信息
			var products = ProductRepo.GetQueryable().Where(
				s => (s.TypeNo == productType || string.IsNullOrWhiteSpace(productType))
				&& (s.SysNo == systemNo || string.IsNullOrWhiteSpace(systemNo))
				&& (s.ProductName.Contains(searchText) || string.IsNullOrWhiteSpace(searchText))
				&& (bzgg == null || s.ProductBzgg == bzgg)
				&& (cd == null || s.ProductCd == cd)
				&& (pp == null || s.ProductPp == pp)
				&& (xh == null || s.ProductXh == xh)
				&& (cz == null || s.ProductCz == cz)
				&& (hb == null || s.ProductHb == hb)
				&& (hd == null || s.ProductHd == hd)
				&& (gy == null || s.ProductGy == gy)
				&& (hs == null || s.ProductHs == hs)
				&& (mc == null || s.ProductMc == mc)
				&& (dj == null || s.ProductDj == dj)
				&& (gg == null || s.ProductGg == gg)
				&& (ys == null || s.ProductYs == ys))
				.OrderBy(s => dto.Sort).Skip(skipNum).Take(dto.PageSize);

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