historydatabase.cs

独立完成考勤管理软件加打卡系统（C＃） 是打卡加管理系统软件

#region 命名空间...
using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.IO;
#endregion
namespace WindowsApplication
{
	public class HistoryDatabase : System.Windows.Forms.Form
	{
		#region Control Collection 
		private System.Windows.Forms.Label label1;
		protected System.Windows.Forms.Button btnExit;
		protected System.Windows.Forms.DataGrid dataGrid;
		protected System.Windows.Forms.StatusBar Status;
		protected System.Windows.Forms.StatusBarPanel historyStauts;
		protected System.Windows.Forms.StatusBarPanel historyUser;
		protected System.Windows.Forms.StatusBarPanel historyTime;
		protected System.Windows.Forms.StatusBarPanel historyInformation;
		protected System.Windows.Forms.StatusBarPanel historyOther;
		private System.Windows.Forms.Timer CurrentTime;
		protected System.Windows.Forms.Button btnEnd;
		protected System.Windows.Forms.Button btnFirst;
		protected System.Windows.Forms.Button btnNext;
		protected System.Windows.Forms.Button btnLast;
		protected System.Windows.Forms.Button btnModify;
		protected System.Windows.Forms.Button btnSave;
		protected System.Windows.Forms.Button btnDelete;
		protected System.Windows.Forms.Button btnAdd;
		private System.Windows.Forms.ImageList image;
		private System.ComponentModel.IContainer components = null;
		#endregion
		#region Contruction Function 
		public HistoryDatabase()
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
		#endregion
		#region 设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(HistoryDatabase));
			this.label1 = new System.Windows.Forms.Label();
			this.btnExit = new System.Windows.Forms.Button();
			this.btnEnd = new System.Windows.Forms.Button();
			this.btnFirst = new System.Windows.Forms.Button();
			this.btnNext = new System.Windows.Forms.Button();
			this.btnLast = new System.Windows.Forms.Button();
			this.btnModify = new System.Windows.Forms.Button();
			this.btnSave = new System.Windows.Forms.Button();
			this.btnDelete = new System.Windows.Forms.Button();
			this.btnAdd = new System.Windows.Forms.Button();
			this.dataGrid = new System.Windows.Forms.DataGrid();
			this.Status = new System.Windows.Forms.StatusBar();
			this.historyStauts = new System.Windows.Forms.StatusBarPanel();
			this.historyUser = new System.Windows.Forms.StatusBarPanel();
			this.historyTime = new System.Windows.Forms.StatusBarPanel();
			this.historyInformation = new System.Windows.Forms.StatusBarPanel();
			this.historyOther = new System.Windows.Forms.StatusBarPanel();
			this.CurrentTime = new System.Windows.Forms.Timer(this.components);
			this.image = new System.Windows.Forms.ImageList(this.components);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.historyStauts)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.historyUser)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.historyTime)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.historyInformation)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.historyOther)).BeginInit();
			this.SuspendLayout();
			// 
			// label1
			// 
			this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.label1.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
			this.label1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.ForeColor = System.Drawing.SystemColors.ControlLightLight;
			this.label1.Location = new System.Drawing.Point(0, 0);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(834, 40);
			this.label1.TabIndex = 0;
			this.label1.Text = "历史数据";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// btnExit
			// 
			this.btnExit.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnExit.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnExit.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnExit.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExit.ImageIndex = 10;
			this.btnExit.ImageList = this.image;
			this.btnExit.Location = new System.Drawing.Point(728, 40);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(88, 32);
			this.btnExit.TabIndex = 48;
			this.btnExit.Text = "退出 (&E)";
			this.btnExit.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			this.btnExit.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnExit.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnEnd
			// 
			this.btnEnd.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnEnd.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnEnd.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnEnd.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnEnd.ImageIndex = 3;
			this.btnEnd.ImageList = this.image;
			this.btnEnd.Location = new System.Drawing.Point(304, 40);
			this.btnEnd.Name = "btnEnd";
			this.btnEnd.Size = new System.Drawing.Size(96, 32);
			this.btnEnd.TabIndex = 47;
			this.btnEnd.Text = "尾记录(&E)";
			this.btnEnd.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);
			this.btnEnd.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnEnd.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnFirst
			// 
			this.btnFirst.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnFirst.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnFirst.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnFirst.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnFirst.ImageIndex = 2;
			this.btnFirst.ImageList = this.image;
			this.btnFirst.Location = new System.Drawing.Point(208, 40);
			this.btnFirst.Name = "btnFirst";
			this.btnFirst.Size = new System.Drawing.Size(96, 32);
			this.btnFirst.TabIndex = 46;
			this.btnFirst.Text = "首记录(&F)";
			this.btnFirst.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnFirst.Click += new System.EventHandler(this.button8_Click);
			this.btnFirst.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnFirst.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnNext
			// 
			this.btnNext.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnNext.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnNext.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnNext.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnNext.ImageIndex = 1;
			this.btnNext.ImageList = this.image;
			this.btnNext.Location = new System.Drawing.Point(104, 40);
			this.btnNext.Name = "btnNext";
			this.btnNext.Size = new System.Drawing.Size(104, 32);
			this.btnNext.TabIndex = 45;
			this.btnNext.Text = "下一记录(&N)";
			this.btnNext.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnNext.Click += new System.EventHandler(this.button9_Click);
			this.btnNext.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnNext.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnLast
			// 
			this.btnLast.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnLast.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnLast.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnLast.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnLast.ImageIndex = 0;
			this.btnLast.ImageList = this.image;
			this.btnLast.Location = new System.Drawing.Point(0, 40);
			this.btnLast.Name = "btnLast";
			this.btnLast.Size = new System.Drawing.Size(104, 32);
			this.btnLast.TabIndex = 44;
			this.btnLast.Text = "上一记录(&S)";
			this.btnLast.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnLast.Click += new System.EventHandler(this.button10_Click);
			this.btnLast.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnLast.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnModify
			// 
			this.btnModify.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnModify.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnModify.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnModify.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnModify.ImageIndex = 4;
			this.btnModify.ImageList = this.image;
			this.btnModify.Location = new System.Drawing.Point(488, 40);
			this.btnModify.Name = "btnModify";
			this.btnModify.Size = new System.Drawing.Size(80, 32);
			this.btnModify.TabIndex = 41;
			this.btnModify.Text = "修改(&M)";
			this.btnModify.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
			this.btnModify.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnModify.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnSave
			// 
			this.btnSave.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnSave.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnSave.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnSave.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnSave.ImageIndex = 5;
			this.btnSave.ImageList = this.image;
			this.btnSave.Location = new System.Drawing.Point(648, 40);
			this.btnSave.Name = "btnSave";
			this.btnSave.Size = new System.Drawing.Size(80, 32);
			this.btnSave.TabIndex = 43;
			this.btnSave.Text = "保存(&S)";
			this.btnSave.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
			this.btnSave.MouseEnter += new System.EventHandler(this.btnModify_MouseEnter);
			this.btnSave.MouseLeave += new System.EventHandler(this.btnModify_MouseLeave);
			// 
			// btnDelete
			// 
			this.btnDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnDelete.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnDelete.ForeColor = System.Drawing.SystemColors.Highlight;
			this.btnDelete.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnDelete.ImageIndex = 6;
			this.btnDelete.ImageList = this.image;
			this.btnDelete.Location = new System.Drawing.Point(568, 40);