query.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>
	/// Query 的摘要说明。
	/// </summary>
	public class Query : System.Windows.Forms.UserControl
	{
		public static bool btnYN = false;//
		
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label1;
		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 System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.TextBox txtOldname;
		private System.Windows.Forms.ComboBox cbOlddiploma;
		private System.Windows.Forms.ComboBox cbOldgraduation;
		private System.Windows.Forms.TextBox txtOlddiplomaid;
		private System.Windows.Forms.ToolTip QueryTip;
		private System.ComponentModel.IContainer components;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.FolderBrowserDialog fbd;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private DBAgent db ;

		public Query()
		{
			// 该调用是 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(Query));
			this.入学时间 = new System.Windows.Forms.ColumnHeader();
			this.毕业时间 = new System.Windows.Forms.ColumnHeader();
			this.证书编号 = new System.Windows.Forms.ColumnHeader();
			this.label3 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.毕结业结论 = new System.Windows.Forms.ColumnHeader();
			this.姓名 = new System.Windows.Forms.ColumnHeader();
			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.groupBox1 = new System.Windows.Forms.GroupBox();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.txtOlddiplomaid = new System.Windows.Forms.TextBox();
			this.cbOldgraduation = new System.Windows.Forms.ComboBox();
			this.cbOlddiploma = new System.Windows.Forms.ComboBox();
			this.txtOldname = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.QueryTip = new System.Windows.Forms.ToolTip(this.components);
			this.fbd = new System.Windows.Forms.FolderBrowserDialog();
			this.groupBox1.SuspendLayout();
			this.SuspendLayout();
			// 
			// 入学时间
			// 
			this.入学时间.Text = "入学时间";
			// 
			// 毕业时间
			// 
			this.毕业时间.Text = "毕业时间";
			// 
			// 证书编号
			// 
			this.证书编号.Text = "证书编号";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(16, 48);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(64, 16);
			this.label3.TabIndex = 19;
			this.label3.Text = "姓  名:";
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(368, 93);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(64, 16);
			this.label1.TabIndex = 18;
			this.label1.Text = "证书编号:";
			// 
			// 毕结业结论
			// 
			this.毕结业结论.Text = "毕结业结论";
			// 
			// 姓名
			// 
			this.姓名.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.BackColor = System.Drawing.SystemColors.HighlightText;
			this.lv.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
																				 this.姓名,
																				 this.性别,
																				 this.出身年月,
																				 this.层次,
																				 this.学历类型,
																				 this.学制,
																				 this.院校名称,
																				 this.专业名称,
																				 this.毕结业结论,
																				 this.入学时间,
																				 this.毕业时间,
																				 this.证书编号});
			this.lv.FullRowSelect = true;
			this.lv.Location = new System.Drawing.Point(8, 184);
			this.lv.Name = "lv";
			this.lv.Size = new System.Drawing.Size(576, 312);
			this.lv.TabIndex = 14;
			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.学历类型.Text = "学历类型";
			// 
			// 学制
			// 
			this.学制.Text = "学制";
			// 
			// 院校名称
			// 
			this.院校名称.Text = "院校名称";
			// 
			// 专业名称
			// 
			this.专业名称.Text = "专业名称";
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.label6);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.pictureBox1);
			this.groupBox1.Controls.Add(this.txtOlddiplomaid);
			this.groupBox1.Controls.Add(this.cbOldgraduation);
			this.groupBox1.Controls.Add(this.cbOlddiploma);
			this.groupBox1.Controls.Add(this.txtOldname);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.label2);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Controls.Add(this.label3);
			this.groupBox1.Location = new System.Drawing.Point(8, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(584, 168);
			this.groupBox1.TabIndex = 23;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "旧库查询";
			// 
			// label6
			// 
			this.label6.ForeColor = System.Drawing.Color.Red;
			this.label6.Location = new System.Drawing.Point(208, 91);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(8, 16);
			this.label6.TabIndex = 29;
			this.label6.Text = "*";
			// 
			// label5
			// 
			this.label5.ForeColor = System.Drawing.Color.Red;
			this.label5.Location = new System.Drawing.Point(560, 48);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(8, 16);
			this.label5.TabIndex = 28;
			this.label5.Text = "*";
			// 
			// 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, 128);
			this.pictureBox1.Name = "pictureBox1";
			this.pictureBox1.Size = new System.Drawing.Size(56, 26);
			this.pictureBox1.TabIndex = 27;
			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);
			// 
			// txtOlddiplomaid
			// 
			this.txtOlddiplomaid.Location = new System.Drawing.Point(432, 88);
			this.txtOlddiplomaid.Name = "txtOlddiplomaid";
			this.txtOlddiplomaid.Size = new System.Drawing.Size(120, 21);
			this.txtOlddiplomaid.TabIndex = 4;
			this.txtOlddiplomaid.Tag = "";
			this.txtOlddiplomaid.Text = "";
			this.QueryTip.SetToolTip(this.txtOlddiplomaid, "姓名或证书编号任填一项");
			this.txtOlddiplomaid.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtOlddiplomaid_KeyPress);
			// 
			// cbOldgraduation
			// 
			this.cbOldgraduation.Items.AddRange(new object[] {
																 "2004",
																 "2003",
																 "2002",
																 "2001",
																 "2000"});
			this.cbOldgraduation.Location = new System.Drawing.Point(80, 89);
			this.cbOldgraduation.Name = "cbOldgraduation";
			this.cbOldgraduation.Size = new System.Drawing.Size(121, 20);
			this.cbOldgraduation.TabIndex = 3;