systembasicdesignframe.cs

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

#region 命名空间...
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.IO;
#endregion
namespace WindowsApplication
{
	public class SystemBasicDesignFrame : System.Windows.Forms.Form
	{
		#region 控件集合...
        public System.Windows.Forms.TabControl SystemBasicTabControl;
		private System.Windows.Forms.TabPage basicDesign;
		private System.Windows.Forms.TabPage popedomDesign;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.ImageList image;
		private System.Windows.Forms.GroupBox groupBox5;
		private System.Windows.Forms.GroupBox groupBox6;
		private System.Windows.Forms.TextBox textBrushID;
		private System.Windows.Forms.ComboBox userIDCombo;
		private System.Windows.Forms.DataGrid dataGrid;
		private System.Windows.Forms.CheckedListBox popedomListBox;
		private System.Windows.Forms.GroupBox groupBox7;
		private System.Windows.Forms.RadioButton showDaoHangTiao;
		private System.Windows.Forms.CheckBox showToolBar;
		private System.Windows.Forms.CheckBox showStatusBar;
		private System.Windows.Forms.GroupBox groupBox8;
		private System.Windows.Forms.CheckBox ChkRemember;
		private System.Windows.Forms.GroupBox groupBox9;
		private System.Windows.Forms.CheckBox SystemCheckExit;
		private System.Windows.Forms.CheckBox SystemKuXianClose;
		private System.Windows.Forms.GroupBox groupBox10;
		private System.Windows.Forms.RadioButton SystemBackRadio;
		private System.Windows.Forms.RadioButton userBackRadio;
		private System.Windows.Forms.TabPage dataDesign;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox processText;
		private System.Windows.Forms.TextBox dataText;
		private System.Windows.Forms.TextBox dataMonthText;
		private System.Windows.Forms.TextBox backText;
		private System.Windows.Forms.TextBox RestoreText;
		private System.Windows.Forms.Button btnModify;
		private System.Windows.Forms.Button btnOk;
		private System.Windows.Forms.Button btnCancel;
		private System.Windows.Forms.OpenFileDialog openFileDialog;
		private System.Windows.Forms.FolderBrowserDialog folderBrowserDialog;
		private System.ComponentModel.IContainer components;
		#endregion
		#region 构造函数...
		public SystemBasicDesignFrame()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

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

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
		#endregion
		#region 数据库变量...
		private ConnectionData conn=new ConnectionData();
		private DataTable tempTable=new DataTable();
		#endregion
		#region 变量...
		private string searchuseridsql="select distinct 用户号 from System_UserTable";
		private string searchQuanXianSql="select distinct 权限名称 from System_PopedomTable";
		private string searchuserNameSql="select distinct 用户类型 from System_UserTable where 用户名称<>'adminstrator'";
		private string searchUserSql="select 用户号,用户名称 from System_UserTable ";
		private  bool  blCheck=true;
		#endregion
		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(SystemBasicDesignFrame));
			this.SystemBasicTabControl = new System.Windows.Forms.TabControl();
			this.basicDesign = new System.Windows.Forms.TabPage();
			this.groupBox5 = new System.Windows.Forms.GroupBox();
			this.groupBox7 = new System.Windows.Forms.GroupBox();
			this.showStatusBar = new System.Windows.Forms.CheckBox();
			this.showToolBar = new System.Windows.Forms.CheckBox();
			this.showDaoHangTiao = new System.Windows.Forms.RadioButton();
			this.groupBox6 = new System.Windows.Forms.GroupBox();
			this.groupBox10 = new System.Windows.Forms.GroupBox();
			this.SystemBackRadio = new System.Windows.Forms.RadioButton();
			this.userBackRadio = new System.Windows.Forms.RadioButton();
			this.groupBox8 = new System.Windows.Forms.GroupBox();
			this.ChkRemember = new System.Windows.Forms.CheckBox();
			this.groupBox9 = new System.Windows.Forms.GroupBox();
			this.SystemCheckExit = new System.Windows.Forms.CheckBox();
			this.SystemKuXianClose = new System.Windows.Forms.CheckBox();
			this.popedomDesign = new System.Windows.Forms.TabPage();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.dataGrid = new System.Windows.Forms.DataGrid();
			this.label2 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.popedomListBox = new System.Windows.Forms.CheckedListBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.textBrushID = new System.Windows.Forms.TextBox();
			this.userIDCombo = new System.Windows.Forms.ComboBox();
			this.dataDesign = new System.Windows.Forms.TabPage();
			this.btnCancel = new System.Windows.Forms.Button();
			this.btnModify = new System.Windows.Forms.Button();
			this.RestoreText = new System.Windows.Forms.TextBox();
			this.label7 = new System.Windows.Forms.Label();
			this.backText = new System.Windows.Forms.TextBox();
			this.label6 = new System.Windows.Forms.Label();
			this.dataMonthText = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.dataText = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.processText = new System.Windows.Forms.TextBox();
			this.label3 = new System.Windows.Forms.Label();
			this.btnOk = new System.Windows.Forms.Button();
			this.image = new System.Windows.Forms.ImageList(this.components);
			this.openFileDialog = new System.Windows.Forms.OpenFileDialog();
			this.folderBrowserDialog = new System.Windows.Forms.FolderBrowserDialog();
			this.SystemBasicTabControl.SuspendLayout();
			this.basicDesign.SuspendLayout();
			this.groupBox5.SuspendLayout();
			this.groupBox7.SuspendLayout();
			this.groupBox6.SuspendLayout();
			this.groupBox10.SuspendLayout();
			this.groupBox8.SuspendLayout();
			this.groupBox9.SuspendLayout();
			this.popedomDesign.SuspendLayout();
			this.groupBox1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit();
			this.groupBox2.SuspendLayout();
			this.dataDesign.SuspendLayout();
			this.SuspendLayout();
			// 
			// SystemBasicTabControl
			// 
			this.SystemBasicTabControl.Appearance = System.Windows.Forms.TabAppearance.FlatButtons;
			this.SystemBasicTabControl.Controls.Add(this.basicDesign);
			this.SystemBasicTabControl.Controls.Add(this.popedomDesign);
			this.SystemBasicTabControl.Controls.Add(this.dataDesign);
			this.SystemBasicTabControl.Cursor = System.Windows.Forms.Cursors.Hand;
			this.SystemBasicTabControl.HotTrack = true;
			this.SystemBasicTabControl.ImageList = this.image;
			this.SystemBasicTabControl.Location = new System.Drawing.Point(0, 0);
			this.SystemBasicTabControl.Name = "SystemBasicTabControl";
			this.SystemBasicTabControl.SelectedIndex = 0;
			this.SystemBasicTabControl.Size = new System.Drawing.Size(456, 432);
			this.SystemBasicTabControl.TabIndex = 0;
			// 
			// basicDesign
			// 
			this.basicDesign.BackColor = System.Drawing.SystemColors.ControlLightLight;
			this.basicDesign.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.basicDesign.Controls.Add(this.groupBox5);
			this.basicDesign.ImageIndex = 1;
			this.basicDesign.Location = new System.Drawing.Point(4, 26);
			this.basicDesign.Name = "basicDesign";
			this.basicDesign.Size = new System.Drawing.Size(448, 402);
			this.basicDesign.TabIndex = 0;
			this.basicDesign.Text = "基础设置";
			// 
			// groupBox5
			// 
			this.groupBox5.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.groupBox5.Controls.Add(this.groupBox7);
			this.groupBox5.Controls.Add(this.groupBox6);
			this.groupBox5.Controls.Add(this.groupBox8);
			this.groupBox5.Controls.Add(this.groupBox9);
			this.groupBox5.Location = new System.Drawing.Point(0, 0);
			this.groupBox5.Name = "groupBox5";
			this.groupBox5.Size = new System.Drawing.Size(400, 312);
			this.groupBox5.TabIndex = 0;
			this.groupBox5.TabStop = false;
			// 
			// groupBox7
			// 
			this.groupBox7.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.groupBox7.Controls.Add(this.showStatusBar);
			this.groupBox7.Controls.Add(this.showToolBar);
			this.groupBox7.Controls.Add(this.showDaoHangTiao);
			this.groupBox7.Location = new System.Drawing.Point(8, 8);
			this.groupBox7.Name = "groupBox7";
			this.groupBox7.Size = new System.Drawing.Size(168, 144);
			this.groupBox7.TabIndex = 2;
			this.groupBox7.TabStop = false;
			this.groupBox7.Text = "界面设置";
			// 
			// showStatusBar
			// 
			this.showStatusBar.Checked = true;
			this.showStatusBar.CheckState = System.Windows.Forms.CheckState.Checked;
			this.showStatusBar.Location = new System.Drawing.Point(40, 104);
			this.showStatusBar.Name = "showStatusBar";
			this.showStatusBar.TabIndex = 2;
			this.showStatusBar.Text = "显示状态栏";
			// 
			// showToolBar
			// 
			this.showToolBar.Checked = true;
			this.showToolBar.CheckState = System.Windows.Forms.CheckState.Checked;
			this.showToolBar.Location = new System.Drawing.Point(40, 64);
			this.showToolBar.Name = "showToolBar";
			this.showToolBar.TabIndex = 1;
			this.showToolBar.Text = "显示工具栏";
			// 
			// showDaoHangTiao
			// 
			this.showDaoHangTiao.Checked = true;
			this.showDaoHangTiao.Location = new System.Drawing.Point(40, 24);
			this.showDaoHangTiao.Name = "showDaoHangTiao";
			this.showDaoHangTiao.TabIndex = 0;
			this.showDaoHangTiao.TabStop = true;
			this.showDaoHangTiao.Text = "显示导航条";
			// 
			// groupBox6
			// 
			this.groupBox6.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.groupBox6.Controls.Add(this.groupBox10);
			this.groupBox6.Location = new System.Drawing.Point(0, 152);
			this.groupBox6.Name = "groupBox6";
			this.groupBox6.Size = new System.Drawing.Size(400, 240);
			this.groupBox6.TabIndex = 1;
			this.groupBox6.TabStop = false;
			// 
			// groupBox10
			// 
			this.groupBox10.Controls.Add(this.SystemBackRadio);
			this.groupBox10.Controls.Add(this.userBackRadio);
			this.groupBox10.Location = new System.Drawing.Point(8, 17);
			this.groupBox10.Name = "groupBox10";
			this.groupBox10.Size = new System.Drawing.Size(376, 119);
			this.groupBox10.TabIndex = 0;
			this.groupBox10.TabStop = false;
			this.groupBox10.Text = "数据备份";
			// 
			// SystemBackRadio
			// 
			this.SystemBackRadio.Location = new System.Drawing.Point(32, 24);
			this.SystemBackRadio.Name = "SystemBackRadio";
			this.SystemBackRadio.Size = new System.Drawing.Size(136, 24);
			this.SystemBackRadio.TabIndex = 0;
			this.SystemBackRadio.Text = "程序退出需要备份";
			// 
			// userBackRadio
			// 
			this.userBackRadio.Checked = true;
			this.userBackRadio.Location = new System.Drawing.Point(32, 64);
			this.userBackRadio.Name = "userBackRadio";
			this.userBackRadio.Size = new System.Drawing.Size(152, 24);
			this.userBackRadio.TabIndex = 0;
			this.userBackRadio.TabStop = true;
			this.userBackRadio.Text = "用户备份(由用户操作)";
			// 
			// groupBox8
			// 
			this.groupBox8.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.groupBox8.Controls.Add(this.ChkRemember);
			this.groupBox8.Location = new System.Drawing.Point(184, 8);
			this.groupBox8.Name = "groupBox8";
			this.groupBox8.Size = new System.Drawing.Size(200, 64);
			this.groupBox8.TabIndex = 3;
			this.groupBox8.TabStop = false;
			this.groupBox8.Text = "程序启动";
			// 
			// ChkRemember
			// 
			this.ChkRemember.Checked = true;
			this.ChkRemember.CheckState = System.Windows.Forms.CheckState.Checked;
			this.ChkRemember.Location = new System.Drawing.Point(40, 24);
			this.ChkRemember.Name = "ChkRemember";
			this.ChkRemember.Size = new System.Drawing.Size(128, 24);
			this.ChkRemember.TabIndex = 0;
			this.ChkRemember.Text = "自动记住用户名";
			// 
			// groupBox9
			// 
			this.groupBox9.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.groupBox9.Controls.Add(this.SystemCheckExit);
			this.groupBox9.Controls.Add(this.SystemKuXianClose);