www.pudn.com > UDS1.1_51aspx.rar > Role.cs

using System; 
using System.Data; 
using System.Data.SqlClient; 
 
namespace UDS.Components 
{ 
	/// 
 
	/// Role 的摘要说明。 
	/// 
 
	public class Role 
	{ 
 
		public Role() 
		{ 
			 
		} 
		/// 
 
		/// 添加角色 
		/// 
 
		/// 角色名 
		/// 角色描述 
		/// 角色ID 
		public static int Add(string rolename,string roledescription) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
										db.MakeInParam("@Role_Name",SqlDbType.VarChar,300,rolename.Trim()), 
										db.MakeInParam("@Role_Description",SqlDbType.VarChar,300,roledescription.Trim()) 
								   }; 
			return(db.RunProc("sp_AddMyRole",prams)); 
		} 
		/// 
 
		/// 删除角色 
		/// 
 
		/// 角色ID 
		/// 0成功1不成功 
		public static int Delete(int roleid) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									   db.MakeInParam("@role_id",SqlDbType.Int,4,roleid) 
								   }; 
			return(db.RunProc("sp_DeleteRole",prams)); 
		} 
		/// 
 
		/// 修改角色信息 
		/// 
 
		/// 角色ID 
		/// 角色名称 
		/// 角色描述 
		/// 返回值（0成功1不成功） 
		public static int Modify(int roleid,string rolename,string roledescription) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
										db.MakeInParam("@role_id",SqlDbType.Int ,4,roleid), 
										db.MakeInParam("@role_name",SqlDbType.VarChar,300,rolename.Trim()), 
										db.MakeInParam("@role_description",SqlDbType.VarChar,300,roledescription.Trim()) 
								   }; 
			return(db.RunProc("sp_UpdateRoleInfo",prams)); 
		} 
		/// 
 
		/// 从角色中删除成员 
		/// 
 
		/// 角色id 
		/// 成员id 
		/// 返回值 
		public static int DelStaffFromRole(int roleid,string staffid) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
										db.MakeInParam("@Role_ID",SqlDbType.Int,4,roleid), 
										db.MakeInParam("@StaffIDS",SqlDbType.VarChar,3000,staffid) 
								   }; 
			return(db.RunProc("sp_DeleteStaffFromRole",prams)); 
		} 
		/// 
 
		/// 从角色中添加成员 
		/// 
 
		/// 角色id 
		/// 非成员id 
		/// 返回值 
		public static int AddStaffFromRole(int roleid,string staffid) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
										db.MakeInParam("@Role_ID",SqlDbType.Int,4,roleid), 
										db.MakeInParam("@StaffIDS",SqlDbType.VarChar,3000,staffid) 
								   }; 
			return(db.RunProc("sp_AddStaffToRole",prams)); 
		} 
		/// 
 
		/// 根据rolename得到roleid 
		/// 
 
		/// 角色名称 
		/// 角色id 
		public static int GetRoleIDByName(string rolename) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			int roleid = 0; 
			SqlDataReader dr = null; 
			SqlParameter[] prams = { 
									   db.MakeInParam("@rolename",SqlDbType.VarChar,100,rolename), 
								   }; 
			db.RunProc("sp_GetRoleIDFromName",prams,out dr); 
			while(dr.Read()) 
			{ 
				roleid = Int32.Parse(dr["role_id"].ToString()); 
			} 
			return(roleid); 
		} 
		public SqlDataReader GetRoleInfo(long RoleID) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlDataReader dr = null; 
			SqlParameter[] prams = { 
									   db.MakeInParam("@RoleID",SqlDbType.Int ,4,RoleID), 
			}; 
			db.RunProc("sp_GetRoleInfo",prams,out dr); 
 
			return(dr); 
 
		} 
 
		public string GetRoleInfo(long RoleID,string FiledName) 
		{ 
			UDS.Components.Database db = new UDS.Components.Database(); 
			SqlDataReader dr = null; 
			SqlParameter[] prams = { 
									   db.MakeInParam("@RoleID",SqlDbType.Int ,4,RoleID), 
			}; 
			db.RunProc("sp_GetRoleInfo",prams,out dr); 
			try 
			{ 
				if(dr.Read())	 
				{ 
					try 
					{ 
						return dr[FiledName].ToString(); 
					} 
					catch 
					{ 
						return ""; 
					} 
				} 
				else 
					return ""; 
			} 
			finally 
			{ 
				dr = null; 
				db = null; 
			} 
 
		} 
 
 
	} 
}