Master.CanYinWu.DAL/MenuDAL.cs

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

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

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

namespace Master.CanYinWu.DAL
{
  public  class MenuDAL
    {
        private IDbConnection conn;
        #region 加载权限列表
        /// <summary>
        /// 加载权限列表
        /// </summary>
        /// <param name="start"></param>
        /// <param name="end"></param>
        /// <param name="key"></param>
        /// <returns></returns>
        public async Task<Tuple<IEnumerable<Menu>, int>> GetMenuList(int start, int end, string key = null)
        {
            StringBuilder sb = new StringBuilder(@"
                                                  SELECT t.*
                                                  FROM   (
                                                             SELECT mm.MenuId,
                                                                    mm.MenuUrl,
                                                                    mm.MenuName,
                                                                    mm.MenuImg,
                                                                    mm.CreateTime,
                                                                    mm.MenuParentId,
                                                                    mm.OrderBy,
                                                                    mm.IsDelete,
                                                                    mm.MenuType,
                                                                    mm.HttpMethod,
                                                                    ROW_NUMBER() OVER(ORDER BY CreateTime desc) AS rn,
                                                                    (
                                                                        SELECT m.MenuName
                                                                        FROM   Menu AS m
                                                                        WHERE  ( m.MenuParentId IS NULL or                                                              m.MenuParentId=0 )
                                                                               AND m.MenuId = mm.MenuParentId
                                                                    )     AS MenuParentName
                                                             FROM   menu     mm
                                                         ) AS t
                                                  WHERE  t.Isdelete = 0 ");

            DynamicParameters dp = new DynamicParameters();
            dp.Add("Start", start);
            dp.Add("End", end);
            StringBuilder sqlTotal = new StringBuilder(@"select count(1)  from menu where Isdelete=0");
            DynamicParameters dpTotal = new DynamicParameters();
            if (!string.IsNullOrEmpty(key))
            {
                sb.Append(" and MenuName like '%'+@Key+'%' ");
                dp.Add("Key", key);
                sqlTotal.Append(" and MenuName like '%'+@Key+'%' ");