qtform.cs

一个酒店管理系统

			this.listView2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.listView2.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																						this.columnHeader1,
																						this.columnHeader2,
																						this.columnHeader3,
																						this.columnHeader4,
																						this.columnHeader5});
			this.listView2.FullRowSelect = true;
			this.listView2.GridLines = true;
			this.listView2.Location = new System.Drawing.Point(160, 64);
			this.listView2.Name = "listView2";
			this.listView2.Size = new System.Drawing.Size(824, 144);
			this.listView2.TabIndex = 14;
			this.listView2.View = System.Windows.Forms.View.Details;
			// 
			// columnHeader1
			// 
			this.columnHeader1.Text = "房间号";
			this.columnHeader1.Width = 150;
			// 
			// columnHeader2
			// 
			this.columnHeader2.Text = "房间楼层";
			this.columnHeader2.Width = 150;
			// 
			// columnHeader3
			// 
			this.columnHeader3.Text = "房间类型";
			this.columnHeader3.Width = 150;
			// 
			// columnHeader4
			// 
			this.columnHeader4.Text = "房间电话";
			this.columnHeader4.Width = 150;
			// 
			// columnHeader5
			// 
			this.columnHeader5.Text = "注释";
			this.columnHeader5.Width = 220;
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(160, 45);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(824, 20);
			this.label2.TabIndex = 15;
			this.label2.Text = "信息显示";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(0, 45);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(152, 18);
			this.label3.TabIndex = 16;
			this.label3.Text = "房间类型";
			// 
			// treeView1
			// 
			this.treeView1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.treeView1.ImageIndex = 4;
			this.treeView1.ImageList = this.imageList1;
			this.treeView1.Location = new System.Drawing.Point(0, 64);
			this.treeView1.Name = "treeView1";
			this.treeView1.SelectedImageIndex = 5;
			this.treeView1.Size = new System.Drawing.Size(152, 496);
			this.treeView1.TabIndex = 17;
			this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect);
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(0, 560);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(152, 16);
			this.label4.TabIndex = 18;
			this.label4.Text = "房间状态选择";
			// 
			// treeView2
			// 
			this.treeView2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.treeView2.ImageList = this.imageList1;
			this.treeView2.Location = new System.Drawing.Point(0, 576);
			this.treeView2.Name = "treeView2";
			this.treeView2.Scrollable = false;
			this.treeView2.SelectedImageIndex = 5;
			this.treeView2.ShowLines = false;
			this.treeView2.ShowPlusMinus = false;
			this.treeView2.ShowRootLines = false;
			this.treeView2.Size = new System.Drawing.Size(152, 88);
			this.treeView2.TabIndex = 19;
			this.treeView2.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView2_AfterSelect);
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(152, 45);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(8, 620);
			this.label5.TabIndex = 21;
			// 
			// timer1
			// 
			this.timer1.Interval = 1000;
			this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
			// 
			// listView3
			// 
			this.listView3.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.listView3.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																						this.columnHeader6,
																						this.columnHeader7,
																						this.columnHeader8,
																						this.columnHeader9,
																						this.columnHeader11,
																						this.columnHeader10,
																						this.columnHeader12,
																						this.columnHeader13});
			this.listView3.FullRowSelect = true;
			this.listView3.GridLines = true;
			this.listView3.Location = new System.Drawing.Point(160, 64);
			this.listView3.Name = "listView3";
			this.listView3.Size = new System.Drawing.Size(824, 144);
			this.listView3.TabIndex = 23;
			this.listView3.View = System.Windows.Forms.View.Details;
			this.listView3.Visible = false;
			// 
			// columnHeader6
			// 
			this.columnHeader6.Text = "预定id";
			this.columnHeader6.Width = 100;
			// 
			// columnHeader7
			// 
			this.columnHeader7.Text = "预定人姓名";
			this.columnHeader7.Width = 100;
			// 
			// columnHeader8
			// 
			this.columnHeader8.Text = "预定房间";
			this.columnHeader8.Width = 100;
			// 
			// columnHeader9
			// 
			this.columnHeader9.Text = "预定时间";
			this.columnHeader9.Width = 100;
			// 
			// columnHeader10
			// 
			this.columnHeader10.Text = "预定人电话";
			this.columnHeader10.Width = 100;
			// 
			// columnHeader11
			// 
			this.columnHeader11.Text = "到达时间";
			this.columnHeader11.Width = 100;
			// 
			// columnHeader12
			// 
			this.columnHeader12.Text = "会员号";
			this.columnHeader12.Width = 100;
			// 
			// columnHeader13
			// 
			this.columnHeader13.Text = "注释";
			this.columnHeader13.Width = 200;
			// 
			// listView4
			// 
			this.listView4.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.listView4.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																						this.columnHeader14,
																						this.columnHeader15,
																						this.columnHeader16,
																						this.columnHeader17,
																						this.columnHeader18,
																						this.columnHeader19,
																						this.columnHeader20,
																						this.columnHeader21,
																						this.columnHeader22,
																						this.columnHeader23});
			this.listView4.FullRowSelect = true;
			this.listView4.GridLines = true;
			this.listView4.Location = new System.Drawing.Point(160, 64);
			this.listView4.Name = "listView4";
			this.listView4.Size = new System.Drawing.Size(824, 144);
			this.listView4.TabIndex = 24;
			this.listView4.View = System.Windows.Forms.View.Details;
			this.listView4.Visible = false;
			// 
			// columnHeader14
			// 
			this.columnHeader14.Text = "房间id";
			this.columnHeader14.Width = 80;
			// 
			// columnHeader15
			// 
			this.columnHeader15.Text = "客人姓名";
			this.columnHeader15.Width = 80;
			// 
			// columnHeader16
			// 
			this.columnHeader16.Text = "客人性别";
			this.columnHeader16.Width = 80;
			// 
			// columnHeader17
			// 
			this.columnHeader17.Text = "客人身份证";
			this.columnHeader17.Width = 80;
			// 
			// columnHeader18
			// 
			this.columnHeader18.Text = "居住人数";
			this.columnHeader18.Width = 80;
			// 
			// columnHeader19
			// 
			this.columnHeader19.Text = "入住时间";
			this.columnHeader19.Width = 80;
			// 
			// columnHeader20
			// 
			this.columnHeader20.Text = "vip卡号";
			this.columnHeader20.Width = 80;
			// 
			// columnHeader21
			// 
			this.columnHeader21.Text = "客房押金";
			this.columnHeader21.Width = 80;
			// 
			// columnHeader22
			// 
			this.columnHeader22.Text = "操作员";
			this.columnHeader22.Width = 80;
			// 
			// columnHeader23
			// 
			this.columnHeader23.Text = "注释";
			this.columnHeader23.Width = 150;
			// 
			// qtform
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(1028, 725);
			this.Controls.Add(this.listView4);
			this.Controls.Add(this.listView3);
			this.Controls.Add(this.label5);
			this.Controls.Add(this.treeView2);
			this.Controls.Add(this.label4);
			this.Controls.Add(this.treeView1);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.label2);
			this.Controls.Add(this.listView2);
			this.Controls.Add(this.listView1);
			this.Controls.Add(this.statusBar1);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.toolBar1);
			this.ForeColor = System.Drawing.Color.Transparent;
			this.IsMdiContainer = true;
			this.Menu = this.mainMenu1;
			this.Name = "qtform";
			this.Text = "前台管理";
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.Closing += new System.ComponentModel.CancelEventHandler(this.qtform_Closing);
			this.Load += new System.EventHandler(this.qtform_Load);
			this.Closed += new System.EventHandler(this.qtform_Closed);
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel3)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void qtform_Load(object sender, System.EventArgs e)
		{
			gong.qjbl.shi=1;
			getfjlx();//treeView1
			settreeview2();
			setlistView1();//lv1
			this.statusBar1.Panels[1].Text="操作员为:"+gong.qjbl.name;//设置操作员
			this.timer1.Start();										//启动时间
			x=this.Size.Width;
			y=this.Size.Height;
		}

		private void menuItem1_Click(object sender, System.EventArgs e)
		{
		
		}
		private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			chuan=e.Node.Text;
			setlistView1_1(e.Node.Text);
		}
		private void treeView2_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{//判断房间
			string z="";
			if(e.Node.Text.Trim()=="空闲房间")
			{
				z="";
			}
			else if(e.Node.Text.Trim()=="预定房间")
			{
				z="1";
			}
			else if(e.Node.Text.Trim()=="有客房间")
			{
				z="2";
			}
			else{
				z="3";
			}
			setlistView1_2(z);
		}
		//----------------------------------页面付值方法部分---------------------------------



		//----------------------------------treeView1-----------------------------------
		private void getfjlx()
		{//设置房间树
			this.treeView1.Nodes.Clear();
			TreeNode nodey=new TreeNode();
			nodey.Text="房间";
			nodey.Tag=1;
				
			this.treeView1.Nodes.Add(nodey);
			this.treeView1.SelectedNode=nodey;

			DataSet objsetfjlx=new DataSet();
			cs.fjlx fjlxsql=new bggl.cs.fjlx();
			objsetfjlx=fjlxsql.selectexeshu();
			foreach(DataRow dr in objsetfjlx.Tables[0].Rows)
			{
				TreeNode nodex=new TreeNode();
				nodex.Text=dr["xname"].ToString();
				nodex.Tag=1;
				
				this.treeView1.SelectedNode.Nodes.Add(nodex);
				this.treeView1.SelectedNode=nodex;
				getkf(dr["xname"].ToString());
				treeView1.SelectedNode=nodex.Parent;
			}
		}
		private void getkf(string xname)
		{//把房间号加进去
			cs.kfsql kfsql=new bggl.cs.kfsql();
			DataSet objsetkf=new DataSet();
			objsetkf=kfsql.selectexeshu();
			foreach(DataRow dr in objsetkf.Tables[0].Rows)
			{
				if(dr["klx"].ToString().Trim()==xname.Trim())
				{
					TreeNode nodex=new TreeNode();
					nodex.Text=dr["kid"].ToString();
					nodex.Tag=1;
				
					this.treeView1.SelectedNode.Nodes.Add(nodex);
				}
			}
			
		}


		//-----------------------------------treeView1结束----------------------------

