DAL/editable/tbUserFuncRights.cs

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

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

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

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

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

            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.tbUserFuncRights model)
        {
            IDbDataParameter[] parms4tbUserFuncRights = PrepareUpdateParameters(model);
            return dbHelper.ExecuteNonQuery(CommandType.Text, COMMAND_UPDATE, parms4tbUserFuncRights);
        }

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