userrole.cs

来自「建立系统架构的说明(教你怎样搭好框架).rar」· CS 代码 · 共 67 行

using System;
using System.Collections.Generic;
using System.Text;
using IAS.BookShop.Model;
using System.Data.SqlClient;
using System.Data;
namespace IAS.BookShop.DAL
{
    public class UserRole
    {
        private const string PARM_Id = "@Id";
        private const string PARM_Name = "@Name";

        private const string SELECTQUERY = "SELECT Id, Name FROM UserRoles ";
        private const string WHEREQUERY = " WHERE Id = @Id";
        private const string INSERTQUERY = "INSERT INTO UserRoles (Name) VALUES (@Name)";
        private const string UPDATEQUERY = "UPDATE UserRoles SET (Name = @Name) WHERE Id = @Id";
        private const string DELETEQUERY = "DELETE FROM UserRoles WHERE Id = @Id";

        public void Add(UserRoleInfo roleInfo)
        {
            SqlParameter parm = new SqlParameter(PARM_Name, SqlDbType.NVarChar, 50);
            parm.Value = roleInfo.Name;
            SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, INSERTQUERY, parm);
        }
        public void Modify(UserRoleInfo roleInfo)
        {
            SqlParameter parm = new SqlParameter(PARM_Name, SqlDbType.NVarChar, 50);
            parm.Value = roleInfo.Name;
            SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, UPDATEQUERY, parm);
        }
        public void Delete(int id)
        {
            SqlParameter parm = new SqlParameter(PARM_Id, SqlDbType.Int, 4);
            parm.Value = id;
            SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, DELETEQUERY, parm);
        }
        public UserRoleInfo GetRoleById(int id)
        {
            SqlParameter parm = new SqlParameter(PARM_Id, SqlDbType.Int, 4);
            parm.Value = id;
            using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text,
                                                                        SELECTQUERY + WHEREQUERY, parm))
            {
                if (rdr.Read())
                    return new UserRoleInfo(rdr.GetInt32(0), rdr.GetString(1));
            }
            return null;
        }
        public IList<UserRoleInfo> GetList()
        {
            IList<UserRoleInfo> list = null;
            using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text, SELECTQUERY))
            {
                if (rdr.HasRows)
                    list = new List<UserRoleInfo>();
                else
                    return list;

                while (rdr.Read())
                    list.Add(new UserRoleInfo(rdr.GetInt32(0), rdr.GetString(1)));
            }
            return list;
        }
    }
}