check.cs

c#写图书管理系统 界面美观 功能齐全 配有完整的数据库

			this.label6.Text = "职工号";
			// 
			// dataGrid1
			// 
			this.dataGrid1.AlternatingBackColor = System.Drawing.Color.White;
			this.dataGrid1.BackColor = System.Drawing.Color.White;
			this.dataGrid1.BackgroundColor = System.Drawing.Color.Gainsboro;
			this.dataGrid1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.dataGrid1.CaptionBackColor = System.Drawing.Color.Silver;
			this.dataGrid1.CaptionFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid1.CaptionForeColor = System.Drawing.Color.Black;
			this.dataGrid1.DataMember = "";
			this.dataGrid1.FlatMode = true;
			this.dataGrid1.Font = new System.Drawing.Font("Courier New", 9F);
			this.dataGrid1.ForeColor = System.Drawing.Color.DarkSlateGray;
			this.dataGrid1.GridLineColor = System.Drawing.Color.DarkGray;
			this.dataGrid1.HeaderBackColor = System.Drawing.Color.DarkGreen;
			this.dataGrid1.HeaderFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid1.HeaderForeColor = System.Drawing.Color.White;
			this.dataGrid1.LinkColor = System.Drawing.Color.DarkGreen;
			this.dataGrid1.Location = new System.Drawing.Point(40, 80);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.Gainsboro;
			this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.Black;
			this.dataGrid1.ReadOnly = true;
			this.dataGrid1.SelectionBackColor = System.Drawing.Color.DarkSeaGreen;
			this.dataGrid1.SelectionForeColor = System.Drawing.Color.Black;
			this.dataGrid1.Size = new System.Drawing.Size(400, 250);
			this.dataGrid1.TabIndex = 15;
			this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle1});
			// 
			// dataGridTableStyle1
			// 
			this.dataGridTableStyle1.DataGrid = this.dataGrid1;
			this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn1,
																												  this.dataGridTextBoxColumn2,
																												  this.dataGridTextBoxColumn3});
			this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle1.MappingName = "CheckInRecord";
			// 
			// 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 = "CheckType";
			this.dataGridTextBoxColumn2.Width = 75;
			// 
			// dataGridTextBoxColumn3
			// 
			this.dataGridTextBoxColumn3.Format = "";
			this.dataGridTextBoxColumn3.FormatInfo = null;
			this.dataGridTextBoxColumn3.HeaderText = "日期";
			this.dataGridTextBoxColumn3.MappingName = "Date";
			this.dataGridTextBoxColumn3.Width = 150;
			// 
			// tabPage2
			// 
			this.tabPage2.Controls.Add(this.groupBox3);
			this.tabPage2.ForeColor = System.Drawing.SystemColors.Desktop;
			this.tabPage2.Location = new System.Drawing.Point(4, 21);
			this.tabPage2.Name = "tabPage2";
			this.tabPage2.Size = new System.Drawing.Size(648, 431);
			this.tabPage2.TabIndex = 1;
			this.tabPage2.Text = "签离记录";
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.btnCheckOut);
			this.groupBox3.Controls.Add(this.textEmployeeID2);
			this.groupBox3.Controls.Add(this.label1);
			this.groupBox3.Controls.Add(this.dataGrid2);
			this.groupBox3.Location = new System.Drawing.Point(8, 8);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(600, 376);
			this.groupBox3.TabIndex = 105;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "下班离签";
			// 
			// btnCheckOut
			// 
			this.btnCheckOut.Location = new System.Drawing.Point(192, 32);
			this.btnCheckOut.Name = "btnCheckOut";
			this.btnCheckOut.TabIndex = 14;
			this.btnCheckOut.Text = "离签";
			this.btnCheckOut.Click += new System.EventHandler(this.btnCheckOut_Click);
			// 
			// 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 = 9;
			this.textEmployeeID2.Text = "";
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(16, 32);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(48, 23);
			this.label1.TabIndex = 10;
			this.label1.Text = "职工号";
			// 
			// dataGrid2
			// 
			this.dataGrid2.AlternatingBackColor = System.Drawing.Color.White;
			this.dataGrid2.BackColor = System.Drawing.Color.White;
			this.dataGrid2.BackgroundColor = System.Drawing.Color.Gainsboro;
			this.dataGrid2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.dataGrid2.CaptionBackColor = System.Drawing.Color.Silver;
			this.dataGrid2.CaptionFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid2.CaptionForeColor = System.Drawing.Color.Black;
			this.dataGrid2.DataMember = "";
			this.dataGrid2.FlatMode = true;
			this.dataGrid2.Font = new System.Drawing.Font("Courier New", 9F);
			this.dataGrid2.ForeColor = System.Drawing.Color.DarkSlateGray;
			this.dataGrid2.GridLineColor = System.Drawing.Color.DarkGray;
			this.dataGrid2.HeaderBackColor = System.Drawing.Color.DarkGreen;
			this.dataGrid2.HeaderFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid2.HeaderForeColor = System.Drawing.Color.White;
			this.dataGrid2.LinkColor = System.Drawing.Color.DarkGreen;
			this.dataGrid2.Location = new System.Drawing.Point(40, 80);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.ParentRowsBackColor = System.Drawing.Color.Gainsboro;
			this.dataGrid2.ParentRowsForeColor = System.Drawing.Color.Black;
			this.dataGrid2.ReadOnly = true;
			this.dataGrid2.SelectionBackColor = System.Drawing.Color.DarkSeaGreen;
			this.dataGrid2.SelectionForeColor = System.Drawing.Color.Black;
			this.dataGrid2.Size = new System.Drawing.Size(400, 250);
			this.dataGrid2.TabIndex = 15;
			this.dataGrid2.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle2});
			// 
			// dataGridTableStyle2
			// 
			this.dataGridTableStyle2.DataGrid = this.dataGrid2;
			this.dataGridTableStyle2.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn4,
																												  this.dataGridTextBoxColumn5,
																												  this.dataGridTextBoxColumn6});
			this.dataGridTableStyle2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle2.MappingName = "CheckOutRecord";
			// 
			// dataGridTextBoxColumn4
			// 
			this.dataGridTextBoxColumn4.Format = "";
			this.dataGridTextBoxColumn4.FormatInfo = null;
			this.dataGridTextBoxColumn4.HeaderText = "职工号";
			this.dataGridTextBoxColumn4.MappingName = "EmployeeID";
			this.dataGridTextBoxColumn4.Width = 75;
			// 
			// dataGridTextBoxColumn5
			// 
			this.dataGridTextBoxColumn5.Format = "";
			this.dataGridTextBoxColumn5.FormatInfo = null;
			this.dataGridTextBoxColumn5.HeaderText = "类型";
			this.dataGridTextBoxColumn5.MappingName = "CheckType";
			this.dataGridTextBoxColumn5.Width = 75;
			// 
			// dataGridTextBoxColumn6
			// 
			this.dataGridTextBoxColumn6.Format = "";
			this.dataGridTextBoxColumn6.FormatInfo = null;
			this.dataGridTextBoxColumn6.HeaderText = "日期";
			this.dataGridTextBoxColumn6.MappingName = "Date";
			this.dataGridTextBoxColumn6.Width = 150;
			// 
			// tabControl1
			// 
			this.tabControl1.Controls.Add(this.tabPage1);
			this.tabControl1.Controls.Add(this.tabPage3);
			this.tabControl1.Controls.Add(this.tabPage2);
			this.tabControl1.Controls.Add(this.tabPage4);
			this.tabControl1.ItemSize = new System.Drawing.Size(60, 17);
			this.tabControl1.Location = new System.Drawing.Point(8, 16);
			this.tabControl1.Name = "tabControl1";
			this.tabControl1.SelectedIndex = 0;
			this.tabControl1.Size = new System.Drawing.Size(656, 456);
			this.tabControl1.TabIndex = 0;
			this.tabControl1.SelectedIndexChanged += new System.EventHandler(this.tabControl1_SelectedIndexChanged);
			// 
			// tabPage3
			// 
			this.tabPage3.Controls.Add(this.dataGrid3);
			this.tabPage3.Controls.Add(this.groupBox2);
			this.tabPage3.ForeColor = System.Drawing.SystemColors.Desktop;
			this.tabPage3.Location = new System.Drawing.Point(4, 21);
			this.tabPage3.Name = "tabPage3";
			this.tabPage3.Size = new System.Drawing.Size(648, 431);
			this.tabPage3.TabIndex = 2;
			this.tabPage3.Text = "签到查询";
			// 
			// dataGrid3
			// 
			this.dataGrid3.AlternatingBackColor = System.Drawing.Color.White;
			this.dataGrid3.BackColor = System.Drawing.Color.White;
			this.dataGrid3.BackgroundColor = System.Drawing.Color.Gainsboro;
			this.dataGrid3.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.dataGrid3.CaptionBackColor = System.Drawing.Color.Silver;
			this.dataGrid3.CaptionFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid3.CaptionForeColor = System.Drawing.Color.Black;
			this.dataGrid3.DataMember = "";
			this.dataGrid3.FlatMode = true;
			this.dataGrid3.Font = new System.Drawing.Font("Courier New", 9F);
			this.dataGrid3.ForeColor = System.Drawing.Color.DarkSlateGray;
			this.dataGrid3.GridLineColor = System.Drawing.Color.DarkGray;
			this.dataGrid3.HeaderBackColor = System.Drawing.Color.DarkGreen;
			this.dataGrid3.HeaderFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
			this.dataGrid3.HeaderForeColor = System.Drawing.Color.White;
			this.dataGrid3.LinkColor = System.Drawing.Color.DarkGreen;
			this.dataGrid3.Location = new System.Drawing.Point(60, 140);
			this.dataGrid3.Name = "dataGrid3";
			this.dataGrid3.ParentRowsBackColor = System.Drawing.Color.Gainsboro;
			this.dataGrid3.ParentRowsForeColor = System.Drawing.Color.Black;
			this.dataGrid3.ReadOnly = true;
			this.dataGrid3.SelectionBackColor = System.Drawing.Color.DarkSeaGreen;
			this.dataGrid3.SelectionForeColor = System.Drawing.Color.Black;
			this.dataGrid3.Size = new System.Drawing.Size(500, 260);
			this.dataGrid3.TabIndex = 37;
			this.dataGrid3.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle3});
			// 
			// dataGridTableStyle3
			// 
			this.dataGridTableStyle3.DataGrid = this.dataGrid3;
			this.dataGridTableStyle3.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn7,
																												  this.dataGridTextBoxColumn8,
																												  this.dataGridTextBoxColumn9,
																												  this.dataGridTextBoxColumn10,
																												  this.dataGridTextBoxColumn11});
			this.dataGridTableStyle3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle3.MappingName = "View_CheckInRecord";
			// 
			// dataGridTextBoxColumn7
			// 
			this.dataGridTextBoxColumn7.Format = "";
			this.dataGridTextBoxColumn7.FormatInfo = null;
			this.dataGridTextBoxColumn7.HeaderText = "职工号";
			this.dataGridTextBoxColumn7.MappingName = "EmployeeID";
			this.dataGridTextBoxColumn7.Width = 75;
			// 
			// dataGridTextBoxColumn8
			// 
			this.dataGridTextBoxColumn8.Format = "";
			this.dataGridTextBoxColumn8.FormatInfo = null;
			this.dataGridTextBoxColumn8.HeaderText = "姓名";
			this.dataGridTextBoxColumn8.MappingName = "EmployeeName";
			this.dataGridTextBoxColumn8.Width = 75;
			// 
			// dataGridTextBoxColumn9
			// 
			this.dataGridTextBoxColumn9.Format = "";
			this.dataGridTextBoxColumn9.FormatInfo = null;
			this.dataGridTextBoxColumn9.HeaderText = "部门";
			this.dataGridTextBoxColumn9.MappingName = "Department";
			this.dataGridTextBoxColumn9.Width = 75;
			// 
			// dataGridTextBoxColumn10
			// 
			this.dataGridTextBoxColumn10.Format = "";
			this.dataGridTextBoxColumn10.FormatInfo = null;
			this.dataGridTextBoxColumn10.HeaderText = "类型";
			this.dataGridTextBoxColumn10.MappingName = "CheckType";
			this.dataGridTextBoxColumn10.Width = 75;
			// 
			// dataGridTextBoxColumn11
			// 
			this.dataGridTextBoxColumn11.Format = "";
			this.dataGridTextBoxColumn11.FormatInfo = null;
			this.dataGridTextBoxColumn11.HeaderText = "日期";
			this.dataGridTextBoxColumn11.MappingName = "Date";
			this.dataGridTextBoxColumn11.Width = 150;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.comboInDepartment);
			this.groupBox2.Controls.Add(this.label8);
			this.groupBox2.Controls.Add(this.btnCheckInExport);
			this.groupBox2.Controls.Add(this.btnCheckInSearch);
			this.groupBox2.Controls.Add(this.btnCheckInCancel);
			this.groupBox2.Controls.Add(this.label10);
			this.groupBox2.Controls.Add(this.label9);
			this.groupBox2.Controls.Add(this.label12);
			this.groupBox2.Controls.Add(this.dateTimePicker4);
			this.groupBox2.Controls.Add(this.dateTimePicker3);
			this.groupBox2.Controls.Add(this.comboCheckInType);
			this.groupBox2.Controls.Add(this.label11);
			this.groupBox2.Controls.Add(this.checkBox1);
			this.groupBox2.Controls.Add(this.textEmployeeID3);
			this.groupBox2.Location = new System.Drawing.Point(24, 16);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(592, 112);
			this.groupBox2.TabIndex = 36;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "签到查询";
			// 
			// comboInDepartment
			// 
			this.comboInDepartment.ItemHeight = 12;
			this.comboInDepartment.Location = new System.Drawing.Point(312, 24);
			this.comboInDepartment.Name = "comboInDepartment";
			this.comboInDepartment.Size = new System.Drawing.Size(72, 20);
			this.comboInDepartment.TabIndex = 109;
			// 
			// label8
			// 
			this.label8.Location = new System.Drawing.Point(272, 24);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(32, 23);
			this.label8.TabIndex = 108;
			this.label8.Text = "部门";
			// 
			// btnCheckInExport
			// 
			this.btnCheckInExport.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnCheckInExport.Image = ((System.Drawing.Image)(resources.GetObject("btnCheckInExport.Image")));
			this.btnCheckInExport.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCheckInExport.Location = new System.Drawing.Point(512, 40);
			this.btnCheckInExport.Name = "btnCheckInExport";
			this.btnCheckInExport.Size = new System.Drawing.Size(56, 24);
			this.btnCheckInExport.TabIndex = 105;
			this.btnCheckInExport.Text = "导出";
			this.btnCheckInExport.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnCheckInExport.Click += new System.EventHandler(this.btnCheckInExport_Click);
			// 
			// btnCheckInSearch
			// 
			this.btnCheckInSearch.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnCheckInSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnCheckInSearch.Image")));
			this.btnCheckInSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCheckInSearch.Location = new System.Drawing.Point(432, 64);
			this.btnCheckInSearch.Name = "btnCheckInSearch";
			this.btnCheckInSearch.Size = new System.Drawing.Size(56, 24);
			this.btnCheckInSearch.TabIndex = 97;
			this.btnCheckInSearch.Text = "查找";
			this.btnCheckInSearch.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnCheckInSearch.Click += new System.EventHandler(this.btnCheckInSearch_Click);
			// 
			// btnCheckInCancel
			// 
			this.btnCheckInCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnCheckInCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCheckInCancel.Image")));
			this.btnCheckInCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCheckInCancel.Location = new System.Drawing.Point(432, 24);
			this.btnCheckInCancel.Name = "btnCheckInCancel";
			this.btnCheckInCancel.Size = new System.Drawing.Size(56, 24);
			this.btnCheckInCancel.TabIndex = 96;
			this.btnCheckInCancel.Text = "取消";
			this.btnCheckInCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnCheckInCancel.Click += new System.EventHandler(this.btnCheckInCancel_Click);
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(8, 32);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(48, 23);