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 入學(xué)時(shí)間;
		private System.Windows.Forms.ColumnHeader 畢業(yè)時(shí)間;
		private System.Windows.Forms.ColumnHeader 證書編號(hào);
		private System.Windows.Forms.ColumnHeader 畢結(jié)業(yè)結(jié)論;
		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 學(xué)歷類型;
		private System.Windows.Forms.ColumnHeader 學(xué)制;
		private System.Windows.Forms.ColumnHeader 院校名稱;
		private System.Windows.Forms.ColumnHeader 專業(yè)名稱;
		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()
		{
			// 該調(diào)用是 Windows.Forms 窗體設(shè)計(jì)器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 調(diào)用后添加任何初始化

		}

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

		#region 組件設(shè)計(jì)器生成的代碼
		/// <summary> 
		/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器 
		/// 修改此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Query));
			this.入學(xué)時(shí)間 = new System.Windows.Forms.ColumnHeader();
			this.畢業(yè)時(shí)間 = new System.Windows.Forms.ColumnHeader();
			this.證書編號(hào) = new System.Windows.Forms.ColumnHeader();
			this.label3 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.畢結(jié)業(yè)結(jié)論 = 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.學(xué)歷類型 = new System.Windows.Forms.ColumnHeader();
			this.學(xué)制 = new System.Windows.Forms.ColumnHeader();
			this.院校名稱 = new System.Windows.Forms.ColumnHeader();
			this.專業(yè)名稱 = 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();
			// 
			// 入學(xué)時(shí)間
			// 
			this.入學(xué)時(shí)間.Text = "入學(xué)時(shí)間";
			// 
			// 畢業(yè)時(shí)間
			// 
			this.畢業(yè)時(shí)間.Text = "畢業(yè)時(shí)間";
			// 
			// 證書編號(hào)
			// 
			this.證書編號(hào).Text = "證書編號(hào)";
			// 
			// 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 = "證書編號(hào):";
			// 
			// 畢結(jié)業(yè)結(jié)論
			// 
			this.畢結(jié)業(yè)結(jié)論.Text = "畢結(jié)業(yè)結(jié)論";
			// 
			// 姓名
			// 
			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.學(xué)歷類型,
																				 this.學(xué)制,
																				 this.院校名稱,
																				 this.專業(yè)名稱,
																				 this.畢結(jié)業(yè)結(jié)論,
																				 this.入學(xué)時(shí)間,
																				 this.畢業(yè)時(shí)間,
																				 this.證書編號(hào)});
			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 = "層次";
			// 
			// 學(xué)歷類型
			// 
			this.學(xué)歷類型.Text = "學(xué)歷類型";
			// 
			// 學(xué)制
			// 
			this.學(xué)制.Text = "學(xué)制";
			// 
			// 院校名稱
			// 
			this.院校名稱.Text = "院校名稱";
			// 
			// 專業(yè)名稱
			// 
			this.專業(yè)名稱.Text = "專業(yè)名稱";
			// 
			// 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, "姓名或證書編號(hào)任填一項(xiàng)");
			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;