formsettingsalary.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 FormSettingSalary : Form
    {
        public static string moeny;
        SqlConnection cnBlueHill_HRM;

        public FormSettingSalary()
        {
            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 btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
            FormSalaryManagement FSM = new FormSalaryManagement();
            FSM.Show();
        }

        private void BtnOk_Click(object sender, EventArgs e)
        {
            //moeny = textBox1.Text.Trim();
            //this.Hide();
            //FormSalaryManagement FSM = new FormSalaryManagement();
            //FSM.Show();

            if (textBox1.Text.Trim() != "")
            {
                cnBlueHill_HRM = new SqlConnection("data source=.;initial catalog=BlueHill_HRM;integrated security=true;");
                cnBlueHill_HRM.Open();
                SqlCommand cmd = new SqlCommand("select count(*) from tblSalary " + textBox1.Text.ToString().Trim() + "'", cnBlueHill_HRM);
                int count = Convert.ToInt32(cmd.ExecuteScalar());
                if (count == 0)
                {
                    cnBlueHill_HRM.Close();
                    DialogResult = MessageBox.Show("该部门不存在！", "提示");

                }
                else
                {
                    DB.setA = textBox1.Text.Trim();
                    this.Close();
                }
            }
            else
                DialogResult = MessageBox.Show("请输入您要设置的薪资！", "提示");

        }
    }
}