employeedal.cs

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

            SqlParameter employeepwd = new SqlParameter("@Employee_pwd",SqlDbType.VarChar,100);
            employeeid.Value = employee_id;
            employeepwd.Value = employee_pwd;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { employeeid, employeepwd });
        }
        #endregion

        #region 员工修改密码时查看信息（还没有测试）
        /// <summary>
        /// 员工修改密码时查看信息
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeUpdatePwdSelect(string employee_id)
        {
            string commandtext = "Employ_Updatepwd_SelInfo";
            SqlParameter employeeid = new SqlParameter("@Employee_ID", SqlDbType.Char, 20);
            employeeid.Value = employee_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { employeeid});
            List<Model.Employee.EmployeeModel> eup = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel pwd = new Model.Employee.EmployeeModel();
                pwd.Employee_ID = item["Employee_ID"].ToString();
                pwd.Employee_Name = item["Employee_Name"].ToString();
                pwd.Employee_pwd = item["Employee_pwd"].ToString();
                eup.Add(pwd);
            }
            return eup;
        }
        #endregion

        #region 密码重置
        /// <summary>
        /// 密码重置
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <returns></returns>
        public int EmployeePasswordReset(string employee_id)
        {
            string commandtext = "Employee_Password_Reset";
            SqlParameter employeeid = new SqlParameter("@Employee_ID", SqlDbType.Char, 20);
            employeeid.Value = employee_id.Trim();
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { employeeid });
        }
        #endregion

        #region 员工离职
        /// <summary>
        /// 员工离职
        /// </summary>
        /// <param name="employee_id">员工编号</param>
        /// <returns></returns>
        public int EmployeeLeaveWorke(string employee_id)
        {
            string commandtext = "Employee_LeaveWorker";
            SqlParameter employeeid = new SqlParameter("@Employee_ID", SqlDbType.Char, 20);
            employeeid.Value = employee_id.Trim();
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { employeeid });
        }
        #endregion

        #region 员工状态信息显示
        /// <summary>
        /// 员工状态信息显示
        /// </summary>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeStateShow()
        {
            string commandtext = "Employee_State_Show";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
            List<Model.Employee.EmployeeModel> Show = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel showstate = new Model.Employee.EmployeeModel();
                showstate.Employee_ID = item["Employee_ID"].ToString();
                showstate.Employee_Name = item["Employee_Name"].ToString();
                showstate.role_Name = item["role_Name"].ToString();
                showstate.Shop_name = item["Shop_name"].ToString();
                showstate.Employee_In_time = (DateTime)item["Employee_In_time"];
                showstate.Employee_Tel = item["Employee_Tel"].ToString();
                showstate.Employee_state = item["Employee_state"].ToString();
                Show.Add(showstate);
            }
            return Show;
        }
        #endregion

        #region 根据员工状态查询
        /// <summary>
        /// 根据员工状态查询
        /// </summary>
        /// <param name="Employee_state">员工状态</param>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> EmployeeStateSelect(string employee_state)
        {
            string commandtext = "Employee_State_select";
            SqlParameter employeestate = new SqlParameter("@Employee_state", SqlDbType.VarChar, 10);
            employeestate.Value = employee_state;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { employeestate });
            List<Model.Employee.EmployeeModel> State = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel selectState = new Model.Employee.EmployeeModel();
                selectState.Employee_ID = item["Employee_ID"].ToString().Trim();
                selectState.Employee_Name = item["Employee_Name"].ToString();
                selectState.role_Name = item["role_Name"].ToString(); // eds.role_ID = (int)item["role_ID"];
                selectState.Shop_name = item["Shop_name"].ToString(); //eds.Shop_id = (int)item["Shop_id"];
                selectState.Employee_In_time = (DateTime)item["Employee_In_time"];
                selectState.Employee_Tel = item["Employee_Tel"].ToString();
                selectState.Employee_state = item["Employee_state"].ToString();
                State.Add(selectState);
            }
            return State;
        }
        #endregion

        #region 根据员工ID查询店铺ID
        /// <summary>
        /// 根据员工ID查询店铺ID
        /// </summary>
        /// <param name="Employee_ID">员工ID</param>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> ShopidSelect(string Employee_ID)
        {
            List<Model.Employee.EmployeeModel> list = new List<Model.Employee.EmployeeModel>();
            string commandtext = "ShopByEmployee_Select";
            SqlParameter id = new SqlParameter("@Employee_ID", SqlDbType.Char, 20);
            id.Value = Employee_ID;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel selectState = new Model.Employee.EmployeeModel();
                selectState.Shop_id = (int)item["Shop_id"];
                list.Add(selectState);
            }
            return list;
        }
        #endregion

        #region 用户登录
        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="Employee_ID">登陆用户名</param>
        /// <param name="Employee_pwd">登录密码</param>
        /// <returns>返回用户登录时的用户名，密码</returns>
        public bool UserEnt(string Employee_ID, string Employee_pwd)
        {
            string commandtext = "LoginIn";
            SqlParameter name = new SqlParameter("@Employee_ID", SqlDbType.Char,20);
            SqlParameter pwd = new SqlParameter("@Employee_pwd", SqlDbType.VarChar,100);
            name.Value = Employee_ID.Trim ();
            pwd.Value = Employee_pwd.Trim ();
            SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { name, pwd });
            //true用户名密码正确，false相反
            if (dr.Read())
            {
                return true;
            }
            else
            {
                return false;

            }
        }
        #endregion

        #region 通过员工编号查询角色编号以及功能编号
        /// <summary>
        /// 通过员工编号查询角色编号以及功能编号
        /// </summary>
        /// <param name="Employee_ID">员工编号</param>
        /// <returns></returns>
        public List<Model.Employee.EmployeeModel> SelectRole(string Employee_ID)
        {
            string commandtext = "Role_Select";
            SqlParameter id = new SqlParameter("@Employee_ID",SqlDbType.Char,20);
            id.Value = Employee_ID;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
            List<Model.Employee.EmployeeModel> ssi = new List<Model.Employee.EmployeeModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Employee.EmployeeModel ss = new Model.Employee.EmployeeModel();
                ss.Employee_ID = item["Employee_ID"].ToString();
                ss.role_ID = (int)item["role_ID"];
                ss.SysFunction_id = (int)item["SysFunction_id"];
                ssi.Add(ss);
            }
            return ssi;
        }
        #endregion

        #region 验证员工角色及功能
        /// <summary>
        ///  验证员工角色及功能
        /// </summary>
        /// <param name="role_ID">角色编号</param>
        /// <param name="SysFunction_id">功能编号</param>
        /// <returns></returns>
        public bool UserRole(string role_ID, string SysFunction_id)
        {
            string commandtext = "RoleSys";
            SqlParameter rid = new SqlParameter("@role_ID", SqlDbType.Int);
            SqlParameter sid = new SqlParameter("@SysFunction_id", SqlDbType.Int);
            rid.Value = role_ID;
            sid.Value = SysFunction_id;
            SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { rid, sid });
            //true拥有权限，false相反
            if (dr.Read())
            {
                return true;
            }
            else
            {
                return false;

            }
        }
        #endregion



    }
}