workmanege.cs

人事管理系统

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

namespace 人事管理
{
    public partial class workmanege : Form
    {
        data da = new data();
        public workmanege()
        {
            InitializeComponent();
        }

        private void workmanege_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
            sqlda.Fill(ds, "WorkerAttendance");
            worklistview.DataSource = ds.Tables["WorkerAttendance"];
            da.link().Close();
        }
        //本日情况
        private void todaybtn_Click(object sender, EventArgs e)
        {
            DateTime dt = DateTime.Now;
            string aa = dt.ToString("yyyy-MM-dd 00:00:00");
            string bb = dt.ToString("yyyy-MM-dd 23:00:00");
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView WHERE 日期 >= '" + aa + "' and 日期 <= '" + bb + "'", da.link());
            sqlda.Fill(ds, "WorkerAttendance");
            worklistview.DataSource = ds.Tables["WorkerAttendance"];
            da.link().Close();
        }
        //历史查询
        private void selecthistrybtn_Click(object sender, EventArgs e)
        {
            selectwork selwo = new selectwork();
            selwo.ShowDialog();
            DataSet ds = new DataSet();
            string sql = "select * from WorkerAttendanceView WHERE 日期 >= '" + selectwork.aa + "' and 日期 <= '" + selectwork.bb + "'";
            SqlDataAdapter sqlda = new SqlDataAdapter(sql, da.link());
            sqlda.Fill(ds, "WorkerAttendance");
            worklistview.DataSource = ds.Tables["WorkerAttendance"];
            da.link().Close();
        }
        //确定 
        private void yesbtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //考勤设置
        private void setbtn_Click(object sender, EventArgs e)
        {

            if (worklistview.DataSource != null && worklistview.CurrentCell != null)
            {
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda1 = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
                sqlda1.Fill(ds);
                SetAttendanceType sat = new SetAttendanceType();
                sat.Tag = ds.Tables[0].Rows[worklistview.CurrentCell.RowIndex][0].ToString().Trim();
                sat.ShowDialog();
                da.link().Close();
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
                sqlda.Fill(ds, "WorkerAttendance");
                worklistview.DataSource = ds.Tables["WorkerAttendance"];
            }
            else
                MessageBox.Show("没有指定的考勤信息");
            //SetAttendanceType sat = new SetAttendanceType();
            //sat.ShowDialog();
            //DataSet ds = new DataSet();
            //string sql = "select * from WorkerAttendance";
            //SqlDataAdapter sqlda = new SqlDataAdapter(sql, da.link());
            //sqlda.Fill(ds, "WorkerAttendance");
            //worklistview.DataSource = ds.Tables["WorkerAttendance"];
            //da.link().Close();
        }

        private void setinbtn_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
            sqlda.Fill(ds, "WorkerAttendance");
            worklistview.DataSource = ds.Tables["WorkerAttendance"];
            da.link().Close();
        }
    }
}