frmchengji.cs

毕业生管理系统:分为六个模块：身份验证模块、毕业生资料模块,考试成绩录入模块、通信录及数据输出与系统设置模块、毕业生成绩统计模块、数据库维护模块。

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;

namespace 毕业生信息管理系统
{
	/// <summary>
	/// frmChengJi 的摘要说明。
	/// </summary>
	public class frmChengJi : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.ContextMenu contextMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.MenuItem menuItem2;
		private System.Windows.Forms.Button btnInt;
		private System.Windows.Forms.Button btnMu;
		private System.Windows.Forms.Button btnDel;
		private System.Windows.Forms.Button btnPrint;
		private System.Windows.Forms.TextBox txt7;
		private System.Windows.Forms.Button btnTongJi;
		private System.Windows.Forms.TextBox txt6;
		private System.Windows.Forms.TextBox txt5;
		private System.Windows.Forms.TextBox txt4;
		private System.Windows.Forms.TextBox txt3;
		private System.Windows.Forms.TextBox txt2;
		private System.Windows.Forms.TextBox txt1;
		private System.Windows.Forms.Button btnOut;
		private System.Windows.Forms.Button btnClose;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		private OleDbDataAdapter objDataAdapter;
		private OleDbConnection objOleDbConn;
		private DataSet objDataSet;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.TextBox txtName;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.TextBox txtNumber;
		private OleDbCommand objOleDbCommand;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.PrintDialog printDialog1;
		private System.Windows.Forms.PrintPreviewDialog printPreviewDialog1;
		private System.Windows.Forms.PageSetupDialog pageSetupDialog1;
		private System.Drawing.Printing.PrintDocument printDocument1;
		private OleDbParameter objParam;

