form_sjjgcx.cs

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

			this.btn_cx.Name = "btn_cx";
			this.btn_cx.TabIndex = 1;
			this.btn_cx.Text = "查   询";
			this.btn_cx.Click += new System.EventHandler(this.btn_cx_Click);
			// 
			// button1
			// 
			this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.button1.Location = new System.Drawing.Point(632, 488);
			this.button1.Name = "button1";
			this.button1.TabIndex = 4;
			this.button1.Text = "删除试卷";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// label1
			// 
			this.label1.AutoSize = true;
			this.label1.Location = new System.Drawing.Point(360, 488);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(128, 17);
			this.label1.TabIndex = 5;
			this.label1.Text = "对生成的新试卷操作：";
			// 
			// Form_sjjgcx
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(792, 573);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.button1);
			this.Controls.Add(this.pnl_sjjgcx2);
			this.Controls.Add(this.dgd_sjjgcx);
			this.Controls.Add(this.pnl_sjjgcx1);
			this.Controls.Add(this.btn_cx);
			this.Controls.Add(this.btn_gd);
			this.Name = "Form_sjjgcx";
			this.Text = "试卷结构查询";
			this.Load += new System.EventHandler(this.Form_sjjgcx_Load);
			this.pnl_sjjgcx1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dgd_sjjgcx)).EndInit();
			this.pnl_sjjgcx2.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void Form_sjjgcx_Load(object sender, System.EventArgs e)
		{
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.ControlBox = false;
	        //在下拉列表框中填入课程名
						cbb_kcmc.SelectedText="【请选取课程】";
			SqlDataAdapter dataA=new SqlDataAdapter("select * from course",dbAccess.conn);
			DataSet ds=new DataSet();
			dataA.Fill(ds);
			
			foreach(DataRow dater in ds.Tables[0].Rows)
			{
				cbb_kcmc.Items.Add(dater["cou_name"]);
			}
			
//cbb_kcmc.SelectedText="【请选取课程】";

			pnl_sjjgcx2.Enabled=false;

				
		}

		private void btn_cx_Click(object sender, System.EventArgs e)
		{
			
			cn.ConnectionString=dbAccess.conn;
			ds.Clear();
          if (this.cbb_kcmc.Text!="")
		  
			
			//在paper表中选出等于课程号的记录
			try
			{  //把下拉列表框所选中的课程名变成课程号付给cou这个变量
			
			
				sql_cou="select cou_no from course where cou_name='"+cbb_kcmc.SelectedItem.ToString()+"'";
				cmd_cou.Connection=cn;
				cmd_cou.CommandText=sql_cou;
				da4.SelectCommand=cmd_cou;
				da4.Fill(ds,"cou");
				string cou;
				cou=ds.Tables["cou"].Rows[0]["cou_no"].ToString();


				sql_pap="select * from paper where cou_no='"+cou+"'"; 
             //如果开考日期单选框被选中，则加入该条件
				if (ckb_kkrq.Checked==true)
				{
					sql_pap="select * from paper where cou_no='"+cou+"' and pap_examtime='"+dtp_kkrq.Value.ToShortDateString()+"'"; 

				}
				//如果查询日期单选框被选中，则加入该条件
				if (ckb_cxrq.Checked==true)
				{
							
					sql_pap="select * from paper where cou_no='"+cou+"' and pap_examtime between '"+dtp_cxrq1.Value.ToShortDateString()+"' and '"+ dtp_cxrq2.Value.ToShortDateString()+"'";
											
				}
                //填充数据集，生成sql_pap表，然后装载到数据窗口中
				cmd_pap.Connection=cn;
				cmd_pap.CommandText=sql_pap;
				da_pap.SelectCommand=cmd_pap;
					
				da_pap.Fill(ds,"pap");
				dgd_sjjgcx.DataSource=ds.Tables["pap"];
				dgd_sjjgcx.ReadOnly=true;
                //把数据窗口字段是英文的，改成中文的
				System.Windows.Forms.DataGridTableStyle dgts=new DataGridTableStyle();
				dgts.MappingName="pap";

				this.dgd_sjjgcx.TableStyles.Clear();

				System.Windows.Forms.DataGridTextBoxColumn  dgtb_1=new DataGridTextBoxColumn();
				dgtb_1.MappingName="cou_no";
				dgtb_1.HeaderText="课程代码";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_2=new DataGridTextBoxColumn();
				dgtb_2.MappingName="teau_no";
				dgtb_2.HeaderText="教学单元代码";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_3=new DataGridTextBoxColumn();
				dgtb_3.MappingName="que_no";
				dgtb_3.HeaderText="试题代码";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_4=new DataGridTextBoxColumn();
				dgtb_4.MappingName="ans_no";
				dgtb_4.HeaderText="答案代码";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_5=new DataGridTextBoxColumn();
				dgtb_5.MappingName="pap_no";
				dgtb_5.HeaderText="试卷代码";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_6=new DataGridTextBoxColumn();
				dgtb_6.MappingName="pap_createtime";
				dgtb_6.HeaderText="创建时间";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_7=new DataGridTextBoxColumn();
				dgtb_7.MappingName="pap_limitterm";
				dgtb_7.HeaderText="考试时限";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_8=new DataGridTextBoxColumn();
				dgtb_8.MappingName="pap_examtime";
				dgtb_8.HeaderText="开考时间";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_9=new DataGridTextBoxColumn();
				dgtb_9.MappingName="pap_avalibledate";
				dgtb_9.HeaderText="有效期";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_10=new DataGridTextBoxColumn();
				dgtb_10.MappingName="pap_canbesaved";
				dgtb_10.HeaderText="归档";
				System.Windows.Forms.DataGridTextBoxColumn  dgtb_11=new DataGridTextBoxColumn();
				dgtb_11.MappingName="pap_memo";
				dgtb_11.HeaderText="备注";

			
				dgts.GridColumnStyles.Add(dgtb_1);
				dgts.GridColumnStyles.Add(dgtb_2);
				dgts.GridColumnStyles.Add(dgtb_3);
				dgts.GridColumnStyles.Add(dgtb_4);
				dgts.GridColumnStyles.Add(dgtb_5);
				dgts.GridColumnStyles.Add(dgtb_6);
				dgts.GridColumnStyles.Add(dgtb_7);
				dgts.GridColumnStyles.Add(dgtb_8);
				dgts.GridColumnStyles.Add(dgtb_9);
				dgts.GridColumnStyles.Add(dgtb_10);
				dgts.GridColumnStyles.Add(dgtb_11);


				this.dgd_sjjgcx.TableStyles.Add(dgts);

			}
			catch(System.Exception my)
			{  // MessageBox.Show("课程名不能为空");
				MessageBox.Show(my.Message);}
			finally
			{pnl_sjjgcx2.Enabled=true;}

		}

		private void btn_xg_Click(object sender, System.EventArgs e)
		{//对数据窗口进行修改
			dgd_sjjgcx.ReadOnly=false;
		}

		private void btn_sc_Click(object sender, System.EventArgs e)
		{//对所选中的记录删除
			ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex].Delete();
		}

		private void btn_tj_Click(object sender, System.EventArgs e)
		{//通过commandbuilder对数据库中的数据进行自动增，删，改
			try
			{
				SqlCommandBuilder cb=new SqlCommandBuilder(da_pap);
				da_pap.Update(ds,"pap");
				MessageBox.Show("对数据库操作已成功","阜和教育课程体系试题库系统提示");
				
			}
			catch(System.Exception m)
			{MessageBox.Show(m.Message);}
			finally
			{button1.Enabled=true;}
		}

		private void btn_gd_Click(object sender, System.EventArgs e)
		{   string pap_no;
			pap_no=ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex]["pap_no"].ToString();
			
				
			MessageBox.Show ("对"+pap_no.ToString()+"试卷进行归档","阜和教育课程体系试题库系统提示",MessageBoxButtons.YesNo);
