//根据id获取数据库实体对象
public Hashtable GetEntity(string Id)
{
string sql = selectSql + " where bookguid=@bookguid";
Hashtable hs = DapperHelper.QuerySingle(sql, new { bookguid = Id });
return(hs);
}
/// <summary>
/// 登录数据访问层方法
/// </summary>
/// <param name="phone"></param>
/// <param name="pass"></param>
/// <returns></returns>
public UserInfo UserInfoLgoin(string phone, string pass)
{
string sql = $@"select u.UserId,u.UserName,u.UserPhone from UserInfo u where u.UserPhone=@Phone and u.UserPass=@Pass and Status=1;";
UserInfo user = new UserInfo();
user = DapperHelper <UserInfo> .QuerySingle(sql, new { Phone = phone, Pass = pass });
return(user);
}
/// <summary>
/// 获取盐
/// </summary>
/// <param name="UserPhone"></param>
/// <returns></returns>
public string GetUserInfoSalt(string UserPhone)
{
string sql = $" select UserSalt from UserInfo where UserPhone=@UserPhone and Status=1 ";
return(DapperHelper <string> .QuerySingle(sql, new { UserPhone = UserPhone }));
}