querybynewdata.cs

为湖北省教委、湖北省就业指导中心订做的学历查询系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;
using www.kcgx.com.Database;

namespace WindowsApplication3
{
	/// <summary>
	/// QueryByNewData 的摘要说明。
	/// </summary>
	public class QueryByNewData : System.Windows.Forms.UserControl
	{
		public static bool btnYN_2 = false;

		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.ComboBox cbNewdiploma;
		private System.Windows.Forms.ComboBox cbNewclass;
		private System.Windows.Forms.TextBox txtNewspecialty;
		private System.Windows.Forms.TextBox txtNewdiplomaid;
		private System.Windows.Forms.TextBox txtNewschool;
		private System.Windows.Forms.TextBox txtNewname;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.ListView lv;
		private System.Windows.Forms.ColumnHeader 姓名;
		private System.Windows.Forms.ColumnHeader 性别;
		private System.Windows.Forms.ColumnHeader 出身年月;
		private System.Windows.Forms.ColumnHeader 层次;
		private System.Windows.Forms.ColumnHeader 学历类型;
		private System.Windows.Forms.ColumnHeader 学制;
		private System.Windows.Forms.ColumnHeader 院校名称;
		private System.Windows.Forms.ColumnHeader 专业名称;
		private System.Windows.Forms.ColumnHeader 毕结业结论;
		private System.Windows.Forms.ColumnHeader 入学时间;
		private System.Windows.Forms.ColumnHeader 毕业时间;
		private System.Windows.Forms.ColumnHeader 证书编号;
		private DBAgent db = new DBAgent( );
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtManager;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.ColumnHeader 序号;
		private System.Windows.Forms.ColumnHeader 录入人员;
		private System.Windows.Forms.ColumnHeader 录入时间;
		private System.Windows.Forms.ColumnHeader 审核结果;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.PictureBox pictureBox2;
		private System.Windows.Forms.TextBox txtTime;
		private System.Windows.Forms.ToolTip toolTip1;
		private System.ComponentModel.IContainer components;
		private System.Windows.Forms.PictureBox pictureBox3;
		public static ListView printList = new ListView( );

		public QueryByNewData()
		{
			// 该调用是 Windows.Forms 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化

		}

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

