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(); } } }