示例#1
0
        /// <summary>
        /// 与数据库对比用户输入的用户名及密码,返回登录结果
        /// </summary>
        /// <param name="userName">用户输入的用户名</param>
        /// <param name="password">用户输入的密码</param>
        /// <returns>表示登录结果的枚举值</returns>
        public LoginResult Login(string userName, string password, out int userId)
        {
            var user = DalInstance.QuerySingle(
                "Account=@account AND IsDelete=0",
                null,
                new Dictionary <string, object> {
                { "@account", userName }
            });

            userId = 0;
            if (user == null)
            {
                return(LoginResult.NotExists);
            }

            userId = user.Id;

            var encrytPwd = password.GetMd5();

            if (encrytPwd == user.Password)
            {
                return(LoginResult.Success);
            }

            return(LoginResult.PasswordError);
        }
示例#2
0
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="departId"></param>
        /// <returns></returns>
        public int CountDepartPerson(int departId)
        {
            var list = DalInstance.QueryList("IsDelete=0 AND DepartmentId=" + departId, new[] { "Id" });

            return(list.Count());
        }