form2.cs

某企业ERP,人员基本信息模块

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

namespace 人员基本信息管理主界面
{
	/// <summary>
	/// Form2 的摘要说明。
	/// </summary>
	public class Form2 : System.Windows.Forms.Form
	{
		private System.Windows.Forms.MainMenu mainMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.MenuItem menuItem3;
		private System.Windows.Forms.MenuItem menuItem4;
		private System.Windows.Forms.MenuItem menuItem5;
		private System.Windows.Forms.MenuItem menuItem6;
		private System.Windows.Forms.MenuItem menuItem7;
		private System.Windows.Forms.MenuItem menuItem8;
		private System.Windows.Forms.MenuItem menuItem9;
		private System.Windows.Forms.MenuItem menuItem10;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label9;
		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.ToolBarButton toolBarButton4;
		private System.Windows.Forms.ToolBarButton toolBarButton7;
		private System.Windows.Forms.ToolBarButton toolBarButton5;
		private System.Windows.Forms.ToolBarButton toolBarButton2;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ToolBarButton toolBarButton1;
		private System.Windows.Forms.ToolBarButton toolBarButton3;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label29;
		private System.Windows.Forms.Label label27;
		private System.Windows.Forms.Label label26;
		private System.Windows.Forms.Label label25;
		private System.Windows.Forms.Label label24;
		private System.Windows.Forms.Label label23;
		private System.Windows.Forms.Label label22;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label28;
		private System.Windows.Forms.Label label30;
		private System.Windows.Forms.Label label31;
		private System.Windows.Forms.Label label32;
		private System.Windows.Forms.Label label33;
		private System.Windows.Forms.ComboBox comboBox1;
		private System.Windows.Forms.ComboBox comboBoxsex;
		private System.Windows.Forms.TextBox textBoxgraduate;
		private System.Windows.Forms.TextBox textBoxcode;
		private System.Windows.Forms.TextBox textBoxnative;
		private System.Windows.Forms.TextBox textBoxeducation;
		private System.Windows.Forms.TextBox textBoxschool;
		private System.Windows.Forms.TextBox textBoxID;
		private System.Windows.Forms.TextBox textBoxaddress;
		private System.Windows.Forms.TextBox textBoxcontact;
		private System.Windows.Forms.TextBox textBoxname;
		private System.Windows.Forms.TextBox textBoxnation;
		private System.Windows.Forms.TextBox textBoxmajor;
		private System.Windows.Forms.TextBox textBoxworkingday;
		private System.Windows.Forms.TextBox textBoxenrollday;
		private System.Windows.Forms.TextBox textBoxtrying;
		private System.Windows.Forms.TextBox textBoxgrade;
		private System.Windows.Forms.TextBox textBoxoriginalsalary;
		private System.Windows.Forms.TextBox textBoxsalarychangeday;
		private System.Windows.Forms.TextBox textBoxpositionsalary;
		private System.Windows.Forms.TextBox textBoxassureday;
		private System.Windows.Forms.TextBox textBoxassurancekind;
		private System.Windows.Forms.TextBox textBoxduty;
		private System.Windows.Forms.TextBox textBoxpromotionday;
		private System.Windows.Forms.TextBox textBoxchangeday;
		private System.Windows.Forms.TextBox textBoxassuresum;
		private System.Windows.Forms.TextBox textBoxleavingday;
		private System.Windows.Forms.TextBox textBoxremark;
		private System.Windows.Forms.TextBox textBoxfileposition;
		private System.Windows.Forms.TextBox textBoxfilecode;
		private System.Windows.Forms.TextBox textBoxbirthday;
		private System.Windows.Forms.TextBox textBoxtitle;
		private System.Windows.Forms.TextBox textBoxoperator;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		private System.Data.SqlClient.SqlConnection sqlConnection2;
		private 人员基本信息管理主界面.DataSet1 dataSet11;
		private System.Windows.Forms.TextBox textBoxpositionchange;
		private System.Windows.Forms.DateTimePicker dateTimePicker1;
        public  BindingManagerBase bManager1;
		private System.Windows.Forms.ToolBarButton toolBarButton9;   //定义绑定管理器
		public int remark;///新建或修改变量，为0为修改，为1为新建
		public int position;///修改是显示的数据库里的行索引
		public string receive; 
		private System.Windows.Forms.MenuItem menuItem11;
		private System.Windows.Forms.ToolBarButton toolBarButton6;
        
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

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

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

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

