/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.dataGrid2 = new System.Windows.Forms.DataGrid(); this.dataView1 = new System.Data.DataView(); this.dataSet11 = new 酒店管理系统.DataSet1(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.da2 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.btnCal = new System.Windows.Forms.Button(); this.btnLeave = new System.Windows.Forms.Button(); this.txt4 = new System.Windows.Forms.TextBox(); this.cmb1 = new System.Windows.Forms.ComboBox(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.label4 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.groupBox2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); this.SuspendLayout(); // // label1 // this.label1.Text = "客房编号"; // // btnSearch // this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click); // // label2 // this.label2.Text = "入住单号"; // // txt3 // this.txt3.Visible = false; // // label3 // this.label3.Visible = false; // // toolBar1 // this.toolBar1.Size = new System.Drawing.Size(728, 41); this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick_1); // // tBtnNew // this.tBtnNew.Visible = false; // // tBtnEdit // this.tBtnEdit.Visible = false; // // tBtnDelete // this.tBtnDelete.Visible = false; // // tBtnSubmit // this.tBtnSubmit.Visible = false; // // tBtnCancel // this.tBtnCancel.Visible = false; // // dataGrid1 // this.dataGrid1.DataMember = "入住单"; this.dataGrid1.DataSource = this.dataSet11; this.dataGrid1.Size = new System.Drawing.Size(728, 160); this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged); // // groupBox2 // this.groupBox2.Controls.Add(this.label4); this.groupBox2.Controls.Add(this.cmb1); this.groupBox2.Controls.Add(this.txt4); this.groupBox2.Controls.Add(this.btnCal); this.groupBox2.Controls.Add(this.btnLeave); this.groupBox2.Controls.Add(this.label5); this.groupBox2.Location = new System.Drawing.Point(0, 414); this.groupBox2.Size = new System.Drawing.Size(728, 82); // // da1 // this.da1.DeleteCommand = null; this.da1.InsertCommand = null; 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("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("付款方式", "付款方式"), new System.Data.Common.DataColumnMapping("入住人数", "入住人数") }) }); this.da1.UpdateCommand = null; // // dataGrid2 // this.dataGrid2.CaptionVisible = false; this.dataGrid2.DataMember = ""; this.dataGrid2.DataSource = this.dataView1; this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid2.Location = new System.Drawing.Point(0, 256); this.dataGrid2.Name = "dataGrid2"; this.dataGrid2.ReadOnly = true; this.dataGrid2.Size = new System.Drawing.Size(728, 152); this.dataGrid2.TabIndex = 32; // // dataView1 // this.dataView1.Table = this.dataSet11.帐单明细; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // da2 // this.da2.SelectCommand = this.sqlSelectCommand2; this.da2.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("备注", "备注") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT 帐单编号, 入住单号, 消费内容, 消费金额, 消费时间, 备注 FROM 帐单明细"; this.sqlSelectCommand2.Connection = this.sqlConnection1; // // btnCal // this.btnCal.Location = new System.Drawing.Point(56, 32); this.btnCal.Name = "btnCal"; this.btnCal.Size = new System.Drawing.Size(112, 23); this.btnCal.TabIndex = 0; this.btnCal.Text = "计算应收款"; this.btnCal.Click += new System.EventHandler(this.btnCal_Click); // // btnLeave // this.btnLeave.Location = new System.Drawing.Point(464, 33); this.btnLeave.Name = "btnLeave"; this.btnLeave.Size = new System.Drawing.Size(128, 23); this.btnLeave.TabIndex = 0; this.btnLeave.Text = "收银结帐退房"; this.btnLeave.Click += new System.EventHandler(this.btnLeave_Click); // // txt4 // this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.应收帐款", true)); this.txt4.Location = new System.Drawing.Point(192, 34); this.txt4.Name = "txt4"; this.txt4.Size = new System.Drawing.Size(100, 21); this.txt4.TabIndex = 1; // // cmb1 // this.cmb1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "入住单.付款方式", true)); this.cmb1.Items.AddRange(new object[] { "现金", "支票", "信用卡", "代金券", "其他" }); this.cmb1.Location = new System.Drawing.Point(312, 35); this.cmb1.Name = "cmb1"; this.cmb1.Size = new System.Drawing.Size(121, 20); this.cmb1.TabIndex = 2; // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT 入住单号, 预定单号, 会员编号, 抵店时间, 离店时间, 客房编号, 客房价格, 入住价格, 是否加床, 加床价格, 预收款, 早餐, 叫醒, 保" + "密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式, 入住人数 FROM 入住单 WHERE (入住单号 LIKE" + " @Param17) AND (客房编号 LIKE @Param18)"; this.sqlSelectCommand1.Connection = this.sqlConnection1; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param17", System.Data.SqlDbType.VarChar, 36, "入住单号"), new System.Data.SqlClient.SqlParameter("@Param18", System.Data.SqlDbType.VarChar, 12, "客房编号") }); // // label4 // this.label4.Location = new System.Drawing.Point(192, 18); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(56, 15); this.label4.TabIndex = 3; this.label4.Text = "应付款"; // // label5 // this.label5.Location = new System.Drawing.Point(312, 17); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(56, 15); this.label5.TabIndex = 3; this.label5.Text = "支付方式"; // // HotelLeave // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(728, 502); this.Controls.Add(this.dataGrid2); this.Name = "HotelLeave"; this.Text = "收银结帐"; this.Load += new System.EventHandler(this.HotelLeave_Load); this.Controls.SetChildIndex(this.dataGrid2, 0); this.Controls.SetChildIndex(this.groupBox1, 0); this.Controls.SetChildIndex(this.toolBar1, 0); this.Controls.SetChildIndex(this.dataGrid1, 0); this.Controls.SetChildIndex(this.groupBox2, 0); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RoomType)); this.txt4 = new System.Windows.Forms.TextBox(); this.dataSet11 = new 酒店管理系统.DataSet1(); this.txt5 = new System.Windows.Forms.TextBox(); this.label6 = new System.Windows.Forms.Label(); this.txt6 = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.groupBox2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); this.SuspendLayout(); // // label1 // this.label1.Text = "类型名称"; // // btnSearch // this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click); // // label2 // this.label2.Text = "类型编号"; // // txt3 // this.txt3.Visible = false; // // label3 // this.label3.Visible = false; // // toolBar1 // this.toolBar1.Size = new System.Drawing.Size(728, 41); // // dataGrid1 // this.dataGrid1.DataMember = "客房类型"; this.dataGrid1.DataSource = this.dataSet11; this.dataGrid1.Size = new System.Drawing.Size(728, 197); // // groupBox2 // this.groupBox2.Controls.Add(this.txt4); this.groupBox2.Controls.Add(this.txt5); this.groupBox2.Controls.Add(this.txt6); this.groupBox2.Controls.Add(this.label6); this.groupBox2.Controls.Add(this.label4); this.groupBox2.Controls.Add(this.label5); this.groupBox2.Location = new System.Drawing.Point(0, 289); this.groupBox2.Size = new System.Drawing.Size(728, 86); // // 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("是否可拼房", "是否可拼房") }) }); this.da1.UpdateCommand = this.sqlUpdateCommand1; // // txt4 // this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房类型.类型编号", true)); this.txt4.Location = new System.Drawing.Point(124, 40); this.txt4.Name = "txt4"; this.txt4.ReadOnly = true; this.txt4.Size = new System.Drawing.Size(136, 21); this.txt4.TabIndex = 6; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txt5 // this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房类型.类型名称", true)); this.txt5.Location = new System.Drawing.Point(292, 40); this.txt5.Name = "txt5"; this.txt5.ReadOnly = true; this.txt5.Size = new System.Drawing.Size(136, 21); this.txt5.TabIndex = 7; // // label6 // this.label6.Location = new System.Drawing.Point(468, 24); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(100, 16); this.label6.TabIndex = 2; this.label6.Text = "价格"; // // txt6 // this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房类型.价格", true)); this.txt6.Location = new System.Drawing.Point(468, 40); this.txt6.Name = "txt6"; this.txt6.ReadOnly = true; this.txt6.Size = new System.Drawing.Size(136, 21); this.txt6.TabIndex = 5; this.txt6.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txt6_KeyPress); // // label4 // this.label4.Location = new System.Drawing.Point(296, 26); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(100, 16); this.label4.TabIndex = 2; this.label4.Text = "类型名称"; // // label5 // this.label5.Location = new System.Drawing.Point(128, 26); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(100, 16); this.label5.TabIndex = 2; this.label5.Text = "类型编号"; // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT 类型编号, 类型名称, 价格, 拼房价格, 可超预定数, 是否可拼房 FROM 客房类型 WHERE (类型编号 LIKE @Param3) AND" + " (类型名称 LIKE @Param4)"; this.sqlSelectCommand1.Connection = this.sqlConnection1; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 40, "类型名称") }); // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO 客房类型(类型编号, 类型名称, 价格, 拼房价格, 可超预定数, 是否可拼房) VALUES (@类型编号, @类型名称, @价格, @" + "拼房价格, @可超预定数, @是否可拼房); SELECT 类型编号, 类型名称, 价格, 拼房价格, 可超预定数, 是否可拼房 FROM 客房类型 WHERE" + " (类型编号 = @类型编号)"; this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@类型名称", System.Data.SqlDbType.VarChar, 40, "类型名称"), new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 8, "价格"), new System.Data.SqlClient.SqlParameter("@拼房价格", System.Data.SqlDbType.Money, 8, "拼房价格"), new System.Data.SqlClient.SqlParameter("@可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "可超预定数", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房") }); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConnection1; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@类型名称", System.Data.SqlDbType.VarChar, 40, "类型名称"), new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 8, "价格"), new System.Data.SqlClient.SqlParameter("@拼房价格", System.Data.SqlDbType.Money, 8, "拼房价格"), new System.Data.SqlClient.SqlParameter("@可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "可超预定数", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_价格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "价格", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "可超预定数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_拼房价格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "拼房价格", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型名称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型名称", System.Data.DataRowVersion.Original, null) }); // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText"); this.sqlDeleteCommand1.Connection = this.sqlConnection1; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_价格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "价格", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "可超预定数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_拼房价格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "拼房价格", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型名称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型名称", System.Data.DataRowVersion.Original, null) }); // // RoomType // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(728, 389); this.Name = "RoomType"; this.Text = "【客房类型设置】"; this.Load += new System.EventHandler(this.RoomType_Load); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RoomInfo)); this.txt4 = new System.Windows.Forms.TextBox(); this.dataSet11 = new 酒店管理系统.DataSet1(); this.label4 = new System.Windows.Forms.Label(); this.txt5 = new System.Windows.Forms.TextBox(); this.label5 = new System.Windows.Forms.Label(); this.txt8 = new System.Windows.Forms.TextBox(); this.txt6 = new System.Windows.Forms.TextBox(); this.label9 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.cmb2 = new System.Windows.Forms.ComboBox(); this.cmb3 = new System.Windows.Forms.ComboBox(); this.label10 = new System.Windows.Forms.Label(); this.txt7 = new System.Windows.Forms.TextBox(); this.txt9 = new System.Windows.Forms.TextBox(); this.label11 = new System.Windows.Forms.Label(); this.checkBox1 = new System.Windows.Forms.CheckBox(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand4 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand5 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand6 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand7 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand8 = new System.Data.SqlClient.SqlCommand(); this.da2 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.da3 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.groupBox2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); this.SuspendLayout(); // // groupBox1 // this.groupBox1.Size = new System.Drawing.Size(736, 56); // // label1 // this.label1.Text = "类型编号"; // // btnSearch // this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click); // // label2 // this.label2.Text = "客房编号"; // // label3 // this.label3.Text = "楼层编号"; // // toolBar1 // this.toolBar1.Size = new System.Drawing.Size(736, 41); // // dataGrid1 // this.dataGrid1.DataMember = "客房信息"; this.dataGrid1.DataSource = this.dataSet11; this.dataGrid1.Size = new System.Drawing.Size(736, 228); // // groupBox2 // this.groupBox2.Controls.Add(this.checkBox1); this.groupBox2.Controls.Add(this.cmb2); this.groupBox2.Controls.Add(this.cmb3); this.groupBox2.Controls.Add(this.txt4); this.groupBox2.Controls.Add(this.txt5); this.groupBox2.Controls.Add(this.txt8); this.groupBox2.Controls.Add(this.txt6); this.groupBox2.Controls.Add(this.txt7); this.groupBox2.Controls.Add(this.txt9); this.groupBox2.Controls.Add(this.label4); this.groupBox2.Controls.Add(this.label5); this.groupBox2.Controls.Add(this.label9); this.groupBox2.Controls.Add(this.label7); this.groupBox2.Controls.Add(this.label6); this.groupBox2.Controls.Add(this.label8); this.groupBox2.Controls.Add(this.label10); this.groupBox2.Controls.Add(this.label11); this.groupBox2.Location = new System.Drawing.Point(0, 330); this.groupBox2.Size = new System.Drawing.Size(736, 128); // // da1 // this.da1.DeleteCommand = this.sqlCommand8; this.da1.InsertCommand = this.sqlCommand6; this.da1.SelectCommand = this.sqlCommand5; 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("是否可拼房", "是否可拼房") }) }); this.da1.UpdateCommand = this.sqlCommand7; // // txt4 // this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.客房编号", true)); this.txt4.Location = new System.Drawing.Point(40, 40); this.txt4.Name = "txt4"; this.txt4.ReadOnly = true; this.txt4.Size = new System.Drawing.Size(112, 21); this.txt4.TabIndex = 15; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label4 // this.label4.Location = new System.Drawing.Point(40, 24); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(100, 16); this.label4.TabIndex = 13; this.label4.Text = "客房编号"; // // txt5 // this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.额定人数", true)); this.txt5.Location = new System.Drawing.Point(440, 40); this.txt5.Name = "txt5"; this.txt5.ReadOnly = true; this.txt5.Size = new System.Drawing.Size(64, 21); this.txt5.TabIndex = 16; // // label5 // this.label5.Location = new System.Drawing.Point(176, 24); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(100, 16); this.label5.TabIndex = 10; this.label5.Text = "客房类型"; // // txt8 // this.txt8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.客房描述", true)); this.txt8.Location = new System.Drawing.Point(40, 86); this.txt8.Name = "txt8"; this.txt8.ReadOnly = true; this.txt8.Size = new System.Drawing.Size(232, 21); this.txt8.TabIndex = 17; // // txt6 // this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.床数", true)); this.txt6.Location = new System.Drawing.Point(528, 40); this.txt6.Name = "txt6"; this.txt6.ReadOnly = true; this.txt6.Size = new System.Drawing.Size(64, 21); this.txt6.TabIndex = 14; // // label9 // this.label9.Location = new System.Drawing.Point(440, 24); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(72, 16); this.label9.TabIndex = 11; this.label9.Text = "额定人数"; // // label7 // this.label7.Location = new System.Drawing.Point(40, 70); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(100, 16); this.label7.TabIndex = 12; this.label7.Text = "客房描述"; // // label6 // this.label6.Location = new System.Drawing.Point(312, 24); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(100, 16); this.label6.TabIndex = 10; this.label6.Text = "楼层"; // // label8 // this.label8.Location = new System.Drawing.Point(528, 24); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(72, 16); this.label8.TabIndex = 11; this.label8.Text = "床数"; // // cmb2 // this.cmb2.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dataSet11, "客房信息.类型编号", true)); this.cmb2.DataSource = this.dataSet11; this.cmb2.DisplayMember = "客房类型.类型名称"; this.cmb2.Enabled = false; this.cmb2.Location = new System.Drawing.Point(176, 40); this.cmb2.Name = "cmb2"; this.cmb2.Size = new System.Drawing.Size(120, 20); this.cmb2.TabIndex = 19; this.cmb2.ValueMember = "客房信息.类型编号"; // // cmb3 // this.cmb3.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dataSet11, "客房信息.楼层编号", true)); this.cmb3.DataSource = this.dataSet11; this.cmb3.DisplayMember = "楼层信息.楼层名称"; this.cmb3.Enabled = false; this.cmb3.Location = new System.Drawing.Point(312, 40); this.cmb3.Name = "cmb3"; this.cmb3.Size = new System.Drawing.Size(104, 20); this.cmb3.TabIndex = 18; this.cmb3.ValueMember = "楼层信息.楼层编号"; // // label10 // this.label10.Location = new System.Drawing.Point(616, 24); this.label10.Name = "label10"; this.label10.Size = new System.Drawing.Size(72, 16); this.label10.TabIndex = 11; this.label10.Text = "状态"; // // txt7 // this.txt7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.状态", true)); this.txt7.Location = new System.Drawing.Point(616, 40); this.txt7.Name = "txt7"; this.txt7.ReadOnly = true; this.txt7.Size = new System.Drawing.Size(88, 21); this.txt7.TabIndex = 14; // // txt9 // this.txt9.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "客房信息.备注", true)); this.txt9.Location = new System.Drawing.Point(304, 86); this.txt9.Name = "txt9"; this.txt9.ReadOnly = true; this.txt9.Size = new System.Drawing.Size(232, 21); this.txt9.TabIndex = 17; // // label11 // this.label11.Location = new System.Drawing.Point(304, 72); this.label11.Name = "label11"; this.label11.Size = new System.Drawing.Size(100, 16); this.label11.TabIndex = 12; this.label11.Text = "备注"; // // checkBox1 // this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.dataSet11, "客房信息.是否可拼房", true)); this.checkBox1.Location = new System.Drawing.Point(568, 82); this.checkBox1.Name = "checkBox1"; this.checkBox1.Size = new System.Drawing.Size(104, 24); this.checkBox1.TabIndex = 20; this.checkBox1.Text = "是否可拼房"; // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT 客房编号, 类型编号, 楼层编号, 额定人数, 床数, 客房描述, 备注, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 LIKE" + " @Param4) AND (类型编号 LIKE @Param5) AND (楼层编号 LIKE @Param6)"; this.sqlSelectCommand1.Connection = this.sqlConnection1; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.Int, 4, "楼层编号") }); // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText"); this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房") }); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConnection1; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"), new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText"); this.sqlDeleteCommand1.Connection = this.sqlConnection1; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // sqlCommand1 // this.sqlCommand1.CommandText = "SELECT 客房编号, 类型编号, 楼层编号, 额定人数, 床数, 客房描述, 备注, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 LIKE" + " @Param4) AND (类型编号 LIKE @Param5) AND (楼层编号 LIKE @Param6)"; this.sqlCommand1.Connection = this.sqlConnection1; this.sqlCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.Int, 4, "楼层编号") }); // // sqlCommand2 // this.sqlCommand2.CommandText = resources.GetString("sqlCommand2.CommandText"); this.sqlCommand2.Connection = this.sqlConnection1; this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房") }); // // sqlCommand3 // this.sqlCommand3.CommandText = resources.GetString("sqlCommand3.CommandText"); this.sqlCommand3.Connection = this.sqlConnection1; this.sqlCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"), new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // sqlCommand4 // this.sqlCommand4.CommandText = resources.GetString("sqlCommand4.CommandText"); this.sqlCommand4.Connection = this.sqlConnection1; this.sqlCommand4.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // sqlCommand5 // this.sqlCommand5.CommandText = "SELECT 客房编号, 类型编号, 楼层编号, 额定人数, 床数, 客房描述, 备注, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 LIKE" + " @Param4) AND (类型编号 LIKE @Param5) AND (楼层编号 LIKE @Param6)"; this.sqlCommand5.Connection = this.sqlConnection1; this.sqlCommand5.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.VarChar, 4, "楼层编号") }); // // sqlCommand6 // this.sqlCommand6.CommandText = resources.GetString("sqlCommand6.CommandText"); this.sqlCommand6.Connection = this.sqlConnection1; this.sqlCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房") }); // // sqlCommand7 // this.sqlCommand7.CommandText = resources.GetString("sqlCommand7.CommandText"); this.sqlCommand7.Connection = this.sqlConnection1; this.sqlCommand7.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"), new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"), new System.Data.SqlClient.SqlParameter("@楼层编号", System.Data.SqlDbType.Int, 4, "楼层编号"), new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"), new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"), new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"), new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"), new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 4, "状态"), new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"), new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // sqlCommand8 // this.sqlCommand8.CommandText = resources.GetString("sqlCommand8.CommandText"); this.sqlCommand8.Connection = this.sqlConnection1; this.sqlCommand8.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "床数", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_楼层编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "楼层编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "状态", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null) }); // // da2 // this.da2.SelectCommand = this.sqlSelectCommand2; this.da2.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("楼层名称", "楼层名称") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT 楼层编号, 楼层名称 FROM 楼层信息"; this.sqlSelectCommand2.Connection = this.sqlConnection1; // // da3 // this.da3.SelectCommand = this.sqlSelectCommand3; this.da3.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("是否可拼房", "是否可拼房") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT 类型编号, 类型名称, 价格, 拼房价格, 可超预定数, 是否可拼房 FROM 客房类型"; this.sqlSelectCommand3.Connection = this.sqlConnection1; // // RoomInfo // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(736, 456); this.Name = "RoomInfo"; this.Text = "【客房信息设置】"; this.Load += new System.EventHandler(this.RoomInfo_Load); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }