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

namespace DocAdmin.BLL
{
	/// <summary>
	/// FolderInfo 的摘要說明。
	/// </summary>
	public class FolderInfo
	{
		public FolderInfo()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		private int _folderID ;
		private int _parentID ;
		private string _folderName ;
		private string _note ;
		private int _type ;
		private DateTime _crdt ;
		private DateTime _mddt ;
		private DateTime _dldt ;
		private int _crusr ;
		private int _mdusr ;
		private int _dlusr ;
		private int _status ;
		private string _usrName ;

		#region 公共屬性
		public int FolderID
		{
			get{ return _folderID ; }
			set{ _folderID = value ;}
		}

		public int ParentID
		{
			get{ return _parentID ; }
			set{ _parentID = value ;}
		}

		public string FolderName
		{
			get{ return _folderName ; }
			set{ _folderName = value ;}
		}

		public string Note
		{
			get{ return _note ; }
			set{ _note = value ;}
		}

		public int Type
		{
			get{ return _type ; }
			set{ _type = value ;}
		}

		public DateTime CRDT
		{
			get{ return _crdt ; }
			set{ _crdt = value ;}
		}

		public DateTime MDDT
		{
			get{ return _mddt ; }
			set{ _mddt = value ;}
		}

		public DateTime DLDT
		{
			get{ return _dldt ; }
			set{ _dldt = value ;}
		}

		public int CrUsr
		{
			get{ return _crusr ; }
			set{ _crusr = value ;}
		}

		public int MdUsr
		{
			get{ return _mdusr ; }
			set{ _mdusr = value ;}
		}

		public int DlUsr
		{
			get{ return _dlusr ; }
			set{ _dlusr = value ;}
		}

		public int Status
		{
			get{ return _status ; }
			set{ _status = value ;}
		}

		public string UsrName
		{
			get{ return _usrName ;}
			set{ _usrName = value ;}
		}
		#endregion

		#region 公共方法

		public static DataTable GetSameLevelFolder(int folderID)
		{
			//存儲過程名
			string spName = "Doc_Folder_GetSameLevelFolder" ;
			//存儲過程參數
			object[] para = new object[] {folderID} ;

			//調用數據訪問方法執行存儲過程			
			return DataAccess.ExecuteDataTable(spName,para) ;	
		}

		public int GetFolder(int folderID)
		{
			int ret = -1 ;

			//存儲過程名
			string spName = "Doc_Folder_Get" ;
			//存儲過程參數
			object[] para = new object[] {folderID} ;

			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count > 0)
			{
				DataRow dr = dt.Rows[0] ;
				AssignAttribute(dr) ;
				ret = 0 ;
			}
			return ret ;
		}

		private void AssignAttribute(DataRow dr)
		{
			_folderID = CommHandler.StringToInt(dr["FolderID"].ToString()) ;
			_folderName = dr["FolderName"].ToString() ;
			_parentID = CommHandler.StringToInt(dr["ParentID"].ToString()) ;
			_note = dr["Note"].ToString() ;
			_crusr = CommHandler.StringToInt(dr["UserID"].ToString()) ;
			_crdt = CommHandler.StringToDateTime(dr["CRDT"].ToString()) ;
			_mdusr = CommHandler.StringToInt(dr["MdUsr"].ToString()) ;
			_mddt = CommHandler.StringToDateTime(dr["mddt"].ToString()) ;
			_usrName = dr["userName"].ToString() ;
		}

		public static DataTable GetFolderForTree()
		{
			//存儲過程名
			string spName = "Doc_Folder_GetParent" ;
			
			//調用數據訪問方法執行存儲過程			
			return DataAccess.ExecuteDataTable(spName) ;
		}

		/// <summary>
		/// 查找目錄樹的節點
		/// </summary>
		/// <param name="parentID">父節點ID，如果為0表示是一級節點</param>
		/// <returns>DataTable，節點</returns>
		public static DataTable GetFolderForTree(int parentID)
		{			
			//存儲過程名
			string spName = "Doc_Folder_GetForTree" ;
			//存儲過程參數
			object[] para = new object[] {parentID} ;

			//調用數據訪問方法執行存儲過程			
			return DataAccess.ExecuteDataTable(spName,para) ;			
		}

		public static int GetParentID(int folderID)
		{
			int ret = 0 ;

			//存儲過程名
			string spName = "Doc_Folder_GetParentID" ;
			//存儲過程參數
			object[] para = new object[] {folderID} ;

			//調用數據訪問方法執行存儲過程			
			ret = CommHandler.StringToInt(DataAccess.ExecuteScalar(spName,para).ToString() ) ;

			return ret ;
		}

		public static string GetPath(int folderID)
		{
			//存儲過程名
			string spName = "Doc_Folder_GetPath" ;

			//存儲過程參數
			object[] para = new object[] {folderID} ;

			return DataAccess.ExecuteScalar(spName,para).ToString() ;
			
		}

		public static int DeleteFolder(int folderID)
		{
			//存儲過程名
			string spName = "Doc_Folder_Delete" ;

			//存儲過程參數
			object[] para = new object[] {folderID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}

		public int AddFolderInfo()
		{
			int ret = -1 ;

			//存儲過程名
			string spName = "Doc_Folder_Add" ;
			//存儲過程參數
			object[] para = new object[] {"",_parentID,_folderName,_note,_crusr} ;

			//調用數據訪問方法執行存儲過程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		public int ModifyFolderInfo()
		{
			int ret = -1 ;
			//存儲過程名
			string spName = "Doc_Folder_Modify" ;
			//存儲過程參數
			object[] para = new object[] {_folderID,_parentID,_folderName,_note,_crusr} ;

			//調用數據訪問方法執行存儲過程			
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}

		public static int RevertFolder(int folderID)
		{
			//存儲過程名
			string spName = "Doc_Folder_Revert" ;

			//存儲過程參數
			object[] para = new object[] {folderID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}

		public static int RecycleFolder(int folderID,int usrid)
		{
			//存儲過程名
			string spName = "Doc_Folder_Recycle" ;

			//存儲過程參數
			object[] para = new object[] {folderID,usrid} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}

		public static int MoveFolder(int folderID,int parentID)
		{
			//存儲過程名
			string spName = "Doc_Folder_Move" ;

			//存儲過程參數
			object[] para = new object[] {folderID,parentID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}
		#endregion
			
	}
}