viewtransacttype.cs

很不错的公文流转系统

using System;
using System.Data ;
namespace OI.cs
{
	/// <summary>
	/// viewTransactType 的摘要说明。
	/// </summary>
	
	public class viewTransactType :System.Web .UI .Page 
	{
	
		
		protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		
		protected OI.cs.readStream  rs=new readStream ();
		
		public viewTransactType()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			
			//
		}
		public string transactType(string nodeName,string documentID,string userid)
		{
			rs.doucmentID =int.Parse (documentID);
			string []ids=rs.GetNodeIdsByType (nodeName);
			string  id="( ";
			
			for (int i=0;i<ids.Length -2;i++)
			{
				id +=ids[i] +",";
			}
		
			id +=ids[ids.Length-1]+ " )";
		    string sql= " select transtype from documenttransact "; 
                   sql += "where  userid="+userid;
                   sql += " and documentid="+ documentID; 
                   sql += " and stepid in "+id;
			DataSet ds=new DataSet 	();
			try
			{
				ds=Dbc.getBinding (sql,"t");
				
			}
			catch(Exception er )
			{
			    throw new Exception ( er.Message );
				//return "";
			}
			if (ds.Tables[0].Rows .Count >0)
			{
				return ds.Tables [0].Rows[0]["transtype"].ToString ();
			}
			else
			{
				return "";
			}
			

		}
		
        

	}
}