docflow.cs

ASP C#代码实例 适合初学人士学习使用

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

namespace OfficeAuto.Components
{
	/// <summary>
	/// 存储公文流转的结构
	/// </summary>
	public class DocFlowDetails
	{
		public int    nFlowID;
		public string FlowName;
		public string FlowDesn;
		public int    SenderID;
		public int    FlowMethodID;
		public ArrayList ReceiverList = new ArrayList();
		public ArrayList DocumentList = new ArrayList();

		public static string DocFlowDetail = "DOCFLOWDETAIL";
		public static string DocFlowDetailEdit = "DOCFLOWDETAILEDIT";
	}

	/// <summary>
	/// DocFlow 的摘要说明。
	/// </summary>
	public class DocFlow
	{
		public int AddDocFlow(string sFlowName,string sFlowDesn,int nSenderID,int nFlowMethodID)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@FlowName",SqlDbType.VarChar,100,sFlowName),
									   db.CreateInParam("@FlowDesn",SqlDbType.VarChar,8000,sFlowDesn),
									   db.CreateInParam("@SenderID",SqlDbType.Int,4,nSenderID),
									   db.CreateInParam("@FlowMethodID",SqlDbType.Int,4,nFlowMethodID)
								   };
			///执行存储过程
			return(db.RunProc("Pr_AddDocFlow",param));
		}

		public void UpdateDocFlow(int nDocFlowID,string sFlowName,string sFlowDesn,int nFlowMethodID)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID),
									   db.CreateInParam("@FlowName",SqlDbType.VarChar,100,sFlowName),
									   db.CreateInParam("@FlowDesn",SqlDbType.VarChar,8000,sFlowDesn),
									   db.CreateInParam("@FlowMethodID",SqlDbType.Int,4,nFlowMethodID)
								   };
			///执行存储过程
			db.RunProc("Pr_UpdateDocFlow",param);
		}

		public SqlDataReader GetDocFlows()
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///执行存储过程
			db.RunProc("Pr_GetDocFlows",out dr);

			///返回获取的数据
			return(dr);
		}

		public SqlDataReader GetSingleDocFlow(int nDocFlowID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)									   
								   };
			///执行存储过程
			db.RunProc("Pr_GetSingleDocFlow",param,out dr);

			///返回获取的数据
			return(dr);
		}

		public SqlDataReader GetDocFlowByUser(int nUserID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@UserID",SqlDbType.Int,4,nUserID)									   
								   };
			///执行存储过程
			db.RunProc("Pr_GetDocFlowByUser",param,out dr);

			///返回获取的数据
			return(dr);
		}

		public void DeleteDocFlow(int nDocFlowID)
		{
			Database db = new Database();			
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)									   
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteDocFlow",param);
		}

	}

	/// <summary>
	/// 公文流转方式设计
	/// </summary>
	public class FlowMethod
	{
		public int AddFlowMethod(string sMethodName,string sMethodDesn)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@MethodName",SqlDbType.VarChar,200,sMethodName),
									   db.CreateInParam("@MethodDesn",SqlDbType.VarChar,200,sMethodDesn)
								   };
			///执行存储过程
			return(db.RunProc("Pr_AddFlowMethod",param));
		}

		public void UpdateFlowMethod(int nFlowMethodID,string sMethodName,string sMethodDesn)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@FlowMethodID",SqlDbType.Int,4,nFlowMethodID),
									   db.CreateInParam("@MethodName",SqlDbType.VarChar,50,sMethodName),
									   db.CreateInParam("@MethodDesn",SqlDbType.VarChar,8000,sMethodDesn)
								   };
			///执行存储过程
			db.RunProc("Pr_UpdateFlowMethod",param);
		}

		public SqlDataReader GetFlowMethods()
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///执行存储过程
			db.RunProc("Pr_GetFlowMethods",out dr);

			///返回获取的数据
			return(dr);
		}

		public SqlDataReader GetSingleFlowMethod(int nFlowMethodID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@FlowMethodID",SqlDbType.Int,4,nFlowMethodID)									   
								   };
			///执行存储过程
			db.RunProc("Pr_GetSingleFlowMethod",param,out dr);

			///返回获取的数据
			return(dr);
		}

		public void DeleteFlowMethod(int nFlowMethodID)
		{
			Database db = new Database();		
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@FlowMethodID",SqlDbType.Int,4,nFlowMethodID)									   
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteFlowMethod",param);
		}
	}

	/// <summary>
	/// 公文流转中文档类设计
	/// </summary>
	public class FlowDocument
	{
		public void AddFlowDocument(int nDocFlowID,int nDocumentID)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID),
									   db.CreateInParam("@DocumentID",SqlDbType.Int,4,nDocumentID)
								   };
			///执行存储过程
			db.RunProc("Pr_AddFlowDocument",param);
		}

		public SqlDataReader GetDocumentByFlow(int nDocFlowID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)
								   };
			///执行存储过程
			db.RunProc("Pr_GetDocumentByFlow",param,out dr);

			///返回获取的数据
			return(dr);
		}

		public void DeleteDocumentByFlow(int nDocFlowID)
		{
			Database db = new Database();		
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteDocumentByFlow",param);
		}

		public void DeleteFlowDocument(int nDocFlowID,int nDocumentID)
		{
			Database db = new Database();		
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID),
									   db.CreateInParam("@DocumentID",SqlDbType.Int,4,nDocumentID)
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteFlowDocument",param);
		}
	}

	/// <summary>
	/// 公文流转中接收人的类设计
	/// </summary>
	public class FlowReceiver
	{
		public void AddFlowReceiver(int nDocFlowID,int nReceiverID)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID),
									   db.CreateInParam("@ReceiverID",SqlDbType.Int,4,nReceiverID)
								   };
			///执行存储过程
			db.RunProc("Pr_AddFlowReceiver",param);
		}

		public SqlDataReader GetReceiverByFlow(int nDocFlowID)
		{
			Database db = new Database();
			SqlDataReader dr = null;
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)
								   };
			///执行存储过程
			db.RunProc("Pr_GetReceiverByFlow",param,out dr);

			///返回获取的数据
			return(dr);
		}

		public void DeleteReceiverByFlow(int nDocFlowID)
		{
			Database db = new Database();		
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID)
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteReceiverByFlow",param);
		}

		public void DeleteFlowReceiver(int nDocFlowID,int nReceiverID)
		{
			Database db = new Database();
			///添加存储过程参数
			SqlParameter[] param = {
									   db.CreateInParam("@DocFlowID",SqlDbType.Int,4,nDocFlowID),
									   db.CreateInParam("@ReceiverID",SqlDbType.Int,4,nReceiverID)
								   };
			///执行存储过程
			db.RunProc("Pr_DeleteFlowReceiver",param);
		}
	}
}