static void doFrom_GameUser(object parm) { ZyGames.Framework.Model.SchemaTable schema = ZyGames.Framework.Model.EntitySchemaSet.Get <GameUser>(); int max = int.Parse(parm as string); ConsoleLog.showNotifyInfo("########" + typeof(GameUser).ToString() + "######## From Start:" + max); int Step = 1000; var cache = new PersonalCacheStruct <GameUser>(); for (int i = 0; i < max; i += Step) { var filter = new ZyGames.Framework.Net.DbDataFilter(0); filter.Condition = "where UserId>=@Key1 and UserId<@Key2"; filter.Parameters.Add("Key1", i); filter.Parameters.Add("Key2", i + Step); cache.TryRecoverFromDb(filter); ConsoleLog.showNotifyInfo("gameUser: "******" load"); } ConsoleLog.showNotifyInfo("########" + typeof(GameUser).ToString() + "######## From End"); }
static void doFrom_Model_person <T>(object parm, string key = "UserId") where T : BaseEntity, new() { ZyGames.Framework.Model.SchemaTable schema = ZyGames.Framework.Model.EntitySchemaSet.Get <T>(); string typeName = typeof(T).ToString(); int max = int.Parse(parm as string); ConsoleLog.showNotifyInfo("########" + typeName + "######## From Start:" + max); int Step = 1000; var cache = new PersonalCacheStruct <T>(); for (int i = 0; i < max; i += Step) { var filter = new ZyGames.Framework.Net.DbDataFilter(0); filter.Condition = "where " + key + " >=@Key1 and " + key + " <@Key2"; filter.Parameters.Add("Key1", i); filter.Parameters.Add("Key2", i + Step); cache.TryRecoverFromDb(filter); ConsoleLog.showNotifyInfo(typeName + ":" + i + " load"); } ConsoleLog.showNotifyInfo("########" + typeName + "######## From End"); }