workflowdal.cs

vml开发工作流设计器,使用C#实现

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

namespace VML.WorkFlow
{
	/// <summary>
	/// WorkFlowItemDAL 的摘要说明。
	/// </summary>
	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");
		}

		/// <summary>
		/// 取得一个工作流的所有工作流项和之间的关系
		/// </summary>
		/// <param name="WorkFlowID"></param>
		/// <returns></returns>
		//		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;
		//
		//		}

		/// <summary>
		/// 取得某工作流程中的所有流转部门及其关系
		/// </summary>
		/// <param name="FlowBaseID"></param>
		/// <returns></returns>
		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;
		}

	}
}