using System;
using System.Data ;
namespace OI.SendMessage
{
	/// <summary>
	/// printTransactPaper 的摘要說明。
	/// </summary>
	public class printTransactPaper
	{  
		protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect (); 
		public printTransactPaper()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}
		/// <summary>
		/// 得到簽發列表．
		/// </summary>
		/// <returns></returns>
		public string  GetSignatures(string documentid)  
		{
	         OI.cs .readStream rs=new OI.cs.readStream ();
		     rs.doucmentID =int.Parse (documentid);
			 string []nodeids= rs.GetNodeIdsByType("公文簽發");
			string s=null;
			foreach (string stepid in nodeids)
			{
				s+=printTransact(stepid,documentid,"公文簽發");
			}
			return s;


		}
		/// <summary>
		/// 打印處理人的姓名,意見,時間
		/// </summary>
		/// <returns></returns>
		private string printTransact(string stepid,string documentid,string transactType)
		{
			
			string sql="select top 1 UserID,TransactDate,Idea from DocumentTransact where StepID="+stepid +" and DocumentID="+documentid ;
		     sql +=" order by transactdate desc ";
			DataTable dt ;
			try
			{
				dt=Dbc.getBinding (sql,"t").Tables [0];
			}
			catch (Exception er)
			{
				throw new ApplicationException (er.Message );
			   
			}
			string s="<table  width=80% cellSpacing=0 cellpadding=0 border=0>";
			foreach (DataRow dr in dt.Rows )
			{
			  s+="<tr><td>";
              s+=dr["idea"].ToString ().Replace ("\r\n","<br/>") ;
			  s+="</td></tr><tr><td align=right>";
              s+=getPersonSign(dr["userid"].ToString ())+"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
              s+= System.DateTime .Parse(dr["TransactDate"].ToString ()).ToShortDateString ();
			  s+="</td></tr>";
			}
			s+="</table>";
			return s;

		}
		/// <summary>
		/// 顯示簽字人員的個人印章,如果沒有則返回用戶名.
		/// </summary>
		/// <param name="userid">用戶ID</param>
		/// <returns>string </returns>
		public string getPersonSign(string userid)
		{
			//string sql="select username,personSign from accounts_users where userid="+userid;
			string sql =" select a.username,ps.personalsign from accounts_users a, personalsign ps where  a.userid=ps.userid and a.userid="+userid;
			DataTable dt ;
			try
			{
				dt=Dbc.getBinding (sql,"t").Tables [0];
			}
			catch (Exception er)
			{
				throw new ApplicationException (er.Message );
			   
			}
			string s=null;
			foreach (DataRow dr in dt.Rows )
			{
				if (dr["personalsign"].ToString ()==null || dr["personalsign"].ToString ()=="")
				{
					s=dr["username"].ToString ();
				}
				else
				{
					s="<img border=0 src=../manage/displayimg.aspx?id="+userid +">";
				}
				
			}
			return s;

		}
		/// <summary>
		/// 得到校核列表
		/// </summary>
		/// <returns></returns>
		public string GetCollates(string documentid)  
		{
			if (documentid ==null || documentid =="")
			{
				return "";
			}
			OI.cs .readStream rs=new OI.cs.readStream ();
			rs.doucmentID =int.Parse (documentid);
			string []nodeids= rs.GetNodeIdsByType("公文校核");
			string s=null;
			foreach (string stepid in nodeids)
			{
				s+=printTransact(stepid,documentid,"公文校核");
			}
			return s;
		}
	
		public DataRow GetDataSource(string RegisterID)
		{
			DataTable dt=new DataTable ();

			string sql=" select dsr.*,e.exigencedegreename,s.SecretGreadname from documentsendr dsr ,ExigenceDegree e ,SecretGread s ";
			sql +=" where dsr.ExigenceDegreeid=e.ExigenceDegreeid  and   dsr.SecretGreadid=s.SecretGreadid and  dsr.RegisterID="+RegisterID;
	
			try
			{
				dt=Dbc.getBinding (sql,"t").Tables[0] ;
			}
			catch(Exception er)
			{
				throw new ApplicationException  (er.Message );
				
			}
			if (dt.Rows .Count >0)
			{
				return dt.Rows[0];
			}
			else
			{
				throw new ApplicationException ("沒有找到相關的文檔,可能數據己被刪除");
			
				
			}


		}
		/// <summary>
		///  得到單位
		/// </summary>
		/// <param name="RegisterID">發文登記ID</param>
		/// <param name="ReseverDepartment">單位類型:主送單位,抄送單位</param>
		/// <returns></returns>
		public string  Getdepartments(string RegisterID,string ReseverDepartment)
		{
			if (RegisterID==null || RegisterID =="")
			{
				return "";
			}
			if (ReseverDepartment ==null || ReseverDepartment =="")
			{
				return "";
			}
			string s="";
			string sql="select "+ ReseverDepartment +"  from receiveWait where    RegisterID="+RegisterID;
			DataTable dt=new DataTable ();
			
			try
			{
				dt=Dbc.getBinding (sql,"t").Tables[0] ;
			}
			catch(Exception er)
			{
				throw new ApplicationException  (er.Message );
				
			}
			foreach (DataRow dr in dt.Rows )
			{
				if (dr[ReseverDepartment] !=DBNull.Value )
				s +=dr[ReseverDepartment].ToString ()+"<br/>";
			}
			return s;
		}
		public string GetExigence (string RegisterID)
		{
			return "";
		}
	}
}