DAL/AuthorityDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
    public class AuthorityDAL
    {


        /// <summary>
        /// 添加 
        ///</summary>
        public static int AddAuthority(Authority AuthorityModel)
        {
            string sql = string.Format("insert into  Authority (ModuleId,RoleId,IsVisible )values({0},{1},'{2}')",AuthorityModel.ModuleId,AuthorityModel.RoleId,AuthorityModel.IsVisible);
            return DBHelper.ExecuteCommand(sql);
        }
        /// <summary> 
        /// 根据RoleId删除 
        ///</summary>
        public static int DeleteAuthorityByRoleId(int RoleId)
        {
            string sql = string.Format("delete from Authority where RoleId={0}", RoleId);
            return DBHelper.ExecuteCommand(sql);
        }

       

     /// <summary>
     /// 根据角色ID及模块功能ID
     /// </summary>
     /// <param name="RoleId"></param>
     /// <param name="ModuleId"></param>
     /// <returns></returns>
        public static Authority GetByRoleIdAndModuleId(int RoleId, int ModuleId)
        {
            string sql = "select * from Authority where RoleId=" + RoleId + " and ModuleId=" + ModuleId;
            Authority AuthorityModel = new Authority();
            using (DataTable table = DBHelper.GetDataSet(sql))
            {
                AuthorityModel = GetMode(table);
            }
            return AuthorityModel;
        }

        /// <summary> 
        /// 根据ID修改 
        ///</summary>
        public static int UpdateAuthority(Authority AuthorityModel)
        {
            string sql = string.Format(" UPDATE Authority  set ModuleId={0},RoleId={1},IsVisible='{2}' where AuthorityId={3} ",AuthorityModel.ModuleId,AuthorityModel.RoleId,AuthorityModel.IsVisible  ,AuthorityModel.AuthorityId);
            return DBHelper.ExecuteCommand(sql);
        }

        /// <summary>