kfyd.cs

一个酒店管理系统

			this.button8.Name = "button8";
			this.button8.Size = new System.Drawing.Size(24, 21);
			this.button8.TabIndex = 23;
			this.button8.Click += new System.EventHandler(this.button8_Click);
			// 
			// comboBox1
			// 
			this.comboBox1.Location = new System.Drawing.Point(384, 32);
			this.comboBox1.Name = "comboBox1";
			this.comboBox1.ReadOnly = true;
			this.comboBox1.Size = new System.Drawing.Size(104, 21);
			this.comboBox1.TabIndex = 22;
			this.comboBox1.Text = "";
			// 
			// kfyd
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(760, 557);
			this.Controls.Add(this.groupBox4);
			this.Controls.Add(this.groupBox3);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.groupBox1);
			this.MaximizeBox = false;
			this.Name = "kfyd";
			this.ShowInTaskbar = false;
			this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Show;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "客房预定";
			this.Load += new System.EventHandler(this.kfyd_Load);
			this.Closed += new System.EventHandler(this.kfyd_Closed);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			this.groupBox4.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void kfyd_Load(object sender, System.EventArgs e)
		{
			setlv();//调用显示记录方法;
			setfjxl();//给房间下拉筐值
			//sethyh();//给会员号下拉筐值
			if(fjh.Trim()!=""){
				
				
			}
		
		}
		//显示预定记录的方法
		private void setlv()
		{
			cs.ydsql ydsq=new bggl.cs.ydsql();
			DataSet objset=new DataSet();
			objset=ydsq.selectexe();//调用cs.ydsql下的selectexe方法;
			this.listView1.Items.Clear();
			foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
			{
				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());
				lst.SubItems.Add(dr[7].ToString());

				this.listView1.Items.Add(lst);

			}
		}
		//查询后调用的方法
		private void setlvc()
		{
			cs.ydsql ydsq=new bggl.cs.ydsql();
			DataSet objset=ydsq.selectexe();
			this.listView1.Items.Clear();
			foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
			{
					string sj=dr["yddsj"].ToString().Trim();
					string kg=" ";
					char []gbq=kg.ToCharArray();
					string []jj=null;
					for(int x=0;x<2;x++)
					{
						jj=sj.Split(gbq,2);
					}
				if(this.dateTimePicker1.Text.Trim()==jj[0])
				{
					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());
					lst.SubItems.Add(dr[7].ToString());

					this.listView1.Items.Add(lst);
				}

			}
		}

		private void dateTimePicker1_ValueChanged(object sender, System.EventArgs e)
		{
			setlvc();
		}
		//给房间下拉筐值
		private void setfjxl()
		{

		}
		//给会员号值
		private void sethyh()
		{
			cs.hysql hysq=new bggl.cs.hysql();
			DataSet objset=hysq.selectexe();
			foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
			{
				if(this.textBox4.Text.Trim()==dr["hname"].ToString().Trim())
				{
					this.textBox4.Text=dr["hid"].ToString().Trim();
				}
			}
			
		}

		private void listView1_Click(object sender, System.EventArgs e)
		{
			zhi=this.listView1.SelectedItems[0].SubItems[0].Text;//点击lv后给值给zhi变量

			if(zhi.ToString().Trim()!="")
			{

				cs.ydsql ydsq=new bggl.cs.ydsql();
				DataSet objset=ydsq.selectexe();
				this.button3.Enabled=true;
				this.button4.Enabled=true;
				this.button2.Enabled=false;
				this.textBox1.Enabled=false;
				foreach(DataRow dr in objset.Tables[0].Rows)
				{
					if(zhi.ToString().Trim()==dr["yid"].ToString().Trim())
						this.textBox1.Text=dr["yname"].ToString().Trim();
					this.comboBox1.Text=dr["yfj"].ToString().Trim();
					this.textBox2.Text=dr["ydh"].ToString().Trim();
					string sj=dr["yddsj"].ToString().Trim();
					string kg=" ";
					char []gbq=kg.ToCharArray();
					string []jj=null;
					for(int x=0;x<2;x++){
						jj=sj.Split(gbq,2);
					}
					this.dateTimePicker3.Text=jj[0];
					this.dateTimePicker2.Text=jj[1];
					this.textBox4.Text=dr["yhyh"].ToString().Trim();
				}

			}
		}

		private void textBox2_TextChanged(object sender, System.EventArgs e)
		{
			gong.zhipd zhip=new bggl.gong.zhipd();
			if(zhip.intjc(this.textBox2.Text))
			{
				
			}
			else
			{
				MessageBox.Show("电话号码输入格式不正确");
				this.textBox2.Text="";
			}
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			cs.ydsql ydsq=new bggl.cs.ydsql();
			if(this.textBox1.Text.Trim()!=""&&this.comboBox1.Text.Trim()!=""&&this.textBox2.Text.Trim()!="")
			{

				DataSet objset=new DataSet();
				objset=ydsq.selectexe();//调用cs.ydsql下的selectexe方法;
				bool pdzhi=true;
				foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
				{
					if(this.textBox1.Text.Trim()==dr["yname"].ToString().Trim())//判断是否已经有这个客户了
					{
						DialogResult panduan=new DialogResult();
						panduan=MessageBox.Show("预约名单里面已经有这位客户了，确定还是添加吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
						if(panduan==DialogResult.Yes)//如果选是就是同一个客户定房，否就取消添加
						{

							
							bool pd=ydsq.insertexe(this.textBox1.Text,this.comboBox1.Text,System.DateTime.Now.ToString(),this.textBox2.Text,this.dateTimePicker3.Text+" "+this.dateTimePicker2.Text,this.textBox4.Text,this.textBox3.Text);
							if(pd==true)
							{
								MessageBox.Show("添加成功");
								pdzhi=false;
								setfjxl();
								qk();
								setlv();
							}
							else
							{
								MessageBox.Show("添加失败，请重新填写");
								pdzhi=false;
								qk();
								setlv();
							}
						
						}
					}
				}
						//如果以前没有这个客户预定就添加预定信息
					if(pdzhi==true)
					{
						bool pd=ydsq.insertexe(this.textBox1.Text,this.comboBox1.Text,System.DateTime.Now.ToString(),this.textBox2.Text,this.dateTimePicker3.Text+" "+this.dateTimePicker2.Text,this.textBox4.Text,this.textBox3.Text);
						if(pd==true)
						{
							MessageBox.Show("添加成功");
							setfjxl();
							qk();
							setlv();
						}
						else
						{
							MessageBox.Show("添加失败，请重新填写");
							qk();
							setlv();
						}
						
					
				}
			}
			else
			{
				MessageBox.Show("资料填写不完整");
			}
		
			
	}

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


			if(zhi.ToString().Trim()!="")
			{
				if(this.textBox1.Text.Trim()!=""&&this.comboBox1.Text.Trim()!=""&&this.textBox2.Text.Trim()!="")
				{
					this.button2.Enabled=true;
					this.button3.Enabled=false;
					this.button4.Enabled=false;
					this.textBox1.Enabled=true;

					cs.ydsql ydsq=new bggl.cs.ydsql();
					bool pd=ydsq.updateexe(zhi.ToString().Trim(),this.textBox1.Text,this.comboBox1.Text,this.textBox2.Text,this.dateTimePicker3.Text+" "+this.dateTimePicker2.Text,this.textBox4.Text,this.textBox3.Text);
					if(pd==true)
					{
						MessageBox.Show("修改成功");
						setfjxl();
						zhi="";
						qk();
						setlv();

					}
					else
					{
						MessageBox.Show("修改失败，请重新修改");
						zhi="";
						qk();
						setlv();
					}
				}
			}
			else{
				MessageBox.Show("您没有选择您要修改的记录！");
			}
		
		}

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

			if(zhi.ToString().Trim()!="")
			{

				DialogResult panduan=new DialogResult();
				panduan=MessageBox.Show("您确定删除当前预定吗?","确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
				if(panduan==DialogResult.Yes)
				{
					this.button2.Enabled=true;
					this.button3.Enabled=false;
					this.button4.Enabled=false;
					this.textBox1.Enabled=true;
					cs.ydsql ydsq=new bggl.cs.ydsql();
					bool pd=ydsq.delexe(zhi.ToString().Trim());
					if(pd==true)
					{
						MessageBox.Show("删除成功");
						setfjxl();
						zhi="";
						qk();
						setlv();

					}
					else
					{
						MessageBox.Show("删除失败，请重新操作!");
						setfjxl();
						zhi="";
						qk();
						setlv();
					}
				}
			}
			else{
				MessageBox.Show("您没有选择你要删除的记录!");
			}		
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void listView1_DoubleClick(object sender, System.EventArgs e)
		{
			
		}
		private void qk(){
			this.textBox1.Text="";
			this.textBox2.Text="";
			this.textBox3.Text="";
			this.textBox4.Text="";
			this.comboBox1.Text="";
		}

		private void button6_Click(object sender, System.EventArgs e)
		{
			cs.ydsql ydsq=new bggl.cs.ydsql();
			DataSet objset=new DataSet();
			objset=ydsq.selectexe();//调用cs.ydsql下的selectexe方法;
			this.listView1.Items.Clear();
			foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
			{
				if(this.textBox5.Text.Trim()==dr["yname"].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());
					lst.SubItems.Add(dr[7].ToString());

					this.listView1.Items.Add(lst);
				}

			}
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			this.textBox1.Enabled=true;
			this.button2.Enabled=true;
			this.button3.Enabled=false;
			this.button4.Enabled=false;
			setfjxl();
			zhi="";
			qk();
			setlv();
		}

		private void button7_Click(object sender, System.EventArgs e)
		{
			int x=Control.MousePosition.X;
			int y=Control.MousePosition.Y;
			hyxs hyx=new hyxs(this.textBox1,this.textBox4,3);
			//设置出现位置
			hyx.Location = new System.Drawing.Point(x, y);
			hyx.ShowDialog();
		}

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

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


		}

		private void kfyd_Closed(object sender, System.EventArgs e)
		{
			setlistView1();
		}
		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 button8_Click(object sender, System.EventArgs e)
		{
			int x=Control.MousePosition.X;
			int y=Control.MousePosition.Y;
			ydck yd=new ydck(this.comboBox1);
			//设置出现位置
			yd.Location = new System.Drawing.Point(x, y);
			yd.ShowDialog();
		}
		private void setlv1()
		{
			cs.ydsql ydsq=new bggl.cs.ydsql();
			DataSet objset=new DataSet();
			objset=ydsq.selectexe();//调用cs.ydsql下的selectexe方法;
			this.listView1.Items.Clear();
			foreach(DataRow dr in objset.Tables[0].Rows)//循环记录
			{
				if(fjh.Trim()==dr["yfj"].ToString())
				{
					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());
					lst.SubItems.Add(dr[7].ToString());

					this.listView1.Items.Add(lst);
				}

			}
		}
	}
}