// sda1
			// 
			this.sda1.DeleteCommand = this.sqlDeleteCommand2;
			this.sda1.InsertCommand = this.sqlInsertCommand2;
			this.sda1.SelectCommand = this.sqlSelectCommand2;
			this.sda1.UpdateCommand = this.sqlUpdateCommand2;
			// 
			// zhuyuan1
			// 
			this.zhuyuan1.DataSetName = "zhuyuan";
			this.zhuyuan1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// cmd1
			// 
			this.cmd1.CommandText = "[zy]";
			this.cmd1.CommandType = System.Data.CommandType.StoredProcedure;
			this.cmd1.Connection = this.cnn;
			this.cmd1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			this.cmd1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4));
			// 
			// sqlSelectCommand3
			// 
			this.sqlSelectCommand3.CommandText = "[z2]";
			this.sqlSelectCommand3.CommandType = System.Data.CommandType.StoredProcedure;
			this.sqlSelectCommand3.Connection = this.cnn;
			this.sqlSelectCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			// 
			// sda3
			// 
			this.sda3.DeleteCommand = this.sqlDeleteCommand3;
			this.sda3.InsertCommand = this.sqlInsertCommand3;
			this.sda3.SelectCommand = this.sqlSelectCommand3;
			this.sda3.UpdateCommand = this.sqlUpdateCommand3;
			// 
			// cmd2
			// 
			this.cmd2.CommandText = "[z3]";
			this.cmd2.CommandType = System.Data.CommandType.StoredProcedure;
			this.cmd2.Connection = this.cnn;
			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4));
			// 
			// sda31
			// 
			this.sda31.DataSetName = "sda3";
			this.sda31.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlSelectCommand4
			// 
			this.sqlSelectCommand4.CommandText = "[z4]";
			this.sqlSelectCommand4.CommandType = System.Data.CommandType.StoredProcedure;
			this.sqlSelectCommand4.Connection = this.cnn;
			this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@num", System.Data.SqlDbType.NVarChar, 10));
			// 
			// sda4
			// 
			this.sda4.DeleteCommand = this.sqlDeleteCommand4;
			this.sda4.InsertCommand = this.sqlInsertCommand4;
			this.sda4.SelectCommand = this.sqlSelectCommand4;
			this.sda4.UpdateCommand = this.sqlUpdateCommand4;
			this.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid2_PageIndexChanged);
			this.DataGrid2.SelectedIndexChanged += new System.EventHandler(this.DataGrid2_SelectedIndexChanged_1);
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.zhu1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.allpepole1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.zhuyuan1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.sda31)).EndInit();

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{    
			try
			{
			if(cnn.State==0) cnn.Open();
			cmd.Parameters["@床號"].Value=tch.Text;
			cmd.Parameters["@掛號號碼"].Value=tnum.Text;
			cmd.Parameters["@姓名"].Value =tname.Text ;
			cmd.Parameters ["@年齡"].Value=tage.Text ;
			cmd.Parameters ["@性別"].Value=r1.SelectedValue ;
			cmd.Parameters ["@級別"].Value=d1.SelectedValue ;
			cmd.Parameters ["@負責人"].Value=d2.SelectedValue ;
			cmd.Parameters ["@進出實況"].Value=d3.SelectedValue ;
			cmd.ExecuteNonQuery();
             Response.Write("<script language=javascript>alert('入院成功！');</script>") ;
			}
			catch
			{
				Response.Write("<script language=javascript>alert('床號或掛號號碼存在！');</script>") ;
			}
			cnn.Close();
			fills();
			fill();


		}
		private void fill()
		{
		if(cnn.State==0) cnn.Open();
          sda.SelectCommand.ExecuteNonQuery();
			sda31.Clear();
			sda3.Fill(sda31);
			cnn.Close();
			this.DataGrid2.DataBind();
		}
		private void fills()
		{
		
			if(cnn.State==0) cnn.Open();
			sda.SelectCommand.ExecuteNonQuery();
			zhu1.Clear(); 
			sda.Fill(zhu1); 
			cnn.Close();
			DataGrid1.DataBind(); 
			
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			fills();
		}

		private void Button4_Click(object sender, System.EventArgs e)
		{
			p1.Visible =true;
		   this.Image2 .Visible =false;
			this.DataGrid2.Visible=true;
			//			this.Button4.Visible=false;
			//            this.Button3.Visible=false;
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
//			p1.Visible =false;
//			Response.Redirect("bedzhao.aspx");
			if(cnn.State==0) cnn.Open();
			sda4.SelectCommand.Parameters["@num"].Value=TextBox1.Text;
			sda4.SelectCommand.ExecuteNonQuery ();
			sda31.Clear();
			sda4.Fill(sda31);
			cnn.Close();
			this.DataGrid2.DataBind();
		}
		

		private void DataGrid2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//			this.DataGrid2.CurrentPageIndex=e.NewPageIndex;
			//			fill();
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			if(cnn.State==0) cnn.Open();
			sda.UpdateCommand.Parameters["@床號"].Value=tch.Text;
			sda.UpdateCommand.Parameters["@掛號號碼"].Value=tnum.Text;
			sda.UpdateCommand.Parameters["@姓名"].Value =tname.Text ;
			sda.UpdateCommand.Parameters ["@年齡"].Value=tage.Text ;
			sda.UpdateCommand.Parameters ["@性別"].Value=r1.SelectedValue ;
			sda.UpdateCommand.Parameters ["@級別"].Value=d1.SelectedValue ;
			sda.UpdateCommand.Parameters ["@負責人"].Value=d2.SelectedValue ;
			sda.UpdateCommand.Parameters ["@進出實況"].Value=d3.SelectedValue ;
			sda.UpdateCommand.ExecuteNonQuery();
			cnn.Close();
			Response.Write("<script language=javascript>alert('你已經康復，成功出院！');</script>") ;
			fills();
			fill();
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			p1.Visible =false;
			this.Image2.Visible =true;
//				if(cnn.State==0) cnn.Open();
//			cmd1.Parameters["@id"].Value=Convert.ToString(DataGrid1.SelectedItem.Cells[1].Text);
//			SqlDataReader rd=cmd1.ExecuteReader();
//			while (rd.Read())
//			{
//				tch.Text =rd.GetValue(1).ToString();
//				
//			}
			

		}

		private void DataGrid2_SelectedIndexChanged_1(object sender, System.EventArgs e)
		{
			if(cnn.State==0) cnn.Open();
			cmd2.Parameters["@id"].Value=Convert.ToString(DataGrid2.SelectedItem.Cells[0].Text);
			SqlDataReader rd=cmd2.ExecuteReader();
			while (rd.Read())
			{
				tch.Text =rd.GetValue(1).ToString();
				tnum.Text =rd.GetValue(0).ToString();
				tname.Text =rd.GetValue(2).ToString();
//				tage.Text =rd.GetValue(4).ToString();
			}
			
		}

		private void DataGrid2_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid2.CurrentPageIndex = e.NewPageIndex;
			fill();
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("index.aspx");
		}

		

	}
	
		
	
}