//-----------------------------------treeView2----------------------------
		private void settreeview2(){
			this.treeView2.Nodes.Clear();
			TreeNode nodey=new TreeNode();
			nodey.Text="所有房间";
			nodey.ImageIndex=3;
			nodey.Tag=1;
			this.treeView2.Nodes.Add(nodey);
			nodey=new TreeNode();
			nodey.Text="空闲房间";
			nodey.ImageIndex=2;
			nodey.Tag=1;
			this.treeView2.Nodes.Add(nodey);
			nodey=new TreeNode();
			nodey.Text="预定房间";
			nodey.ImageIndex=0;
			nodey.Tag=1;
			this.treeView2.Nodes.Add(nodey);
			nodey=new TreeNode();
			nodey.Text="有客房间";
			nodey.ImageIndex=1;
			nodey.Tag=1;
			this.treeView2.Nodes.Add(nodey);
		
		}



		//-----------------------------------页面付值方法部分结束-----------------------------//

		//------------------------------改变treeView1值后给listView1付值-----------------------
		private void setlistView1(){
			int z=1;
			ListViewItem lstItem;
			cs.kfsql kfsql=new bggl.cs.kfsql();
			DataSet objsetkf=new DataSet();
			objsetkf=kfsql.selectexeshu();
			this.listView1.Items.Clear();
			foreach(DataRow dr in objsetkf.Tables[0].Rows)
			{
				if(dr["kzt"].ToString().Trim()=="")
				{
					z=2;
				}
				else if(dr["kzt"].ToString().Trim()=="1")
				{
					z=0;
				}
				else if(dr["kzt"].ToString().Trim()=="2")
				{
					z=1;
					
				}
				lstItem=new ListViewItem();
				lstItem.ImageIndex=z;
				lstItem.SubItems[0].Text=dr["kid"].ToString().Trim();
				this.listView1.Items.Add(lstItem); 
			}		
		}
		private void setlistView1_1(string fjlx)
		{
			int z=1;
			ListViewItem lstItem;
			cs.kfsql kfsql=new bggl.cs.kfsql();
			DataSet objsetkf=new DataSet();
			objsetkf=kfsql.selectexeshu();
			this.listView1.Items.Clear();
			foreach(DataRow dr in objsetkf.Tables[0].Rows)
			{
				//点选房间树如果房间类型或 房间名相同就在lv1中显示值
				if(dr["kid"].ToString().Trim()==fjlx.Trim()||dr["klx"].ToString().Trim()==fjlx.Trim()||fjlx.Trim()=="房间")
				{
					if(dr["kzt"].ToString().Trim()=="")
					{
						z=2;
					}
					else if(dr["kzt"].ToString().Trim()=="1")
					{
						z=0;
					}
					else if(dr["kzt"].ToString().Trim()=="2")
					{
						z=1;
					
					}
					lstItem=new ListViewItem();
					lstItem.ImageIndex=z;
					lstItem.SubItems[0].Text=dr["kid"].ToString().Trim();
					this.listView1.Items.Add(lstItem); 
				}
			}		
		}
		private void setlistView1_2(string fjzt)
		{
			int z=1;
			ListViewItem lstItem;
			cs.kfsql kfsql=new bggl.cs.kfsql();
			DataSet objsetkf=new DataSet();
			objsetkf=kfsql.selectexeshu();
			this.listView1.Items.Clear();
			foreach(DataRow dr in objsetkf.Tables[0].Rows)
			{