frmreside.cs

采用C#和SQL Server 2000开发 功能比较全面的酒店管理系统

			this.Label13.TabIndex = 72;
			this.Label13.Text = "折扣原因";
			// 
			// txbDiscount
			// 
			this.txbDiscount.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.折扣"));
			this.txbDiscount.Location = new System.Drawing.Point(174, 62);
			this.txbDiscount.Name = "txbDiscount";
			this.txbDiscount.Size = new System.Drawing.Size(61, 20);
			this.txbDiscount.TabIndex = 71;
			this.txbDiscount.Text = "";
			// 
			// Label12
			// 
			this.Label12.Location = new System.Drawing.Point(171, 47);
			this.Label12.Name = "Label12";
			this.Label12.Size = new System.Drawing.Size(57, 13);
			this.Label12.TabIndex = 70;
			this.Label12.Text = "折扣";
			// 
			// txbNowPrice
			// 
			this.txbNowPrice.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.入住价格"));
			this.txbNowPrice.Location = new System.Drawing.Point(88, 62);
			this.txbNowPrice.Name = "txbNowPrice";
			this.txbNowPrice.Size = new System.Drawing.Size(61, 20);
			this.txbNowPrice.TabIndex = 69;
			this.txbNowPrice.Text = "";
			// 
			// Label11
			// 
			this.Label11.Location = new System.Drawing.Point(84, 47);
			this.Label11.Name = "Label11";
			this.Label11.Size = new System.Drawing.Size(58, 13);
			this.Label11.TabIndex = 68;
			this.Label11.Text = "入住价格";
			// 
			// txbOriginPrice
			// 
			this.txbOriginPrice.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.客房价格"));
			this.txbOriginPrice.Location = new System.Drawing.Point(9, 62);
			this.txbOriginPrice.Name = "txbOriginPrice";
			this.txbOriginPrice.Size = new System.Drawing.Size(61, 20);
			this.txbOriginPrice.TabIndex = 67;
			this.txbOriginPrice.Text = "";
			// 
			// Label9
			// 
			this.Label9.Location = new System.Drawing.Point(8, 47);
			this.Label9.Name = "Label9";
			this.Label9.Size = new System.Drawing.Size(58, 13);
			this.Label9.TabIndex = 66;
			this.Label9.Text = "客房价格";
			// 
			// txbRoomCode
			// 
			this.txbRoomCode.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.客房编号"));
			this.txbRoomCode.Location = new System.Drawing.Point(408, 23);
			this.txbRoomCode.Name = "txbRoomCode";
			this.txbRoomCode.Size = new System.Drawing.Size(60, 20);
			this.txbRoomCode.TabIndex = 65;
			this.txbRoomCode.Text = "";
			// 
			// Label8
			// 
			this.Label8.Location = new System.Drawing.Point(406, 9);
			this.Label8.Name = "Label8";
			this.Label8.Size = new System.Drawing.Size(53, 13);
			this.Label8.TabIndex = 64;
			this.Label8.Text = "客房编号";
			// 
			// txbPhone
			// 
			this.txbPhone.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.联系电话"));
			this.txbPhone.Location = new System.Drawing.Point(329, 23);
			this.txbPhone.Name = "txbPhone";
			this.txbPhone.Size = new System.Drawing.Size(60, 20);
			this.txbPhone.TabIndex = 63;
			this.txbPhone.Text = "";
			// 
			// Label7
			// 
			this.Label7.Location = new System.Drawing.Point(327, 9);
			this.Label7.Name = "Label7";
			this.Label7.Size = new System.Drawing.Size(53, 13);
			this.Label7.TabIndex = 62;
			this.Label7.Text = "联系电话";
			// 
			// Label6
			// 
			this.Label6.Location = new System.Drawing.Point(250, 9);
			this.Label6.Name = "Label6";
			this.Label6.Size = new System.Drawing.Size(53, 13);
			this.Label6.TabIndex = 61;
			this.Label6.Text = "离店时间";
			// 
			// Label5
			// 
			this.Label5.Location = new System.Drawing.Point(171, 9);
			this.Label5.Name = "Label5";
			this.Label5.Size = new System.Drawing.Size(57, 13);
			this.Label5.TabIndex = 60;
			this.Label5.Text = "抵店时间";
			// 
			// cbbRoomType
			// 
			this.cbbRoomType.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.客房类型"));
			this.cbbRoomType.Location = new System.Drawing.Point(88, 23);
			this.cbbRoomType.Name = "cbbRoomType";
			this.cbbRoomType.Size = new System.Drawing.Size(71, 21);
			this.cbbRoomType.TabIndex = 59;
			this.cbbRoomType.SelectedValueChanged += new System.EventHandler(this.cbbRoomType_SelectedValueChanged);
			// 
			// Label10
			// 
			this.Label10.Location = new System.Drawing.Point(84, 9);
			this.Label10.Name = "Label10";
			this.Label10.Size = new System.Drawing.Size(58, 13);
			this.Label10.TabIndex = 58;
			this.Label10.Text = "客房类型";
			// 
			// txbInId
			// 
			this.txbInId.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.入住单号"));
			this.txbInId.Location = new System.Drawing.Point(9, 23);
			this.txbInId.Name = "txbInId";
			this.txbInId.ReadOnly = true;
			this.txbInId.Size = new System.Drawing.Size(61, 20);
			this.txbInId.TabIndex = 57;
			this.txbInId.Text = "";
			// 
			// Label4
			// 
			this.Label4.Location = new System.Drawing.Point(8, 9);
			this.Label4.Name = "Label4";
			this.Label4.Size = new System.Drawing.Size(58, 13);
			this.Label4.TabIndex = 56;
			this.Label4.Text = "入住单号";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "入住单", new System.Data.Common.DataColumnMapping[] {
																																																			 new System.Data.Common.DataColumnMapping("Expr1", "Expr1"),
																																																			 new System.Data.Common.DataColumnMapping("Expr2", "Expr2"),
																																																			 new System.Data.Common.DataColumnMapping("Expr3", "Expr3"),
																																																			 new System.Data.Common.DataColumnMapping("Expr4", "Expr4"),
																																																			 new System.Data.Common.DataColumnMapping("Expr5", "Expr5"),
																																																			 new System.Data.Common.DataColumnMapping("Expr6", "Expr6"),
																																																			 new System.Data.Common.DataColumnMapping("Expr7", "Expr7"),
																																																			 new System.Data.Common.DataColumnMapping("Expr8", "Expr8"),
																																																			 new System.Data.Common.DataColumnMapping("Expr9", "Expr9"),
																																																			 new System.Data.Common.DataColumnMapping("Expr10", "Expr10"),
																																																			 new System.Data.Common.DataColumnMapping("Expr11", "Expr11"),
																																																			 new System.Data.Common.DataColumnMapping("Expr12", "Expr12"),
																																																			 new System.Data.Common.DataColumnMapping("Expr13", "Expr13"),
																																																			 new System.Data.Common.DataColumnMapping("Expr14", "Expr14"),
																																																			 new System.Data.Common.DataColumnMapping("Expr15", "Expr15"),
																																																			 new System.Data.Common.DataColumnMapping("Expr16", "Expr16"),
																																																			 new System.Data.Common.DataColumnMapping("Expr17", "Expr17"),
																																																			 new System.Data.Common.DataColumnMapping("Expr18", "Expr18"),
																																																			 new System.Data.Common.DataColumnMapping("Expr19", "Expr19"),
																																																			 new System.Data.Common.DataColumnMapping("Expr20", "Expr20"),
																																																			 new System.Data.Common.DataColumnMapping("Expr21", "Expr21"),
																																																			 new System.Data.Common.DataColumnMapping("Expr22", "Expr22"),
																																																			 new System.Data.Common.DataColumnMapping("Expr23", "Expr23"),
																																																			 new System.Data.Common.DataColumnMapping("Expr24", "Expr24"),
																																																			 new System.Data.Common.DataColumnMapping("Expr25", "Expr25"),
																																																			 new System.Data.Common.DataColumnMapping("Expr26", "Expr26"),
																																																			 new System.Data.Common.DataColumnMapping("Expr27", "Expr27"),
																																																			 new System.Data.Common.DataColumnMapping("Expr28", "Expr28"),
																																																			 new System.Data.Common.DataColumnMapping("Expr29", "Expr29"),
																																																			 new System.Data.Common.DataColumnMapping("Expr30", "Expr30"),
																																																			 new System.Data.Common.DataColumnMapping("Expr31", "Expr31"),
																																																			 new System.Data.Common.DataColumnMapping("Expr32", "Expr32"),
																																																			 new System.Data.Common.DataColumnMapping("Expr33", "Expr33"),
																																																			 new System.Data.Common.DataColumnMapping("入住单号", "入住单号"),