navigationframe.cs

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

		{
			this.jishuzhichiTitle.Font=new Font("Verdana",10.5f,FontStyle.Underline);
			this.jishuzhichiTitle.ForeColor=Color.DarkTurquoise;
		}
		private void kaoQinTongJiLabel_MouseLeave(object sender, System.EventArgs e)
		{
			Label label=(Label)sender;
			label.FlatStyle=FlatStyle.Flat;
		}

		private void kaoQinTongJiLabel_MouseEnter(object sender, System.EventArgs e)
		{
			Label label=(Label)sender;
			label.FlatStyle=FlatStyle.Standard;
		}
		#endregion
		#region ShowHideQuanXian()
		private void ShowHideQuanXian()
		{
			try
			{
				string QuanXianSql="select distinct 权限名称 from System_PopedomTable where 用户类型='"+landFrame.strName+"'";
				DataTable tempTable=new DataTable();
				tempTable=ExcuteSql(QuanXianSql,"System_PopedomTable");
				#region 判断权限的函数
				QuanXianModify(tempTable);
				#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 QuanXianModify(DataTable QuanXianTable)
		{
			if(landFrame.blTure.Equals(true))
			{
				ShowControl(false);
				this.startLoadQuanXian.Enabled=false;
				this.modifyQuanXian.Enabled=false;
				if(landFrame.strName.Equals("管理员"))
				{
					ShowControl(true);
					#region 状态栏上改变登录的用户
					#endregion
				}
				else
				{
					for(int i=0;i<QuanXianTable.Rows.Count;i++)
					{
						#region 考勤管理...
						if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("员工档案"))
						{
							EmployeeLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("考勤日志"))
						{
							KaoQinRiZhiLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("早退查询"))
						{
							ZhaoTuiLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("迟到查询"))
						{
							lateLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("请假查询"))
						{
							LeaveLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("权限管理"))
						{
							QuXianLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("用户管理"))
						{
							usersManagerLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("考勤统计"))
						{
							kaoQinTongJiLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("考勤备份"))
						{
							KaoQinBackLabel.Enabled=true;
						}
							#endregion
						#region 用户管理...
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("用户管理"))
						{
							userManagerLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("权限管理"))
						{
							UserPopedomLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Equals("系统设置"))
						{
							SystemDesignLabel.Enabled=true;
						}
							#endregion
						#region 系统管理...
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("系统备份"))
						{
							SystemBackLabel.Enabled=true;
						}
						else if(QuanXianTable.Rows[i][0].ToString().Trim().Equals("系统还原"))
						{
							SystemRevertLabel.Enabled=true;
						}
						#endregion
					}
					#region 状态栏上改变登录的用户
					#endregion
				}
			}
		}
		#endregion
        #region 所有控件隐藏与显示
		private void ShowControl(bool f)
		{
			#region 考勤管理...
			EmployeeLabel.Enabled=f;
			KaoQinRiZhiLabel.Enabled=f;
			ZhaoTuiLabel.Enabled=f;
			lateLabel.Enabled=f;
			LeaveLabel.Enabled=f;
			QuXianLabel.Enabled=f;
			usersManagerLabel.Enabled=f;
			kaoQinTongJiLabel.Enabled=f;
			KaoQinBackLabel.Enabled=f;
			#endregion
			#region 系统管理...
			SystemBackLabel.Enabled=f;
			SystemRevertLabel.Enabled=f;
            SystemDesignLabel.Enabled=f;
			#endregion
			#region 用户管理...
			userManagerLabel.Enabled=f;
			UserPopedomLabel.Enabled=f;
			#endregion
		}
		#endregion
		#region 两个时间处理事件....判断权限改变的事件..
		private void startLoadQuanXian_Tick(object sender, System.EventArgs e)
		{
		   ShowHideQuanXian();
		}

		private void modifyQuanXian_Tick(object sender, System.EventArgs e)
		{
		   ShowHideQuanXian();
		}
		#endregion
		#region 标题移动开始...
		private void titleLabel_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			this.blMove=true;
            this.MouseX=e.X;
			this.MouseY=e.Y;
		}
		#endregion
		#region 移动过程中....
		private void titleLabel_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if(blMove.Equals(true))
			{
				this.Top+=e.Y-this.MouseY;
				this.Left+=e.X-this.MouseX;
			}
		}
		#endregion
		#region 移动停止....
		private void titleLabel_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			this.blMove=false;
		}
		#endregion
		#region 关闭事件...
		private void menuClose_Click(object sender, System.EventArgs e)
		{
		    DialogResult result=MessageBox.Show(this,"是否真的关闭窗体啊!!!","提示信息",MessageBoxButtons.YesNo,MessageBoxIcon.Information);
			if(result.Equals(DialogResult.Yes))
			{
				this.Dispose();
			}
			else
			{
				return;
			}
		}
		#endregion
		#region 添加用户操作历史　...
		private void UserOperatorHistory(string strUser)
		{
			try
			{
				if(strUser.Equals("员工考勤"))
				{
					this.sqlConnection1.Open();
					this.sqlInsertCommand1.Parameters["@日期"].Value=DateTime.Now.ToString("yyyy-MM-dd").Trim();
					this.sqlInsertCommand1.Parameters["@时间"].Value=WindowsApplication.dealTime.dealTime.dealTimeString(System.DateTime.Now.Hour,System.DateTime.Now.Minute,System.DateTime.Now.Second).Trim();
					this.sqlInsertCommand1.Parameters["@操作员"].Value=landFrame.strUserName;
					this.sqlInsertCommand1.Parameters["@状态"].Value=strUser;
					int k=this.sqlInsertCommand1.ExecuteNonQuery();
					if(k>0)
					{}
					else
					{
						MessageBox.Show(this,"记录失败啊!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
				else if(strUser.Equals("窗体设置"))
				{
					this.sqlConnection1.Open();
					this.sqlInsertCommand1.Parameters["@日期"].Value=DateTime.Now.ToString("yyyy-MM-dd").Trim();
					this.sqlInsertCommand1.Parameters["@时间"].Value=WindowsApplication.dealTime.dealTime.dealTimeString(System.DateTime.Now.Hour,System.DateTime.Now.Minute,System.DateTime.Now.Second).Trim();
					this.sqlInsertCommand1.Parameters["@操作员"].Value=landFrame.strUserName;
					this.sqlInsertCommand1.Parameters["@状态"].Value=strUser;
					int k=this.sqlInsertCommand1.ExecuteNonQuery();
					if(k>0)
					{}
					else
					{
						MessageBox.Show(this,"记录失败啊!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
				else if(strUser.Equals("考勤日志"))
				{
					this.sqlConnection1.Open();
					this.sqlInsertCommand1.Parameters["@日期"].Value=DateTime.Now.ToString("yyyy-MM-dd").Trim();
					this.sqlInsertCommand1.Parameters["@时间"].Value=WindowsApplication.dealTime.dealTime.dealTimeString(System.DateTime.Now.Hour,System.DateTime.Now.Minute,System.DateTime.Now.Second).Trim();
					this.sqlInsertCommand1.Parameters["@操作员"].Value=landFrame.strUserName;
					this.sqlInsertCommand1.Parameters["@状态"].Value=strUser;
					int k=this.sqlInsertCommand1.ExecuteNonQuery();
					if(k>0)
					{}
					else
					{
						MessageBox.Show(this,"记录失败啊!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
				else if(strUser.Equals("考勤备份"))
				{
					this.sqlConnection1.Open();
					this.sqlInsertCommand1.Parameters["@日期"].Value=DateTime.Now.ToString("yyyy-MM-dd").Trim();
					this.sqlInsertCommand1.Parameters["@时间"].Value=WindowsApplication.dealTime.dealTime.dealTimeString(System.DateTime.Now.Hour,Syst