/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2016/1/11 15:07:26</remarks>
public bool Update(LadderManagerhistoryEntity entity, DbTransaction trans = null)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_LadderManagerhistory_Update");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx);
database.AddInParameter(commandWrapper, "@Season", DbType.Int32, entity.Season);
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId);
database.AddInParameter(commandWrapper, "@Rank", DbType.Int32, entity.Rank);
database.AddInParameter(commandWrapper, "@Score", DbType.Int32, entity.Score);
database.AddInParameter(commandWrapper, "@PrizeItems", DbType.AnsiString, entity.PrizeItems);
database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
database.AddInParameter(commandWrapper, "@UpdateTime", DbType.DateTime, entity.UpdateTime);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx");
return(Convert.ToBoolean(results));
}
public void SendPrize(LadderManagerhistoryEntity manager, int seasonStatus, ref List <MailBuilder> mails)
{
try
{
if (string.IsNullOrEmpty(manager.PrizeItems))
{
manager.PrizeItems = "";
MailBuilder mail = null;
if (seasonStatus == 1)
{
//var lotterys = CacheFactory.LadderCache.GetRankPrize(manager.Rank);
//mail = new MailBuilder(manager, lotterys);
//foreach (var entity in lotterys)
//{
// manager.PrizeItems += string.Format("{0},{1},{2}|", entity.PrizeItemCode,
// entity.Strength, entity.IsBinding ? 1 : 0);
//}
int packId = CacheFactory.LadderCache.GetRankPrizeNew(manager.Rank);
if (packId <= 0)
{
SystemlogMgr.Info("LadderSendPrize", "no packid for rank:" + manager.Rank);
return;
}
mail = new MailBuilder(manager);
var code = MallCore.Instance.BuildPackMail(packId, ref mail);
if (code != MessageCode.Success)
{
SystemlogMgr.Info("LadderSendPrize", "build pack fail rank:" + manager.Rank + ",packId:" + packId);
return;
}
manager.PrizeItems = "pack:" + packId;
}
else
{
int packId = CacheFactory.LadderCache.GetRankPrizeSevenNew(manager.Rank);
if (packId <= 0)
{
SystemlogMgr.Info("LadderSendPrize", "no packid for rank:" + manager.Rank);
return;
}
mail = new MailBuilder(manager);
var code = MallCore.Instance.BuildPackMail(packId, ref mail);
if (code != MessageCode.Success)
{
SystemlogMgr.Info("LadderSendPrize", "build pack fail rank:" + manager.Rank + ",packId:" + packId);
return;
}
manager.PrizeItems = "pack:" + packId;
}
manager.PrizeItems = manager.PrizeItems.TrimEnd('|');
manager.UpdateTime = DateTime.Now;
mails.Add(mail);
}
}
catch (Exception ex)
{
SystemlogMgr.Error("LadderSendPrize", ex);
}
}
/// <summary>
/// 天梯排名奖励
/// </summary>
/// <param name="managerhistory"></param>
public MailBuilder(LadderManagerhistoryEntity managerhistory)
: this()
{
//Period(第几届)|Rank(排名)
string content = string.Format("P,{0}|R,{1}", managerhistory.Season, managerhistory.Rank);
Builder(managerhistory.ManagerId, EnumMailType.LadderPrize, content);
}
/// <summary>
/// 将IDataReader的当前记录读取到LadderManagerhistoryEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public LadderManagerhistoryEntity LoadSingleRow(IDataReader reader)
{
var obj = new LadderManagerhistoryEntity();
obj.Idx = (System.Int32)reader["Idx"];
obj.Season = (System.Int32)reader["Season"];
obj.ManagerId = (System.Guid)reader["ManagerId"];
obj.Rank = (System.Int32)reader["Rank"];
obj.Score = (System.Int32)reader["Score"];
obj.PrizeItems = (System.String)reader["PrizeItems"];
obj.Status = (System.Int32)reader["Status"];
obj.RowTime = (System.DateTime)reader["RowTime"];
obj.UpdateTime = (System.DateTime)reader["UpdateTime"];
return(obj);
}
/// <summary>
/// GetById
/// </summary>
/// <param name="idx">idx</param>
/// <returns>LadderManagerhistoryEntity</returns>
/// <remarks>2016/1/11 15:07:26</remarks>
public LadderManagerhistoryEntity GetById(System.Int32 idx)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_LadderManagerhistory_GetById");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx);
LadderManagerhistoryEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
public static bool Update(LadderManagerhistoryEntity ladderManagerhistoryEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new LadderManagerhistoryProvider(zoneId);
return(provider.Update(ladderManagerhistoryEntity, trans));
}
