systembasicdesignframe.cs

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

			this.openFileDialog.ShowReadOnly = true;
			// 
			// folderBrowserDialog
			// 
			this.folderBrowserDialog.Description = "更改目录...";
			this.folderBrowserDialog.SelectedPath = "..\\WindowsApplication";
			this.folderBrowserDialog.ShowNewFolderButton = false;
			// 
			// SystemBasicDesignFrame
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
			this.ClientSize = new System.Drawing.Size(400, 327);
			this.Controls.Add(this.SystemBasicTabControl);
			this.Cursor = System.Windows.Forms.Cursors.Hand;
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "SystemBasicDesignFrame";
			this.ShowInTaskbar = false;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "SystemBasicDesignFrame";
			this.Load += new System.EventHandler(this.SystemBasicDesignFrame_Load);
			this.SystemBasicTabControl.ResumeLayout(false);
			this.basicDesign.ResumeLayout(false);
			this.groupBox5.ResumeLayout(false);
			this.groupBox7.ResumeLayout(false);
			this.groupBox6.ResumeLayout(false);
			this.groupBox10.ResumeLayout(false);
			this.groupBox8.ResumeLayout(false);
			this.groupBox9.ResumeLayout(false);
			this.popedomDesign.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit();
			this.groupBox2.ResumeLayout(false);
			this.dataDesign.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion
		#region 初始化控件...
		private void SystemBasicDesignFrame_Load(object sender, System.EventArgs e)
		{
			try
			{
				#region 获取焦点...
				this.SystemBasicTabControl.Focus();
				#endregion
				#region 初始化用户号控件...
				tempTable=ExcuteSql(searchuseridsql,"System_UserTable");
				for(int i=0;i<tempTable.Rows.Count;i++)
				{
					userIDCombo.Items.Add(tempTable.Rows[i][0].ToString());
				}
				#endregion
				#region 初始化用户列表框
				DataTable userTable=new DataTable();
				userTable=ExcuteSql(searchuserNameSql,"System_UserTable");
				this.dataGrid.DataSource=userTable;
				#endregion
				#region 初始化 popedomListBox
				try
				{
					DataTable QuanXianTable=new DataTable();
					QuanXianTable=ExcuteSql(searchQuanXianSql,"System_PopedomTable");
					for(int o=0;o<QuanXianTable.Rows.Count;o++)
					{
						this.popedomListBox.Items.Add(QuanXianTable.Rows[o][0].ToString().Trim());
					}
				}
				catch(Exception ele)
				{
					MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
				}
				#endregion
				#region  初始化界面...
				this.processText.Text=System.Environment.CurrentDirectory.ToString()+"\\windowsApplication.exe";
				dataText.Text=System.Environment.CurrentDirectory.ToString()+"\\WindowsApplication\\WindowsApplication\\Data";
				dataMonthText.Text=System.Environment.CurrentDirectory.ToString()+"\\WindowsApplication\\导出报表";
				this.RestoreText.Text=System.Environment.CurrentDirectory.ToString()+"\\WindowsApplication\\Restore";
				this.backText.Text=System.Environment.CurrentDirectory.ToString()+"\\WindowsApplication\\backup";
				#endregion
				#region 窗体运行时...
				string userName=this.dataGrid[0,0].ToString().Trim();
                string selectPepodomsql="select 权限名称 from System_PopedomTable where 用户类型='"+userName+"'";
				DataTable tTable=new DataTable();
				tTable=ExcuteSql(selectPepodomsql,"System_PepodomTable");
				for(int i=0;i<tTable.Rows.Count;i++)
				{
					for(int j=0;j<this.popedomListBox.Items.Count;j++)
					{
						if(tTable.Rows[i][0].ToString().Equals(this.popedomListBox.Items[j].ToString()))
						{
							this.popedomListBox.SetItemChecked(j,true);
						}
					}
				}
				#endregion
			}
			catch(Exception ele)
			{
				ele.ToString();
			}
		}
		#endregion
		#region 用户号改变时的变化...
		private void userIDCombo_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			try
			{
				#region 初始化用户名称的内容
                DataTable userTempTable=new DataTable();
				userTempTable=ExcuteSql(searchUserSql,"System_UserTable");
				for(int k=0;k<userTempTable.Rows.Count;k++)
				{
					for(int j=0;j<this.userIDCombo.Items.Count;j++)
					{
						if(userTempTable.Rows[k][0].ToString().Equals(this.userIDCombo.Text))
						{
                            this.textBrushID.Text=userTempTable.Rows[k][1].ToString();
						}
					}
				}
				#endregion
			}
			catch(Exception ele)
			{
				ele.ToString();
			}
		}
		#endregion
		#region DataFunction
		private DataTable ExcuteSql(string strSql,string tableName)
		{
			DataSet dsSet=new DataSet();
			DataTable dsTable=new DataTable();
			try
			{
				dsSet=conn.ExcuteDataSetResult(strSql,tableName);
				dsTable=dsSet.Tables[0];
			}
			catch(Exception eles)
			{
				MessageBox.Show(this,eles.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			return dsTable;
		}
		#endregion
		#region 光标移动变化时...
		private void userIDCombo_MouseLeave(object sender, System.EventArgs e)
		{
		    ComboBox com=(ComboBox)sender;
			com.DropDownStyle=System.Windows.Forms.ComboBoxStyle.Simple;
		}

		private void userIDCombo_MouseEnter(object sender, System.EventArgs e)
		{
			ComboBox com=(ComboBox)sender;
			com.DropDownStyle=System.Windows.Forms.ComboBoxStyle.DropDown;
		}
		private void btnModify_MouseLeave(object sender, System.EventArgs e)
		{
		     Button button=(Button)sender;
			button.FlatStyle=FlatStyle.Flat;
			button.Font=new Font("宋体",9);
		}

		private void btnModify_MouseEnter(object sender, System.EventArgs e)
		{
			Button button=(Button)sender;
			button.FlatStyle=FlatStyle.Standard;
			button.Font=new Font("宋体",9,FontStyle.Underline);
		}
		#endregion
		#region 数据设置....
		private void dataDesign_Click(object sender, System.EventArgs e)
		{
		
		}
		#endregion
		#region 取消事件...
		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			DialogResult result=MessageBox.Show(this,"是否真关闭此窗体啊!!!","提示信息",MessageBoxButtons.YesNo,MessageBoxIcon.Information);
			if(result.Equals (DialogResult.Yes))
			{
				Dispose();
			}
			else 
			{
				return;
			}
		}
		#endregion
		#region 更改目录...
		private void btnModify_Click(object sender, System.EventArgs e)
		{
			if(this.folderBrowserDialog.ShowDialog().Equals(DialogResult.OK))
			{
				this.backText.Text=this.folderBrowserDialog.SelectedPath.ToString()+"\\backup\\";
				this.RestoreText.Text=this.folderBrowserDialog.SelectedPath.ToString()+"\\Restore\\";
			}
		}
		#endregion
		#region 选择某项后...
		private void popedomListBox_ItemCheck(object sender, System.Windows.Forms.ItemCheckEventArgs e)
		{
			try
			{
				if(this.blCheck.Equals(false))
				{
					if(e.CurrentValue.ToString().Equals("Unchecked"))
					{
                        string userCheckBox=this.popedomListBox.SelectedItem.ToString().Trim();
						string userType=this.dataGrid[this.dataGrid.CurrentCell.RowNumber,0].ToString().Trim();
						InsertIntoUser(userCheckBox,userType);
					}
					else if(e.CurrentValue.ToString().Equals("Checked"))
					{
                        string userBox=this.popedomListBox.SelectedItem.ToString().Trim();
						string userName=this.dataGrid[this.dataGrid.CurrentCell.RowNumber,0].ToString().Trim();
						deleteUserType(userBox,userName);
					}
				}
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
        #region DataGrid 鼠标按下事件...
		private void dataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			try
			{
                DataTable searchUserTable=new DataTable();
				searchUserTable=ExcuteSql("select distinct 用户类型 from System_UserTable where 用户名称<>'adminstrator'","System_UserTable");
				if(this.dataGrid.CurrentCell.RowNumber>=searchUserTable.Rows.Count)
				{
					return;
				}
				else
				{
					this.blCheck=true;
					for(int h=0;h<this.popedomListBox.Items.Count;h++)
					{
						this.popedomListBox.SetItemChecked(h,false);
					}
					string userName=this.dataGrid[0,0].ToString().Trim();
					string searchSql="select distinct 权限名称 from System_PopedomTable where 用户类型='"+userName+"'";
					DataTable searchTable=new DataTable();
					searchTable=ExcuteSql(searchSql,"System_PopedomTable");
					for(int i=0;i<searchTable.Rows.Count;i++)
					{
						for (int k=0;k<this.popedomListBox.Items.Count;k++)
						{
							if(searchTable.Rows[i][0].ToString().Equals(this.popedomListBox.Items[k].ToString()))
							{
								this.popedomListBox.SetItemChecked(k,true);
							}
						}
					}
					this.blCheck=false;
				}
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
		#region 添加权限的函数
		private void InsertIntoUser(string userpepodom,string userType)
		{
            string InsertPopedomSql="update System_PopedomTable set 权限名称='"+userpepodom+"'where 用户类型='"+userType+"'";
			ConnectionData conn=new ConnectionData();
			int k=conn.ExcuteStrSql(InsertPopedomSql);
			if(k>0)
			{
				MessageBox.Show(this,"加入权限成功啦!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			else
			{
				MessageBox.Show(this,"加入权限失败啦!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
		#region 删除权限的函数
		private void deleteUserType(string userpepodom,string userType)
		{
			string InsertPopedomSql="delete from System_PopedomTable where (用户类型='"+userType+"'and 权限名称='"+userpepodom+"')";
			ConnectionData conn=new ConnectionData();
			int w=conn.ExcuteStrSql(InsertPopedomSql);
			if(w>0)
			{
                MessageBox.Show(this,"删除权限成功啦!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			else
			{
				MessageBox.Show(this,"删除权限失败啦!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
	}
}