frmdestine.cs

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

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using HouseBE;
using HouseBS;
using System.Drawing.Printing;

namespace frmLogin
{
	/// <summary>
	/// frmDestine 的摘要说明。
	/// </summary>
	public class frmDestine : System.Windows.Forms.Form
	{
		private System.Windows.Forms.ImageList imageList1;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ToolBarButton toolBarButton2;
		private System.Windows.Forms.ToolBarButton toolBarButton4;
		private System.Windows.Forms.ToolBarButton toolBarButton5;
		private System.ComponentModel.IContainer components;
		private System.Drawing.Printing.PrintDocument printDocument1;
		private System.Windows.Forms.PageSetupDialog pageSetupDialog1;
		private System.Windows.Forms.PrintPreviewDialog printPreviewDialog1;
		
        private DataSet ds;
		private DevComponents.DotNetBar.PanelEx panelEx1;
		private DevComponents.DotNetBar.PanelEx panelEx2;
		private System.Windows.Forms.DataGrid dataGrid1;
		private DevComponents.DotNetBar.LabelX labelX1;
		private DevComponents.DotNetBar.LabelX labelX2;
		private DevComponents.DotNetBar.Controls.TextBoxX textBoxX1;
		private DevComponents.DotNetBar.Controls.ComboBoxEx comboBoxEx1;
		private DevComponents.DotNetBar.LabelX labelX4;
		private DevComponents.DotNetBar.ButtonX buttonX1;
		private DevComponents.DotNetBar.Controls.ComboBoxEx comboBoxEx2;
		private DevComponents.DotNetBar.LabelX labelX5;
		private DevComponents.DotNetBar.Controls.TextBoxX textBoxX3;
		