		#region 组件设计器生成的代码
		/// <summary> 
		/// 设计器支持所需的方法 - 不要使用代码编辑器 
		/// 修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(QueryByNewData));
			this.groupBox3 = new System.Windows.Forms.GroupBox();
			this.pictureBox3 = new System.Windows.Forms.PictureBox();
			this.txtTime = new System.Windows.Forms.TextBox();
			this.pictureBox2 = new System.Windows.Forms.PictureBox();
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.cbNewdiploma = new System.Windows.Forms.ComboBox();
			this.cbNewclass = new System.Windows.Forms.ComboBox();
			this.txtNewspecialty = new System.Windows.Forms.TextBox();
			this.txtNewdiplomaid = new System.Windows.Forms.TextBox();
			this.txtNewschool = new System.Windows.Forms.TextBox();
			this.txtNewname = new System.Windows.Forms.TextBox();
			this.label11 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label13 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label15 = new System.Windows.Forms.Label();
			this.label16 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.txtManager = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.lv = new System.Windows.Forms.ListView();
			this.序号 = new System.Windows.Forms.ColumnHeader();
			this.姓名 = new System.Windows.Forms.ColumnHeader();
			this.性别 = new System.Windows.Forms.ColumnHeader();
			this.出身年月 = new System.Windows.Forms.ColumnHeader();
			this.层次 = new System.Windows.Forms.ColumnHeader();
			this.学历类型 = new System.Windows.Forms.ColumnHeader();
			this.学制 = new System.Windows.Forms.ColumnHeader();
			this.院校名称 = new System.Windows.Forms.ColumnHeader();
			this.专业名称 = new System.Windows.Forms.ColumnHeader();
			this.毕结业结论 = new System.Windows.Forms.ColumnHeader();
			this.入学时间 = new System.Windows.Forms.ColumnHeader();
			this.毕业时间 = new System.Windows.Forms.ColumnHeader();
			this.证书编号 = new System.Windows.Forms.ColumnHeader();
			this.录入人员 = new System.Windows.Forms.ColumnHeader();
			this.录入时间 = new System.Windows.Forms.ColumnHeader();
			this.审核结果 = new System.Windows.Forms.ColumnHeader();
			this.toolTip1 = new System.Windows.Forms.ToolTip(this.components);
			this.groupBox3.SuspendLayout();
			this.SuspendLayout();
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.pictureBox3);
			this.groupBox3.Controls.Add(this.txtTime);
			this.groupBox3.Controls.Add(this.pictureBox2);
			this.groupBox3.Controls.Add(this.pictureBox1);
			this.groupBox3.Controls.Add(this.cbNewdiploma);
			this.groupBox3.Controls.Add(this.cbNewclass);
			this.groupBox3.Controls.Add(this.txtNewspecialty);
			this.groupBox3.Controls.Add(this.txtNewdiplomaid);
			this.groupBox3.Controls.Add(this.txtNewschool);
			this.groupBox3.Controls.Add(this.txtNewname);
			this.groupBox3.Controls.Add(this.label11);
			this.groupBox3.Controls.Add(this.label12);
			this.groupBox3.Controls.Add(this.label13);
			this.groupBox3.Controls.Add(this.label14);
			this.groupBox3.Controls.Add(this.label15);
			this.groupBox3.Controls.Add(this.label16);
			this.groupBox3.Controls.Add(this.label2);
			this.groupBox3.Controls.Add(this.txtManager);
			this.groupBox3.Controls.Add(this.label1);
			this.groupBox3.Location = new System.Drawing.Point(8, 8);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(584, 200);
			this.groupBox3.TabIndex = 25;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "新库查询";
			// 
			// pictureBox3
			// 
			this.pictureBox3.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox3.Image")));
			this.pictureBox3.Location = new System.Drawing.Point(360, 160);
			this.pictureBox3.Name = "pictureBox3";
			this.pictureBox3.Size = new System.Drawing.Size(56, 26);
			this.pictureBox3.TabIndex = 23;
			this.pictureBox3.TabStop = false;
			this.pictureBox3.Click += new System.EventHandler(this.pictureBox3_Click);
			this.pictureBox3.MouseEnter += new System.EventHandler(this.pictureBox3_MouseEnter);
			this.pictureBox3.MouseLeave += new System.EventHandler(this.pictureBox3_MouseLeave);
			// 
			// txtTime
			// 
			this.txtTime.Location = new System.Drawing.Point(408, 128);
			this.txtTime.Name = "txtTime";
			this.txtTime.Size = new System.Drawing.Size(144, 21);
			this.txtTime.TabIndex = 21;
			this.txtTime.Text = "";
			this.toolTip1.SetToolTip(this.txtTime, "输入样式:2004年5月31日");
			// 
			// pictureBox2
			// 
			this.pictureBox2.Cursor = System.Windows.Forms.Cursors.Hand;
			this.pictureBox2.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox2.Image")));
			this.pictureBox2.Location = new System.Drawing.Point(432, 160);
			this.pictureBox2.Name = "pictureBox2";
			this.pictureBox2.Size = new System.Drawing.Size(56, 26);
			this.pictureBox2.TabIndex = 20;
			this.pictureBox2.TabStop = false;
			this.pictureBox2.Click += new System.EventHandler(this.pictureBox2_Click);
			this.pictureBox2.MouseEnter += new System.EventHandler(this.pictureBox2_MouseEnter);
			this.pictureBox2.MouseLeave += new System.EventHandler(this.pictureBox2_MouseLeave);
			// 
			// pictureBox1
			// 
			this.pictureBox1.Cursor = System.Windows.Forms.Cursors.Hand;
			this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
			this.pictureBox1.Location = new System.Drawing.Point(496, 160);
			this.pictureBox1.Name = "pictureBox1";
			this.pictureBox1.Size = new System.Drawing.Size(56, 26);
			this.pictureBox1.TabIndex = 19;
			this.pictureBox1.TabStop = false;
			this.pictureBox1.Click += new System.EventHandler(this.pictureBox1_Click);
			this.pictureBox1.MouseEnter += new System.EventHandler(this.pictureBox1_MouseEnter);
			this.pictureBox1.MouseLeave += new System.EventHandler(this.pictureBox1_MouseLeave);
			// 
			// cbNewdiploma
			// 
			this.cbNewdiploma.Items.AddRange(new object[] {
															  "普通全日制",
															  "成人",
															  "网络教育",
															  "研究生"});
			this.cbNewdiploma.Location = new System.Drawing.Point(104, 96);
			this.cbNewdiploma.Name = "cbNewdiploma";
			this.cbNewdiploma.Size = new System.Drawing.Size(144, 20);
			this.cbNewdiploma.TabIndex = 5;
			this.cbNewdiploma.Text = "请选择或输入新项";
			this.cbNewdiploma.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.cbNewdiploma_KeyPress);
			this.cbNewdiploma.SelectedIndexChanged += new System.EventHandler(this.cbNewdiploma_SelectedIndexChanged);
			// 
			// cbNewclass
			// 
			this.cbNewclass.Items.AddRange(new object[] {
															"博士研究生",
															"硕士研究生",
															"研究生",
															"第二学士学位",
															"本科",
															"高升本",
															"专升本",
															"第二本科",
															"专科",
															"高职",
															"第二专科",
															"夜大电大函大普通班",
															"中专",
															"不详"});
			this.cbNewclass.Location = new System.Drawing.Point(408, 32);
			this.cbNewclass.Name = "cbNewclass";
			this.cbNewclass.Size = new System.Drawing.Size(144, 20);
			this.cbNewclass.TabIndex = 2;
			this.cbNewclass.Text = "请选择或输入新项";
			this.cbNewclass.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.cbNewclass_KeyPress);
			// 
			// txtNewspecialty
			// 
			this.txtNewspecialty.Location = new System.Drawing.Point(408, 64);
			this.txtNewspecialty.Name = "txtNewspecialty";
			this.txtNewspecialty.Size = new System.Drawing.Size(144, 21);
			this.txtNewspecialty.TabIndex = 4;
			this.txtNewspecialty.Tag = "";
			this.txtNewspecialty.Text = "";
			this.txtNewspecialty.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtNewspecialty_KeyPress);
			// 
			// txtNewdiplomaid
			// 
			this.txtNewdiplomaid.Location = new System.Drawing.Point(408, 96);
			this.txtNewdiplomaid.Name = "txtNewdiplomaid";
			this.txtNewdiplomaid.Size = new System.Drawing.Size(144, 21);
			this.txtNewdiplomaid.TabIndex = 6;
			this.txtNewdiplomaid.Tag = "";
			this.txtNewdiplomaid.Text = "";
			this.txtNewdiplomaid.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtNewdiplomaid_KeyPress);
			// 
			// txtNewschool
			// 
			this.txtNewschool.Location = new System.Drawing.Point(104, 64);
			this.txtNewschool.Name = "txtNewschool";
			this.txtNewschool.Size = new System.Drawing.Size(144, 21);
			this.txtNewschool.TabIndex = 3;
			this.txtNewschool.Tag = "";
			this.txtNewschool.Text = "";
			this.txtNewschool.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtNewschool_KeyPress);
			// 
			// txtNewname
			// 
			this.txtNewname.Location = new System.Drawing.Point(104, 32);
			this.txtNewname.Name = "txtNewname";
			this.txtNewname.Size = new System.Drawing.Size(144, 21);
			this.txtNewname.TabIndex = 1;
			this.txtNewname.Tag = "";
			this.txtNewname.Text = "";
			this.txtNewname.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtNewname_KeyPress);
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(336, 96);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(64, 16);
			this.label11.TabIndex = 5;
			this.label11.Text = "证书编号:";
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(336, 64);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(64, 16);
			this.label12.TabIndex = 4;
			this.label12.Text = "专业名称:";
			this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label13
			// 
			this.label13.Location = new System.Drawing.Point(32, 64);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(64, 16);
			this.label13.TabIndex = 3;
			this.label13.Text = "院校名称:";
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(32, 96);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(64, 16);
			this.label14.TabIndex = 2;
			this.label14.Text = "学  历:";
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(336, 32);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(64, 16);
			this.label15.TabIndex = 1;
			this.label15.Text = "层  次:";
			// 
			// label16
			// 
			this.label16.Location = new System.Drawing.Point(32, 32);
			this.label16.Name = "label16";
			this.label16.Size = new System.Drawing.Size(64, 16);
			this.label16.TabIndex = 0;
			this.label16.Text = "姓  名:";
			this.label16.Click += new System.EventHandler(this.label16_Click);
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(336, 128);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(64, 16);
			this.label2.TabIndex = 17;
			this.label2.Text = "录入时间:";
			// 
			// txtManager
			// 
			this.txtManager.Location = new System.Drawing.Point(104, 128);
			this.txtManager.Name = "txtManager";
			this.txtManager.Size = new System.Drawing.Size(144, 21);
			this.txtManager.TabIndex = 7;
			this.txtManager.Text = "";
			this.txtManager.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtManager_KeyPress);
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(32, 128);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(64, 16);
			this.label1.TabIndex = 15;
			this.label1.Text = "录入人员:";
			// 
			// lv
			// 
			this.lv.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.lv.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																				 this.序号,
																				 this.姓名,
																				 this.性别,
																				 this.出身年月,
																				 this.层次,
																				 this.学历类型,
																				 this.学制,
																				 this.院校名称,
																				 this.专业名称,
																				 this.毕结业结论,
																				 this.入学时间,
																				 this.毕业时间,
																				 this.证书编号,
																				 this.录入人员,
																				 this.录入时间,
																				 this.审核结果});
			this.lv.FullRowSelect = true;
			this.lv.Location = new System.Drawing.Point(8, 216);
			this.lv.Name = "lv";
			this.lv.Size = new System.Drawing.Size(576, 224);
			this.lv.TabIndex = 26;
			this.lv.TabStop = false;
			this.lv.View = System.Windows.Forms.View.Details;
			this.lv.DoubleClick += new System.EventHandler(this.lv_DoubleClick);
			this.lv.SelectedIndexChanged += new System.EventHandler(this.lv_SelectedIndexChanged);
			// 
			// 序号
			// 
			this.序号.Text = "序号";
			this.序号.Width = 30;
			// 
			// 姓名
			// 
			this.姓名.Text = "姓名";
			// 
			// 性别
			// 
			this.性别.Text = "性别";
			this.性别.Width = 30;
			// 
			// 出身年月
			// 
			this.出身年月.Text = "出生年月";
			// 
			// 层次
			// 
			this.层次.Text = "层次";
			//