streamtime.cs

很不错的公文流转系统

using System;
using System.Data .SqlClient ;
using System.Data;
namespace OI.cs
{
	/// <summary>
	/// streamtime 的摘要说明。
	/// 返回到达公文的时间.
	/// </summary>
	public class streamtime
	{
		private OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect (); 
      //  private System.Data .DataSet  ds;
		
		public streamtime()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//

		}
		/// <summary>
		/// 返回到达公文的时间
		/// </summary>
		/// <param name="documentid"></param>
		/// <returns></returns>
		public string GetPrivTransactTime(int documentid)
		{ 
			

            readStream rs=new readStream ();
			rs.doucmentID =documentid;
			int currentnodeid=GetcurrentNodeID(documentid);
			int privNodeID=rs.GetPrivateNodeID (currentnodeid.ToString ());
			return GetArrivalDataTime(documentid,privNodeID);
		}
		private string GetArrivalDataTime(int documentid,int stepid)
		{
			string sql=" select transactdate from documenttransact where documentid="+documentid.ToString () +" and  stepid=" +stepid.ToString ();
			object o=Dbc.GetObjectBySql (sql);
			if (o==null)
			{
				return null;
			}
			return (o.ToString ());
		}
		private int GetcurrentNodeID(int documentid)
		{
			string sql="select CurrentStepID from document where documentid= "+documentid.ToString ();
			object o=Dbc.GetObjectBySql (sql);
			if (o==null)
			{
				throw new ApplicationException ("没有找到此公文对应流程的当前节点");
			}
			return int.Parse (o.ToString ());
		}
	}
}