		private HouseBS.DestineBS _destineBS;
		private DevComponents.DotNetBar.ButtonX buttonX2;
		public frmDestine()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
            this._destineBS=new DestineBS();
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}
		public frmDestine(string House)
		{
			InitializeComponent();
			this._destineBS=new DestineBS();
			this.textBoxX1.Text=House;
		}
		/// <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(frmDestine));
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.toolBarButton2 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton4 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton5 = new System.Windows.Forms.ToolBarButton();
			this.printDocument1 = new System.Drawing.Printing.PrintDocument();
			this.pageSetupDialog1 = new System.Windows.Forms.PageSetupDialog();
			this.printPreviewDialog1 = new System.Windows.Forms.PrintPreviewDialog();
			this.panelEx1 = new DevComponents.DotNetBar.PanelEx();
			this.buttonX2 = new DevComponents.DotNetBar.ButtonX();
			this.textBoxX3 = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX5 = new DevComponents.DotNetBar.LabelX();
			this.comboBoxEx2 = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.buttonX1 = new DevComponents.DotNetBar.ButtonX();
			this.labelX4 = new DevComponents.DotNetBar.LabelX();
			this.comboBoxEx1 = new DevComponents.DotNetBar.Controls.ComboBoxEx();
			this.textBoxX1 = new DevComponents.DotNetBar.Controls.TextBoxX();
			this.labelX2 = new DevComponents.DotNetBar.LabelX();
			this.labelX1 = new DevComponents.DotNetBar.LabelX();
			this.panelEx2 = new DevComponents.DotNetBar.PanelEx();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.panelEx1.SuspendLayout();
			this.panelEx2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.SuspendLayout();
			// 
			// imageList1
			// 
			this.imageList1.ImageSize = new System.Drawing.Size(30, 30);
			this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
			this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// toolBar1
			// 
			this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																						this.toolBarButton2,
																						this.toolBarButton4,
																						this.toolBarButton5});
			this.toolBar1.ButtonSize = new System.Drawing.Size(70, 50);
			this.toolBar1.DropDownArrows = true;
			this.toolBar1.ImageList = this.imageList1;
			this.toolBar1.Location = new System.Drawing.Point(0, 0);
			this.toolBar1.Name = "toolBar1";
			this.toolBar1.ShowToolTips = true;
			this.toolBar1.Size = new System.Drawing.Size(720, 56);
			this.toolBar1.TabIndex = 0;
			this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
			// 
			// toolBarButton2
			// 
			this.toolBarButton2.ImageIndex = 1;
			this.toolBarButton2.Text = "查询";
			this.toolBarButton2.ToolTipText = "查询信息";
			// 
			// toolBarButton4
			// 
			this.toolBarButton4.ImageIndex = 2;
			this.toolBarButton4.Text = "打印";
			this.toolBarButton4.ToolTipText = "打印数据";
			// 
			// toolBarButton5
			// 
			this.toolBarButton5.ImageIndex = 5;
			this.toolBarButton5.Text = "退出";
			this.toolBarButton5.ToolTipText = "退出";
			// 
			// printDocument1
			// 
			this.printDocument1.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.printDocument1_PrintPage_1);
			// 
			// pageSetupDialog1
			// 
			this.pageSetupDialog1.Document = this.printDocument1;
			// 
			// printPreviewDialog1
			// 
			this.printPreviewDialog1.AutoScrollMargin = new System.Drawing.Size(0, 0);
			this.printPreviewDialog1.AutoScrollMinSize = new System.Drawing.Size(0, 0);
			this.printPreviewDialog1.ClientSize = new System.Drawing.Size(400, 300);
			this.printPreviewDialog1.Document = this.printDocument1;
			this.printPreviewDialog1.Enabled = true;
			this.printPreviewDialog1.Icon = ((System.Drawing.Icon)(resources.GetObject("printPreviewDialog1.Icon")));
			this.printPreviewDialog1.Location = new System.Drawing.Point(383, 19);
			this.printPreviewDialog1.MinimumSize = new System.Drawing.Size(375, 250);
			this.printPreviewDialog1.Name = "printPreviewDialog1";
			this.printPreviewDialog1.TransparencyKey = System.Drawing.Color.Empty;
			this.printPreviewDialog1.Visible = false;
			// 
			// panelEx1
			// 
			this.panelEx1.CanvasColor = System.Drawing.SystemColors.Control;
			this.panelEx1.Controls.Add(this.buttonX2);
			this.panelEx1.Controls.Add(this.textBoxX3);
			this.panelEx1.Controls.Add(this.labelX5);
			this.panelEx1.Controls.Add(this.comboBoxEx2);
			this.panelEx1.Controls.Add(this.buttonX1);
			this.panelEx1.Controls.Add(this.labelX4);
			this.panelEx1.Controls.Add(this.comboBoxEx1);
			this.panelEx1.Controls.Add(this.textBoxX1);
			this.panelEx1.Controls.Add(this.labelX2);
			this.panelEx1.Controls.Add(this.labelX1);
			this.panelEx1.Dock = System.Windows.Forms.DockStyle.Top;
			this.panelEx1.Location = new System.Drawing.Point(0, 56);
			this.panelEx1.Name = "panelEx1";
			this.panelEx1.Size = new System.Drawing.Size(720, 168);
			this.panelEx1.Style.Alignment = System.Drawing.StringAlignment.Center;
			this.panelEx1.Style.BackColor1.ColorSchemePart = DevComponents.DotNetBar.eColorSchemePart.BarBackground;
			this.panelEx1.Style.BackColor2.ColorSchemePart = DevComponents.DotNetBar.eColorSchemePart.BarBackground2;
			this.panelEx1.Style.BorderColor.ColorSchemePart = DevComponents.DotNetBar.eColorSchemePart.BarDockedBorder;
			this.panelEx1.Style.ForeColor.ColorSchemePart = DevComponents.DotNetBar.eColorSchemePart.ItemText;
			this.panelEx1.Style.GradientAngle = 90;
			this.panelEx1.TabIndex = 2;
			// 
			// buttonX2
			// 
			this.buttonX2.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
			this.buttonX2.Image = ((System.Drawing.Image)(resources.GetObject("buttonX2.Image")));
			this.buttonX2.Location = new System.Drawing.Point(368, 136);
			this.buttonX2.Name = "buttonX2";
			this.buttonX2.Size = new System.Drawing.Size(96, 24);
			this.buttonX2.TabIndex = 11;
			this.buttonX2.Text = "取消";
			this.buttonX2.Click += new System.EventHandler(this.buttonX2_Click);
			// 
			// textBoxX3
			// 
			this.textBoxX3.AutoSize = false;
			// 
			// textBoxX3.Border
			// 
			this.textBoxX3.Border.Class = "TextBoxBorder";
			this.textBoxX3.Location = new System.Drawing.Point(248, 64);
			this.textBoxX3.Name = "textBoxX3";
			this.textBoxX3.Size = new System.Drawing.Size(448, 56);
			this.textBoxX3.TabIndex = 10;
			// 
			// labelX5
			// 
			this.labelX5.Location = new System.Drawing.Point(32, 64);
			this.labelX5.Name = "labelX5";
			this.labelX5.Size = new System.Drawing.Size(176, 48);
			this.labelX5.TabIndex = 9;
			this.labelX5.Text = "     交易备注(可以不填写)";
			// 
			// comboBoxEx2
			// 
			this.comboBoxEx2.DisplayMember = "Text";
			this.comboBoxEx2.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed;
			this.comboBoxEx2.Location = new System.Drawing.Point(600, 24);
			this.comboBoxEx2.Name = "comboBoxEx2";
			this.comboBoxEx2.Size = new System.Drawing.Size(104, 22);
			this.comboBoxEx2.TabIndex = 7;
			// 
			// buttonX1
			// 
			this.buttonX1.AccessibleRole = System.Windows.Forms.AccessibleRole.PushButton;
			this.buttonX1.Image = ((System.Drawing.Image)(resources.GetObject("buttonX1.Image")));
			this.buttonX1.Location = new System.Drawing.Point(224, 136);
			this.buttonX1.Name = "buttonX1";