/// <summary>
/// 获得数据列表
/// </summary>
public IList <Wuyiju.Model.UserRank> GetList(Wuyiju.Model.UserRank.Query filter)
{
StringBuilder sql = new StringBuilder(@"select * from ec_user_rank where 1 = 1 ");
DynamicParameters param = new DynamicParameters();
if (filter != null)
{
param.AddDynamicParams(filter);
}
return(db.GetList <Wuyiju.Model.UserRank>(sql, param));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public IList <Wuyiju.Model.UserRank> GetList(Wuyiju.Model.UserRank.Query filter, int?limit = null)
{
StringBuilder sql = new StringBuilder(@"select * from ec_user_rank where 1 = 1 ");
if (limit != null)
{
sql.Append(" limit @rows ");
}
DynamicParameters param = new DynamicParameters();
if (filter != null)
{
param.AddDynamicParams(filter);
}
if (limit != null)
{
param.Add("rows", limit);
}
return(db.GetList <Wuyiju.Model.UserRank>(sql, param));
}
public void UpdateUserRank(string username, decimal money)
{
try
{
Wuyiju.Model.UserRank.Query query = new Wuyiju.Model.UserRank.Query();
var svr = unity.GetInstance <IUserDAL>();
var ranklist = dao.GetList(query);
if (ranklist != null)
{
foreach (var rank in ranklist)
{
if (rank.Min_Points <= money && money < rank.Max_Points)
{
var user = svr.GetByUsername(username);
user.Rank_Id = rank.Rank_Id;
svr.Update(user);
}
}
}
}
catch {
throw new ApplicationException("更新错误");
}
}
/// <summary>
/// 获得前几行数据
/// </summary>
public IList <Wuyiju.Model.UserRank> GetList(Wuyiju.Model.UserRank.Query query, int?limit = null)
{
return(dao.GetList(query, limit));
}
/// <summary>
/// 获得数据列表
/// </summary>
public IList <Wuyiju.Model.UserRank> GetList(Wuyiju.Model.UserRank.Query query)
{
return(dao.GetList(query));
}
