Master.CanYinWu.DAL/Customer/CustomerTypeLevelDAL.cs

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

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

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

namespace Master.CanYinWu.DAL.Customer
{
   public class CustomerTypeLevelDAL
    {
        public async Task<int> Insert(CustomerTypeLevel model)
        {
            string sql = @"
                INSERT INTO [CustomerTypeLevel]
                           ([LevelRule],[AdminId],[StoreId])
                     VALUES
                           (@LevelRule,@AdminId,@StoreId)";
            using (var conn = ConnectionFactory.Connection())
            {
                return await conn.ExecuteAsync(sql, model);
            }
        }
        public async Task<int> Update(CustomerTypeLevel model)
        {
            try
            {
                string sql = @"
                           UPDATE [dbo].[CustomerTypeLevel]
                           SET 
                              [LevelRule] =@LevelRule,
                              ModifierId=@ModifierId,
                              UpdateTime=@UpdateTime
                         WHERE CustomerTypeLevelId=@CustomerTypeLevelId";
                using (var conn = ConnectionFactory.Connection())
                {
                    return await conn.ExecuteAsync(sql, model);
                }
            }
            catch (Exception ex)
            {

                throw;
            }
            
        }
        public async Task<CustomerTypeLevel> GetModelAsync(int id)
        {
            string sql = @"select top 1 *  from CustomerTypeLevel where CustomerTypeLevelId=@Id";
            using (var conn=ConnectionFactory.Connection())
            {
                return await conn.QueryFirstOrDefaultAsync<CustomerTypeLevel>(sql,new { Id=id });
            }
        }
        public async Task<Tuple<IEnumerable<CustomerTypeLevel>, int>> GetCustomerTypeLevelList(int pageIndex, int pageSize,int storeId)
        {
           string sql=$@"select a.* from(
                            SELECT   *,ROW_NUMBER() OVER(ORDER BY  CustomerTypeLevelId DESC) AS rownumber