setholiyday.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 setholiyday : Form
    {
        data da = new data();
        public setholiyday()
        {
            InitializeComponent();
        }
        private void setholiyday_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select HolidayName from Holiday where NationalHoliday=1", da.link());
            sqlda.Fill(ds, "Holiday");
            setholidaybox.DataSource = ds.Tables["Holiday"];
            setholidaybox.DisplayMember = "HolidayName";
            setholidaybox.ValueMember = "HolidayName";
            da.link().Close();
            
        }
        //增加假日
        private void addholidaybtn_Click(object sender, EventArgs e)
        {
            if (checkBox1.Checked == true)
            {
                checkBox1.Text = "1";
            }
            else checkBox1.Text = "0";
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select HolidayTimes,HolidayName,NationalHoliday from Holiday", da.link());
            //添加
            SqlCommand sqlcomm = new SqlCommand("insert Holiday (HolidayTimes,HolidayName,NationalHoliday) values(@HolidayTimes,@HolidayName,@NationalHoliday)", da.link());
            sqlcomm.Parameters.AddWithValue("@HolidayTimes",Convert.ToDateTime( datebox.Text));
            sqlcomm.Parameters.AddWithValue("@HolidayName", holidaynamebox.Text);
            sqlcomm.Parameters.AddWithValue("@NationalHoliday", checkBox1.Text);
            sqlda.InsertCommand = sqlcomm;
            sqlda.InsertCommand.ExecuteNonQuery();
            checkBox1.Text = "国定假期";

            MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //重新显示
            SqlDataAdapter sqlda1 = new SqlDataAdapter("select HolidayName from Holiday where NationalHoliday=1", da.link());
            sqlda1.Fill(ds, "Holiday");
            setholidaybox.DataSource = ds.Tables["Holiday"];
            setholidaybox.DisplayMember = "HolidayName";
            setholidaybox.ValueMember = "HolidayName";
            da.link().Close();
        }
        //删除假日
        private void deleteholidaybtn_Click(object sender, EventArgs e)
        {
            if (setholidaybox.DataBindings != null)
            {
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda = new SqlDataAdapter("select HolidayName from Holiday where NationalHoliday=1", da.link());
                SqlCommand sqlcomm = new SqlCommand("delete Holiday where HolidayName=@HolidayName", da.link());
                SqlParameter para = sqlcomm.Parameters.Add("@HolidayName", SqlDbType.NVarChar, 50, "HolidayName");
                para.SqlValue =setholidaybox.Text;
                para.SourceVersion = DataRowVersion.Current;
                sqlda.DeleteCommand = sqlcomm;
                sqlda.DeleteCommand.ExecuteNonQuery();
                da.link().Close();
                //重新显示
                SqlDataAdapter sqlda1 = new SqlDataAdapter("select HolidayName from Holiday where NationalHoliday=1", da.link());
                sqlda1.Fill(ds, "Holiday");
                setholidaybox.DataSource = ds.Tables["Holiday"];
                setholidaybox.DisplayMember = "HolidayName";
                setholidaybox.ValueMember = "HolidayName";
                da.link().Close();
            }
            else
                MessageBox.Show("没有指定的国定节日信息");
        }
        //确定
        private void yestbtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //取消
        private void outbtn_Click(object sender, EventArgs e)
        {
            DialogResult sss = MessageBox.Show("请确认要取消!", "请确认要退出!", MessageBoxButtons.YesNo);
            if (sss == DialogResult.Yes)
            {
                this.Close();
            }
        }
    }
}