DAL/AchieveDAL/ButtonDAL.cs

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

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

using AchieveCommon;
using AchieveEntity;
using AchieveInterfaceDAL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;

namespace AchieveDAL
{
    public class ButtonDAL : IButtonDAL
    {
        /// <summary>
        /// 根据菜单标识码和用户id获取此用户拥有该菜单下的哪些按钮权限
        /// </summary>
        public DataTable GetButtonByMenuCodeAndUserId(string menuCode, int userId)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select distinct(b.Id) id,b.Code code,b.Name name,b.Icon icon,b.Sort sort from tbUser u");
            strSql.Append(" join tbUserRole ur on u.Id=ur.UserId");
            strSql.Append(" join tbRoleMenuButton rmb on ur.RoleId=rmb.RoleId");
            strSql.Append(" join tbMenu m on rmb.MenuId=m.Id");
            strSql.Append(" join tbButton b on rmb.ButtonId=b.Id");
            strSql.Append(" where u.Id=@Id and m.Code=@MenuCode order by b.Sort");
            SqlParameter[] paras = {
                                   new SqlParameter("@Id",userId),
                                   new SqlParameter("@MenuCode",menuCode)
                                   };
            return SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras);
        }

        /// <summary>
        /// 根据条件获取按钮
        /// </summary>
        public DataTable GetAllButton(string where)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Id,Name,Code,Icon,Sort,[Description],CreateTime,CreateBy,UpdateTime,UpdateBy from tbButton");
            if (!string.IsNullOrEmpty(where))
            {
                strSql.Append(" where " + where);
            }
            strSql.Append(" order by Sort ");
            return SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, strSql.ToString(), null);
        }

        /// <summary>
        /// 根据按钮名获取按钮
        /// </summary>
        public ButtonEntity GetButtonByButtonName(string ButtonName)
        {
            string sql = "select top 1 Id,Name,Code,Icon,Sort,[Description],CreateTime,CreateBy,UpdateTime,UpdateBy from tbButton where Name = @ButtonName";
            ButtonEntity Button = null;
            DataTable dt = SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, sql, new SqlParameter("@ButtonName", ButtonName));
            if (dt.Rows.Count > 0)
            {
                Button = new ButtonEntity();
                DataRowToModel(Button, dt.Rows[0]);
                return Button;