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

using System; 
using System.Data; 
using System.Data.SqlClient; 
using System.Collections; 
namespace UDS.Components 
{ 
	/// 
 
	/// 接点管理 
	/// 
 
	public class Class 
	{ 
		/// 
 
		/// 获取接点类型 
		/// 
 
		/// 接点ID 
		/// 返回接点类型 
		public string GetClassType(int ClassID)  
		{ 
			string ClassType		 = null; 
			SqlDataReader dataReader = null; 
			Database data			 = new Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@ClassID",    SqlDbType.Int, 8, ClassID) 
								   }; 
			data.RunProc("sp_GetClass", prams,out dataReader);    
			if(dataReader.Read()) 
			{ 
				ClassType = dataReader[3].ToString(); 
			} 
			else 
			{ 
				ClassType = ""; 
			} 
			return ClassType; 
		} 
 
	 
 
	 
		/// 
 
		/// 获取接点名字 
		/// 
 
		/// 接点ID 
		/// 返回接点名字 
		public string GetClassName(int ClassID)  
		{ 
			string ClassName		 = null; 
			SqlDataReader dataReader = null; 
			Database data			 = new Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@ClassID",    SqlDbType.Int, 8, ClassID) 
								   }; 
			data.RunProc("sp_GetClass", prams,out dataReader);    
			if(dataReader.Read()) 
			{ 
				ClassName = dataReader[1].ToString(); 
			} 
			else 
			{ 
				ClassName = ""; 
			} 
			return ClassName; 
		} 
 
 
		/// 
 
		/// 加目录节点 
		/// 
 
		/// 加目录节点 
		/// 加目录节点 
		public void AddClass(int ParentID,string ClassName,string ClassRemark,int ClassType,string AddedBy,DateTime AddedDate,int Status)  
		{ 
			Database data			 = new Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@ClassParentID" , SqlDbType.Int, 20, ParentID), 
									   data.MakeInParam("@ClassName" , SqlDbType.NVarChar, 20, ClassName), 
									   data.MakeInParam("@ClassRemark" , SqlDbType.NVarChar, 400, ClassRemark), 
									   data.MakeInParam("@ClassType" , SqlDbType.Int, 1, ClassType), 
									   data.MakeInParam("@AddedBy" , SqlDbType.NVarChar, 40, AddedBy), 
									   data.MakeInParam("@AddedDate" , SqlDbType.DateTime, 30, AddedDate), 
									   data.MakeInParam("@Status" , SqlDbType.Int, 1, Status) 
								   }; 
			 
			try  
			{ 
				data.RunProc("sp_AddTeam",prams); 
				 
			} 
			catch(Exception ex) 
			{ 
				Error.Log(ex.ToString()); 
				throw new Exception("目录添加出错",ex); 
			} 
			finally 
			{ 
				data	   = null; 
			} 
			 
			 
		} 
 
		 
		/// 
 
		/// 获取某节点详细信息 
		/// 
 
		/// 项目ID 
		public SqlDataReader GetClassDetail(int ClassID) 
		{ 
			SqlDataReader dataReader = null; 
			Database data = new Database(); 
			SqlParameter[] prams =  
								{ 
									data.MakeInParam("@ClassID",	SqlDbType.Int, 20 ,ClassID) 
								}; 
			try 
			{ 
				data.RunProc("sp_GetClass",prams, out dataReader); 
				return dataReader; 
			} 
						 
			catch(Exception ex) 
			{ 
				Error.Log(ex.ToString()); 
				return null; 
			} 
 
		} 
		 
		#region 获取用户相关项目 
		/// 
 
		/// 获取用户相关项目 
		/// 
 
		public SqlDataReader GetDeliverClass(string Username)  
		{ 
			// create data object and params 
			SqlDataReader dataReader = null; 
			Database data = new Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@UserName",      SqlDbType.NVarChar, 20, Username) 
								   }; 
			 
    
			try  
			{ 
				// run the stored procedure 
				data.RunProc("sp_GetDeliverClass",prams,out dataReader); 
				return dataReader; 
			} 
			catch (Exception ex)  
			{ 
				Error.Log(ex.ToString()); 
				throw new Exception("获取用户相关项目出错!",ex); 
			} 
		} 
		#endregion 
 
 
	} 
}