connectionshowaccess.cs

来自「独立完成考勤管理软件加打卡系统（C＃） 是打卡加管理系统软件 」· CS 代码 · 共 513 行 · 第 1/2 页

#region　命名空间..
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data;
#endregion
namespace WindowsApplication.ConnectionDB
{
	public class ConnectionShowAccess : System.Windows.Forms.Form
	{
		#region 控件集合...
		private System.Windows.Forms.DataGrid dataGrid;
		private System.Windows.Forms.ToolBar tool;
		private System.Windows.Forms.StatusBar status;
		private System.Windows.Forms.ToolBarButton toolFirstasdfasd;
		private System.Windows.Forms.ToolBarButton toolEndasdfasd;
		private System.Windows.Forms.ToolBarButton toolBarButton6;
		private System.Windows.Forms.ToolBarButton toolBarButton1;
		private System.Windows.Forms.ToolBarButton toolBarButton2;
		private System.Windows.Forms.Label TitleLabel;
		private System.Windows.Forms.ImageList imageList1;
		private System.Windows.Forms.StatusBarPanel stStauts;
		private System.Windows.Forms.StatusBarPanel stOperator;
		private System.Windows.Forms.StatusBarPanel stDate;
		private System.Windows.Forms.StatusBarPanel stTime;
		private System.Windows.Forms.StatusBarPanel stState;
		private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
		private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
		private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter;
		private System.Data.OleDb.OleDbConnection oleDbConnection;
		private WindowsApplication.ConnectionDB.ConnectionAccessSet connectionAccessSet;
		private System.Windows.Forms.CurrencyManager cmOrders=null;
		private System.Data.DataSet ds=new System.Data.DataSet();
		private System.Windows.Forms.ToolBarButton tLast;
		private System.Windows.Forms.ToolBarButton tFirst;
		private System.Windows.Forms.ToolBarButton tNext;
		private System.Windows.Forms.ToolBarButton tEnd;
		private System.Windows.Forms.ToolBarButton tSearch;
		private System.Windows.Forms.ToolBarButton tDelete;
		private System.Windows.Forms.ToolBarButton toolBarButton3;
		private System.Windows.Forms.ToolBarButton tExit;
		private System.Windows.Forms.Timer timer1;
		private System.ComponentModel.IContainer components;
        #endregion
		#region 构造函数..
		public ConnectionShowAccess()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
        #endregion
		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ConnectionShowAccess));
			this.tool = new System.Windows.Forms.ToolBar();
			this.tLast = new System.Windows.Forms.ToolBarButton();
			this.toolFirstasdfasd = new System.Windows.Forms.ToolBarButton();
			this.tFirst = new System.Windows.Forms.ToolBarButton();
			this.toolEndasdfasd = new System.Windows.Forms.ToolBarButton();
			this.tNext = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton6 = new System.Windows.Forms.ToolBarButton();
			this.tEnd = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton1 = new System.Windows.Forms.ToolBarButton();
			this.tSearch = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton2 = new System.Windows.Forms.ToolBarButton();
			this.tDelete = new System.Windows.Forms.ToolBarButton();
			this.toolBarButton3 = new System.Windows.Forms.ToolBarButton();
			this.tExit = new System.Windows.Forms.ToolBarButton();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.status = new System.Windows.Forms.StatusBar();
			this.stStauts = new System.Windows.Forms.StatusBarPanel();
			this.stOperator = new System.Windows.Forms.StatusBarPanel();
			this.stDate = new System.Windows.Forms.StatusBarPanel();
			this.stTime = new System.Windows.Forms.StatusBarPanel();
			this.stState = new System.Windows.Forms.StatusBarPanel();
			this.TitleLabel = new System.Windows.Forms.Label();
			this.dataGrid = new System.Windows.Forms.DataGrid();
			this.oleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter();
			this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbConnection = new System.Data.OleDb.OleDbConnection();
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
			this.connectionAccessSet = new WindowsApplication.ConnectionDB.ConnectionAccessSet();
			this.timer1 = new System.Windows.Forms.Timer(this.components);
			((System.ComponentModel.ISupportInitialize)(this.stStauts)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.stOperator)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.stDate)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.stTime)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.stState)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.connectionAccessSet)).BeginInit();
			this.SuspendLayout();
			// 
			// tool
			// 
			this.tool.Appearance = System.Windows.Forms.ToolBarAppearance.Flat;
			this.tool.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																					this.tLast,
																					this.toolFirstasdfasd,
																					this.tFirst,
																					this.toolEndasdfasd,
																					this.tNext,
																					this.toolBarButton6,
																					this.tEnd,
																					this.toolBarButton1,
																					this.tSearch,
																					this.toolBarButton2,
																					this.tDelete,
																					this.toolBarButton3,
																					this.tExit});
			this.tool.ButtonSize = new System.Drawing.Size(90, 40);
			this.tool.DropDownArrows = true;
			this.tool.ImageList = this.imageList1;
			this.tool.Location = new System.Drawing.Point(0, 0);
			this.tool.Name = "tool";
			this.tool.ShowToolTips = true;
			this.tool.Size = new System.Drawing.Size(806, 41);
			this.tool.TabIndex = 0;
			this.tool.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.tool_ButtonClick);
			// 
			// tLast
			// 
			this.tLast.ImageIndex = 0;
			this.tLast.Text = "上一条记录";
			// 
			// toolFirstasdfasd
			// 
			this.toolFirstasdfasd.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tFirst
			// 
			this.tFirst.ImageIndex = 1;
			this.tFirst.Text = "首记录";
			// 
			// toolEndasdfasd
			// 
			this.toolEndasdfasd.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tNext
			// 
			this.tNext.ImageIndex = 2;
			this.tNext.Text = "下一条记录";
			// 
			// toolBarButton6
			// 
			this.toolBarButton6.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tEnd
			// 
			this.tEnd.ImageIndex = 3;
			this.tEnd.Text = "尾记录";
			// 
			// toolBarButton1
			// 
			this.toolBarButton1.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tSearch
			// 
			this.tSearch.ImageIndex = 5;
			this.tSearch.Style = System.Windows.Forms.ToolBarButtonStyle.DropDownButton;
			this.tSearch.Text = "查询";
			// 
			// toolBarButton2
			// 
			this.toolBarButton2.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tDelete
			// 
			this.tDelete.ImageIndex = 7;
			this.tDelete.Text = "删除历史";
			// 
			// toolBarButton3
			// 
			this.toolBarButton3.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tExit
			// 
			this.tExit.ImageIndex = 6;
			this.tExit.Text = "退出";
			// 
			// imageList1
			// 
			this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
			this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
			this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// status
			// 
			this.status.Location = new System.Drawing.Point(0, 379);
			this.status.Name = "status";
			this.status.Panels.AddRange(new System.Windows.Forms.StatusBarPanel[] {
																					  this.stStauts,
																					  this.stOperator,
																					  this.stDate,
																					  this.stTime,
																					  this.stState});
			this.status.ShowPanels = true;
			this.status.Size = new System.Drawing.Size(806, 40);
			this.status.TabIndex = 1;
			this.status.Text = "statusBar1";
			// 
			// stStauts
			// 
			this.stStauts.Icon = ((System.Drawing.Icon)(resources.GetObject("stStauts.Icon")));
			this.stStauts.Text = "所有记录:";
			this.stStauts.Width = 130;
			// 
			// stOperator
			// 
			this.stOperator.Icon = ((System.Drawing.Icon)(resources.GetObject("stOperator.Icon")));
			this.stOperator.Text = "当前用户:";
			this.stOperator.Width = 180;
			// 
			// stDate
			// 
			this.stDate.Icon = ((System.Drawing.Icon)(resources.GetObject("stDate.Icon")));
			this.stDate.Text = "当前日期:";
			this.stDate.Width = 180;
			// 
			// stTime
			// 
			this.stTime.Icon = ((System.Drawing.Icon)(resources.GetObject("stTime.Icon")));
			this.stTime.Text = "当前时间:";
			this.stTime.Width = 180;
			// 
			// stState
			//