permissioncategory.cs

来自「wrox c#高级编程」· CS 代码 · 共 54 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace Wrox.WebModules.Accounts.Data
{
	/// <summary>
	/// Summary description for PermissionCategory.
	/// </summary>
	public class PermissionCategory : Wrox.WebModules.Data.DbObject
	{
		public PermissionCategory(string newConnectionString) : base( newConnectionString )
		{	}

		public DataRow Retrieve(int categoryId)
		{
			SqlParameter[] parameters = 
				{
					new SqlParameter("@CategoryID", SqlDbType.Int, 4)
				};
			parameters[0].Value = categoryId;

			using (DataSet categories = RunProcedure("sp_Accounts_GetPermissionCategoryDetails", parameters, "Categories"))
			{
				return categories.Tables[0].Rows[0];
			}
		}

		public DataSet GetPermissionsInCategory(int categoryId)
		{
			SqlParameter[] parameters =
				{
					new SqlParameter("@CategoryID", SqlDbType.Int, 4)
				};
			parameters[0].Value = categoryId;
			using (DataSet permissions = RunProcedure("sp_Accounts_GetPermissionsInCategory",
					   parameters, "Categories"))
			{
				return permissions;
			}		
		}

		public DataSet GetCategoryList()
		{
			using (DataSet categories = RunProcedure("sp_Accounts_GetPermissionCategories", 
					   new IDataParameter[]{}, 
					   "Categories"))
			{
				return categories;
			}
		}
	}
}