employeedaoimpl.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using DaFanRongMIS.Model.Employee;
using DaFanRongMIS.Model.Common;

#region 描述
//类名：EmployeeDAOImpl
//作用：员工信息操作类
//创建者：姜秀鑫
//创建时间：2008年1月16日
//修改者：
//修改时间：
//修改内容：
#endregion

namespace DaFanRongMIS.Model.Employee
{
    #region 员工基本信息操作类
    class EmployeeDAOImpl:EmployeeDAO
    {
        SqlCommand cmd = null;

        #region 此方用于员工模块，实现员工基本信息的增加
        public string AddEmployee(EmployeeEntity employee)
        {
            cmd = new SqlCommand();
            //cmd.CommandText = "insert into Employee values(@IDCard,@Name,@Sex,@Birthday,@Photo,@Phone,@Mobile,@Address,@PostalCode,@Email,@QQ,@Memo)";
            cmd.CommandText = "proc_AddEmployee";
            cmd.CommandType = CommandType.StoredProcedure;
            #region 为参数列表赋值
            //指定参数列表，为参数赋值
            SqlParameter eIDCard = new SqlParameter("@IDCard", SqlDbType.VarChar, 20);
            eIDCard.Value = employee.EmIDCard;//身份证号
            cmd.Parameters.Add(eIDCard);

            SqlParameter eName = new SqlParameter("@Name", SqlDbType.VarChar, 30);
            eName.Value = employee.EmName;//姓名
            cmd.Parameters.Add(eName);

            SqlParameter eSex = new SqlParameter("@Sex", SqlDbType.VarChar, 30);
            eSex.Value = employee.EmSex;//性别
            cmd.Parameters.Add(eSex);

            SqlParameter eBirthday = new SqlParameter("@Birthday", SqlDbType.VarChar, 20);
            eBirthday.Value = employee.EmBirthday;//出生日期
            cmd.Parameters.Add(eBirthday);

            SqlParameter ePhoto = new SqlParameter("@Photo", SqlDbType.VarChar, 300);
            ePhoto.Value = employee.EmPhoto;//照片
            cmd.Parameters.Add(ePhoto);

            SqlParameter ePhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
            ePhone.Value = employee.EmPhone;//电话
            cmd.Parameters.Add(ePhone);

            SqlParameter eMobile = new SqlParameter("@Mobile", SqlDbType.VarChar, 20);
            eMobile.Value = employee.EmMobile;//手机
            cmd.Parameters.Add(eMobile);

            SqlParameter eAddress = new SqlParameter("@Address", SqlDbType.VarChar, 80);
            eAddress.Value = employee.EmAddress;//家庭住址
            cmd.Parameters.Add(eAddress);

            SqlParameter ePostalCode = new SqlParameter("@PostalCode", SqlDbType.VarChar, 6);
            ePostalCode.Value = employee.EmPostalCode;//邮政编码
            cmd.Parameters.Add(ePostalCode);

            SqlParameter eEmail = new SqlParameter("@Email", SqlDbType.VarChar, 40);
            eEmail.Value = employee.EmEmail;//Email
            cmd.Parameters.Add(eEmail);

            SqlParameter eQQ = new SqlParameter("@QQ", SqlDbType.VarChar, 12);
            eQQ.Value = employee.EmQQ;//QQ
            cmd.Parameters.Add(eQQ);

            SqlParameter eMemo = new SqlParameter("@Memo", SqlDbType.VarChar, 2000);
            eMemo.Value = employee.EmMemo;//备注
            cmd.Parameters.Add(eMemo);
            #endregion

            cmd.Connection = ConnectionDataBase.getConOpen();
            cmd.ExecuteNonQuery();//执行存储过程
            cmd.Dispose();//释放cmd对象
            ConnectionDataBase.getConClose();//关闭数据库连接
            return "OK";
        }//end method AddEmployee
        #endregion

        #region 此方法用来查询饭店信息，用于实现饭店模块饭店信息查找功能
        public SqlDataReader SelectEmployee(EmployeeEntity employee)
        {
            SqlDataReader dr = null;
            string str = "";
            if (employee.EmIDCard != "" && employee.EmName == "")
            {
                str = "select * from Employee where IDCard like '" + employee.EmIDCard + "%'";
            }
            else if (employee.EmName == "" && employee.EmIDCard != "")
            {
                str = "select * from Employee where Name like '" + employee.EmName + "%'";
            }
            else if (employee.EmIDCard != "" && employee.EmName != "")
            {
                str = "select * from Employee where IDCard like'" + employee.EmIDCard + "%'or Name like '" + employee.EmName + "%'";
            }
            else
            {
                str = "select * from Employee";
            }
            cmd = new SqlCommand();
            cmd.Connection = ConnectionDataBase.getConOpen();
            //将饭店信息写入数据库
            cmd.CommandText = str;
            dr = cmd.ExecuteReader();
            return dr;
        }//end method SelectShop()
               #endregion

