public void Init() { var trans = MyDBHelper.Instance.CreateTrans(); try { //GlobalConfig.IncomeMoneyAccount = DBProvider.SystemDBProvider.GetIncomeMoneyAccountConfig(); //if (GlobalConfig.IncomeMoneyAccount == null) //{ // //LogHelper.Instance.AddErrorLog("没有设置收款信息。", null); //} GlobalConfig.GameConfig = DBProvider.SystemDBProvider.GetGameConfig(); if (GlobalConfig.GameConfig == null) { GlobalConfig.GameConfig = new GameConfig(); DBProvider.SystemDBProvider.SaveGameConfig(GlobalConfig.GameConfig, trans); } GlobalConfig.RegisterPlayerConfig = DBProvider.SystemDBProvider.GetRegisterUserConfig(); if (GlobalConfig.RegisterPlayerConfig == null) { GlobalConfig.RegisterPlayerConfig = new RegisterUserConfig(); DBProvider.SystemDBProvider.SaveRegisterUserConfig(GlobalConfig.RegisterPlayerConfig, trans); } GlobalConfig.AwardReferrerLevelConfig = new AwardReferrerLevelConfig(); GlobalConfig.AwardReferrerLevelConfig.SetListAward(DBProvider.SystemDBProvider.GetAwardReferrerConfig()); if (GlobalConfig.AwardReferrerLevelConfig.AwardLevelCount == 0) { var config = new AwardReferrerConfig(); List <AwardReferrerConfig> listConfig = new List <AwardReferrerConfig>(); listConfig.Add(config); DBProvider.SystemDBProvider.SaveAwardReferrerConfig(listConfig, trans); GlobalConfig.AwardReferrerLevelConfig.SetListAward(listConfig); } GlobalConfig.RouletteConfig = DBProvider.SystemDBProvider.GetRouletteConfig(); trans.Commit(); } catch (Exception exc) { trans.Rollback(); throw exc; } finally { trans.Dispose(); } }
public AwardReferrerConfig ToDBObject() { AwardReferrerConfig dbConfig = new AwardReferrerConfig() { AwardReferrerDiamond = this.AwardReferrerDiamond, AwardReferrerExp = this.AwardReferrerExp, AwardReferrerGoldCoin = this.AwardReferrerGoldCoin, AwardReferrerMiners = this.AwardReferrerMiners, AwardReferrerMines = this.AwardReferrerMines, AwardReferrerStones = this.AwardReferrerStones, ReferLevel = this.ReferLevel }; return(dbConfig); }
public List <AwardReferrerConfig> GetAwardReferrerConfig() { List <AwardReferrerConfig> listAwardConfig = new List <AwardReferrerConfig>(); MySqlConnection myconn = null; try { myconn = MyDBHelper.Instance.CreateConnection(); myconn.Open(); DataTable table = new DataTable(); string cmdText = "SELECT * FROM awardreferrerconfig"; MySqlCommand mycmd = new MySqlCommand(cmdText, myconn); MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd); adapter.Fill(table); for (int i = 0; i < table.Rows.Count; i++) { AwardReferrerConfig config = new AwardReferrerConfig(); config.ReferLevel = Convert.ToInt32(table.Rows[i]["ReferLevel"]); config.AwardReferrerExp = Convert.ToDecimal(table.Rows[i]["AwardReferrerExp"]); config.AwardReferrerGoldCoin = Convert.ToDecimal(table.Rows[i]["AwardReferrerGoldCoin"]); config.AwardReferrerMines = Convert.ToDecimal(table.Rows[i]["AwardReferrerMines"]); config.AwardReferrerMiners = Convert.ToInt32(table.Rows[i]["AwardReferrerMiners"]); config.AwardReferrerStones = Convert.ToDecimal(table.Rows[i]["AwardReferrerStones"]); config.AwardReferrerDiamond = Convert.ToDecimal(table.Rows[i]["AwardReferrerDiamond"]); listAwardConfig.Add(config); } table.Clear(); table.Dispose(); adapter.Dispose(); mycmd.Dispose(); return(listAwardConfig); } catch (Exception exc) { throw exc; } finally { MyDBHelper.Instance.DisposeConnection(myconn); } }
public static AwardReferrerConfigUIModel CreateFromDBObject(AwardReferrerConfig parent) { if (parent == null) { return(new AwardReferrerConfigUIModel()); } AwardReferrerConfigUIModel uiConfig = new AwardReferrerConfigUIModel() { AwardReferrerDiamond = parent.AwardReferrerDiamond, AwardReferrerExp = parent.AwardReferrerExp, AwardReferrerGoldCoin = parent.AwardReferrerGoldCoin, AwardReferrerMiners = parent.AwardReferrerMiners, AwardReferrerMines = parent.AwardReferrerMines, AwardReferrerStones = parent.AwardReferrerStones, ReferLevel = parent.ReferLevel }; return(uiConfig); }