formvacationsetting.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 HumanResourceManagement
{
    public partial class FormVacationSetting : Form
    {
        SqlConnection cnn;
        public FormVacationSetting()
        {
            InitializeComponent();
        }

        private const int CP_NOCLOSE_BUTTON = 0x200;
        protected override CreateParams CreateParams
        {
            get
            {
                CreateParams myCp = base.CreateParams;
                myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON;
                return myCp;
            }
        } 

        private void btnAddVaction_Click(object sender, EventArgs e)
        {
            cnn = new SqlConnection("data source=.;initial catalog=BlueHill_HRM;integrated security=true;");
            cnn.Open();
            if (textBox1.Text.Trim() != "")
            {
                if (checkBox1.Checked == true)
                {

                    SqlCommand cmd = new SqlCommand("insert into tblHoliday(HolidayID, HolidayDate,HolidayName,IsNationalHoliday) values ('" + addFVSid.Text.ToString().Trim() + "','" + dtpVacationDay.Value.ToShortDateString() + "','" + textBox1.Text.ToString().Trim() + "','" + true + "')", cnn);
                    int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                    if (count > 0)
                    {
                        DialogResult = MessageBox.Show("添加成功！", "提示");
                    }
                    else
                        DialogResult = MessageBox.Show("操作失败！", "提示");
                }
                else
                {
                    SqlCommand cmd1 = new SqlCommand("insert into tblHoliday( HolidayID,HolidayDate,HolidayName,IsNationalHoliday)  values('" + addFVSid.Text.ToString().Trim() + "','" + dtpVacationDay.Value.ToShortDateString() + "','" + textBox1.Text.ToString().Trim() + "','" + false + "')", cnn); 
                    int count1 = Convert.ToInt32(cmd1.ExecuteNonQuery());
                    if (count1 > 0)
                    {
                        DialogResult = MessageBox.Show("添加成功！", "提示");
                    }
                    else
                        DialogResult = MessageBox.Show("操作失败！", "提示");
                }
                cnn.Close();
            }
            else
                DialogResult = MessageBox.Show("请输入假期名称！", "提示");
            textBox1.Focus();

        }

        private void FormVacationSetting_Load(object sender, EventArgs e)
        {
            cnn = new SqlConnection("data source=.;initial catalog=BlueHill_HRM;integrated security=true;");
            cnn.Open();
            string cmd = "select * from  tblHoliday";
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter(cmd, cnn);
            sda.Fill(ds, "tblHoliday");
            this.clbVacation.DataSource = ds.Tables["tblHoliday"];
            this.clbVacation.ValueMember = "HolidayID";
            this.clbVacation.DisplayMember = "HolidayName";
            cnn.Close();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Hide();
            FormVacationManagement VM = new FormVacationManagement();
            VM.Show();
        }

        private void btnDelVaction_Click(object sender, EventArgs e)
        {
            MessageBox.Show(clbVacation.SelectedItems.ToString());
        }



        private void BtnDelVaction_Click_1(object sender, EventArgs e)
        {
            if (checkBox1.Checked == true)
            {
                cnn = new SqlConnection("data source=.;initial catalog=BlueHill_HRM;integrated security=true;");
                cnn.Open();
                SqlCommand cmd = new SqlCommand("delete tblHoliday from tblHoliday where (HolidayID, HolidayDate,HolidayName,IsNationalHoliday) values ('" + addFVSid.Text.ToString().Trim() + "','" + dtpVacationDay.Value.ToShortDateString() + "','" + textBox1.Text.ToString().Trim() + "','" + true + "')", cnn);
                int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                if (count > 0)
                {
                    DialogResult = MessageBox.Show("删除成功！", "提示");
                }
                else
                    DialogResult = MessageBox.Show("删除失败！", "提示");
            }
            else
            {
                SqlCommand cmd1 = new SqlCommand("insert into tblHoliday( HolidayID,HolidayDate,HolidayName,IsNationalHoliday)  values('" + addFVSid.Text.ToString().Trim() + "','" + dtpVacationDay.Value.ToShortDateString() + "','" + textBox1.Text.ToString().Trim() + "','" + false + "')", cnn);
                int count1 = Convert.ToInt32(cmd1.ExecuteNonQuery());
                if (count1 > 0)
                {
                    DialogResult = MessageBox.Show("删除成功！", "提示");
                }
                else
                    DialogResult = MessageBox.Show("删除失败！", "提示");
            }
            cnn.Close();
        }




        private void BtnOK_Click(object sender, EventArgs e)
        {
            this.Hide();
            FormVacationManagement FVM = new FormVacationManagement();
            FVM.Show();
        }

        private void btnCancel_Click_1(object sender, EventArgs e)
        {
            this.Hide();
            FormVacationManagement FVM = new FormVacationManagement();
            FVM.Show();
        }

    }
}