using System;
using System.Data;

namespace PMS.Components
{
	/// <summary>
	/// Transfer 的摘要說明。
	/// </summary>
	public class Transfer
	{
		public DataTable GetTransfer()
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Transfer] order by TransferID DESC") ;
				return(DT) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		public DataTable GetTransfer(int TransferID)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				DataTable DT = DataAs.CreateDataTable("select * from [Transfer] where TransferID="+TransferID+" order by TransferID DESC") ;
				return(DT) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}
		public bool AddTransfer(string strSql)
		{
			try
			{
				PMS.Common.DataAccess DataAs = new PMS.Common.DataAccess() ;
				bool bResult = DataAs.ExecSql(strSql) ;
				return(bResult) ;
			}
			catch(Exception ex)
			{
				PMS.Common.SystemError.SystemLog(ex.Message) ;
				throw new Exception(ex.Message,ex) ;
			}
		}

	}
}