frmlp.cs

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

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using HouseBE;
using HouseBS;

namespace frmLogin
{
	/// <summary>
	/// frmLP 的摘要说明。
	/// </summary>
	public class frmLP : System.Windows.Forms.Form
	{
		private DevComponents.DotNetBar.TabControl tabControl1;
		private DevComponents.DotNetBar.TabItem tabItem1;
		private DevComponents.DotNetBar.TabControlPanel tabControlPanel1;
		private DevComponents.DotNetBar.TabItem tabItem2;
		private DevComponents.DotNetBar.TabControlPanel tabControlPanel2;
		private DevComponents.DotNetBar.TabItem tabItem3;
		private DevComponents.DotNetBar.TabControlPanel tabControlPanel3;
		private DevComponents.DotNetBar.LabelX labelX1;
		private DevComponents.DotNetBar.LabelX labelX2;
		private DevComponents.DotNetBar.LabelX labelX3;
		private DevComponents.DotNetBar.LabelX labelX4;
		private System.Windows.Forms.ListView listView1;
		private System.Windows.Forms.ColumnHeader columnHeader1;
		private System.Windows.Forms.ColumnHeader columnHeader2;
		private System.Windows.Forms.ColumnHeader columnHeader3;
		private System.Windows.Forms.ColumnHeader columnHeader4;
		private System.Windows.Forms.ColumnHeader columnHeader5;
		private DevComponents.DotNetBar.LabelX labelX5;
		private DevComponents.DotNetBar.LabelX labelX6;
		private System.Windows.Forms.DateTimePicker dateTimePicker1;
		private System.Windows.Forms.ColumnHeader columnHeader6;
		private System.Windows.Forms.ListView listView2;
		private System.Windows.Forms.ColumnHeader columnHeader7;
		private System.Windows.Forms.ColumnHeader columnHeader8;
		private System.Windows.Forms.ColumnHeader columnHeader10;
		private System.Windows.Forms.ColumnHeader columnHeader11;
		private System.Windows.Forms.ColumnHeader columnHeader12;
		private DevComponents.Editors.ComboItem comboItem1;
		private DevComponents.Editors.ComboItem comboItem2;
		private DevComponents.Editors.ComboItem comboItem3;
		private DevComponents.Editors.ComboItem comboItem4;
		private DevComponents.Editors.ComboItem comboItem5;
		private DevComponents.Editors.ComboItem comboItem6;
		private DevComponents.Editors.ComboItem comboItem7;
		private DevComponents.DotNetBar.LabelX labelX17;
		private DevComponents.DotNetBar.LabelX labelX18;
		private DevComponents.DotNetBar.LabelX labelX19;
		private DevComponents.DotNetBar.LabelX labelX20;
		private DevComponents.DotNetBar.LabelX labelX21;
		private DevComponents.DotNetBar.LabelX labelX22;
		private DevComponents.DotNetBar.ButtonX buttonX10;
		private DevComponents.DotNetBar.ButtonX buttonX12;
		private System.Windows.Forms.ListView listView3;
		private System.Windows.Forms.ColumnHeader columnHeader13;
		private System.Windows.Forms.ColumnHeader columnHeader14;
		private System.Windows.Forms.ColumnHeader columnHeader15;
		private System.Windows.Forms.ColumnHeader columnHeader16;
		private System.Windows.Forms.ColumnHeader columnHeader17;
		private System.Windows.Forms.ColumnHeader columnHeader18;
		private DevComponents.DotNetBar.LabelX labelX23;
		private DevComponents.DotNetBar.LabelX labelX24;
		private DevComponents.DotNetBar.LabelX labelX25;
		private DevComponents.DotNetBar.LabelX labelX26;
		private System.Windows.Forms.ColumnHeader columnHeader19;
		private System.Windows.Forms.ColumnHeader columnHeader20;
		private DevComponents.Editors.ComboItem comboItem8;
		private DevComponents.Editors.ComboItem comboItem9;
		private DevComponents.Editors.ComboItem comboItem10;
		private DevComponents.Editors.ComboItem comboItem11;
		private DevComponents.Editors.ComboItem comboItem12;
		private DevComponents.Editors.ComboItem comboItem13;
		private DevComponents.Editors.ComboItem comboItem14;
		private DevComponents.Editors.ComboItem comboItem15;
		private DevComponents.Editors.ComboItem comboItem16;
		private DevComponents.Editors.ComboItem comboItem17;
		private DevComponents.Editors.ComboItem comboItem18;
		private DevComponents.DotNetBar.LabelX labelX27;
		private System.Windows.Forms.ColumnHeader columnHeader21;
		private System.Windows.Forms.ColumnHeader columnHeader22;
		private System.Windows.Forms.ColumnHeader columnHeader23;
		private System.Windows.Forms.ColumnHeader columnHeader24;
		private System.Windows.Forms.ColumnHeader columnHeader25;
		private DevComponents.Editors.ComboItem comboItem19;
		private DevComponents.Editors.ComboItem comboItem20;
		private DevComponents.Editors.ComboItem comboItem21;
		private DevComponents.Editors.ComboItem comboItem22;
		private DevComponents.DotNetBar.Controls.TextBoxX txtremark;
		private DevComponents.DotNetBar.Controls.TextBoxX txttotal;
		private DevComponents.DotNetBar.Controls.TextBoxX txtnum;
		private DevComponents.DotNetBar.Controls.TextBoxX txtcount;
		private DevComponents.DotNetBar.Controls.TextBoxX txtname;
		private DevComponents.DotNetBar.ButtonX btnnext;
		private DevComponents.DotNetBar.ButtonX btnprint;
		private DevComponents.DotNetBar.ButtonX btnupdate;
		private DevComponents.DotNetBar.ButtonX btnadd;
		private System.ComponentModel.IContainer components;
		private HouseBE.LPMessage lpET;
		private HouseBS.LPMessageBS lpBS;
		private ArrayList list=null;
		private DevComponents.DotNetBar.LabelX labelX16;
		private DevComponents.DotNetBar.LabelX labelX15;
		private DevComponents.DotNetBar.LabelX labelX14;
		private DevComponents.DotNetBar.LabelX labelX13;
		private System.Windows.Forms.DateTimePicker dateTimePicker2;
		private DevComponents.DotNetBar.LabelX labelX7;
		private DevComponents.DotNetBar.LabelX labelX8;
		private DevComponents.DotNetBar.ButtonX buttonX5;
		private DevComponents.DotNetBar.ButtonX buttonX6;
		private DevComponents.DotNetBar.ButtonX btnupdates;
		private DevComponents.DotNetBar.ButtonX btnadds;
		private DevComponents.DotNetBar.LabelX labelX9;
		private DevComponents.DotNetBar.LabelX labelX11;
		private DevComponents.DotNetBar.LabelX labelX12;
		private System.Windows.Forms.ColumnHeader columnHeader26;
		private System.Windows.Forms.ColumnHeader columnHeader27;
		private HouseBE.House houET;
		private HouseBS.YesSellsBS yesBS;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboSpc;
		private DevComponents.DotNetBar.Controls.TextBoxX txtArea;
		private DevComponents.DotNetBar.Controls.TextBoxX txtAddress;
		private DevComponents.DotNetBar.Controls.TextBoxX txtAge;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboLP;
		private DevComponents.DotNetBar.Controls.TextBoxX txtRe;
		private DevComponents.DotNetBar.Controls.TextBoxX txtPrice;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHouseNO;
		private int lpID=0;
		private System.Windows.Forms.ColumnHeader columnHeader9;
		private System.Windows.Forms.ColumnHeader columnHeader28;
		private System.Windows.Forms.ColumnHeader columnHeader29;
		private System.Windows.Forms.ColumnHeader columnHeader30;
		private System.Windows.Forms.ColumnHeader columnHeader31;
		private System.Windows.Forms.ColumnHeader columnHeader32;
		private System.Windows.Forms.ColumnHeader columnHeader33;
		private System.Windows.Forms.ColumnHeader columnHeader34;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboLPName;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboformat;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHomeToPrice;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboChao;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboHouseNO;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboType;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHomePrice;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHomeArea;
		private DevComponents.DotNetBar.Controls.TextBoxX txtCell;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHomeRe;
		private DevComponents.DotNetBar.Controls.TextBoxX txtFloor;
		private int houseID=0;
		private HouseBE.Home homeBT;
		private DevComponents.Editors.ComboItem comboItem23;
		private DevComponents.Editors.ComboItem comboItem25;
		private DevComponents.Editors.ComboItem comboItem26;
		private DevComponents.Editors.ComboItem comboItem27;
		private DevComponents.Editors.ComboItem comboItem28;
		private DevComponents.DotNetBar.LabelX labelX10;
		private DevComponents.DotNetBar.LabelX labelX28;
		private DevComponents.Editors.ComboItem comboItem29;
		private DevComponents.Editors.ComboItem comboItem30;
		private DevComponents.Editors.ComboItem comboItem31;
		private DevComponents.DotNetBar.Controls.TextBoxX txtHomeNo;
		private DevComponents.DotNetBar.Controls.ComboBoxEx cboState;
		private System.Windows.Forms.ColumnHeader columnHeader35;
		private System.Windows.Forms.ColumnHeader columnHeader36;
		private HouseBS.HomeBS homeBS;

