rolem.cs

精通网络应用系统开发 光盘 该书是人民邮电出版社出版的

using System;
using System.Data;
using System.Data.Linq;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Xml.Linq;
using System.Collections.Generic;

/// <summary>
/// Summary description for RoleM
/// </summary>
public class RoleM
{
	public RoleM()
	{
	}
    /// <summary>
    /// 返回角色信息
    /// </summary>
    /// <returns>角色集合</returns>
    public IList<Role> GetRoles()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        IList<Role> roles;
        try
        {
            ///执行存储过程
            roles = db.Roles.ToList();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
        ///返回从数据库获取的结果
        return (roles);
    }
    /// <summary>
    /// 获取指定的角色
    /// </summary>
    /// <param name="nRoleID">角色ID</param>
    /// <returns>一个角色对象</returns>
     public Role GetSingleRole(int nRoleID)
     {
         DataClassesDataContext db = new DataClassesDataContext();
         Role role;
        try
        {
            role = db.Roles.Where(r => r.RoleID == nRoleID).First();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (role);
    }
    /// <summary>
    /// 添加角色
    /// </summary>
    /// <param name="sRoleName">角色名称</param>
     /// /// <param name="nTreeID">所选择树的ID</param>
    public void AddRole(string sRoleName, int nTreeID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //创建新角色,并添加到角色集合
            Role myrole = new Role { RoleName = sRoleName, TreeID=nTreeID };
            db.Roles.InsertOnSubmit(myrole);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 更新角色名称
    /// </summary>
    /// <param name="nRoleID">要更新的角色ID</param>
    /// <param name="sRoleName">角色名称</param>
    public void UpdateRole(int nRoleID, string sRoleName)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //首先找到要更新的角色
            Role myrole = db.Roles.Where(p => p.RoleID == nRoleID).First();
            //更新名称
            myrole.RoleName = sRoleName;
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 删除指定的角色
    /// </summary>
    /// <param name="nRoleID"></param>
    public void DeleteRole(int nRoleID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //获取要删除的角色对象
            Role myrole = db.Roles.Where(r => r.RoleID == nRoleID).First();
            //从集合中删除并提交到数据库
            db.Roles.DeleteOnSubmit(myrole);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }

}