Hotel/Core/SM/Dal/UserDal.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Common;
using Common.Data;
using Common.Data.SqlServer;
using Common.Provider;
using Core.SM.Model;
namespace Core.SM.Dal
{
    public class UserDal : BaseRepository<User>
    {
        public static UserDal Instance
        {
            get { return SingletonProvider<UserDal>.Instance; }
        }



        public override int Update(User o)
        {
            return DbUtils.Update(o, new[] { "keyid", "password", "passwordupddate", "passwordupdby" });
        }

        public int UpdatePassword(int userId, string password)
        {
            string sql = "update SM_USERS set Password=@password where KeyId=@KeyId";
            return DbUtils.ExecuteNonQuery(sql, new { Password = password, KeyId = userId });
        }

        /// <summary>
        /// 更新密碼登入錯誤次數
        /// </summary>
        /// <param name="userId">用戶KeyId</param>
        /// <returns></returns>
        public int UpdateFailCount(int userId)
        {
            string sql = "update SM_USERS set FailCount=FailCount+1 where KeyId=@KeyId";
            return DbUtils.ExecuteNonQuery(sql, new { KeyId = userId });
        }
        
        
        
        
            /// <summary>
            /// 取得指定用戶角色
            /// </summary>
            /// <param name="userId">用戶KeyID</param>
            /// <returns></returns>

        public IEnumerable<Role> GetRolesBy(int userId)
        {
            string s = "select RoleId from SM_USER_ROLES where UserId=@UserId";
            DataTable dt = SqlEasy.ExecuteDataTable(s, new SqlParameter("@UserId", userId));