public async Task History()
{
/************************************************************************************************************/
await Pre01();
xx = string.Empty;
// 默认 "%"+"xx"+"%"
var res1 = await MyDAL_TestDB.SelectOneAsync <BodyFitRecord>(it => it.BodyMeasureProperty.Contains("xx"));
Assert.NotNull(res1);
/************************************************************************************************************/
xx = string.Empty;
// 默认 "%"+"~00-d-3-1-"+"%"
var res3 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.CreatedOn >= Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30))
.And(it => it.PathId.Contains("~00-d-3-1-"))
.SelectPagingAsync(1, 10);
Assert.True(res3.TotalCount == 5680);
/************************************************************************************************************/
}
public async Task NotEqual()
{
xx = string.Empty;
// !(==) --> <>
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => !(it.AgentLevel == AgentLevel.DistiAgent))
.SelectListAsync();
Assert.True(res1.Count == 28064 || res1.Count == 28065);
/********************************************************************************************************************************/
xx = string.Empty;
// != --> <>
var res2 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.AgentLevel != AgentLevel.DistiAgent)
.SelectListAsync();
Assert.True(res2.Count == 28064 || res2.Count == 28065);
/********************************************************************************************************************************/
xx = string.Empty;
}
private async Task <Agent> PreData01()
{
return(await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.Id == Guid.Parse("0ce552c0-2f5e-4c22-b26d-01654443b30e"))
.SelectOneAsync());
}
public async Task NotNotEqual()
{
xx = string.Empty;
// !(!=) --> =
var res1 = await MyDAL_TestDB.SelectListAsync <Agent>(it => !(it.AgentLevel != AgentLevel.Customer));
Assert.True(res1.Count == 28063 || res1.Count == 28064); // 此处为test
/***********************************************************************************************************************/
xx = string.Empty;
// == --> =
var res2 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.AgentLevel == AgentLevel.DistiAgent)
.OrderBy(it => it.CreatedOn)
.SelectListAsync <AgentVM>();
Assert.True(res2.Count == 555);
/***********************************************************************************************************************/
xx = string.Empty;
}
public async Task SelectVM_ST()
{
xx = string.Empty;
var res6 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.CreatedOn >= Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30))
.SelectPagingAsync <AgentVM>(1, 10);
var resR6 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30) <= it.CreatedOn)
.SelectPagingAsync <AgentVM>(1, 10);
Assert.True(res6.TotalCount == resR6.TotalCount);
Assert.True(res6.TotalCount == 28619);
/*************************************************************************************************************************/
xx = string.Empty;
}
public async Task Concat_Multi_ST()
{
xx = string.Empty;
// 上下文条件 变量
var userId = "08d6036b-0a7e-b07d-b9bd-af03841b3baa";
var firstName = "伏";
var where = MyDAL_TestDB.Selecter <Agent>().WhereSegment;
// 根据条件 判断 是否 拼接 UserId 字段 的 过滤条件
if (userId.IsNotBlank())
{
where = where.And(it => it.UserId == Guid.Parse(userId));
}
// 根据条件 判断 是否 拼接 Name 字段 的 过滤条件
if (firstName.IsNotBlank())
{
where = where.And(it => it.Name.StartsWith(firstName));
}
// 对 WhereSegment 设定的条件 进行 select 动作
var res1 = await where.SelectListAsync();
Assert.True(res1.Count == 1);
xx = string.Empty;
}
public None test(None none)
{
var res5 = (MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.Name == "刘中华")
.Distinct()
.SelectOneAsync()).GetAwaiter().GetResult();
return(none);
}
public async Task SelectM_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.TopAsync(25);
Assert.True(res1.Count == 25);
}
public async Task History_02()
{
/******************************************************************************************************/
xx = string.Empty;
// order by
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.AgentLevel == (AgentLevel)128)
.OrderBy(it => it.PathId)
.ThenOrderBy(it => it.Name, OrderByEnum.Asc)
.SelectPagingAsync(1, 10);
Assert.True(res1.TotalCount == 555);
/******************************************************************************************************/
xx = string.Empty;
// key
var res2 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.AgentLevel == (AgentLevel)2)
.SelectPagingAsync(1, 10);
Assert.True(res2.TotalPage == 2807);
/******************************************************************************************************/
xx = string.Empty;
var res4 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.CreatedOn >= WhereTest.CreatedOn)
.SelectPagingAsync(1, 10);
var resR4 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => WhereTest.CreatedOn <= it.CreatedOn)
.SelectPagingAsync(1, 10);
Assert.True(res4.TotalCount == resR4.TotalCount);
Assert.True(res4.TotalCount == 28619);
/*************************************************************************************************************************/
}
public async Task DateTime_Select_yyyy()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Distinct()
.SelectListAsync(it => it.CreatedOn.ToString("yyyy"));
Assert.True(res1.Count == 2);
}
public async Task Mock_SelectAllPaging_SelectM_ST()
{
/*************************************************************************************************************************/
xx = string.Empty;
var res3 = await MyDAL_TestDB
.Selecter <Agent>()
.SelectPagingAsync(1, 10);
Assert.True(res3.TotalCount == 28620);
}
public async Task Sum_Nullable_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <AgentInventoryRecord>()
.Where(it => it.Id != Guid.Parse("df2b788e-6b1a-4a74-ac1d-016551f76dc9"))
.SumAsync(it => it.TotalSaleCount);
Assert.True(res1 == 589);
xx = string.Empty;
}
public async Task Sum_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <AlipayPaymentRecord>()
.Where(it => it.CreatedOn > Convert.ToDateTime("2018-08-23 13:36:58").AddDays(-30))
.SumAsync(it => it.TotalAmount);
Assert.True(res1 == 1527.2600000000000000000000000M);
xx = string.Empty;
}
private async Task yyy(Guid[] arrays)
{
xx = string.Empty;
var res = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => arrays.Contains(it.Id))
.SelectListAsync();
Assert.True(res.Count == 2);
xx = string.Empty;
}
public async Task DateTime_Where_Nullable_yyyy_MM_dd()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.ActivedOn != null && it.ActivedOn.Value.ToString("yyyy-MM-dd") == DateTime.Parse("2018-08-19 12:05:45.560984").ToString("yyyy-MM-dd"))
.SelectListAsync();
Assert.True(res1.Count == 554);
xx = string.Empty;
}
// 在接口注入中使用 勿删!!!
public async Task eee(ApplyStockholderAwardAccountingVM vm)
{
xx = string.Empty;
if (!await MyDAL_TestDB
.Selecter <PlatformMonthlyPerformance>()
.Where(it => it.Year == vm.Year)
.And(it => it.Month == vm.Month)
.IsExistAsync())
{
Assert.True(true);
}
}
public async Task SqlAction_Distinct_Count_SpecialColumn_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Distinct()
.CountAsync(it => it.AgentLevel);
Assert.Equal(3, res1);
xx = string.Empty;
}
public async Task Count_Star_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.Name.Contains("陈%"))
.CountAsync();
Assert.True(res1 == 1421);
xx = string.Empty;
}
public async Task test()
{
/*************************************************************************************************************************/
xx = string.Empty;
var res2 = await MyDAL_TestDB
.Selecter <Agent>()
.Distinct()
.SelectListAsync(it => it.Name);
Assert.True(res2.Count == 24444);
/****************************************************************************************************************************************/
xx = string.Empty;
var res6 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.Name == "刘中华")
.Distinct()
.SelectOneAsync();
Assert.NotNull(res6);
var res61 = await MyDAL_TestDB.SelectListAsync <Agent>(it => it.Name == "刘中华");
Assert.True(res61.Count == 2);
/****************************************************************************************************************************************/
xx = string.Empty;
var res7 = await MyDAL_TestDB
.Selecter(out Agent agent1, out AgentInventoryRecord record1)
.From(() => agent1)
.InnerJoin(() => record1)
.On(() => agent1.Id == record1.AgentId)
.Where(() => agent1.AgentLevel == AgentLevel.DistiAgent)
.Distinct()
.SelectListAsync(() => agent1.Name);
Assert.True(res7.Count == 543);
/****************************************************************************************************************************************/
xx = string.Empty;
}
public async Task Test()
{
/******************************************************************************************************************/
xx = string.Empty;
await PreTrim();
var res1 = await MyDAL_TestDB
.Selecter <Product>()
.Where(it => it.Title.Trim() == "演示商品01")
.SelectOneAsync();
Assert.True(res1.Title == " 演示商品01 ");
/******************************************************************************************************************/
xx = string.Empty;
await PreLTrim();
var res2 = await MyDAL_TestDB
.Selecter <Product>()
.Where(it => it.Title.TrimStart() == "演示商品01")
.SelectOneAsync();
Assert.True(res2.Title == " 演示商品01");
/******************************************************************************************************************/
xx = string.Empty;
await PreRTrim();
var res3 = await MyDAL_TestDB
.Selecter <Product>()
.Where(it => it.Title.TrimEnd() == "演示商品01")
.SelectOneAsync();
Assert.True(res3.Title == "演示商品01 ");
/******************************************************************************************************************/
xx = string.Empty;
}
public async Task SelectM_ST()
{
xx = string.Empty;
//
var res1 = await MyDAL_TestDB
.Selecter <WechatPaymentRecord>()
.Where(it => it.Amount > 1)
.SelectPagingAsync(1, 10);
Assert.True(res1.TotalPage == 56);
xx = string.Empty;
}
public async Task Mock_TableIsHavingData_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.IsExistAsync();
Assert.True(res1);
/*****************************************************************************************/
}
public async Task Count_SpecialColumn_ST()
{
xx = string.Empty;
// count(id) like "陈%"
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.Name.Contains("陈%"))
.CountAsync(it => it.Id);
Assert.True(res1 == 1421);
xx = string.Empty;
}
public async Task Concat_None_ST()
{
xx = string.Empty;
var where = MyDAL_TestDB.Selecter <Agent>().WhereSegment;
var res1 = await where.TopAsync(1);
Assert.NotNull(res1);
xx = string.Empty;
}
public async Task DateTime_Where_yyyy()
{
var date = DateTime.Parse("2018-08-16 12:03:47.225916");
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => it.CreatedOn.ToString("yyyy") == date.ToString("yyyy"))
.SelectListAsync();
Assert.True(res1.Count == 28619);
xx = string.Empty;
}
public async Task Ture_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Agent>()
.Where(it => true) // true
.SelectListAsync();
Assert.True(res1.Count == 28620);
xx = string.Empty;
}
public async Task Not_Nullable_Bool_IsNotNull_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <Product>()
.Where(it => !(it.VipProduct != null)) // is null <-- nullable<bool>
.SelectPagingAsync(1, 10);
Assert.True(res1.Data.Count == 0);
xx = string.Empty;
}
public async Task Not_Nullable_Bool_False_ST()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <AddressInfo>()
.Where(it => !(it.IsDefault.Value == false)) // true
.SelectListAsync();
Assert.True(res1.Count == 5);
xx = string.Empty;
}
public async Task Not_Bool_False()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <AspnetUsers>()
.Where(it => !(it.RootUser == false)) // true
.SelectPagingAsync(1, 10);
Assert.True(res1.Data.Count == 1);
xx = string.Empty;
}
public async Task Bool_Default()
{
xx = string.Empty;
var res1 = await MyDAL_TestDB
.Selecter <AspnetUsers>()
.Where(it => it.RootUser) // true
.SelectPagingAsync(1, 10);
Assert.True(res1.Data.Count == 1);
xx = string.Empty;
}
