HN.DAL/Roles.cs

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

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

using System;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Data;
using HN.Utility;
using HN.Model;

namespace HN.DAL
{
    /// <summary>
    /// 角色表
    /// Author 2015-08-11
    /// </summary>
    public class Roles
    {
        #region 判断是否存在 Exists(object tran, string RoleName)
        /// <summary>
        /// 判断是否存在
        /// Author 2015-08-11
        /// </summary>
        public bool Exists(object tran, string RoleName)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from Roles");
            strSql.Append(" where ");
            strSql.Append(" RoleName = @RoleName  ");
            SqlParameter[] parameters = {
					new SqlParameter("@RoleName",RoleName)
			};

            object obj = SQLHelper.ExecuteScalar((SqlTransaction)tran, strSql.ToString(), parameters);
            return obj.ToString() == "0" ? false : true;
        }
        #endregion

        #region 增加一条数据 Add(object tran,RolesInfo model)
        /// <summary>
        /// 增加一条数据
        /// Author 2015-08-11
        /// </summary>
        public bool Add(object tran, RolesInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Roles(");
            strSql.Append("RoleName,IsDefault,Sort,Remark");
            strSql.Append(") values (");
            strSql.Append("@RoleName,@IsDefault,@Sort,@Remark");
            strSql.Append(") ");
            SqlParameter[] parameters = {
			            new SqlParameter("@RoleName", SqlDbType.NVarChar,50) ,  
                        new SqlParameter("@IsDefault", SqlDbType.Int,4) ,     
                        new SqlParameter("@Sort", SqlDbType.Int,4) ,            
                        new SqlParameter("@Remark", SqlDbType.NVarChar,200)             
             };

            parameters[0].Value = model.RoleName;
            parameters[1].Value = model.IsDefault;
            parameters[2].Value = model.Sort;
            parameters[3].Value = model.Remark;