		public frmLP()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmLP));
			this.tabControl1 = new DevComponents.DotNetBar.TabControl();
			this.tabControlPanel1 = new DevComponents.DotNetBar.TabControlPanel();
			this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
			this.labelX6 = new DevComponents.DotNetBar.LabelX();
			this.txtremark = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX5 = new DevComponents.DotNetBar.LabelX();
			this.btnnext = new DevComponents.DotNetBar.ButtonX();
			this.btnprint = new DevComponents.DotNetBar.ButtonX();
			this.btnupdate = new DevComponents.DotNetBar.ButtonX();
			this.btnadd = new DevComponents.DotNetBar.ButtonX();
			this.listView1 = new System.Windows.Forms.ListView();
			this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader6 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader5 = new System.Windows.Forms.ColumnHeader();
			this.txttotal = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX4 = new DevComponents.DotNetBar.LabelX();
			this.txtnum = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX3 = new DevComponents.DotNetBar.LabelX();
			this.txtcount = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX2 = new DevComponents.DotNetBar.LabelX();
			this.txtname = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX1 = new DevComponents.DotNetBar.LabelX();
			this.tabItem1 = new DevComponents.DotNetBar.TabItem(this.components);
			this.tabControlPanel3 = new DevComponents.DotNetBar.TabControlPanel();
			this.cboState = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem29 = new DevComponents.Editors.ComboItem();
			this.comboItem30 = new DevComponents.Editors.ComboItem();
			this.comboItem31 = new DevComponents.Editors.ComboItem();
			this.labelX28 = new DevComponents.DotNetBar.LabelX();
			this.txtHomeNo = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX10 = new DevComponents.DotNetBar.LabelX();
			this.cboformat = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem19 = new DevComponents.Editors.ComboItem();
			this.comboItem20 = new DevComponents.Editors.ComboItem();
			this.comboItem21 = new DevComponents.Editors.ComboItem();
			this.comboItem22 = new DevComponents.Editors.ComboItem();
			this.txtHomeToPrice = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX27 = new DevComponents.DotNetBar.LabelX();
			this.cboChao = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem13 = new DevComponents.Editors.ComboItem();
			this.comboItem14 = new DevComponents.Editors.ComboItem();
			this.comboItem15 = new DevComponents.Editors.ComboItem();
			this.comboItem16 = new DevComponents.Editors.ComboItem();
			this.comboItem17 = new DevComponents.Editors.ComboItem();
			this.comboItem18 = new DevComponents.Editors.ComboItem();
			this.cboHouseNO = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem23 = new DevComponents.Editors.ComboItem();
			this.comboItem25 = new DevComponents.Editors.ComboItem();
			this.comboItem26 = new DevComponents.Editors.ComboItem();
			this.comboItem27 = new DevComponents.Editors.ComboItem();
			this.comboItem28 = new DevComponents.Editors.ComboItem();
			this.cboType = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem4 = new DevComponents.Editors.ComboItem();
			this.comboItem5 = new DevComponents.Editors.ComboItem();
			this.comboItem6 = new DevComponents.Editors.ComboItem();
			this.comboItem7 = new DevComponents.Editors.ComboItem();
			this.comboItem8 = new DevComponents.Editors.ComboItem();
			this.txtHomePrice = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX17 = new DevComponents.DotNetBar.LabelX();
			this.txtHomeArea = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX18 = new DevComponents.DotNetBar.LabelX();
			this.txtCell = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX19 = new DevComponents.DotNetBar.LabelX();
			this.labelX20 = new DevComponents.DotNetBar.LabelX();
			this.cboLPName = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem1 = new DevComponents.Editors.ComboItem();
			this.comboItem2 = new DevComponents.Editors.ComboItem();
			this.comboItem3 = new DevComponents.Editors.ComboItem();
			this.labelX21 = new DevComponents.DotNetBar.LabelX();
			this.txtHomeRe = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX22 = new DevComponents.DotNetBar.LabelX();
			this.buttonX10 = new DevComponents.DotNetBar.ButtonX();
			this.buttonX12 = new DevComponents.DotNetBar.ButtonX();
			this.listView3 = new System.Windows.Forms.ListView();
			this.columnHeader13 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader24 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader25 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader9 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader28 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader29 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader30 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader31 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader32 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader33 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader34 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader35 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader36 = new System.Windows.Forms.ColumnHeader();
			this.labelX23 = new DevComponents.DotNetBar.LabelX();
			this.txtFloor = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX24 = new DevComponents.DotNetBar.LabelX();
			this.labelX25 = new DevComponents.DotNetBar.LabelX();
			this.labelX26 = new DevComponents.DotNetBar.LabelX();
			this.tabItem3 = new DevComponents.DotNetBar.TabItem(this.components);
			this.tabControlPanel2 = new DevComponents.DotNetBar.TabControlPanel();
			this.cboSpc = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.comboItem9 = new DevComponents.Editors.ComboItem();
			this.comboItem10 = new DevComponents.Editors.ComboItem();
			this.comboItem11 = new DevComponents.Editors.ComboItem();
			this.comboItem12 = new DevComponents.Editors.ComboItem();
			this.txtArea = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX16 = new DevComponents.DotNetBar.LabelX();
			this.txtAddress = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX15 = new DevComponents.DotNetBar.LabelX();
			this.txtAge = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX14 = new DevComponents.DotNetBar.LabelX();
			this.labelX13 = new DevComponents.DotNetBar.LabelX();
			this.cboLP = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
			this.labelX7 = new DevComponents.DotNetBar.LabelX();
			this.txtRe = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX8 = new DevComponents.DotNetBar.LabelX();
			this.buttonX5 = new DevComponents.DotNetBar.ButtonX();
			this.buttonX6 = new DevComponents.DotNetBar.ButtonX();
			this.btnupdates = new DevComponents.DotNetBar.ButtonX();
			this.btnadds = new DevComponents.DotNetBar.ButtonX();
			this.txtPrice = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX9 = new DevComponents.DotNetBar.LabelX();
			this.txtHouseNO = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX11 = new DevComponents.DotNetBar.LabelX();
			this.labelX12 = new DevComponents.DotNetBar.LabelX();
			this.listView2 = new System.Windows.Forms.ListView();
			this.columnHeader7 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader8 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader10 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader11 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader26 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader12 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader19 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader27 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader20 = new System.Windows.Forms.ColumnHeader();
			this.tabItem2 = new DevComponents.DotNetBar.TabItem(this.components);
			this.columnHeader14 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader15 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader16 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader17 = new System.Windows.Forms.ColumnHeader();
			this.columnHeader18 = new System.Windows.Forms.ColumnHeader();