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