role.cs

来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 144 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using SQLHelper;

namespace BookShop
{
    /// <summary>
    /// Summary description for Role
    /// </summary>
    public class Role
    {
        public SqlDataReader GetRoles()
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///定义保存从数据库获取的结果的DataReader
            SqlDataReader dr = null;

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_GetRoles", out dr);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }

            ///返回从数据库获取的结果
            return (dr);
        }

        public SqlDataReader GetSingleRole(int nRoleID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///定义保存从数据库获取的结果的DataReader
            SqlDataReader dr = null;

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
										   sqlHelper.CreateInParam("@RoleID",SqlDbType.Int,4,nRoleID)
									   };

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_GetSingleRole", paramList, out dr);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }

            ///返回从数据库获取的结果
            return (dr);
        }

        public int AddRole(string sRoleName)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@RoleName",SqlDbType.VarChar,200,sRoleName)
			};

            try
            {
                ///执行存储过程
                return (sqlHelper.RunProc("Pr_AddRole", paramList));
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }

        public void UpdateRole(int nRoleID, string sRoleName)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@RoleID",SqlDbType.Int,4,nRoleID),
                sqlHelper.CreateInParam("@RoleName",SqlDbType.VarChar,200,sRoleName)
			};

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_UpdateRole", paramList);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }

        public void DeleteRole(int nRoleID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@RoleID",SqlDbType.Int,4,nRoleID)
			};

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_DeleteRole", paramList);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }
    }
}