inputdata.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
{
	public  struct textAll
	{
		public string name ;
		public string sex;
		public string birthYear ;
		public string birthMonth ;
		public string birthDay;
		public string termYear ;
		public string schName ;
		public string schCourse ;
		public string schYear;
		public string schMonth;
		public string graYear ;
		public string graMonth;
		public string degree ;
		public string degreeNum ;
		public string degreeKind;
	}
	/// <summary>
	/// InputData 的摘要说明。
	/// </summary>
	public class InputData : System.Windows.Forms.UserControl
	{
		public static bool stuState = false;
		public static bool NoQuery = true;
		public static textAll trans =  new textAll();
		private DBAgent db = new DBAgent( );

		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label lbl2;
		private System.Windows.Forms.Label lbl4;
		private System.Windows.Forms.Label lbl6;
		private System.Windows.Forms.Label lbl1;
		private System.Windows.Forms.Label lbl5;
		private System.Windows.Forms.Label lbl3;
		private System.Windows.Forms.Label lbl8;
		private System.Windows.Forms.Label lbl12;
		private System.Windows.Forms.Label lbl11;
		private System.Windows.Forms.Label lbl7;
		private System.Windows.Forms.Label lbl9;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label lblName;
		private System.Windows.Forms.Label lblSex;
		private System.Windows.Forms.Label lblBirthday;
		private System.Windows.Forms.Label lblClass;
		private System.Windows.Forms.Label lblDiploma;
		private System.Windows.Forms.Label lblSchool;
		private System.Windows.Forms.Label lblSystem;
		private System.Windows.Forms.Label lblSpecialty;
		private System.Windows.Forms.Label lblEnrollment;
		private System.Windows.Forms.Label lblGraduation;
		private System.Windows.Forms.Label lblDiplomaID;
		private System.Windows.Forms.ToolTip 提示拦;
		private System.Windows.Forms.RadioButton rb2;
		private System.Windows.Forms.RadioButton rb1;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.CheckBox ckXm;
		private System.Windows.Forms.CheckBox ckCsrq;
		private System.Windows.Forms.CheckBox ckPycc;
		private System.Windows.Forms.CheckBox ckYxmc;
		private System.Windows.Forms.CheckBox ckXz;
		private System.Windows.Forms.CheckBox ckZymc;
		private System.Windows.Forms.CheckBox ckRxrq;
		private System.Windows.Forms.CheckBox ckZsbh;
		private System.Windows.Forms.ComboBox cbXXXs;
		private System.Windows.Forms.ComboBox cbPycc;
		private System.Windows.Forms.TextBox tbXm;
		private System.Windows.Forms.TextBox tbXz;
		private System.Windows.Forms.TextBox tbZsbh;
		private System.Windows.Forms.TextBox tbYxmc;
		private System.Windows.Forms.TextBox tbZymc;
		private System.Windows.Forms.CheckBox ckXb;
		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.ColumnHeader 证书编号;
		private System.Windows.Forms.ListView lvInput;
		private System.Windows.Forms.Panel Panel1;
		private System.Windows.Forms.Panel Panel2;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.PictureBox pictureBox2;
		private System.Windows.Forms.PictureBox pictureBox3;
		private System.Windows.Forms.PictureBox pictureBox4;
		private System.Windows.Forms.DateTimePicker dtRxrq;
		private System.Windows.Forms.DateTimePicker dtByrq;
		private System.Windows.Forms.FolderBrowserDialog fbdd;
		private System.Windows.Forms.TextBox tbBirth;
		private System.ComponentModel.IContainer components;
		

		public InputData()
		{
			// 该调用是 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(InputData));
			this.Panel1 = new System.Windows.Forms.Panel();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.tbBirth = new System.Windows.Forms.TextBox();
			this.dtByrq = new System.Windows.Forms.DateTimePicker();
			this.dtRxrq = new System.Windows.Forms.DateTimePicker();
			this.ckXb = new System.Windows.Forms.CheckBox();
			this.ckXm = new System.Windows.Forms.CheckBox();
			this.rb2 = new System.Windows.Forms.RadioButton();
			this.rb1 = new System.Windows.Forms.RadioButton();
			this.cbXXXs = new System.Windows.Forms.ComboBox();
			this.cbPycc = new System.Windows.Forms.ComboBox();
			this.tbXm = new System.Windows.Forms.TextBox();
			this.lbl2 = new System.Windows.Forms.Label();
			this.lbl4 = new System.Windows.Forms.Label();
			this.lbl6 = new System.Windows.Forms.Label();
			this.lbl1 = new System.Windows.Forms.Label();
			this.lbl5 = new System.Windows.Forms.Label();
			this.lbl3 = new System.Windows.Forms.Label();
			this.lbl8 = new System.Windows.Forms.Label();
			this.lbl12 = new System.Windows.Forms.Label();
			this.lbl11 = new System.Windows.Forms.Label();
			this.lbl7 = new System.Windows.Forms.Label();
			this.lbl9 = new System.Windows.Forms.Label();
			this.tbXz = new System.Windows.Forms.TextBox();
			this.tbZsbh = new System.Windows.Forms.TextBox();
			this.tbYxmc = new System.Windows.Forms.TextBox();
			this.tbZymc = new System.Windows.Forms.TextBox();
			this.label13 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.ckCsrq = new System.Windows.Forms.CheckBox();
			this.ckPycc = new System.Windows.Forms.CheckBox();
			this.ckYxmc = new System.Windows.Forms.CheckBox();
			this.ckXz = new System.Windows.Forms.CheckBox();
			this.ckZymc = new System.Windows.Forms.CheckBox();
			this.ckRxrq = new System.Windows.Forms.CheckBox();
			this.ckZsbh = new System.Windows.Forms.CheckBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.lblName = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.lblSex = new System.Windows.Forms.Label();
			this.lblBirthday = new System.Windows.Forms.Label();
			this.lblClass = new System.Windows.Forms.Label();
			this.lblDiploma = new System.Windows.Forms.Label();
			this.lblSchool = new System.Windows.Forms.Label();
			this.lblSystem = new System.Windows.Forms.Label();
			this.lblSpecialty = new System.Windows.Forms.Label();
			this.lblEnrollment = new System.Windows.Forms.Label();
			this.lblGraduation = new System.Windows.Forms.Label();
			this.lblDiplomaID = new System.Windows.Forms.Label();
			this.Panel2 = new System.Windows.Forms.Panel();
			this.lvInput = 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.ToolTip(this.components);
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.pictureBox2 = new System.Windows.Forms.PictureBox();
			this.pictureBox3 = new System.Windows.Forms.PictureBox();
			this.pictureBox4 = new System.Windows.Forms.PictureBox();
			this.fbdd = new System.Windows.Forms.FolderBrowserDialog();
			this.Panel1.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.Panel2.SuspendLayout();
			this.SuspendLayout();
			// 
			// Panel1
			// 
			this.Panel1.Controls.Add(this.groupBox1);
			this.Panel1.Controls.Add(this.groupBox2);
			this.Panel1.Location = new System.Drawing.Point(16, 0);
			this.Panel1.Name = "Panel1";
			this.Panel1.Size = new System.Drawing.Size(576, 392);
			this.Panel1.TabIndex = 1;
			this.Panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel1_Paint);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.tbBirth);
			this.groupBox1.Controls.Add(this.dtByrq);
			this.groupBox1.Controls.Add(this.dtRxrq);
			this.groupBox1.Controls.Add(this.ckXb);
			this.groupBox1.Controls.Add(this.ckXm);
			this.groupBox1.Controls.Add(this.rb2);
			this.groupBox1.Controls.Add(this.rb1);
			this.groupBox1.Controls.Add(this.cbXXXs);
			this.groupBox1.Controls.Add(this.cbPycc);
			this.groupBox1.Controls.Add(this.tbXm);
			this.groupBox1.Controls.Add(this.lbl2);
			this.groupBox1.Controls.Add(this.lbl4);
			this.groupBox1.Controls.Add(this.lbl6);
			this.groupBox1.Controls.Add(this.lbl1);
			this.groupBox1.Controls.Add(this.lbl5);
			this.groupBox1.Controls.Add(this.lbl3);
			this.groupBox1.Controls.Add(this.lbl8);
			this.groupBox1.Controls.Add(this.lbl12);
			this.groupBox1.Controls.Add(this.lbl11);
			this.groupBox1.Controls.Add(this.lbl7);
			this.groupBox1.Controls.Add(this.lbl9);
			this.groupBox1.Controls.Add(this.tbXz);
			this.groupBox1.Controls.Add(this.tbZsbh);
			this.groupBox1.Controls.Add(this.tbYxmc);
			this.groupBox1.Controls.Add(this.tbZymc);
			this.groupBox1.Controls.Add(this.label13);
			this.groupBox1.Controls.Add(this.label14);
			this.groupBox1.Controls.Add(this.ckCsrq);
			this.groupBox1.Controls.Add(this.ckPycc);
			this.groupBox1.Controls.Add(this.ckYxmc);
			this.groupBox1.Controls.Add(this.ckXz);
			this.groupBox1.Controls.Add(this.ckZymc);
			this.groupBox1.Controls.Add(this.ckRxrq);
			this.groupBox1.Controls.Add(this.ckZsbh);
			this.groupBox1.Location = new System.Drawing.Point(8, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(280, 376);
			this.groupBox1.TabIndex = 5;
			this.groupBox1.TabStop = false;
			this.groupBox1.Tag = "";
			this.groupBox1.Text = "录入系统";
			// 
			// tbBirth
			// 
			this.tbBirth.Location = new System.Drawing.Point(88, 83);
			this.tbBirth.Name = "tbBirth";
			this.tbBirth.Size = new System.Drawing.Size(152, 21);
			this.tbBirth.TabIndex = 12;
			this.tbBirth.Text = "";
			// 
			// dtByrq
			// 
			this.dtByrq.Location = new System.Drawing.Point(88, 312);
			this.dtByrq.Name = "dtByrq";
			this.dtByrq.Size = new System.Drawing.Size(152, 21);
			this.dtByrq.TabIndex = 10;
			// 
			// dtRxrq
			// 
			this.dtRxrq.Location = new System.Drawing.Point(88, 280);
			this.dtRxrq.Name = "dtRxrq";
			this.dtRxrq.Size = new System.Drawing.Size(152, 21);
			this.dtRxrq.TabIndex = 9;
			// 
			// ckXb
			// 
			this.ckXb.FlatStyle = System.Windows.Forms.FlatStyle.System;
			this.ckXb.Location = new System.Drawing.Point(248, 52);
			this.ckXb.Name = "ckXb";
			this.ckXb.Size = new System.Drawing.Size(16, 24);
			this.ckXb.TabIndex = 11;
			this.ckXb.TabStop = false;
			// 
			// ckXm
			// 
			this.ckXm.Checked = true;
			this.ckXm.CheckState = System.Windows.Forms.CheckState.Checked;
			this.ckXm.FlatStyle = System.Windows.Forms.FlatStyle.System;
			this.ckXm.Location = new System.Drawing.Point(248, 25);
			this.ckXm.Name = "ckXm";
			this.ckXm.Size = new System.Drawing.Size(16, 24);
			this.ckXm.TabIndex = 8;
			this.ckXm.TabStop = false;
			// 
			// rb2
			// 
			this.rb2.FlatStyle = System.Windows.Forms.FlatStyle.System;
			this.rb2.Location = new System.Drawing.Point(152, 51);
			this.rb2.Name = "rb2";
			this.rb2.Size = new System.Drawing.Size(40, 24);
			this.rb2.TabIndex = 3;
			this.rb2.Text = "女";
			// 
			// rb1
			// 
			this.rb1.Checked = true;
			this.rb1.FlatStyle = System.Windows.Forms.FlatStyle.System;
			this.rb1.Location = new System.Drawing.Point(96, 50);
			this.rb1.Name = "rb1";
			this.rb1.Size = new System.Drawing.Size(32, 24);
			this.rb1.TabIndex = 2;
			this.rb1.TabStop = true;
			this.rb1.Text = "男";
			// 
			// cbXXXs
			// 
			this.cbXXXs.Items.AddRange(new object[] {
														"普通全日制",
														"成人",
														"网络教育",
														"研究生"});
			this.cbXXXs.Location = new System.Drawing.Point(88, 147);
			this.cbXXXs.Name = "cbXXXs";
			this.cbXXXs.Size = new System.Drawing.Size(152, 20);
			this.cbXXXs.TabIndex = 5;
			this.cbXXXs.Text = "请选择或输入新项";
			// 
			// cbPycc
			// 
			this.cbPycc.Items.AddRange(new object[] {
														"博士研究生",
														"硕士研究生",
														"研究生",
														"第二学士学位",
														"本科",
														"高升本",
														"专升本",
														"第二本科",
														"专科",
														"高职",
														"第二专科",
														"夜大电大函大普通班",
														"中专",
														"不详"});
			this.cbPycc.Location = new System.Drawing.Point(88, 115);
			this.cbPycc.Name = "cbPycc";
			this.cbPycc.Size = new System.Drawing.Size(152, 20);
			this.cbPycc.TabIndex = 4;