QMS.DAL/SysRoleLimitDAL.cs

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

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

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Mvc;
using QMS.Model;
using QMS.Common;
using System.Web.Caching;
using System.Transactions;

namespace QMS.DAL
{
    /// <summary>
    /// 角色授权-数据访问类
    /// 创建人:Jimy
    /// 日期:2016/8/6 2:50:13
    /// </summary>

    public class SysRoleLimitDAL : Base.SysRoleLimit
    {
        #region 获取缓存DataSet
        /// <summary>
        /// 获取缓存DataSet
        /// </summary>
        /// <param name="trans"></param>
        /// <returns></returns>
        public DataSet GetCacheDataSet(SqlTransaction trans, int SysRoleID)
        {
            string key = "Cache_SysRoleLimit_DataSet_" + SysRoleID;
            DataSet ds;
            object value = CacheHelper.GetCache(key);
            if (value != null)
                ds = (DataSet)value;
            else
            {
                ds = GetDataSet(trans, CommandType.Text, "select * from t_SysRoleLimit where SysRoleID=" + SysRoleID, null);
                CacheHelper.AddCache(key, ds, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
            }
            return ds;
        }
        #endregion
        
        #region 批量保存权限配置
        /// <summary>
        /// 批量保存权限配置
        /// </summary>
        /// <param name="SysRoleID"></param>
        /// <param name="ModuleLimits"></param>
        public void SaveRoleLimit(int SysRoleID, string[] ModuleLimits)
        {
            if (ModuleLimits != null && ModuleLimits.Length > 0)
            {
                //1.定义DataTable
                DataTable dt = new DataTable();
                dt.Columns.Add("SysRoleID", typeof(int));
                dt.Columns.Add("ModuleValue", typeof(string));
                dt.Columns.Add("LimitValue", typeof(string));