//					ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex]["pap_canbesaved"]="1";
			foreach (DataRow dr in ds.Tables["pap"].Rows)
			{
				
				
				if (dr["pap_no"].ToString()==pap_no)
					ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex ]["pap_canbesaved"]="1";
//			dr.Table.Rows[0]["pap_canbesaved"]="1";
//				dr.Table.Rows[0]["pap_canbesaved"]="1";
			}
           
		
		}

		private void button1_Click(object sender, System.EventArgs e)
		{string pap_no;
		pap_no=ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex]["pap_no"].ToString();
			if (ds.Tables["pap"].Rows[dgd_sjjgcx.CurrentRowIndex]["pap_canbesaved"].ToString() == "1")
				MessageBox.Show("该试卷已被归档,不能被删除");
			else
			{   MessageBox.Show("是否要对"+pap_no.ToString()+"试卷删除？","阜和教育课程体系试题库系统提示",MessageBoxButtons.YesNo);

				foreach (DataRow dr in ds.Tables["pap"].Rows)
				{
				
				if (dr["pap_no"].ToString()==pap_no)
						dr.Delete();
				}
				MessageBox.Show("如想要对删除的试卷进行生效,请按下提交","阜和教育课程体系试题库系统提示");
				button1.Enabled=false;
			}

		}

	

		

	


		
	}
}