folderctrl.cs

这是一学习的好东西

using System;
using System.Data ;
using DocAdmin.DAL ;

namespace DocAdmin.BLL
{
	/// <summary>
	/// FolderCtrl 的摘要说明。
	/// </summary>
	public class FolderCtrl
	{
		public FolderCtrl()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		private int _ctrlID ;
		private int _folderID ;
		private int _userID ;
		private int _groupID ;
		private byte _adminCtrl ;
		private byte _writeCtrl ;
		private byte _readCtrl ;

		#region 公共方法
		public int CtrlID
		{
			get{ return _ctrlID ; }
			set{ _ctrlID = value ; }
		}

		public int FolderID
		{
			get{ return _folderID ; }
			set{ _folderID = value ; }
		}

		public int GroupID
		{
			get{ return _groupID ; }
			set{ _groupID = value ; }
		}

		public int UserID
		{
			get{ return _userID ; }
			set{ _userID = value ; }
		}

		public byte  AdminCtrl
		{
			get{ return _adminCtrl ; }
			set{ _adminCtrl = value ; }
		}

		public byte  WriteCtrl
		{
			get{ return _writeCtrl ; }
			set{ _writeCtrl = value ; }
		}

		public byte  ReadCtrl
		{
			get{ return _readCtrl ; }
			set{ _readCtrl = value ; }
		}
		#endregion

		#region 公共方法

		public int AddFolderCtrl()
		{
			int ret = -1 ;
			// 添加文件控制权限存储过程
			string spName = "Doc_FolderCtrl_Add" ;
			//参数
			object[] para = new object[]{"",_folderID,
											(_userID==0)?(object)DBNull.Value:_userID,
											(_groupID==0)?(object)DBNull.Value:_groupID,
											_adminCtrl,_writeCtrl,_readCtrl} ;
			//执行存储过程
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		//

		public int ModifyFolderCtrl()
		{
			int ret = -1 ;
			//修改文件权限存储过程
			string spName = "Doc_FolderCtrl_Modify" ;
			//参数
			object[] para = new object[]{_ctrlID,_folderID,
											(_userID==0)?(object)DBNull.Value:_userID,
											(_groupID==0)?(object)DBNull.Value:_groupID,
											_adminCtrl,_writeCtrl,_readCtrl} ;
			//执行存储过程
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;

		}

		public static int DeleteFolderCtrl(int ctrlID)
		{
			int ret = -1 ;
			//修改文件权限存储过程
			string spName = "Doc_FolderCtrl_Delete" ;
			//参数
			object[] para = new object[]{ctrlID} ;
			//执行存储过程
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		public static bool HasReadCtrl(int usrID,int groupID,int folderID)
		{
			bool ret = false ;
			//存储过程名，取文件的读取权限
			string spName = "Doc_Folder_GetReadCtrl" ;
			//存储过程参数
			object[] para = new object[] {"",usrID,groupID,folderID} ;

			//调用数据访问方法执行存储过程			
			if( DataAccess.ExecuteNonQuery(spName,true,para)  == 0 )
			{
				ret = true ;
			}

			return ret ;			
		}

		public static bool HasWriteCtrl(int usrID,int groupID,int folderID)
		{
			bool ret = false ;
			//存储过程名，取文件的读取权限
			string spName = "Doc_Folder_GetWriteCtrl" ;
			//存储过程参数
			object[] para = new object[] {"",usrID,groupID,folderID} ;

			//调用数据访问方法执行存储过程			
			if( DataAccess.ExecuteNonQuery(spName,true,para) == 0)
			{
				ret = true ;
			}

			return ret ;			
		}

		public static bool HasAdminCtrl(int usrID,int groupID,int folderID)
		{
			bool ret = false ;
			//存储过程名，取文件的读取权限
			string spName = "Doc_Folder_GetAdminCtrl" ;
			//存储过程参数
			object[] para = new object[] {"",usrID,groupID,folderID} ;

			//调用数据访问方法执行存储过程			
			if( DataAccess.ExecuteNonQuery(spName,true,para)  == 0)
			{
				ret = true ;
			}

			return ret ;			
		}

		public static DataTable GetFolderCtrlFromFolderID(int folderID)
		{
			//存储过程名
			string spName = "Doc_FolderCtrl_GetFromFolderID" ;
			//存储过程参数
			object[] para = new object[] {folderID} ;

			//调用数据访问方法执行存储过程			
			return DataAccess.ExecuteDataTable(spName,para) ;		
		}
		#endregion

	}
}