form_jxdy.cs

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

			btn_hyjr.Enabled = false;
			btn_mjl.Enabled = false;
			btn_bj.Enabled = false;
			btn_tj.Enabled = false;
			btn_sc.Enabled = false;
			btn_qdtj.Enabled = false;
			btn_qx.Enabled = false;

			sqlcmd.CommandText = "select cou_name,cou_no from Course where cou_no in (select cou_no from teachingAbility  where emp_id = '" + common.emplidstr + "')";
			sqlcmd.Connection = sqlcnt;
			sqldpt_jxdy1.SelectCommand = sqlcmd;
			sqldpt_jxdy1.Fill(dst_jxdy1);
			
			cbb_kcm.DataSource = dst_jxdy1.Tables[0];
			cbb_kcm.DisplayMember = "cou_name";
		
			this.setfalse();
			sqlcnt.Close();

			if (this.dst_jxdy1.Tables [0].Rows.Count !=0)
			{
				btn_qd.Enabled = true;
			}
		}
		private void setenable()
		{
			txt_jxdymc.Enabled = true;
			txt_nttl.Enabled =true;
			txt_zttl.Enabled = true;
			txt_yttl.Enabled = true;
			txt_zsdsm.Enabled = true;
		}
		private void setfalse()
		{
			txt_jxdymc.Enabled = false;
			txt_nttl.Enabled =false;
			txt_zttl.Enabled = false;
			txt_yttl.Enabled = false;
			txt_zsdsm.Enabled = false;
		}
		private void reject_jxdy()
		{
			if (this.modifyok == true)
			{
				this.dst_jxdy2.RejectChanges();
				this.modifyok = false;
			}
		}

		private void cbb_kcm_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if (cbb_kcm.SelectedIndex != -1)
			{
				btn_qd.Enabled = true;
			}
		}

		private void btn_qd_Click(object sender, System.EventArgs e)
		{
			dst_jxdy2.Clear();
			txt_jxdymc.DataBindings.Clear();
			txt_nttl.DataBindings.Clear();
			txt_zttl.DataBindings.Clear();
			txt_yttl.DataBindings.Clear();
			txt_zsdsm.DataBindings.Clear();
			dgd_jxdy.DataBindings.Clear ();
			

			try
			{
				sqlcnt.Open();
							
			}
			catch
			{
				MessageBox.Show("Server Error");
				return;                
			}
			btn_sjr.Enabled = true;
			btn_qyjr.Enabled = true;
			btn_hyjr.Enabled = true;
			btn_mjl.Enabled = true;
			btn_bj.Enabled = true;
			btn_tj.Enabled = true;
			btn_sc.Enabled = true;
			btn_qdtj.Enabled = true;
			btn_qx.Enabled = true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;

			intcou = int.Parse(dst_jxdy1.Tables[0].Rows[cbb_kcm.SelectedIndex][1].ToString());
			sqlcmd.CommandText = "select * from teachingunit where cou_no = " + intcou;
			sqlcmd.Connection = sqlcnt;
			sqldpt_jxdy2.SelectCommand = sqlcmd;
			sqldpt_jxdy2.Fill(dst_jxdy2,"table");

			txt_jxdymc.DataBindings.Add(new Binding("text",dst_jxdy2,"table.teau_name"));
			txt_nttl.DataBindings.Add(new Binding("text",dst_jxdy2,"table.teau_diffcult"));
			txt_zttl.DataBindings.Add(new Binding("text",dst_jxdy2,"table.teau_normal"));
			txt_yttl.DataBindings.Add(new Binding("text",dst_jxdy2,"table.teau_easy"));
			txt_zsdsm.DataBindings.Add(new Binding("text",dst_jxdy2,"table.teau_detail"));
		
			DataGridTableStyle style=new DataGridTableStyle();
			style.MappingName="table";
			DataGridTextBoxColumn teau_name = new DataGridTextBoxColumn();
			teau_name.HeaderText = "教学单元名称";
			teau_name.MappingName = "teau_name";
			teau_name.Width = 100;

			DataGridTextBoxColumn teau_diffcult = new DataGridTextBoxColumn();
			teau_diffcult.HeaderText = "教学单元出题量比重(难)";
			teau_diffcult.MappingName = "teau_diffcult";
			teau_diffcult.Width = 150;

			DataGridTextBoxColumn teau_normal = new DataGridTextBoxColumn();
			teau_normal.HeaderText = "教学单元出题量比重(中)";
			teau_normal.MappingName = "teau_normal";
			teau_normal.Width = 150;

			DataGridTextBoxColumn teau_easy = new DataGridTextBoxColumn();
			teau_easy.HeaderText = "教学单元出题量比重(易)";
			teau_easy.MappingName ="teau_easy";
			teau_easy.Width = 150;

			DataGridTextBoxColumn teau_detail = new  DataGridTextBoxColumn();
			teau_detail.HeaderText = "教学单元知识点说明";
			teau_detail.MappingName = "teau_detail";
			teau_detail.Width = 203;

			style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{teau_name,teau_diffcult,teau_normal,teau_easy,teau_detail});
			dgd_jxdy.TableStyles.Clear ();
			dgd_jxdy.TableStyles.Add(style);
			dgd_jxdy.SetDataBinding(this.dst_jxdy2,"table");
			if (this.dst_jxdy2.Tables [0].Rows.Count !=0)
			{
				dgd_jxdy.CurrentRowIndex = 0;
				dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
			}
						

			sqlcnt.Close();
		}

		private void btn_sjr_Click(object sender, System.EventArgs e)
		{
			this.reject_jxdy();
			dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex);
			dgd_jxdy.CurrentRowIndex = 0;
			dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
			btn_bj.Enabled = true;
			btn_sc.Enabled = true;
			btn_tj.Enabled =true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;
			this.setfalse();
		}

		private void btn_mjl_Click(object sender, System.EventArgs e)
		{
			this.reject_jxdy ();
			dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex);
			dgd_jxdy.CurrentRowIndex=dst_jxdy2.Tables[0].Rows.Count - 1;
			dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
			btn_bj.Enabled = true;
			btn_sc.Enabled = true;
			btn_tj.Enabled =true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;
			this.setfalse();
		}

		private void btn_qyjr_Click(object sender, System.EventArgs e)
		{
			this.reject_jxdy ();
			if (dgd_jxdy.CurrentRowIndex != 0)
			{
				dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex );
				dgd_jxdy.CurrentRowIndex  -= 1;
				dgd_jxdy.Select (dgd_jxdy.CurrentRowIndex );
			}
			btn_bj.Enabled = true;
			btn_sc.Enabled = true;
			btn_tj.Enabled =true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;
			this.setfalse();
		}

		private void btn_hyjr_Click(object sender, System.EventArgs e)
		{
			this.reject_jxdy ();
			if (dgd_jxdy.CurrentRowIndex != dst_jxdy2.Tables[0].Rows.Count - 1)
			{
				dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex );
				dgd_jxdy.CurrentRowIndex  += 1;
				dgd_jxdy.Select (dgd_jxdy.CurrentRowIndex );
			}
			btn_bj.Enabled = true;
			btn_sc.Enabled = true;
			btn_tj.Enabled =true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;
			this.setfalse();
		}

		private void btn_bj_Click(object sender, System.EventArgs e)
		{
			this.modifyok = true;
			btn_qdtj.Enabled =true;
			btn_qx.Enabled =true;
			btn_tj.Enabled = false;
			btn_sc.Enabled = false;
			this.setenable();			
		}

		private void btn_tj_Click(object sender, System.EventArgs e)
		{
			if (modifyok == true)
			{
				this.dst_jxdy2.RejectChanges();
   			}
			this.modifyok = true;
			btn_qdtj.Enabled =true;
			btn_qx.Enabled =true;
			btn_bj.Enabled = false;
			btn_sc.Enabled = false;
			this.setenable();

			int index = dst_jxdy2.Tables[0].Rows.Count - 1;
			DataRow drw = dst_jxdy2.Tables[0].NewRow();
			drw[0] = this.intcou ;
//
//			if (this.dst_jxdy2.Tables [0].Rows.Count == 0)
//			{
//				drw[1] = 1;
//			}
//			else
//			{
//				drw[1] = Convert.ToInt16(dst_jxdy2.Tables[0].Rows[index][1].ToString())+1;
//			}
			dst_jxdy2.Tables[0].Rows.Add(drw);
			dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex);
			dgd_jxdy.CurrentRowIndex=dst_jxdy2.Tables[0].Rows.Count - 1;
			dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
		
		}

		private void btn_qx_Click(object sender, System.EventArgs e)
		{
			
			this.reject_jxdy ();
			this.modifyok = false;
			btn_bj.Enabled = true;
			btn_tj.Enabled = true;
			btn_sc.Enabled = true;
			btn_qdtj.Enabled = false;
			btn_qx.Enabled = false;
			this.setfalse ();
			
		}

		private void btn_sc_Click(object sender, System.EventArgs e)
		{
//			this.modifyok = true;
//			
			DialogResult result=MessageBox.Show("确认要删除吗？","阜和教育课程体系试题库系统提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question);  
			if(result==DialogResult.Yes)
			{
				try
				{
					int index = dgd_jxdy.CurrentRowIndex;
					dst_jxdy2.Tables [0].Rows[index].Delete();
					SqlCommandBuilder scb = new SqlCommandBuilder(sqldpt_jxdy2);
					sqldpt_jxdy2.Update(dst_jxdy2);
				}
				catch
				{
					MessageBox.Show("输入数据不正确!","阜和教育课程体系试题库系统提示");//
				}
			}

		}

		private void btn_qdtj_Click(object sender, System.EventArgs e)
		{
			try
			{
				sqlcnt.Open();
							
			}
			catch
			{
				MessageBox.Show("服务器连接出错","阜和教育课程体系试题库系统提示");
				this.setfalse();
				this.modifyok = false;
				btn_bj.Enabled = true;
				btn_tj.Enabled = true;
				btn_sc.Enabled = true;
				btn_qdtj.Enabled =false;
				btn_qx.Enabled =false;
				return;                
			}
			
			DataRow drw =dst_jxdy2.Tables [0].NewRow ();
            this.dst_jxdy2.Tables[0].Rows.Add(drw);
			int index = dst_jxdy2.Tables[0].Rows.Count - 1;
			dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex );
			dgd_jxdy.CurrentRowIndex = index;
			dgd_jxdy.Select (dgd_jxdy.CurrentRowIndex );
			dgd_jxdy.UnSelect(dgd_jxdy.CurrentRowIndex );
			dgd_jxdy.CurrentRowIndex -=1;
			dgd_jxdy.Select (dgd_jxdy.CurrentRowIndex );
			dst_jxdy2.Tables [0].Rows[index].Delete ();


			SqlCommandBuilder scb = new SqlCommandBuilder(sqldpt_jxdy2);
			sqldpt_jxdy2.Update(dst_jxdy2);
			MessageBox.Show("数据库成功更新","阜和教育课程体系试题库系统提示");
			dst_jxdy2.Clear ();
			sqldpt_jxdy2.Fill(dst_jxdy2,"table");
			
			sqlcnt.Close();
			this.setfalse();
			this.modifyok = false;
			btn_bj.Enabled = true;
			btn_tj.Enabled = true;
			btn_sc.Enabled = true;
			btn_qdtj.Enabled =false;
			btn_qx.Enabled =false;
		}

		private void txt_nttl_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if (!char.IsNumber(e.KeyChar.ToString(),0))
			{
				e.Handled = true;
			}
		}

		private void txt_zttl_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if (!char.IsNumber(e.KeyChar.ToString(),0))
			{
				e.Handled = true;
			}
		}

		private void txt_yttl_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if (!char.IsNumber(e.KeyChar.ToString(),0))
			{
				e.Handled = true;
			}
		}

		private void dgd_jxdy_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 = dgd_jxdy.HitTest(pt);
				if(hit.Type == DataGrid.HitTestType.Cell) 
				{
					dgd_jxdy.Select(hit.Row);
				}
			}
		}

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

		private void dgd_jxdy_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if (this.modifyok == true)
			{
				dgd_jxdy.CurrentRowIndex = dst_jxdy2.Tables[0].Rows.Count - 1;
				dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
				this.btn_qx_Click (sender,e);
			}
		}

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

		
	






	}
}