assetsclassdao.cs

来自「资产数据库设计」· CS 代码 · 共 55 行

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

namespace AdminGoods
{
	/// <summary>
	/// AssetsClassDAO 的摘要说明。
	/// </summary>
	public class AssetsClassDAO
	{
		public AssetsClassDAO()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public DataTable listAllAssets()
		{

			System.Data.SqlClient.SqlConnection conn;		

			SqlDataAdapter dp;
			string sql;
			DataSet ds = new DataSet();
			Database db = new Database();

			DataTable last = new DataTable();
			try
			{
				sql = "select id,className,about from assetsClass";

				conn = db.openConn();
				
				dp = new System.Data.SqlClient.SqlDataAdapter(sql,conn);	 
 
				dp.Fill(ds,"worker");

				last = ds.Tables["worker"];

			}
			catch
			{
				last = null;
			}
			finally
			{
				db.closeConn();
			}
			return last;
		}
	}
}