DAL/editable/tbRoleFuncRights.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;

namespace DAL
{
    /// <summary>
    /// 数据访问类 tbRoleFuncRights
    /// <summary>
    public partial class tbRoleFuncRights : DALHelper
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.tbRoleFuncRights model)
        {
            IDbDataParameter[] parms4tbRoleFuncRights = PrepareAddParameters(model);
            return dbHelper.ExecuteNonQuery(CommandType.Text, COMMAND_ADD, parms4tbRoleFuncRights);
        }


        /// <summary>
        /// 批量增加权限
        /// </summary>
        public void Add(List<Model.tbRoleFuncRights> list)
        {
            string strDelSql = "DELETE FROM tbRoleFuncRights WHERE RD_RoleID=@in_RD_RoleID";
            IDbDataParameter[] parms = DBUtility.DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, strDelSql);
            if (parms == null)
            {
                parms = new IDbDataParameter[]{
                    dbHelper.CreateDbParameter(PARM_RD_ROLEID, DbType.Int32, ParameterDirection.Input)};
            }
            parms[0].Value = list[0].RD_RoleID;

            dbHelper.ExecuteNonQuery(CommandType.Text, strDelSql, parms);
            for (int i = 0; i < list.Count; i++)
            {
                if(!string.IsNullOrEmpty(list[i].FB_FuncBtnID))
                this.Add(list[i]);
            }
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public int Update(Model.tbRoleFuncRights model)
        {
            IDbDataParameter[] parms4tbRoleFuncRights = PrepareUpdateParameters(model);
            return dbHelper.ExecuteNonQuery(CommandType.Text, COMMAND_UPDATE, parms4tbRoleFuncRights);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public int Delete(int? RFR_ID)
        {
            IDbDataParameter[] parms4tbRoleFuncRights = PrepareDeleteParameters(RFR_ID);