assetsdao.cs

资产数据库设计

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

namespace AdminGoods
{
	/// <summary>
	/// AssetsDAO 的摘要说明。
	/// </summary>
	public class AssetsDAO
	{
		public AssetsDAO()
		{
			//
			// 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 a.id,a.name,a.code ,w.realname,c.className  from assets as a ,worker as w ,assetsClass as c where  a.workerID = w.ID and a.classID = c.ID";

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


		
		public DataTable executeSQL(string sql)
		{

			System.Data.SqlClient.SqlConnection conn;		

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

			DataTable last = new DataTable();
			try
			{
				//sql = "select a.id,a.name,a.code ,w.realname,c.className  from assets as a ,worker as w ,assetsClass as c where  a.workerID = w.ID and a.classID = c.ID";

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