basedatamanageblc.cs

一个好的系统 对初学者很有用啊 来看看啊

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");
		}
	}
}