employeemanage.cs

人事,工资,考勤系统,C#实现 1、查看建模图 本文件夹中的Model目录下包含了系统的数据库模型图和系统建模图

			this.dataGridTextBoxColumn8.Width = 75;
			// 
			// dataGridTextBoxColumn5
			// 
			this.dataGridTextBoxColumn5.Format = "";
			this.dataGridTextBoxColumn5.FormatInfo = null;
			this.dataGridTextBoxColumn5.HeaderText = "性别";
			this.dataGridTextBoxColumn5.MappingName = "Sex";
			this.dataGridTextBoxColumn5.Width = 75;
			// 
			// dataGridTextBoxColumn3
			// 
			this.dataGridTextBoxColumn3.Format = "";
			this.dataGridTextBoxColumn3.FormatInfo = null;
			this.dataGridTextBoxColumn3.HeaderText = "部门";
			this.dataGridTextBoxColumn3.MappingName = "Department";
			this.dataGridTextBoxColumn3.Width = 75;
			// 
			// dataGridTextBoxColumn6
			// 
			this.dataGridTextBoxColumn6.Format = "";
			this.dataGridTextBoxColumn6.FormatInfo = null;
			this.dataGridTextBoxColumn6.HeaderText = "职称";
			this.dataGridTextBoxColumn6.MappingName = "Title";
			this.dataGridTextBoxColumn6.Width = 75;
			// 
			// dataGridTextBoxColumn7
			// 
			this.dataGridTextBoxColumn7.Format = "";
			this.dataGridTextBoxColumn7.FormatInfo = null;
			this.dataGridTextBoxColumn7.HeaderText = "职务";
			this.dataGridTextBoxColumn7.MappingName = "Duty";
			this.dataGridTextBoxColumn7.Width = 75;
			// 
			// dataGridTextBoxColumn19
			// 
			this.dataGridTextBoxColumn19.Format = "";
			this.dataGridTextBoxColumn19.FormatInfo = null;
			this.dataGridTextBoxColumn19.HeaderText = "学历";
			this.dataGridTextBoxColumn19.MappingName = "Degree";
			this.dataGridTextBoxColumn19.Width = 75;
			// 
			// dataGridTextBoxColumn20
			// 
			this.dataGridTextBoxColumn20.Format = "";
			this.dataGridTextBoxColumn20.FormatInfo = null;
			this.dataGridTextBoxColumn20.HeaderText = "毕业学校";
			this.dataGridTextBoxColumn20.MappingName = "GraduateSchool";
			this.dataGridTextBoxColumn20.Width = 75;
			// 
			// dataGridTextBoxColumn9
			// 
			this.dataGridTextBoxColumn9.Format = "";
			this.dataGridTextBoxColumn9.FormatInfo = null;
			this.dataGridTextBoxColumn9.HeaderText = "就职日期";
			this.dataGridTextBoxColumn9.MappingName = "InDate";
			this.dataGridTextBoxColumn9.Width = 75;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.label22);
			this.groupBox2.Controls.Add(this.comboTitle2);
			this.groupBox2.Controls.Add(this.label19);
			this.groupBox2.Controls.Add(this.textEmployeeID2);
			this.groupBox2.Controls.Add(this.label20);
			this.groupBox2.Controls.Add(this.comboDepartment2);
			this.groupBox2.Location = new System.Drawing.Point(24, 16);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(440, 72);
			this.groupBox2.TabIndex = 0;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "职工查询";
			// 
			// label22
			// 
			this.label22.Location = new System.Drawing.Point(288, 32);
			this.label22.Name = "label22";
			this.label22.Size = new System.Drawing.Size(32, 23);
			this.label22.TabIndex = 116;
			this.label22.Text = "职称";
			// 
			// comboTitle2
			// 
			this.comboTitle2.Location = new System.Drawing.Point(336, 32);
			this.comboTitle2.Name = "comboTitle2";
			this.comboTitle2.Size = new System.Drawing.Size(72, 20);
			this.comboTitle2.TabIndex = 115;
			// 
			// label19
			// 
			this.label19.Location = new System.Drawing.Point(16, 32);
			this.label19.Name = "label19";
			this.label19.Size = new System.Drawing.Size(48, 23);
			this.label19.TabIndex = 114;
			this.label19.Text = "职工号";
			// 
			// textEmployeeID2
			// 
			this.textEmployeeID2.Location = new System.Drawing.Point(72, 32);
			this.textEmployeeID2.Name = "textEmployeeID2";
			this.textEmployeeID2.Size = new System.Drawing.Size(80, 21);
			this.textEmployeeID2.TabIndex = 113;
			this.textEmployeeID2.Text = "";
			// 
			// label20
			// 
			this.label20.Location = new System.Drawing.Point(160, 32);
			this.label20.Name = "label20";
			this.label20.Size = new System.Drawing.Size(40, 23);
			this.label20.TabIndex = 112;
			this.label20.Text = "部门";
			// 
			// comboDepartment2
			// 
			this.comboDepartment2.Location = new System.Drawing.Point(200, 32);
			this.comboDepartment2.Name = "comboDepartment2";
			this.comboDepartment2.Size = new System.Drawing.Size(72, 20);
			this.comboDepartment2.TabIndex = 111;
			// 
			// tabPage3
			// 
			this.tabPage3.Controls.Add(this.groupBox7);
			this.tabPage3.Controls.Add(this.dataGrid3);
			this.tabPage3.Controls.Add(this.groupBox6);
			this.tabPage3.Location = new System.Drawing.Point(4, 21);
			this.tabPage3.Name = "tabPage3";
			this.tabPage3.Size = new System.Drawing.Size(840, 559);
			this.tabPage3.TabIndex = 2;
			this.tabPage3.Text = "离职员工查询";
			// 
			// groupBox7
			// 
			this.groupBox7.Controls.Add(this.button4);
			this.groupBox7.Controls.Add(this.button1);
			this.groupBox7.Controls.Add(this.button2);
			this.groupBox7.Controls.Add(this.btnDimmisionExport);
			this.groupBox7.Location = new System.Drawing.Point(728, 24);
			this.groupBox7.Name = "groupBox7";
			this.groupBox7.Size = new System.Drawing.Size(96, 424);
			this.groupBox7.TabIndex = 125;
			this.groupBox7.TabStop = false;
			// 
			// button4
			// 
			this.button4.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.button4.Image = ((System.Drawing.Image)(resources.GetObject("button4.Image")));
			this.button4.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button4.Location = new System.Drawing.Point(24, 104);
			this.button4.Name = "button4";
			this.button4.Size = new System.Drawing.Size(56, 24);
			this.button4.TabIndex = 123;
			this.button4.Text = "全部";
			this.button4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.button4.Click += new System.EventHandler(this.button4_Click);
			// 
			// button1
			// 
			this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.button1.Image = ((System.Drawing.Image)(resources.GetObject("button1.Image")));
			this.button1.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button1.Location = new System.Drawing.Point(24, 32);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(56, 24);
			this.button1.TabIndex = 119;
			this.button1.Text = "取消";
			this.button1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// button2
			// 
			this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.button2.Image = ((System.Drawing.Image)(resources.GetObject("button2.Image")));
			this.button2.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button2.Location = new System.Drawing.Point(24, 64);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(56, 24);
			this.button2.TabIndex = 120;
			this.button2.Text = "查找";
			this.button2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// btnDimmisionExport
			// 
			this.btnDimmisionExport.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnDimmisionExport.Image = ((System.Drawing.Image)(resources.GetObject("btnDimmisionExport.Image")));
			this.btnDimmisionExport.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnDimmisionExport.Location = new System.Drawing.Point(24, 256);
			this.btnDimmisionExport.Name = "btnDimmisionExport";
			this.btnDimmisionExport.Size = new System.Drawing.Size(56, 24);
			this.btnDimmisionExport.TabIndex = 121;
			this.btnDimmisionExport.Text = "导出";
			this.btnDimmisionExport.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnDimmisionExport.Click += new System.EventHandler(this.btnDimmisionExport_Click);
			// 
			// dataGrid3
			// 
			this.dataGrid3.AlternatingBackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid3.BackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid3.BackgroundColor = System.Drawing.Color.Lavender;
			this.dataGrid3.BorderStyle = System.Windows.Forms.BorderStyle.None;
			this.dataGrid3.CaptionBackColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid3.CaptionForeColor = System.Drawing.Color.White;
			this.dataGrid3.DataMember = "";
			this.dataGrid3.FlatMode = true;
			this.dataGrid3.Font = new System.Drawing.Font("Tahoma", 8F);
			this.dataGrid3.ForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid3.GridLineColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid3.HeaderBackColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid3.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dataGrid3.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dataGrid3.LinkColor = System.Drawing.Color.Teal;
			this.dataGrid3.Location = new System.Drawing.Point(24, 120);
			this.dataGrid3.Name = "dataGrid3";
			this.dataGrid3.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dataGrid3.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid3.SelectionBackColor = System.Drawing.Color.Teal;
			this.dataGrid3.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dataGrid3.Size = new System.Drawing.Size(672, 328);
			this.dataGrid3.TabIndex = 124;
			this.dataGrid3.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle2});
			// 
			// dataGridTableStyle2
			// 
			this.dataGridTableStyle2.DataGrid = this.dataGrid3;
			this.dataGridTableStyle2.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn10,
																												  this.dataGridTextBoxColumn11,
																												  this.dataGridTextBoxColumn21,
																												  this.dataGridTextBoxColumn22,
																												  this.dataGridTextBoxColumn23,
																												  this.dataGridTextBoxColumn24,
																												  this.dataGridTextBoxColumn25,
																												  this.dataGridTextBoxColumn12,
																												  this.dataGridTextBoxColumn13});
			this.dataGridTableStyle2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle2.MappingName = "Dimmision";
			// 
			// dataGridTextBoxColumn10
			// 
			this.dataGridTextBoxColumn10.Format = "";
			this.dataGridTextBoxColumn10.FormatInfo = null;
			this.dataGridTextBoxColumn10.HeaderText = "职工号";
			this.dataGridTextBoxColumn10.MappingName = "EmployeeID";
			this.dataGridTextBoxColumn10.Width = 75;
			// 
			// dataGridTextBoxColumn11
			// 
			this.dataGridTextBoxColumn11.Format = "";
			this.dataGridTextBoxColumn11.FormatInfo = null;
			this.dataGridTextBoxColumn11.HeaderText = "姓名";
			this.dataGridTextBoxColumn11.MappingName = "EmployeeName";
			this.dataGridTextBoxColumn11.Width = 75;
			// 
			// dataGridTextBoxColumn21
			// 
			this.dataGridTextBoxColumn21.Format = "";
			this.dataGridTextBoxColumn21.FormatInfo = null;
			this.dataGridTextBoxColumn21.HeaderText = "性别";
			this.dataGridTextBoxColumn21.MappingName = "Sex";
			this.dataGridTextBoxColumn21.Width = 75;
			// 
			// dataGridTextBoxColumn22
			// 
			this.dataGridTextBoxColumn22.Format = "";
			this.dataGridTextBoxColumn22.FormatInfo = null;
			this.dataGridTextBoxColumn22.HeaderText = "年龄";
			this.dataGridTextBoxColumn22.MappingName = "Age";
			this.dataGridTextBoxColumn22.Width = 75;
			// 
			// dataGridTextBoxColumn23
			// 
			this.dataGridTextBoxColumn23.Format = "";
			this.dataGridTextBoxColumn23.FormatInfo = null;
			this.dataGridTextBoxColumn23.HeaderText = "部门";
			this.dataGridTextBoxColumn23.MappingName = "Department";
			this.dataGridTextBoxColumn23.Width = 75;
			// 
			// dataGridTextBoxColumn24
			// 
			this.dataGridTextBoxColumn24.Format = "";
			this.dataGridTextBoxColumn24.FormatInfo = null;
			this.dataGridTextBoxColumn24.HeaderText = "职称";
			this.dataGridTextBoxColumn24.MappingName = "Title";
			this.dataGridTextBoxColumn24.Width = 75;
			// 
			// dataGridTextBoxColumn25
			// 
			this.dataGridTextBoxColumn25.Format = "";
			this.dataGridTextBoxColumn25.FormatInfo = null;
			this.dataGridTextB