/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.dtAccountTime = new System.Windows.Forms.DateTimePicker();
this.dtArrTime = new System.Windows.Forms.DateTimePicker();
this.txtRemarks = new System.Windows.Forms.TextBox();
this.label16 = new System.Windows.Forms.Label();
this.label15 = new System.Windows.Forms.Label();
this.txtDiscount = new System.Windows.Forms.TextBox();
this.label14 = new System.Windows.Forms.Label();
this.label13 = new System.Windows.Forms.Label();
this.txtMoney = new System.Windows.Forms.TextBox();
this.label12 = new System.Windows.Forms.Label();
this.txtContents = new System.Windows.Forms.TextBox();
this.label11 = new System.Windows.Forms.Label();
this.txtIDCard = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.txtName = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.txtPrice = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.txtPosition = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtType = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtRoomID = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtInID = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtBillID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.btnSave = new System.Windows.Forms.Button();
this.btnCancel = new System.Windows.Forms.Button();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.dtAccountTime);
this.groupBox1.Controls.Add(this.dtArrTime);
this.groupBox1.Controls.Add(this.txtRemarks);
this.groupBox1.Controls.Add(this.label16);
this.groupBox1.Controls.Add(this.label15);
this.groupBox1.Controls.Add(this.txtDiscount);
this.groupBox1.Controls.Add(this.label14);
this.groupBox1.Controls.Add(this.label13);
this.groupBox1.Controls.Add(this.txtMoney);
this.groupBox1.Controls.Add(this.label12);
this.groupBox1.Controls.Add(this.txtContents);
this.groupBox1.Controls.Add(this.label11);
this.groupBox1.Controls.Add(this.txtIDCard);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.txtName);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.txtPrice);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.txtPosition);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtType);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtRoomID);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtInID);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtBillID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(40, 32);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(576, 296);
this.groupBox1.TabIndex = 41;
this.groupBox1.TabStop = false;
//
// dtAccountTime
//
this.dtAccountTime.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtAccountTime.Location = new System.Drawing.Point(376, 216);
this.dtAccountTime.Name = "dtAccountTime";
this.dtAccountTime.Size = new System.Drawing.Size(176, 21);
this.dtAccountTime.TabIndex = 29;
//
// dtArrTime
//
this.dtArrTime.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtArrTime.Location = new System.Drawing.Point(376, 144);
this.dtArrTime.Name = "dtArrTime";
this.dtArrTime.Size = new System.Drawing.Size(176, 21);
this.dtArrTime.TabIndex = 28;
//
// txtRemarks
//
this.txtRemarks.Location = new System.Drawing.Point(376, 254);
this.txtRemarks.Name = "txtRemarks";
this.txtRemarks.Size = new System.Drawing.Size(176, 21);
this.txtRemarks.TabIndex = 27;
this.txtRemarks.Text = "";
//
// label16
//
this.label16.Location = new System.Drawing.Point(296, 254);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(72, 23);
this.label16.TabIndex = 26;
this.label16.Text = "备注";
this.label16.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label15
//
this.label15.Location = new System.Drawing.Point(296, 217);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(72, 23);
this.label15.TabIndex = 24;
this.label15.Text = "结算日期";
this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtDiscount
//
this.txtDiscount.Location = new System.Drawing.Point(376, 180);
this.txtDiscount.Name = "txtDiscount";
this.txtDiscount.Size = new System.Drawing.Size(176, 21);
this.txtDiscount.TabIndex = 23;
this.txtDiscount.Text = "";
//
// label14
//
this.label14.Location = new System.Drawing.Point(296, 180);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(72, 23);
this.label14.TabIndex = 22;
this.label14.Text = "折扣";
this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label13
//
this.label13.Location = new System.Drawing.Point(296, 143);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(72, 23);
this.label13.TabIndex = 20;
this.label13.Text = "入住时间";
this.label13.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtMoney
//
this.txtMoney.Location = new System.Drawing.Point(376, 106);
this.txtMoney.Name = "txtMoney";
this.txtMoney.Size = new System.Drawing.Size(176, 21);
this.txtMoney.TabIndex = 19;
this.txtMoney.Text = "";
//
// label12
//
this.label12.Location = new System.Drawing.Point(296, 106);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(72, 23);
this.label12.TabIndex = 18;
this.label12.Text = "消费金额";
this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtContents
//
this.txtContents.Location = new System.Drawing.Point(376, 69);
this.txtContents.Name = "txtContents";
this.txtContents.Size = new System.Drawing.Size(176, 21);
this.txtContents.TabIndex = 17;
this.txtContents.Text = "";
//
// label11
//
this.label11.Location = new System.Drawing.Point(296, 69);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(72, 23);
this.label11.TabIndex = 16;
this.label11.Text = "消费内容";
this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtIDCard
//
this.txtIDCard.Location = new System.Drawing.Point(376, 32);
this.txtIDCard.Name = "txtIDCard";
this.txtIDCard.Size = new System.Drawing.Size(176, 21);
this.txtIDCard.TabIndex = 15;
this.txtIDCard.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(296, 32);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 23);
this.label8.TabIndex = 14;
this.label8.Text = "身份证";
this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtName
//
this.txtName.Location = new System.Drawing.Point(96, 254);
this.txtName.Name = "txtName";
this.txtName.Size = new System.Drawing.Size(176, 21);
this.txtName.TabIndex = 13;
this.txtName.Text = "";
//
// label7
//
this.label7.Location = new System.Drawing.Point(16, 260);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(72, 23);
this.label7.TabIndex = 12;
this.label7.Text = "顾客姓名";
this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtPrice
//
this.txtPrice.Location = new System.Drawing.Point(96, 217);
this.txtPrice.Name = "txtPrice";
this.txtPrice.Size = new System.Drawing.Size(176, 21);
this.txtPrice.TabIndex = 11;
this.txtPrice.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(16, 222);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(72, 23);
this.label6.TabIndex = 10;
this.label6.Text = "客房价格";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtPosition
//
this.txtPosition.Location = new System.Drawing.Point(96, 180);
this.txtPosition.Name = "txtPosition";
this.txtPosition.Size = new System.Drawing.Size(176, 21);
this.txtPosition.TabIndex = 9;
this.txtPosition.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(16, 184);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 8;
this.label5.Text = "客房位置";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtType
//
this.txtType.Location = new System.Drawing.Point(96, 143);
this.txtType.Name = "txtType";
this.txtType.Size = new System.Drawing.Size(176, 21);
this.txtType.TabIndex = 7;
this.txtType.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(16, 146);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 23);
this.label4.TabIndex = 6;
this.label4.Text = "客房类型";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtRoomID
//
this.txtRoomID.Location = new System.Drawing.Point(96, 106);
this.txtRoomID.Name = "txtRoomID";
this.txtRoomID.Size = new System.Drawing.Size(176, 21);
this.txtRoomID.TabIndex = 5;
this.txtRoomID.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(16, 108);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 4;
this.label3.Text = "客房编号";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtInID
//
this.txtInID.Location = new System.Drawing.Point(96, 69);
this.txtInID.Name = "txtInID";
this.txtInID.Size = new System.Drawing.Size(176, 21);
this.txtInID.TabIndex = 3;
this.txtInID.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(16, 70);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 23);
this.label2.TabIndex = 2;
this.label2.Text = "入住单号";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtBillID
//
this.txtBillID.Location = new System.Drawing.Point(96, 32);
this.txtBillID.Name = "txtBillID";
this.txtBillID.Size = new System.Drawing.Size(176, 21);
this.txtBillID.TabIndex = 1;
this.txtBillID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(16, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 23);
this.label1.TabIndex = 0;
this.label1.Text = "帐单编号";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(424, 360);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 42;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(528, 360);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 43;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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("备注", "备注")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 帐单明细 WHERE (帐单编号 = @Original_帐单编号) AND (入住单号 = @Original_入住单号) AND (入住时间 = @Original_入住时间 OR @Original_入住时间 IS NULL AND 入住时间 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (消费内容 = @Original_消费内容 OR @Original_消费内容 IS NULL AND 消费内容 IS NULL) AND (消费金额 = @Original_消费金额 OR @Original_消费金额 IS NULL AND 消费金额 IS NULL) AND (结算日期 = @Original_结算日期 OR @Original_结算日期 IS NULL AND 结算日期 IS NULL) AND (身份证 = @Original_身份证 OR @Original_身份证 IS NULL AND 身份证 IS NULL) AND (顾客姓名 = @Original_顾客姓名 OR @Original_顾客姓名 IS NULL AND 顾客姓名 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐单编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐单编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住单号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住时间", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住时间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费内容", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "消费内容", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_结算日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "结算日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_顾客姓名", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "顾客姓名", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 帐单明细(帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注) VALUES (@帐单编号, @入住单号, @客房编号, @客房类型, @客房位置, @客房价格, @顾客姓名, @身份证, @消费内容, @消费金额, @入住时间, @折扣, @结算日期, @备注); SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注 FROM 帐单明细 WHERE (帐单编号 = @帐单编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐单编号", System.Data.SqlDbType.VarChar, 10, "帐单编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住单号", System.Data.SqlDbType.VarChar, 10, "入住单号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@顾客姓名", System.Data.SqlDbType.VarChar, 10, "顾客姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费内容", System.Data.SqlDbType.VarChar, 40, "消费内容"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住时间", System.Data.SqlDbType.DateTime, 8, "入住时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@结算日期", System.Data.SqlDbType.DateTime, 8, "结算日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期," +
" 备注 FROM 帐单明细";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 帐单明细 SET 帐单编号 = @帐单编号, 入住单号 = @入住单号, 客房编号 = @客房编号, 客房类型 = @客房类型, 客房位置 = @客房位置, 客房价格 = @客房价格, 顾客姓名 = @顾客姓名, 身份证 = @身份证, 消费内容 = @消费内容, 消费金额 = @消费金额, 入住时间 = @入住时间, 折扣 = @折扣, 结算日期 = @结算日期, 备注 = @备注 WHERE (帐单编号 = @Original_帐单编号) AND (入住单号 = @Original_入住单号) AND (入住时间 = @Original_入住时间 OR @Original_入住时间 IS NULL AND 入住时间 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (消费内容 = @Original_消费内容 OR @Original_消费内容 IS NULL AND 消费内容 IS NULL) AND (消费金额 = @Original_消费金额 OR @Original_消费金额 IS NULL AND 消费金额 IS NULL) AND (结算日期 = @Original_结算日期 OR @Original_结算日期 IS NULL AND 结算日期 IS NULL) AND (身份证 = @Original_身份证 OR @Original_身份证 IS NULL AND 身份证 IS NULL) AND (顾客姓名 = @Original_顾客姓名 OR @Original_顾客姓名 IS NULL AND 顾客姓名 IS NULL); SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注 FROM 帐单明细 WHERE (帐单编号 = @帐单编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐单编号", System.Data.SqlDbType.VarChar, 10, "帐单编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住单号", System.Data.SqlDbType.VarChar, 10, "入住单号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@顾客姓名", System.Data.SqlDbType.VarChar, 10, "顾客姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费内容", System.Data.SqlDbType.VarChar, 40, "消费内容"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住时间", System.Data.SqlDbType.DateTime, 8, "入住时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@结算日期", System.Data.SqlDbType.DateTime, 8, "结算日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐单编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐单编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住单号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住时间", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住时间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费内容", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "消费内容", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_结算日期", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "结算日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_顾客姓名", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "顾客姓名", System.Data.DataRowVersion.Original, null));
//
// sqlCommand1
//
this.sqlCommand1.CommandText = "dbo.[PROC_帐单明细历史]";
this.sqlCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlCommand1.Connection = this.conn;
this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐单编号", System.Data.SqlDbType.VarChar, 10));
//
// AddAccountInfoManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(656, 414);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.groupBox1);
this.MaximizeBox = false;
this.Name = "AddAccountInfoManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "结算信息添加";
this.Load += new System.EventHandler(this.AddAccountInfoManagement_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.btnCancel = new System.Windows.Forms.Button();
this.btnEnd = new System.Windows.Forms.Button();
this.btnNext = new System.Windows.Forms.Button();
this.btnBack = new System.Windows.Forms.Button();
this.btnFirst = new System.Windows.Forms.Button();
this.btnAll = new System.Windows.Forms.Button();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.textBox1 = new System.Windows.Forms.TextBox();
this.btnFind = new System.Windows.Forms.Button();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label9 = new System.Windows.Forms.Label();
this.txtPower = new System.Windows.Forms.TextBox();
this.txtGrade = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.txtPwd = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtPost = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtSection = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// label7
//
this.label7.Location = new System.Drawing.Point(577, 45);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(80, 23);
this.label7.TabIndex = 58;
this.label7.Text = "记录数：";
this.label7.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// label6
//
this.label6.Location = new System.Drawing.Point(1, 45);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(96, 23);
this.label6.TabIndex = 57;
this.label6.Text = "当前记录：";
this.label6.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(497, 37);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 56;
this.btnCancel.Text = "退出";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnEnd
//
this.btnEnd.Location = new System.Drawing.Point(417, 37);
this.btnEnd.Name = "btnEnd";
this.btnEnd.TabIndex = 55;
this.btnEnd.Text = "最后";
this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
//
// btnNext
//
this.btnNext.Location = new System.Drawing.Point(337, 37);
this.btnNext.Name = "btnNext";
this.btnNext.TabIndex = 54;
this.btnNext.Text = "下一个";
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
//
// btnBack
//
this.btnBack.Location = new System.Drawing.Point(257, 37);
this.btnBack.Name = "btnBack";
this.btnBack.TabIndex = 53;
this.btnBack.Text = "上一个";
this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(177, 37);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 52;
this.btnFirst.Text = "最前";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnAll
//
this.btnAll.Location = new System.Drawing.Point(97, 37);
this.btnAll.Name = "btnAll";
this.btnAll.TabIndex = 51;
this.btnAll.Text = "查询所有";
this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Controls.Add(this.btnFind);
this.groupBox2.Location = new System.Drawing.Point(49, 432);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(564, 64);
this.groupBox2.TabIndex = 50;
this.groupBox2.TabStop = false;
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(320, 24);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(120, 21);
this.textBox2.TabIndex = 11;
this.textBox2.Text = "";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(248, 24);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(65, 24);
this.radioButton2.TabIndex = 10;
this.radioButton2.Text = "姓名";
this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged);
//
// radioButton1
//
this.radioButton1.Location = new System.Drawing.Point(24, 24);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(64, 24);
this.radioButton1.TabIndex = 9;
this.radioButton1.Text = "编号";
this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(96, 24);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(120, 21);
this.textBox1.TabIndex = 8;
this.textBox1.Text = "";
//
// btnFind
//
this.btnFind.Location = new System.Drawing.Point(464, 24);
this.btnFind.Name = "btnFind";
this.btnFind.TabIndex = 7;
this.btnFind.Text = "查询";
this.btnFind.Click += new System.EventHandler(this.btnFind_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "管理员";
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(49, 72);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(564, 169);
this.dataGrid1.TabIndex = 49;
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.txtPower);
this.groupBox1.Controls.Add(this.txtGrade);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.txtPwd);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtPost);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtSection);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtName);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(49, 248);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(564, 177);
this.groupBox1.TabIndex = 48;
this.groupBox1.TabStop = false;
//
// label9
//
this.label9.Location = new System.Drawing.Point(24, 143);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(72, 23);
this.label9.TabIndex = 14;
this.label9.Text = "权限";
//
// txtPower
//
this.txtPower.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.权限"));
this.txtPower.Location = new System.Drawing.Point(96, 140);
this.txtPower.Name = "txtPower";
this.txtPower.ReadOnly = true;
this.txtPower.Size = new System.Drawing.Size(272, 21);
this.txtPower.TabIndex = 13;
this.txtPower.Text = "";
//
// txtGrade
//
this.txtGrade.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.等级"));
this.txtGrade.Location = new System.Drawing.Point(368, 105);
this.txtGrade.Name = "txtGrade";
this.txtGrade.ReadOnly = true;
this.txtGrade.Size = new System.Drawing.Size(176, 21);
this.txtGrade.TabIndex = 11;
this.txtGrade.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(288, 107);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(80, 23);
this.label8.TabIndex = 10;
this.label8.Text = "等级";
//
// txtPwd
//
this.txtPwd.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.密码"));
this.txtPwd.Location = new System.Drawing.Point(96, 102);
this.txtPwd.Name = "txtPwd";
this.txtPwd.ReadOnly = true;
this.txtPwd.Size = new System.Drawing.Size(168, 21);
this.txtPwd.TabIndex = 9;
this.txtPwd.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(24, 106);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 8;
this.label5.Text = "密码";
//
// txtPost
//
this.txtPost.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.职位"));
this.txtPost.Location = new System.Drawing.Point(368, 64);
this.txtPost.Name = "txtPost";
this.txtPost.ReadOnly = true;
this.txtPost.Size = new System.Drawing.Size(176, 21);
this.txtPost.TabIndex = 7;
this.txtPost.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(288, 67);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(80, 23);
this.label4.TabIndex = 6;
this.label4.Text = "职位";
//
// txtSection
//
this.txtSection.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.部门"));
this.txtSection.Location = new System.Drawing.Point(368, 25);
this.txtSection.Name = "txtSection";
this.txtSection.ReadOnly = true;
this.txtSection.Size = new System.Drawing.Size(176, 21);
this.txtSection.TabIndex = 5;
this.txtSection.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(288, 32);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80, 23);
this.label3.TabIndex = 4;
this.label3.Text = "部门";
//
// txtName
//
this.txtName.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.姓名"));
this.txtName.Location = new System.Drawing.Point(96, 63);
this.txtName.Name = "txtName";
this.txtName.ReadOnly = true;
this.txtName.Size = new System.Drawing.Size(168, 21);
this.txtName.TabIndex = 3;
this.txtName.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(24, 67);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 23);
this.label2.TabIndex = 2;
this.label2.Text = "姓名";
//
// txtID
//
this.txtID.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "管理员.编号"));
this.txtID.Location = new System.Drawing.Point(96, 24);
this.txtID.Name = "txtID";
this.txtID.ReadOnly = true;
this.txtID.Size = new System.Drawing.Size(168, 21);
this.txtID.TabIndex = 1;
this.txtID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(24, 28);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 23);
this.label1.TabIndex = 0;
this.label1.Text = "编号";
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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("权限", "权限")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 管理员 WHERE (编号 = @Original_编号) AND (姓名 = @Original_姓名) AND (密码 = @Orig" +
"inal_密码) AND (权限 = @Original_权限) AND (等级 = @Original_等级) AND (职位 = @Original_职位)" +
" AND (部门 = @Original_部门)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_密码", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "密码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_等级", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "等级", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职位", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职位", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 管理员(编号, 姓名, 密码, 部门, 职位, 等级, 权限) VALUES (@编号, @姓名, @密码, @部门, @职位, @等级," +
" @权限); SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员 WHERE (编号 = @编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 20, "编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@密码", System.Data.SqlDbType.VarChar, 20, "密码"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门", System.Data.SqlDbType.VarChar, 20, "部门"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位", System.Data.SqlDbType.VarChar, 20, "职位"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@等级", System.Data.SqlDbType.VarChar, 20, "等级"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限", System.Data.SqlDbType.VarChar, 20, "权限"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 管理员 SET 编号 = @编号, 姓名 = @姓名, 密码 = @密码, 部门 = @部门, 职位 = @职位, 等级 = @等级, 权限 = @权限 WHERE (编号 = @Original_编号) AND (姓名 = @Original_姓名) AND (密码 = @Original_密码) AND (权限 = @Original_权限) AND (等级 = @Original_等级) AND (职位 = @Original_职位) AND (部门 = @Original_部门); SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员 WHERE (编号 = @编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 20, "编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@密码", System.Data.SqlDbType.VarChar, 20, "密码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门", System.Data.SqlDbType.VarChar, 20, "部门"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位", System.Data.SqlDbType.VarChar, 20, "职位"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@等级", System.Data.SqlDbType.VarChar, 20, "等级"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限", System.Data.SqlDbType.VarChar, 20, "权限"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_密码", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "密码", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_等级", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "等级", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职位", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职位", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门", System.Data.DataRowVersion.Original, null));
//
// SelectUserManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(664, 518);
this.Controls.Add(this.label7);
this.Controls.Add(this.label6);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnEnd);
this.Controls.Add(this.btnNext);
this.Controls.Add(this.btnBack);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.btnAll);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.groupBox1);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(672, 552);
this.MinimumSize = new System.Drawing.Size(672, 552);
this.Name = "SelectUserManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "用户查询";
this.Load += new System.EventHandler(this.SelectUserManagement_Load);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.checkBox4 = new System.Windows.Forms.CheckBox();
this.checkBox3 = new System.Windows.Forms.CheckBox();
this.checkBox2 = new System.Windows.Forms.CheckBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.txtPrice = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtNum = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtArea = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtname = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.btnCancel = new System.Windows.Forms.Button();
this.btnSave = new System.Windows.Forms.Button();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox2.SuspendLayout();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.SuspendLayout();
//
// groupBox2
//
this.groupBox2.Controls.Add(this.checkBox4);
this.groupBox2.Controls.Add(this.checkBox3);
this.groupBox2.Controls.Add(this.checkBox2);
this.groupBox2.Controls.Add(this.checkBox1);
this.groupBox2.Location = new System.Drawing.Point(56, 264);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(332, 96);
this.groupBox2.TabIndex = 21;
this.groupBox2.TabStop = false;
//
// checkBox4
//
this.checkBox4.Location = new System.Drawing.Point(216, 64);
this.checkBox4.Name = "checkBox4";
this.checkBox4.TabIndex = 19;
this.checkBox4.Text = "单独卫生间";
//
// checkBox3
//
this.checkBox3.Location = new System.Drawing.Point(40, 64);
this.checkBox3.Name = "checkBox3";
this.checkBox3.TabIndex = 18;
this.checkBox3.Text = "电话";
//
// checkBox2
//
this.checkBox2.Location = new System.Drawing.Point(216, 15);
this.checkBox2.Name = "checkBox2";
this.checkBox2.TabIndex = 17;
this.checkBox2.Text = "电视机";
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(40, 15);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 16;
this.checkBox1.Text = "空调";
//
// groupBox1
//
this.groupBox1.Controls.Add(this.txtPrice);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtNum);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtArea);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtname);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(56, 16);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(332, 240);
this.groupBox1.TabIndex = 20;
this.groupBox1.TabStop = false;
//
// txtPrice
//
this.txtPrice.Location = new System.Drawing.Point(136, 199);
this.txtPrice.Name = "txtPrice";
this.txtPrice.Size = new System.Drawing.Size(168, 21);
this.txtPrice.TabIndex = 21;
this.txtPrice.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(24, 201);
this.label5.Name = "label5";
this.label5.TabIndex = 20;
this.label5.Text = "客房价格";
//
// txtNum
//
this.txtNum.Location = new System.Drawing.Point(136, 153);
this.txtNum.Name = "txtNum";
this.txtNum.Size = new System.Drawing.Size(168, 21);
this.txtNum.TabIndex = 19;
this.txtNum.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(24, 157);
this.label4.Name = "label4";
this.label4.TabIndex = 18;
this.label4.Text = "床位数量";
//
// txtArea
//
this.txtArea.Location = new System.Drawing.Point(136, 113);
this.txtArea.Name = "txtArea";
this.txtArea.Size = new System.Drawing.Size(168, 21);
this.txtArea.TabIndex = 17;
this.txtArea.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(24, 113);
this.label3.Name = "label3";
this.label3.TabIndex = 16;
this.label3.Text = "房间面积";
//
// txtname
//
this.txtname.Location = new System.Drawing.Point(136, 73);
this.txtname.Name = "txtname";
this.txtname.Size = new System.Drawing.Size(168, 21);
this.txtname.TabIndex = 15;
this.txtname.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(24, 69);
this.label2.Name = "label2";
this.label2.TabIndex = 14;
this.label2.Text = "客房类型";
//
// txtID
//
this.txtID.Location = new System.Drawing.Point(136, 25);
this.txtID.Name = "txtID";
this.txtID.Size = new System.Drawing.Size(168, 21);
this.txtID.TabIndex = 13;
this.txtID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(24, 25);
this.label1.Name = "label1";
this.label1.TabIndex = 12;
this.label1.Text = "类型编号";
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(296, 384);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 19;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(72, 384);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 18;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 客房标准信息 WHERE (类型编号 = @Original_类型编号) AND (单独卫生间 = @Original_单独卫生间 OR @Original_单独卫生间 IS NULL AND 单独卫生间 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床位数量 = @Original_床位数量 OR @Original_床位数量 IS NULL AND 床位数量 IS NULL) AND (房间面积 = @Original_房间面积 OR @Original_房间面积 IS NULL AND 房间面积 IS NULL) AND (电视机 = @Original_电视机 OR @Original_电视机 IS NULL AND 电视机 IS NULL) AND (电话 = @Original_电话 OR @Original_电话 IS NULL AND 电话 IS NULL) AND (空调 = @Original_空调 OR @Original_空调 IS NULL AND 空调 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单独卫生间", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单独卫生间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床位数量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床位数量", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电视机", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电视机", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_空调", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "空调", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 客房标准信息(类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间) VALUES (@类型编" +
"号, @客房类型, @房间面积, @床位数量, @客房价格, @空调, @电视机, @电话, @单独卫生间); SELECT 类型编号, 客房类型, 房间面积," +
" 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息 WHERE (类型编号 = @类型编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床位数量", System.Data.SqlDbType.Int, 4, "床位数量"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@空调", System.Data.SqlDbType.Bit, 1, "空调"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电视机", System.Data.SqlDbType.Bit, 1, "电视机"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.Bit, 1, "电话"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单独卫生间", System.Data.SqlDbType.Bit, 1, "单独卫生间"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 客房标准信息 SET 类型编号 = @类型编号, 客房类型 = @客房类型, 房间面积 = @房间面积, 床位数量 = @床位数量, 客房价格 = @客房价格, 空调 = @空调, 电视机 = @电视机, 电话 = @电话, 单独卫生间 = @单独卫生间 WHERE (类型编号 = @Original_类型编号) AND (单独卫生间 = @Original_单独卫生间 OR @Original_单独卫生间 IS NULL AND 单独卫生间 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床位数量 = @Original_床位数量 OR @Original_床位数量 IS NULL AND 床位数量 IS NULL) AND (房间面积 = @Original_房间面积 OR @Original_房间面积 IS NULL AND 房间面积 IS NULL) AND (电视机 = @Original_电视机 OR @Original_电视机 IS NULL AND 电视机 IS NULL) AND (电话 = @Original_电话 OR @Original_电话 IS NULL AND 电话 IS NULL) AND (空调 = @Original_空调 OR @Original_空调 IS NULL AND 空调 IS NULL); SELECT 类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息 WHERE (类型编号 = @类型编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床位数量", System.Data.SqlDbType.Int, 4, "床位数量"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@空调", System.Data.SqlDbType.Bit, 1, "空调"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电视机", System.Data.SqlDbType.Bit, 1, "电视机"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.Bit, 1, "电话"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单独卫生间", System.Data.SqlDbType.Bit, 1, "单独卫生间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单独卫生间", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单独卫生间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床位数量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床位数量", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电视机", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电视机", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_空调", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "空调", System.Data.DataRowVersion.Original, null));
//
// AddRoomStandardManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(442, 440);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnSave);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(450, 472);
this.MinimumSize = new System.Drawing.Size(450, 472);
this.Name = "AddRoomStandardManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "客房标准添加";
this.Load += new System.EventHandler(this.AddRoomStandardManagement_Load);
this.groupBox2.ResumeLayout(false);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.textBox1 = new System.Windows.Forms.TextBox();
this.btnFind = new System.Windows.Forms.Button();
this.btnCancel = new System.Windows.Forms.Button();
this.btnEnd = new System.Windows.Forms.Button();
this.btnNext = new System.Windows.Forms.Button();
this.btnBack = new System.Windows.Forms.Button();
this.btnFirst = new System.Windows.Forms.Button();
this.btnAll = new System.Windows.Forms.Button();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.txtState = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.txtSay = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.txtBedNum = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.txtNum = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtPlace = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtRoomType = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtTypeID = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtRoomID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label9 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// groupBox2
//
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Controls.Add(this.btnFind);
this.groupBox2.Location = new System.Drawing.Point(56, 399);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(576, 64);
this.groupBox2.TabIndex = 37;
this.groupBox2.TabStop = false;
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(328, 24);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(120, 21);
this.textBox2.TabIndex = 11;
this.textBox2.Text = "";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(255, 24);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(73, 24);
this.radioButton2.TabIndex = 10;
this.radioButton2.Text = "客房类型";
this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged);
//
// radioButton1
//
this.radioButton1.Location = new System.Drawing.Point(24, 24);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(73, 24);
this.radioButton1.TabIndex = 9;
this.radioButton1.Text = "客房编号";
this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(112, 24);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(120, 21);
this.textBox1.TabIndex = 8;
this.textBox1.Text = "";
//
// btnFind
//
this.btnFind.Location = new System.Drawing.Point(480, 24);
this.btnFind.Name = "btnFind";
this.btnFind.TabIndex = 7;
this.btnFind.Text = "查询";
this.btnFind.Click += new System.EventHandler(this.btnFind_Click);
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(504, 31);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 36;
this.btnCancel.Text = "退出";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnEnd
//
this.btnEnd.Location = new System.Drawing.Point(416, 31);
this.btnEnd.Name = "btnEnd";
this.btnEnd.TabIndex = 35;
this.btnEnd.Text = "最后";
this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
//
// btnNext
//
this.btnNext.Location = new System.Drawing.Point(336, 31);
this.btnNext.Name = "btnNext";
this.btnNext.TabIndex = 34;
this.btnNext.Text = "下一个";
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
//
// btnBack
//
this.btnBack.Location = new System.Drawing.Point(256, 31);
this.btnBack.Name = "btnBack";
this.btnBack.TabIndex = 33;
this.btnBack.Text = "上一个";
this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(176, 31);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 32;
this.btnFirst.Text = "最前";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnAll
//
this.btnAll.Location = new System.Drawing.Point(96, 31);
this.btnAll.Name = "btnAll";
this.btnAll.TabIndex = 31;
this.btnAll.Text = "查询所有";
this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "客房信息";
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(56, 71);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(576, 151);
this.dataGrid1.TabIndex = 30;
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// groupBox1
//
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Controls.Add(this.txtState);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.txtSay);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.txtBedNum);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.txtNum);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtPlace);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtRoomType);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtTypeID);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtRoomID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(56, 229);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(576, 168);
this.groupBox1.TabIndex = 29;
this.groupBox1.TabStop = false;
//
// checkBox1
//
this.checkBox1.AutoCheck = false;
this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.ds, "客房信息.是否可拼房"));
this.checkBox1.Location = new System.Drawing.Point(384, 120);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 33;
this.checkBox1.Text = "是否可拼房";
//
// txtState
//
this.txtState.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.状态"));
this.txtState.Location = new System.Drawing.Point(384, 80);
this.txtState.Name = "txtState";
this.txtState.ReadOnly = true;
this.txtState.Size = new System.Drawing.Size(168, 21);
this.txtState.TabIndex = 32;
this.txtState.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(296, 80);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 23);
this.label8.TabIndex = 31;
this.label8.Text = "状态";
//
// txtSay
//
this.txtSay.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.客房描述"));
this.txtSay.Location = new System.Drawing.Point(384, 48);
this.txtSay.Name = "txtSay";
this.txtSay.ReadOnly = true;
this.txtSay.Size = new System.Drawing.Size(168, 21);
this.txtSay.TabIndex = 30;
this.txtSay.Text = "";
//
// label7
//
this.label7.Location = new System.Drawing.Point(296, 48);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(72, 23);
this.label7.TabIndex = 29;
this.label7.Text = "客房描述";
//
// txtBedNum
//
this.txtBedNum.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.床数"));
this.txtBedNum.Location = new System.Drawing.Point(384, 16);
this.txtBedNum.Name = "txtBedNum";
this.txtBedNum.ReadOnly = true;
this.txtBedNum.Size = new System.Drawing.Size(168, 21);
this.txtBedNum.TabIndex = 28;
this.txtBedNum.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(296, 16);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(72, 23);
this.label6.TabIndex = 27;
this.label6.Text = "床数";
//
// txtNum
//
this.txtNum.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.额定人数"));
this.txtNum.Location = new System.Drawing.Point(104, 136);
this.txtNum.Name = "txtNum";
this.txtNum.ReadOnly = true;
this.txtNum.Size = new System.Drawing.Size(168, 21);
this.txtNum.TabIndex = 26;
this.txtNum.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(16, 136);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 25;
this.label5.Text = "额定人数";
//
// txtPlace
//
this.txtPlace.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.客房位置"));
this.txtPlace.Location = new System.Drawing.Point(104, 109);
this.txtPlace.Name = "txtPlace";
this.txtPlace.ReadOnly = true;
this.txtPlace.Size = new System.Drawing.Size(168, 21);
this.txtPlace.TabIndex = 24;
this.txtPlace.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(16, 112);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 24);
this.label4.TabIndex = 23;
this.label4.Text = "客房位置";
//
// txtRoomType
//
this.txtRoomType.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.客房类型"));
this.txtRoomType.Location = new System.Drawing.Point(104, 77);
this.txtRoomType.Name = "txtRoomType";
this.txtRoomType.ReadOnly = true;
this.txtRoomType.Size = new System.Drawing.Size(168, 21);
this.txtRoomType.TabIndex = 22;
this.txtRoomType.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(16, 80);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 24);
this.label3.TabIndex = 21;
this.label3.Text = "客房类型";
//
// txtTypeID
//
this.txtTypeID.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.类型编号"));
this.txtTypeID.Location = new System.Drawing.Point(104, 47);
this.txtTypeID.Name = "txtTypeID";
this.txtTypeID.ReadOnly = true;
this.txtTypeID.Size = new System.Drawing.Size(168, 21);
this.txtTypeID.TabIndex = 20;
this.txtTypeID.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(16, 48);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 24);
this.label2.TabIndex = 19;
this.label2.Text = "类型编号";
//
// txtRoomID
//
this.txtRoomID.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房信息.客房编号"));
this.txtRoomID.Location = new System.Drawing.Point(104, 16);
this.txtRoomID.Name = "txtRoomID";
this.txtRoomID.ReadOnly = true;
this.txtRoomID.Size = new System.Drawing.Size(168, 21);
this.txtRoomID.TabIndex = 18;
this.txtRoomID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(16, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 24);
this.label1.TabIndex = 17;
this.label1.Text = "客房编号";
//
// label9
//
this.label9.Location = new System.Drawing.Point(8, 48);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(88, 23);
this.label9.TabIndex = 38;
this.label9.Text = "当前记录：";
this.label9.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// label10
//
this.label10.Location = new System.Drawing.Point(584, 48);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(88, 23);
this.label10.TabIndex = 39;
this.label10.Text = "记录数：";
this.label10.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 客房信息 WHERE (客房编号 = @Original_客房编号) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房描述 = @Original_客房描述 OR @Original_客房描述 IS NULL AND 客房描述 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床数 = @Original_床数 OR @Original_床数 IS NULL AND 床数 IS NULL) AND (是否可拼房 = @Original_是否可拼房 OR @Original_是否可拼房 IS NULL AND 是否可拼房 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (类型编号 = @Original_类型编号) AND (额定人数 = @Original_额定人数 OR @Original_额定人数 IS NULL AND 额定人数 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床数", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 客房信息(客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房) VALUES (@客房编号" +
", @类型编号, @客房类型, @客房位置, @额定人数, @床数, @客房描述, @状态, @是否可拼房); SELECT 客房编号, 类型编号, 客房类型," +
" 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 = @客房编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 客房信息 SET 客房编号 = @客房编号, 类型编号 = @类型编号, 客房类型 = @客房类型, 客房位置 = @客房位置, 额定人数 = @额定人数, 床数 = @床数, 客房描述 = @客房描述, 状态 = @状态, 是否可拼房 = @是否可拼房 WHERE (客房编号 = @Original_客房编号) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房描述 = @Original_客房描述 OR @Original_客房描述 IS NULL AND 客房描述 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床数 = @Original_床数 OR @Original_床数 IS NULL AND 床数 IS NULL) AND (是否可拼房 = @Original_是否可拼房 OR @Original_是否可拼房 IS NULL AND 是否可拼房 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (类型编号 = @Original_类型编号) AND (额定人数 = @Original_额定人数 OR @Original_额定人数 IS NULL AND 额定人数 IS NULL); SELECT 客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 = @客房编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床数", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null));
//
// SelectRoomInfoManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(688, 494);
this.Controls.Add(this.label10);
this.Controls.Add(this.label9);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnEnd);
this.Controls.Add(this.btnNext);
this.Controls.Add(this.btnBack);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.btnAll);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.groupBox1);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(696, 528);
this.MinimumSize = new System.Drawing.Size(696, 528);
this.Name = "SelectRoomInfoManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "客房信息查询";
this.Load += new System.EventHandler(this.SelectRoomInfoManagement_Load);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.txtState = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.txtSay = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.txtBedNum = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.txtNum = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtPlace = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtRoomType = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtTypeID = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtRoomID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.btnCancel = new System.Windows.Forms.Button();
this.btnSave = new System.Windows.Forms.Button();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Controls.Add(this.txtState);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.txtSay);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.txtBedNum);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.txtNum);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtPlace);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtRoomType);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtTypeID);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtRoomID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(56, 32);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(332, 344);
this.groupBox1.TabIndex = 24;
this.groupBox1.TabStop = false;
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(184, 304);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 16;
this.checkBox1.Text = "是否可拼房";
//
// txtState
//
this.txtState.Location = new System.Drawing.Point(136, 262);
this.txtState.Name = "txtState";
this.txtState.Size = new System.Drawing.Size(176, 21);
this.txtState.TabIndex = 15;
this.txtState.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(24, 264);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(80, 23);
this.label8.TabIndex = 14;
this.label8.Text = "状态";
//
// txtSay
//
this.txtSay.Location = new System.Drawing.Point(136, 228);
this.txtSay.Name = "txtSay";
this.txtSay.Size = new System.Drawing.Size(176, 21);
this.txtSay.TabIndex = 13;
this.txtSay.Text = "";
//
// label7
//
this.label7.Location = new System.Drawing.Point(24, 232);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(80, 23);
this.label7.TabIndex = 12;
this.label7.Text = "客房描述";
//
// txtBedNum
//
this.txtBedNum.Location = new System.Drawing.Point(136, 194);
this.txtBedNum.Name = "txtBedNum";
this.txtBedNum.Size = new System.Drawing.Size(176, 21);
this.txtBedNum.TabIndex = 11;
this.txtBedNum.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(24, 200);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(80, 23);
this.label6.TabIndex = 10;
this.label6.Text = "床数";
//
// txtNum
//
this.txtNum.Location = new System.Drawing.Point(136, 160);
this.txtNum.Name = "txtNum";
this.txtNum.Size = new System.Drawing.Size(176, 21);
this.txtNum.TabIndex = 9;
this.txtNum.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(24, 166);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80, 23);
this.label5.TabIndex = 8;
this.label5.Text = "额定人数";
//
// txtPlace
//
this.txtPlace.Location = new System.Drawing.Point(136, 126);
this.txtPlace.Name = "txtPlace";
this.txtPlace.Size = new System.Drawing.Size(176, 21);
this.txtPlace.TabIndex = 7;
this.txtPlace.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(24, 131);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(80, 23);
this.label4.TabIndex = 6;
this.label4.Text = "客房位置";
//
// txtRoomType
//
this.txtRoomType.Location = new System.Drawing.Point(136, 92);
this.txtRoomType.Name = "txtRoomType";
this.txtRoomType.Size = new System.Drawing.Size(176, 21);
this.txtRoomType.TabIndex = 5;
this.txtRoomType.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(25, 98);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80, 23);
this.label3.TabIndex = 4;
this.label3.Text = "客房类型";
//
// txtTypeID
//
this.txtTypeID.Location = new System.Drawing.Point(136, 58);
this.txtTypeID.Name = "txtTypeID";
this.txtTypeID.Size = new System.Drawing.Size(176, 21);
this.txtTypeID.TabIndex = 3;
this.txtTypeID.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(24, 64);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(80, 23);
this.label2.TabIndex = 2;
this.label2.Text = "类型编号";
//
// txtRoomID
//
this.txtRoomID.Location = new System.Drawing.Point(136, 24);
this.txtRoomID.Name = "txtRoomID";
this.txtRoomID.Size = new System.Drawing.Size(176, 21);
this.txtRoomID.TabIndex = 1;
this.txtRoomID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(24, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(80, 23);
this.label1.TabIndex = 0;
this.label1.Text = "客房编号";
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(280, 408);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 23;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(72, 408);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 22;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// conn
//
this.conn.ConnectionString = "workstation id=(local);packet size=4096;integrated security=SSPI;data source=(loc" +
"al);persist security info=False;initial catalog=酒店管理系统";
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 客房信息 WHERE (客房编号 = @Original_客房编号) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房描述 = @Original_客房描述 OR @Original_客房描述 IS NULL AND 客房描述 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床数 = @Original_床数 OR @Original_床数 IS NULL AND 床数 IS NULL) AND (是否可拼房 = @Original_是否可拼房 OR @Original_是否可拼房 IS NULL AND 是否可拼房 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (类型编号 = @Original_类型编号) AND (额定人数 = @Original_额定人数 OR @Original_额定人数 IS NULL AND 额定人数 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床数", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 客房信息(客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房) VALUES (@客房编号" +
", @类型编号, @客房类型, @客房位置, @额定人数, @床数, @客房描述, @状态, @是否可拼房); SELECT 客房编号, 类型编号, 客房类型," +
" 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 = @客房编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 客房信息 SET 客房编号 = @客房编号, 类型编号 = @类型编号, 客房类型 = @客房类型, 客房位置 = @客房位置, 额定人数 = @额定人数, 床数 = @床数, 客房描述 = @客房描述, 状态 = @状态, 是否可拼房 = @是否可拼房 WHERE (客房编号 = @Original_客房编号) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房描述 = @Original_客房描述 OR @Original_客房描述 IS NULL AND 客房描述 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床数 = @Original_床数 OR @Original_床数 IS NULL AND 床数 IS NULL) AND (是否可拼房 = @Original_是否可拼房 OR @Original_是否可拼房 IS NULL AND 是否可拼房 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (类型编号 = @Original_类型编号) AND (额定人数 = @Original_额定人数 OR @Original_额定人数 IS NULL AND 额定人数 IS NULL); SELECT 客房编号, 类型编号, 客房类型, 客房位置, 额定人数, 床数, 客房描述, 状态, 是否可拼房 FROM 客房信息 WHERE (客房编号 = @客房编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@额定人数", System.Data.SqlDbType.Int, 4, "额定人数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床数", System.Data.SqlDbType.Int, 4, "床数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房描述", System.Data.SqlDbType.VarChar, 40, "客房描述"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否可拼房", System.Data.SqlDbType.Bit, 1, "是否可拼房"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房描述", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房描述", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床数", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否可拼房", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否可拼房", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_额定人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "额定人数", System.Data.DataRowVersion.Original, null));
//
// AddRoomInfoManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(442, 464);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnSave);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(450, 496);
this.MinimumSize = new System.Drawing.Size(450, 496);
this.Name = "AddRoomInfoManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "客房信息添加";
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.textBox1 = new System.Windows.Forms.TextBox();
this.btnFind = new System.Windows.Forms.Button();
this.btnCancel = new System.Windows.Forms.Button();
this.btnEnd = new System.Windows.Forms.Button();
this.btnNext = new System.Windows.Forms.Button();
this.btnBack = new System.Windows.Forms.Button();
this.btnFirst = new System.Windows.Forms.Button();
this.btnAll = new System.Windows.Forms.Button();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox4 = new System.Windows.Forms.CheckBox();
this.checkBox3 = new System.Windows.Forms.CheckBox();
this.checkBox2 = new System.Windows.Forms.CheckBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.txtPrice = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtNum = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtArea = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtname = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.btnDelete = new System.Windows.Forms.Button();
this.btnSave = new System.Windows.Forms.Button();
this.label6 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.checkBox5 = new System.Windows.Forms.CheckBox();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// groupBox2
//
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Controls.Add(this.btnFind);
this.groupBox2.Location = new System.Drawing.Point(57, 400);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(576, 64);
this.groupBox2.TabIndex = 37;
this.groupBox2.TabStop = false;
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(328, 24);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(120, 21);
this.textBox2.TabIndex = 11;
this.textBox2.Text = "";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(255, 24);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(73, 24);
this.radioButton2.TabIndex = 10;
this.radioButton2.Text = "客房类型";
this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged);
//
// radioButton1
//
this.radioButton1.Location = new System.Drawing.Point(24, 24);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(73, 24);
this.radioButton1.TabIndex = 9;
this.radioButton1.Text = "类型编号";
this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(112, 24);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(120, 21);
this.textBox1.TabIndex = 8;
this.textBox1.Text = "";
//
// btnFind
//
this.btnFind.Location = new System.Drawing.Point(480, 24);
this.btnFind.Name = "btnFind";
this.btnFind.TabIndex = 7;
this.btnFind.Text = "查询";
this.btnFind.Click += new System.EventHandler(this.btnFind_Click);
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(490, 32);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 36;
this.btnCancel.Text = "退出";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnEnd
//
this.btnEnd.Location = new System.Drawing.Point(415, 32);
this.btnEnd.Name = "btnEnd";
this.btnEnd.TabIndex = 35;
this.btnEnd.Text = "最后";
this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
//
// btnNext
//
this.btnNext.Location = new System.Drawing.Point(340, 32);
this.btnNext.Name = "btnNext";
this.btnNext.TabIndex = 34;
this.btnNext.Text = "下一个";
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
//
// btnBack
//
this.btnBack.Location = new System.Drawing.Point(265, 32);
this.btnBack.Name = "btnBack";
this.btnBack.TabIndex = 33;
this.btnBack.Text = "上一个";
this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(190, 32);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 32;
this.btnFirst.Text = "最前";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnAll
//
this.btnAll.Location = new System.Drawing.Point(115, 32);
this.btnAll.Name = "btnAll";
this.btnAll.TabIndex = 31;
this.btnAll.Text = "查询所有";
this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "客房标准信息";
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(57, 72);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(576, 150);
this.dataGrid1.TabIndex = 30;
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// groupBox1
//
this.groupBox1.Controls.Add(this.checkBox4);
this.groupBox1.Controls.Add(this.checkBox3);
this.groupBox1.Controls.Add(this.checkBox2);
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Controls.Add(this.txtPrice);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtNum);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtArea);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtname);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Enabled = false;
this.groupBox1.Location = new System.Drawing.Point(57, 256);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(576, 144);
this.groupBox1.TabIndex = 29;
this.groupBox1.TabStop = false;
//
// checkBox4
//
this.checkBox4.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.ds, "客房标准信息.单独卫生间"));
this.checkBox4.Location = new System.Drawing.Point(456, 112);
this.checkBox4.Name = "checkBox4";
this.checkBox4.TabIndex = 35;
this.checkBox4.Text = "单独卫生间";
//
// checkBox3
//
this.checkBox3.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.ds, "客房标准信息.电话"));
this.checkBox3.Location = new System.Drawing.Point(304, 112);
this.checkBox3.Name = "checkBox3";
this.checkBox3.TabIndex = 34;
this.checkBox3.Text = "电话";
//
// checkBox2
//
this.checkBox2.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.ds, "客房标准信息.电视机"));
this.checkBox2.Location = new System.Drawing.Point(456, 88);
this.checkBox2.Name = "checkBox2";
this.checkBox2.TabIndex = 33;
this.checkBox2.Text = "电视机";
//
// checkBox1
//
this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.ds, "客房标准信息.空调"));
this.checkBox1.Location = new System.Drawing.Point(304, 88);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 32;
this.checkBox1.Text = "空调";
//
// txtPrice
//
this.txtPrice.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房标准信息.客房价格"));
this.txtPrice.Location = new System.Drawing.Point(400, 62);
this.txtPrice.Name = "txtPrice";
this.txtPrice.Size = new System.Drawing.Size(152, 21);
this.txtPrice.TabIndex = 31;
this.txtPrice.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(288, 62);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(104, 23);
this.label5.TabIndex = 30;
this.label5.Text = "客房价格";
//
// txtNum
//
this.txtNum.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房标准信息.床位数量"));
this.txtNum.Location = new System.Drawing.Point(400, 23);
this.txtNum.Name = "txtNum";
this.txtNum.Size = new System.Drawing.Size(152, 21);
this.txtNum.TabIndex = 29;
this.txtNum.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(288, 25);
this.label4.Name = "label4";
this.label4.TabIndex = 28;
this.label4.Text = "床位数量";
//
// txtArea
//
this.txtArea.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房标准信息.客房类型"));
this.txtArea.Location = new System.Drawing.Point(120, 64);
this.txtArea.Name = "txtArea";
this.txtArea.Size = new System.Drawing.Size(152, 21);
this.txtArea.TabIndex = 27;
this.txtArea.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(8, 106);
this.label3.Name = "label3";
this.label3.TabIndex = 26;
this.label3.Text = "房间面积";
//
// txtname
//
this.txtname.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房标准信息.房间面积"));
this.txtname.Location = new System.Drawing.Point(120, 104);
this.txtname.Name = "txtname";
this.txtname.Size = new System.Drawing.Size(152, 21);
this.txtname.TabIndex = 25;
this.txtname.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 66);
this.label2.Name = "label2";
this.label2.TabIndex = 24;
this.label2.Text = "客房类型";
//
// txtID
//
this.txtID.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.ds, "客房标准信息.类型编号"));
this.txtID.Location = new System.Drawing.Point(120, 24);
this.txtID.Name = "txtID";
this.txtID.Size = new System.Drawing.Size(152, 21);
this.txtID.TabIndex = 23;
this.txtID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(100, 24);
this.label1.TabIndex = 22;
this.label1.Text = "类型编号";
//
// conn
//
this.conn.ConnectionString = Config.Settings.ConnStr;
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 客房标准信息 WHERE (类型编号 = @Original_类型编号) AND (单独卫生间 = @Original_单独卫生间 OR @Original_单独卫生间 IS NULL AND 单独卫生间 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床位数量 = @Original_床位数量 OR @Original_床位数量 IS NULL AND 床位数量 IS NULL) AND (房间面积 = @Original_房间面积 OR @Original_房间面积 IS NULL AND 房间面积 IS NULL) AND (电视机 = @Original_电视机 OR @Original_电视机 IS NULL AND 电视机 IS NULL) AND (电话 = @Original_电话 OR @Original_电话 IS NULL AND 电话 IS NULL) AND (空调 = @Original_空调 OR @Original_空调 IS NULL AND 空调 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单独卫生间", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单独卫生间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床位数量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床位数量", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电视机", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电视机", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_空调", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "空调", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 客房标准信息(类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间) VALUES (@类型编" +
"号, @客房类型, @房间面积, @床位数量, @客房价格, @空调, @电视机, @电话, @单独卫生间); SELECT 类型编号, 客房类型, 房间面积," +
" 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息 WHERE (类型编号 = @类型编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床位数量", System.Data.SqlDbType.Int, 4, "床位数量"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@空调", System.Data.SqlDbType.Bit, 1, "空调"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电视机", System.Data.SqlDbType.Bit, 1, "电视机"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.Bit, 1, "电话"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单独卫生间", System.Data.SqlDbType.Bit, 1, "单独卫生间"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 客房标准信息 SET 类型编号 = @类型编号, 客房类型 = @客房类型, 房间面积 = @房间面积, 床位数量 = @床位数量, 客房价格 = @客房价格, 空调 = @空调, 电视机 = @电视机, 电话 = @电话, 单独卫生间 = @单独卫生间 WHERE (类型编号 = @Original_类型编号) AND (单独卫生间 = @Original_单独卫生间 OR @Original_单独卫生间 IS NULL AND 单独卫生间 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (床位数量 = @Original_床位数量 OR @Original_床位数量 IS NULL AND 床位数量 IS NULL) AND (房间面积 = @Original_房间面积 OR @Original_房间面积 IS NULL AND 房间面积 IS NULL) AND (电视机 = @Original_电视机 OR @Original_电视机 IS NULL AND 电视机 IS NULL) AND (电话 = @Original_电话 OR @Original_电话 IS NULL AND 电话 IS NULL) AND (空调 = @Original_空调 OR @Original_空调 IS NULL AND 空调 IS NULL); SELECT 类型编号, 客房类型, 房间面积, 床位数量, 客房价格, 空调, 电视机, 电话, 单独卫生间 FROM 客房标准信息 WHERE (类型编号 = @类型编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 10, "类型编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 10, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@床位数量", System.Data.SqlDbType.Int, 4, "床位数量"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@空调", System.Data.SqlDbType.Bit, 1, "空调"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电视机", System.Data.SqlDbType.Bit, 1, "电视机"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.Bit, 1, "电话"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单独卫生间", System.Data.SqlDbType.Bit, 1, "单独卫生间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单独卫生间", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单独卫生间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_床位数量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "床位数量", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_房间面积", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "房间面积", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电视机", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电视机", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_空调", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "空调", System.Data.DataRowVersion.Original, null));
//
// btnDelete
//
this.btnDelete.Location = new System.Drawing.Point(544, 232);
this.btnDelete.Name = "btnDelete";
this.btnDelete.TabIndex = 38;
this.btnDelete.Text = "删除";
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
//
// btnSave
//
this.btnSave.Enabled = false;
this.btnSave.Location = new System.Drawing.Point(120, 232);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 39;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// label6
//
this.label6.Location = new System.Drawing.Point(8, 48);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(104, 23);
this.label6.TabIndex = 42;
this.label6.Text = "当前记录：";
this.label6.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// label7
//
this.label7.Location = new System.Drawing.Point(568, 47);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(104, 23);
this.label7.TabIndex = 43;
this.label7.Text = "记录数：";
this.label7.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// checkBox5
//
this.checkBox5.Location = new System.Drawing.Point(56, 232);
this.checkBox5.Name = "checkBox5";
this.checkBox5.Size = new System.Drawing.Size(56, 24);
this.checkBox5.TabIndex = 44;
this.checkBox5.Text = "修改";
this.checkBox5.CheckedChanged += new System.EventHandler(this.checkBox5_CheckedChanged);
//
// ChangeRoomStandardManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(692, 486);
this.Controls.Add(this.checkBox5);
this.Controls.Add(this.label7);
this.Controls.Add(this.label6);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.btnDelete);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnEnd);
this.Controls.Add(this.btnNext);
this.Controls.Add(this.btnBack);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.btnAll);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.groupBox1);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(700, 520);
this.MinimumSize = new System.Drawing.Size(700, 520);
this.Name = "ChangeRoomStandardManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "客房标准修改";
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label9 = new System.Windows.Forms.Label();
this.txtPower = new System.Windows.Forms.TextBox();
this.txtGrade = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.txtPwd = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txtPost = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.txtSection = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.txtName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.btnSave = new System.Windows.Forms.Button();
this.btnCancel = new System.Windows.Forms.Button();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.txtPower);
this.groupBox1.Controls.Add(this.txtGrade);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.txtPwd);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.txtPost);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.txtSection);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.txtName);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtID);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(40, 24);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(328, 304);
this.groupBox1.TabIndex = 49;
this.groupBox1.TabStop = false;
//
// label9
//
this.label9.Location = new System.Drawing.Point(24, 260);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(72, 23);
this.label9.TabIndex = 14;
this.label9.Text = "权限";
//
// txtPower
//
this.txtPower.Location = new System.Drawing.Point(96, 254);
this.txtPower.Name = "txtPower";
this.txtPower.Size = new System.Drawing.Size(200, 21);
this.txtPower.TabIndex = 13;
this.txtPower.Text = "";
//
// txtGrade
//
this.txtGrade.Location = new System.Drawing.Point(96, 217);
this.txtGrade.Name = "txtGrade";
this.txtGrade.Size = new System.Drawing.Size(200, 21);
this.txtGrade.TabIndex = 11;
this.txtGrade.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(24, 222);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 23);
this.label8.TabIndex = 10;
this.label8.Text = "等级";
//
// txtPwd
//
this.txtPwd.Location = new System.Drawing.Point(96, 106);
this.txtPwd.Name = "txtPwd";
this.txtPwd.Size = new System.Drawing.Size(200, 21);
this.txtPwd.TabIndex = 9;
this.txtPwd.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(24, 108);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 8;
this.label5.Text = "密码";
//
// txtPost
//
this.txtPost.Location = new System.Drawing.Point(96, 180);
this.txtPost.Name = "txtPost";
this.txtPost.Size = new System.Drawing.Size(200, 21);
this.txtPost.TabIndex = 7;
this.txtPost.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(24, 184);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 23);
this.label4.TabIndex = 6;
this.label4.Text = "职位";
//
// txtSection
//
this.txtSection.Location = new System.Drawing.Point(96, 143);
this.txtSection.Name = "txtSection";
this.txtSection.Size = new System.Drawing.Size(200, 21);
this.txtSection.TabIndex = 5;
this.txtSection.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(24, 146);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 4;
this.label3.Text = "部门";
//
// txtName
//
this.txtName.Location = new System.Drawing.Point(96, 69);
this.txtName.Name = "txtName";
this.txtName.Size = new System.Drawing.Size(200, 21);
this.txtName.TabIndex = 3;
this.txtName.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(24, 70);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 23);
this.label2.TabIndex = 2;
this.label2.Text = "姓名";
//
// txtID
//
this.txtID.Location = new System.Drawing.Point(96, 32);
this.txtID.Name = "txtID";
this.txtID.Size = new System.Drawing.Size(200, 21);
this.txtID.TabIndex = 1;
this.txtID.Text = "";
//
// label1
//
this.label1.Location = new System.Drawing.Point(24, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 23);
this.label1.TabIndex = 0;
this.label1.Text = "编号";
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(80, 360);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 50;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(248, 360);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 51;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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("权限", "权限")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 管理员 WHERE (编号 = @Original_编号) AND (姓名 = @Original_姓名) AND (密码 = @Orig" +
"inal_密码) AND (权限 = @Original_权限) AND (等级 = @Original_等级) AND (职位 = @Original_职位)" +
" AND (部门 = @Original_部门)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_密码", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "密码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_等级", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "等级", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职位", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职位", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 管理员(编号, 姓名, 密码, 部门, 职位, 等级, 权限) VALUES (@编号, @姓名, @密码, @部门, @职位, @等级," +
" @权限); SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员 WHERE (编号 = @编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 20, "编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@密码", System.Data.SqlDbType.VarChar, 20, "密码"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门", System.Data.SqlDbType.VarChar, 20, "部门"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位", System.Data.SqlDbType.VarChar, 20, "职位"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@等级", System.Data.SqlDbType.VarChar, 20, "等级"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限", System.Data.SqlDbType.VarChar, 20, "权限"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 管理员 SET 编号 = @编号, 姓名 = @姓名, 密码 = @密码, 部门 = @部门, 职位 = @职位, 等级 = @等级, 权限 = @权限 WHERE (编号 = @Original_编号) AND (姓名 = @Original_姓名) AND (密码 = @Original_密码) AND (权限 = @Original_权限) AND (等级 = @Original_等级) AND (职位 = @Original_职位) AND (部门 = @Original_部门); SELECT 编号, 姓名, 密码, 部门, 职位, 等级, 权限 FROM 管理员 WHERE (编号 = @编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 20, "编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@密码", System.Data.SqlDbType.VarChar, 20, "密码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门", System.Data.SqlDbType.VarChar, 20, "部门"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位", System.Data.SqlDbType.VarChar, 20, "职位"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@等级", System.Data.SqlDbType.VarChar, 20, "等级"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限", System.Data.SqlDbType.VarChar, 20, "权限"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_密码", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "密码", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_等级", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "等级", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职位", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职位", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门", System.Data.DataRowVersion.Original, null));
//
// AddUserManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(408, 418);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.groupBox1);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(416, 450);
this.MinimumSize = new System.Drawing.Size(416, 450);
this.Name = "AddUserManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "用户添加";
this.Load += new System.EventHandler(this.AddUserManagement_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.btnFind = new System.Windows.Forms.Button();
this.textBox2 = new System.Windows.Forms.TextBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label24 = new System.Windows.Forms.Label();
this.label23 = new System.Windows.Forms.Label();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.btnCancel = new System.Windows.Forms.Button();
this.btnEnd = new System.Windows.Forms.Button();
this.btnNext = new System.Windows.Forms.Button();
this.btnBack = new System.Windows.Forms.Button();
this.btnFirst = new System.Windows.Forms.Button();
this.btnAll = new System.Windows.Forms.Button();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.SuspendLayout();
//
// groupBox2
//
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.btnFind);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Location = new System.Drawing.Point(16, 416);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(712, 64);
this.groupBox2.TabIndex = 87;
this.groupBox2.TabStop = false;
//
// radioButton1
//
this.radioButton1.Location = new System.Drawing.Point(16, 27);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(80, 24);
this.radioButton1.TabIndex = 5;
this.radioButton1.Text = "帐单编号";
this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);
//
// btnFind
//
this.btnFind.Location = new System.Drawing.Point(608, 27);
this.btnFind.Name = "btnFind";
this.btnFind.TabIndex = 4;
this.btnFind.Text = "查询";
this.btnFind.Click += new System.EventHandler(this.btnFind_Click);
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(400, 27);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(176, 21);
this.textBox2.TabIndex = 3;
this.textBox2.Text = "";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(320, 27);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(72, 24);
this.radioButton2.TabIndex = 2;
this.radioButton2.Text = "客房编号";
this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged);
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(104, 27);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(176, 21);
this.textBox1.TabIndex = 1;
this.textBox1.Text = "";
//
// label24
//
this.label24.Location = new System.Drawing.Point(624, 48);
this.label24.Name = "label24";
this.label24.TabIndex = 86;
this.label24.Text = "记录数：";
this.label24.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// label23
//
this.label23.Location = new System.Drawing.Point(16, 48);
this.label23.Name = "label23";
this.label23.TabIndex = 85;
this.label23.Text = "当前记录：";
this.label23.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// dataGrid1
//
this.dataGrid1.DataMember = "帐单明细历史";
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(16, 72);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(712, 328);
this.dataGrid1.TabIndex = 84;
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(536, 32);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 83;
this.btnCancel.Text = "退出";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnEnd
//
this.btnEnd.Location = new System.Drawing.Point(456, 32);
this.btnEnd.Name = "btnEnd";
this.btnEnd.TabIndex = 82;
this.btnEnd.Text = "最后";
this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
//
// btnNext
//
this.btnNext.Location = new System.Drawing.Point(376, 32);
this.btnNext.Name = "btnNext";
this.btnNext.TabIndex = 81;
this.btnNext.Text = "下一个";
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
//
// btnBack
//
this.btnBack.Location = new System.Drawing.Point(288, 32);
this.btnBack.Name = "btnBack";
this.btnBack.TabIndex = 80;
this.btnBack.Text = "上一个";
this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(208, 32);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 79;
this.btnFirst.Text = "最前";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnAll
//
this.btnAll.Location = new System.Drawing.Point(128, 32);
this.btnAll.Name = "btnAll";
this.btnAll.TabIndex = 78;
this.btnAll.Text = "查询所有";
this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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("备注", "备注")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 帐单明细历史 WHERE (帐单编号 = @Original_帐单编号) AND (入住单号 = @Original_入住单号) AND (入住时间 = @Original_入住时间 OR @Original_入住时间 IS NULL AND 入住时间 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (消费内容 = @Original_消费内容 OR @Original_消费内容 IS NULL AND 消费内容 IS NULL) AND (消费金额 = @Original_消费金额 OR @Original_消费金额 IS NULL AND 消费金额 IS NULL) AND (结算日期 = @Original_结算日期 OR @Original_结算日期 IS NULL AND 结算日期 IS NULL) AND (身份证 = @Original_身份证 OR @Original_身份证 IS NULL AND 身份证 IS NULL) AND (顾客姓名 = @Original_顾客姓名 OR @Original_顾客姓名 IS NULL AND 顾客姓名 IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐单编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐单编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住单号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住时间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费内容", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "消费内容", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_结算日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "结算日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_顾客姓名", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "顾客姓名", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 帐单明细历史(帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注) VALUES (@帐单编号, @入住单号, @客房编号, @客房类型, @客房位置, @客房价格, @顾客姓名, @身份证, @消费内容, @消费金额, @入住时间, @折扣, @结算日期, @备注); SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注 FROM 帐单明细历史 WHERE (帐单编号 = @帐单编号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐单编号", System.Data.SqlDbType.VarChar, 10, "帐单编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住单号", System.Data.SqlDbType.VarChar, 10, "入住单号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@顾客姓名", System.Data.SqlDbType.VarChar, 10, "顾客姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费内容", System.Data.SqlDbType.VarChar, 40, "消费内容"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住时间", System.Data.SqlDbType.DateTime, 4, "入住时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@结算日期", System.Data.SqlDbType.DateTime, 4, "结算日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期," +
" 备注 FROM 帐单明细历史";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 帐单明细历史 SET 帐单编号 = @帐单编号, 入住单号 = @入住单号, 客房编号 = @客房编号, 客房类型 = @客房类型, 客房位置 = @客房位置, 客房价格 = @客房价格, 顾客姓名 = @顾客姓名, 身份证 = @身份证, 消费内容 = @消费内容, 消费金额 = @消费金额, 入住时间 = @入住时间, 折扣 = @折扣, 结算日期 = @结算日期, 备注 = @备注 WHERE (帐单编号 = @Original_帐单编号) AND (入住单号 = @Original_入住单号) AND (入住时间 = @Original_入住时间 OR @Original_入住时间 IS NULL AND 入住时间 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (消费内容 = @Original_消费内容 OR @Original_消费内容 IS NULL AND 消费内容 IS NULL) AND (消费金额 = @Original_消费金额 OR @Original_消费金额 IS NULL AND 消费金额 IS NULL) AND (结算日期 = @Original_结算日期 OR @Original_结算日期 IS NULL AND 结算日期 IS NULL) AND (身份证 = @Original_身份证 OR @Original_身份证 IS NULL AND 身份证 IS NULL) AND (顾客姓名 = @Original_顾客姓名 OR @Original_顾客姓名 IS NULL AND 顾客姓名 IS NULL); SELECT 帐单编号, 入住单号, 客房编号, 客房类型, 客房位置, 客房价格, 顾客姓名, 身份证, 消费内容, 消费金额, 入住时间, 折扣, 结算日期, 备注 FROM 帐单明细历史 WHERE (帐单编号 = @帐单编号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐单编号", System.Data.SqlDbType.VarChar, 10, "帐单编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住单号", System.Data.SqlDbType.VarChar, 10, "入住单号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@顾客姓名", System.Data.SqlDbType.VarChar, 10, "顾客姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费内容", System.Data.SqlDbType.VarChar, 40, "消费内容"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住时间", System.Data.SqlDbType.DateTime, 4, "入住时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@结算日期", System.Data.SqlDbType.DateTime, 4, "结算日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐单编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐单编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住单号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住时间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费内容", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "消费内容", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_消费金额", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "消费金额", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_结算日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "结算日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_顾客姓名", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "顾客姓名", System.Data.DataRowVersion.Original, null));
//
// BillHistoryManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(744, 502);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.label24);
this.Controls.Add(this.label23);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnEnd);
this.Controls.Add(this.btnNext);
this.Controls.Add(this.btnBack);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.btnAll);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(752, 536);
this.MinimumSize = new System.Drawing.Size(752, 536);
this.Name = "BillHistoryManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "帐单明细历史查询";
this.Load += new System.EventHandler(this.BillHistoryManagement_Load);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.label24 = new System.Windows.Forms.Label();
this.label23 = new System.Windows.Forms.Label();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.ds = new HotelManagementSystem.Data.HotelDataSet();
this.btnCancel = new System.Windows.Forms.Button();
this.btnEnd = new System.Windows.Forms.Button();
this.btnNext = new System.Windows.Forms.Button();
this.btnBack = new System.Windows.Forms.Button();
this.btnFirst = new System.Windows.Forms.Button();
this.btnAll = new System.Windows.Forms.Button();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.btnFind = new System.Windows.Forms.Button();
this.textBox2 = new System.Windows.Forms.TextBox();
this.radioButton2 = new System.Windows.Forms.RadioButton();
this.textBox1 = new System.Windows.Forms.TextBox();
this.conn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
this.groupBox2.SuspendLayout();
this.SuspendLayout();
//
// label24
//
this.label24.Location = new System.Drawing.Point(626, 40);
this.label24.Name = "label24";
this.label24.TabIndex = 66;
this.label24.Text = "记录数：";
this.label24.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// label23
//
this.label23.Location = new System.Drawing.Point(18, 40);
this.label23.Name = "label23";
this.label23.TabIndex = 65;
this.label23.Text = "当前记录：";
this.label23.TextAlign = System.Drawing.ContentAlignment.BottomLeft;
//
// dataGrid1
//
this.dataGrid1.DataMember = "预订单历史";
this.dataGrid1.DataSource = this.ds;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(16, 64);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(712, 328);
this.dataGrid1.TabIndex = 64;
//
// ds
//
this.ds.DataSetName = "HotelDataSet";
this.ds.Locale = new System.Globalization.CultureInfo("en-US");
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(535, 24);
this.btnCancel.Name = "btnCancel";
this.btnCancel.TabIndex = 63;
this.btnCancel.Text = "退出";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnEnd
//
this.btnEnd.Location = new System.Drawing.Point(454, 24);
this.btnEnd.Name = "btnEnd";
this.btnEnd.TabIndex = 62;
this.btnEnd.Text = "最后";
this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
//
// btnNext
//
this.btnNext.Location = new System.Drawing.Point(373, 24);
this.btnNext.Name = "btnNext";
this.btnNext.TabIndex = 61;
this.btnNext.Text = "下一个";
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
//
// btnBack
//
this.btnBack.Location = new System.Drawing.Point(292, 24);
this.btnBack.Name = "btnBack";
this.btnBack.TabIndex = 60;
this.btnBack.Text = "上一个";
this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(211, 24);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 59;
this.btnFirst.Text = "最前";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnAll
//
this.btnAll.Location = new System.Drawing.Point(130, 24);
this.btnAll.Name = "btnAll";
this.btnAll.TabIndex = 58;
this.btnAll.Text = "查询所有";
this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.btnFind);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Location = new System.Drawing.Point(16, 408);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(712, 64);
this.groupBox2.TabIndex = 67;
this.groupBox2.TabStop = false;
//
// radioButton1
//
this.radioButton1.Location = new System.Drawing.Point(16, 27);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(80, 24);
this.radioButton1.TabIndex = 5;
this.radioButton1.Text = "预订单号";
this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);
//
// btnFind
//
this.btnFind.Location = new System.Drawing.Point(608, 27);
this.btnFind.Name = "btnFind";
this.btnFind.TabIndex = 4;
this.btnFind.Text = "查询";
this.btnFind.Click += new System.EventHandler(this.btnFind_Click);
//
// textBox2
//
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(400, 27);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(176, 21);
this.textBox2.TabIndex = 3;
this.textBox2.Text = "";
//
// radioButton2
//
this.radioButton2.Location = new System.Drawing.Point(320, 27);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(72, 24);
this.radioButton2.TabIndex = 2;
this.radioButton2.Text = "客房编号";
this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton2_CheckedChanged);
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(104, 27);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(176, 21);
this.textBox1.TabIndex = 1;
this.textBox1.Text = "";
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.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("业务员", "业务员")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 预订单历史 WHERE (预订单号 = @Original_预订单号) AND (业务员 = @Original_业务员 OR @Orig" +
"inal_业务员 IS NULL AND 业务员 IS NULL) AND (会员编号 = @Original_会员编号 OR @Original_会员编号 I" +
"S NULL AND 会员编号 IS NULL) AND (入住人数 = @Original_入住人数 OR @Original_入住人数 IS NULL AN" +
"D 入住人数 IS NULL) AND (入住价格 = @Original_入住价格 OR @Original_入住价格 IS NULL AND 入住价格 IS" +
" NULL) AND (加床价格 = @Original_加床价格 OR @Original_加床价格 IS NULL AND 加床价格 IS NULL) AN" +
"D (单据状态 = @Original_单据状态 OR @Original_单据状态 IS NULL AND 单据状态 IS NULL) AND (备注 = @" +
"Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 O" +
"R @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Origin" +
"al_客房位置 IS NULL AND 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 I" +
"S NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @" +
"Original_折扣 IS NULL AND 折扣 IS NULL) AND (折扣原因 = @Original_折扣原因 OR @Original_折扣原因" +
" IS NULL AND 折扣原因 IS NULL) AND (抵店时间 = @Original_抵店时间 OR @Original_抵店时间 IS NULL " +
"AND 抵店时间 IS NULL) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS N" +
"ULL) AND (是否加床 = @Original_是否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NULL) AND " +
"(离店时间 = @Original_离店时间 OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND (联系电话 = @" +
"Original_联系电话 OR @Original_联系电话 IS NULL AND 联系电话 IS NULL) AND (身份证 = @Original_身" +
"份证 OR @Original_身份证 IS NULL AND 身份证 IS NULL) AND (预收款 = @Original_预收款 OR @Origin" +
"al_预收款 IS NULL AND 预收款 IS NULL) AND (预订人 = @Original_预订人 OR @Original_预订人 IS NUL" +
"L AND 预订人 IS NULL) AND (预订公司 = @Original_预订公司 OR @Original_预订公司 IS NULL AND 预订公司" +
" IS NULL)";
this.sqlDeleteCommand1.Connection = this.conn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订单号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_业务员", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "业务员", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_会员编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "会员编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住人数", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "入住价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_加床价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "加床价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单据状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单据状态", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣原因", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣原因", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_抵店时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "抵店时间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_操作员", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "操作员", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否加床", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否加床", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_离店时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "离店时间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系电话", System.Data.SqlDbType.VarChar, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "联系电话", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预收款", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "预收款", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订人", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订人", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订公司", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订公司", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 预订单历史(预订单号, 会员编号, 客房编号, 客房类型, 客房位置, 抵店时间, 离店时间, 单据状态, 入住人数, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预订人, 身份证, 预订公司, 联系电话, 备注, 操作员, 业务员) VALUES (@预订单号, @会员编号, @客房编号, @客房类型, @客房位置, @抵店时间, @离店时间, @单据状态, @入住人数, @客房价格, @入住价格, @折扣, @折扣原因, @是否加床, @加床价格, @预收款, @预订人, @身份证, @预订公司, @联系电话, @备注, @操作员, @业务员); SELECT 预订单号, 会员编号, 客房编号, 客房类型, 客房位置, 抵店时间, 离店时间, 单据状态, 入住人数, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预订人, 身份证, 预订公司, 联系电话, 备注, 操作员, 业务员 FROM 预订单历史 WHERE (预订单号 = @预订单号)";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订单号", System.Data.SqlDbType.VarChar, 10, "预订单号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@会员编号", System.Data.SqlDbType.VarChar, 10, "会员编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@抵店时间", System.Data.SqlDbType.DateTime, 4, "抵店时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@离店时间", System.Data.SqlDbType.DateTime, 4, "离店时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单据状态", System.Data.SqlDbType.VarChar, 10, "单据状态"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住人数", System.Data.SqlDbType.Int, 4, "入住人数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "入住价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣原因", System.Data.SqlDbType.VarChar, 40, "折扣原因"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否加床", System.Data.SqlDbType.Bit, 1, "是否加床"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@加床价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "加床价格", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预收款", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "预收款", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订人", System.Data.SqlDbType.VarChar, 10, "预订人"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订公司", System.Data.SqlDbType.VarChar, 40, "预订公司"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系电话", System.Data.SqlDbType.VarChar, 13, "联系电话"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 10, "操作员"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@业务员", System.Data.SqlDbType.VarChar, 10, "业务员"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 预订单号, 会员编号, 客房编号, 客房类型, 客房位置, 抵店时间, 离店时间, 单据状态, 入住人数, 客房价格, 入住价格, 折扣, 折扣原因" +
", 是否加床, 加床价格, 预收款, 预订人, 身份证, 预订公司, 联系电话, 备注, 操作员, 业务员 FROM 预订单历史";
this.sqlSelectCommand1.Connection = this.conn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 预订单历史 SET 预订单号 = @预订单号, 会员编号 = @会员编号, 客房编号 = @客房编号, 客房类型 = @客房类型, 客房位置 = @" +
"客房位置, 抵店时间 = @抵店时间, 离店时间 = @离店时间, 单据状态 = @单据状态, 入住人数 = @入住人数, 客房价格 = @客房价格, 入住价格" +
" = @入住价格, 折扣 = @折扣, 折扣原因 = @折扣原因, 是否加床 = @是否加床, 加床价格 = @加床价格, 预收款 = @预收款, 预订人 = " +
"@预订人, 身份证 = @身份证, 预订公司 = @预订公司, 联系电话 = @联系电话, 备注 = @备注, 操作员 = @操作员, 业务员 = @业务员 W" +
"HERE (预订单号 = @Original_预订单号) AND (业务员 = @Original_业务员 OR @Original_业务员 IS NULL A" +
"ND 业务员 IS NULL) AND (会员编号 = @Original_会员编号 OR @Original_会员编号 IS NULL AND 会员编号 IS" +
" NULL) AND (入住人数 = @Original_入住人数 OR @Original_入住人数 IS NULL AND 入住人数 IS NULL) AN" +
"D (入住价格 = @Original_入住价格 OR @Original_入住价格 IS NULL AND 入住价格 IS NULL) AND (加床价格 =" +
" @Original_加床价格 OR @Original_加床价格 IS NULL AND 加床价格 IS NULL) AND (单据状态 = @Origina" +
"l_单据状态 OR @Original_单据状态 IS NULL AND 单据状态 IS NULL) AND (备注 = @Original_备注 OR @Or" +
"iginal_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 I" +
"S NULL AND 客房价格 IS NULL) AND (客房位置 = @Original_客房位置 OR @Original_客房位置 IS NULL AN" +
"D 客房位置 IS NULL) AND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS" +
" NULL) AND (客房编号 = @Original_客房编号) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NUL" +
"L AND 折扣 IS NULL) AND (折扣原因 = @Original_折扣原因 OR @Original_折扣原因 IS NULL AND 折扣原因 " +
"IS NULL) AND (抵店时间 = @Original_抵店时间 OR @Original_抵店时间 IS NULL AND 抵店时间 IS NULL) " +
"AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (是否加床 = @" +
"Original_是否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NULL) AND (离店时间 = @Original_" +
"离店时间 OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND (联系电话 = @Original_联系电话 OR @" +
"Original_联系电话 IS NULL AND 联系电话 IS NULL) AND (身份证 = @Original_身份证 OR @Original_身份" +
"证 IS NULL AND 身份证 IS NULL) AND (预收款 = @Original_预收款 OR @Original_预收款 IS NULL AND" +
" 预收款 IS NULL) AND (预订人 = @Original_预订人 OR @Original_预订人 IS NULL AND 预订人 IS NULL)" +
" AND (预订公司 = @Original_预订公司 OR @Original_预订公司 IS NULL AND 预订公司 IS NULL); SELECT " +
"预订单号, 会员编号, 客房编号, 客房类型, 客房位置, 抵店时间, 离店时间, 单据状态, 入住人数, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床" +
", 加床价格, 预收款, 预订人, 身份证, 预订公司, 联系电话, 备注, 操作员, 业务员 FROM 预订单历史 WHERE (预订单号 = @预订单号)";
this.sqlUpdateCommand1.Connection = this.conn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订单号", System.Data.SqlDbType.VarChar, 10, "预订单号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@会员编号", System.Data.SqlDbType.VarChar, 10, "会员编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 10, "客房编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 20, "客房类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房位置", System.Data.SqlDbType.VarChar, 10, "客房位置"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@抵店时间", System.Data.SqlDbType.DateTime, 4, "抵店时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@离店时间", System.Data.SqlDbType.DateTime, 4, "离店时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单据状态", System.Data.SqlDbType.VarChar, 10, "单据状态"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住人数", System.Data.SqlDbType.Int, 4, "入住人数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "入住价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Float, 8, "折扣"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣原因", System.Data.SqlDbType.VarChar, 40, "折扣原因"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否加床", System.Data.SqlDbType.Bit, 1, "是否加床"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@加床价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "加床价格", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预收款", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "预收款", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订人", System.Data.SqlDbType.VarChar, 10, "预订人"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证", System.Data.SqlDbType.VarChar, 20, "身份证"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预订公司", System.Data.SqlDbType.VarChar, 40, "预订公司"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系电话", System.Data.SqlDbType.VarChar, 13, "联系电话"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 40, "备注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 10, "操作员"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@业务员", System.Data.SqlDbType.VarChar, 10, "业务员"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订单号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订单号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_业务员", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "业务员", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_会员编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "会员编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住人数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入住人数", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入住价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "入住价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_加床价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "加床价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单据状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单据状态", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房价格", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "客房价格", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房位置", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房位置", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房类型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_客房编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "客房编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折扣原因", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折扣原因", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_抵店时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "抵店时间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_操作员", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "操作员", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否加床", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否加床", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_离店时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "离店时间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系电话", System.Data.SqlDbType.VarChar, 13, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "联系电话", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预收款", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "预收款", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订人", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订人", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_预订公司", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预订公司", System.Data.DataRowVersion.Original, null));
//
// OrderHistoryManagement
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(744, 494);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.label24);
this.Controls.Add(this.label23);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.btnEnd);
this.Controls.Add(this.btnNext);
this.Controls.Add(this.btnBack);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.btnAll);
this.MaximizeBox = false;
this.MaximumSize = new System.Drawing.Size(752, 528);
this.MinimumSize = new System.Drawing.Size(752, 528);
this.Name = "OrderHistoryManagement";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "预订单历史查询";
this.Load += new System.EventHandler(this.OrderHistoryManagement_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
this.groupBox2.ResumeLayout(false);
this.ResumeLayout(false);
}
