form_mbwh.cs

一个很简单的考试系统。实用性很强啊！数据库在里面

			}
		}

		private void btn_tj_Click(object sender, System.EventArgs e)
		{
			this.btn_bj.Enabled=false;
			this.btn_sc.Enabled=false;
			if (this.change!=1)
			{
				System.Data.DataRow dr=dst.Tables[this.dataset_table].NewRow();
				dst.Tables[this.dataset_table].Rows.Add(dr);
				this.dgd_mbwh.UnSelect(this.dgd_mbwh.CurrentRowIndex);
				this.dgd_mbwh.CurrentRowIndex =dst.Tables[this.dataset_table].Rows.Count-1;
				this.dgd_mbwh.Select(this.dgd_mbwh.CurrentRowIndex);
				this.btn_qrtj.Enabled=true;
				this.btn_qx.Enabled=true;
				this.txt_bmms.Enabled=true;
				this.txt_bmgw.Enabled=true;
				this.TextEnTrue();
				this.change=1;
				this.btn_bj.Enabled=false;
//				if(this.dataset_table=="role")
//				{
//					this.txt_jsqxdm.Enabled=true;
////					this.txt_dm.Enabled=false;
//				}
			}
		}

		private void btn_qrtj_Click(object sender, System.EventArgs e)
		{
				if (this.txt_dm.Text!="")
				{
					//为了存入DataGrid中
					System.Data.DataRow drw =dst.Tables [this.dataset_table].NewRow ();
					this.dst.Tables[this.dataset_table].Rows.Add(drw);
					int index = dst.Tables[this.dataset_table].Rows.Count - 1;
					this.dgd_mbwh.UnSelect(this.dgd_mbwh.CurrentRowIndex );
					this.dgd_mbwh.CurrentRowIndex = index;
					this.dgd_mbwh.Select (this.dgd_mbwh.CurrentRowIndex );
					this.dgd_mbwh.UnSelect(this.dgd_mbwh.CurrentRowIndex );
					this.dgd_mbwh.CurrentRowIndex -=1;
					this.dgd_mbwh.Select (this.dgd_mbwh.CurrentRowIndex );
					dst.Tables [this.dataset_table].Rows[index].Delete ();
					this.dgd_mbwh.UnSelect(this.dgd_mbwh.CurrentRowIndex );
					this.dgd_mbwh.CurrentRowIndex = 0;
					this.dgd_mbwh.Select (this.dgd_mbwh.CurrentRowIndex);
					this.updata_data();
					this.txt_bmms.Enabled=false;
					this.txt_bmgw.Enabled=false;
					//this.change=0;//
				}
				else//
				{//
					MessageBox.Show("代码不能为空","阜和教育课程体系试题库系统提示");//
					this.dst.RejectChanges();//
				}//
			this.change=0;//
			this.TextEnFalse();//
			this.btn_bj.Enabled=true;//
			this.btn_tj.Enabled=true;//
			this.btn_sc.Enabled=true;//
			this.btn_qx.Enabled=false;//
			this.btn_qrtj.Enabled=false;//
//			this.txt_jsqxdm.Enabled=false;//
		}
		private void updata_data()
		{
			try
			{
				switch(this.dataset_table)
				{
					case "nation":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada1);
						sqlada1.Update(dst,"nation");
						break;
					}
					case "sex":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada2);
						sqlada2.Update(dst,"sex");				
						break;
					}
					case "PoliticalFeature":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada3);
						sqlada3.Update(dst,"PoliticalFeature");
						break;
					}
					case "Maritalstatus":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada4);
						sqlada4.Update(dst,"Maritalstatus");
						break;
					}
					case "nativePlace":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada5);
						sqlada5.Update(dst,"nativePlace");
						break;
					}
					case "cultureDegree":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada6);
						sqlada6.Update(dst,"cultureDegree");
						break;
					}
					case "field":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada7);
						sqlada7.Update(dst,"field");
						break;
					}
					case "technicalPosition":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada8);
						sqlada8.Update(dst,"technicalPosition");
						break;
					}
					case "role":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada9);
						sqlada9.Update(dst,"role");
						dst.Tables["role"].Clear();
						sqlada9=new System.Data.SqlClient.SqlDataAdapter("select * from role",this.sqlcon);
						sqlada9.Fill(dst,"role");
						break;
					}
					case "class":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada10);
						sqlada10.Update(dst,"class");
						dst.Tables["class"].Clear();
						sqlada10=new System.Data.SqlClient.SqlDataAdapter("select * from class",this.sqlcon);
						sqlada10.Fill(dst,"class");
						break;
					}
					case "Department":
					{
						System.Data.SqlClient.SqlCommandBuilder sqlcbu=new System.Data.SqlClient.SqlCommandBuilder(sqlada11);
						this.dst.Tables["Department"].AcceptChanges();
						break;
					}
				}
				this.dst.Tables[this.dataset_table].AcceptChanges();
			}
			catch(System.Exception error)
			{
				MessageBox.Show(error.Message,"阜和教育课程体系试题库系统提示");//
				this.dst.RejectChanges();
			}
		}

		private void btn_sc_Click(object sender, System.EventArgs e)
		{
			if (this.dst.Tables[this.dataset_table].Rows.Count > 0)
			{
				DialogResult result=MessageBox.Show("确认要删除吗？","阜和教育课程体系试题库系统提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);  
				if(result==DialogResult.Yes)
				{
					try//
					{//
						dst.Tables[this.dataset_table].Rows[this.dgd_mbwh.CurrentRowIndex].Delete();
						this.updata_data();
						dst.Tables[this.dataset_table].AcceptChanges();
					}//
					catch//
					{//
						MessageBox.Show("输入数据不正确!","阜和教育课程体系试题库系统提示");//
					}//
				}
			}
		}

		private void btn_qx_Click(object sender, System.EventArgs e)
		{
			this.btn_bj.Enabled=true;//
			this.btn_tj.Enabled=true;//
			this.btn_sc.Enabled=true;//
			this.btn_qx.Enabled=false;//
			this.btn_qrtj.Enabled=false;//
			this.dst.RejectChanges();
			TextEnFalse();
//			this.txt_jsqxdm.Enabled=false;
			this.btn_bj.Enabled=true;
			this.btn_tj.Enabled=true;
			this.btn_sc.Enabled=true;
			this.btn_qx.Enabled=false;
			this.btn_qrtj.Enabled=false;
			this.txt_bmms.Enabled=false;
			this.txt_bmgw.Enabled=false;
			this.change=0;//
		}

		private void dgd_mbwh_Click(object sender, System.EventArgs e)
		{
			if (this.change==1)
			{
				dst.RejectChanges();
				this.change=0;
			}
		}

		private void dgd_mbwh_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if(this.notable==1)
			{
//				this.txt_jsqxdm.Enabled=false;//
				this.btn_bj.Enabled=true;//
				this.btn_tj.Enabled=true;//
				this.btn_sc.Enabled=true;//
				this.btn_qx.Enabled=false;//
				this.btn_qrtj.Enabled=false;//
				if (e.Button==System.Windows.Forms.MouseButtons.Left)
				{
					Point pt = new Point(e.X,e.Y);
					DataGrid.HitTestInfo hit = this.dgd_mbwh.HitTest(pt);
					if(hit.Type == DataGrid.HitTestType.Cell)
					{
						this.dgd_mbwh.Select(hit.Row);
					}
					TextEnFalse();
					if (this.change==1)
					{
						dst.RejectChanges();
						this.change=0;
					}
				}
			}
		}

		private void pnl_mbwh1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
		{
		
		}

		private void btn_baj_Click(object sender, System.EventArgs e)
		{
			this.txt_bmgw.DataBindings.Clear();
			this.txt_bmms.DataBindings.Clear();
			this.lbl_bmms.Visible=false;
			this.lbl_bngw.Visible=false;
			this.txt_bmgw.Visible=false;
			this.txt_bmms.Visible=false;
			this.txt_dm.Text="";
			this.txt_mc.Text="";
			this.notable=1;
			DataGridTableStyle style=new DataGridTableStyle();
			style.MappingName="class";
			DataGridTextBoxColumn cla_no = new DataGridTextBoxColumn();
			cla_no.HeaderText = "班级代码";
			cla_no.MappingName = "cla_no";
			cla_no.Width = 100;

			DataGridTextBoxColumn cla_name = new DataGridTextBoxColumn();
			cla_name.HeaderText = "班级名称";
			cla_name.MappingName = "cla_name";
			cla_name.Width = 100;

			style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{cla_no,cla_name});
			this.dgd_mbwh.TableStyles.Clear ();
			this.dgd_mbwh.TableStyles.Add(style);

			this.txt_mc.DataBindings.Clear();
			this.txt_dm.DataBindings.Clear();
			this.EnTrue();
			this.dgd_mbwh.DataSource=dst;
			this.dgd_mbwh.DataMember="class";
			this.txt_dm.DataBindings.Add("text",dst,"class.cla_no");
			this.txt_mc.DataBindings.Add("text",dst,"class.cla_name");
			this.dataset_table="class";
			this.lbl_dm.Text="班级代码";
			this.lbl_mc.Text="班级名称";
