public void ProductTest() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); oLiveEntities.Dispose(); GC.Collect(); }
public void MemberTest2() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralResource ResourceB = new GeneralResource { Rtype = (byte)ModelEnum.ResourceType.STRING, Code = "ResourceB", Culture = 1033, Matter = "ResourceTest2" }; GeneralResItem ResItemA = new GeneralResItem { Culture = 1033, Matter = "this is the resource's son", Cash = 3.08m, Resource = ResourceB }; oLiveEntities.GeneralResItems.Add(ResItemA); oLiveEntities.SaveChanges(); oLiveEntities.Dispose(); GC.Collect(); }
public void MemberTest() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralResource ResourceA = new GeneralResource { Rtype = (byte)ModelEnum.ResourceType.STRING, Code = "ResourceA", Culture = 1033, Matter = "ResourceTest" }; oLiveEntities.GeneralResources.Add(ResourceA); oLiveEntities.SaveChanges(); oLiveEntities.Dispose(); GC.Collect(); }
public void MemberTest() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); MemberOrganization ResourceA = new MemberOrganization { Code="123456" }; MemberOrganization ResourceB = new MemberOrganization { Code = "2345", CellPhone = "123456" }; oLiveEntities.MemberOrganizations.Add(ResourceA); oLiveEntities.MemberOrganizations.Add(ResourceB); oLiveEntities.SaveChanges(); oLiveEntities.Dispose(); GC.Collect(); }
private static void Test04() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); MemberUser oUser = new MemberUser { Passcode = "hello world" }; oGeneralEntities.Dispose(); GC.Collect(); }
private static void Test03() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); // 指定Child方式 GeneralLargeItem oItemA1 = new GeneralLargeItem { Culture = 1033, CLOB = "hello, this is a long text (en-US)", Source = (byte)ModelEnum.LargeObjectSource.NONE }; GeneralLargeItem oItemA2 = new GeneralLargeItem { Culture = 1036, CLOB = "hello, this is a long text (fr-FR)", Source = (byte)ModelEnum.LargeObjectSource.NONE }; GeneralLargeObject oLargeA = new GeneralLargeObject { CLOB = "hello, there are parents", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE, LargeItems = new List<GeneralLargeItem> { oItemA1, oItemA2 } }; // 指定Parent方式 GeneralLargeObject oLargeB = new GeneralLargeObject { CLOB = "hello, there are parents", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE }; GeneralLargeItem oItemB1 = new GeneralLargeItem { Culture = 1033, CLOB = "hello, this is a long text (en-US)", Source = (byte)ModelEnum.LargeObjectSource.NONE, LargeObject = oLargeB }; GeneralLargeItem oItemB2 = new GeneralLargeItem { Culture = 1036, CLOB = "hello, this is a long text (fr-FR)", Source = (byte)ModelEnum.LargeObjectSource.NONE, LargeObject = oLargeB }; oGeneralEntities.GeneralLargeObjects.Add(oLargeA); oGeneralEntities.GeneralLargeItems.Add(oItemB1); oGeneralEntities.GeneralLargeItems.Add(oItemB2); oGeneralEntities.SaveChanges(); var oResources = oGeneralEntities.GeneralLargeObjects.Include("GeneralLargeItems"); foreach (GeneralLargeObject obj1 in oResources.ToList()) { Console.WriteLine(obj1.CLOB); foreach (GeneralLargeItem obj2 in obj1.LargeItems) { CultureInfo oCulture = new CultureInfo(obj2.Culture); Console.WriteLine(" " + oCulture.NativeName + " " + obj2.CLOB); } } oGeneralEntities.Dispose(); GC.Collect(); }
private static void Test02(string s) { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); // 指定Child方式 GeneralResItem oResItemA1 = new GeneralResItem { Culture = 1033, Matter = "Product Name (En)" }; GeneralResItem oResItemA2 = new GeneralResItem { Culture = 1036, Matter = "Product Name (Fr)" }; GeneralResource oResourceA = new GeneralResource { Rtype = (byte)ModelEnum.ResourceType.STRING, Matter = "产品名称", ResourceItems = new List<GeneralResItem> { oResItemA1, oResItemA2 } }; // 指定Parent方式 GeneralResource oResourceB = new GeneralResource { Rtype = (byte)ModelEnum.ResourceType.MONEY, Matter = "产品名称" }; GeneralResItem oResItemB1 = new GeneralResItem { Culture = 1033, Matter = "Product Name (En)", Resource = oResourceB }; GeneralResItem oResItemB2 = new GeneralResItem { Culture = 1036, Matter = "Product Name (Fr)", Resource = oResourceB }; oGeneralEntities.GeneralResources.Add(oResourceA); oGeneralEntities.GeneralResItems.Add(oResItemB1); oGeneralEntities.GeneralResItems.Add(oResItemB2); oGeneralEntities.SaveChanges(); var oResources = oGeneralEntities.GeneralResources.Include("GeneralResItems"); foreach (GeneralResource obj1 in oResources.ToList()) { Console.WriteLine(obj1.Matter); foreach (GeneralResItem obj2 in obj1.ResourceItems) { CultureInfo oCulture = new CultureInfo(obj2.Culture); Console.WriteLine(" " + oCulture.NativeName + " " + obj2.Matter); } } oGeneralEntities.Dispose(); GC.Collect(); }
private static void Test01() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralConfig oGeneralA1 = new GeneralConfig { Code = "F1", Culture = 2052, Ctype = (byte)ModelEnum.ConfigParamType.DECIMAL, IntValue = 0, DecValue = 123.3456m }; GeneralConfig oGeneralA2 = new GeneralConfig { Code = "F2", Culture = 2052, Ctype = (byte)ModelEnum.ConfigParamType.DATETIME, DateValue = DateTimeOffset.Now }; GeneralConfig oGeneralA = new GeneralConfig { Code = "F", Culture = 2052, Ctype = (byte)Models.ModelEnum.ConfigParamType.STRING, StrValue = "Root_A", ChildItems = new List<GeneralConfig> { oGeneralA1, oGeneralA2 } }; GeneralConfig oGeneralA3 = new GeneralConfig { Code = "F3", Culture = 2052, Ctype = (byte)Models.ModelEnum.ConfigParamType.STRING, StrValue = "Root_A", Parent = oGeneralA }; // oGeneralEntities.GeneralConfigs.Add(oGeneralA); // oGeneralEntities.GeneralConfigs.Add(oGeneralA1); // oGeneralEntities.GeneralConfigs.Add(oGeneralA2); oGeneralEntities.GeneralConfigs.Add(oGeneralA3); oGeneralEntities.SaveChanges(); var oConfigs = oGeneralEntities.GeneralConfigs; foreach (GeneralConfig obj in oConfigs.ToList()) { Console.WriteLine("GUID: {0} Code: {1}, Decimal: {2}", obj.Gid.ToString("N"), obj.Code, obj.DecValue); } oGeneralEntities.Dispose(); GC.Collect(); }
public void MemberTest3() { LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralLargeItem LargeItemA = new GeneralLargeItem { //LargeObject = LargeObjectA, Culture = 1024, CLOB = "this is a test LargeItem", FileType = ".txt", Source = (byte)ModelEnum.LargeObjectSource.DATEBASE, ObjUrl = "/123/23/3" }; GeneralLargeItem LargeItemB = new GeneralLargeItem { //LargeObject = LargeObjectB, Culture = 2011, CLOB = "this is the other test LargeItem", FileType = ".php", Source = (byte)ModelEnum.LargeObjectSource.NONE, ObjUrl = "/1abc" }; GeneralLargeObject LargeObjectA = new GeneralLargeObject { Code = "LargeObjectA", Culture = 1033, CLOB = "this is a LargeObject CLOB", FileType = ".jpg", ObjUrl = "/zhuchao/123", LargeItems = new List<GeneralLargeItem> { LargeItemA, LargeItemB}, Source = (byte)ModelEnum.LargeObjectSource.DATEBASE }; oLiveEntities.GeneralLargeObjects.Add(LargeObjectA); oLiveEntities.SaveChanges(); //Console.WriteLine(LargeItemA.Gid); //Console.WriteLine(LargeObjectA.Gid); oLiveEntities.Dispose(); GC.Collect(); }
public void MemberTest6() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralMeasureUnit UnitA = new GeneralMeasureUnit { Utype = (byte)ModelEnum.MeasureUnit.PIECE, Code = "RMB", Name = new GeneralResource { Matter = "RMB", Culture = 2052, ResourceItems = new List<GeneralResItem> { new GeneralResItem { Culture = 1033, Matter = "USD" }, new GeneralResItem { Culture = 1035, Matter = "FR" } } } }; oGeneralEntities.GeneralMeasureUnits.Add(UnitA); oGeneralEntities.SaveChanges(); oGeneralEntities.Dispose(); GC.Collect(); }
public void MemberTest5() { LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection); GeneralRegion RegionA = new GeneralRegion { Code = "RegionA", FullName = "RegionChinaA", ShortName = "A", Sorting = 1 }; GeneralRegion RegionB = new GeneralRegion { Code = "RegionB", FullName = "RegionChinaB", ShortName = "B", Sorting = 2, Parent = RegionA }; oGeneralEntities.GeneralRegions.Add(RegionB); oGeneralEntities.SaveChanges(); oGeneralEntities.Dispose(); GC.Collect(); }
/// <summary> /// 时间触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OnTimedEvent(object sender, ElapsedEventArgs e) { if (oSemaphore == LiveSemaphore.RED) // 红灯冲突,终止执行 return; if (nDelayTime > 0) // 延迟一个周期 { nDelayTime--; return; } // 开始执行事件 oSemaphore = LiveSemaphore.RED; LiveEntities dbEntity = new LiveEntities(ConfigHelper.LiveConnection.Connection); EventBLL oEventBLL = new EventBLL(dbEntity); try { oEventBLL.WriteEvent("OnTimedEvent 执行事件", this.ToString()); // 淘宝接口同步 Section.TaobaoDaemon oTaobao = new Section.TaobaoDaemon(dbEntity, oEventBLL); oTaobao.Main(); // 消息服务 Section.MessageDaemon oMessage = new Section.MessageDaemon(dbEntity, oEventBLL); oMessage.Main(); // 同步分布式数据库 Section.SynchroDaemon oSynchro = new Section.SynchroDaemon(dbEntity, oEventBLL); oSynchro.Main(); oEventBLL.WriteEvent("OnTimedEvent 执行结束", this.ToString()); } catch (Exception ex) { oEventBLL.WriteEvent("OnTimedEvent " + ex.Message, ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString()); } finally { try { dbEntity.Dispose(); } catch { } } oSemaphore = LiveSemaphore.GREED; }