form_xy.cs

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

			this.txt_zcf.DataBindings.Add("text",dat,table_name+".住宿费");
			this.txt_jl.DataBindings.Add("text",dat,table_name+".简历");
			this.txt_bz.DataBindings.Add("text",dat,table_name+".备注");
		}
		private void Combo_Add()
		{
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from sex",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"sex");
				foreach (DataRow dater in dat_mb.Tables["sex"].Rows )
				{
					this.cbb_xb.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from nation",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"nation");
				foreach (DataRow dater in dat_mb.Tables["nation"].Rows )
				{
					this.cbb_mz.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from technicalPosition",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"technicalPosition");
				foreach (DataRow dater in dat_mb.Tables["technicalPosition"].Rows )
				{
					this.cbb_zyjszw.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from Maritalstatus",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"Maritalstatus");
				foreach (DataRow dater in dat_mb.Tables["Maritalstatus"].Rows )
				{
					this.cbb_hyzk.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from PoliticalFeature",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"PoliticalFeature");
				foreach (DataRow dater in dat_mb.Tables["PoliticalFeature"].Rows )
				{
					this.cbb_zzmm.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from cultureDegree",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"cultureDegree");
				foreach (DataRow dater in dat_mb.Tables["cultureDegree"].Rows )
				{
					this.cbb_whcd.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}

			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from nativePlace",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"nativePlace");
				foreach (DataRow dater in dat_mb.Tables["nativePlace"].Rows )
				{
					this.cbb_jg.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from field",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"field");
				foreach (DataRow dater in dat_mb.Tables["field"].Rows )
				{
					this.cbb_hy.Items.Add(dater[1]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			try
			{
				System.Data.DataSet dat_mb=new System.Data.DataSet();
				System.Data.SqlClient.SqlCommand sqlcom_sex=new System.Data.SqlClient.SqlCommand();
				System.Data.SqlClient.SqlConnection sqlcon=new System.Data.SqlClient.SqlConnection();
				System.Data.SqlClient.SqlDataAdapter sqlada_mb=new System.Data.SqlClient.SqlDataAdapter("select * from class",
					this.sqlcon);
				sqlada_mb.Fill(dat_mb,"class");
				foreach (DataRow dater in dat_mb.Tables["class"].Rows )
				{
					this.cbb_bj.Items.Add(dater["cla_name"]);
				}
				this.ConEnbTrue();
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
			this.cbb_xxfs.Items.Add("全日制");
			this.cbb_xxfs.Items.Add("半脱产");
			this.cbb_xxfs.Items.Add("双休日");
			this.cbb_xxfs.Items.Add("其它");
		}
		private void ConEnbFalse()
		{
			this.txt_xh.Enabled=false;
			this.txt_xm.Enabled=false;
			this.txt_zyjs.Enabled=false;
			this.cbb_xb.Enabled=false;
			this.dtp_csny.Enabled=false;
			this.txt_yzbm.Enabled=false;
			this.txt_jtdz.Enabled=false;
			this.txt_lxdh.Enabled=false;
			this.txt_jtdh.Enabled=false;
			this.cbb_xxfs.Enabled=false;
			this.txt_sfzh.Enabled=false;
			this.cbb_bj.Enabled=false;
			this.dtp_bnrq.Enabled=false;
			this.cbb_jg.Enabled=false;
			this.cbb_mz.Enabled=false;
			this.cbb_zzmm.Enabled=false;
			this.cbb_hyzk.Enabled=false;
			this.txt_gzdw.Enabled=false;
			this.txt_yj.Enabled=false;
			this.txt_txdz.Enabled=false;
			this.cbb_hy.Enabled=false;
			this.txt_zw.Enabled=false;
			this.txt_dzyj.Enabled=false;
			this.txt_xl.Enabled=false;
			this.cbb_whcd.Enabled=false;
			this.cbb_zyjszw.Enabled=false;
			this.txt_wycd.Enabled=false;
			this.txt_byyx.Enabled=false;
			this.txt_xf.Enabled=false;
			this.txt_jcf.Enabled=false;
			this.txt_dnnl.Enabled=false;
			this.dtp_kbrq.Enabled=false;
			this.txt_zcf.Enabled=false;
			this.txt_jl.Enabled=false;
			this.txt_bz.Enabled=false;
			this.btn_xhcx.Enabled=false;//
			this.btn_sfzhcx.Enabled=false;//
			this.btn_xmcx.Enabled=false;
		}
		private void ConEnbTrue()
		{
			this.txt_xh.Enabled=true;
			this.txt_zyjs.Enabled=true;
			this.txt_xm.Enabled=true;
			this.cbb_xb.Enabled=true;
			this.dtp_csny.Enabled=true;
			this.txt_yzbm.Enabled=true;
			this.txt_jtdz.Enabled=true;
			this.txt_lxdh.Enabled=true;
			this.txt_jtdh.Enabled=true;
			this.cbb_xxfs.Enabled=true;
			this.txt_sfzh.Enabled=true;
			this.cbb_bj.Enabled=true;
			this.dtp_bnrq.Enabled=true;
			this.cbb_jg.Enabled=true;
			this.txt_yj.Enabled=true;
			this.cbb_mz.Enabled=true;
			this.cbb_zzmm.Enabled=true;
			this.cbb_hyzk.Enabled=true;
			this.txt_gzdw.Enabled=true;
			this.txt_txdz.Enabled=true;
			this.cbb_hy.Enabled=true;
			this.txt_zw.Enabled=true;
			this.txt_dzyj.Enabled=true;
			this.txt_xl.Enabled=true;
			this.cbb_whcd.Enabled=true;
			this.cbb_zyjszw.Enabled=true;
			this.txt_wycd.Enabled=true;
			this.txt_byyx.Enabled=true;
			this.txt_xf.Enabled=true;
			this.txt_jcf.Enabled=true;
			this.txt_dnnl.Enabled=true;
			this.dtp_kbrq.Enabled=true;
			this.txt_zcf.Enabled=true;
			this.txt_jl.Enabled=true;
			this.txt_bz.Enabled=true;
		}

		private void btn_tj_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.btn_xhcx.Enabled=false;//
				this.btn_sfzhcx.Enabled=false;//
				this.btn_sc.Enabled=false;
				this.btn_qx.Enabled=true;
				this.btn_qdtj.Enabled=true;
				this.btn_bj.Enabled=false;
				if (this.dat.Tables[this.table_name].Rows.Count==0)
				{
					this.cbb_xb.Text=this.cbb_xb.Items[0].ToString();
					this.cbb_mz.Text=this.cbb_mz.Items[0].ToString();
					this.cbb_zyjszw.Text=this.cbb_zyjszw.Items[0].ToString();
					this.cbb_hyzk.Text=this.cbb_hyzk.Items[0].ToString();
					this.cbb_zzmm.Text=this.cbb_zzmm.Items[0].ToString();
					this.cbb_whcd.Text=this.cbb_whcd.Items[0].ToString();
					this.cbb_jg.Text=this.cbb_jg.Items[0].ToString();
					this.cbb_hy.Text=this.cbb_hy.Items[0].ToString();
					this.cbb_bj.Text=this.cbb_bj.Items[0].ToString();
					this.cbb_xxfs.Text=this.cbb_xxfs.Items[0].ToString();
					this.txt_zyjs.DataBindings.Clear();
					this.txt_yj.DataBindings.Clear();
					this.txt_xh.DataBindings.Clear();
					this.txt_xm.DataBindings.Clear();
					this.cbb_xb.DataBindings.Clear();
					this.dtp_csny.DataBindings.Clear();
					this.txt_yzbm.DataBindings.Clear();
					this.txt_jtdz.DataBindings.Clear();
					this.txt_lxdh.DataBindings.Clear();
					this.txt_jtdh.DataBindings.Clear();
					this.cbb_xxfs.DataBindings.Clear();
					this.txt_sfzh.DataBindings.Clear();
					this.cbb_bj.DataBindings.Clear();
					this.dtp_bnrq.DataBindings.Clear();
					this.cbb_jg.DataBindings.Clear();
					this.cbb_mz.DataBindings.Clear();
					this.cbb_zzmm.DataBindings.Clear();
					this.cbb_hyzk.DataBindings.Clear();
					this.txt_gzdw.DataBindings.Clear();
					this.txt_txdz.DataBindings.Clear();
					this.cbb_hy.DataBindings.Clear();
					this.txt_zw.DataBindings.Clear();
					this.txt_dzyj.DataBindings.Clear();
					this.txt_xl.DataBindings.Clear();
					this.cbb_whcd.DataBindings.Clear();
					this.cbb_zyjszw.DataBindings.Clear();
					this.txt_wycd.DataBindings.Clear();
					this.txt_byyx.DataBindings.Clear();
					this.txt_xf.DataBindings.Clear();
					this.txt_jcf.DataBindings.Clear();
					this.txt_dnnl.DataBindings.Clear();
					this.dtp_kbrq.DataBindings.Clear();
					this.txt_zcf.DataBindings.Clear();
					this.txt_jl.DataBindings.Clear();
					this.txt_bz.DataBindings.Clear();
					System.Data.DataRow daw=dat.Tables[this.table_name].NewRow();
					dat.Tables[this.table_name].Rows.Add(daw);
					this.TextbomNull();
					this.ConEnbTrue();
					this.IsEorI=2;
					this.txt_xf.Text=Convert.ToString(0.00);
					this.txt_jcf.Text=Convert.ToString(0.00);
					this.txt_zcf.Text=Convert.ToString(0.00);
					this.txt_yj.Text=Convert.ToString(0.00);
				}
				else
				{
					if (this.IsEorI!=2)
					{
						this.txt_zyjs.DataBindings.Clear();
						this.txt_yj.DataBindings.Clear();
						this.txt_xh.DataBindings.Clear();
						this.txt_xm.DataBindings.Clear();
						this.cbb_xb.DataBindings.Clear();
						this.dtp_csny.DataBindings.Clear();
						this.txt_yzbm.DataBindings.Clear();
						this.txt_jtdz.DataBindings.Clear();
						this.txt_lxdh.DataBindings.Clear();
						this.txt_jtdh.DataBindings.Clear();
						this.cbb_xxfs.DataBindings.Clear();
						this.txt_sfzh.DataBindings.Clear();
						this.cbb_bj.DataBindings.Clear();
						this.dtp_bnrq.DataBindings.Clear();
						this.cbb_jg.DataBindings.Clear();
						this.cbb_mz.DataBindings.Clear();
						this.cbb_zzmm