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 });
|
}
|
}
|
}
|
}
|
