private bool UpdateCurrentAwardItemList(RouletteAwardItem[] items, CustomerMySqlTransaction trans)
{
string sqlDeleteText = "delete from currentrouletteawarditemlist;";
MySqlCommand mycmd = trans.CreateCommand();
mycmd.CommandText = sqlDeleteText;
mycmd.ExecuteNonQuery();
mycmd.Dispose();
for (int i = 0; i < items.Length; i++)
{
var item = items[i];
string sqlInsertText = "insert into currentrouletteawarditemlist " +
" (`Index`, `AwarditemID`) " +
" values (@Index, @AwarditemID)";
mycmd = trans.CreateCommand();
mycmd.CommandText = sqlInsertText;
mycmd.Parameters.AddWithValue("@Index", i);
mycmd.Parameters.AddWithValue("@AwarditemID", item.ID);
mycmd.ExecuteNonQuery();
mycmd.Dispose();
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="userID"></param>
/// <param name="isJoinIn">true表示投入；false表示提取</param>
/// <param name="stoneStackCount"></param>
/// <param name="myTrans"></param>
/// <returns></returns>
public bool AddNewStackChangeRecord(StoneFactoryStackChangeRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into stonefactorystackchangerecord " +
"(`UserID`,`JoinStoneStackCount`,`Time`) " +
" values (@UserID,@JoinStoneStackCount,@Time) ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@JoinStoneStackCount", record.JoinStoneStackCount);
mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime());
mycmd.ExecuteNonQuery();
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
return(true);
}
public bool AddAgentAwardRecord(AgentAwardRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "insert into agentawardrecord " +
" (`AgentID`, `AgentUserName`, `PlayerID`, `PlayerUserName`, `PlayerInchargeRMB`, `AgentAwardRMB`, `PlayerInchargeContent`, `Time`) " +
" values (@AgentID, @AgentUserName, @PlayerID, @PlayerUserName, @PlayerInchargeRMB, @AgentAwardRMB, @PlayerInchargeContent, @Time)";
mycmd = myTrans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@AgentID", record.AgentID);
mycmd.Parameters.AddWithValue("@AgentUserName", DESEncrypt.EncryptDES(record.AgentUserName));
mycmd.Parameters.AddWithValue("@PlayerID", record.PlayerID);
mycmd.Parameters.AddWithValue("@PlayerUserName", DESEncrypt.EncryptDES(record.PlayerUserName));
mycmd.Parameters.AddWithValue("@PlayerInchargeRMB", record.PlayerInchargeRMB);
mycmd.Parameters.AddWithValue("@AgentAwardRMB", record.AgentAwardRMB);
mycmd.Parameters.AddWithValue("@PlayerInchargeContent", record.PlayerInchargeContent);
mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool UpdatePlayerGravelRequsetRecords(PlayerGravelRequsetRecordInfo[] records, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
StringBuilder builder = new StringBuilder();
for (int i = 0; i < records.Length; i++)
{
string sqlText = "UPDATE playergravelrequsetrecordinfo set `IsResponsed`=@IsResponsed" + i + ",`ResponseDate`=@ResponseDate" + i + ",`Gravel`=@Gravel" + i + " where `id`=@ID" + i + "; ";
builder.Append(sqlText);
mycmd.Parameters.AddWithValue("@IsResponsed" + i, records[i].IsResponsed);
mycmd.Parameters.AddWithValue("@ResponseDate" + i, records[i].ResponseDate);
mycmd.Parameters.AddWithValue("@Gravel" + i, records[i].Gravel);
mycmd.Parameters.AddWithValue("@ID" + i, records[i].ID);
}
mycmd.CommandText = builder.ToString();
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveFinalMineTradeRecord(MinesBuyRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string cmdTextA = "insert into minesbuyrecord " +
"(`OrderNumber`, `UserID`, `SpendRMB`, `GainMinesCount`,`GainStonesReserves`, `CreateTime`, `PayTime`) values " +
" (@OrderNumber, @UserID, @SpendRMB, @GainMinesCount, @GainStonesReserves, @CreateTime, @PayTime); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@SpendRMB", record.SpendRMB);
mycmd.Parameters.AddWithValue("@GainMinesCount", record.GainMinesCount);
mycmd.Parameters.AddWithValue("@GainStonesReserves", record.GainStonesReserves);
mycmd.Parameters.AddWithValue("@CreateTime", record.CreateTime);
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveWaitToAwardExpRecord(WaitToReferAwardRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into waittoawardexprecord " +
"(`ReferrerUserName`,`NewRegisterUserNme`,`AwardLevel`) " +
" values (@ReferrerUserName, @NewRegisterUserNme,@AwardLevel)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@ReferrerUserName", DESEncrypt.EncryptDES(record.ReferrerUserName));
mycmd.Parameters.AddWithValue("@NewRegisterUserNme", DESEncrypt.EncryptDES(record.NewRegisterUserName));
mycmd.Parameters.AddWithValue("@AwardLevel", record.AwardLevel);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddExpChangeRecord(ExpChangeRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string cmdTextA = "insert into expchangerecord " +
"(`UserID`, `AddExp`, `NewExp`, `Time`, `OperContent` ) " +
" values " +
"(@UserID, @AddExp, @NewExp, @Time, @OperContent); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@AddExp", record.AddExp);
mycmd.Parameters.AddWithValue("@NewExp", record.NewExp);
mycmd.Parameters.AddWithValue("@Time", record.Time.ToDateTime());
mycmd.Parameters.AddWithValue("@OperContent", record.OperContent);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool SetPlayerGravelRequsetRecordInfoIsGoted(PlayerGravelRequsetRecordInfo record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "update playergravelrequsetrecordinfo set `IsGoted`=@IsGoted where `id`=@ID; ";
mycmd.Parameters.AddWithValue("@IsGoted", record.IsGoted);
mycmd.Parameters.AddWithValue("@ID", record.ID);
mycmd.CommandText = sqlText;
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddPlayerBuyDiamondShoppingItemRecord(PlayerBuyDiamondShoppingItemRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into playerbuydiamondshoppingitemrecord " +
"(`OrderNumber`,`UserID`,`DiamondShoppingItemID`,`SendAddress`,`BuyTime`,`ShoppingState`) " +
" values (@OrderNumber,@UserID,@DiamondShoppingItemID,@SendAddress,@BuyTime,@ShoppingState )";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@DiamondShoppingItemID", record.DiamondShoppingItemID);
mycmd.Parameters.AddWithValue("@SendAddress", DESEncrypt.EncryptDES(record.SendAddress));
mycmd.Parameters.AddWithValue("@BuyTime", record.BuyTime.ToDateTime());
mycmd.Parameters.AddWithValue("@ShoppingState", (int)record.ShoppingState);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool LockOrder(LockSellStonesOrder lockOrder, CustomerMySqlTransaction trans)
{
//1.修改订单状态；
//2.添加锁定信息记录。
MySqlCommand mycmd = null;
try
{
string textDel = "delete from locksellstonesorder where OrderNumber = @OrderNumber;";
string textA = "update sellstonesorder set OrderState = @OrderState where OrderNumber = @OrderNumber;";
string textB = "insert into locksellstonesorder " +
"(`OrderNumber`, `PayUrl`, `LockedByUserName`, `LockedTime` ) " +
" values " +
"(@OrderNumber, @PayUrl, @LockedByUserName, @LockedTime); ";
mycmd = trans.CreateCommand();
mycmd.CommandText = textDel + textA + textB;
mycmd.Parameters.AddWithValue("@OrderState", (int)SellOrderState.Lock);
mycmd.Parameters.AddWithValue("@OrderNumber", lockOrder.StonesOrder.OrderNumber);
mycmd.Parameters.AddWithValue("@PayUrl", lockOrder.PayUrl);
mycmd.Parameters.AddWithValue("@LockedByUserName", DESEncrypt.EncryptDES(lockOrder.LockedByUserName));
mycmd.Parameters.AddWithValue("@LockedTime", lockOrder.LockedTime);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool PayOrder(BuyStonesOrder buyOrder, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string textC = "insert into buystonesrecord " +
"(`OrderNumber`, `BuyerUserName`, `BuyTime`, `AwardGoldCoin` ) " +
" values " +
"(@OrderNumber, @BuyerUserName, @BuyTime, @AwardGoldCoin); ";
mycmd = trans.CreateCommand();
mycmd.CommandText = textC;
mycmd.Parameters.AddWithValue("@OrderNumber", buyOrder.StonesOrder.OrderNumber);
string encryptUserName = DESEncrypt.EncryptDES(buyOrder.BuyerUserName);
mycmd.Parameters.AddWithValue("@BuyerUserName", encryptUserName);
mycmd.Parameters.AddWithValue("@BuyTime", buyOrder.BuyTime);
mycmd.Parameters.AddWithValue("@AwardGoldCoin", buyOrder.AwardGoldCoin);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool CancelSellOrder(SellStonesOrder order, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string cmdTextA = "delete from sellstonesorder where OrderNumber = @OrderNumber;";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SavePlayerStoneFactoryAccountInfo(PlayerStoneFactoryAccountInfo account, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "update playerstonefactoryaccountinfo set `FactoryIsOpening`=@FactoryIsOpening,`FactoryLiveDays`=@FactoryLiveDays,`Food`=@Food,`LastFeedSlaveTime`=@LastFeedSlaveTime,`LastDayValidStoneStack`=@LastDayValidStoneStack,`FreezingSlaveGroupCount`=@FreezingSlaveGroupCount,`EnableSlavesGroupCount`=@EnableSlavesGroupCount,`AutoFeedSumTimes`=@AutoFeedSumTimes where `ID`=@ID ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@ID", account.ID);
mycmd.Parameters.AddWithValue("@FactoryIsOpening", account.FactoryIsOpening);
mycmd.Parameters.AddWithValue("@FactoryLiveDays", account.FactoryLiveDays);
mycmd.Parameters.AddWithValue("@Food", account.Food);
mycmd.Parameters.AddWithValue("@LastFeedSlaveTime", account.LastFeedSlaveTime == null? DBNull.Value: (object)account.LastFeedSlaveTime.ToDateTime());
mycmd.Parameters.AddWithValue("@LastDayValidStoneStack", account.LastDayValidStoneStack);
mycmd.Parameters.AddWithValue("@FreezingSlaveGroupCount", account.FreezingSlaveGroupCount);
mycmd.Parameters.AddWithValue("@EnableSlavesGroupCount", account.EnableSlavesGroupCount);
mycmd.Parameters.AddWithValue("@AutoFeedSumTimes", account.AutoFeedSumTimes);
mycmd.ExecuteNonQuery();
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
return(true);
}
//public bool AddMiners(int userID, int minersCount, CustomerMySqlTransaction myTrans)
//{
// StoneFactoryOneGroupSlave slave = new StoneFactoryOneGroupSlave()
// {
// UserID = userID,
// ChargeTime = new MyDateTime(),
// JoinInSlaveCount = minersCount,
// isLive = true,
// LifeDays = 2,
// LiveSlaveCount = minersCount
// };
// return false;
//}
//public bool AddFoods(int userID, int foodsCount, CustomerMySqlTransaction myTrans)
//{
// //直接修改字段值
// return false;
//}
public bool AddProfitRMBChangedRecord(StoneFactoryProfitRMBChangedRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into stonefactoryprofitrmbchangedrecord " +
"(`UserID`,`OperRMB`,`ValidStoneCount`,`ProfitType`,`OperTime`) " +
" values (@UserID,@OperRMB,@ValidStoneCount,@ProfitType,@OperTime) ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@OperRMB", record.OperRMB);
mycmd.Parameters.AddWithValue("@ValidStoneCount", record.ValidStoneCount);
mycmd.Parameters.AddWithValue("@ProfitType", (int)record.ProfitType);
mycmd.Parameters.AddWithValue("@OperTime", record.OperTime.ToDateTime());
mycmd.ExecuteNonQuery();
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
return(true);
}
public bool SaveAwardReferrerConfig(List <AwardReferrerConfig> ListConfig, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = trans.CreateCommand();
mycmd.CommandText = "delete from awardreferrerconfig; ";
mycmd.ExecuteNonQuery();
mycmd.CommandText = "insert into awardreferrerconfig (ReferLevel, AwardReferrerExp, AwardReferrerGoldCoin, AwardReferrerMines, AwardReferrerMiners, AwardReferrerStones, AwardReferrerDiamond ) values " +
" (@ReferLevel, @AwardReferrerExp, @AwardReferrerGoldCoin, @AwardReferrerMines, @AwardReferrerMiners, @AwardReferrerStones, @AwardReferrerDiamond )";
mycmd.Parameters.Add("@ReferLevel", MySqlDbType.Int32);
mycmd.Parameters.AddWithValue("@AwardReferrerExp", MySqlDbType.Float);
mycmd.Parameters.AddWithValue("@AwardReferrerGoldCoin", MySqlDbType.Float);
mycmd.Parameters.AddWithValue("@AwardReferrerMines", MySqlDbType.Float);
mycmd.Parameters.AddWithValue("@AwardReferrerMiners", MySqlDbType.Int32);
mycmd.Parameters.AddWithValue("@AwardReferrerStones", MySqlDbType.Float);
mycmd.Parameters.AddWithValue("@AwardReferrerDiamond", MySqlDbType.Float);
foreach (var config in ListConfig)
{
mycmd.Parameters["@ReferLevel"].Value = config.ReferLevel;
mycmd.Parameters["@AwardReferrerExp"].Value = config.AwardReferrerExp;
mycmd.Parameters["@AwardReferrerGoldCoin"].Value = config.AwardReferrerGoldCoin;
mycmd.Parameters["@AwardReferrerMines"].Value = config.AwardReferrerMines;
mycmd.Parameters["@AwardReferrerMiners"].Value = config.AwardReferrerMiners;
mycmd.Parameters["@AwardReferrerStones"].Value = config.AwardReferrerStones;
mycmd.Parameters["@AwardReferrerDiamond"].Value = config.AwardReferrerDiamond;
mycmd.ExecuteNonQuery();
}
//mycmd.Dispose();
return(true);
}
public bool AddBuyMinerRecord(MinersBuyRecord record, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string cmdTextA = "insert into minersbuyrecord " +
"(`UserID`, `SpendGoldCoin`, `GainMinersCount`, `Time`) values " +
" (@UserID, @SpendGoldCoin, @GainMinersCount, @Time); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@SpendGoldCoin", record.SpendGoldCoin);
mycmd.Parameters.AddWithValue("@GainMinersCount", record.GainMinersCount);
mycmd.Parameters.AddWithValue("@Time", record.Time);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool SaveGameConfig(GameConfig config, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = trans.CreateCommand();
string cmdText = "delete from gameconfig; " +
"insert into gameconfig (`Yuan_RMB`, `RMB_GoldCoin`, `RMB_Mine`, `GoldCoin_Miner`, `Stones_RMB`, `Diamonds_RMB`, `StoneBuyerAwardGoldCoinMultiple`, `OutputStonesPerHour`, `TempStoneOutputValidHour`, `MineReservesIsRandom`, `StonesReservesPerMines`, `MinStonesReservesPerMine`, `MaxStonesReservesPerMine`, `ExchangeExpensePercent`, `ExchangeExpenseMinNumber`, `UserMaxHaveMinersCount`, `BuyOrderLockTimeMinutes`, `CanExchangeMinExp`, `CanDiscountMinExp`, `Discount`) values " +
" (@Yuan_RMB, @RMB_GoldCoin, @RMB_Mine, @GoldCoin_Miner, @Stones_RMB, @Diamonds_RMB, @StoneBuyerAwardGoldCoinMultiple, @OutputStonesPerHour, @TempStoneOutputValidHour, @MineReservesIsRandom, @StonesReservesPerMines, @MinStonesReservesPerMine, @MaxStonesReservesPerMine, @ExchangeExpensePercent, @ExchangeExpenseMinNumber, @UserMaxHaveMinersCount, @BuyOrderLockTimeMinutes, @CanExchangeMinExp, @CanDiscountMinExp, @Discount)";
mycmd.CommandText = cmdText;
mycmd.Parameters.AddWithValue("@Yuan_RMB", config.Yuan_RMB);
mycmd.Parameters.AddWithValue("@RMB_GoldCoin", config.RMB_GoldCoin);
mycmd.Parameters.AddWithValue("@RMB_Mine", config.RMB_Mine);
mycmd.Parameters.AddWithValue("@GoldCoin_Miner", config.GoldCoin_Miner);
mycmd.Parameters.AddWithValue("@Stones_RMB", config.Stones_RMB);
mycmd.Parameters.AddWithValue("@Diamonds_RMB", config.Diamonds_RMB);
mycmd.Parameters.AddWithValue("@StoneBuyerAwardGoldCoinMultiple", config.StoneBuyerAwardGoldCoinMultiple);
mycmd.Parameters.AddWithValue("@OutputStonesPerHour", config.OutputStonesPerHour);
mycmd.Parameters.AddWithValue("@TempStoneOutputValidHour", config.TempStoneOutputValidHour);
mycmd.Parameters.AddWithValue("@MineReservesIsRandom", config.MineReservesIsRandom);
mycmd.Parameters.AddWithValue("@StonesReservesPerMines", config.StonesReservesPerMines);
mycmd.Parameters.AddWithValue("@MinStonesReservesPerMine", config.MinStonesReservesPerMine_VIPPlayer);
mycmd.Parameters.AddWithValue("@MaxStonesReservesPerMine", config.MaxStonesReservesPerMine_VIPPlayer);
mycmd.Parameters.AddWithValue("@ExchangeExpensePercent", config.ExchangeExpensePercent);
mycmd.Parameters.AddWithValue("@ExchangeExpenseMinNumber", config.ExchangeExpenseMinNumber);
mycmd.Parameters.AddWithValue("@UserMaxHaveMinersCount", config.UserMaxHaveMinersCount);
mycmd.Parameters.AddWithValue("@BuyOrderLockTimeMinutes", config.BuyOrderLockTimeMinutes);
mycmd.Parameters.AddWithValue("@CanExchangeMinExp", config.CanExchangeMinExp);
mycmd.Parameters.AddWithValue("@CanDiscountMinExp", config.CanDiscountMinExp);
mycmd.Parameters.AddWithValue("@Discount", config.Discount);
mycmd.ExecuteNonQuery();
//mycmd.Dispose();
return(true);
}
public bool AddUserRemoteHandleServiceRecord(UserRemoteHandleServiceRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into userremotehandleservicerecord " +
"(`UserID`, `ServiceTime`,`WorkerName`,`ServiceContent`,`AdminUserName`) " +
" values (@UserID, @ServiceTime, @WorkerName,@ServiceContent,@AdminUserName)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@ServiceTime", record.ServiceTime);
mycmd.Parameters.AddWithValue("@WorkerName", DESEncrypt.EncryptDES(record.WorkerName));
mycmd.Parameters.AddWithValue("@ServiceContent", DESEncrypt.EncryptDES(record.ServiceContent));
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddAgentUser(AgentUserInfo info, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string sqlText = "insert into agentuserinfo " +
" (`UserID`,`TotalAwardRMB`,`InvitationURL`) " +
" values (@UserID,@TotalAwardRMB,@InvitationURL)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", info.Player.SimpleInfo.UserID);
mycmd.Parameters.AddWithValue("@TotalAwardRMB", info.TotalAwardRMB);
mycmd.Parameters.AddWithValue("@InvitationURL", info.InvitationURL);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveUserRemoteServerBuyRecord(UserRemoteServerBuyRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into userremoteserverbuyrecord " +
"(`UserID`, `ServerType`,`PayMoneyYuan`,`OrderNumber`,`GetShoppingCredits`,`BuyRemoteServerTime`) " +
" values (@UserID, @ServerType, @PayMoneyYuan,@OrderNumber,@GetShoppingCredits,@BuyRemoteServerTime)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@ServerType", (int)record.ServerType);
mycmd.Parameters.AddWithValue("@PayMoneyYuan", record.PayMoneyYuan);
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@GetShoppingCredits", record.GetShoppingCredits);
mycmd.Parameters.AddWithValue("@BuyRemoteServerTime", record.BuyRemoteServerTime);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddPlayerBuyVirtualShoppingItemRecord(PlayerBuyVirtualShoppingItemRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into playerbuyvirtualshoppingitemrecord " +
"(`OrderNumber`,`UserID`,`VirtualShoppingItemID`,`BuyTime`) " +
" values (@OrderNumber,@UserID,@VirtualShoppingItemID,@BuyTime )";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@VirtualShoppingItemID", record.VirtualShoppingItemID);
mycmd.Parameters.AddWithValue("@BuyTime", record.BuyTime.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool UpdateRaiderRoundMetaDataInfo(RaiderRoundMetaDataInfo roundInfo, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "UPDATE raiderroundmetadatainfo " +
" set `State` = @State, `StartTime` = @StartTime, `AwardPoolSumStones` = @AwardPoolSumStones, `JoinedPlayerCount`=@JoinedPlayerCount, `WinnerUserName`=@WinnerUserName,`WinStones`=@WinStones,`EndTime`=@EndTime where `id` = @id ; ";
mycmd = myTrans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@State", (int)roundInfo.State);
mycmd.Parameters.AddWithValue("@StartTime", roundInfo.StartTime == null ? DBNull.Value : (object)roundInfo.StartTime.ToDateTime());
mycmd.Parameters.AddWithValue("@AwardPoolSumStones", roundInfo.AwardPoolSumStones);
mycmd.Parameters.AddWithValue("@JoinedPlayerCount", roundInfo.JoinedPlayerCount);
mycmd.Parameters.AddWithValue("@WinnerUserName", string.IsNullOrEmpty(roundInfo.WinnerUserName) ? DBNull.Value : (object)DESEncrypt.EncryptDES(roundInfo.WinnerUserName));
mycmd.Parameters.AddWithValue("@WinStones", roundInfo.WinStones);
mycmd.Parameters.AddWithValue("@EndTime", roundInfo.EndTime == null ? DBNull.Value : (object)roundInfo.EndTime.ToDateTime());
mycmd.Parameters.AddWithValue("@id", roundInfo.ID);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool ConfirmWithdrawRMB(WithdrawRMBRecord record, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "update withdrawrmbrecord set " +
"`RMBWithdrawState` = @RMBWithdrawState, `AdminUserName` = @AdminUserName, `AlipayOrderNumber` = @AlipayOrderNumber, `PayTime` = @PayTime, `Message` = @Message " +
" where id = @id ";
mycmd = trans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@RMBWithdrawState", (int)record.State);
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
mycmd.Parameters.AddWithValue("@AlipayOrderNumber", record.AlipayOrderNumber);
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
mycmd.Parameters.AddWithValue("@Message", record.Message);
mycmd.Parameters.AddWithValue("@id", record.id);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveFinalGoldCoinRechargeRecord(GoldCoinRechargeRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string cmdTextA = "insert into goldcoinrechargerecord " +
"(`OrderNumber`, `UserID`, `SpendRMB`, `GainGoldCoin`, `CreateTime`, `PayTime`) values " +
" (@OrderNumber, @UserID, @SpendRMB, @GainGoldCoin, @CreateTime, @PayTime); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@SpendRMB", record.SpendRMB);
mycmd.Parameters.AddWithValue("@GainGoldCoin", record.GainGoldCoin);
mycmd.Parameters.AddWithValue("@CreateTime", record.CreateTime);
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveAlipayRechargeRecord(AlipayRechargeRecord alipayRecord, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into alipayrechargerecord " +
"(`out_trade_no`, `trade_type`,`alipay_trade_no`,`user_name`,`buyer_email`,`total_fee`,`value_rmb`,`pay_time`) " +
" values (@out_trade_no, @trade_type, @alipay_trade_no,@user_name,@buyer_email,@total_fee,@value_rmb,@pay_time)";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@out_trade_no", alipayRecord.out_trade_no);
mycmd.Parameters.AddWithValue("@trade_type", (int)alipayRecord.trade_type);
mycmd.Parameters.AddWithValue("@alipay_trade_no", alipayRecord.alipay_trade_no);
mycmd.Parameters.AddWithValue("@user_name", DESEncrypt.EncryptDES(alipayRecord.user_name));
mycmd.Parameters.AddWithValue("@buyer_email", alipayRecord.buyer_email);
mycmd.Parameters.AddWithValue("@total_fee", alipayRecord.total_fee);
mycmd.Parameters.AddWithValue("@pay_time", alipayRecord.pay_time);
mycmd.Parameters.AddWithValue("@value_rmb", alipayRecord.value_rmb);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveGravelDistributeRecordInfo(GravelDistributeRecordInfo record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into graveldistributerecordinfo (`CreateDate`,`AllPlayerCount`,`RequestPlayerCount`,`ResponseGravelCount`) values (@CreateDate,@AllPlayerCount,@RequestPlayerCount,@ResponseGravelCount); ";
mycmd.Parameters.AddWithValue("@CreateDate", record.CreateDate);
mycmd.Parameters.AddWithValue("@AllPlayerCount", record.AllPlayerCount);
mycmd.Parameters.AddWithValue("@RequestPlayerCount", record.RequestPlayerCount);
mycmd.Parameters.AddWithValue("@ResponseGravelCount", record.ResponseGravelCount);
mycmd.CommandText = sqlText;
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sellOrder"></param>
/// <param name="myTrans"></param>
/// <returns></returns>
public bool CancelSellStoneOrder(StoneDelegateSellOrderInfo sellOrder, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
//string cmdTextA = "update notfinishedstonedelegatesellorderinfo set `SellState`=@SellState,`FinishedTime`=@FinishedTime where `OrderNumber` = @OrderNumber";
//mycmd.CommandText = cmdTextA;
//mycmd.Parameters.AddWithValue("@SellState", (int)sellOrder.SellState);
//mycmd.Parameters.AddWithValue("@FinishedTime", sellOrder.FinishedTime.ToDateTime());
//mycmd.Parameters.AddWithValue("@OrderNumber", sellOrder.OrderNumber);
//mycmd.ExecuteNonQuery();
//return true;
string cmdTextA = "insert into stonedelegatesellordercanceledinfo " +
"(`OrderNumber`, `UserID`, `Price`, `TradeStoneHandCount`, `FinishedStoneTradeHandCount`, `SellState`, `DelegateTime`, `IsSubOrder`, `ParentOrderNumber`, `FinishedTime` ) " +
" values " +
"(@OrderNumber, @UserID, @Price, @TradeStoneHandCount, @FinishedStoneTradeHandCount, @SellState, @DelegateTime, @IsSubOrder, @ParentOrderNumber, @FinishedTime); ";
string cmdTextB = "delete from notfinishedstonedelegatesellorderinfo where `OrderNumber` = @OrderNumber ;";
mycmd.CommandText = cmdTextA + cmdTextB;
mycmd.Parameters.AddWithValue("@OrderNumber", sellOrder.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", sellOrder.UserID);
mycmd.Parameters.AddWithValue("@Price", sellOrder.SellUnit.Price);
mycmd.Parameters.AddWithValue("@TradeStoneHandCount", sellOrder.SellUnit.TradeStoneHandCount);
mycmd.Parameters.AddWithValue("@FinishedStoneTradeHandCount", sellOrder.FinishedStoneTradeHandCount);
mycmd.Parameters.AddWithValue("@SellState", (int)sellOrder.SellState);
mycmd.Parameters.AddWithValue("@DelegateTime", sellOrder.DelegateTime.ToDateTime());
mycmd.Parameters.AddWithValue("@IsSubOrder", sellOrder.IsSubOrder);
if (sellOrder.ParentOrderNumber == null)
{
mycmd.Parameters.AddWithValue("@ParentOrderNumber", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@ParentOrderNumber", sellOrder.ParentOrderNumber);
}
mycmd.Parameters.AddWithValue("@FinishedTime", sellOrder.FinishedTime);
//myconn.Open();
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddSellOrder(SellStonesOrder order, int userID, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string cmdTextA = "insert into sellstonesorder " +
"(`OrderNumber`, `SellerUserName`, `SellStonesCount`, `Expense`, `ValueRMB`, `SellTime`, `OrderState` ) " +
" values " +
"(@OrderNumber, @SellerUserName, @SellStonesCount, @Expense, @ValueRMB, @SellTime, @OrderState); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber);
mycmd.Parameters.AddWithValue("@SellerUserName", DESEncrypt.EncryptDES(order.SellerUserName));
mycmd.Parameters.AddWithValue("@SellStonesCount", order.SellStonesCount);
mycmd.Parameters.AddWithValue("@Expense", order.Expense);
mycmd.Parameters.AddWithValue("@ValueRMB", order.ValueRMB);
mycmd.Parameters.AddWithValue("@SellTime", order.SellTime);
mycmd.Parameters.AddWithValue("@OrderState", order.OrderState);
mycmd.ExecuteNonQuery();
PlayerLastSellStoneRecord lastrecord = new PlayerLastSellStoneRecord()
{
UserID = userID,
SellStoneOrderNumber = order.OrderNumber,
SellTime = order.SellTime
};
string cmdTextB = "delete from playerlastsellstonerecord where `UserID` = @UserID ;" +
"insert into playerlastsellstonerecord " +
"(`UserID`, `SellStoneOrderNumber`, `SellTime` ) " +
" values " +
"(@UserID, @OrderNumber, @SellTime ); ";
mycmd.CommandText = cmdTextB;
mycmd.Parameters.AddWithValue("@UserID", lastrecord.UserID);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool AddWithdrawRMBRecord(WithdrawRMBRecord record, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
string sqlText = "insert into withdrawrmbrecord " +
"(`PlayerUserID`, `AlipayAccount`, `AlipayRealName`, `WidthdrawRMB`, `ValueYuan`,`CreateTime`, `RMBWithdrawState`, `AdminUserName`, `PayTime`) " +
" values (@PlayerUserID, @AlipayAccount, @AlipayRealName, @WidthdrawRMB, @ValueYuan, @CreateTime, @RMBWithdrawState, @AdminUserName, @PayTime)";
mycmd = trans.CreateCommand();
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@PlayerUserID", record.PlayerUserID);
mycmd.Parameters.AddWithValue("@AlipayAccount", DESEncrypt.EncryptDES(record.AlipayAccount));
mycmd.Parameters.AddWithValue("@AlipayRealName", DESEncrypt.EncryptDES(record.AlipayRealName));
mycmd.Parameters.AddWithValue("@WidthdrawRMB", record.WidthdrawRMB);
mycmd.Parameters.AddWithValue("@ValueYuan", record.ValueYuan);
mycmd.Parameters.AddWithValue("@CreateTime", record.CreateTime);
mycmd.Parameters.AddWithValue("@RMBWithdrawState", RMBWithdrawState.Waiting);
if (string.IsNullOrEmpty(record.AdminUserName))
{
mycmd.Parameters.AddWithValue("@AdminUserName", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@AdminUserName", DESEncrypt.EncryptDES(record.AdminUserName));
}
if (record.PayTime == null || !record.PayTime.HasValue)
{
mycmd.Parameters.AddWithValue("@PayTime", DBNull.Value);
}
else
{
mycmd.Parameters.AddWithValue("@PayTime", record.PayTime);
}
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool AddGambleStoneInningInfo(GambleStoneRoundInfo round, GambleStoneInningInfo inning, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
string tableName = GambleStoneInningInfoTableNamePrefix + round.TableName;
mycmd = myTrans.CreateCommand();
string sqlSelectTableText = "show tables where Tables_in_" + MyDBHelper.DataBaseServerName + " = @tableName ";
mycmd.CommandText = sqlSelectTableText;
mycmd.Parameters.AddWithValue("@tableName", tableName);
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(table);
adapter.Dispose();
if (table.Rows.Count == 0)
{
//表不存在，则创建
mycmd.CommandText = string.Format(this.sqlCreateGambleStoneInningInfoTable, round.TableName);
mycmd.ExecuteNonQuery();
}
string sqlText = "insert into " + tableName + " (`id`,`InningIndex`,`RoundID`,`CountDownSeconds`,`State`,`BetRedStone`,`BetGreenStone`,`BetBlueStone`,`BetPurpleStone`,`WinnedColor`,`WinnedTimes`,`WinnedOutStone`) " +
" values (@ID,@InningIndex,@RoundID,@CountDownSeconds,@State,@BetRedStone,@BetGreenStone,@BetBlueStone,@BetPurpleStone,@WinnedColor,@WinnedTimes,@WinnedOutStone ) ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@ID", inning.ID);
mycmd.Parameters.AddWithValue("@InningIndex", inning.InningIndex);
mycmd.Parameters.AddWithValue("@RoundID", inning.RoundID);
mycmd.Parameters.AddWithValue("@CountDownSeconds", inning.CountDownSeconds);
mycmd.Parameters.AddWithValue("@State", (byte)inning.State);
mycmd.Parameters.AddWithValue("@BetRedStone", inning.BetRedStone);
mycmd.Parameters.AddWithValue("@BetGreenStone", inning.BetGreenStone);
mycmd.Parameters.AddWithValue("@BetBlueStone", inning.BetBlueStone);
mycmd.Parameters.AddWithValue("@BetPurpleStone", inning.BetPurpleStone);
mycmd.Parameters.AddWithValue("@WinnedColor", inning.WinnedColor);
mycmd.Parameters.AddWithValue("@WinnedTimes", inning.WinnedTimes);
mycmd.Parameters.AddWithValue("@WinnedOutStone", inning.WinnedOutStone);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
