fmopenguest.cs

一个基本的酒店管理系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using ShowInfoLibrary;
using ConnectDBLibrary;
using System.Data;

namespace UI
{
	/// <summary>
	/// fmOpenGuest 的摘要说明。
	/// </summary>
	public class fmOpenGuest : System.Windows.Forms.Form
	{
	
		string Nremark="";
		string roomid="";
		int PID;
		string coding="";
		string sex="";
		string name="";
		string num;
		string origin="";
		string utel="";
		string company="";//所在公司
		string address="";//地址
		string uremark="";//宾客备注
		string handcoding="";//手工单号
		float deposit;//实收押金
		string days="";//预住天数
		int originID;
		private int isjack=0;
		
		private int istimeroom=0;//是否为钟点房间
		private int issecret=0;//是否保密
		private string papersort;//证件类型
		private	int	addcoding=0;
		LoadRoomInfoData roominfo;
		LoadRoomInfoBusiness business;
		private string RoomCoding;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label lblRoomID;
		private System.Windows.Forms.Label lblRoomType;
		private System.Windows.Forms.Label lblRoomPrice;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.TextBox txtaddress;
		private System.Windows.Forms.TextBox txtremark;
		private System.Windows.Forms.ComboBox cboCertificate;
		private System.Windows.Forms.ComboBox cboGusetType;
		private System.Windows.Forms.ComboBox cboOrigin;
		private System.Windows.Forms.ComboBox cboSell;
		private System.Windows.Forms.TextBox txtDiscount;
		private System.Windows.Forms.TextBox txtPrice;
		private System.Windows.Forms.TextBox txtDeposit;
		private System.Windows.Forms.TextBox txtCompany;
		private System.Windows.Forms.TextBox txtCoding;
		private System.Windows.Forms.TextBox txtName;
		private System.Windows.Forms.ComboBox cboSex;
		private System.Windows.Forms.TextBox txtGuestNum;
		private System.Windows.Forms.ComboBox comboBox1;
		private System.Windows.Forms.Label lslHandCoding;
		private System.Windows.Forms.TextBox textBox2;
		private System.Windows.Forms.Label lblDays;
		private System.Windows.Forms.TextBox txtDays;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.ListView listView1;
		private System.Windows.Forms.CheckBox checkBox4;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Button button4;
		private System.Windows.Forms.ColumnHeader 序号;
		private System.Windows.Forms.ColumnHeader 开单房间;
		private System.Windows.Forms.TabControl tabControl1;
		private System.Windows.Forms.TabPage tabPage1;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.CheckBox chkJack;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.Label lblPrice;
		private System.Windows.Forms.Label lblrType;
		private System.Windows.Forms.ListBox lstRoomUsable;
		private System.Windows.Forms.Label label24;
		private System.Windows.Forms.TextBox txttel;
		private System.Windows.Forms.ComboBox cbopayway;
		private System.Windows.Forms.CheckBox chktime;
		private System.Windows.Forms.Button btnInsert;
		private System.Windows.Forms.CheckBox chkserect;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public fmOpenGuest()
		{
			//
			// 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.label1 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.lblRoomID = new System.Windows.Forms.Label();
			this.lblRoomType = new System.Windows.Forms.Label();
			this.lblRoomPrice = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.lblPrice = new System.Windows.Forms.Label();
			this.lblDays = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label15 = new System.Windows.Forms.Label();
			this.label16 = new System.Windows.Forms.Label();
			this.label17 = new System.Windows.Forms.Label();
			this.label18 = new System.Windows.Forms.Label();
			this.label20 = new System.Windows.Forms.Label();
			this.chktime = new System.Windows.Forms.CheckBox();
			this.chkserect = new System.Windows.Forms.CheckBox();
			this.chkJack = new System.Windows.Forms.CheckBox();
			this.label5 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label19 = new System.Windows.Forms.Label();
			this.txtaddress = new System.Windows.Forms.TextBox();
			this.txtremark = new System.Windows.Forms.TextBox();
			this.cboCertificate = new System.Windows.Forms.ComboBox();
			this.cboGusetType = new System.Windows.Forms.ComboBox();
			this.cboOrigin = new System.Windows.Forms.ComboBox();
			this.cboSell = new System.Windows.Forms.ComboBox();
			this.txtDiscount = new System.Windows.Forms.TextBox();
			this.txtPrice = new System.Windows.Forms.TextBox();
			this.txtDays = new System.Windows.Forms.TextBox();
			this.txtDeposit = new System.Windows.Forms.TextBox();
			this.txtCompany = new System.Windows.Forms.TextBox();
			this.txtCoding = new System.Windows.Forms.TextBox();
			this.txtName = new System.Windows.Forms.TextBox();
			this.cboSex = new System.Windows.Forms.ComboBox();
			this.txtGuestNum = new System.Windows.Forms.TextBox();
			this.comboBox1 = new System.Windows.Forms.ComboBox();
			this.lslHandCoding = new System.Windows.Forms.Label();
			this.textBox2 = new System.Windows.Forms.TextBox();
			this.button1 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			this.listView1 = new System.Windows.Forms.ListView();
			this.序号 = new System.Windows.Forms.ColumnHeader();
			this.开单房间 = new System.Windows.Forms.ColumnHeader();
			this.checkBox4 = new System.Windows.Forms.CheckBox();
			this.label13 = new System.Windows.Forms.Label();
			this.btnInsert = new System.Windows.Forms.Button();
			this.button4 = new System.Windows.Forms.Button();
			this.tabControl1 = new System.Windows.Forms.TabControl();
			this.tabPage1 = new System.Windows.Forms.TabPage();
			this.lstRoomUsable = new System.Windows.Forms.ListBox();
			this.lblrType = new System.Windows.Forms.Label();
			this.label21 = new System.Windows.Forms.Label();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.label24 = new System.Windows.Forms.Label();
			this.cbopayway = new System.Windows.Forms.ComboBox();
			this.txttel = new System.Windows.Forms.TextBox();
			this.tabControl1.SuspendLayout();
			this.tabPage1.SuspendLayout();
			this.SuspendLayout();
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(288, 8);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 16);
			this.label1.TabIndex = 0;
			this.label1.Text = "开单信息";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.label1.Click += new System.EventHandler(this.label1_Click);
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(32, 40);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(72, 24);
			this.label2.TabIndex = 1;
			this.label2.Text = "主客房间：";
			this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(232, 40);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(72, 23);
			this.label3.TabIndex = 2;
			this.label3.Text = "房间类型：";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(432, 40);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(72, 23);
			this.label4.TabIndex = 3;
			this.label4.Text = "预设单价：";
			this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// lblRoomID
			// 
			this.lblRoomID.ForeColor = System.Drawing.Color.Red;
			this.lblRoomID.Location = new System.Drawing.Point(128, 40);
			this.lblRoomID.Name = "lblRoomID";
			this.lblRoomID.Size = new System.Drawing.Size(48, 23);
			this.lblRoomID.TabIndex = 4;
			this.lblRoomID.Text = "BD001";
			this.lblRoomID.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// lblRoomType
			// 
			this.lblRoomType.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.lblRoomType.ForeColor = System.Drawing.Color.Red;
			this.lblRoomType.Location = new System.Drawing.Point(328, 40);
			this.lblRoomType.Name = "lblRoomType";
			this.lblRoomType.Size = new System.Drawing.Size(72, 23);
			this.lblRoomType.TabIndex = 5;
			this.lblRoomType.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// lblRoomPrice
			// 
			this.lblRoomPrice.ForeColor = System.Drawing.Color.Red;
			this.lblRoomPrice.Location = new System.Drawing.Point(512, 40);
			this.lblRoomPrice.Name = "lblRoomPrice";
			this.lblRoomPrice.Size = new System.Drawing.Size(48, 23);
			this.lblRoomPrice.TabIndex = 6;
			this.lblRoomPrice.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(16, 144);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(72, 23);
			this.label6.TabIndex = 8;
			this.label6.Text = "宾客来源：";
			this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(16, 176);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 9;
			this.label7.Text = "营销人员：";
			this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label9
			// 
			this.label9.Location = new System.Drawing.Point(16, 80);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(72, 23);
			this.label9.TabIndex = 7;
			this.label9.Text = "证件类型：";
			this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(16, 208);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(72, 23);
			this.label10.TabIndex = 10;
			this.label10.Text = "联系电话：";
			this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(16, 240);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(72, 23);
			this.label11.TabIndex = 11;
			this.label11.Text = "打折比例：";
			this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// lblPrice
			// 
			this.lblPrice.Location = new System.Drawing.Point(176, 240);
			this.lblPrice.Name = "lblPrice";
			this.lblPrice.Size = new System.Drawing.Size(80, 23);
			this.lblPrice.TabIndex = 12;
			this.lblPrice.Text = "实际单价：";
			this.lblPrice.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// lblDays
			// 
			this.lblDays.Location = new System.Drawing.Point(312, 240);
			this.lblDays.Name = "lblDays";
			this.lblDays.Size = new System.Drawing.Size(72, 23);
			this.lblDays.TabIndex = 13;
			this.lblDays.Text = "预住天数：";
			this.lblDays.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(432, 240);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(72, 23);
			this.label14.TabIndex = 14;
			this.label14.Text = "实收压金：";
			this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(200, 80);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(72, 23);
			this.label15.TabIndex = 15;
			this.label15.Text = "证件编码：";
			this.label15.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label16
			// 
			this.label16.Location = new System.Drawing.Point(200, 112);
			this.label16.Name = "label16";
			this.label16.Size = new System.Drawing.Size(72, 23);
			this.label16.TabIndex = 16;
			this.label16.Text = "主客姓名：";
			this.label16.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label17
			// 
			this.label17.Location = new System.Drawing.Point(200, 144);
			this.label17.Name = "label17";
			this.label17.Size = new System.Drawing.Size(72, 23);
			this.label17.TabIndex = 17;
			this.label17.Text = "公司名称：";
			this.label17.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label18
			// 
			this.label18.Location = new System.Drawing.Point(200, 176);
			this.label18.Name = "label18";
			this.label18.Size = new System.Drawing.Size(72, 23);
			this.label18.TabIndex = 18;
			this.label18.Text = "地址信息：";
			this.label18.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label20
			// 
			this.label20.Location = new System.Drawing.Point(432, 112);
			this.label20.Name = "label20";
			this.label20.Size = new System.Drawing.Size(80, 23);
			this.label20.TabIndex = 20;
			this.label20.Text = "宾客人数：";