using System;
using System.Data ;
using System.Data.SqlClient ;


namespace qminoa.DA
{
	/// <summary>
	/// bind 的摘要說明。
	/// </summary>
	
	public class controlbinding 
	{ 
		private DataSet objdataset;

		private	SqlDataAdapter objadapter=new SqlDataAdapter();
		private SqlCommand objcommand=new SqlCommand();

		private	String conn=System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
		
		public controlbinding()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//

		}

		public DataSet dropPlacebind()
		{
			return controlbind("cpDropPlaceBind");
		}

		public DataSet dropTypebind()
		{
			return controlbind("cpDropTypeBind");
		}

		//綁定所有機構
		public DataSet dropBranchbind()
		{
			return controlbind("cpDropBranchBind");
		}
		//綁定指定機構下屬所有部門
		public DataSet dropDepbind(string strtxt)
		{
			return controlbind("cpDropDepBind","@txtdropBranch",strtxt);
		}
		//綁定制定部門下屬所有人員
		public DataSet droplstEmpbind(string strtxt)
		{
			return controlbind("cpLstEmpBind","@txtdropDep",strtxt);
		}

		public DataSet controlbind(string strsql)
		{
			objdataset=new DataSet ();
			objadapter=new SqlDataAdapter(strsql,conn);
			objadapter.Fill(objdataset, "tablename");
	
			return objdataset;
		}

		public DataSet controlbind(string strsql ,string paramName,int paramValue)
		{

			objadapter.SelectCommand = new SqlCommand();
			objadapter.SelectCommand.Connection  = new SqlConnection(conn);
			objdataset=new DataSet ();
			objcommand = objadapter.SelectCommand;
			objcommand.CommandText = strsql;
			objcommand.CommandType = CommandType.StoredProcedure; 
			SqlParameter param = new SqlParameter(paramName, SqlDbType.Int);
			param.Value = paramValue ;
			objcommand.Parameters.Add(param);
			objadapter.Fill(objdataset);

			
			return objdataset;
		}

		public DataSet controlbind(string strsql ,string paramName,string paramValue)
		{
			objadapter.SelectCommand = new SqlCommand();
			objadapter.SelectCommand.Connection  = new SqlConnection(conn);
			objdataset=new DataSet ();
			objcommand = objadapter.SelectCommand;
			objcommand.CommandText = strsql;
			objcommand.CommandType = CommandType.StoredProcedure; 
			SqlParameter param = new SqlParameter(paramName, SqlDbType.NVarChar, 255);
			param.Value = paramValue ;
			objcommand.Parameters.Add(param);
			objadapter.Fill(objdataset);

			return objdataset;
		}
	}
}