		#region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.mainMenu1 = new System.Windows.Forms.MainMenu();
			this.menuItem1 = new System.Windows.Forms.MenuItem();
			this.menuItem11 = new System.Windows.Forms.MenuItem();
			this.menuItem3 = new System.Windows.Forms.MenuItem();
			this.menuItem4 = new System.Windows.Forms.MenuItem();
			this.menuItem5 = new System.Windows.Forms.MenuItem();
			this.menuItem6 = new System.Windows.Forms.MenuItem();
			this.menuItem7 = new System.Windows.Forms.MenuItem();
			this.menuItem8 = new System.Windows.Forms.MenuItem();
			this.menuItem9 = new System.Windows.Forms.MenuItem();
			this.menuItem10 = new System.Windows.Forms.MenuItem();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.textBoxbirthday = new System.Windows.Forms.TextBox();
			this.dataSet11 = new 人员基本信息管理主界面.DataSet1();
			this.label32 = new System.Windows.Forms.Label();
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.comboBox1 = new System.Windows.Forms.ComboBox();
			this.comboBoxsex = new System.Windows.Forms.ComboBox();
			this.textBoxgraduate = new System.Windows.Forms.TextBox();
			this.textBoxcode = new System.Windows.Forms.TextBox();
			this.textBoxnative = new System.Windows.Forms.TextBox();
			this.textBoxeducation = new System.Windows.Forms.TextBox();
			this.textBoxschool = new System.Windows.Forms.TextBox();
			this.textBoxID = new System.Windows.Forms.TextBox();
			this.textBoxaddress = new System.Windows.Forms.TextBox();
			this.textBoxcontact = new System.Windows.Forms.TextBox();
			this.textBoxname = new System.Windows.Forms.TextBox();
			this.label13 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.textBoxnation = new System.Windows.Forms.TextBox();
			this.textBoxmajor = new System.Windows.Forms.TextBox();
			this.toolBarButton4 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton7 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton5 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton2 = new System.Windows.Forms.ToolBarButton();
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.toolBarButton9 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton1 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton3 = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton6 = new System.Windows.Forms.ToolBarButton();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.textBoxtitle = new System.Windows.Forms.TextBox();
			this.label33 = new System.Windows.Forms.Label();
			this.textBoxworkingday = new System.Windows.Forms.TextBox();
			this.textBoxenrollday = new System.Windows.Forms.TextBox();
			this.label30 = new System.Windows.Forms.Label();
			this.label31 = new System.Windows.Forms.Label();
			this.textBoxtrying = new System.Windows.Forms.TextBox();
			this.label29 = new System.Windows.Forms.Label();
			this.textBoxgrade = new System.Windows.Forms.TextBox();
			this.textBoxoriginalsalary = new System.Windows.Forms.TextBox();
			this.textBoxsalarychangeday = new System.Windows.Forms.TextBox();
			this.textBoxpositionsalary = new System.Windows.Forms.TextBox();
			this.textBoxassureday = new System.Windows.Forms.TextBox();
			this.textBoxassurancekind = new System.Windows.Forms.TextBox();
			this.textBoxduty = new System.Windows.Forms.TextBox();
			this.textBoxpromotionday = new System.Windows.Forms.TextBox();
			this.textBoxchangeday = new System.Windows.Forms.TextBox();
			this.textBoxassuresum = new System.Windows.Forms.TextBox();
			this.textBoxpositionchange = new System.Windows.Forms.TextBox();
			this.textBoxleavingday = new System.Windows.Forms.TextBox();
			this.textBoxremark = new System.Windows.Forms.TextBox();
			this.textBoxfileposition = new System.Windows.Forms.TextBox();
			this.label27 = new System.Windows.Forms.Label();
			this.label26 = new System.Windows.Forms.Label();
			this.label25 = new System.Windows.Forms.Label();
			this.label24 = new System.Windows.Forms.Label();
			this.label23 = new System.Windows.Forms.Label();
			this.label22 = new System.Windows.Forms.Label();