Master.CanYinWu.DAL/MenuBarDAL.cs

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

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

using Dapper;
using Master.CanYinWu.Entity;
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 MenuBarDAL
    {
        #region 加载投资金额列表
        public async Task<Tuple<IEnumerable<MenuBar>, int>> GetList(int pageIndex, int pageSize, string key)
        {
            StringBuilder sb = new StringBuilder(@"SELECT *
                                            FROM (
                                            	SELECT *, ROW_NUMBER() OVER (ORDER BY MenubarId ASC) AS rownumber
                                            	FROM menubar
                                            ) a
                                            WHERE isdelete = 0 ");
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);
            dp.Add("PageSize", pageSize);
            StringBuilder sqlTotal = new StringBuilder(@"select count(1)  from menubar where isdelete=0");
            DynamicParameters dpTotal = new DynamicParameters();
            if (!string.IsNullOrEmpty(key))
            {
                sb.Append(" and MValue like '%'+@Key+'%' ");
                dp.Add("Key", key);
                sqlTotal.Append(" and MValue like '%'+@Key+'%' ");
                dpTotal.Add("Key", key);
            }
            sb.Append(" and rownumber BETWEEN (((@PageIndex-1)*@PageSize)+1) and @PageIndex*@PageSize ");
            using (var conn = ConnectionFactory.Connection())
            {
                var query = await conn.QueryAsync<MenuBar>(sb.ToString(), dp);
                var total = await conn.ExecuteScalarAsync<int>(sqlTotal.ToString(), dpTotal);
                return new Tuple<IEnumerable<MenuBar>, int>(query, total);
            }
        }
        #endregion
        #region 编辑
        public async Task<int> EditMenuBar(MenuBar bar)
        {
            string sql = @"update  Menubar set MType=@MType,MKey=@mkey,MValue=@mvalue  where MenubarId=@MenubarId";
            using (var conn = ConnectionFactory.Connection())
            {
                int i = await conn.ExecuteAsync(sql, bar);
                return i;
            }
        } 
        #endregion
        #region 添加
        public async Task<int> AddMenuBar(MenuBar bar)
        {
            string sql = @"INSERT INTO [dbo].[Menubar]
                                      (MType
                                      ,IsDelete