/// <summary>
/// �����֧������ķ��� - ��Ҫʹ�ô���༭����
/// �˷��������ݡ�
/// </summary>
private void InitializeComponent()
{
this.dataGrid2 = new System.Windows.Forms.DataGrid();
this.dataView1 = new System.Data.DataView();
this.dataSet11 = new �Ƶ����ϵͳ.DataSet1();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.da2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.btnCal = new System.Windows.Forms.Button();
this.btnLeave = new System.Windows.Forms.Button();
this.txt4 = new System.Windows.Forms.TextBox();
this.cmb1 = new System.Windows.Forms.ComboBox();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.Text = "�ͷ����";
//
// btnSearch
//
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// label2
//
this.label2.Text = "��ס����";
//
// txt3
//
this.txt3.Visible = false;
//
// label3
//
this.label3.Visible = false;
//
// toolBar1
//
this.toolBar1.Size = new System.Drawing.Size(728, 41);
//
// tBtnNew
//
this.tBtnNew.Visible = false;
//
// tBtnEdit
//
this.tBtnEdit.Visible = false;
//
// tBtnDelete
//
this.tBtnDelete.Visible = false;
//
// tBtnSubmit
//
this.tBtnSubmit.Visible = false;
//
// tBtnCancel
//
this.tBtnCancel.Visible = false;
//
// dataGrid1
//
this.dataGrid1.DataMember = "��ס��";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.Size = new System.Drawing.Size(728, 160);
this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.cmb1);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.btnCal);
this.groupBox2.Controls.Add(this.btnLeave);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Location = new System.Drawing.Point(0, 408);
this.groupBox2.Size = new System.Drawing.Size(728, 88);
//
// da1
//
this.da1.DeleteCommand = null;
this.da1.InsertCommand = null;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "��ס��", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("��ס����", "��ס����"),
new System.Data.Common.DataColumnMapping("Ԥ������", "Ԥ������"),
new System.Data.Common.DataColumnMapping("��Ա���", "��Ա���"),
new System.Data.Common.DataColumnMapping("�ֵ�ʱ��", "�ֵ�ʱ��"),
new System.Data.Common.DataColumnMapping("���ʱ��", "���ʱ��"),
new System.Data.Common.DataColumnMapping("�ͷ����", "�ͷ����"),
new System.Data.Common.DataColumnMapping("�ͷ��۸�", "�ͷ��۸�"),
new System.Data.Common.DataColumnMapping("��ס�۸�", "��ס�۸�"),
new System.Data.Common.DataColumnMapping("�Ƿ�Ӵ�", "�Ƿ�Ӵ�"),
new System.Data.Common.DataColumnMapping("�Ӵ��۸�", "�Ӵ��۸�"),
new System.Data.Common.DataColumnMapping("Ԥ�տ�", "Ԥ�տ�"),
new System.Data.Common.DataColumnMapping("���", "���"),
new System.Data.Common.DataColumnMapping("����", "����"),
new System.Data.Common.DataColumnMapping("����", "����"),
new System.Data.Common.DataColumnMapping("vip", "vip"),
new System.Data.Common.DataColumnMapping("�绰�ȼ�", "�绰�ȼ�"),
new System.Data.Common.DataColumnMapping("��Ҫ˵��", "��Ҫ˵��"),
new System.Data.Common.DataColumnMapping("Ӧ���ʿ�", "Ӧ���ʿ�"),
new System.Data.Common.DataColumnMapping("�Ƿ����", "�Ƿ����"),
new System.Data.Common.DataColumnMapping("���ʽ��", "���ʽ��"),
new System.Data.Common.DataColumnMapping("��������", "��������"),
new System.Data.Common.DataColumnMapping("���ʽ", "���ʽ"),
new System.Data.Common.DataColumnMapping("��ס����", "��ס����")})});
this.da1.UpdateCommand = null;
//
// dataGrid2
//
this.dataGrid2.CaptionVisible = false;
this.dataGrid2.DataMember = "";
this.dataGrid2.DataSource = this.dataView1;
this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid2.Location = new System.Drawing.Point(0, 256);
this.dataGrid2.Name = "dataGrid2";
this.dataGrid2.ReadOnly = true;
this.dataGrid2.Size = new System.Drawing.Size(728, 152);
this.dataGrid2.TabIndex = 32;
//
// dataView1
//
this.dataView1.Table = this.dataSet11.�ʵ���ϸ;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// da2
//
this.da2.SelectCommand = this.sqlSelectCommand2;
this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "�ʵ���ϸ", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("�ʵ����", "�ʵ����"),
new System.Data.Common.DataColumnMapping("��ס����", "��ס����"),
new System.Data.Common.DataColumnMapping("��������", "��������"),
new System.Data.Common.DataColumnMapping("���ѽ��", "���ѽ��"),
new System.Data.Common.DataColumnMapping("����ʱ��", "����ʱ��"),
new System.Data.Common.DataColumnMapping("��ע", "��ע")})});
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT �ʵ����, ��ס����, ��������, ���ѽ��, ����ʱ��, ��ע FROM �ʵ���ϸ";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// btnCal
//
this.btnCal.Location = new System.Drawing.Point(56, 32);
this.btnCal.Name = "btnCal";
this.btnCal.Size = new System.Drawing.Size(112, 23);
this.btnCal.TabIndex = 0;
this.btnCal.Text = "����Ӧ�տ�";
this.btnCal.Click += new System.EventHandler(this.btnCal_Click);
//
// btnLeave
//
this.btnLeave.Location = new System.Drawing.Point(464, 32);
this.btnLeave.Name = "btnLeave";
this.btnLeave.Size = new System.Drawing.Size(128, 23);
this.btnLeave.TabIndex = 0;
this.btnLeave.Text = "���������˷�";
this.btnLeave.Click += new System.EventHandler(this.btnLeave_Click);
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "��ס��.Ӧ���ʿ�", true));
this.txt4.Location = new System.Drawing.Point(192, 32);
this.txt4.Name = "txt4";
this.txt4.Size = new System.Drawing.Size(100, 21);
this.txt4.TabIndex = 1;
//
// cmb1
//
this.cmb1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "��ס��.���ʽ", true));
this.cmb1.Items.AddRange(new object[] {
"�ֽ�",
"֧Ʊ",
"���ÿ�",
"����ȯ",
"����"});
this.cmb1.Location = new System.Drawing.Point(312, 32);
this.cmb1.Name = "cmb1";
this.cmb1.Size = new System.Drawing.Size(121, 20);
this.cmb1.TabIndex = 2;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ��ס����, Ԥ������, ��Ա���, �ֵ�ʱ��, ���ʱ��, �ͷ����, �ͷ��۸�, ��ס�۸�, �Ƿ�Ӵ�, �Ӵ��۸�, Ԥ�տ�, ���, ����, ��" +
"��, vip, �绰�ȼ�, ��Ҫ˵��, Ӧ���ʿ�, �Ƿ����, ���ʽ��, ��������, ���ʽ, ��ס���� FROM ��ס�� WHERE (��ס���� LIKE" +
" @Param17) AND (�ͷ���� LIKE @Param18)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Param17", System.Data.SqlDbType.VarChar, 36, "��ס����"),
new System.Data.SqlClient.SqlParameter("@Param18", System.Data.SqlDbType.VarChar, 12, "�ͷ����")});
//
// label4
//
this.label4.Location = new System.Drawing.Point(192, 17);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(56, 15);
this.label4.TabIndex = 3;
this.label4.Text = "Ӧ����";
//
// label5
//
this.label5.Location = new System.Drawing.Point(312, 16);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(56, 15);
this.label5.TabIndex = 3;
this.label5.Text = "֧����ʽ";
//
// HotelLeave
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(728, 502);
this.Controls.Add(this.dataGrid2);
this.Name = "HotelLeave";
this.Text = "��������";
this.TopMost = true;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.HotelLeave_FormClosing);
this.Load += new System.EventHandler(this.HotelLeave_Load);
this.Controls.SetChildIndex(this.dataGrid2, 0);
this.Controls.SetChildIndex(this.groupBox1, 0);
this.Controls.SetChildIndex(this.toolBar1, 0);
this.Controls.SetChildIndex(this.dataGrid1, 0);
this.Controls.SetChildIndex(this.groupBox2, 0);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// �����֧������ķ��� - ��Ҫʹ�ô���༭����
/// �˷��������ݡ�
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RoomType));
this.txt4 = new System.Windows.Forms.TextBox();
this.dataSet11 = new �Ƶ����ϵͳ.DataSet1();
this.txt5 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.txt6 = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.Text = "��������";
//
// btnSearch
//
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// label2
//
this.label2.Text = "���ͱ��";
//
// txt3
//
this.txt3.Visible = false;
//
// label3
//
this.label3.Visible = false;
//
// toolBar1
//
this.toolBar1.Size = new System.Drawing.Size(728, 41);
//
// dataGrid1
//
this.dataGrid1.DataMember = "�ͷ�����";
this.dataGrid1.DataSource = this.dataSet11;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label5);
//
// da1
//
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "�ͷ�����", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("���ͱ��", "���ͱ��"),
new System.Data.Common.DataColumnMapping("��������", "��������"),
new System.Data.Common.DataColumnMapping("�۸�", "�۸�"),
new System.Data.Common.DataColumnMapping("�Ӵ��۸�", "�Ӵ��۸�"),
new System.Data.Common.DataColumnMapping("�ɳ�Ԥ����", "�ɳ�Ԥ����"),
new System.Data.Common.DataColumnMapping("�Ƿ�ɼӴ�", "�Ƿ�ɼӴ�")})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ�����.���ͱ��", true));
this.txt4.Location = new System.Drawing.Point(124, 62);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.Size = new System.Drawing.Size(136, 21);
this.txt4.TabIndex = 6;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ�����.��������", true));
this.txt5.Location = new System.Drawing.Point(292, 62);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.Size = new System.Drawing.Size(136, 21);
this.txt5.TabIndex = 7;
//
// label6
//
this.label6.Location = new System.Drawing.Point(468, 46);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(100, 16);
this.label6.TabIndex = 2;
this.label6.Text = "�۸�";
//
// txt6
//
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ�����.�۸�", true));
this.txt6.Location = new System.Drawing.Point(468, 62);
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.Size = new System.Drawing.Size(136, 21);
this.txt6.TabIndex = 5;
this.txt6.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txt6_KeyPress);
//
// label4
//
this.label4.Location = new System.Drawing.Point(296, 48);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(100, 16);
this.label4.TabIndex = 2;
this.label4.Text = "��������";
//
// label5
//
this.label5.Location = new System.Drawing.Point(128, 48);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(100, 16);
this.label5.TabIndex = 2;
this.label5.Text = "���ͱ��";
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ���ͱ��, ��������, �۸�, �Ӵ��۸�, �ɳ�Ԥ����, �Ƿ�ɼӴ� FROM �ͷ����� WHERE (���ͱ�� LIKE @Param3) AND" +
" (�������� LIKE @Param4)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 40, "��������")});
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO �ͷ�����(���ͱ��, ��������, �۸�, �Ӵ��۸�, �ɳ�Ԥ����, �Ƿ�ɼӴ�) VALUES (@���ͱ��, @��������, @�۸�, @" +
"�Ӵ��۸�, @�ɳ�Ԥ����, @�Ƿ�ɼӴ�); SELECT ���ͱ��, ��������, �۸�, �Ӵ��۸�, �ɳ�Ԥ����, �Ƿ�ɼӴ� FROM �ͷ����� WHERE" +
" (���ͱ�� = @���ͱ��)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@��������", System.Data.SqlDbType.VarChar, 40, "��������"),
new System.Data.SqlClient.SqlParameter("@�۸�", System.Data.SqlDbType.Money, 8, "�۸�"),
new System.Data.SqlClient.SqlParameter("@�Ӵ��۸�", System.Data.SqlDbType.Money, 8, "�Ӵ��۸�"),
new System.Data.SqlClient.SqlParameter("@�ɳ�Ԥ����", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "�ɳ�Ԥ����", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�")});
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@��������", System.Data.SqlDbType.VarChar, 40, "��������"),
new System.Data.SqlClient.SqlParameter("@�۸�", System.Data.SqlDbType.Money, 8, "�۸�"),
new System.Data.SqlClient.SqlParameter("@�Ӵ��۸�", System.Data.SqlDbType.Money, 8, "�Ӵ��۸�"),
new System.Data.SqlClient.SqlParameter("@�ɳ�Ԥ����", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "�ɳ�Ԥ����", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�"),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�۸�", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�۸�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ɳ�Ԥ����", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "�ɳ�Ԥ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ӵ��۸�", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ӵ��۸�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��������", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��������", System.Data.DataRowVersion.Original, null)});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText");
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�۸�", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�۸�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ɳ�Ԥ����", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((byte)(3)), ((byte)(0)), "�ɳ�Ԥ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ӵ��۸�", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ӵ��۸�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��������", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��������", System.Data.DataRowVersion.Original, null)});
//
// RoomType
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(728, 502);
this.Name = "RoomType";
this.Text = "���ͷ��������á�";
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.RoomType_FormClosing);
this.Load += new System.EventHandler(this.RoomType_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// �����֧������ķ��� - ��Ҫʹ�ô���༭����
/// �˷��������ݡ�
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RoomInfo));
this.txt4 = new System.Windows.Forms.TextBox();
this.dataSet11 = new �Ƶ����ϵͳ.DataSet1();
this.label4 = new System.Windows.Forms.Label();
this.txt5 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txt8 = new System.Windows.Forms.TextBox();
this.txt6 = new System.Windows.Forms.TextBox();
this.label9 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.cmb2 = new System.Windows.Forms.ComboBox();
this.cmb3 = new System.Windows.Forms.ComboBox();
this.label10 = new System.Windows.Forms.Label();
this.txt7 = new System.Windows.Forms.TextBox();
this.txt9 = new System.Windows.Forms.TextBox();
this.label11 = new System.Windows.Forms.Label();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand7 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand8 = new System.Data.SqlClient.SqlCommand();
this.da2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.da3 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Size = new System.Drawing.Size(736, 56);
//
// label1
//
this.label1.Text = "���ͱ��";
//
// btnSearch
//
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// label2
//
this.label2.Text = "�ͷ����";
//
// label3
//
this.label3.Text = "¥����";
//
// toolBar1
//
this.toolBar1.Size = new System.Drawing.Size(736, 41);
//
// dataGrid1
//
this.dataGrid1.DataMember = "�ͷ���Ϣ";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.Size = new System.Drawing.Size(736, 280);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.checkBox1);
this.groupBox2.Controls.Add(this.cmb2);
this.groupBox2.Controls.Add(this.cmb3);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.txt8);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.txt7);
this.groupBox2.Controls.Add(this.txt9);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label10);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Location = new System.Drawing.Point(0, 379);
this.groupBox2.Size = new System.Drawing.Size(736, 128);
//
// da1
//
this.da1.DeleteCommand = this.sqlCommand8;
this.da1.InsertCommand = this.sqlCommand6;
this.da1.SelectCommand = this.sqlCommand5;
this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "�ͷ���Ϣ", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("�ͷ����", "�ͷ����"),
new System.Data.Common.DataColumnMapping("���ͱ��", "���ͱ��"),
new System.Data.Common.DataColumnMapping("¥����", "¥����"),
new System.Data.Common.DataColumnMapping("�����", "�����"),
new System.Data.Common.DataColumnMapping("����", "����"),
new System.Data.Common.DataColumnMapping("�ͷ�����", "�ͷ�����"),
new System.Data.Common.DataColumnMapping("��ע", "��ע"),
new System.Data.Common.DataColumnMapping("״̬", "״̬"),
new System.Data.Common.DataColumnMapping("�Ƿ�ɼӴ�", "�Ƿ�ɼӴ�")})});
this.da1.UpdateCommand = this.sqlCommand7;
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.�ͷ����", true));
this.txt4.Location = new System.Drawing.Point(40, 40);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.Size = new System.Drawing.Size(112, 21);
this.txt4.TabIndex = 15;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label4
//
this.label4.Location = new System.Drawing.Point(40, 24);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(100, 16);
this.label4.TabIndex = 13;
this.label4.Text = "�ͷ����";
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.�����", true));
this.txt5.Location = new System.Drawing.Point(440, 40);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.Size = new System.Drawing.Size(64, 21);
this.txt5.TabIndex = 16;
//
// label5
//
this.label5.Location = new System.Drawing.Point(176, 24);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(100, 16);
this.label5.TabIndex = 10;
this.label5.Text = "�ͷ�����";
//
// txt8
//
this.txt8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.�ͷ�����", true));
this.txt8.Location = new System.Drawing.Point(40, 86);
this.txt8.Name = "txt8";
this.txt8.ReadOnly = true;
this.txt8.Size = new System.Drawing.Size(232, 21);
this.txt8.TabIndex = 17;
//
// txt6
//
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.����", true));
this.txt6.Location = new System.Drawing.Point(528, 40);
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.Size = new System.Drawing.Size(64, 21);
this.txt6.TabIndex = 14;
//
// label9
//
this.label9.Location = new System.Drawing.Point(440, 24);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(72, 16);
this.label9.TabIndex = 11;
this.label9.Text = "�����";
//
// label7
//
this.label7.Location = new System.Drawing.Point(40, 70);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(100, 16);
this.label7.TabIndex = 12;
this.label7.Text = "�ͷ�����";
//
// label6
//
this.label6.Location = new System.Drawing.Point(312, 24);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(100, 16);
this.label6.TabIndex = 10;
this.label6.Text = "¥��";
//
// label8
//
this.label8.Location = new System.Drawing.Point(528, 24);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 16);
this.label8.TabIndex = 11;
this.label8.Text = "����";
//
// cmb2
//
this.cmb2.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dataSet11, "�ͷ���Ϣ.���ͱ��", true));
this.cmb2.DataSource = this.dataSet11;
this.cmb2.DisplayMember = "�ͷ�����.��������";
this.cmb2.Enabled = false;
this.cmb2.Location = new System.Drawing.Point(176, 40);
this.cmb2.Name = "cmb2";
this.cmb2.Size = new System.Drawing.Size(120, 20);
this.cmb2.TabIndex = 19;
this.cmb2.ValueMember = "�ͷ���Ϣ.���ͱ��";
//
// cmb3
//
this.cmb3.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dataSet11, "�ͷ���Ϣ.¥����", true));
this.cmb3.DataSource = this.dataSet11;
this.cmb3.DisplayMember = "¥����Ϣ.¥������";
this.cmb3.Enabled = false;
this.cmb3.Location = new System.Drawing.Point(312, 40);
this.cmb3.Name = "cmb3";
this.cmb3.Size = new System.Drawing.Size(104, 20);
this.cmb3.TabIndex = 18;
this.cmb3.ValueMember = "¥����Ϣ.¥����";
//
// label10
//
this.label10.Location = new System.Drawing.Point(616, 24);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(72, 16);
this.label10.TabIndex = 11;
this.label10.Text = "״̬";
//
// txt7
//
this.txt7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.״̬", true));
this.txt7.Location = new System.Drawing.Point(616, 40);
this.txt7.Name = "txt7";
this.txt7.ReadOnly = true;
this.txt7.Size = new System.Drawing.Size(88, 21);
this.txt7.TabIndex = 14;
//
// txt9
//
this.txt9.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "�ͷ���Ϣ.��ע", true));
this.txt9.Location = new System.Drawing.Point(304, 86);
this.txt9.Name = "txt9";
this.txt9.ReadOnly = true;
this.txt9.Size = new System.Drawing.Size(232, 21);
this.txt9.TabIndex = 17;
//
// label11
//
this.label11.Location = new System.Drawing.Point(304, 72);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(100, 16);
this.label11.TabIndex = 12;
this.label11.Text = "��ע";
//
// checkBox1
//
this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.dataSet11, "�ͷ���Ϣ.�Ƿ�ɼӴ�", true));
this.checkBox1.Location = new System.Drawing.Point(568, 82);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(104, 24);
this.checkBox1.TabIndex = 20;
this.checkBox1.Text = "�Ƿ�ɼӴ�";
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT �ͷ����, ���ͱ��, ¥����, �����, ����, �ͷ�����, ��ע, ״̬, �Ƿ�ɼӴ� FROM �ͷ���Ϣ WHERE (�ͷ���� LIKE" +
" @Param4) AND (���ͱ�� LIKE @Param5) AND (¥���� LIKE @Param6)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.Int, 4, "¥����")});
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText");
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�")});
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�"),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText");
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// sqlCommand1
//
this.sqlCommand1.CommandText = "SELECT �ͷ����, ���ͱ��, ¥����, �����, ����, �ͷ�����, ��ע, ״̬, �Ƿ�ɼӴ� FROM �ͷ���Ϣ WHERE (�ͷ���� LIKE" +
" @Param4) AND (���ͱ�� LIKE @Param5) AND (¥���� LIKE @Param6)";
this.sqlCommand1.Connection = this.sqlConnection1;
this.sqlCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.Int, 4, "¥����")});
//
// sqlCommand2
//
this.sqlCommand2.CommandText = resources.GetString("sqlCommand2.CommandText");
this.sqlCommand2.Connection = this.sqlConnection1;
this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�")});
//
// sqlCommand3
//
this.sqlCommand3.CommandText = resources.GetString("sqlCommand3.CommandText");
this.sqlCommand3.Connection = this.sqlConnection1;
this.sqlCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�"),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// sqlCommand4
//
this.sqlCommand4.CommandText = resources.GetString("sqlCommand4.CommandText");
this.sqlCommand4.Connection = this.sqlConnection1;
this.sqlCommand4.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// sqlCommand5
//
this.sqlCommand5.CommandText = "SELECT �ͷ����, ���ͱ��, ¥����, �����, ����, �ͷ�����, ��ע, ״̬, �Ƿ�ɼӴ� FROM �ͷ���Ϣ WHERE (�ͷ���� LIKE" +
" @Param4) AND (���ͱ�� LIKE @Param5) AND (¥���� LIKE @Param6)";
this.sqlCommand5.Connection = this.sqlConnection1;
this.sqlCommand5.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.VarChar, 4, "¥����")});
//
// sqlCommand6
//
this.sqlCommand6.CommandText = resources.GetString("sqlCommand6.CommandText");
this.sqlCommand6.Connection = this.sqlConnection1;
this.sqlCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�")});
//
// sqlCommand7
//
this.sqlCommand7.CommandText = resources.GetString("sqlCommand7.CommandText");
this.sqlCommand7.Connection = this.sqlConnection1;
this.sqlCommand7.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@�ͷ����", System.Data.SqlDbType.VarChar, 12, "�ͷ����"),
new System.Data.SqlClient.SqlParameter("@���ͱ��", System.Data.SqlDbType.VarChar, 4, "���ͱ��"),
new System.Data.SqlClient.SqlParameter("@¥����", System.Data.SqlDbType.Int, 4, "¥����"),
new System.Data.SqlClient.SqlParameter("@�����", System.Data.SqlDbType.Int, 4, "�����"),
new System.Data.SqlClient.SqlParameter("@����", System.Data.SqlDbType.Int, 4, "����"),
new System.Data.SqlClient.SqlParameter("@�ͷ�����", System.Data.SqlDbType.VarChar, 40, "�ͷ�����"),
new System.Data.SqlClient.SqlParameter("@��ע", System.Data.SqlDbType.VarChar, 100, "��ע"),
new System.Data.SqlClient.SqlParameter("@״̬", System.Data.SqlDbType.VarChar, 4, "״̬"),
new System.Data.SqlClient.SqlParameter("@�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, "�Ƿ�ɼӴ�"),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// sqlCommand8
//
this.sqlCommand8.CommandText = resources.GetString("sqlCommand8.CommandText");
this.sqlCommand8.Connection = this.sqlConnection1;
this.sqlCommand8.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_�ͷ����", System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_��ע", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "��ע", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�ͷ�����", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�ͷ�����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�Ƿ�ɼӴ�", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�Ƿ�ɼӴ�", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_¥����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "¥����", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_״̬", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "״̬", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_���ͱ��", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "���ͱ��", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_�����", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "�����", System.Data.DataRowVersion.Original, null)});
//
// da2
//
this.da2.SelectCommand = this.sqlSelectCommand2;
this.da2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "¥����Ϣ", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("¥����", "¥����"),
new System.Data.Common.DataColumnMapping("¥������", "¥������")})});
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT ¥����, ¥������ FROM ¥����Ϣ";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// da3
//
this.da3.SelectCommand = this.sqlSelectCommand3;
this.da3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "�ͷ�����", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("���ͱ��", "���ͱ��"),
new System.Data.Common.DataColumnMapping("��������", "��������"),
new System.Data.Common.DataColumnMapping("�۸�", "�۸�"),
new System.Data.Common.DataColumnMapping("�Ӵ��۸�", "�Ӵ��۸�"),
new System.Data.Common.DataColumnMapping("�ɳ�Ԥ����", "�ɳ�Ԥ����"),
new System.Data.Common.DataColumnMapping("�Ƿ�ɼӴ�", "�Ƿ�ɼӴ�")})});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT ���ͱ��, ��������, �۸�, �Ӵ��۸�, �ɳ�Ԥ����, �Ƿ�ɼӴ� FROM �ͷ�����";
this.sqlSelectCommand3.Connection = this.sqlConnection1;
//
// RoomInfo
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
this.ClientSize = new System.Drawing.Size(736, 509);
this.Name = "RoomInfo";
this.Text = "���ͷ���Ϣ���á�";
this.TopMost = true;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.RoomInfo_FormClosing);
this.Load += new System.EventHandler(this.RoomInfo_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}