form_jzg.cs

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

			{
				MessageBox.Show(m.Message);
			}
			this.cbb_isT.Items.Add("是");
			this.cbb_isT.Items.Add("否");
		}
		private void update_data()
		{
			try
			{
				System.Data.SqlClient.SqlCommand sqlcom_add=new System.Data.SqlClient.SqlCommand("UpdateEmployee",this.sqlcon);
				sqlcom_add.CommandType = CommandType.StoredProcedure;

				System.Data.SqlClient.SqlParameter myPara1=sqlcom_add.Parameters.Add("@emp_id",System.Data.SqlDbType.Char,6);
				myPara1.Value=this.txt_zjgbh.Text;
				myPara1.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara2=sqlcom_add.Parameters.Add("@natp_code",System.Data.SqlDbType.Char,6);
				myPara2.Value=this.GetValue("nativePlace","natp_name",this.cbb_jg1.Text);
				myPara2.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara3=sqlcom_add.Parameters.Add("@mars_code",System.Data.SqlDbType.Char,1);
				myPara3.Value=this.GetValue("Maritalstatus","mars_name",this.cbb_hyzk.Text);
				myPara3.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara4=sqlcom_add.Parameters.Add("@polf_code",System.Data.SqlDbType.Char,2);
				myPara4.Value=this.GetValue("PoliticalFeature","polf_name",this.cbb_zzmm.Text);
				myPara4.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara5=sqlcom_add.Parameters.Add("@culd_code",System.Data.SqlDbType.Char,2);
				myPara5.Value=this.GetValue("cultureDegree","culd_name",this.cbb_whcd.Text);
				myPara5.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara6=sqlcom_add.Parameters.Add("@rol_no",System.Data.SqlDbType.Int,18);
				myPara6.Value=this.GetValue("role","rol_name",this.cbb_js.Text);
				myPara6.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara7=sqlcom_add.Parameters.Add("@sex_code",System.Data.SqlDbType.Char,1);
				myPara7.Value=this.GetValue("sex","sex_name",this.cbb_xb.Text);
				myPara7.Direction = ParameterDirection.Input;
			
				System.Data.SqlClient.SqlParameter myPara8=sqlcom_add.Parameters.Add("@nat_code",System.Data.SqlDbType.Char,2);
				myPara8.Value=this.GetValue("nation","nat_name",this.cbb_mz.Text);
				myPara8.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara9=sqlcom_add.Parameters.Add("@tecp_code",System.Data.SqlDbType.Char,3);
				myPara9.Value=this.GetValue("technicalPosition","tecp_name",this.cbb_zyjszw.Text);
				myPara9.Direction = ParameterDirection.Input;
			
				System.Data.SqlClient.SqlParameter myPara10=sqlcom_add.Parameters.Add("@emp_name",System.Data.SqlDbType.VarChar,20);
				myPara10.Value=this.txt_xm.Text;
				myPara10.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara12=sqlcom_add.Parameters.Add("@emp_birthday",System.Data.SqlDbType.DateTime);
				myPara12.Value=this.dTP_csny.Text;
				myPara12.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara13=sqlcom_add.Parameters.Add("@emp_identityNo",System.Data.SqlDbType.Char,21);
				myPara13.Value=this.txt_sfzh.Text;
				myPara13.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara14=sqlcom_add.Parameters.Add("@emp_address",System.Data.SqlDbType.VarChar,50);
				myPara14.Value=this.txt_lxdh.Text;
				myPara14.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara15=sqlcom_add.Parameters.Add("@emp_tel",System.Data.SqlDbType.VarChar,16);
				myPara15.Value=this.txt_lxdh.Text;
				myPara15.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara16=sqlcom_add.Parameters.Add("@emp_postcode",System.Data.SqlDbType.Char,6);
				myPara16.Value=this.txt_yzbm.Text;
				myPara16.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara17=sqlcom_add.Parameters.Add("@emp_homeaddress",System.Data.SqlDbType.VarChar,50);
				myPara17.Value=this.txt_jtzz.Text;
				myPara17.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara18=sqlcom_add.Parameters.Add("@emp_hometel",System.Data.SqlDbType.VarChar,16);
				myPara18.Value=this.txt_jtdh.Text;
				myPara18.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara19=sqlcom_add.Parameters.Add("@emp_email",System.Data.SqlDbType.VarChar,30);
				myPara19.Value=this.txt_dzyx.Text;
				myPara19.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara20=sqlcom_add.Parameters.Add("@emp_college",System.Data.SqlDbType.VarChar,20);
				myPara20.Value=this.txt_byyx.Text;
				myPara20.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara21=sqlcom_add.Parameters.Add("@emp_speciality",System.Data.SqlDbType.VarChar,20);
				myPara21.Value=this.txt_zy.Text;
				myPara21.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara22=sqlcom_add.Parameters.Add("@emp_CertificateNo",System.Data.SqlDbType.VarChar,20);
				myPara22.Value=this.txt_jszgzbh.Text;
				myPara22.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara23=sqlcom_add.Parameters.Add("@emp_certificateDate",System.Data.SqlDbType.DateTime);
				myPara23.Value=this.dTP_fzrq.Text;
				myPara23.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara24=sqlcom_add.Parameters.Add("@emp_certificateDept",System.Data.SqlDbType.VarChar,30);
				myPara24.Value=this.txt_fzbm.Text;
				myPara24.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara25=sqlcom_add.Parameters.Add("@emp_propositionFirst",System.Data.SqlDbType.DateTime);
				myPara25.Value=this.dTP_sccymtsj.Text;
				myPara25.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara26=sqlcom_add.Parameters.Add("@emp_propositionRecent",System.Data.SqlDbType.DateTime);
				myPara26.Value=this.dTP_zjcymtsj.Text;
				myPara26.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara27=sqlcom_add.Parameters.Add("@emp_isTeacher",System.Data.SqlDbType.Char,1);
				if (this.cbb_isT.Text=="是")
					myPara27.Value='0';
				else
					myPara27.Value='1';
				myPara27.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara28=sqlcom_add.Parameters.Add("@emp_memo",System.Data.SqlDbType.VarChar,200);
				myPara28.Value=this.txt_bf.Text;
				myPara28.Direction = ParameterDirection.Input;

//				System.Data.SqlClient.SqlParameter myPara29=sqlcom_add.Parameters.Add("@emp_old",System.Data.SqlDbType.Char,6);
//				myPara29.Value=this.emp_id;
//				myPara29.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlDataReader sqlread=sqlcom_add.ExecuteReader();
				sqlread.Close();
				MessageBox.Show("编辑成功！","阜和教育课程体系试题库系统提示");
			}
			catch(System.Exception error)
			{
				MessageBox.Show(error.Message);
			}
		}
		private void insert_data()
		{
			try
			{
				System.Data.SqlClient.SqlCommand sqlcom_add=new System.Data.SqlClient.SqlCommand("InsertEmployee",this.sqlcon);
				sqlcom_add.CommandType = CommandType.StoredProcedure;

				System.Data.SqlClient.SqlParameter myPara1=sqlcom_add.Parameters.Add("@emp_id",System.Data.SqlDbType.Char,6);
				myPara1.Value=this.txt_zjgbh.Text;
				myPara1.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara2=sqlcom_add.Parameters.Add("@natp_code",System.Data.SqlDbType.Char,6);
				myPara2.Value=this.GetValue("nativePlace","natp_name",this.cbb_jg1.Text);
				myPara2.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara3=sqlcom_add.Parameters.Add("@mars_code",System.Data.SqlDbType.Char,1);
				myPara3.Value=this.GetValue("Maritalstatus","mars_name",this.cbb_hyzk.Text);
				myPara3.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara4=sqlcom_add.Parameters.Add("@polf_code",System.Data.SqlDbType.Char,2);
				myPara4.Value=this.GetValue("PoliticalFeature","polf_name",this.cbb_zzmm.Text);
				myPara4.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara5=sqlcom_add.Parameters.Add("@culd_code",System.Data.SqlDbType.Char,2);
				myPara5.Value=this.GetValue("cultureDegree","culd_name",this.cbb_whcd.Text);
				myPara5.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara6=sqlcom_add.Parameters.Add("@rol_no",System.Data.SqlDbType.Int,18);
				myPara6.Value=this.GetValue("role","rol_name",this.cbb_js.Text);
				myPara6.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara7=sqlcom_add.Parameters.Add("@sex_code",System.Data.SqlDbType.Char,1);
				myPara7.Value=this.GetValue("sex","sex_name",this.cbb_xb.Text);
				myPara7.Direction = ParameterDirection.Input;
			
				System.Data.SqlClient.SqlParameter myPara8=sqlcom_add.Parameters.Add("@nat_code",System.Data.SqlDbType.Char,2);
				myPara8.Value=this.GetValue("nation","nat_name",this.cbb_mz.Text);
				myPara8.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara9=sqlcom_add.Parameters.Add("@tecp_code",System.Data.SqlDbType.Char,3);
				myPara9.Value=this.GetValue("technicalPosition","tecp_name",this.cbb_zyjszw.Text);
				myPara9.Direction = ParameterDirection.Input;
			
				System.Data.SqlClient.SqlParameter myPara10=sqlcom_add.Parameters.Add("@emp_name",System.Data.SqlDbType.VarChar,20);
				myPara10.Value=this.txt_xm.Text;
				myPara10.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara12=sqlcom_add.Parameters.Add("@emp_birthday",System.Data.SqlDbType.DateTime);
				myPara12.Value=this.dTP_csny.Text;
				myPara12.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara13=sqlcom_add.Parameters.Add("@emp_identityNo",System.Data.SqlDbType.Char,21);
				myPara13.Value=this.txt_sfzh.Text;
				myPara13.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara14=sqlcom_add.Parameters.Add("@emp_address",System.Data.SqlDbType.VarChar,50);
				myPara14.Value=this.txt_lxdh.Text;
				myPara14.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara15=sqlcom_add.Parameters.Add("@emp_tel",System.Data.SqlDbType.VarChar,16);
				myPara15.Value=this.txt_lxdh.Text;
				myPara15.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara16=sqlcom_add.Parameters.Add("@emp_postcode",System.Data.SqlDbType.Char,6);
				myPara16.Value=this.txt_yzbm.Text;
				myPara16.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara17=sqlcom_add.Parameters.Add("@emp_homeaddress",System.Data.SqlDbType.VarChar,50);
				myPara17.Value=this.txt_jtzz.Text;
				myPara17.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara18=sqlcom_add.Parameters.Add("@emp_hometel",System.Data.SqlDbType.VarChar,16);
				myPara18.Value=this.txt_jtdh.Text;
				myPara18.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara19=sqlcom_add.Parameters.Add("@emp_email",System.Data.SqlDbType.VarChar,30);
				myPara19.Value=this.txt_dzyx.Text;
				myPara19.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara20=sqlcom_add.Parameters.Add("@emp_college",System.Data.SqlDbType.VarChar,20);
				myPara20.Value=this.txt_byyx.Text;
				myPara20.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara21=sqlcom_add.Parameters.Add("@emp_speciality",System.Data.SqlDbType.VarChar,20);
				myPara21.Value=this.txt_zy.Text;
				myPara21.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara22=sqlcom_add.Parameters.Add("@emp_CertificateNo",System.Data.SqlDbType.VarChar,20);
				myPara22.Value=this.txt_jszgzbh.Text;
				myPara22.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara23=sqlcom_add.Parameters.Add("@emp_certificateDate",System.Data.SqlDbType.DateTime);
				myPara23.Value=this.dTP_fzrq.Text;
				myPara23.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara24=sqlcom_add.Parameters.Add("@emp_certificateDept",System.Data.SqlDbType.VarChar,30);
				myPara24.Value=this.txt_fzbm.Text;
				myPara24.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara25=sqlcom_add.Parameters.Add("@emp_propositionFirst",System.Data.SqlDbType.DateTime);
				myPara25.Value=this.dTP_sccymtsj.Text;
				myPara25.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara26=sqlcom_add.Parameters.Add("@emp_propositionRecent",System.Data.SqlDbType.DateTime);
				myPara26.Value=this.dTP_zjcymtsj.Text;
				myPara26.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara27=sqlcom_add.Parameters.Add("@emp_isTeacher",System.Data.SqlDbType.Char,1);
				if (this.cbb_isT.Text=="是")
					myPara27.Value='0';
				else
					myPara27.Value='1';
				myPara27.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlParameter myPara28=sqlcom_add.Parameters.Add("@emp_memo",System.Data.SqlDbType.VarChar,200);
				myPara28.Value=this.txt_bf.Text;
				myPara28.Direction = ParameterDirection.Input;

				System.Data.SqlClient.SqlDataReader sqlread=sqlcom_add.ExecuteReader();
				sqlread.Close();

				MessageBox.Show("添加成功！","阜和教育课程体系试题库系统提示");
			}
			catch(System.Exception error)
			{
				MessageBox.Show(error.Message);
			}
		}
		private void LianJie()
		{
			dbAccess dab=new dbAccess();
			string select = "Select emp_id as 教职工编号,emp_name as 姓名,sex.sex_name as 性别,nation.nat_name as 民族,"
				+"emp_birthday as '出生年月',nativePlace.natp_name as '籍贯',PoliticalFeature.polf_name as '政治面貌',"
				+"Maritalstatus.mars_name as '婚姻状况',emp_identityNo as '身份证号',emp_address as '联系地址',"
				+"emp_tel as '联系电话',emp_email as '电子邮箱',emp_postcode as '邮政编码',emp_hometel as '家庭住址',"
				+"emp_hometel as '家庭电话',cultureDegree.culd_name as '文化程度',emp_college as '毕业院校',"
				+"emp_speciality as '专业',technicalPosition.tecp_name as '专业技术职务',emp_CertificateNo as '教师资格证编号',"
				+"emp_certificateDate as '发证日期',emp_certificateDept as '发证部门',emp_isTeacher as '是否教师',"
				+"emp_propositionFirst as '首次参与命题时间',emp_propositionRecent as '最近参与命题时间',"
				+"role.rol_name as '角色',emp_memo as '备注' from Employee,sex,nation,technicalPosition,Maritalstatus,role,"
				+"PoliticalFeature,cultureDegree,nativePlace where sex.sex_code=Employee.sex_code and"
				+" nation.nat_code=Employee.nat_code and technicalPosition.tecp_code=Employee.tecp_code "
				+"and Maritalstatus.mars_code=Employee.mars_code and PoliticalFeature.polf_code=Employee.polf_code "
				+"and cultureDegree.culd_code=Employee.culd_code and nativePlace.natp_code = Employee.natp_code"
				+" and role.rol_no=Employee.rol_no";
			System.Data.SqlClient.SqlDataAdapter sqldat=new System.Data.SqlClient.SqlDataAdapter(select,dab.connStr);
			sqldat.Fill(dat,this.table_name);
			for(int i=0 ; i<dat.Tables[this.table_name].Rows.Count;i++)
			{
				if(int.Parse(dat.Tables[this.table_name].Rows[i]["是否教师"].ToString())==0)
					dat.Tables[this.table_name].Rows[i]["是否教师"]='是';
				else
					dat.Tables[this.table_name].Rows[i]["是否教师"]='否';
			}
		}

		private void btn_qyjr_Click(object sender, System.EventArgs e)
		{
			this.btn_sc.Enabled=true;
			this.btn_bj.Enabled=true;
			this.btn_tj.Enabled=true;
			this.btn_qx.Enabled=false;
			this.btn_qdtj.Enabled=false;
			if(dgd_jzg.CurrentRowIndex!=0)
			{
				dgd_jzg.UnSelect(dgd_jzg.CurrentRowIndex);
				dgd_jzg.CurrentRowIndex -=1;
				dgd_jzg.Select(dgd_jzg.CurrentRowIndex);
			}
			this.ConEnbFalse();
			if(this.IsEorI==2)
			{
				this.dat.RejectChanges();
				this.IsEorI=0;
				this.txt_xm.DataBindings.Add("text",dat,this.table_name+".姓名");
				this.txt_zjgbh.DataBindings.Add("text",dat,this.table_name+".教职工编号");
				this.cbb_xb.DataBindings.Add("text",dat,this.table_name+".性别");
				this.cbb_mz.DataBindings.Add("text",dat,this.table_name+".民族");
				this.dTP_csny.DataBindings.Add("Value",dat,this.table_name+".出生年月");
				this.cbb_jg1.DataBindings.Add("text",dat,this.table_name+".籍贯");
				this.cbb_zzmm.