DAL/editable/tbUserRole.cs

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

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

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

namespace DAL
{
    /// <summary>
    /// 数据访问类 tbUserRole
    /// <summary>
    public partial class tbUserRole : DALHelper
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.tbUserRole model)
        {
            string strSql = "INSERT INTO tbUserRole(U_Account,RD_RoleID) VALUES (@in_U_Account,@in_RD_RoleID)";
            IDbDataParameter[] parms = DBUtility.DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, strSql);
            if (parms == null)
            {
                parms = new IDbDataParameter[]{
                    dbHelper.CreateDbParameter(PARM_U_ACCOUNT, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_RD_ROLEID, DbType.Int32, ParameterDirection.Input)};
            }

            parms[0].Value = model.U_Account;
            parms[1].Value = model.RD_RoleID;

            return dbHelper.ExecuteNonQuery(CommandType.Text, strSql, parms);
        }

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

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public int Delete(string U_Account, int? RD_RoleID)
        {
            IDbDataParameter[] parms4tbUserRole = PrepareDeleteParameters(U_Account, RD_RoleID);
            return dbHelper.ExecuteNonQuery(CommandType.Text, COMMAND_DELETE, parms4tbUserRole);
        }
        /// <summary>
        /// 删除特定U_Account的所有记录
        /// </summary>
        public int Delete(string U_Account)
        {
            string strSql = "DELETE FROM tbUserRole WHERE U_Account=@in_U_Account";
            IDbDataParameter[] parms = DBUtility.DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, strSql);
            if (parms == null)
            {
                parms = new IDbDataParameter[]{