hotelleave.cs

酒店管理系统采用C#和SQL Server 数据库实现 适合一般小酒店的管理

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

namespace 酒店管理系统
{
	public class HotelLeave : 医院管理系统.ParentForm
	{
		private System.Windows.Forms.DataGrid dataGrid2;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private 酒店管理系统.DataSet1 dataSet11;
		private System.Data.SqlClient.SqlDataAdapter da2;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
		private System.Windows.Forms.TextBox txt4;
		private System.Windows.Forms.ComboBox cmb1;
		private System.Data.DataView dataView1;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Windows.Forms.Button btnCal;
		private System.Windows.Forms.Button btnLeave;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.ComponentModel.IContainer components = null;

		public HotelLeave()
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

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

		#region 设计器生成的代码
		/// <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();
			((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();
			// 
			// groupBox1
			// 
			this.groupBox1.Name = "groupBox1";
			// 
			// txt2
			// 
			this.txt2.Name = "txt2";
			// 
			// label1
			// 
			this.label1.Name = "label1";
			this.label1.Text = "客房编号";
			// 
			// btnSearch
			// 
			this.btnSearch.Name = "btnSearch";
			this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
			// 
			// txt1
			// 
			this.txt1.Name = "txt1";
			// 
			// label2
			// 
			this.label2.Name = "label2";
			this.label2.Text = "入住单号";
			// 
			// txt3
			// 
			this.txt3.Name = "txt3";
			this.txt3.Visible = false;
			// 
			// label3
			// 
			this.label3.Name = "label3";
			this.label3.Visible = false;
			// 
			// toolBar1
			// 
			this.toolBar1.Name = "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.Name = "dataGrid1";
			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.Name = "groupBox2";
			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";