employeeform.cs

一个超市管理系统,没有错误,非常好,里面什么都有!很使用,很有用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DaFanRongMIS.ViewController.Employee;
using DaFanRongMIS.Model.Employee;

namespace DaFanRongMIS.ViewController.Employee
{
    public partial class EmployeeForm : Form
    {
        public EmployeeForm()
        {
            InitializeComponent();
        }
        SqlDataReader dr = null;
        EmployeeEntity employee;
        EmployeeDAO employeedao;

        #region 填充ListView方法
        public void FillLV(SqlDataReader dr)
        {

            //判断是否有异常
            if (dr != null)
            {
                //清除ListView上的所有项
                this.LVEmployee.Items.Clear();
                //有返回值，将其填充到ListView中
                while (dr.Read())
                {
                    ListViewItem item = new ListViewItem(dr["IDCard"].ToString());//身份证号	
                    item.SubItems.Add(dr["Name"].ToString());//姓名
                    item.SubItems.Add(dr["Sex"].ToString());//性别
                    item.SubItems.Add(dr["Birthday"].ToString());//出生日期
                    item.SubItems.Add(dr["Photo"].ToString());//照片
                    item.SubItems.Add(dr["Phone"].ToString());//联系电话
                    item.SubItems.Add(dr["Mobile"].ToString());//手机
                    item.SubItems.Add(dr["Address"].ToString());//家庭住址
                    item.SubItems.Add(dr["PostalCode"].ToString());//邮政编码
                    item.SubItems.Add(dr["Email"].ToString());//信箱
                    item.SubItems.Add(dr["QQ"].ToString());//QQ
                    item.SubItems.Add(dr["Memo"].ToString());//备注
                    this.LVEmployee.Items.Insert(this.LVEmployee.Items.Count, item);
                }
            }
        }//end method FillLV
        #endregion

        private void AddEmployee_Click(object sender, EventArgs e)
        {
            //显示员工信息模块增加操作窗体(1为增加)
            new EmployeeOperForm(1, LVEmployee).ShowDialog();
        }

        private void btnSel_Click(object sender, EventArgs e)
        {
            employee = new EmployeeEntity();
            employee.EmIDCard = this.txtIDCard.Text;
            employee.EmName = this.txtName.Text;
            employeedao = new EmployeeDAOImpl();
            dr = employeedao.SelectEmployee(employee);
            this.FillLV(dr);//调用填充ListView方法
        }

        private void LVEmployee_Click(object sender, EventArgs e)
        {
            this.UpdateEmployee.Visible = true;
            this.DeleteEmployee.Visible = true;
        }

        private void EmployeeForm_Load(object sender, EventArgs e)
        {
            this.UpdateEmployee.Visible = false;
            this.DeleteEmployee.Visible = false;
        }

        private void UpdateEmployee_Click(object sender, EventArgs e)
        {
            //员工信息修改
            //显示员工信息模块修改操作窗体(2为修改)
            new EmployeeOperForm(2, LVEmployee).ShowDialog();
        }

        #region 员工信息删除
        private void DeleteEmployee_Click(object sender, EventArgs e)
        {
            //员工信息删除
            //删除
            if (LVEmployee.SelectedItems.Count == 0)
            {
                MessageBox.Show("您没有选择要删除的记录，请选择", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (LVEmployee.SelectedItems.Count > 0)  //有要删除的项
            {
                //提示用户是否删除

                if (MessageBox.Show("真的要删除信息吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    employeedao = new EmployeeDAOImpl();
                    if (employeedao.DeleteEmployee(employee) == "OK")
                    {
                        LVEmployee.SelectedItems[0].Remove();
                        MessageBox.Show("删除信息成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                    }
                }

            }
        }
        #endregion
    }
}