酒店行业

开发平台：
C#

zjyj.cs：源码内容
							using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Data ;
using System.Data .SqlClient ;

namespace RoomManage
{
	public class zjyj : RoomManage.pub
	{
		private System.ComponentModel.IContainer components = null;

		public zjyj(string s)
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();
			this.opername =s;
			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.ComboBox comboBox1;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox textBox1;
		private System.Windows.Forms.TextBox textBox2;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.GroupBox groupBox4;
		private System.Windows.Forms.GroupBox groupBox5;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.TextBox textBox3;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.TextBox textBox10;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.TextBox textBox4;
		private System.Windows.Forms.TextBox textBox5;
		private System.Windows.Forms.TextBox textBox11;
		private System.Windows.Forms.TextBox textBox9;
		private System.Windows.Forms.TextBox textBox8;
		private System.Windows.Forms.TextBox textBox7;
		private System.Windows.Forms.TextBox textBox6;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label6;

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

		#region 设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(zjyj));
			this.label5 = new System.Windows.Forms.Label();
			this.comboBox1 = new System.Windows.Forms.ComboBox();
			this.label1 = new System.Windows.Forms.Label();
			this.textBox1 = new System.Windows.Forms.TextBox();
			this.textBox2 = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.groupBox4 = new System.Windows.Forms.GroupBox();
			this.groupBox5 = new System.Windows.Forms.GroupBox();
			this.label3 = new System.Windows.Forms.Label();
			this.textBox3 = new System.Windows.Forms.TextBox();
			this.label12 = new System.Windows.Forms.Label();
			this.textBox5 = new System.Windows.Forms.TextBox();
			this.label9 = new System.Windows.Forms.Label();
			this.textBox10 = new System.Windows.Forms.TextBox();
			this.label19 = new System.Windows.Forms.Label();
			this.textBox11 = new System.Windows.Forms.TextBox();
			this.label17 = new System.Windows.Forms.Label();
			this.textBox9 = new System.Windows.Forms.TextBox();
			this.label15 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.textBox8 = new System.Windows.Forms.TextBox();
			this.textBox7 = new System.Windows.Forms.TextBox();
			this.label11 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.button2 = new System.Windows.Forms.Button();
			this.textBox4 = new System.Windows.Forms.TextBox();
			this.textBox6 = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.groupBox2.SuspendLayout();
			this.groupBox3.SuspendLayout();
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(8, 80);
			this.button1.Name = "button1";
			this.button1.TabIndex = 21;
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Name = "groupBox1";
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.button2);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Controls.SetChildIndex(this.button1, 0);
			this.groupBox2.Controls.SetChildIndex(this.button2, 0);
			// 
			// pictureBox1
			// 
			this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
			this.pictureBox1.Name = "pictureBox1";
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.label6);
			this.groupBox3.Controls.Add(this.label4);
			this.groupBox3.Controls.Add(this.textBox6);
			this.groupBox3.Controls.Add(this.textBox4);
			this.groupBox3.Controls.Add(this.textBox5);
			this.groupBox3.Controls.Add(this.label9);
			this.groupBox3.Controls.Add(this.textBox10);
			this.groupBox3.Controls.Add(this.label19);
			this.groupBox3.Controls.Add(this.textBox11);
			this.groupBox3.Controls.Add(this.label17);
			this.groupBox3.Controls.Add(this.textBox9);
			this.groupBox3.Controls.Add(this.label15);
			this.groupBox3.Controls.Add(this.label14);
			this.groupBox3.Controls.Add(this.textBox8);
			this.groupBox3.Controls.Add(this.textBox7);
			this.groupBox3.Controls.Add(this.label11);
			this.groupBox3.Controls.Add(this.label8);
			this.groupBox3.Controls.Add(this.label7);
			this.groupBox3.Controls.Add(this.label12);
			this.groupBox3.Controls.Add(this.textBox3);
			this.groupBox3.Controls.Add(this.label3);
			this.groupBox3.Controls.Add(this.groupBox5);
			this.groupBox3.Controls.Add(this.groupBox4);
			this.groupBox3.Controls.Add(this.textBox2);
			this.groupBox3.Controls.Add(this.label2);
			this.groupBox3.Controls.Add(this.textBox1);
			this.groupBox3.Controls.Add(this.label1);
			this.groupBox3.Controls.Add(this.comboBox1);
			this.groupBox3.Controls.Add(this.label5);
			this.groupBox3.Name = "groupBox3";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(8, 21);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(72, 16);
			this.label5.TabIndex = 52;
			this.label5.Text = "凭证号码：";
			// 
			// comboBox1
			// 
			this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.comboBox1.Location = new System.Drawing.Point(72, 16);
			this.comboBox1.Name = "comboBox1";
			this.comboBox1.Size = new System.Drawing.Size(120, 20);
			this.comboBox1.TabIndex = 53;
			this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(192, 18);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 54;
			this.label1.Text = "追加押金：";
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(264, 16);
			this.textBox1.Name = "textBox1";
			this.textBox1.TabIndex = 55;
			this.textBox1.Text = "";
			this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
			// 
			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(80, 53);
			this.textBox2.Name = "textBox2";
			this.textBox2.ReadOnly = true;
			this.textBox2.TabIndex = 56;
			this.textBox2.Text = "";
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(8, 56);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(72, 23);
			this.label2.TabIndex = 57;
			this.label2.Text = "姓　　名：";
			// 
			// groupBox4
			// 
			this.groupBox4.Location = new System.Drawing.Point(0, 40);
			this.groupBox4.Name = "groupBox4";
			this.groupBox4.Size = new System.Drawing.Size(384, 3);
			this.groupBox4.TabIndex = 58;
			this.groupBox4.TabStop = false;
			// 
			// groupBox5
			// 
			this.groupBox5.Location = new System.Drawing.Point(0, 240);
			this.groupBox5.Name = "groupBox5";
			this.groupBox5.Size = new System.Drawing.Size(384, 3);
			this.groupBox5.TabIndex = 59;
			this.groupBox5.TabStop = false;
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(192, 56);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(72, 23);
			this.label3.TabIndex = 60;
			this.label3.Text = "已交押金：";
			// 
			// textBox3
			// 
			this.textBox3.Location = new System.Drawing.Point(264, 53);
			this.textBox3.Name = "textBox3";
			this.textBox3.ReadOnly = true;
			this.textBox3.TabIndex = 61;
			this.textBox3.Text = "";
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(8, 253);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(120, 23);
			this.label12.TabIndex = 70;
			// 
			// textBox5
			// 
			this.textBox5.Location = new System.Drawing.Point(264, 89);
			this.textBox5.Name = "textBox5";
			this.textBox5.ReadOnly = true;
			this.textBox5.TabIndex = 76;
			this.textBox5.Text = "";
			// 
			// label9
			// 
			this.label9.Location = new System.Drawing.Point(192, 92);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(72, 23);
			this.label9.TabIndex = 86;
			this.label9.Text = "应交宿费：";
			// 
			// textBox10
			// 
			this.textBox10.Location = new System.Drawing.Point(80, 197);
			this.textBox10.Name = "textBox10";
			this.textBox10.ReadOnly = true;
			this.textBox10.TabIndex = 74;
			this.textBox10.Text = "";
			// 
			// label19
			// 
			this.label19.Location = new System.Drawing.Point(8, 200);
			this.label19.Name = "label19";
			this.label19.Size = new System.Drawing.Size(72, 23);
			this.label19.TabIndex = 85;
			this.label19.Text = "提醒日期：";
			// 
			// textBox11
			// 
			this.textBox11.Location = new System.Drawing.Point(264, 197);
			this.textBox11.Name = "textBox11";
			this.textBox11.ReadOnly = true;
			this.textBox11.TabIndex = 75;
			this.textBox11.Text = "";
			// 
			// label17
			// 
			this.label17.Location = new System.Drawing.Point(192, 164);
			this.label17.Name = "label17";
			this.label17.Size = new System.Drawing.Size(72, 23);
			this.label17.TabIndex = 84;
			this.label17.Text = "预住天数：";
			// 
			// textBox9
			// 
			this.textBox9.Location = new System.Drawing.Point(264, 161);
			this.textBox9.Name = "textBox9";
			this.textBox9.ReadOnly = true;
			this.textBox9.TabIndex = 73;
			this.textBox9.Text = "";
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(8, 164);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(72, 23);
			this.label15.TabIndex = 83;
			this.label15.Text = "住宿日期：";
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(8, 92);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(72, 23);
			this.label14.TabIndex = 82;
			this.label14.Text = "房 间 号：";
			// 
			// textBox8
			// 
			this.textBox8.Location = new System.Drawing.Point(80, 161);
			this.textBox8.Name = "textBox8";
			this.textBox8.ReadOnly = true;
			this.textBox8.TabIndex = 81;
			this.textBox8.Text = "";
			// 
			// textBox7
			// 
			this.textBox7.Location = new System.Drawing.Point(264, 125);
			this.textBox7.Name = "textBox7";
			this.textBox7.ReadOnly = true;
			this.textBox7.TabIndex = 72;
			this.textBox7.Text = "";
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(192, 200);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(72, 23);
			this.label11.TabIndex = 80;
			this.label11.Text = "退宿日期：";
			// 
			// label8
			// 
			this.label8.Location = new System.Drawing.Point(192, 128);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(72, 23);
			this.label8.TabIndex = 79;
			this.label8.Text = "房间价格：";
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(8, 128);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 78;
			this.label7.Text = "客房类型：";
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(8, 32);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(48, 23);
			this.button2.TabIndex = 19;
			this.button2.Text = "确定";
			this.button2.Click += new System.EventHandler(this.button2_Click_1);
			// 
			// textBox4
			// 
			this.textBox4.Location = new System.Drawing.Point(80, 89);
			this.textBox4.Name = "textBox4";
			this.textBox4.ReadOnly = true;
			this.textBox4.TabIndex = 88;
			this.textBox4.Text = "";
			// 
			// textBox6
			// 
			this.textBox6.Location = new System.Drawing.Point(80, 125);
			this.textBox6.Name = "textBox6";
			this.textBox6.ReadOnly = true;
			this.textBox6.TabIndex = 89;
			this.textBox6.Text = "";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(264, 253);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(88, 23);
			this.label4.TabIndex = 90;
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(192, 253);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(72, 23);
			this.label6.TabIndex = 91;
			this.label6.Text = "增款日期：";
			// 
			// zjyj
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(480, 283);
			this.Name = "zjyj";
			this.Text = "追加押金";
			this.Load += new System.EventHandler(this.zjyj_Load);
			this.groupBox2.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
		}
		#endregion
		private void button2_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show (opername);
		}
		
		DataConn dc=new DataConn ();
		
		private void zjyj_Load(object sender, System.EventArgs e)
		{
			this.AcceptButton =this.button2 ;
			this.label12 .Text ="操作员："+this.opername ;
			this.label4.Text =System.DateTime .Today.Date.ToShortDateString();
			
			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			string sql="select 凭证号码 from tabdjb where 是否结帐='0'";
			SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
			DataSet dataset=new DataSet ();
			adapter.Fill (dataset,"tabdjb");
			
			this.comboBox1 .DisplayMember="凭证号码";
			this.comboBox1 .DataSource =dataset.Tables ["tabdjb"];
			
			conn.Dispose ();
			adapter.Dispose ();
			dataset.Dispose ();
		}
		private void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string str=dc.connstr ;
			SqlConnection conn=new SqlConnection (str);
			string sql="select * from tabdjb where 凭证号码='"+this.comboBox1 .Text +"'";
			SqlDataAdapter adapter=new SqlDataAdapter (sql,conn);
			DataSet dataset=new DataSet ();
			adapter.Fill (dataset,"tabdjb");
			
			this.textBox2 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.姓名"));
			this.textBox3 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.预付金额"));
			this.textBox4 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.房间号"));
			this.textBox5 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.应交宿费"));
			this.textBox6 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.客房类型"));
			this.textBox7 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.房间价格"));
			this.textBox8 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.住宿日期"));
			this.textBox9 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.预住天数"));
			this.textBox10 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.提醒日期"));
			this.textBox11 .DataBindings.Add (new Binding ("Text",dataset,"tabdjb.退宿日期"));
			
			this.textBox8.Text =(Convert.ToDateTime (this.textBox8.Text)).ToShortDateString();
			this.textBox10.Text =(Convert.ToDateTime (this.textBox10.Text)).ToShortDateString();
			this.textBox11.Text =(Convert.ToDateTime (this.textBox11.Text)).ToShortDateString();
			
			//释放所有绑定
			this.textBox2 .DataBindings .Clear ();
			this.textBox3 .DataBindings .Clear ();
			this.textBox4 .DataBindings .Clear ();
			this.textBox5 .DataBindings .Clear ();
			this.textBox6 .DataBindings .Clear ();
			this.textBox7 .DataBindings .Clear ();
			this.textBox8 .DataBindings .Clear ();
			this.textBox9 .DataBindings .Clear ();
			this.textBox10 .DataBindings .Clear ();
			this.textBox11 .DataBindings .Clear ();
			conn.Dispose ();
			adapter.Dispose ();
			dataset.Dispose ();
			
		}
		private void button1_Click(object sender, System.EventArgs e)
		{
		
		}
		private void textBox1_TextChanged(object sender, System.EventArgs e)
		{
			string str=this.textBox1.Text ;
			int f=1;
			for(int i=0;i<str.Length ;i++)
			{
				if(str[i]<'0'|str[i]>'9'|textBox1.Text.Length  >7)
					f=0;
					break;
			}
			if(f!=1)
			{
				MessageBox.Show ("对不起，您的输入有误！","注意",MessageBoxButtons.OK ,MessageBoxIcon.Error );
				this.textBox1.Text ="";
			}
		}
		private void button2_Click_1(object sender, System.EventArgs e)
		{
			if(textBox1.Text .Length >0&textBox1.Text .Length<7)
			{
				this.textBox3 .Text =Convert.ToString((Convert.ToUInt32 (this.textBox1 .Text )+Convert.ToUInt32 (this.textBox3 .Text )));
				string str=dc.connstr ;
				SqlConnection conn=new SqlConnection (str);
				string sql="update tabdjb set 预付金额='"+this.textBox3.Text +"'";
				SqlCommand cmd=new SqlCommand (sql,conn);
				conn.Open ();
				cmd.ExecuteNonQuery ();
				conn.Close ();
				MessageBox.Show ("您已经成功追加了"+this.textBox1.Text+"元的押金","注意",MessageBoxButtons.OK ,MessageBoxIcon.Information);
			}
			else
			{
				MessageBox.Show ("输入有误！");
				textBox1.Text ="";
			}
			
		}

	}
}


						