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;
}
