companymessageda.cs

实现房产销售的房屋管理 客户管理 并且在客户管理中实现了对预定客户和已购房客户的查询和修改

using System;
using System.Data;
using System.Data.SqlClient;
using HouseBE;
namespace HouseDA
{
	/// <summary>
	/// CompanyMessageDA 的摘要说明。
	/// </summary
	public class CompanyMessageDA
	{
		private SqlConnection _con;
		private ConDA _cons;
		private SqlCommand _cmd;
		private SqlDataAdapter _adapter;
		private DataSet _ds;
		private HouseBE.CompanyMessage _companyMessage;

		public HouseBE.CompanyMessage companyMessage
		{
			set
			{
			 this._companyMessage=value;
			}
			get
			{
			  return this._companyMessage;
			}
		}
		public CompanyMessageDA()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			this._cons=new ConDA();
			this._con=this._cons._con;
		}

		public DataSet select()
		{
			// TODO:  添加 CompanyMessageDA.select 实现
			try
			{
				this._adapter=new SqlDataAdapter("select * from CompanyMessage",this._con);
				this._ds=new DataSet();
				this._adapter.Fill(this._ds,"CompanyMessage");
			}
			catch(Exception ex)
			{
			  Console.WriteLine(ex.Message);
		      throw ex;
			}
			return this._ds;
		}

		public void insert()
		{
			// TODO:  添加 CompanyMessageDA.insert 实现
			this._cmd=this._con.CreateCommand();
			this._cmd.CommandText="insert into CompanyMessage values(@CompanyName,@CompanyAddress,@CompanyEmail,@CompanyTelphone,@CompanyNet,@Corporation,@Fax,@Employees,@Remark)";
			this._cmd.Parameters.Add("@CompanyName",this._companyMessage.CompanyName);
			this._cmd.Parameters.Add("@CompanyAddress",this._companyMessage.CompanyAddress);
			this._cmd.Parameters.Add("@CompanyEmail",this._companyMessage.CompanyEmail);
			this._cmd.Parameters.Add("@CompanyTelphone",this._companyMessage.CompanyTelphone);
			this._cmd.Parameters.Add("@CompanyNet",this._companyMessage.CompanyNet);
			this._cmd.Parameters.Add("@Corporation",this._companyMessage.Corporation);
			this._cmd.Parameters.Add("@Fax",this._companyMessage.Fax);
			this._cmd.Parameters.Add("@Employees",this._companyMessage.Employees);
			this._cmd.Parameters.Add("@Remark",this._companyMessage.Remark);

			try
			{
				this._con.Open();
				this._cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				throw ex;
			}
			finally
			{
			  this._con.Close();
			}
		}

		public void update()
		{
			// TODO:  添加 CompanyMessageDA.insert 实现
			this._cmd=this._con.CreateCommand();
			this._cmd.CommandText="update CompanyMessage set CompanyAddress=@CompanyAddress,CompanyEmail=@CompanyEmail,CompanyTelphone=@CompanyTelphone,CompanyNet=@CompanyNet,Corporation=@Corporation,Fax=@Fax,Employees=@Employees,Remark=@Remark  where CompanyName=@CompanyName";
			
			this._cmd.Parameters.Add("@CompanyAddress",this._companyMessage.CompanyAddress);
			this._cmd.Parameters.Add("@CompanyEmail",this._companyMessage.CompanyEmail);
			this._cmd.Parameters.Add("@CompanyTelphone",this._companyMessage.CompanyTelphone);
			this._cmd.Parameters.Add("@CompanyNet",this._companyMessage.CompanyNet);
			this._cmd.Parameters.Add("@Corporation",this._companyMessage.Corporation);
			this._cmd.Parameters.Add("@Fax",this._companyMessage.Fax);
			this._cmd.Parameters.Add("@Employees",this._companyMessage.Employees);
			this._cmd.Parameters.Add("@Remark",this._companyMessage.Remark);
            this._cmd.Parameters.Add("@CompanyName",this._companyMessage.CompanyName);
			try
			{
				this._con.Open();
				this._cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				throw ex;
			}
			finally
			{
				this._con.Close();
			}
		}
	}
}