form1.cs

酒店管理系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using Bussiness;


using System.Data.SqlClient;

namespace 客房预定
{
	/// <summary>
	/// Form1 的摘要说明。
	/// </summary>
	public class Form1 : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox gb1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label60;
		private System.Windows.Forms.Label label57;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.TextBox textBox9;
		private System.Windows.Forms.TextBox textBox10;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.TextBox CustID;
		private System.Windows.Forms.DateTimePicker OrderTime;
		private System.Windows.Forms.DateTimePicker LeaveTime;
		private System.Windows.Forms.TextBox RoNo;
		private System.Windows.Forms.TextBox Desposit;
		private System.Windows.Forms.DataGrid dg;
		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.Button Search;
		private System.Windows.Forms.ComboBox RState;
		private System.Windows.Forms.ComboBox RType;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Button Clear;
		private System.Windows.Forms.Button Commit;
		private System.Windows.Forms.TextBox T_Desposit;
		private System.Windows.Forms.TextBox RoomCount;
		private System.Windows.Forms.DateTimePicker T_LeaveTime;
		private System.Windows.Forms.DateTimePicker T_OrderTime;
		private System.Windows.Forms.GroupBox groupBox4;
		private System.Windows.Forms.GroupBox groupBox5;
		private System.Windows.Forms.TabControl Pre_Order;
		private System.Windows.Forms.TabPage Personal;
		private System.Windows.Forms.TabPage Team;
		private System.Windows.Forms.TabPage Process;
		private System.Windows.Forms.ComboBox TRState;
		private System.Windows.Forms.ComboBox TRType;
		private System.Windows.Forms.Button TSearch;
		private System.Windows.Forms.DataGrid Tdg;
		private System.Windows.Forms.Button TCommit;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.TextBox Team_ID;
		private System.Windows.Forms.ComboBox RNos;
		private System.Windows.Forms.Button TClear;
		private System.Windows.Forms.Button PCancel;
		private System.Windows.Forms.Button TCancel;
		private System.Windows.Forms.GroupBox groupBox6;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.TextBox Pre_CustID;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.TextBox Pre_TID;
		private System.Windows.Forms.GroupBox groupBox7;
		private System.Windows.Forms.RadioButton P;
		private System.Windows.Forms.RadioButton T;
		private System.Windows.Forms.DataGrid Odg;
		private System.Windows.Forms.Button DeleteOutOfDate;
		private System.Windows.Forms.Button search3;
		private System.Windows.Forms.Button CancelOrder;
		private System.Windows.Forms.TextBox Session;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form1()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.gb1 = new System.Windows.Forms.GroupBox();
			this.Pre_Order = new System.Windows.Forms.TabControl();
			this.Personal = new System.Windows.Forms.TabPage();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.PCancel = new System.Windows.Forms.Button();
			this.Clear = new System.Windows.Forms.Button();
			this.Commit = new System.Windows.Forms.Button();
			this.groupBox3 = new System.Windows.Forms.GroupBox();
			this.Search = new System.Windows.Forms.Button();
			this.RState = new System.Windows.Forms.ComboBox();
			this.RType = new System.Windows.Forms.ComboBox();
			this.dg = new System.Windows.Forms.DataGrid();
			this.Desposit = new System.Windows.Forms.TextBox();
			this.RoNo = new System.Windows.Forms.TextBox();
			this.LeaveTime = new System.Windows.Forms.DateTimePicker();
			this.OrderTime = new System.Windows.Forms.DateTimePicker();
			this.CustID = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.Team = new System.Windows.Forms.TabPage();
			this.groupBox5 = new System.Windows.Forms.GroupBox();
			this.TSearch = new System.Windows.Forms.Button();
			this.TRState = new System.Windows.Forms.ComboBox();
			this.TRType = new System.Windows.Forms.ComboBox();
			this.groupBox4 = new System.Windows.Forms.GroupBox();
			this.TCancel = new System.Windows.Forms.Button();
			this.TClear = new System.Windows.Forms.Button();
			this.TCommit = new System.Windows.Forms.Button();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.RNos = new System.Windows.Forms.ComboBox();
			this.label11 = new System.Windows.Forms.Label();
			this.T_OrderTime = new System.Windows.Forms.DateTimePicker();
			this.T_LeaveTime = new System.Windows.Forms.DateTimePicker();
			this.T_Desposit = new System.Windows.Forms.TextBox();
			this.label60 = new System.Windows.Forms.Label();
			this.Team_ID = new System.Windows.Forms.TextBox();
			this.label57 = new System.Windows.Forms.Label();
			this.RoomCount = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.textBox9 = new System.Windows.Forms.TextBox();
			this.textBox10 = new System.Windows.Forms.TextBox();
			this.label9 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.Tdg = new System.Windows.Forms.DataGrid();
			this.Process = new System.Windows.Forms.TabPage();
			this.Session = new System.Windows.Forms.TextBox();
			this.Odg = new System.Windows.Forms.DataGrid();
			this.groupBox6 = new System.Windows.Forms.GroupBox();
			this.search3 = new System.Windows.Forms.Button();
			this.CancelOrder = new System.Windows.Forms.Button();
			this.DeleteOutOfDate = new System.Windows.Forms.Button();
			this.groupBox7 = new System.Windows.Forms.GroupBox();
			this.T = new System.Windows.Forms.RadioButton();
			this.P = new System.Windows.Forms.RadioButton();
			this.Pre_TID = new System.Windows.Forms.TextBox();
			this.label13 = new System.Windows.Forms.Label();
			this.Pre_CustID = new System.Windows.Forms.TextBox();
			this.label12 = new System.Windows.Forms.Label();
			this.gb1.SuspendLayout();
			this.Pre_Order.SuspendLayout();
			this.Personal.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.groupBox3.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dg)).BeginInit();
			this.Team.SuspendLayout();
			this.groupBox5.SuspendLayout();
			this.groupBox4.SuspendLayout();
			this.groupBox2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.Tdg)).BeginInit();
			this.Process.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.Odg)).BeginInit();
			this.groupBox6.SuspendLayout();
			this.groupBox7.SuspendLayout();
			this.SuspendLayout();
			// 
			// gb1
			// 
			this.gb1.Controls.Add(this.Pre_Order);
			this.gb1.Location = new System.Drawing.Point(16, 30);
			this.gb1.Name = "gb1";
			this.gb1.Size = new System.Drawing.Size(672, 434);
			this.gb1.TabIndex = 12;
			this.gb1.TabStop = false;
			this.gb1.Text = "预定系统";
			// 
			// Pre_Order
			// 
			this.Pre_Order.Controls.Add(this.Personal);
			this.Pre_Order.Controls.Add(this.Team);
			this.Pre_Order.Controls.Add(this.Process);
			this.Pre_Order.Location = new System.Drawing.Point(24, 16);
			this.Pre_Order.Name = "Pre_Order";
			this.Pre_Order.SelectedIndex = 0;
			this.Pre_Order.Size = new System.Drawing.Size(672, 392);
			this.Pre_Order.TabIndex = 0;
			// 
			// Personal
			// 
			this.Personal.Controls.Add(this.groupBox1);
			this.Personal.Controls.Add(this.groupBox3);
			this.Personal.Controls.Add(this.dg);
			this.Personal.Controls.Add(this.Desposit);
			this.Personal.Controls.Add(this.RoNo);
			this.Personal.Controls.Add(this.LeaveTime);
			this.Personal.Controls.Add(this.OrderTime);
			this.Personal.Controls.Add(this.CustID);
			this.Personal.Controls.Add(this.label2);
			this.Personal.Controls.Add(this.label4);
			this.Personal.Controls.Add(this.label3);
			this.Personal.Controls.Add(this.label6);
			this.Personal.Controls.Add(this.label7);
			this.Personal.Location = new System.Drawing.Point(4, 21);
			this.Personal.Name = "Personal";
			this.Personal.Size = new System.Drawing.Size(664, 367);
			this.Personal.TabIndex = 0;
			this.Personal.Text = "散客预定";
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.PCancel);
			this.groupBox1.Controls.Add(this.Clear);
			this.groupBox1.Controls.Add(this.Commit);
			this.groupBox1.Location = new System.Drawing.Point(520, 16);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(96, 344);
			this.groupBox1.TabIndex = 75;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "groupBox1";
			// 
			// PCancel
			// 
			this.PCancel.Location = new System.Drawing.Point(11, 152);
			this.PCancel.Name = "PCancel";
			this.PCancel.TabIndex = 56;
			this.PCancel.Text = "取消";
			this.PCancel.Click += new System.EventHandler(this.PCancel_Click);
			// 
			// Clear
			// 
			this.Clear.Location = new System.Drawing.Point(8, 88);
			this.Clear.Name = "Clear";
			this.Clear.TabIndex = 55;
			this.Clear.Text = "清空";
			this.Clear.Click += new System.EventHandler(this.Clear_Click);
			// 
			// Commit
			// 
			this.Commit.Location = new System.Drawing.Point(8, 32);
			this.Commit.Name = "Commit";
			this.Commit.TabIndex = 53;
			this.Commit.Text = "提交";
			this.Commit.Click += new System.EventHandler(this.Commit_Click);
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.Search);
			this.groupBox3.Controls.Add(this.RState);
			this.groupBox3.Controls.Add(this.RType);
			this.groupBox3.Location = new System.Drawing.Point(32, 144);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(440, 40);
			this.groupBox3.TabIndex = 74;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "查询";
			// 
			// Search
			// 
			this.Search.Location = new System.Drawing.Point(336, 16);
			this.Search.Name = "Search";
			this.Search.TabIndex = 5;
			this.Search.Text = "查询";
			this.Search.Click += new System.EventHandler(this.Search_Click);
			// 
			// RState
			// 
			this.RState.Location = new System.Drawing.Point(172, 16);
			this.RState.Name = "RState";
			this.RState.Size = new System.Drawing.Size(120, 20);
			this.RState.TabIndex = 3;
			this.RState.Text = "请选择房间状态";
			// 
			// RType
			// 
			this.RType.Location = new System.Drawing.Point(0, 16);
			this.RType.Name = "RType";
			this.RType.Size = new System.Drawing.Size(120, 20);
			this.RType.TabIndex = 2;
			this.RType.Text = "请选择房间类型";
			// 
			// dg
			// 
			this.dg.DataMember = "";
			this.dg.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dg.Location = new System.Drawing.Point(32, 176);
			this.dg.Name = "dg";
			this.dg.Size = new System.Drawing.Size(440, 184);
			this.dg.TabIndex = 73;
			this.dg.DoubleClick += new System.EventHandler(this.dg_DoubleClick);
			// 
			// Desposit
			// 
			this.Desposit.Location = new System.Drawing.Point(112, 88);
			this.Desposit.Name = "Desposit";
			this.Desposit.Size = new System.Drawing.Size(120, 21);
			this.Desposit.TabIndex = 69;
			this.Desposit.Text = "";
			// 
			// RoNo
			// 
			this.RoNo.Location = new System.Drawing.Point(112, 56);
			this.RoNo.Name = "RoNo";
			this.RoNo.Size = new System.Drawing.Size(120, 21);
			this.RoNo.TabIndex = 68;
			this.RoNo.Text = "";
			// 
			// LeaveTime
			//