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 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 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();
}
}
}
/// <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 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 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 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 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 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 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 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 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 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);
}
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>
/// 保存从所有奖项中选出的12个
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
public bool SaveCurrentRouletteAwardItemsList(RouletteAwardItem[] items)
{
CustomerMySqlTransaction trans = null;
try
{
trans = MyDBHelper.Instance.CreateTrans();
UpdateRouletteAwardItem_WinProbability(items, trans);
UpdateCurrentAwardItemList(items, trans);
trans.Commit();
return(true);
}
catch (Exception exc)
{
trans.Rollback();
throw exc;
}
finally
{
if (trans != null)
{
trans.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 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 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 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();
}
}
/// <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 OpenFactory(int userID, CustomerMySqlTransaction myTrans)
{
//需先检查数据库中是否存在工厂信息，如果没有则添加
bool isOK = MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd =>
{
string sqlText = "select count(ID) from playerstonefactoryaccountinfo where `UserID`=@UserID ";
mycmd.Parameters.AddWithValue("@UserID", userID);
mycmd.CommandText = sqlText;
object objResult = Convert.ToInt32(mycmd.ExecuteScalar());
if (objResult == DBNull.Value || Convert.ToInt32(objResult) == 0)
{
//添加新记录
sqlText = "insert into playerstonefactoryaccountinfo " +
"(`UserID`,`FactoryIsOpening`,`FactoryLiveDays`,`Food`,`LastDayValidStoneStack`,`FreezingSlaveGroupCount`,`EnableSlavesGroupCount`) " +
" values (@UserID,@FactoryIsOpening,@FactoryLiveDays,@Food,@LastDayValidStoneStack,@FreezingSlaveGroupCount,@EnableSlavesGroupCount) ";
mycmd.CommandText = sqlText;
//mycmd.Parameters.Clear();
//mycmd.Parameters.AddWithValue("@UserID", userID);
mycmd.Parameters.AddWithValue("@FactoryIsOpening", true);
mycmd.Parameters.AddWithValue("@FactoryLiveDays", StoneFactoryConfig.FactoryLiveDays);
mycmd.Parameters.AddWithValue("@Food", 0);
mycmd.Parameters.AddWithValue("@LastDayValidStoneStack", 0);
mycmd.Parameters.AddWithValue("@FreezingSlaveGroupCount", 0);
mycmd.Parameters.AddWithValue("@EnableSlavesGroupCount", 0);
mycmd.ExecuteNonQuery();
}
else
{
//修改原记录
sqlText = "update playerstonefactoryaccountinfo set `FactoryIsOpening`=@FactoryIsOpening,`FactoryLiveDays`=@FactoryLiveDays where `UserID`=@UserID ";
mycmd.CommandText = sqlText;
//mycmd.Parameters.Clear();
//mycmd.Parameters.AddWithValue("@UserID", userID);
mycmd.Parameters.AddWithValue("@FactoryIsOpening", true);
mycmd.Parameters.AddWithValue("@FactoryLiveDays", StoneFactoryConfig.FactoryLiveDays);
mycmd.ExecuteNonQuery();
}
});
return(isOK);
}
public bool UpdateGambleStoneRoundInfo(GambleStoneRoundInfo round, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "update gamblestoneroundinfo set `StartTime`=@StartTime,`FinishedInningCount`=@FinishedInningCount,`EndTime`=@EndTime,`CurrentWinRedCount`=@CurrentWinRedCount," +
"`CurrentWinGreenCount`=@CurrentWinGreenCount,`CurrentWinBlueCount`=@CurrentWinBlueCount,`CurrentWinPurpleCount`=@CurrentWinPurpleCount,`LastWinRedCount`=@LastWinRedCount," +
"`LastWinGreenCount`=@LastWinGreenCount,`LastWinBlueCount`=@LastWinBlueCount,`LastWinPurpleCount`=@LastWinPurpleCount,`AllBetInStone`=@AllBetInStone," +
"`AllWinnedOutStone`=@AllWinnedOutStone,`WinColorItems`=@WinColorItems,`TableName`=@TableName " +
" where `id`=@id ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@StartTime", round.StartTime.ToDateTime());
mycmd.Parameters.AddWithValue("@FinishedInningCount", round.FinishedInningCount);
mycmd.Parameters.AddWithValue("@EndTime", round.EndTime == null ? DBNull.Value : (object)round.EndTime.ToDateTime());
mycmd.Parameters.AddWithValue("@CurrentWinRedCount", round.CurrentWinRedCount);
mycmd.Parameters.AddWithValue("@CurrentWinGreenCount", round.CurrentWinGreenCount);
mycmd.Parameters.AddWithValue("@CurrentWinBlueCount", round.CurrentWinBlueCount);
mycmd.Parameters.AddWithValue("@CurrentWinPurpleCount", round.CurrentWinPurpleCount);
mycmd.Parameters.AddWithValue("@LastWinRedCount", round.LastWinRedCount);
mycmd.Parameters.AddWithValue("@LastWinGreenCount", round.LastWinGreenCount);
mycmd.Parameters.AddWithValue("@LastWinBlueCount", round.LastWinBlueCount);
mycmd.Parameters.AddWithValue("@LastWinPurpleCount", round.LastWinPurpleCount);
mycmd.Parameters.AddWithValue("@AllBetInStone", round.AllBetInStone);
mycmd.Parameters.AddWithValue("@AllWinnedOutStone", round.AllWinnedOutStone);
mycmd.Parameters.AddWithValue("@WinColorItems", BytesConverter.ConvertByteArrayToBytes(round.WinColorItems));
mycmd.Parameters.AddWithValue("@TableName", round.TableName);
mycmd.Parameters.AddWithValue("@id", round.ID);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool SaveRegisterUserConfig(RegisterUserConfig config, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = trans.CreateCommand();
string cmdText = "delete from registeruserconfig; " +
"insert into registeruserconfig (UserCountCreateByOneIP, GiveToNewUserExp, GiveToNewUserGoldCoin, GiveToNewUserMines, GiveToNewUserMiners, GiveToNewUserStones, FirstAlipayRechargeGoldCoinAwardMultiple ) values " +
" (@UserCountCreateByOneIP, @GiveToNewUserExp, @GiveToNewUserGoldCoin, @GiveToNewUserMines, @GiveToNewUserMiners, @GiveToNewUserStones, @FirstAlipayRechargeGoldCoinAwardMultiple )";
mycmd.CommandText = cmdText;
mycmd.Parameters.AddWithValue("@UserCountCreateByOneIP", config.UserCountCreateByOneIP);
mycmd.Parameters.AddWithValue("@GiveToNewUserExp", config.GiveToNewUserExp);
mycmd.Parameters.AddWithValue("@GiveToNewUserGoldCoin", config.GiveToNewUserGoldCoin);
mycmd.Parameters.AddWithValue("@GiveToNewUserMines", config.GiveToNewUserMines);
mycmd.Parameters.AddWithValue("@GiveToNewUserMiners", config.GiveToNewUserMiners);
mycmd.Parameters.AddWithValue("@GiveToNewUserStones", config.GiveToNewUserStones);
mycmd.Parameters.AddWithValue("@FirstAlipayRechargeGoldCoinAwardMultiple", config.FirstAlipayRechargeGoldCoinAwardMultiple);
mycmd.ExecuteNonQuery();
//mycmd.Dispose();
return(true);
}
public bool DeleteWaitToAwardExpRecord(int id, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string sqlText = "delete from waittoawardexprecord where id = @id ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@id", id);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public int TransactionDataBaseOper(TransactionDBOperDelegte DBOper, TransactionDBOperFailedDelegate FaileOper)
{
CustomerMySqlTransaction myTrans = null;
try
{
myTrans = MyDBHelper.Instance.CreateTrans();
int result = DBOper(myTrans);
if (result == OperResult.RESULTCODE_TRUE)
{
myTrans.Commit();
}
else
{
myTrans.Rollback();
if (FaileOper != null)
{
FaileOper(null);
}
}
return(result);
}
catch (Exception exc)
{
myTrans.Rollback();
if (FaileOper != null)
{
FaileOper(exc);
}
return(OperResult.RESULTCODE_FALSE);
}
finally
{
if (myTrans != null)
{
myTrans.Dispose();
}
}
}
/// <summary>
/// 保存到未完成表
/// </summary>
/// <param name="buyOrder"></param>
/// <returns></returns>
public bool SaveWaitingStoneDelegateBuyOrderInfo(StoneDelegateBuyOrderInfo buyOrder)
{
CustomerMySqlTransaction myTrans = MyDBHelper.Instance.CreateTrans();
try
{
SaveWaitingStoneDelegateBuyOrderInfo(buyOrder, myTrans);
myTrans.Commit();
return(true);
}
catch (Exception exc)
{
myTrans.Rollback();
throw exc;
}
finally
{
if (myTrans != null)
{
myTrans.Dispose();
}
}
}
private bool UpdateSellOrderState(string orderNumber, SellOrderState state, CustomerMySqlTransaction trans)
{
//1.修改订单状态；
//2.删除锁定信息记录。
MySqlCommand mycmd = null;
try
{
string textA = "update sellstonesorder set OrderState = @OrderState where OrderNumber = @OrderNumber;";
string textB = "delete from locksellstonesorder where OrderNumber = @OrderNumber;";
mycmd = trans.CreateCommand();
mycmd.CommandText = textA + textB;
mycmd.Parameters.AddWithValue("@OrderState", (int)state);
mycmd.Parameters.AddWithValue("@OrderNumber", orderNumber);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool DeleteTempMineTradeRecord(string orderNumber, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string cmdTextA = "delete from tempminesbuyrecord where OrderNumber = @OrderNumber;";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", orderNumber);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
