using System;
using System.Data ;
using System.Collections ;
using ExamCenter.ADLCTier;
using System.Windows .Forms ;


namespace ExamCenter.BLCTier
{
	/// <summary>
	/// BaseDataManageBLC 的摘要說明。
	/// </summary>
	public struct BaseDataUnit
	{
		public int intID;
		public string sectionID;
		public string strName;
		public int intParentID;
		public string strDescription;
	}
	public class BaseDataManBLC: BaseADLC
	{
		private string SQLSelectALLData="SELECT * FROM basedata";
		public BaseDataManBLC()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}		
		public DataSet GetAllBaseData()
		{//獲取用于建樹的所有基礎數據
			return BaseDataManBLC.ExecuteSqlReturnDs(SQLSelectALLData);
		}	
		public void UpdateDataSourceBLC(DataSet ds)
		{//更新數據源
			BaseDataManBLC.UpdateDataSource (ds,SQLSelectALLData);
		}
		public void MakeTree(DataTable dtBdu, TreeView trFuction)
		{//遞歸生成功能樹
			foreach(DataRow drNew in dtBdu.Rows )
			{				
				if (drNew["parentID"].ToString().Equals("0"))
				{
					TreeNode tnCurrent=new TreeNode (drNew["name"].ToString ());
					tnCurrent.Tag=drNew["ID"];
					trFuction.Nodes .Add (tnCurrent);					
					MakeTree(dtBdu,tnCurrent);
				}				
			}
		}
		public void MakeTree(DataTable dtBdu, TreeNode tnParent)
		{//遞歸生成功能樹
			foreach(DataRow drNew in dtBdu.Rows )
			{				
				if (drNew["parentID"].Equals(tnParent.Tag))
				{
					TreeNode tnCurrent=new TreeNode (drNew["name"].ToString ());
					tnCurrent.Tag=drNew["ID"];
					tnParent.Nodes .Add (tnCurrent);					
					MakeTree(dtBdu,tnCurrent);
				}				
			}
		}
		public void CreateTree(DataTable dt,TreeView tr,string strId,string strName,string strParentId,int rootid)
		{
			//參數：1.dt為數據表
			//      2.strId為數據表的Id字段
			//      3.strName為數據表的name字段
			//      4.strParentId為數據表的parentid字段
			//      5.tr為你要建的視圖樹
			foreach(DataRow drNew in dt.Rows )
			{
				//如果基礎數據表中一行的父id等于intId，就將其加入
				if (Convert.ToInt32(drNew[strParentId]) == rootid)
				{
					TreeNode tnCurrent=new TreeNode(drNew[strName].ToString());
					tnCurrent.Tag = drNew[strId].ToString();
					tr.Nodes.Add(tnCurrent);
					//遞歸建樹
					FunctionTree(dt,tnCurrent,strId,strName,strParentId);
				}
			}
		}
		public void FunctionTree(DataTable dt,TreeNode tn,string strId,string strName,string strParentId)
		{
			foreach(DataRow drNew in dt.Rows )
			{
				//如果基礎數據表中一行的父id等于intId，就將其加入
				if (Convert.ToInt32(drNew[strParentId]) == Convert.ToInt32(tn.Tag))
				{
					TreeNode tnCurrent=new TreeNode(drNew[strName].ToString());
					tnCurrent.Tag = drNew[strId].ToString();
					tn.Nodes.Add(tnCurrent);
					//遞歸建樹
					FunctionTree(dt,tnCurrent,strId,strName,strParentId);
				}
			}
		}

		public DataSet GetBaseDataByName(string strName)
		{
			//方法：public DataSet GetBaseDataByName(string strName)
			//參數：strName為basedata的name
			//功能：根據name選出basedata中的相應項
			//返回：數據集

			//SQL_SELECT_BASEDATA_BY_NAME為查詢語句
			string SQL_SELECT_BASEDATA_BY_NAME = "SELECT * FROM basedata WHERE name = '" + strName +"'";
			//執行查詢語句返回數據集
			return BaseDataManBLC.ExecuteSqlReturnDs(SQL_SELECT_BASEDATA_BY_NAME);
		}
		public DataSet GetBaseDataByParentName(string strName)
		{
			//SQL_SELECT_BASEDATA_BY_NAME為查詢語句
			string strSql= "SELECT * FROM basedata WHERE parentid=(SELECT id FROM basedata where name = '" + strName +"')";
			//執行查詢語句返回數據集
			return ExecuteSqlReturnDs(strSql);
		}

		public DataSet GetAll()
		{
			return ExecuteSqlReturnDs("SELECT * FROM basedata");
		}
	}
}