dictonaryaccess.cs

实施医院管理系统

using System;
using comman;
using System.Data;

namespace DataAccess
{
	/// <summary>
	/// DictonaryAccess 的摘要说明。
	/// </summary>
	public class DictonaryAccess
	{
		DBconnection cn = new DBconnection();
		public DictonaryAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public Dictionary[] GetDetailByCate(string Category)
		{
			string commandText = string.Format("SELECT * FROM Dictionary WHERE Category = '{0}' AND Enable = 1",Category);
			DataTable table = DBAccess.ExcuteDataTable(cn.Connection,commandText);
			int count = table.Rows.Count;
			Dictionary[] dic = new Dictionary[count];

			for(int i=0;i< count;i++)
			{
				dic[i].ID = (int)table.Rows[i]["ID"];
				dic[i].Detail = table.Rows[i]["Detail"].ToString();
				dic[i].Category = table.Rows[i]["Category"].ToString();
//				dic[i].Enable = Convert.ToInt32(table.Rows[i]["Enable"]);
			}
			return dic;
		}
	}
}