public static void CheckAndUpdateDataTable(object state) { DBProvider db = new DBProvider("Game"); var versions = db.Select("dataTableVersions", "Name,UsedVersion,LatestVersion", ""); foreach (var version in versions) { if ((int)version["LatestVersion"] > (int)version["UsedVersion"]) { FileInfo dtfile = new FileInfo("DataTables/" + (string)version["Name"] + ".txt"); DataTableLoader.LoadDataTableFile(dtfile); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams["UsedVersion"] = version["LatestVersion"]; db.Update("dataTableVersions", sqlparams, "Name = '" + version["Name"] + "'"); } } }
public void SetUp() { DataTableLoader.LoadDataTableFile(new FileInfo(TestConsts.DataTableDir + "Hero.txt"), typeof(DTHero)); DataTableLoader.LoadDataTableFile(new FileInfo(TestConsts.DataTableDir + "HeroBase.txt"), typeof(DTHeroBase)); m_PlayerHeroLogic = new PlayerHeroLogic(); PlayerHeros ph = new PlayerHeros() { UserId = 1, }; Hero h1 = new Hero() { HeroType = 1, HeroLv = 1, HeroExp = 0, HeroStarLevel = 1, ConsciousnessLevel = 0, ElevationLevel = 0 }; h1.SkillLevels.AddRange(new int[] { 1, 1, 1, 1, 1, 0, 0, 0, 0, 1 }); m_PlayerHeroLogic.MyHeros = ph; ph.Heros.Add(1, h1); }