Master.CanYinWu.DAL/OrderDAL.cs

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

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

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

namespace Master.CanYinWu.DAL
{
    public class OrderDAL
    {
        public async Task<Tuple<IEnumerable<WareHousViewModel>, int>> GetList(int pageIndex, int pageSize, string key, DateTime? dateStart = null, DateTime? dateEnd = null, int? storeId = 0)
        {
            StringBuilder sb = new StringBuilder(@"
                                  SELECT tab.* 
   	                                FROM   (
   	                                       SELECT m.WareHousId,
   	                                              m.CreateTime,
   	                                              m.WareHousCode,
   	                                              AdminId,
                                                  (select UserName from admin where adminid=m.AdminId) as AdminName,
                                                  Remark,
   	                                              ROW_NUMBER() OVER( ORDER BY m.CreateTime DESC) AS 
   	                                              rownumber
   	                                       FROM   [WareHous]  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   [WareHous] AS m 
   	                                                     where m.IsDel = 0 and  storeId=@StoreId ");

            DynamicParameters dpTotal = new DynamicParameters();
            dpTotal.Add("StoreId", storeId); //用户id
            if (!string.IsNullOrEmpty(key))
            {
                sb.Append(" and m.WareHousCode like '%'+@Key+'%' ");
                sqlTotal.Append(" and m.WareHousCode like '%'+@Key+'%' ");
                dp.Add("Key", key);
                dpTotal.Add("Key", key);
            }

            if (dateStart.HasValue && dateEnd.HasValue)
            {
                dateEnd = dateEnd.Value.AddDays(1);
                sb.Append($" and m.CreateTime >'{dateStart}' and m.CreateTime<='{dateEnd}' ");
                sqlTotal.Append($" and m.CreateTime >'{dateStart}' and m.CreateTime<='{dateEnd}' ");
            }
            sb.Append("  ) AS tab  WHERE  tab.rownumber  BETWEEN(((@PageIndex - 1) * @PageSize) + 1) and @PageIndex * @PageSize");
            using (var conn = ConnectionFactory.Connection())
            {
                var query = await conn.QueryAsync<WareHousViewModel>(sb.ToString(), dp);
                var total = await conn.ExecuteScalarAsync<int>(sqlTotal.ToString(), dpTotal);