资源简介

工考勤管理系统源码 功能介绍: 登陆用户分为管理员,和普通员工。 管理员可以管理员工信息,管理部门信息,修改工资, 修改加班费用和惩罚费用,设置考勤时间,可以查询工资 统计信息并导出excel表格。 普通员工可以签到和签退,修改自己密码等信息。 开发环境为Visual Studio 2010,数据库为SQL Server 2005,数据库文件在

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 员工考勤管理系统
{
    public partial class Attendance : Form
    {
        public Attendance()
        {
            InitializeComponent();
        }//_来_自_5_1_a_s_p_x
        
        /// 
        /// 初始化加载员工签到签离界面
        /// 

        /// 
        /// 
        private void Attendance_Load(object sender EventArgs e)
        {
            label1.BackColor = Color.Transparent;

            this.panel1.Visible = true;
            this.panel2.Visible = false;
            this.panel1.BackColor = Color.Transparent;
            this.panel2.BackColor = Color.Transparent;
            timer1.Enabled = true;
            timer1.Interval = 100;
            timer1.Tick += new EventHandler(time1_Tick);
            reLoadTime();

        }
        private void time1_Tick(object sender EventArgs e)
        {
            this.label4.Text = DateTime.Now.Hour.ToString() + “时“ + DateTime.Now.Minute.ToString()+“分“+DateTime.Now.Second.ToString()+“秒“;

        }
        /// 
        /// 签到
        /// 

        /// 
        /// 
        private void button1_Click_1(object sender EventArgs e)
        {
            string number = this.textBox1.Text.Trim();
            if (number == string.Empty)
            {
                MessageBox.Show(“请输入员工编号!“);
                return;
            }
            else
            {

                int ii;
                if (int.TryParse(number out ii))  //bool
                {
                    int intnumber = Convert.ToInt32(number);
                    string sql = “select count(Time_EmployeeId)as IdCount from Timetable where Time_EmployeeId=@employeeid“;
                    DataTable dt = DbHelper.Instance.CreateDataTable(sql new SqlParameter(“employeeid“ intnumber));
                    int count = Convert.ToInt32(dt.Rows[0][“IdCount“]);
                   
                    DateTime date = DateTime.Now.Date;
                    DateTime time2 = DateTime.Now;
                    
                    if (count == 0)
                    {
                        MessageBox.Show(“员工编号不存在“);
                        //DateTime time = DateTime.Now.Date;
                        //MessageBox.Show(time.ToString(“yyyy-MM-dd“));rn
                        return;
                    }
                    else
                    {
                        
                        
                            DateTime nowdate = DateTime.Now.Date;

                            
                           
                            string sql_date = “select count(Time_Date)as counttime from T

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2012-07-03 15:43  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\
     文件         403  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\App.config
     文件       32038  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\appicon.ico
     文件       20781  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\Attendance.cs
     文件       17912  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\Attendance.Designer.cs
     文件       29484  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\Attendance.resx
     目录           0  2012-07-03 15:42  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\
     目录           0  2012-07-03 15:42  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\
     文件      996352  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.exe
     文件         403  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.exe.config
     文件      366080  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.pdb
     文件       11600  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.vshost.exe
     文件         403  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.vshost.exe.config
     文件         490  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\bin\Debug\员工考勤管理系统.vshost.exe.manifest
     文件         913  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\CheckExist.cs
     文件       22885  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\CreateExcel.cs
     文件        2730  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\CreateExcel.designer.cs
     文件        6020  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\CreateExcel.resx
     文件       20480  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\Database1.sdf
     文件       20480  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\Database2.sdf
     目录           0  2012-07-03 15:42  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DB\
     文件       15525  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DbHelper.cs
     文件    11534336  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DB\考勤系统.mdf
     文件     5308416  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DB\考勤系统_log.ldf
     文件         388  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteRecord.cs
     文件        7659  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteRecord.Designer.cs
     文件        5817  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteRecord.resx
     文件         384  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteUser.cs
     文件        4528  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteUser.Designer.cs
     文件        5817  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\DeleteUser.resx
     文件       18637  2012-07-02 10:40  51aspx_AttendanceManagement9b254b9f-ade9-4159-bfd1-e78b0715d2b9\EmployeeForm.cs
............此处省略254个文件信息

评论

共有 条评论