		public frmChengJi()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmChengJi));
			this.btnInt = new System.Windows.Forms.Button();
			this.btnMu = new System.Windows.Forms.Button();
			this.btnDel = new System.Windows.Forms.Button();
			this.btnPrint = new System.Windows.Forms.Button();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.txtNumber = new System.Windows.Forms.TextBox();
			this.label10 = new System.Windows.Forms.Label();
			this.txtName = new System.Windows.Forms.TextBox();
			this.label9 = new System.Windows.Forms.Label();
			this.txt7 = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.btnTongJi = new System.Windows.Forms.Button();
			this.txt6 = new System.Windows.Forms.TextBox();
			this.label6 = new System.Windows.Forms.Label();
			this.txt5 = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.txt4 = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.txt3 = new System.Windows.Forms.TextBox();
			this.label3 = new System.Windows.Forms.Label();
			this.txt2 = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.txt1 = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.btnOut = new System.Windows.Forms.Button();
			this.btnClose = new System.Windows.Forms.Button();
			this.contextMenu1 = new System.Windows.Forms.ContextMenu();
			this.menuItem1 = new System.Windows.Forms.MenuItem();
			this.menuItem2 = new System.Windows.Forms.MenuItem();
			this.button1 = new System.Windows.Forms.Button();
			this.printDialog1 = new System.Windows.Forms.PrintDialog();
			this.printDocument1 = new System.Drawing.Printing.PrintDocument();
			this.printPreviewDialog1 = new System.Windows.Forms.PrintPreviewDialog();
			this.pageSetupDialog1 = new System.Windows.Forms.PageSetupDialog();
			this.groupBox1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.groupBox2.SuspendLayout();
			this.SuspendLayout();
			// 
			// btnInt
			// 
			this.btnInt.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnInt.ForeColor = System.Drawing.Color.Blue;
			this.btnInt.Location = new System.Drawing.Point(120, 256);
			this.btnInt.Name = "btnInt";
			this.btnInt.Size = new System.Drawing.Size(80, 24);
			this.btnInt.TabIndex = 16;
			this.btnInt.Text = "插入";
			this.btnInt.Click += new System.EventHandler(this.btnInt_Click);
			// 
			// btnMu
			// 
			this.btnMu.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnMu.ForeColor = System.Drawing.Color.Blue;
			this.btnMu.Location = new System.Drawing.Point(216, 256);
			this.btnMu.Name = "btnMu";
			this.btnMu.Size = new System.Drawing.Size(80, 24);
			this.btnMu.TabIndex = 17;
			this.btnMu.Text = "修改";
			this.btnMu.Click += new System.EventHandler(this.btnMu_Click);
			// 
			// btnDel
			// 
			this.btnDel.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnDel.ForeColor = System.Drawing.Color.Blue;
			this.btnDel.Location = new System.Drawing.Point(312, 256);
			this.btnDel.Name = "btnDel";
			this.btnDel.Size = new System.Drawing.Size(80, 24);
			this.btnDel.TabIndex = 18;
			this.btnDel.Text = "删除";
			this.btnDel.Click += new System.EventHandler(this.btnDel_Click);
			// 
			// btnPrint
			// 
			this.btnPrint.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnPrint.ForeColor = System.Drawing.Color.Blue;
			this.btnPrint.Location = new System.Drawing.Point(504, 256);
			this.btnPrint.Name = "btnPrint";
			this.btnPrint.Size = new System.Drawing.Size(80, 24);
			this.btnPrint.TabIndex = 19;
			this.btnPrint.Text = "打印";
			this.btnPrint.Click += new System.EventHandler(this.btnPrint_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.dataGrid1);
			this.groupBox1.Location = new System.Drawing.Point(344, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(352, 232);
			this.groupBox1.TabIndex = 20;
			this.groupBox1.TabStop = false;
			// 
			// dataGrid1
			// 
			this.dataGrid1.BackgroundColor = System.Drawing.Color.LightBlue;
			this.dataGrid1.CaptionBackColor = System.Drawing.SystemColors.ActiveBorder;
			this.dataGrid1.DataMember = "";
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(8, 17);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(336, 207);
			this.dataGrid1.TabIndex = 0;
			this.dataGrid1.Click += new System.EventHandler(this.dataGrid1_Click);
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.txtNumber);
			this.groupBox2.Controls.Add(this.label10);
			this.groupBox2.Controls.Add(this.txtName);
			this.groupBox2.Controls.Add(this.label9);
			this.groupBox2.Controls.Add(this.txt7);
			this.groupBox2.Controls.Add(this.label8);
			this.groupBox2.Controls.Add(this.label7);
			this.groupBox2.Controls.Add(this.btnTongJi);
			this.groupBox2.Controls.Add(this.txt6);
			this.groupBox2.Controls.Add(this.label6);
			this.groupBox2.Controls.Add(this.txt5);
			this.groupBox2.Controls.Add(this.label5);
			this.groupBox2.Controls.Add(this.txt4);
			this.groupBox2.Controls.Add(this.label4);
			this.groupBox2.Controls.Add(this.txt3);
			this.groupBox2.Controls.Add(this.label3);
			this.groupBox2.Controls.Add(this.txt2);
			this.groupBox2.Controls.Add(this.label2);
			this.groupBox2.Controls.Add(this.txt1);
			this.groupBox2.Controls.Add(this.label1);
			this.groupBox2.Location = new System.Drawing.Point(8, 8);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(328, 232);
			this.groupBox2.TabIndex = 21;
			this.groupBox2.TabStop = false;
			// 
			// txtNumber
			// 
			this.txtNumber.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.txtNumber.ForeColor = System.Drawing.Color.Blue;
			this.txtNumber.Location = new System.Drawing.Point(240, 17);
			this.txtNumber.MaxLength = 8;
			this.txtNumber.Name = "txtNumber";
			this.txtNumber.Size = new System.Drawing.Size(72, 21);
			this.txtNumber.TabIndex = 35;
			this.txtNumber.Text = "";
			// 
			// label10
			// 
			this.label10.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label10.ForeColor = System.Drawing.Color.Magenta;
			this.label10.Location = new System.Drawing.Point(160, 16);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(80, 24);
			this.label10.TabIndex = 34;
			this.label10.Text = "学号：";
			this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// txtName
			// 
			this.txtName.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.txtName.ForeColor = System.Drawing.Color.Blue;
			this.txtName.Location = new System.Drawing.Point(80, 16);
			this.txtName.MaxLength = 6;
			this.txtName.Name = "txtName";
			this.txtName.Size = new System.Drawing.Size(72, 21);
			this.txtName.TabIndex = 33;
			this.txtName.Text = "";
			// 
			// label9
			// 
			this.label9.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label9.ForeColor = System.Drawing.Color.Magenta;
			this.label9.Location = new System.Drawing.Point(8, 17);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(72, 24);
			this.label9.TabIndex = 32;
			this.label9.Text = "姓名：";
			this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// txt7
			// 
			this.txt7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.txt7.ForeColor = System.Drawing.Color.Red;
			this.txt7.Location = new System.Drawing.Point(240, 200);
			this.txt7.MaxLength = 3;
			this.txt7.Name = "txt7";
			this.txt7.Size = new System.Drawing.Size(72, 21);
			this.txt7.TabIndex = 31;
			this.txt7.Text = "";
			// 
			// label8
			// 
			this.label8.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label8.ForeColor = System.Drawing.Color.Blue;
			this.label8.Location = new System.Drawing.Point(152, 200);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(80, 24);
			this.label8.TabIndex = 30;
			this.label8.Text = "平均分：";