员工考勤.cs

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

				this.emp_Name.SelectedIndex=1;
				#endregion
				#region 初始化 DataGrid 控件...
                InitDataGrid();
				#endregion
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
		#region 工具栏上时间显示...
		private void currentTimer_Tick(object sender, System.EventArgs e)
		{
			this.kaoqinshijian.Text="时间:"+dealTime().Trim();
		}
		#endregion
		#region 工具栏的事件...
		private void tool_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			
            if(e.Button.Text.ToString().Equals("考勤统计"))
			{
				kaqintongjiFrame log=new kaqintongjiFrame();
				log.ShowDialog();
			}
			if(e.Button.Text.ToString().Equals("请假原因"))
			{
				MessageBox.Show(this,"展开下拉菜单!!!","提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			if(e.Button.Text.ToString().Equals("打印月考勤"))
			{
				MonthFrame log=new MonthFrame();
				log.ShowDialog();
			}
		}
		#endregion
		#region 当下拉表内容改变时发生事件...
		private void departmentCombox_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			#region 初始化状态栏上文本...
			for(int k=0;k<this.EmployeeCombox.Items.Count;k++)
			{
				this.kaoqinzhuangtai.Text="末尾的是:"+this.EmployeeCombox.Items[k].ToString().Trim();
			}
			for(int j=0;j<this.EmployeeCombox.Items.Count;j++)
			{
				for(int u=0;u<this.employeeNameTree.Nodes.Count;u++)
				{
					if(this.EmployeeCombox.Items[j].ToString().Equals(this.employeeNameTree.Nodes[u].ToString()))
					{
						this.employeeNameTree.Nodes[u].SelectedImageIndex=1;
					}
				}
			}
			this.employeeNameTree.Select();
			#endregion
			#region  初始化TreeView控件...
			try
			{
				string searchEmployeeNames="Select distinct 职工名称 from Employee  where 职工号='"+this.EmployeeCombox.Text+"'";
				DataSet searchEmployeeNameSets=new DataSet();
				DataTable searchEmployeeNameTables=new DataTable();
				try
				{
					con.ConnectionString=connectionStr;
					con.Open();
					dataAdapter=new SqlDataAdapter(searchEmployeeNames,con);
					int k=dataAdapter.Fill(searchEmployeeNameSets);
					searchEmployeeNameTables=searchEmployeeNameSets.Tables[0];
					for(int p=0;p<searchEmployeeNameTables.Rows.Count;p++)
					{
						for(int t=0;t<this.employeeNameTree.Nodes.Count;t++)
						{
							if(searchEmployeeNameTables.Rows[p][0].ToString().Equals(this.employeeNameTree.Nodes[t].Text.ToString()))
							{
								rootNode.Nodes.RemoveAt(t);
							}
							else
							{
                                rootNode.Nodes.Add(searchEmployeeNameTables.Rows[p][0].ToString().Trim());
							}
						}
					}
					con.Close();
				}
				catch(Exception ele)
				{
					ele.ToString();
				}
				this.employeeNameTree.Nodes.Add(rootNode);
			}
			catch(Exception ele)
			{
				ele.ToString();
			}
			#endregion
		}
		#endregion
		#region 当更改departmentTree控件时发生事件...
		private void departmentTree_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			
		}
		#endregion
		#region 刷卡事件...
		private void menuBrush_Click(object sender, System.EventArgs e)
		{
//			BrushWedgeFrame log=new BrushWedgeFrame();
//			log.ShowDialog();
			DesignFrame log=new DesignFrame();
			log.ShowDialog();
		}
		#endregion
		#region  请假原因
		private void menuReason_Click(object sender, System.EventArgs e)
		{
//		    LeaveReasonFrame log=new LeaveReasonFrame();
//			log.ShowDialog();
			WindowsApplication.EmployeeLeaveManager.EmployeeLeaveManager log=new WindowsApplication.EmployeeLeaveManager.EmployeeLeaveManager();
			log.ShowDialog();
		}
		#endregion
		#region 填充下拉表框
		private DataTable returnEmployeeName()
		{
			string searchEmployeeName="Select distinct 职工号 from Employee";
			DataSet searchEmployeeNameSet=new DataSet();
			DataTable searchEmployeeNameTable=new DataTable();
			try
			{
				con.ConnectionString=connectionStr;
				con.Open();
                dataAdapter=new SqlDataAdapter(searchEmployeeName,con);
				int k=dataAdapter.Fill(searchEmployeeNameSet);
			    searchEmployeeNameTable=searchEmployeeNameSet.Tables[0];
				con.Close();
			}
			catch(Exception ele)
			{
				ele.ToString();
			}
			return searchEmployeeNameTable;
		}
		#endregion
		#region 填充TreeView控件...的函数...
		private DataTable returnEmployeeID()
		{
			string searchEmployeeName="Select distinct 职工名称 from Employee where 职工号='"+this.EmployeeCombox.Text+"'";
			DataSet searchEmployeeNameSet=new DataSet();
			DataTable searchEmployeeNameTable=new DataTable();
			try
			{
				con.ConnectionString=connectionStr;
				con.Open();
				dataAdapter=new SqlDataAdapter(searchEmployeeName,con);
				int k=dataAdapter.Fill(searchEmployeeNameSet);
				searchEmployeeNameTable=searchEmployeeNameSet.Tables[0];
				con.Close();
			}
			catch(Exception ele)
			{
				ele.ToString();
			}
			return searchEmployeeNameTable;
		}
		#endregion
		#region 光标移动变化...
		private void EmployeeCombox_MouseLeave(object sender, System.EventArgs e)
		{
		    ComboBox combo=(ComboBox)sender;
			combo.DropDownStyle=System.Windows.Forms.ComboBoxStyle.Simple;
		}

		private void EmployeeCombox_MouseEnter(object sender, System.EventArgs e)
		{
			ComboBox combo=(ComboBox)sender;
			combo.DropDownStyle=System.Windows.Forms.ComboBoxStyle.DropDown;
		}
		private void emp_Name_MouseLeave(object sender, System.EventArgs e)
		{
		    EmployeeCombox_MouseLeave(sender,e);
		}

		private void emp_Name_MouseEnter(object sender, System.EventArgs e)
		{
		    EmployeeCombox_MouseEnter(sender,e);
		}
		private void btnSearch_MouseLeave(object sender, System.EventArgs e)
		{
		    Button butonn=(Button)sender;
			butonn.FlatStyle=FlatStyle.Flat;
		}

		private void btnSearch_MouseEnter(object sender, System.EventArgs e)
		{
			Button butonn=(Button)sender;
			butonn.FlatStyle=FlatStyle.Standard;
		}
		#endregion
		#region 初始化Emp_NameComboBox控件...
		private DataTable returnEmp_Name()
		{
			DataTable searchEmployeeNameTable=new DataTable();
			try
			{
				string searchEmployeeName="Select distinct 职工名称 from Employee";
				DataSet searchEmployeeNameSet=new DataSet();
				try
				{
					con.ConnectionString=connectionStr;
					con.Open();
					dataAdapter=new SqlDataAdapter(searchEmployeeName,con);
					int k=dataAdapter.Fill(searchEmployeeNameSet);
					searchEmployeeNameTable=searchEmployeeNameSet.Tables[0];
					con.Close();
				}
				catch(Exception ele)
				{
					ele.ToString();
				}
				return searchEmployeeNameTable;
			}
			catch(Exception ele)
			{
				MessageBox.Show(ele.ToString());
			}
			return searchEmployeeNameTable;
		}
		#endregion
		#region TreeView_AfterExpand 事件
		private void employeeNameTree_AfterExpand(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			e.Node.ImageIndex=1;
			e.Node.SelectedImageIndex=1;
		}
		#endregion
		#region TreeView_AfterCollapse 事件
		private void employeeNameTree_AfterCollapse(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			e.Node.ImageIndex=0;
			e.Node.SelectedImageIndex=0;
		}
		#endregion
		#region 查询事件...
		private void btnSearch_Click(object sender, System.EventArgs e)
		{
		
		}
		#endregion
		#region 搜索事件...
		private void btnsearchSou_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.searchKaoQinManager.SelectCommand.Parameters[0].Value="%%";
				this.searchKaoQinManager.SelectCommand.Parameters[1].Value="%%";
				if(this.dateTimePicker1.Text!="")
				{
					this.searchKaoQinManager.SelectCommand.Parameters[0].Value="%"+this.dateTimePicker1.Text+"%";
				}
				else if(this.emp_Name.Text!="")
				{
                    this.searchKaoQinManager.SelectCommand.Parameters[1].Value="%"+this.emp_Name.Text+"%";
				}
				this.emp_BrushFrameIDSet.Emp_BrushID.Clear();
				this.searchKaoQinManager.Fill(emp_BrushFrameIDSet);
				this.dataGrid.DataSource=emp_BrushFrameIDSet.Tables[0];
			}
			catch(Exception ele)
			{
                MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			finally
			{
				if(this.sqlConn.State.Equals(ConnectionState.Open))
				{
					this.sqlConn.Close();
				}
			}
		}
		#endregion
		#region 初始化 DataGrid 控件...
		private void InitDataGrid()
		{
			try
			{
				this.searchKaoQinManager.SelectCommand.Parameters[0].Value="%%";
				this.searchKaoQinManager.SelectCommand.Parameters[1].Value="%%";
				sqlDataAdapter.Fill(emp_BrushFrameIDSet);
				this.searchKaoQinManager.Fill(emp_BrushFrameIDSet);
				DataTable emp_TimeRule=new DataTable();