/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2016/6/7 17:03:12</remarks>
public bool Update(GambleHostoptionrateEntity entity, DbTransaction trans = null)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_GambleHostoptionrate_Update");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx);
database.AddInParameter(commandWrapper, "@HostId", DbType.Int32, entity.HostId);
database.AddInParameter(commandWrapper, "@OptionId", DbType.Guid, entity.OptionId);
database.AddInParameter(commandWrapper, "@WinRate", DbType.Decimal, entity.WinRate);
database.AddInParameter(commandWrapper, "@GambleMoney", DbType.Int32, entity.GambleMoney);
database.AddInParameter(commandWrapper, "@AttendPeopleCount", DbType.Int32, entity.AttendPeopleCount);
database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
database.AddInParameter(commandWrapper, "@RowVersion", DbType.Binary, entity.RowVersion);
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));
}
/// <summary>
/// 将IDataReader的当前记录读取到GambleHostoptionrateEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public GambleHostoptionrateEntity LoadSingleRow2(IDataReader reader)
{
var obj = new GambleHostoptionrateEntity();
obj.Idx = (System.Int32)reader["Idx"];
obj.HostId = (System.Int32)reader["HostId"];
obj.OptionId = (System.Guid)reader["OptionId"];
obj.WinRate = (System.Decimal)reader["WinRate"];
obj.GambleMoney = (System.Int32)reader["GambleMoney"];
obj.Status = (System.Int32)reader["Status"];
obj.RowTime = (System.DateTime)reader["RowTime"];
obj.RowVersion = (System.Byte[])reader["RowVersion"];
obj.OptionContent = (System.String)reader["OptionContent"];
return(obj);
}
/// <summary>
/// GetById
/// </summary>
/// <param name="idx">idx</param>
/// <returns>GambleHostoptionrateEntity</returns>
/// <remarks>2016/6/7 17:03:12</remarks>
public GambleHostoptionrateEntity GetById(System.Int32 idx)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_GambleHostoptionrate_GetById");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx);
GambleHostoptionrateEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
public static bool Update(GambleHostoptionrateEntity gambleHostoptionrateEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new GambleHostoptionrateProvider(zoneId);
return(provider.Update(gambleHostoptionrateEntity, trans));
}
/// <summary>
/// 坐庄
/// </summary>
/// <param name="managerId">庄家ID</param>
/// <param name="rateStr">赔率字符串（以‘|’分割)</param>
/// <param name="gambleTitleId">竞猜的主题ID</param>
/// <param name="hostMoney">奖池的奖金</param>
public AuctionBuyResponse ToBeHost(Guid managerId, string rateStr, Guid gambleTitleId, int hostMoney, string zoneId = "")
{
AuctionBuyResponse mc = new AuctionBuyResponse();
//如果赔率是空 默认 2|2|2
if (string.IsNullOrEmpty(rateStr))
{
rateStr = "2|2|2";
}
try
{
#region 各种验证
//奖池不得低于5000点券
if (hostMoney < CacheFactory.AppsettingCache.GetAppSettingToInt(EnumAppsetting.MinGamblePoolMoney))
{
mc.Code = (int)MessageCode.GambleNotEnoughMoney;
return(mc);
}
//是否存在该题目
GambleTitleEntity gte = GambleTitleMgr.GetById(gambleTitleId, zoneId);
if (gte == null)
{
mc.Code = (int)MessageCode.GambleTitleNoExist;
return(mc);
}
//该题目是否允许玩家坐庄
if (managerId != LeagueConst.GambleNpcId)
{
if (gte.IsOfficial == 1)
{
mc.Code = (int)MessageCode.ThisGambleTitleIsOfficial;
return(mc);
}
}
//最多三个庄家，检查有没有超过3家
if (gte.CurrentCount >= 3)
{
mc.Code = (int)MessageCode.GambleHostsIsFull;
return(mc);
}
//竞猜还没有开始
if (gte.StartTime > DateTime.Now)
{
mc.Code = (int)MessageCode.GambleNotStart;
return(mc);
}
if (gte.StopTime < DateTime.Now)
{
mc.Code = (int)MessageCode.GambleNotStart;
return(mc);
}
//验证赔率和玩家资金
string[] rateArr = rateStr.Split('|');
List <GambleOptionEntity> optionList = GambleOptionMgr.GetByTitleId(gambleTitleId, zoneId);
if (optionList == null || optionList.Count == 0 || optionList.Count != rateArr.Length)
{
mc.Code = (int)MessageCode.GambleParamError;
return(mc);
}
decimal[] rateArrM = new decimal[rateArr.Length];
for (int i = 0, count = optionList.Count; i < count; i++)
{
rateArrM[i] = decimal.Round(Convert.ToDecimal(rateArr[i]), 2);
}
#endregion
//支付奖金
string billingId = "Gamble" + ShareUtil.GenerateComb();
GambleHostEntity ghe = new GambleHostEntity();
ghe.ManagerId = managerId;
if (managerId == LeagueConst.GambleNpcId)
{
ghe.ManagerName = "Official_Manager";
}
else
{
ghe.ManagerName = ManagerCore.Instance.GetManager(managerId).Name;
}
ghe.TitleId = gambleTitleId;
ghe.Status = 0;
ghe.RowTime = DateTime.Now;
ghe.TotalMoney = hostMoney;
ghe.HostMoney = hostMoney;
string conn = ConnectionFactory.Instance.GetConnectionString(zoneId, EnumDbType.Main);
using (var transactionManager = new TransactionManager(conn))
{
transactionManager.BeginTransaction();
if (managerId != LeagueConst.GambleNpcId)
{
MessageCode code = PayCore.Instance.GambleTrueMatch(managerId, hostMoney, billingId, transactionManager.TransactionObject);
if (code != MessageCode.Success)
{
transactionManager.Rollback();
mc.Code = (int)code;
return(mc);
}
}
bool addResult = GambleTitleMgr.AddCount(gambleTitleId, transactionManager.TransactionObject, zoneId);
if (!addResult)
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleHostsIsFull;
return(mc);
}
int idxx = 0;
if (!GambleHostMgr.InsertOnce(managerId, ghe.ManagerName, ghe.TitleId, ghe.HostMoney, ghe.TotalMoney, ghe.RowTime, ref idxx, transactionManager.TransactionObject))
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleOnlyOnce;
return(mc);
}
ghe.Idx = idxx;
GambleHostoptionrateEntity ghoe = new GambleHostoptionrateEntity();
ghoe.HostId = ghe.Idx;
ghoe.Status = 0;
ghoe.RowTime = DateTime.Now;
for (int i = 0, count = optionList.Count; i < count; i++)
{
ghoe.OptionId = optionList[i].Idx;
ghoe.WinRate = rateArrM[i];
if (!GambleHostoptionrateMgr.Insert(ghoe, transactionManager.TransactionObject, zoneId))
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleHostRateInsertError;
return(mc);
}
}
transactionManager.Commit();
}
}
catch (Exception ex)
{
SystemlogMgr.Error("Gamble.ToBeHost", ex);
mc.Code = (int)MessageCode.Exception;
return(mc);
}
mc.Data = new AuctionBuyEntity();
if (managerId != LeagueConst.GambleNpcId)
{
mc.Data.ManagerPoint = PayCore.Instance.GetPoint(managerId);
}
mc.Code = (int)MessageCode.Success;
return(mc);
}
/// <summary>
/// 玩家参与竞猜
/// </summary>
/// <param name="managerId">经理ID</param>
/// <param name="gambleMoney">下注金额</param>
/// <param name="optionRateId">庄家的哪个选项的竞猜</param>
/// <returns>是否参与成功</returns>
public AuctionBuyResponse AttendGamble(Guid managerId, int gambleMoney, int optionRateId)
{
#region 各种验证
NbManagerEntity manager = ManagerCore.Instance.GetManager(managerId);
AuctionBuyResponse mc = new AuctionBuyResponse();
if (gambleMoney < 1)
{
mc.Code = (int)MessageCode.GambleTooPoor;
return(mc);
}
if (manager == null)
{
mc.Code = (int)MessageCode.LoginNoUser;
return(mc);
}
//是否存在该题目
GambleTitleEntity gte = GambleTitleMgr.GetByOptionRateId(optionRateId);
if (gte == null)
{
mc.Code = (int)MessageCode.GambleTitleNoExist;
return(mc);
}
//竞猜还没有开始
if (gte.StartTime > DateTime.Now)
{
mc.Code = (int)MessageCode.GambleNotStart;
return(mc);
}
if (gte.StopTime < DateTime.Now)
{
mc.Code = (int)MessageCode.GambleNotStart;
return(mc);
}
//检查奖金是否够支付
GambleHostoptionrateEntity ore = GambleHostoptionrateMgr.GetById(optionRateId);
if (ore == null || ore.Idx == 0)
{
mc.Code = (int)MessageCode.Exception;
return(mc);
}
GambleHostEntity he = GambleHostMgr.GetById(ore.HostId);
if (he == null || he.Idx == 0)
{
mc.Code = (int)MessageCode.Exception;
return(mc);
}
decimal needMoney = (decimal)(ore.GambleMoney + gambleMoney) * ore.WinRate;
if (needMoney > he.TotalMoney)
{
mc.Code = (int)MessageCode.GambleNeedMoreTotalMoney;
return(mc);
}
//不能竞猜自己发起的主题
if (managerId == he.ManagerId)
{
mc.Code = (int)MessageCode.GambleCannotGambleSelf;
return(mc);
}
//压住金额20钻石：任意等级 100钻石：需VIP3 300钻石：需VIP5
mc.Code = (int)MessageCode.NbFunctionNotOpen;
switch (manager.Level)
{
case 0:
case 1:
case 2:
if (gambleMoney != 20)
{
return(mc);
}
break;
case 3:
case 4:
if (gambleMoney != 20 || gambleMoney != 100)
{
return(mc);
}
break;
default:
if (gambleMoney != 20 || gambleMoney != 100 || gambleMoney != 300)
{
return(mc);
}
break;
}
//支付金额
string billingId = "Gamble_" + ShareUtil.GenerateComb().ToString();
GambleDetailEntity de = new GambleDetailEntity();
de.ManagerId = managerId;
de.ManagerName = manager.Name;
de.GambleMoney = gambleMoney;
de.HostOptionId = ore.Idx;
de.ResultMoney = 0;
de.Status = 0;
de.RowTime = DateTime.Now;
try
{
using (var transactionManager = new TransactionManager(Dal.ConnectionFactory.Instance.GetDefault()))
{
transactionManager.BeginTransaction();
ore.GambleMoney += gambleMoney;
ore.AttendPeopleCount += 1;
he.TotalMoney += gambleMoney;
he.AttendPeopleCount += 1;
if (!GambleHostMgr.Update(he, transactionManager.TransactionObject))
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleTooManyPeopleIsGambling;
return(mc);
}
if (!GambleHostoptionrateMgr.Update(ore, transactionManager.TransactionObject))
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleTooManyPeopleIsGambling;
return(mc);
}
if (!GambleDetailMgr.Insert(de, transactionManager.TransactionObject))
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GambleTooManyPeopleIsGambling;
return(mc);
}
MessageCode code = PayCore.Instance.GambleTrueMatch(managerId, gambleMoney, billingId, transactionManager.TransactionObject);
if (code != MessageCode.Success)
{
transactionManager.Rollback();
mc.Code = (int)MessageCode.GamblePayError;
return(mc);
}
transactionManager.Commit();
}
}
catch (Exception ex)
{
SystemlogMgr.Error("Gamble.AttendGamble", ex);
mc.Code = (int)MessageCode.Exception;
}
#endregion
mc.Data = new AuctionBuyEntity();
mc.Data.ManagerPoint = PayCore.Instance.GetPoint(managerId);
return(mc);
}
