employeedal.cs

c#三层架构项目开发的全过程

                eus.Employee_In_time = (DateTime)item["Employee_In_time"];
                eus.role_ID = (int)item["role_ID"];// item["role_Name"].ToString();
                eus.Shop_id = (int)item["Shop_id"];//item["Shop_name"].ToString();
                eus.Employee_state = item["Employee_state"].ToString();
                eius.Add(eus);
            }
            return eius;
        }
        #endregion

        #region 员工查看详情
        /// <summary>
        /// 员工查看详情
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeSelectDetail(string employee_id)
        {
            string commandtext = "Employee_Select_Detail";
            SqlParameter employid = new SqlParameter("@Employee_ID", SqlDbType.Char, 20);
            employid.Value = employee_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { "Users" }, new SqlParameter[] { employid });
            List<Model.Employee.EmployeeModel> esd = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel eds = new Model.Employee.EmployeeModel();
                eds.Employee_ID = item["Employee_ID"].ToString().Trim();
                eds.Employee_Name = item["Employee_Name"].ToString();
                eds.role_Name= item["role_Name"].ToString(); // eds.role_ID = (int)item["role_ID"];
                eds.Shop_name= item["Shop_name"].ToString(); //eds.Shop_id = (int)item["Shop_id"];
                eds.Employee_In_time = (DateTime)item["Employee_In_time"];
                eds.Employee_Tel = item["Employee_Tel"].ToString();
                //eds.Employee_state = item["Employee_state"].ToString();
                esd.Add(eds);

            }
            return esd;
        }
        #endregion

        #region 获取职位名称
        /// <summary>
        /// 用职位ID找职位名称
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> SelectRoleName(string role_id)
        {
            string commandtext = "EmployeeSelect_Role_Name";
            SqlParameter roleid = new SqlParameter("@role_id", SqlDbType.Int);
            roleid.Value = role_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { roleid });
            List<Model.Employee.EmployeeModel> srn = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel rn = new Model.Employee.EmployeeModel();
                rn.role_Name = item["role_Name"].ToString();
                srn.Add(rn);
            }
            return srn;
        }
        #endregion

        #region 获取分店名称
        /// <summary>
        /// 用分店ID找分店名称
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> SelectShopName(string shop_id)
        {
            string commandtext = "EmployeeSelect_Shop_Name";
            SqlParameter shopid = new SqlParameter("@shop_id", SqlDbType.Int);
            shopid.Value = shop_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { shopid });
            List<Model.Employee.EmployeeModel> ssn = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel sn = new Model.Employee.EmployeeModel();
                sn.Shop_name = item["Shop_name"].ToString();
                ssn.Add(sn);
            }
            return ssn;
        }
        #endregion

        #region 员工信息修改
        /// <summary>
        /// 员工信息修改
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <param name="employee_name">员工姓名</param>
        /// <param name="employee_tel">员工联系电话</param>
        /// <param name="employee_state">员工在职状态</param>
        /// <returns></returns>
        public int EmployeeUpdate(string employee_id, string employee_name, string employee_tel, string employee_state)
        {
            string commandtext = "Employee_Update";
            SqlParameter employeeid = new SqlParameter("@employee_id", SqlDbType.Char, 20);
            //SqlParameter roleid = new SqlParameter("@role_id",SqlDbType.Int);
            //SqlParameter shopid = new SqlParameter("@shop_id", SqlDbType.Int);
            SqlParameter employeename = new SqlParameter("@employee_name", SqlDbType.VarChar, 10);
            SqlParameter employeetel = new SqlParameter("@employee_tel", SqlDbType.Char, 20);
            SqlParameter employeestate = new SqlParameter("@employee_state", SqlDbType.VarChar, 10);
            employeeid.Value = employee_id;
            //roleid.Value = role_id;
            //shopid.Value = shop_id;
            employeename.Value = employee_name;
            employeetel.Value = employee_tel;
            employeestate.Value = employee_state;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { employeeid, employeename, employeetel, employeestate });
        }
        #endregion

        #region 员工信息显示(多表)
        /// <summary>
        /// 员工信息显示
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeInforShows()
        {
            string commandtext = "Employee_Infor_Shows";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
            List<Model.Employee.EmployeeModel> eisw = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel eiw = new Model.Employee.EmployeeModel();
                eiw.Employee_ID = item["Employee_ID"].ToString();
                eiw.Employee_Name = item["Employee_Name"].ToString();
                //eiw.Shop_id = (int)item["Shop_id"];  
                //eiw.role_ID = (int)item["role_ID"];
                eiw.Shop_name = item["Shop_name"].ToString();
                eiw.role_Name = item["role_Name"].ToString();
                eisw.Add(eiw);
            }
            return eisw;
        }
        #endregion

        #region 员工职位调动
        /// <summary>
        /// 员工职位调动
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <param name="employee_name">员工姓名</param>
        /// <param name="role_id">职位ID</param>
        /// <param name="shop_id">分店ID</param>
        /// <returns></returns>
        public int EmployeeJobRemove(string employee_id, string employee_name, int role_id, int shop_id)
        {
            string commandtext = "Employee_Job_Remove";
            SqlParameter employeeid = new SqlParameter("@Employee_id", SqlDbType.Char, 20);
            SqlParameter employeename = new SqlParameter("@Employee_name", SqlDbType.VarChar, 10);
            SqlParameter roleid = new SqlParameter("@role_ID", SqlDbType.Int);
            SqlParameter shopid = new SqlParameter("@Shop_id", SqlDbType.Int);
            employeeid.Value = employee_id;
            employeename.Value = employee_name;
            roleid.Value = role_id;
            shopid.Value = shop_id;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { employeeid, employeename, roleid, shopid });
        }
        #endregion

        #region 根据员工姓名信息查询 多表
        /// <summary>
        /// 根据员工姓名信息查询
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeSelectData(string employee_name)
        {
            string commandtext = "Employee_Select_Data";
            SqlParameter employeename = new SqlParameter("@Employee_name", SqlDbType.VarChar, 10);
            employeename.Value = employee_name;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { employeename });
            List<Model.Employee.EmployeeModel> esd = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel ed = new Model.Employee.EmployeeModel();
                ed.Employee_ID = item["Employee_ID"].ToString();
                ed.Employee_Name = item["Employee_Name"].ToString();
                ed.Shop_name = item["Shop_name"].ToString();
                ed.role_Name = item["role_Name"].ToString();
                ed.Employee_state = item["Employee_state"].ToString();
                esd.Add(ed);
            }
            return esd;
        }
        #endregion

        #region 根据分店名称信息查询 多表
        /// <summary>
        /// 根据分店名称信息查询
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeSelectShop(string shop_name)
        {
            string commandtext = "Employee_Select_Shop";
            SqlParameter shopname = new SqlParameter("@shop_name", SqlDbType.VarChar, 20);
            shopname.Value = shop_name;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { shopname });
            List<Model.Employee.EmployeeModel> esd = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel ed = new Model.Employee.EmployeeModel();
                ed.Employee_ID = item["Employee_ID"].ToString();
                ed.Employee_Name = item["Employee_Name"].ToString();
                ed.Shop_name = item["Shop_name"].ToString();
                ed.role_Name = item["role_Name"].ToString();
                ed.Employee_state = item["Employee_state"].ToString();
                esd.Add(ed);
            }
            return esd;
        }
        #endregion

        #region 员工密码修改（还没有测试）
        /// <summary>
        /// 员工密码修改
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <param name="employee_pwd">员工密码</param>
        /// <returns></returns>
        public int EmployeeUpdatePwd(string employee_id, string employee_pwd)
        {
            string commandtext = "Employee_Update_Password";
            SqlParameter employeeid = new SqlParameter("@Employee_ID",SqlDbType.Char,20);