/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2016/6/7 15:34:22</remarks>
public bool Update(GambleRankEntity entity, DbTransaction trans = null)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_GambleRank_Update");
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId);
database.AddInParameter(commandWrapper, "@ManagerName", DbType.String, entity.ManagerName);
database.AddInParameter(commandWrapper, "@RankIndex", DbType.Int32, entity.RankIndex);
database.AddInParameter(commandWrapper, "@RankType", DbType.Int32, entity.RankType);
database.AddInParameter(commandWrapper, "@WinTotalMoney", DbType.Int32, entity.WinTotalMoney);
database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
entity.ManagerId = (System.Guid)database.GetParameterValue(commandWrapper, "@ManagerId");
return(Convert.ToBoolean(results));
}
/// <summary>
/// top10 奖金排行榜
/// </summary>
/// <returns>top10 奖金排行榜</returns>
public GambleRankListResponse GetTop10Rank(Guid managerId)
{
GambleRankListResponse response = new GambleRankListResponse();
try
{
List <GambleRankEntity> list = GambleRankMgr.GetRank(10);
response.Code = (int)MessageCode.Success;
if (list != null && list.Count != 0)
{
response.Data = list;
}
GambleRankEntity rank = GambleRankMgr.GetById(managerId);
if (rank != null)
{
response.MyRank = rank.RankIndex;
response.MyWinPoints = rank.WinTotalMoney;
}
}
catch (Exception ex)
{
SystemlogMgr.Error("Gamble.GetTop10Rank", ex);
response.Code = (int)MessageCode.Exception;
}
return(response);
}
/// <summary>
/// 将IDataReader的当前记录读取到GambleRankEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public GambleRankEntity LoadSingleRow(IDataReader reader)
{
var obj = new GambleRankEntity();
obj.ManagerId = (System.Guid)reader["ManagerId"];
obj.ManagerName = (System.String)reader["ManagerName"];
obj.RankIndex = (System.Int32)reader["RankIndex"];
obj.RankType = (System.Int32)reader["RankType"];
obj.WinTotalMoney = (System.Int32)reader["WinTotalMoney"];
obj.Status = (System.Int32)reader["Status"];
obj.RowTime = (System.DateTime)reader["RowTime"];
return(obj);
}
/// <summary>
/// GetById
/// </summary>
/// <param name="managerId">managerId</param>
/// <returns>GambleRankEntity</returns>
/// <remarks>2016/6/7 15:34:21</remarks>
public GambleRankEntity GetById(System.Guid managerId)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_GambleRank_GetById");
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, managerId);
GambleRankEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
/// <summary>
/// 获取我的排行
/// </summary>
/// <param name="managerId">经理ID</param>
/// <returns>我的排行</returns>
public GambleRankResponse GetMyRank(Guid managerId)
{
GambleRankResponse response = new GambleRankResponse();
try
{
GambleRankEntity rank = GambleRankMgr.GetById(managerId);
if (rank != null)
{
response.Data = rank;
}
response.Code = (int)MessageCode.Success;
}
catch (Exception ex)
{
SystemlogMgr.Error("Gamble.GetMyRank", ex);
response.Code = (int)MessageCode.Exception;
}
return(response);
}
public static bool Insert(GambleRankEntity gambleRankEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new GambleRankProvider(zoneId);
return(provider.Insert(gambleRankEntity, trans));
}
