using System;

namespace X2Design.Data
{
	/// <summary>
	/// 本對象用與提供對SqlServer數據庫的常用訪問操作。
	/// </summary>
	public class SqlDbOperHandler:DbOperHandler
	{
		/// <summary>
		/// 構造函數，接收一個SqlServer數據庫連接對象SqlConnection
		/// </summary>
		public SqlDbOperHandler(System.Data.SqlClient.SqlConnection _conn)
		{
			
			conn=_conn;
			dbType=DatabaseType.SqlServer;
			
			conn.Open();
			cmd=conn.CreateCommand();
			da=new System.Data.SqlClient.SqlDataAdapter();
			
		}
		/// <summary>
		/// 產生SqlCommand對象所需的查詢參數。
		/// </summary>
		protected override void GenParameters()
		{
			System.Data.SqlClient.SqlCommand sqlCmd=(System.Data.SqlClient.SqlCommand)cmd;
			if(this.alFieldItems.Count>0)
			{
				for(int i=0;i<alFieldItems.Count;i++)
				{
					//if(((DbKeyItem)alFieldItems[i]).fieldValue.ToString().Length>
					sqlCmd.Parameters.Add("@para"+i.ToString(),((DbKeyItem)alFieldItems[i]).fieldValue.ToString());
				}
			}
			
			if(this.alSqlCmdParameters.Count>0)
			{
				for(int i=0;i<this.alSqlCmdParameters.Count;i++)
				{
					//sqlCmd.Parameters.Add("@spara"+i.ToString(),((DbKeyItem)alSqlCmdParameters[i]).fieldValue.ToString());
					sqlCmd.Parameters.Add(((DbKeyItem)alSqlCmdParameters[i]).fieldName.ToString(),((DbKeyItem)alSqlCmdParameters[i]).fieldValue.ToString());
				}
			}
			if(this.alConditionParameters.Count>0)
			{
				for(int i=0;i<this.alConditionParameters.Count;i++)
				{
					//sqlCmd.Parameters.Add("@cpara"+i.ToString(),((DbKeyItem)alConditionParameters[i]).fieldValue.ToString());
					sqlCmd.Parameters.Add(((DbKeyItem)alConditionParameters[i]).fieldName.ToString(),((DbKeyItem)alConditionParameters[i]).fieldValue.ToString());
				}
			}
		}
		
	}
}