using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FineAdmin.IRepository;
using FineAdmin.Model;
using Dapper;

namespace FineAdmin.Repository
{
    public class UserRepository : BaseRepository<UserModel>, IUserRepository
    {
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="username"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public UserModel LoginOn(string username, string password)
        {
            using (var conn = OracleHelper.OracleConnection())
            {
                var sql = "Select * from dbsys_user where 1=1";
                if (!string.IsNullOrEmpty(username))
                {
                    sql += " and Account=:Account";
                }
                if (!string.IsNullOrEmpty(password))
                {
                    sql += " and UserPassWord=:UserPassWord";
                }
                return conn.Query<UserModel>(sql, new { Account = username, UserPassWord = password }).FirstOrDefault();
            }
        }
        /// <summary>
        /// 修改密码
        /// </summary>
        /// <param name="model"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public int ModifyUserPwd(ModifyPwd model, int userId)
        {
            using (var conn = OracleHelper.OracleConnection())
            {
                var sql = "UPDATE dbsys_user SET UserPassword=:UserPassword WHERE Id=:Id AND Account=:Account AND UserPassword=:OldPassword";
                return conn.Execute(sql, new { UserPassword = model.Password, Id = userId, Account = model.UserName, OldPassword = model.OldPassword });
            }
        }
    }
}