using?System;
using?System.Collections;
using?System.Data;
using?System.Data.Common;
using?System.Collections.Generic;

using?WHC.Pager.Entity;
using?Microsoft.Practices.EnterpriseLibrary.Data;
using?WHC.TestProject.Entity;
using?WHC.TestProject.IDAL;

namespace?WHC.TestProject.DAL
{
	///?

	///?#if（${TableInfo.Description}?）${TableInfo.Description}#else${ClassName}#end
	///?

	public?class?${ClassName}?:?baseDAL<${ClassName}Info>?I${ClassName}
	{
		#region?對象實例及構造函數

		public?static?${ClassName}?Instance
		{
			get
			{
				return?new?${ClassName}（）;
			}
		}
		public?${ClassName}（）?:?base（“${TableName}““${TableInfo.PrimayKey.Name}“）
		{
		}

		#endregion

		///?

		///?將DataReader的屬性值轉化為實體類的屬性值，返回實體類
		///?

		///?有效的DataReader對象
		///?實體類對象
		protected?override?${ClassName}Info?DataReaderToEntity（IDataReader?dataReader）
		{
			${ClassName}Info?info?=?new?${ClassName}Info（）;
			SmartDataReader?reader?=?new?SmartDataReader（dataReader）;
			
#foreach（$ColumnInfo?in?${TableInfo.ColumnList.Values}）
			info.${ColumnInfo.Name.Alias.ToCapit（）}?=?reader.Get${ColumnInfo.NetType.Name.Replace（“System.“““）.Replace（“[]““s“）}（“${ColumnInfo.Name.Name.ToString（）}“）;
#end
			
			return?${ClassLowerName}Info;
		}

		///?

		///?將實體對象的屬性值轉化為Hashtable對應的鍵值
		///?

		///?有效的實體對象
		///?包含鍵值映射的Hashtable
????????protected?override?Hashtable?GetHashByEntity（${ClassName}Info?obj）
		{
		????${ClassName}Info?info?=?obj?as?${ClassName}Info;
			Hashtable?hash?=?new?Hashtable（）;?
			
#foreach（$ColumnInfo?in?${TableInfo.ColumnList.Values}）		
#if（${ColumnInfo.AutoIncrement}?==?false）	
			hash.Add（“${ColumnInfo.Name.Name.ToString（）}“?info.${ColumnInfo.Name.Alias.ToCapit（）}）;
#end?##endif
#end
				
			return?hash;
		}

????}
}