using?System;
using?System.Data;
using?System.Text;
using?System.Data.OleDb;
using?zoruan.DBUtility;//請(qǐng)先添加引用
namespace?zoruan.DAL
{
	///?

	///?數(shù)據(jù)訪問(wèn)類(lèi)Building。
	///?

	public?class?BuildingDAL
	{
????????public?BuildingDAL（）
		{}
		#region??成員方法

		///?

		///?是否存在該記錄
		///?

		public?bool?Exists（int?Building_ID）
		{
			StringBuilder?strSql=new?StringBuilder（）;
			strSql.Append（“select?count（1）?from?Building“）;
			strSql.Append（“?where?Building_ID=@Building_ID?“）;
			OleDbParameter[]?parameters?=?{
					new?OleDbParameter（“@Building_ID“?OleDbType.Integer4）};
			parameters[0].Value?=?Building_ID;

			return?DbHelperOleDb.Exists（strSql.ToString（）parameters）;
		}


		///?

		///?增加一條數(shù)據(jù)
		///?

		public?int?Add（zoruan.Model.Building?model）
		{
			StringBuilder?strSql=new?StringBuilder（）;
			strSql.Append（“insert?into?Building（“）;
			strSql.Append（“Building_Name）“）;
			strSql.Append（“?values?（“）;
			strSql.Append（“@Building_Name）“）;
			OleDbParameter[]?parameters?=?{
					new?OleDbParameter（“@Building_Name“?OleDbType.VarChar50）};	
			parameters[0].Value?=?model.Building_Name;

			return?DbHelperOleDb.ExecuteSql（strSql.ToString（）parameters）;
		}
		///?

		///?更新一條數(shù)據(jù)
		///?

		public?int?Update（zoruan.Model.Building?model）
		{
			StringBuilder?strSql=new?StringBuilder（）;
			strSql.Append（“update?Building?set?“）;
			strSql.Append（“Building_Name=@Building_Name“）;
			strSql.Append（“?where?Building_ID=@Building_ID?“）;
			OleDbParameter[]?parameters?=?{					
					new?OleDbParameter（“@Building_Name“?OleDbType.VarChar50）
????????????????????new?OleDbParameter（“@Building_ID“?OleDbType.Integer4）};
????????????parameters[0].Value?=?model.Building_Name;
			parameters[1].Value?=?model.Building_ID;
			

		????return	DbHelperOleDb.ExecuteSql（strSql.ToString（）parameters）;
		}

		///?

		///?刪除一條數(shù)據(jù)
		///?

		public?int?Delete（int?Building_ID）
		{
			
			StringBuilder?strSql=new?StringBuilder（）;
			strSql.Append（“delete?from?Building?“）;
			strSql.Append（“?where?Building_ID=@Building_ID?“）;
			OleDbParameter[]?parameters?=?{
					new?OleDbParameter（“@Building_ID“?OleDbType.Integer4）};
			parameters[0].Value?=?Building_ID;

		????return	DbHelperOleDb.ExecuteSql（strSql.ToString（）parameters）;
		}


		///?

		///?得到一個(gè)對(duì)象實(shí)體
		///?

		public?zoruan.Model.Building?GetModel（int?Building_ID）
		{
			
			StringBuilder?strSql=new?StringBuilder（）;
			strSql.Append（“select?Building_IDBuilding_Name?from?Building?“）;
			strSql.Append（“?where?Building_ID=@Building_ID?“）;
			OleDbParameter[]?parameters?=?{
					new?OleDbParameter（“@Building_ID“?OleDbType.Integer4）};
			parameters[0].Value?=?Building_ID;

			zoruan.Model.Building?model=new?zoruan.Model.Building（）;
			DataSet?ds=DbHelperOleDb.Query（strSql.ToString（）parameters）;
			if（ds.Tables[0].Rows.Count>0）
			{
				if（d

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

????.......?????65536??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\DAL.dll

????.......?????79360??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\DAL.pdb

????.......???3543552??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\DevComponents.DotNetBar2.dll

????.......????102400??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\IBatisNet.Common.dll

????.......????249856??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\IBatisNet.DataMapper.dll

????.......?????86016??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Maticsoft.DBUtility.dll

????.......????187904??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Maticsoft.DBUtility.pdb

????.......???1100392??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Microsoft.Office.Interop.Excel.dll

????.......?????64088??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Microsoft.Vbe.Interop.dll

????.......?????16896??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Model.dll

????.......?????77312??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\Model.pdb

????.......????274432??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\MySql.Data.dll

????.......????223800??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Debug\office.dll

????.......?????50688??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\DAL.pdb

????.......????102400??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\IBatisNet.Common.dll

????.......????249856??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\IBatisNet.DataMapper.dll

????.......?????57344??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\Maticsoft.DBUtility.dll

????.......??????9728??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\Model.dll

????.......?????46592??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\Model.pdb

????.......????274432??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\Release\MySql.Data.dll

?????文件????3621836??2015-04-27?11:29??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\國(guó)內(nèi)最大的免費(fèi)商業(yè)源碼下載平臺(tái).mht

?????文件??????14108??2015-07-21?10:13??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\bin\百納科技源碼.png

????.......??????4681??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\BuildingDAL.cs

????.......?????42027??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\CostListDAL.cs

????.......??????2933??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\DAL.csproj

????.......??????5497??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\FloorDAL.cs

????.......?????13651??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\HouseholdListDAL.cs

????.......??????3450??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

????.......?????47897??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache

????.......?????65536??2014-09-15?13:45??小區(qū)物業(yè)管理系統(tǒng)源碼\DAL\obj\Debug\DAL.dll

............此處省略407個(gè)文件信息