PSI.DAL/MenuDAL.cs

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

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

using PSI.DbUtility;
using PSI.Models.DModels;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PSI.DAL
{
    public class MenuDAL : BaseDAL<MenuInfoModel>
    {
        /// <summary>
        /// 获取所有的菜单列表
        /// </summary>
        /// <returns></returns>
        public List<MenuInfoModel> GetMenuList()
        {
            string strWhere = " order by MOrder";
            string cols = "MId,MName,ParentId,MKey,MUrl,IsTop";
            return GetModelList(strWhere, cols);
        }

        /// <summary>
        /// 获取角色权限菜单列表
        /// </summary>
        /// <param name="roleIds"></param>
        /// <returns></returns>
        public List<MenuInfoModel> GetMenuList(string roleIds)
        {
            string strWhere = "1=1 and IsDeleted=0";
            string cols = "MId,MName,ParentId,MKey,MUrl,IsTop,MDesp";
            if (!string.IsNullOrEmpty(roleIds))
            {
                strWhere += $" and MId in (select MId from RoleMenuInfos where RoleId in ({roleIds})) ";
            }
            strWhere += " order by MOrder";
            return GetModelList(strWhere, cols);
        }

        /// <summary>
        /// 关键字查询菜单列表
        /// </summary>
        /// <param name="keywords"></param>
        /// <returns></returns>
        public List<MenuInfoModel> GetMenuListByKeyWords(string keywords)
        {
            string strWhere = "IsDeleted=0";
            if (!string.IsNullOrEmpty(keywords))
            {
                strWhere += " and (MName like @keywords or ParentName like @keywords)";
            }
            strWhere += " order by ParentId,MOrder";
            SqlParameter paraKeyWords = new SqlParameter("@keywords", $"%{keywords}%");
            string cols = "MId,MName,ParentId,ParentName,MKey,MUrl";
            return GetModelList(strWhere, cols, paraKeyWords);
        }