formemplist.cs

来自「人事管理系统」· CS 代码 · 共 59 行

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 FormEmpList : Form
    {
        SqlConnection cnBlueHill_HRM;
        public FormEmpList()
        {
            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 BtnOK_Click(object sender, EventArgs e)
        {
            this.Hide();
            FormVacationManagement FVM = new FormVacationManagement();
            FVM.Show();
        }
        private void FormEmpList_Load(object sender, EventArgs e)
        {
            cnBlueHill_HRM = new SqlConnection("data source=.;initial catalog=BlueHill_HRM;integrated security=true;");
            cnBlueHill_HRM.Open();
            SqlCommand cmd = new SqlCommand("select * from tblEmployee", cnBlueHill_HRM);
            SqlDataReader bm = cmd.ExecuteReader();
            while (bm.Read())
            {
                lbEmp.Items.Add(bm["Name"].ToString());

            }
            cnBlueHill_HRM.Close();
        }
    }

}