        #region 此方法用来修改员工信息
        public string UpdateEmployee(EmployeeEntity employee)
        {
            cmd = new SqlCommand();
            cmd.CommandText = "proc_UpdateEmployee";
            cmd.CommandType = CommandType.StoredProcedure;
            #region 为参数列表赋值
            //指定参数列表，为参数赋值
            SqlParameter eIDCard = new SqlParameter("@IDCard", SqlDbType.VarChar, 20);
            eIDCard.Value = employee.EmIDCard;//身份证号
            cmd.Parameters.Add(eIDCard);

            SqlParameter eName = new SqlParameter("@Name", SqlDbType.VarChar, 30);
            eName.Value = employee.EmName;//姓名
            cmd.Parameters.Add(eName);

            SqlParameter eSex = new SqlParameter("@Sex", SqlDbType.VarChar, 30);
            eSex.Value = employee.EmSex;//性别
            cmd.Parameters.Add(eSex);

            SqlParameter eBirthday = new SqlParameter("@Birthday", SqlDbType.VarChar, 20);
            eBirthday.Value = employee.EmBirthday;//出生日期
            cmd.Parameters.Add(eBirthday);

            SqlParameter ePhoto = new SqlParameter("@Photo", SqlDbType.VarChar, 300);
            ePhoto.Value = employee.EmPhone;//照片
            cmd.Parameters.Add(ePhoto);

            SqlParameter ePhone = new SqlParameter("@Phone", SqlDbType.VarChar, 20);
            ePhone.Value = employee.EmPhone;//电话
            cmd.Parameters.Add(ePhone);

            SqlParameter eMobile = new SqlParameter("@Mobile", SqlDbType.VarChar, 20);
            eMobile.Value = employee.EmMobile;//手机
            cmd.Parameters.Add(eMobile);

            SqlParameter eAddress = new SqlParameter("@Address", SqlDbType.VarChar, 80);
            eAddress.Value = employee.EmAddress;//家庭住址
            cmd.Parameters.Add(eAddress);

            SqlParameter ePostalCode = new SqlParameter("@PostalCode", SqlDbType.VarChar, 6);
            ePostalCode.Value = employee.EmPostalCode;//邮政编码
            cmd.Parameters.Add(ePostalCode);

            SqlParameter eEmail = new SqlParameter("@Email", SqlDbType.VarChar, 40);
            eEmail.Value = employee.EmEmail;//Email
            cmd.Parameters.Add(eEmail);

            SqlParameter eQQ = new SqlParameter("@QQ", SqlDbType.VarChar, 12);
            eQQ.Value = employee.EmQQ;//QQ
            cmd.Parameters.Add(eQQ);

            SqlParameter eMemo = new SqlParameter("@Memo", SqlDbType.VarChar, 2000);
            eMemo.Value = employee.EmMemo;//备注
            cmd.Parameters.Add(eMemo);
            #endregion
            cmd.Connection = ConnectionDataBase.getConOpen();
            cmd.ExecuteNonQuery();//执行存储过程
            cmd.Dispose();//释放cmd对象
            ConnectionDataBase.getConClose();//关闭数据库连接
            return "OK";
        }
#endregion

        #region 此方法用来删除员工信息
        public string DeleteEmployee(EmployeeEntity employee)
        {

            cmd = new SqlCommand();
            cmd.CommandText = "proc_DeleteEmployee";
            cmd.CommandType = CommandType.StoredProcedure;
            //指定参数列表，为参数赋值
            SqlParameter eIDCard = new SqlParameter("@IDCard", SqlDbType.VarChar, 20);
            eIDCard.Value = employee.EmIDCard;//身份证号
            cmd.Parameters.Add(eIDCard);

            cmd.Connection = ConnectionDataBase.getConOpen();
            cmd.ExecuteNonQuery();//执行存储过程
            cmd.Dispose();//释放cmd对象
            ConnectionDataBase.getConClose();//关闭数据库连接
            return "OK";
        }
        #endregion
    }
    #endregion
}