public UserModel GetById(int id)
{
try
{
string sql = @"SELECT * FROM `user` WHERE id=@Id;";
return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@Id", id))));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(null);
}
public UserModel GetByToken(string token)
{
try
{
string sql = @"SELECT * FROM `user` WHERE userToken=@Token;";
return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@Token", token))));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(null);
}
public UserModel GetByMobile(string mobileNum)
{
try
{
string sql = "SELECT * FROM `user` WHERE mobileNum = @MobileNum;";
return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@MobileNum", mobileNum))));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(null);
}
public UserModel GetByUserId(string userId)
{
try
{
string sql = @"SELECT * FROM `user` WHERE userId=@UserId;";
DataRow dr = MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, new MySqlParameter("@UserId", userId));
return(EntityToModel(dr));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(null);
}
public SMSCodeModel GetByMobileNum(string mobileNum, DateTime dt)
{
string sql = "SELECT * FROM `smscode` WHERE `MobileNum` = @MobileNum AND `CreateTime` > @CreateTime ORDER BY `CreateTime` DESC LIMIT 0,1;";
MySqlParameter[] parameters =
{
new MySqlParameter("@MobileNum", mobileNum),
new MySqlParameter("@CreateTime", dt)
};
DataRow dr = MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, parameters);
return(EntityToModel(dr));
}
public UserModel GetByOpenIdAndUnionId(string openId, string unionId)
{
try
{
string sql = @"SELECT * FROM `user` WHERE `openId`=@OpenId AND `unionId`=@UnionId ;";
MySqlParameter[] param =
{
new MySqlParameter("@OpenId", openId),
new MySqlParameter("@UnionId", unionId),
};
return(EntityToModel(MySqlHelper.ExecuteDataRow(ConfigHelper.ConnStr, sql, param)));
}
catch (Exception ex)
{
LogHelper.Error(ex);
}
return(null);
}