hotelarrival.cs

C#数据库编程（酒店管理系统）

			this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
			// 
			// txt1
			// 
			this.txt1.Name = "txt1";
			// 
			// label2
			// 
			this.label2.Name = "label2";
			this.label2.Text = "入住单号";
			// 
			// txt3
			// 
			this.txt3.Name = "txt3";
			// 
			// label3
			// 
			this.label3.Name = "label3";
			this.label3.Text = "抵店时间";
			// 
			// toolBar1
			// 
			this.toolBar1.Name = "toolBar1";
			this.toolBar1.Size = new System.Drawing.Size(728, 41);
			this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
			// 
			// tBtnDelete
			// 
			this.tBtnDelete.Visible = false;
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataMember = "入住单";
			this.dataGrid1.DataSource = this.dataSet21;
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(728, 176);
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.btnRoom);
			this.groupBox2.Controls.Add(this.checkBox2);
			this.groupBox2.Controls.Add(this.checkBox3);
			this.groupBox2.Controls.Add(this.checkBox4);
			this.groupBox2.Controls.Add(this.checkBox5);
			this.groupBox2.Controls.Add(this.checkBox1);
			this.groupBox2.Controls.Add(this.cmb1);
			this.groupBox2.Controls.Add(this.btnImport);
			this.groupBox2.Controls.Add(this.txt4);
			this.groupBox2.Controls.Add(this.label4);
			this.groupBox2.Controls.Add(this.txt5);
			this.groupBox2.Controls.Add(this.label5);
			this.groupBox2.Controls.Add(this.label6);
			this.groupBox2.Controls.Add(this.txt7);
			this.groupBox2.Controls.Add(this.txt6);
			this.groupBox2.Controls.Add(this.label9);
			this.groupBox2.Controls.Add(this.label7);
			this.groupBox2.Controls.Add(this.cmb2);
			this.groupBox2.Controls.Add(this.label8);
			this.groupBox2.Controls.Add(this.label10);
			this.groupBox2.Controls.Add(this.cmb3);
			this.groupBox2.Controls.Add(this.txt8);
			this.groupBox2.Controls.Add(this.label11);
			this.groupBox2.Controls.Add(this.label12);
			this.groupBox2.Controls.Add(this.txt9);
			this.groupBox2.Controls.Add(this.label13);
			this.groupBox2.Controls.Add(this.txt10);
			this.groupBox2.Controls.Add(this.txt11);
			this.groupBox2.Controls.Add(this.label14);
			this.groupBox2.Controls.Add(this.label15);
			this.groupBox2.Controls.Add(this.label16);
			this.groupBox2.Controls.Add(this.txt13);
			this.groupBox2.Controls.Add(this.label17);
			this.groupBox2.Controls.Add(this.txt14);
			this.groupBox2.Controls.Add(this.label18);
			this.groupBox2.Controls.Add(this.txt12);
			this.groupBox2.Controls.Add(this.txt15);
			this.groupBox2.Controls.Add(this.label19);
			this.groupBox2.Controls.Add(this.txt16);
			this.groupBox2.Controls.Add(this.label20);
			this.groupBox2.Controls.Add(this.label21);
			this.groupBox2.Controls.Add(this.txt17);
			this.groupBox2.Controls.Add(this.label22);
			this.groupBox2.Controls.Add(this.txt18);
			this.groupBox2.Controls.Add(this.txt20);
			this.groupBox2.Controls.Add(this.label23);
			this.groupBox2.Controls.Add(this.cmb4);
			this.groupBox2.Controls.Add(this.label24);
			this.groupBox2.Controls.Add(this.txt19);
			this.groupBox2.Location = new System.Drawing.Point(0, 272);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(728, 248);
			// 
			// da1
			// 
			this.da1.DeleteCommand = this.sqlDeleteCommand1;
			this.da1.InsertCommand = this.sqlInsertCommand1;
			this.da1.SelectCommand = this.sqlSelectCommand1;
			this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																						  new System.Data.Common.DataTableMapping("Table", "入住单", new System.Data.Common.DataColumnMapping[] {
																																																 new System.Data.Common.DataColumnMapping("入住单号", "入住单号"),
																																																 new System.Data.Common.DataColumnMapping("预定单号", "预定单号"),
																																																 new System.Data.Common.DataColumnMapping("会员编号", "会员编号"),
																																																 new System.Data.Common.DataColumnMapping("客房类型", "客房类型"),
																																																 new System.Data.Common.DataColumnMapping("抵店时间", "抵店时间"),
																																																 new System.Data.Common.DataColumnMapping("离店时间", "离店时间"),
																																																 new System.Data.Common.DataColumnMapping("单据状态", "单据状态"),
																																																 new System.Data.Common.DataColumnMapping("入住人数", "入住人数"),
																																																 new System.Data.Common.DataColumnMapping("客房编号", "客房编号"),
																																																 new System.Data.Common.DataColumnMapping("客房价格", "客房价格"),
																																																 new System.Data.Common.DataColumnMapping("入住价格", "入住价格"),
																																																 new System.Data.Common.DataColumnMapping("折扣", "折扣"),
																																																 new System.Data.Common.DataColumnMapping("折扣原因", "折扣原因"),
																																																 new System.Data.Common.DataColumnMapping("是否加床", "是否加床"),
																																																 new System.Data.Common.DataColumnMapping("加床价格", "加床价格"),
																																																 new System.Data.Common.DataColumnMapping("预收款", "预收款"),
																																																 new System.Data.Common.DataColumnMapping("预定人", "预定人"),
																																																 new System.Data.Common.DataColumnMapping("预定公司", "预定公司"),
																																																 new System.Data.Common.DataColumnMapping("联系电话", "联系电话"),
																																																 new System.Data.Common.DataColumnMapping("备注", "备注"),
																																																 new System.Data.Common.DataColumnMapping("操作员", "操作员"),
																																																 new System.Data.Common.DataColumnMapping("业务员", "业务员"),
																																																 new System.Data.Common.DataColumnMapping("早餐", "早餐"),
																																																 new System.Data.Common.DataColumnMapping("叫醒", "叫醒"),
																																																 new System.Data.Common.DataColumnMapping("保密", "保密"),
																																																 new System.Data.Common.DataColumnMapping("vip", "vip"),
																																																 new System.Data.Common.DataColumnMapping("电话等级", "电话等级"),
																																																 new System.Data.Common.DataColumnMapping("特要说明", "特要说明"),
																																																 new System.Data.Common.DataColumnMapping("应收帐款", "应收帐款"),
																																																 new System.Data.Common.DataColumnMapping("是否结帐", "是否结帐"),
																																																 new System.Data.Common.DataColumnMapping("结帐金额", "结帐金额"),
																																																 new System.Data.Common.DataColumnMapping("结帐日期", "结帐日期"),
																																																 new System.Data.Common.DataColumnMapping("付款方式", "付款方式")})});
			this.da1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// txt4
			// 
			this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.入住单号"));
			this.txt4.Location = new System.Drawing.Point(24, 34);
			this.txt4.Name = "txt4";
			this.txt4.ReadOnly = true;
			this.txt4.Size = new System.Drawing.Size(112, 21);
			this.txt4.TabIndex = 52;
			this.txt4.Text = "";
			// 
			// dataSet21
			// 
			this.dataSet21.DataSetName = "DataSet2";
			this.dataSet21.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(24, 18);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(100, 16);
			this.label4.TabIndex = 50;
			this.label4.Text = "入住单号";
			// 
			// txt5
			// 
			this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.联系电话"));
			this.txt5.Location = new System.Drawing.Point(568, 34);
			this.txt5.Name = "txt5";
			this.txt5.ReadOnly = true;
			this.txt5.Size = new System.Drawing.Size(136, 21);
			this.txt5.TabIndex = 53;
			this.txt5.Text = "";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(568, 18);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(100, 16);
			this.label5.TabIndex = 31;
			this.label5.Text = "联系电话";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(152, 18);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(56, 16);
			this.label6.TabIndex = 32;
			this.label6.Text = "客房类型";
			// 
			// txt7