//			this.lbl_jsqxdm.Visible=false;
//			this.txt_jsqxdm.Visible=false;
//			this.txt_jsqxdm.Enabled=false;
//			this.txt_jsqxdm.Visible=false;
			this.TextEnFalse();
			if (this.change==1)
			{
				dst.RejectChanges();
				this.change=0;
			}
		}

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

		private void button1_Click(object sender, System.EventArgs e)
		{
			if (this.dataset_table!="Department")
			{
				this.txt_bmgw.Text="";
				this.txt_bmms.Text="";
				this.lbl_bmms.Visible=true;
				this.lbl_bngw.Visible=true;
				this.txt_bmgw.Visible=true;
				this.txt_bmms.Visible=true;
				this.txt_bmms.Enabled=false;
				this.txt_bmgw.Enabled=false;
				this.txt_dm.Text="";
				this.txt_mc.Text="";
				this.notable=1;
				DataGridTableStyle style=new DataGridTableStyle();
				style.MappingName="Department";
				DataGridTextBoxColumn dep_departmentname = new DataGridTextBoxColumn();
				dep_departmentname.HeaderText = "部门名称";
				dep_departmentname.MappingName = "dep_departmentname";
				dep_departmentname.Width = 100;

				DataGridTextBoxColumn dep_departmentfunction = new DataGridTextBoxColumn();
				dep_departmentfunction.HeaderText = "部门职能";
				dep_departmentfunction.MappingName = "dep_departmentfunction";
				dep_departmentfunction.Width = 100;

				DataGridTextBoxColumn dep_departmentpost = new DataGridTextBoxColumn();
				dep_departmentpost.HeaderText = "部门岗位";
				dep_departmentpost.MappingName = "dep_departmentpost";
				dep_departmentpost.Width = 100;

				DataGridTextBoxColumn dep_departmentdetail = new DataGridTextBoxColumn();
				dep_departmentdetail.HeaderText = "部门描述";
				dep_departmentdetail.MappingName = "dep_departmentdetail";
				dep_departmentdetail.Width = 100;


				style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{dep_departmentname,dep_departmentfunction,dep_departmentpost,dep_departmentdetail});
				this.dgd_mbwh.TableStyles.Clear ();
				this.dgd_mbwh.TableStyles.Add(style);

				this.txt_mc.DataBindings.Clear();
				this.txt_dm.DataBindings.Clear();
				this.txt_bmgw.DataBindings.Clear();
				this.txt_bmms.DataBindings.Clear();
				this.EnTrue();
				this.dgd_mbwh.DataSource=dst;
				this.dgd_mbwh.DataMember="Department";
				try
				{
					this.txt_dm.DataBindings.Add("text",dst,"Department.dep_departmentname");
					this.txt_mc.DataBindings.Add("text",dst,"Department.dep_departmentfunction");
					this.txt_bmgw.DataBindings.Add("text",dst,"Department.dep_departmentpost");
					this.txt_bmms.DataBindings.Add("text",dst,"Department.dep_departmentdetail");
				}
				catch(System.Exception error)
				{
					MessageBox.Show(error.Message);
				}
				this.dataset_table="Department";
				this.lbl_dm.Text="岗位名称";
				this.lbl_mc.Text="岗位职能";
				//			this.lbl_jsqxdm.Visible=false;
				//			this.txt_jsqxdm.Visible=false;
				//			this.txt_jsqxdm.Enabled=false;
				//			this.txt_jsqxdm.Visible=false;
				this.TextEnFalse();
				if (this.change==1)
				{
					dst.RejectChanges();
					this.change=0;
				}
			}
		}

	}
}