employeemanage.cs

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

			// 
			// label9
			// 
			this.label9.Location = new System.Drawing.Point(184, 208);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(40, 23);
			this.label9.TabIndex = 97;
			this.label9.Text = "性别";
			// 
			// label8
			// 
			this.label8.Location = new System.Drawing.Point(24, 248);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(40, 23);
			this.label8.TabIndex = 96;
			this.label8.Text = "工种";
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(184, 320);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(40, 32);
			this.label7.TabIndex = 95;
			this.label7.Text = "政治身份";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(24, 176);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(40, 23);
			this.label6.TabIndex = 94;
			this.label6.Text = "部门";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(24, 208);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(32, 23);
			this.label5.TabIndex = 93;
			this.label5.Text = "职务";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(184, 248);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(32, 23);
			this.label4.TabIndex = 92;
			this.label4.Text = "职称";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(184, 288);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(32, 23);
			this.label3.TabIndex = 91;
			this.label3.Text = "民族";
			// 
			// comboWorkType
			// 
			this.comboWorkType.Location = new System.Drawing.Point(80, 248);
			this.comboWorkType.Name = "comboWorkType";
			this.comboWorkType.Size = new System.Drawing.Size(72, 20);
			this.comboWorkType.TabIndex = 79;
			// 
			// comboStatus
			// 
			this.comboStatus.Location = new System.Drawing.Point(240, 328);
			this.comboStatus.Name = "comboStatus";
			this.comboStatus.Size = new System.Drawing.Size(72, 20);
			this.comboStatus.TabIndex = 78;
			// 
			// comboDepartment
			// 
			this.comboDepartment.Location = new System.Drawing.Point(80, 168);
			this.comboDepartment.Name = "comboDepartment";
			this.comboDepartment.Size = new System.Drawing.Size(72, 20);
			this.comboDepartment.TabIndex = 77;
			// 
			// comboTitle
			// 
			this.comboTitle.Location = new System.Drawing.Point(240, 248);
			this.comboTitle.Name = "comboTitle";
			this.comboTitle.Size = new System.Drawing.Size(72, 20);
			this.comboTitle.TabIndex = 82;
			// 
			// comboDuty
			// 
			this.comboDuty.Location = new System.Drawing.Point(80, 208);
			this.comboDuty.Name = "comboDuty";
			this.comboDuty.Size = new System.Drawing.Size(72, 20);
			this.comboDuty.TabIndex = 81;
			// 
			// comboNation
			// 
			this.comboNation.Location = new System.Drawing.Point(240, 288);
			this.comboNation.Name = "comboNation";
			this.comboNation.Size = new System.Drawing.Size(72, 20);
			this.comboNation.TabIndex = 80;
			// 
			// dateTimePicker1
			// 
			this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Short;
			this.dateTimePicker1.Location = new System.Drawing.Point(160, 384);
			this.dateTimePicker1.Name = "dateTimePicker1";
			this.dateTimePicker1.Size = new System.Drawing.Size(136, 21);
			this.dateTimePicker1.TabIndex = 87;
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(80, 384);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(64, 23);
			this.label1.TabIndex = 89;
			this.label1.Text = "就职时间";
			// 
			// btnApply
			// 
			this.btnApply.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnApply.Image = ((System.Drawing.Image)(resources.GetObject("btnApply.Image")));
			this.btnApply.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnApply.Location = new System.Drawing.Point(352, 40);
			this.btnApply.Name = "btnApply";
			this.btnApply.Size = new System.Drawing.Size(56, 24);
			this.btnApply.TabIndex = 95;
			this.btnApply.Text = "确定";
			this.btnApply.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCancel.Image")));
			this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCancel.Location = new System.Drawing.Point(352, 16);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.Size = new System.Drawing.Size(56, 24);
			this.btnCancel.TabIndex = 94;
			this.btnCancel.Text = "取消";
			this.btnCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// tabPage2
			// 
			this.tabPage2.Controls.Add(this.groupBox8);
			this.tabPage2.Controls.Add(this.dataGrid2);
			this.tabPage2.Controls.Add(this.groupBox2);
			this.tabPage2.Location = new System.Drawing.Point(4, 21);
			this.tabPage2.Name = "tabPage2";
			this.tabPage2.Size = new System.Drawing.Size(840, 559);
			this.tabPage2.TabIndex = 1;
			this.tabPage2.Text = "查询员工";
			// 
			// groupBox8
			// 
			this.groupBox8.Controls.Add(this.btnEmployeeExport);
			this.groupBox8.Controls.Add(this.btnSearchCancel);
			this.groupBox8.Controls.Add(this.btnEmployeeSearch);
			this.groupBox8.Controls.Add(this.btnEmployeeSearchAll);
			this.groupBox8.Location = new System.Drawing.Point(480, 16);
			this.groupBox8.Name = "groupBox8";
			this.groupBox8.Size = new System.Drawing.Size(336, 72);
			this.groupBox8.TabIndex = 125;
			this.groupBox8.TabStop = false;
			// 
			// btnEmployeeExport
			// 
			this.btnEmployeeExport.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnEmployeeExport.Image = ((System.Drawing.Image)(resources.GetObject("btnEmployeeExport.Image")));
			this.btnEmployeeExport.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEmployeeExport.Location = new System.Drawing.Point(240, 24);
			this.btnEmployeeExport.Name = "btnEmployeeExport";
			this.btnEmployeeExport.Size = new System.Drawing.Size(56, 24);
			this.btnEmployeeExport.TabIndex = 117;
			this.btnEmployeeExport.Text = "导出";
			this.btnEmployeeExport.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnEmployeeExport.Click += new System.EventHandler(this.btnEmployeeExport_Click);
			// 
			// btnSearchCancel
			// 
			this.btnSearchCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnSearchCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnSearchCancel.Image")));
			this.btnSearchCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnSearchCancel.Location = new System.Drawing.Point(24, 24);
			this.btnSearchCancel.Name = "btnSearchCancel";
			this.btnSearchCancel.Size = new System.Drawing.Size(56, 24);
			this.btnSearchCancel.TabIndex = 115;
			this.btnSearchCancel.Text = "取消";
			this.btnSearchCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// btnEmployeeSearch
			// 
			this.btnEmployeeSearch.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnEmployeeSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnEmployeeSearch.Image")));
			this.btnEmployeeSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEmployeeSearch.Location = new System.Drawing.Point(88, 24);
			this.btnEmployeeSearch.Name = "btnEmployeeSearch";
			this.btnEmployeeSearch.Size = new System.Drawing.Size(56, 24);
			this.btnEmployeeSearch.TabIndex = 116;
			this.btnEmployeeSearch.Text = "查找";
			this.btnEmployeeSearch.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnEmployeeSearch.Click += new System.EventHandler(this.btnEmployeeSearch_Click);
			// 
			// btnEmployeeSearchAll
			// 
			this.btnEmployeeSearchAll.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnEmployeeSearchAll.Image = ((System.Drawing.Image)(resources.GetObject("btnEmployeeSearchAll.Image")));
			this.btnEmployeeSearchAll.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEmployeeSearchAll.Location = new System.Drawing.Point(160, 24);
			this.btnEmployeeSearchAll.Name = "btnEmployeeSearchAll";
			this.btnEmployeeSearchAll.Size = new System.Drawing.Size(56, 24);
			this.btnEmployeeSearchAll.TabIndex = 124;
			this.btnEmployeeSearchAll.Text = "全部";
			this.btnEmployeeSearchAll.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnEmployeeSearchAll.Click += new System.EventHandler(this.btnEmployeeSearchAll_Click);
			// 
			// dataGrid2
			// 
			this.dataGrid2.AlternatingBackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid2.BackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid2.BackgroundColor = System.Drawing.Color.Lavender;
			this.dataGrid2.BorderStyle = System.Windows.Forms.BorderStyle.None;
			this.dataGrid2.CaptionBackColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid2.CaptionForeColor = System.Drawing.Color.White;
			this.dataGrid2.DataMember = "";
			this.dataGrid2.FlatMode = true;
			this.dataGrid2.Font = new System.Drawing.Font("Tahoma", 8F);
			this.dataGrid2.ForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.GridLineColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid2.HeaderBackColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dataGrid2.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dataGrid2.LinkColor = System.Drawing.Color.Teal;
			this.dataGrid2.Location = new System.Drawing.Point(32, 120);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dataGrid2.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.SelectionBackColor = System.Drawing.Color.Teal;
			this.dataGrid2.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dataGrid2.Size = new System.Drawing.Size(784, 392);
			this.dataGrid2.TabIndex = 118;
			this.dataGrid2.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle1});
			// 
			// dataGridTableStyle1
			// 
			this.dataGridTableStyle1.DataGrid = this.dataGrid2;
			this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn1,
																												  this.dataGridTextBoxColumn2,
																												  this.dataGridTextBoxColumn4,
																												  this.dataGridTextBoxColumn8,
																												  this.dataGridTextBoxColumn5,
																												  this.dataGridTextBoxColumn3,
																												  this.dataGridTextBoxColumn6,
																												  this.dataGridTextBoxColumn7,
																												  this.dataGridTextBoxColumn19,
																												  this.dataGridTextBoxColumn20,
																												  this.dataGridTextBoxColumn9});
			this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle1.MappingName = "Employee";
			// 
			// dataGridTextBoxColumn1
			// 
			this.dataGridTextBoxColumn1.Format = "";
			this.dataGridTextBoxColumn1.FormatInfo = null;
			this.dataGridTextBoxColumn1.HeaderText = "职工号";
			this.dataGridTextBoxColumn1.MappingName = "EmployeeID";
			this.dataGridTextBoxColumn1.Width = 75;
			// 
			// dataGridTextBoxColumn2
			// 
			this.dataGridTextBoxColumn2.Format = "";
			this.dataGridTextBoxColumn2.FormatInfo = null;
			this.dataGridTextBoxColumn2.HeaderText = "姓名";
			this.dataGridTextBoxColumn2.MappingName = "EmployeeName";
			this.dataGridTextBoxColumn2.Width = 75;
			// 
			// dataGridTextBoxColumn4
			// 
			this.dataGridTextBoxColumn4.Format = "Age";
			this.dataGridTextBoxColumn4.FormatInfo = null;
			this.dataGridTextBoxColumn4.HeaderText = "年龄";
			this.dataGridTextBoxColumn4.MappingName = "";
			this.dataGridTextBoxColumn4.Width = 75;
			// 
			// dataGridTextBoxColumn8
			// 
			this.dataGridTextBoxColumn8.Format = "";
			this.dataGridTextBoxColumn8.FormatInfo = null;
			this.dataGridTextBoxColumn8.HeaderText = "民族";
			this.dataGridTextBoxColumn8.MappingName = "Nation";