ysheng.aspx.cs

B/S结构的医院管理软件含数据库

			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职务", System.Data.SqlDbType.NVarChar, 20));
			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.NVarChar, 20));
			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@邮箱", System.Data.SqlDbType.NVarChar, 20));
			this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@家庭地址", System.Data.SqlDbType.NVarChar, 50));
			this.Button8.Click += new System.EventHandler(this.Button8_Click);
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dsa1)).EndInit();

		}
		#endregion

		

		private void fills()
		{
		
			if(cnn.State==0) cnn.Open();
			sda.SelectCommand.ExecuteNonQuery();
			dsa1.Clear(); 
			sda.Fill(dsa1); 
			cnn.Close();
			DataGrid1.DataBind(); 
			
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			
			if(cnn.State==0) cnn.Open();
			sda1.SelectCommand.Parameters["@sel"].Value=TextBox1.Text;
			sda1.SelectCommand.Parameters["@name"].Value=TextBox2.Text;
			sda1.SelectCommand.ExecuteNonQuery ();
			this.dsa1.Clear();
			this.sda1.Fill(dsa1);
			this.DataGrid1.DataBind();
			cnn.Close();
	
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			Panel2.Visible =true;
            Submit.Visible =false;
			
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			Panel1.Visible =true;
//			this.DataGrid1.SelectedIndex=-1;
			
		}

		private void Button6_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.SelectedIndex==-1)
			{
				Response.Write("<script language=javascript>alert('你还没选择！');</script>") ;
			}
			else
			{
				Panel2.Visible =true;

				Submit.Text="修改";
				Button7.Visible =false;
				if(cnn.State==0) cnn.Open();
				cmd1.Parameters["@id"].Value=Convert.ToInt32(DataGrid1.SelectedItem.Cells[1].Text);
				SqlDataReader rd=cmd1.ExecuteReader();
				while (rd.Read())
				{
					tname.Text=rd.GetValue(1).ToString();
					tjg.Text=rd.GetValue(4).ToString();
					tzz.Text =rd.GetValue(5).ToString();
					
					tdh.Text=rd.GetValue(9).ToString();
					tem.Text =rd.GetValue(10).ToString();
					tdz.Text =rd.GetValue(11).ToString();

				}
			}
			
		}

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

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			Panel2.Visible =false;


		}

		private void Submit_Click(object sender, System.EventArgs e)
		{
			Panel2.Visible =false;
			if(this.File1.Value=="")
			{
				Response.Write("<script language=javascript>alert('你还没选择图片路径！')</script>") ;
				return;
			}
			else
			{
			
				string file=File1.PostedFile.FileName ;
				string type=file.Substring(file.LastIndexOf(".")+1);
				byte[] fileCont = new byte[File1.PostedFile.ContentLength];
				File1.PostedFile.InputStream.Read(fileCont,0,(int)File1.PostedFile.ContentLength); //将文件流中的内容转成byte数组
				if(cnn.State==0) cnn.Open();
				cmd.Parameters["@put"].Value=Submit.Text;
				if(Submit.Text=="上传")
				{
				   cmd.Parameters["@id"].Value=11;
	
				}
				else
				{
					cmd.Parameters["@id"].Value=DataGrid1.SelectedItem.Cells[1].Text;
				}
				cmd.Parameters["@mydata"].Value = fileCont ; 			
				cmd.Parameters ["@姓名"].Value =tname.Text ;
				cmd.Parameters ["@性别"].Value =r1.SelectedValue ;
				cmd.Parameters ["@出生年月"].Value =d1.SelectedValue + "-" + d2.SelectedValue;
				cmd.Parameters ["@籍贯"].Value =tjg.Text  ;
				cmd.Parameters ["@种族"].Value =tzz.Text  ;
				cmd.Parameters ["@政治面貌"].Value =d3.SelectedValue;
				cmd.Parameters ["@学历"].Value =d4.SelectedValue  ;
				cmd.Parameters ["@职务"].Value =d6.SelectedValue  ;
				cmd.Parameters ["@电话"].Value =tdh.Text  ;
				cmd.Parameters ["@邮箱"].Value =tem.Text  ;
				cmd.Parameters ["@家庭地址"].Value =tdz.Text  ;
				cmd.ExecuteNonQuery();
				cnn.Close();
//				fills();
//				Response.Write("<script language=javascript>alert('恭喜你！！！你已成功的填完！')</script>") ;                 
				string kk="";
				if(Submit.Text=="上传")
				{
					kk="添加成功！";
				}
				else
				{
					kk="修改成功！";
				}
				Response.Write("<script language=javascript>alert('"+kk+"');</script>") ;
				fills();
				this.DataGrid1.SelectedIndex=-1;
				tname.Text="";
				tjg.Text="";
				tzz.Text ="";
				
				tdh.Text="";
				tem.Text ="";
				tdz.Text ="";
			}
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.SelectedIndex==-1)
			{
				Response.Write("<script language=javascript>alert('你还没选择！');</script>") ;
			}
			else
			{
		
				if(cnn.State==0) cnn.Open();
				sda.DeleteCommand.Parameters["@id"].Value=DataGrid1.SelectedItem.Cells[1].Text;
				sda.DeleteCommand.ExecuteNonQuery ();
				cnn.Close();
				fills();
				this.DataGrid1.SelectedIndex=-1;

			}
		}

		private void Button7_Click(object sender, System.EventArgs e)
		{
			Panel2.Visible =false;
			if(this.File1.Value=="")
			{
				Response.Write("<script language=javascript>alert('你还没选择图片路径！')</script>") ;
				return;
			}
			else
			{
			
				string file=File1.PostedFile.FileName ;
				string type=file.Substring(file.LastIndexOf(".")+1);
				byte[] fileCont = new byte[File1.PostedFile.ContentLength];
				File1.PostedFile.InputStream.Read(fileCont,0,(int)File1.PostedFile.ContentLength); //将文件流中的内容转成byte数组
				if(cnn.State==0) cnn.Open();
				cmd2.Parameters["@mydata"].Value = fileCont ; 			
				cmd2.Parameters ["@姓名"].Value =tname.Text ;
				cmd2.Parameters ["@性别"].Value =r1.SelectedValue ;
				cmd2.Parameters ["@出生年月"].Value =d1.SelectedValue + "-" + d2.SelectedValue;
				cmd2.Parameters ["@籍贯"].Value =tjg.Text  ;
				cmd2.Parameters ["@种族"].Value =tzz.Text  ;
				cmd2.Parameters ["@政治面貌"].Value =d3.SelectedValue;
				cmd2.Parameters ["@学历"].Value =d4.SelectedValue  ;
				cmd2.Parameters ["@职务"].Value =d6.SelectedValue  ;
				cmd2.Parameters ["@电话"].Value =tdh.Text  ;
				cmd2.Parameters ["@邮箱"].Value =tem.Text  ;
				cmd2.Parameters ["@家庭地址"].Value =tdz.Text  ;
				cmd2.ExecuteNonQuery();
				cnn.Close();
				fills();
				
			}
		}

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

		

	}
}