form_xycx.cs

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

			this.rdb_tbcx.TabIndex = 1;
			this.rdb_tbcx.Text = "特别查询";
			this.rdb_tbcx.CheckedChanged += new System.EventHandler(this.rdb_tbcx_CheckedChanged);
			// 
			// rdb_zhcx
			// 
			this.rdb_zhcx.Location = new System.Drawing.Point(24, 32);
			this.rdb_zhcx.Name = "rdb_zhcx";
			this.rdb_zhcx.TabIndex = 0;
			this.rdb_zhcx.Text = "综合查询";
			this.rdb_zhcx.CheckedChanged += new System.EventHandler(this.rdb_zhcx_CheckedChanged);
			// 
			// Form_xycx
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(792, 573);
			this.Controls.AddRange(new System.Windows.Forms.Control[] {
																		  this.gpb_cxfs,
																		  this.dgd_xycx,
																		  this.gpb_tbcx,
																		  this.gpb_zhcx});
			this.Name = "Form_xycx";
			this.Text = "学员资料查询";
			this.Load += new System.EventHandler(this.Form_xycx_Load);
			this.gpb_zhcx.ResumeLayout(false);
			this.gpb_tbcx.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dgd_xycx)).EndInit();
			this.gpb_cxfs.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void Form_xycx_Load(object sender, System.EventArgs e)
		{
			this.gpb_zhcx.Enabled=false;
			this.gpb_tbcx.Enabled=false;
			dbAccess aba=new dbAccess();
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.ControlBox = false;
			try
			{
				this.cbb_mz.Enabled=false;
				this.cbb_bj.Enabled=false;
				this.cbb_xb.Enabled=false;
				this.txt_xm.Enabled=false;
				System.Data.SqlClient.SqlDataAdapter sqlada=new System.Data.SqlClient.SqlDataAdapter
					("select getdate()",aba.connStr);
				System.Data.DataSet dst=new System.Data.DataSet();
				sqlada.Fill(dst);
				this.ddtp_bmrq1.Text=dst.Tables[0].Rows[0][0].ToString();
				this.ddtp_bmrq2.Text=dst.Tables[0].Rows[0][0].ToString();
			}
			catch(System.Exception error)
			{
				MessageBox.Show(error.Message);
			}
			this.Combo_Add();
		}

		private void dgd_xycx_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if (e.Button==System.Windows.Forms.MouseButtons.Left)
			{
				Point pt = new Point(e.X,e.Y);
				DataGrid.HitTestInfo hit = this.dgd_xycx.HitTest(pt);
				if(hit.Type == DataGrid.HitTestType.Cell)
				{
					this.dgd_xycx.Select(hit.Row);
				}
			}
		}

		private void rdb_zhcx_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.rdb_zhcx.Checked==true)
			{
				gpb_zhcx.Enabled=true;
				gpb_tbcx.Enabled=false;
			}
		}

		private void rdb_tbcx_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.rdb_tbcx.Checked==true)
			{
				gpb_zhcx.Enabled=false;
				gpb_tbcx.Enabled=true;
			}
			this.ckb_xm.Checked=false;
			this.ckb_bj.Checked=false;
			this.ckb_mz.Checked=false;
			this.ckb_xb.Checked=false;
		}

		private void ckb_xm_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.ckb_xm.Checked==true)
			{
				this.txt_xm.Enabled=true;
			}
			else
			{
				this.txt_xm.Enabled=false;
			}
		}

		private void ckb_xb_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.ckb_xb.Checked==true)
			{
				this.cbb_xb.Enabled=true;
			}
			else
			{
				this.cbb_xb.Enabled=false;
			}
		}

		private void ckb_bj_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.ckb_bj.Checked==true)
			{
				this.cbb_bj.Enabled=true;
			}
			else
			{
				this.cbb_bj.Enabled=false;
			}
		}

		private void ckb_mz_CheckedChanged(object sender, System.EventArgs e)
		{
			if (this.ckb_mz.Checked==true)
			{
				this.cbb_mz.Enabled=true;
			}
			else
			{
				this.cbb_mz.Enabled=false;
			}
		}
		private void Combo_Add()
		{
			dbAccess dba=new dbAccess();
			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",
					dba.connStr);
				sqlada_mb.Fill(dat_mb,"sex");
				foreach (System.Data.DataRow dater in dat_mb.Tables["sex"].Rows )
				{
					this.cbb_xb.Items.Add(dater[1]);
				}
			}
			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",
					dba.connStr);
				sqlada_mb.Fill(dat_mb,"nation");
				foreach (System.Data.DataRow dater in dat_mb.Tables["nation"].Rows )
				{
					this.cbb_mz.Items.Add(dater[1]);
				}
			}
			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,classes where class.cla_no=classes.cla_no",
					dba.connStr);
				sqlada_mb.Fill(dat_mb,"class");
				foreach (System.Data.DataRow dater in dat_mb.Tables["class"].Rows )
				{
					this.cbb_bj.Items.Add(dater["cla_name"]);
				}
			}
			catch(System.Exception m)
			{
				MessageBox.Show(m.Message);
			}
		}
		private void but_find_Click(object sender, System.EventArgs e)
		{
			dbAccess dba = new dbAccess();
			string select = "select student.stu_id as '学号',stu_name as '姓名',"
				+"sex_name as '性别',stu_birthday as '出生年月',stu_postcode as '邮政编码',"
				+"stu_homeaddress as '家庭地址',stu_tel as '联系电话',stu_hometel as '家庭电话',"
				+"stu_studytype as '学习方式',stu_identityNo as '身份证号',cla_name as '班级',"
				+"stu_registerdate as '报名日期',natp_name as '籍贯',nat_name as '民族',"
				+"polf_name as '政治面貌',mars_name as '婚姻状况',stu_company as '工作单位',"
				+"stu_address as '通讯地址',fie_name as '行业',stu_job as '职位',"
				+"stu_email as '电子邮件',tecp_name as '职业技术',Stu_diploma as '学历',"
				+"culd_name as '文化程度',Stu_languagedegree as '外语程度',stu_college as '毕业院校',"
				+"stu_tuitionfee as '学费',stu_materialfee as '教材费',stu_skillfullevel as '电脑能力',"
				+"stu_studydate as '开班日期',stu_lodgefee as '住宿费',stu_resume as '简历',stu_memo as '备注'"
				+" from student,sex,nation,technicalPosition,Maritalstatus,PoliticalFeature,"
				+"cultureDegree,nativePlace,field,class,classes"
				+" where nation.nat_code=student.nat_code and nativePlace.natp_code=student.natp_code"
				+" and Maritalstatus.mars_code=student.mars_code and PoliticalFeature.polf_code=student.polf_code"
				+" and cultureDegree.culd_code=student.culd_code and technicalPosition.tecp_code=student.tecp_code"
				+" and sex.sex_code=student.sex_code and field.fie_code=student.fie_code and class.cla_no=classes.cla_no"
				+" and classes.stu_id=student.stu_id";
			if (this.rdb_zhcx.Checked==true)
			{
				if(this.ckb_xm.Checked==true)
					select += " and stu_name like '%" + this.txt_xm.Text + "%'";
				if(this.ckb_xb.Checked==true)
					select += " and sex_name like '%" + this.cbb_xb.Text + "%'";
				if(this.ckb_bj.Checked==true)
					select += " and cla_name like '%" + this.cbb_bj.Text + "%'";
				if(this.ckb_mz.Checked==true)
					select += " and nat_name like '%" + this.cbb_mz.Text + "%'";
			}
			else if(this.rdb_tbcx.Checked==true)
			{
				string old_day=System.DateTime.Parse(this.ddtp_bmrq1.Text).Year.ToString()+"-"+System.DateTime.Parse(this.ddtp_bmrq1.Text).Month.ToString()+"-"+System.DateTime.Parse(this.ddtp_bmrq1.Text).Day.ToString();//
				string new_day=System.DateTime.Parse(this.ddtp_bmrq2.Text).Year.ToString()+"-"+System.DateTime.Parse(this.ddtp_bmrq2.Text).Month.ToString()+"-"+System.DateTime.Parse(this.ddtp_bmrq2.Text).Day.ToString();//
				select += " and stu_registerdate between '"+ old_day + "' and '" + new_day + "' ";//
			}
			try
			{
				System.Data.SqlClient.SqlConnection sqlcon_all=new System.Data.SqlClient.SqlConnection(dba.connStr);
				sqlcon_all.Open();
				System.Data.SqlClient.SqlDataAdapter sqldat_all=new System.Data.SqlClient.SqlDataAdapter(select,sqlcon_all);
				System.Data.DataSet dst_all=new System.Data.DataSet();
				sqldat_all.Fill(dst_all,"Employee");
				for(int i=0; i < dst_all.Tables["Employee"].Rows.Count; i++)
				{
					if (int.Parse(dst_all.Tables["Employee"].Rows[i]["学习方式"].ToString())==1)
						dst_all.Tables["Employee"].Rows[i]["学习方式"]="全日制";
					else if (int.Parse(dst_all.Tables["Employee"].Rows[i]["学习方式"].ToString())==2)
						dst_all.Tables["Employee"].Rows[i]["学习方式"]="半脱产";
					else if (int.Parse(dst_all.Tables["Employee"].Rows[i]["学习方式"].ToString())==3)
						dst_all.Tables["Employee"].Rows[i]["学习方式"]="双休日";
					else if (int.Parse(dst_all.Tables["Employee"].Rows[i]["学习方式"].ToString())==4)
						dst_all.Tables["Employee"].Rows[i]["学习方式"]="其它";
				}
				this.dgd_xycx.DataSource=dst_all;
				this.dgd_xycx.DataMember="Employee";
				sqlcon_all.Close();
			}
			catch(System.Exception error)
			{
				MessageBox.Show(error.Message );
			}
		}
	}
}