checksdao.cs

资产数据库设计

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

namespace AdminGoods
{
	/// <summary>
	/// ChecksDAO 的摘要说明。
	/// </summary>
	public class ChecksDAO
	{
		public ChecksDAO()
		{
			//
			// 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  c.*,a.name,w.realname   from  checks as c , assets as a ,worker as w  where  c.assetsID = a.id and c.workerID = w.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;
		}
	}
}