holiydaymanege.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 holiydaymanege : Form
    {
        data da = new data();
        public holiydaymanege()
        {
            InitializeComponent();
        }

        private void holiydaymanege_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
            sqlda.Fill(ds, "WorkerLeave");
            leaveview.DataSource = ds.Tables["WorkerLeave"];
            da.link().Close();
        }
        //删除
        private void deletebtn_Click(object sender, EventArgs e)
        {
            if (leaveview.DataSource != null && leaveview.CurrentCell != null)
            {
                DialogResult sss = MessageBox.Show("是否确认删除!", "是否确认删除!", MessageBoxButtons.YesNo);
                if (sss == DialogResult.Yes)
                {
                    SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
                    SqlCommand sqlcomm = new SqlCommand("delete WorkerLeave where LeaveApplicationID=@LeaveApplicationID", da.link());
                    SqlParameter para = sqlcomm.Parameters.Add("@LeaveApplicationID", SqlDbType.Int, 4, "LeaveApplicationID");
                    para.SqlValue = leaveview.SelectedCells[0].Value.ToString();
                    para.SourceVersion = DataRowVersion.Current;
                    sqlda.DeleteCommand = sqlcomm;
                    sqlda.DeleteCommand.ExecuteNonQuery();
                    da.link().Close();
                    DataSet ds = new DataSet();
                    sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
                    sqlda.Fill(ds, "WorkerLeave");
                    leaveview.DataSource = ds.Tables["WorkerLeave"];

                }
            }
            else
                MessageBox.Show("没有指定的员工信息");
        }
        //撤销申请
        private void rebtn_Click(object sender, EventArgs e)
        {
            DialogResult sss = MessageBox.Show("是否确认撤销申请!", "是否确认撤销申请!", MessageBoxButtons.YesNo);
            if (sss == DialogResult.Yes)
            {
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
                sqlda.Fill(ds, "WorkerLeave");
                SqlCommand sqlcomm = new SqlCommand("delete WorkerLeave where LeaveApplicationID=@LeaveApplicationID", da.link());
                SqlParameter para = sqlcomm.Parameters.Add("@LeaveApplicationID", SqlDbType.Int, 4, "LeaveApplicationID");
                para.SqlValue = leaveview.SelectedCells[0].Value.ToString();
                para.SourceVersion = DataRowVersion.Current;
                人事管理.HolidayManage.RejectReason rejectreason = new 人事管理.HolidayManage.RejectReason();
                rejectreason.Tag = ds.Tables[0].Rows[leaveview.CurrentCell.RowIndex][0].ToString().Trim();
                rejectreason.ShowDialog();
                da.link().Close();
                ds.Clear();
                sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
                sqlda.Fill(ds, "WorkerLeave");
                leaveview.DataSource = ds.Tables["WorkerLeave"]; 
            }
        }
        //部门汇总
        private void mainbranchbtn_Click(object sender, EventArgs e)
        {
            DataSet ds=new DataSet ();
            人事管理.HolidayManage.Branchcollect branchcollect = new 人事管理.HolidayManage.Branchcollect();
            branchcollect.ShowDialog();
            SqlDataAdapter sqlda = new SqlDataAdapter("select LeaveApplicationID as 请假申请编号,WorkerLeave.WorkerID as 员工编号,ReferTime as 提交时间,Birthday as 员工生日,StartTime as 开始时间,EndTime as 结束时间,ReasonExplain as 理由说明,StypeID as 类型编号,HourCount as 小时数,ApplicationEstate as 申请状态,AuditingID as 审核者编号,RejectReason as 拒绝申请的理由 from WorkerLeave inner join Worker on Worker.WorkerID=WorkerLeave.WorkerID inner join branchnum on branchnum.branchnumID=Worker.branchnumID where branchnum.branchnumname='" + branchcollect.comboBox1.Text + "'", da.link());
            sqlda.Fill(ds, "holiydaymanegeView");
            if (ds.Tables["holiydaymanegeView"].Rows.Count ==0)
            {
                MessageBox.Show("本部门没有任何请假记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                leaveview.DataSource = ds.Tables["holiydaymanegeView"];
            }
        }
        //员工汇总
        private void mainworkerbtn_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            人事管理.HolidayManage.Workercollect workercollect = new 人事管理.HolidayManage.Workercollect();
            workercollect.ShowDialog();
            SqlDataAdapter sqlda = new SqlDataAdapter("select LeaveApplicationID as 请假申请编号,WorkerLeave.WorkerID as 员工编号,ReferTime as 提交时间,Birthday as 员工生日,StartTime as 开始时间,EndTime as 结束时间,ReasonExplain as 理由说明,StypeID as 类型编号,HourCount as 小时数,ApplicationEstate as 申请状态,AuditingID as 审核者编号,RejectReason as 拒绝申请的理由 from WorkerLeave inner join Worker on Worker.WorkerID=WorkerLeave.WorkerID where Worker.WorkerName='" + workercollect.comboBox1.Text + "'", da.link());
            sqlda.Fill(ds, "WorkerLeave");
            if (ds.Tables["WorkerLeave"].Rows.Count == 0)
            {
                MessageBox.Show("此员工没有任何请假记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                leaveview.DataSource = ds.Tables["WorkerLeave"];
            }
        }
        //假期设置
        private void holidaysetbtn_Click(object sender, EventArgs e)
        {
            setholiyday setday = new setholiyday();
            setday.ShowDialog();
        }

        private void yesbtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //取消
        private void button1_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerLeaveView", da.link());
            sqlda.Fill(ds, "WorkerLeave");
            leaveview.DataSource = ds.Tables["WorkerLeave"];
            da.link().Close();
        }
    }
}