tjsb.cs

一个酒店管理系统

				this.textBox7.Enabled=false;
				DataSet fjobjset=new DataSet();
				cs.fjlx flsql=new bggl.cs.fjlx();
				fjobjset=flsql.selectexe();;

				foreach(DataRow dr in fjobjset.Tables[0].Rows)
			
				{
					if(fjlxid.Trim()==dr["xid"].ToString().Trim())
					{
						this.textBox7.Text=dr[1].ToString().Trim();
						this.textBox8.Text=dr[2].ToString().Trim();
						this.textBox13.Text=dr[3].ToString().Trim();
						this.textBox14.Text=dr[4].ToString().Trim();
						this.textBox3.Text=dr[5].ToString().Trim();
					}
				
				}
			}
		}

		private void button4_Click(object sender, System.EventArgs e)
		{

			if(fjlxid.Trim()!="")
			{
				cs.kfsql kfsq=new bggl.cs.kfsql();
				if(kfsq.pdsf(this.textBox7.Text))
				{
					DialogResult panduan=new DialogResult();

					panduan=MessageBox.Show("您确定删除当前记录吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
					if(panduan==DialogResult.Yes)
					{
						this.button6.Enabled=true;
						this.button5.Enabled=false;
						this.button4.Enabled=false;
						this.textBox7.Enabled=true;
						cs.fjlx fjlxsqld=new bggl.cs.fjlx();
						bool pd=fjlxsqld.delexe(fjlxid.Trim());
						if(pd==true)
						{
							MessageBox.Show("删除成功");
						

							setfl();//给com2入值
							getfjlx();// 调用房间类型表
							qkfjlx();
							setfl1();
							fjlxid="";
						}

					}
				}
				else{
					MessageBox.Show("有房间引用了这个房间类型，请先改变房间!");
					
				}
			}
			else
			{
				MessageBox.Show("请选择你要删除的记录!");
			}
		}

		private void comboBox1_SelectionChangeCommitted(object sender, System.EventArgs e)
		{
			sbobjset=sbsql.selectexe();
			this.listView1.Items.Clear();
			foreach(DataRow dr in sbobjset.Tables[0].Rows)
			{
				if(this.comboBox1.Text.Trim()==dr["slx"].ToString().Trim())
				{
					ListViewItem lst=new ListViewItem();
					lst.SubItems.Clear();
					lst.SubItems[0].Text=dr[0].ToString();
					lst.SubItems.Add(dr[1].ToString());
					lst.SubItems.Add(dr[2].ToString());
					lst.SubItems.Add(dr[3].ToString());
					lst.SubItems.Add(dr[4].ToString());
					lst.SubItems.Add(dr[5].ToString());
					lst.SubItems.Add(dr[6].ToString());
					this.listView1.Items.Add(lst);
				}
			}
		}

		private void comboBox2_SelectionChangeCommitted(object sender, System.EventArgs e)
		{


		
		}

		private void button9_Click(object sender, System.EventArgs e)
		{

		}

		private void listView5_Click(object sender, System.EventArgs e)
		{
			fjlb=this.listView5.SelectedItems[0].SubItems[0].Text;
			fjzt=this.listView5.SelectedItems[0].SubItems[2].Text;
		}


		private void textBox5_TextChanged(object sender, System.EventArgs e)
		{

		}
		private void qksb(){
			this.textBox1.Text="";
			this.textBox2.Text="";
			this.textBox4.Text="";
			this.textBox5.Text="";
			this.textBox6.Text="";
		}

		private void textBox8_TextChanged(object sender, System.EventArgs e)
		{
			gong.zhipd zhi=new bggl.gong.zhipd();
			if(zhi.zhi(this.textBox8.Text.Trim())!=true)
			{
				MessageBox.Show("价格只能输入数字!");
				this.textBox8.Text="";
			}
		
		}
		private void qkfjlx(){
			this.textBox7.Text="";
			this.textBox8.Text="";
			this.textBox3.Text="";
			this.textBox13.Text="";
			this.textBox14.Text="";
		}
		private void setcb3(){
			cs.fjlx fjlxsql=new bggl.cs.fjlx();
			DataSet objset=new DataSet();
			objset=fjlxsql.selectexeshu();
			foreach(DataRow dr in objset.Tables[0].Rows)
			{
				this.comboBox1.Items.Add(dr["xname"].ToString().Trim());
			}
			this.comboBox1.SelectedIndex=0;
			
		}

		private void button9_Click_1(object sender, System.EventArgs e)
		{
			if(this.textBox9.Text.Trim()!=""&&this.textBox10.Text.Trim()!=""&&this.comboBox3.Text.Trim()!=""&&this.textBox11.Text.Trim()!="")
			{
				cs.kfsql kfsq=new bggl.cs.kfsql();
				bool pd=kfsq.insertexe(this.textBox9.Text,this.textBox10.Text,this.comboBox3.Text,this.textBox11.Text,this.textBox12.Text);
				if(pd==true)
				{
					MessageBox.Show("添加成功!");
					getkf();
					qkkf();
				}
			}
			else
			{
				MessageBox.Show("信息不完整，请填写完整");
			}
		}

		private void button8_Click_1(object sender, System.EventArgs e)
		{
			cs.kfsql kfsq=new bggl.cs.kfsql();
			if(fjh.Trim()!="")
			{
				if(this.textBox9.Text.Trim()!=""&&this.textBox10.Text.Trim()!=""&&this.comboBox3.Text.Trim()!=""&&this.textBox11.Text.Trim()!="")
				{
					kfsq=new bggl.cs.kfsql();
					if(kfsq.pdzt(fjh.Trim()).Trim()=="")
					{
						this.button7.Enabled=false;
						this.button8.Enabled=false;
						this.button9.Enabled=true;
						this.textBox9.Enabled=true;
						
						kfsq=new bggl.cs.kfsql();
						if(kfsq.updateexe(this.textBox9.Text,this.textBox10.Text,this.comboBox3.Text,this.textBox11.Text,this.textBox12.Text))
						{
							MessageBox.Show("修改成功");
							qkkf();
							getkf();
						}
						else
						{
							MessageBox.Show("修改失败");
							qkkf();
							getkf();
						}

					}
					else
					{
						MessageBox.Show("房间正在使用中");
					}
				}
				else
				{
					MessageBox.Show("资料不完整");
				}
			}
			else{
				MessageBox.Show("请选择你要修改的记录");
			}
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			cs.kfsql kfsq=new bggl.cs.kfsql();
			if(fjh.Trim()!="")
			{
					kfsq=new bggl.cs.kfsql();
					if(kfsq.pdzt(fjh.Trim())=="")
					{
						DialogResult panduan=new DialogResult();
						panduan=MessageBox.Show("您确定删除当前记录吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
						if(panduan==DialogResult.Yes)
						{
							this.button7.Enabled=false;
							this.button8.Enabled=false;
							this.button9.Enabled=true;
							this.textBox9.Enabled=true;
							kfsq=new bggl.cs.kfsql();
							if(kfsq.delexe(fjh.Trim()))
							{
								MessageBox.Show("删除成功");
								qkkf();
								getkf();
							}
							else
							{
								MessageBox.Show("添加失败");
								qkkf();
								getkf();
							}
						}
					}
					else
					{
						MessageBox.Show("房间正在使用中");
					}
			}
			else
			{
				MessageBox.Show("请选择你要修改的记录");
			}
		}
		private void qkkf(){
			this.textBox9.Text="";
			this.textBox10.Text="";
			this.textBox11.Text="";
			this.textBox12.Text="";
			this.comboBox3.Text="";
		}

		private void textBox13_TextChanged(object sender, System.EventArgs e)
		{
			gong.zhipd zhi=new bggl.gong.zhipd();
			if(zhi.zhi(this.textBox8.Text.Trim())!=true)
			{
				MessageBox.Show("价格只能输入数字!");
				this.textBox8.Text="";
			}
		}

		private void listView5_Click_1(object sender, System.EventArgs e)
		{
			fjh=this.listView5.SelectedItems[0].SubItems[0].Text;
			if(fjh.Trim()!=""){
				this.button7.Enabled=true;
				this.button8.Enabled=true;
				this.button9.Enabled=false;
				this.textBox9.Enabled=false;
				cs.kfsql kfsq=new bggl.cs.kfsql();
				DataSet objset=kfsq.selectexet(fjh);
				foreach(DataRow dr in objset.Tables[0].Rows){
					this.textBox9.Text=dr["kid"].ToString().Trim();
					this.textBox10.Text=dr["klc"].ToString().Trim();
					this.textBox11.Text=dr["kdh"].ToString().Trim();
					this.textBox12.Text=dr["kzs"].ToString().Trim();
					this.comboBox3.Text=dr["klx"].ToString().Trim();
				}						  
			}
			
		}

		private void textBox5_Leave(object sender, System.EventArgs e)
		{
			gong.zhipd zhi=new bggl.gong.zhipd();
			if(zhi.zhi(this.textBox5.Text.Trim())!=true)
			{
				MessageBox.Show("价格只能输入数字!");
				this.textBox5.Text="";
			}
		}

		private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void button10_Click(object sender, System.EventArgs e)
		{
			this.button1.Enabled=true;
			this.button2.Enabled=false;
			this.button3.Enabled=false;
			getsb();
			setcom();
			qksb();
		}

		private void button11_Click(object sender, System.EventArgs e)
		{
			fjlxid="";
			setfl();//给com2入值
			getfjlx();// 调用房间类型表
			qkfjlx();
			setfl1();
			this.button6.Enabled=true;
			this.button5.Enabled=false;
			this.button4.Enabled=false;
			this.textBox7.Enabled=true;
		}

		private void button12_Click(object sender, System.EventArgs e)
		{
			qkkf();
			getkf();
			this.button7.Enabled=false;
			this.button8.Enabled=false;
			this.button9.Enabled=true;
			this.textBox9.Enabled=true;
		}

		private void tjsb_Closed(object sender, System.EventArgs e)
		{
			setlistView1();
			getfjlx1();
		}
		private void setlistView1()
		{
			int z=1;
			ListViewItem lstItem;
			cs.kfsql kfsql=new bggl.cs.kfsql();
			DataSet objsetkf=new DataSet();
			objsetkf=kfsql.selectexeshu();
			this.lv.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.lv.Items.Add(lstItem); 
			}		
		}

		private void comboBox2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			kfobjset=ksql.selectexeshu();
			this.listView5.Items.Clear();
			foreach(DataRow dr in kfobjset.Tables[0].Rows)
			{
				if(this.comboBox2.Text.Trim()==dr["klx"].ToString().Trim())
				{
					ListViewItem lst=new ListViewItem();
					lst.SubItems.Clear();
					lst.SubItems[0].Text=dr["kid"].ToString();
					lst.SubItems.Add(dr["klc"].ToString());
					lst.SubItems.Add(dr["kzt"].ToString());
					lst.SubItems.Add(dr["klx"].ToString());
					lst.SubItems.Add(dr["krs"].ToString());
					lst.SubItems.Add(dr["kdh"].ToString());
			//		lst.SubItems.Add(dr["kjg"].ToString());
					lst.SubItems.Add(dr["kzs"].ToString());
					this.listView5.Items.Add(lst);
				}
			}
		}
		private void getfjlx1()
		{//设置房间树
			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);
				}
			}
			
		}
		}
	}