www.pudn.com > VMLForAspnet.rar > WorkFlowDAL.cs

using System; 
using System.Data.SqlClient; 
using System.Data; 
 
namespace VML.WorkFlow 
{ 
	/// 
 
	/// WorkFlowItemDAL 的摘要说明。 
	/// 
 
	public class WorkFlowDAL 
	{ 
		private SqlDataAdapter dsCommand; 
 
		public WorkFlowDAL() 
		{ 
			// 
			// TODO: 在此处添加构造函数逻辑 
			// 
			// 创建数据适配器,和数据连接 
			dsCommand = new SqlDataAdapter(); 
 
			dsCommand.SelectCommand = new SqlCommand(); 
			dsCommand.SelectCommand.Connection  = new SqlConnection("Persist Security Info=False;User ID=sa;password=111;Initial Catalog=only_sp;Data Source=boqi"); 
			dsCommand.SelectCommand.Connection.Open(); 
			 
			//如数据集有多个表,这里需要手工添加表映射,系统默认的表名是Table,Table1,Table2......,如: 
			dsCommand.TableMappings.Add("Table","OnlySp_FlowDetail"); 
			//			dsCommand.TableMappings.Add("Table1","Relation"); 
		} 
 
		/// 
 
		/// 取得一个工作流的所有工作流项和之间的关系 
		/// 
 
		///  
		///  
		//		public VML.WorkFlow.WorkFlow GetWorkFlow(int WorkFlowID) 
		//		{ 
		//			System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand(); 
		//			command.CommandText = "GetWorkFlow"; 
		//			command.CommandType = System.Data.CommandType.StoredProcedure; 
		//			command.Connection = dsCommand.SelectCommand.Connection; 
		//			dsCommand.SelectCommand = command; 
		// 
		//			VML.WorkFlow.WorkFlow data = new VML.WorkFlow.WorkFlow(); 
		//			dsCommand.Fill(data); 
		// 
		//			return data; 
		// 
		//		} 
 
		/// 
 
		/// 取得某工作流程中的所有流转部门及其关系 
		/// 
 
		///  
		///  
		public VML.OnlySp.Flow GetFlowItems(int FlowBaseID) 
		{ 
			System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand(); 
			command.CommandText = "WorkFlow_GetFlowItems"; 
			command.CommandType = System.Data.CommandType.StoredProcedure; 
			command.Connection = dsCommand.SelectCommand.Connection; 
			dsCommand.SelectCommand = command; 
			command.Parameters.Add(new SqlParameter("@FlowBaseID",FlowBaseID)); 
			VML.OnlySp.Flow data=new VML.OnlySp.Flow(); 
			dsCommand.Fill(data); 
			return data; 
		} 
 
	} 
}