PSI.DAL/ToolMenuDAL.cs

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

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

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

namespace PSI.DAL
{
   public  class ToolMenuDAL:BaseDAL<ToolMenuInfoModel>
    {
        /// <summary>
        /// 获取角色工具栏菜单项数据
        /// </summary>
        /// <param name="roleIds"></param>
        /// <returns></returns>
        public List<ToolMenuInfoModel> GetToolMenuList(string roleIds)
        {
            string strWhere = "IsDeleted=0";
            string cols = "TMenuId,TMenuName,TMPic,TMOrder,TGroupId,TMUrl,IsTop,TMDesp";
            if (!string.IsNullOrEmpty(roleIds))
            {
                strWhere += $" and TMenuId in (select TMenuId from RoleTMenuInfos where RoleId in ({roleIds})) ";
            }
            strWhere += " order by TGroupId, TMOrder";
            return GetModelList(strWhere, cols);
        }

        /// <summary>
        /// 获取所有的工具菜单项（绑定TreeView）
        /// </summary>
        /// <returns></returns>
        public  List<ToolMenuInfoModel> GetToolMenuList()
        {
            string cols = "TMenuId,TMenuName";
            return GetModelList(cols);
        }

        /// <summary>
        /// 关键字查询工具菜单项列表
        /// </summary>
        /// <param name="keywords"></param>
        /// <returns></returns>
        public List<ToolMenuInfoModel> GetToolMenuInfos(string keywords,bool blShow)
        {
            string strWhere = "1=1";
            if (blShow)
                strWhere += "  and IsDeleted=1";
            else
                strWhere += " and IsDeleted=0";
            string cols = "TMenuId,TMenuName,TMPic,TMOrder,TMUrl,TGroupId";
            if (!string.IsNullOrEmpty(keywords))
            {
                strWhere += " and TMenuName like @keywords";
                SqlParameter para = new SqlParameter("@keywords", $"%{keywords}%");
                return GetModelList(strWhere, cols, para);
            }
            else