employeemanage.cs

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

			this.dataGrid1.ForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid1.GridLineColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid1.HeaderBackColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid1.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dataGrid1.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dataGrid1.LinkColor = System.Drawing.Color.Teal;
			this.dataGrid1.Location = new System.Drawing.Point(24, 72);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid1.ReadOnly = true;
			this.dataGrid1.SelectionBackColor = System.Drawing.Color.Teal;
			this.dataGrid1.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dataGrid1.Size = new System.Drawing.Size(400, 352);
			this.dataGrid1.TabIndex = 98;
			this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle3});
			this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
			// 
			// dataGridTableStyle3
			// 
			this.dataGridTableStyle3.DataGrid = this.dataGrid1;
			this.dataGridTableStyle3.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn14,
																												  this.dataGridTextBoxColumn15,
																												  this.dataGridTextBoxColumn17,
																												  this.dataGridTextBoxColumn18,
																												  this.dataGridTextBoxColumn16});
			this.dataGridTableStyle3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle3.MappingName = "Employee";
			// 
			// dataGridTextBoxColumn14
			// 
			this.dataGridTextBoxColumn14.Format = "";
			this.dataGridTextBoxColumn14.FormatInfo = null;
			this.dataGridTextBoxColumn14.HeaderText = "职工号";
			this.dataGridTextBoxColumn14.MappingName = "EmployeeID";
			this.dataGridTextBoxColumn14.Width = 75;
			// 
			// dataGridTextBoxColumn15
			// 
			this.dataGridTextBoxColumn15.Format = "";
			this.dataGridTextBoxColumn15.FormatInfo = null;
			this.dataGridTextBoxColumn15.HeaderText = "姓名";
			this.dataGridTextBoxColumn15.MappingName = "EmployeeName";
			this.dataGridTextBoxColumn15.Width = 75;
			// 
			// dataGridTextBoxColumn17
			// 
			this.dataGridTextBoxColumn17.Format = "";
			this.dataGridTextBoxColumn17.FormatInfo = null;
			this.dataGridTextBoxColumn17.HeaderText = "性别";
			this.dataGridTextBoxColumn17.MappingName = "Sex";
			this.dataGridTextBoxColumn17.Width = 75;
			// 
			// dataGridTextBoxColumn18
			// 
			this.dataGridTextBoxColumn18.Format = "";
			this.dataGridTextBoxColumn18.FormatInfo = null;
			this.dataGridTextBoxColumn18.HeaderText = "年龄";
			this.dataGridTextBoxColumn18.MappingName = "Age";
			this.dataGridTextBoxColumn18.Width = 75;
			// 
			// dataGridTextBoxColumn16
			// 
			this.dataGridTextBoxColumn16.Format = "";
			this.dataGridTextBoxColumn16.FormatInfo = null;
			this.dataGridTextBoxColumn16.HeaderText = "部门";
			this.dataGridTextBoxColumn16.MappingName = "Department";
			this.dataGridTextBoxColumn16.Width = 75;
			// 
			// btnExcel
			// 
			this.btnExcel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnExcel.ForeColor = System.Drawing.SystemColors.Desktop;
			this.btnExcel.Image = ((System.Drawing.Image)(resources.GetObject("btnExcel.Image")));
			this.btnExcel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExcel.Location = new System.Drawing.Point(352, 64);
			this.btnExcel.Name = "btnExcel";
			this.btnExcel.Size = new System.Drawing.Size(56, 24);
			this.btnExcel.TabIndex = 106;
			this.btnExcel.Text = "导出";
			this.btnExcel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnExcel.Click += new System.EventHandler(this.btnExcel_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.label18);
			this.groupBox1.Controls.Add(this.textGraduateSchool);
			this.groupBox1.Controls.Add(this.label17);
			this.groupBox1.Controls.Add(this.label16);
			this.groupBox1.Controls.Add(this.label15);
			this.groupBox1.Controls.Add(this.label14);
			this.groupBox1.Controls.Add(this.label13);
			this.groupBox1.Controls.Add(this.textIDCard);
			this.groupBox1.Controls.Add(this.textName);
			this.groupBox1.Controls.Add(this.textNativePlace);
			this.groupBox1.Controls.Add(this.textEmployeeID);
			this.groupBox1.Controls.Add(this.numericUpDown1);
			this.groupBox1.Controls.Add(this.label12);
			this.groupBox1.Controls.Add(this.btnPicture);
			this.groupBox1.Controls.Add(this.label11);
			this.groupBox1.Controls.Add(this.pictureBox1);
			this.groupBox1.Controls.Add(this.comboSex);
			this.groupBox1.Controls.Add(this.comboDegree);
			this.groupBox1.Controls.Add(this.label10);
			this.groupBox1.Controls.Add(this.label9);
			this.groupBox1.Controls.Add(this.label8);
			this.groupBox1.Controls.Add(this.label7);
			this.groupBox1.Controls.Add(this.label6);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.label3);
			this.groupBox1.Controls.Add(this.comboWorkType);
			this.groupBox1.Controls.Add(this.comboStatus);
			this.groupBox1.Controls.Add(this.comboDepartment);
			this.groupBox1.Controls.Add(this.comboTitle);
			this.groupBox1.Controls.Add(this.comboDuty);
			this.groupBox1.Controls.Add(this.comboNation);
			this.groupBox1.Controls.Add(this.dateTimePicker1);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.ForeColor = System.Drawing.SystemColors.Desktop;
			this.groupBox1.Location = new System.Drawing.Point(472, 96);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(352, 440);
			this.groupBox1.TabIndex = 104;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "此员工详细信息";
			// 
			// label18
			// 
			this.label18.Location = new System.Drawing.Point(232, 16);
			this.label18.Name = "label18";
			this.label18.Size = new System.Drawing.Size(48, 23);
			this.label18.TabIndex = 116;
			this.label18.Text = "照片";
			// 
			// textGraduateSchool
			// 
			this.textGraduateSchool.Location = new System.Drawing.Point(80, 328);
			this.textGraduateSchool.Name = "textGraduateSchool";
			this.textGraduateSchool.Size = new System.Drawing.Size(72, 21);
			this.textGraduateSchool.TabIndex = 115;
			this.textGraduateSchool.Text = "";
			// 
			// label17
			// 
			this.label17.Location = new System.Drawing.Point(24, 328);
			this.label17.Name = "label17";
			this.label17.Size = new System.Drawing.Size(40, 32);
			this.label17.TabIndex = 114;
			this.label17.Text = "毕业学校";
			// 
			// label16
			// 
			this.label16.Location = new System.Drawing.Point(16, 128);
			this.label16.Name = "label16";
			this.label16.Size = new System.Drawing.Size(48, 23);
			this.label16.TabIndex = 113;
			this.label16.Text = "籍贯";
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(16, 96);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(48, 23);
			this.label15.TabIndex = 112;
			this.label15.Text = "身份证";
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(24, 64);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(40, 23);
			this.label14.TabIndex = 111;
			this.label14.Text = "姓名";
			// 
			// label13
			// 
			this.label13.Location = new System.Drawing.Point(24, 24);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(48, 23);
			this.label13.TabIndex = 110;
			this.label13.Text = "职工号";
			// 
			// textIDCard
			// 
			this.textIDCard.Location = new System.Drawing.Point(72, 96);
			this.textIDCard.Name = "textIDCard";
			this.textIDCard.Size = new System.Drawing.Size(104, 21);
			this.textIDCard.TabIndex = 109;
			this.textIDCard.Text = "";
			// 
			// textName
			// 
			this.textName.Location = new System.Drawing.Point(72, 64);
			this.textName.Name = "textName";
			this.textName.Size = new System.Drawing.Size(80, 21);
			this.textName.TabIndex = 108;
			this.textName.Text = "";
			// 
			// textNativePlace
			// 
			this.textNativePlace.Location = new System.Drawing.Point(72, 128);
			this.textNativePlace.Name = "textNativePlace";
			this.textNativePlace.Size = new System.Drawing.Size(104, 21);
			this.textNativePlace.TabIndex = 107;
			this.textNativePlace.Text = "";
			// 
			// textEmployeeID
			// 
			this.textEmployeeID.Location = new System.Drawing.Point(72, 24);
			this.textEmployeeID.Name = "textEmployeeID";
			this.textEmployeeID.Size = new System.Drawing.Size(80, 21);
			this.textEmployeeID.TabIndex = 106;
			this.textEmployeeID.Text = "";
			// 
			// numericUpDown1
			// 
			this.numericUpDown1.Location = new System.Drawing.Point(240, 168);
			this.numericUpDown1.Maximum = new System.Decimal(new int[] {
																		   200,
																		   0,
																		   0,
																		   0});
			this.numericUpDown1.Name = "numericUpDown1";
			this.numericUpDown1.Size = new System.Drawing.Size(72, 21);
			this.numericUpDown1.TabIndex = 105;
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(184, 176);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(40, 23);
			this.label12.TabIndex = 104;
			this.label12.Text = "年龄";
			// 
			// btnPicture
			// 
			this.btnPicture.Location = new System.Drawing.Point(304, 56);
			this.btnPicture.Name = "btnPicture";
			this.btnPicture.Size = new System.Drawing.Size(32, 72);
			this.btnPicture.TabIndex = 103;
			this.btnPicture.Text = "选择照片";
			this.btnPicture.Click += new System.EventHandler(this.btnPicture_Click);
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(80, -72);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(40, 22);
			this.label11.TabIndex = 102;
			this.label11.Text = "照片";
			// 
			// pictureBox1
			// 
			this.pictureBox1.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.pictureBox1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.pictureBox1.Location = new System.Drawing.Point(224, 40);
			this.pictureBox1.Name = "pictureBox1";
			this.pictureBox1.Size = new System.Drawing.Size(72, 104);
			this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;
			this.pictureBox1.TabIndex = 101;
			this.pictureBox1.TabStop = false;
			// 
			// comboSex
			// 
			this.comboSex.Items.AddRange(new object[] {
														  "男",
														  "女"});
			this.comboSex.Location = new System.Drawing.Point(240, 208);
			this.comboSex.Name = "comboSex";
			this.comboSex.Size = new System.Drawing.Size(72, 20);
			this.comboSex.TabIndex = 100;
			// 
			// comboDegree
			// 
			this.comboDegree.Location = new System.Drawing.Point(80, 288);
			this.comboDegree.Name = "comboDegree";
			this.comboDegree.Size = new System.Drawing.Size(72, 20);
			this.comboDegree.TabIndex = 99;
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(24, 288);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(40, 23);
			this.label10.TabIndex = 98;
			this.label10.Text = "学历";