Master.CanYinWu.DAL/ProductDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Dapper;
using Master.CanYinWu.Entity;
using Master.CanYinWu.Entity.ViewModel;
using Master.CanYinWu.Utility;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Master.CanYinWu.DAL
{
    public class ProductDAL
    {


        public async Task<Tuple<IEnumerable<ProductViewModel>, int>> GetList(int pageIndex, int pageSize, string key,  int bigCategoryId = 0, int smallCategoryId = 0,  DateTime? dateStart = null, DateTime? dateEnd = null, int? storeId = 0)
        {
            StringBuilder sb = new StringBuilder(@"
                                  SELECT tab.* 
   	                                FROM   (
   	                                       SELECT m.ProductId,
   	                                              m.CreateTime,
   	                                              m.Name,
                                                  (select name from sysunit where sysunit.SysUnitId=m.UnitId) as  UnitName,
                                                  m.SupplierId,
                                                  (select name from supplier where supplier.supplierid=m.supplierId) as SupplierName,
   	                                              m.PurchasePrice,
                                                  m.SellingPrice,
                                                  m.ImgPath,
                                                  m.Inventor,
   	                                              (
   	                                                  SELECT c.CategoryName
   	                                                  FROM   Category AS c	 WITH(NOLOCK)
   	                                                  WHERE  c.CategoryId = m.BigCategoryId
   	                                                         AND c.ParentId = 0
   	                                              )          AS BigCategoryName,
   	                                             (
   	                                                   SELECT c.CategoryName
   	                                                   FROM   Category AS c	  WITH(NOLOCK)
   	                                                   WHERE  c.CategoryId = m.SmallCategoryId
   	                                                      AND c.ParentId <>0
   	                                              )          AS SmallCategoryName,
                                                  
   	                                              
   	                                              ROW_NUMBER() OVER( ORDER BY m.CreateTime DESC) AS 
   	                                              rownumber
   	                                       FROM   [Product]  AS m
   	                                      where  m.IsDel = 0 and m.storeId=@StoreId
   	                                     ");
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);
            dp.Add("PageSize", pageSize);
            dp.Add("StoreId", storeId); //用户id
            StringBuilder sqlTotal = new StringBuilder(@"  
                                                        SELECT COUNT(*)
   	                                                    FROM   [Product] AS m 
   	                                                     where m.IsDel = 0 and  storeId=@StoreId ");

            DynamicParameters dpTotal = new DynamicParameters();