public async Task History_02() { xx = string.Empty; var path = "~00-c-1-2-1-1-1-1-1-4-1-1-1-4-1-2-1-7"; var level = 2; // where and var res3 = await MyDAL_TestDB .Deleter <Agent>() .Where(it => it.PathId == path) .And(it => it.AgentLevel == (AgentLevel)level) .DeleteAsync(); Assert.True(res3 == 1); xx = string.Empty; // where or var res2 = await MyDAL_TestDB.OpenDebug() .Deleter <Agent>() .Where(it => it.PathId == path) .Or(it => it.AgentLevel == (AgentLevel)level) .DeleteAsync(); Assert.True(res2 == 28063); var xx4 = string.Empty; // where and or var res4 = await MyDAL_TestDB .Deleter <Agent>() .Where(it => it.PathId == path) .And(it => it.AgentLevel == (AgentLevel)level) .Or(it => it.CreatedOn >= WhereTest.StartTime) .DeleteAsync(); xx = string.Empty; }
public async Task Update_SetField_ST() { xx = string.Empty; var m = await CreateDbData(); // 多 字段 多 set 用法 var res1 = await MyDAL_TestDB.OpenDebug() .Updater <BodyFitRecord>() // 更新表 BodyFitRecord .Set(it => it.CreatedOn, DateTime.Now) // 设置字段 CreatedOn 值 .Set(it => it.BodyMeasureProperty, "{xxx:yyy,mmm:nnn,zzz:aaa}") // 设置字段 BodyMeasureProperty 值 .Where(it => it.Id == m.Id) .UpdateAsync(); Assert.True(res1 == 1); /***************************************************************************************************************************/ xx = string.Empty; }
public async Task History_06() { var m = await PreData01(); var name = "辛文丽"; var level = 128; /**************************************************************************************************************************/ xx = string.Empty; // var res2 = await MyDAL_TestDB .Selecter(out Agent agent2, out AgentInventoryRecord record2) .From(() => agent2) .InnerJoin(() => record2) .On(() => agent2.Id == record2.AgentId) .Where(() => agent2.CreatedOn >= Convert.ToDateTime("2018-08-16 19:20:28.118853")) // const method DateTime >= .SelectListAsync <AgentInventoryRecord>(); Assert.True(res2.Count == 523); /**************************************************************************************************************************/ xx = string.Empty; // var res3 = await MyDAL_TestDB .Selecter(out Agent agent3, out AgentInventoryRecord record3) .From(() => agent3) .InnerJoin(() => record3) .On(() => agent3.Id == record3.AgentId) .Where(() => record3.AgentId == Guid.Parse("544b9053-322e-4857-89a0-0165443dcbef")) // const method Guid == .SelectListAsync <AgentInventoryRecord>(); Assert.True(res3.Count == 1); Assert.Equal(res3.First().Id, Guid.Parse("02dbc81c-5c9a-4cdf-8bf0-016551f756c4")); /**************************************************************************************************************************/ xx = string.Empty; // var res4 = await MyDAL_TestDB .Selecter(out Agent agent4, out AgentInventoryRecord record4) .From(() => agent4) .InnerJoin(() => record4) .On(() => agent4.Id == record4.AgentId) .Where(() => agent4.Name == "辛文丽") // const string == .SelectListAsync <AgentInventoryRecord>(); Assert.True(res4.Count == 1); /**************************************************************************************************************************/ xx = string.Empty; // var res5 = await MyDAL_TestDB.OpenDebug() .Selecter(out Agent agent5, out AgentInventoryRecord record5) .From(() => agent5) .InnerJoin(() => record5) .On(() => agent5.Id == record5.AgentId) .Where(() => agent5.AgentLevel == AgentLevel.DistiAgent) // const enum == .SelectListAsync <AgentInventoryRecord>(); Assert.True(res5.Count == 574); /**************************************************************************************************************************/ xx = string.Empty; // var res6 = await MyDAL_TestDB .Selecter(out Agent agent6, out AgentInventoryRecord record6) .From(() => agent6) .InnerJoin(() => record6) .On(() => agent6.Id == record6.AgentId) .Where(() => agent6.Id == m.Id) // virable prop Guid == .SelectListAsync <Agent>(); Assert.True(res6.Count == 1); Assert.Equal(res6.First().Id, Guid.Parse("0ce552c0-2f5e-4c22-b26d-01654443b30e")); /**************************************************************************************************************************/ xx = string.Empty; // var res7 = await MyDAL_TestDB .Selecter(out Agent agent7, out AgentInventoryRecord record7) .From(() => agent7) .InnerJoin(() => record7) .On(() => agent7.Id == record7.AgentId) .Where(() => agent7.Name == name) // virable string == .SelectListAsync <AgentInventoryRecord>(); Assert.True(res7.Count == 1); /**************************************************************************************************************************/ xx = string.Empty; // var res8 = await MyDAL_TestDB .Selecter(out Agent agent8, out AgentInventoryRecord record8) .From(() => agent8) .InnerJoin(() => record8) .On(() => agent8.Id == record8.AgentId) .Where(() => agent8.AgentLevel == (AgentLevel)level) // virable enum == .SelectListAsync <AgentInventoryRecord>(); Assert.True(res8.Count == 574); /**************************************************************************************************************************/ xx = string.Empty; // var res9 = await MyDAL_TestDB .Selecter(out Agent agent9, out AgentInventoryRecord record9) .From(() => agent9) .InnerJoin(() => record9) .On(() => agent9.Id == record9.AgentId) .Where(() => agent9.CreatedOn >= Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30)) // prop prop DateTime >= .SelectListAsync <AgentInventoryRecord>(); Assert.True(res9.Count == 574); /**************************************************************************************************************************/ xx = string.Empty; var res10 = await MyDAL_TestDB .Selecter(out Agent agent10, out AgentInventoryRecord record10) .From(() => agent10) .InnerJoin(() => record10) .On(() => agent10.Id == record10.AgentId) .Where(() => agent10.Id == Guid.Parse("544b9053-322e-4857-89a0-0165443dcbef")) .And(() => record10.CreatedOn >= Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30).AddDays(-60)) .SelectListAsync <Agent>(); Assert.True(res10.Count == 1); /**************************************************************************************************************************/ xx = string.Empty; }
public async Task History_01() { await PreQuery(); /****************************************************************************************************************************************/ xx = string.Empty; // == Guid var res1 = await MyDAL_TestDB .Selecter <BodyFitRecord>() .Where(it => it.Id == Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e")) .SelectOneAsync(); Assert.NotNull(res1); var resR1 = await MyDAL_TestDB.OpenDebug() .Selecter <BodyFitRecord>() .Where(it => Guid.Parse("1fbd8a41-c75b-45c0-9186-016544284e2e") == it.Id) .SelectOneAsync(); Assert.NotNull(resR1); Assert.True(res1.Id == resR1.Id); /****************************************************************************************************************************************/ xx = string.Empty; // == DateTime var res2 = await MyDAL_TestDB .Selecter <BodyFitRecord>() .Where(it => it.CreatedOn == Convert.ToDateTime("2018-08-23 13:36:58")) .SelectOneAsync(); Assert.NotNull(res2); var resR2 = await MyDAL_TestDB.OpenDebug() .Selecter <BodyFitRecord>() .Where(it => Convert.ToDateTime("2018-08-23 13:36:58") == it.CreatedOn) .SelectOneAsync(); Assert.NotNull(resR2); Assert.True(res2.Id == resR2.Id); /****************************************************************************************************************************************/ xx = string.Empty; // == string var res3 = await MyDAL_TestDB .Selecter <BodyFitRecord>() .Where(it => it.BodyMeasureProperty == "xxxx") .SelectOneAsync(); Assert.NotNull(res3); var resR3 = await MyDAL_TestDB.OpenDebug() .Selecter <BodyFitRecord>() .Where(it => "xxxx" == it.BodyMeasureProperty) .SelectOneAsync(); Assert.NotNull(resR3); Assert.True(res3.Id == resR3.Id); /****************************************************************************************************************************************/ xx = string.Empty; }