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