public async Task test()
{
var xx7 = "";
var option = new AgentQueryOption();
option.Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b");
option.Name = "樊士芹";
option.OrderBys = new List <OrderBy>
{
new OrderBy
{
Field = "Name",
Desc = true
}
};
// where method -- option orderby
var res7 = await Conn
.Selecter <Agent>()
.Where(it => it.Name == "樊士芹")
.PagingListAsync(option, agent => new AgentVM
{
XXXX = agent.Name,
YYYY = agent.PathId
});
Assert.True(res7.Data.Count == 1);
var tuple7 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx8 = "";
var res8 = await Conn
.Selecter <Agent>()
.Where(it => it.CreatedOn >= WhereTest.CreatedOn)
.PagingListAsync(1, 10, agent => new AgentVM
{
XXXX = agent.Name,
YYYY = agent.PathId
});
var tuple8 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx = "";
}
public async Task test()
{
/*************************************************************************************************************************/
var xx5 = "";
var res5 = await Conn
.Joiner <Agent, AgentInventoryRecord>(out var agent5, out var record5)
.From(() => agent5)
.InnerJoin(() => record5)
.On(() => agent5.Id == record5.AgentId)
.Where(() => agent5.AgentLevel == AgentLevel.DistiAgent)
.PagingListAsync <Agent>(1, 10);
Assert.True(res5.TotalCount == 574);
/*************************************************************************************************************************/
var option6 = new AgentQueryOption();
option6.AgentLevel = AgentLevel.DistiAgent;
var xx6 = "";
var res6 = await Conn
.Joiner <Agent, AgentInventoryRecord>(out var agent6, out var record6)
.From(() => agent6)
.InnerJoin(() => record6)
.On(() => agent6.Id == record6.AgentId)
.Where(() => agent6.AgentLevel == AgentLevel.DistiAgent)
.PagingListAsync <Agent>(option6);
Assert.True(res6.TotalCount == 574);
var tuple6 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx = "";
}
public async Task test()
{
var xx6 = "";
var res6 = await Conn
.Selecter <Agent>()
.Where(it => it.CreatedOn >= WhereTest.CreatedOn)
.PagingListAsync <AgentVM>(1, 10);
var tuple6 = (XDebug.SQL, XDebug.Parameters);
var resR6 = await Conn
.Selecter <Agent>()
.Where(it => WhereTest.CreatedOn <= it.CreatedOn)
.PagingListAsync <AgentVM>(1, 10);
Assert.True(res6.TotalCount == resR6.TotalCount);
Assert.True(res6.TotalCount == 28619);
var tupleR6 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx13 = "";
var option13 = new AgentQueryOption();
var res13 = await Conn
.Selecter <Agent>()
.Where(option13.GetCondition())
.PagingListAsync <AgentVM>(option13);
Assert.True(res13.TotalCount == 28620);
Assert.True(res13.Data.Count == 10);
var tuple13 = (XDebug.SQL, XDebug.Parameters, XDebug.SqlWithParams);
/*************************************************************************************************************************/
}
public async Task WhereObjQueryOptionTest()
{
/*************************************************************************************************************************/
var xx1 = "";
// where object
var res1 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
Name = "樊士芹",
xxx = "xxx"
})
.QueryListAsync();
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx2 = "";
var option = new AgentQueryOption();
option.Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b");
option.Name = "樊士芹";
// where method
var res2 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(option.GetCondition())
.QueryPagingListAsync(option);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx3 = "";
option.OrderBys = new List <OrderBy>
{
new OrderBy
{
Field = "Name",
Desc = true
}
};
// where method -- option orderby
var res3 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(option.GetCondition())
.QueryPagingListAsync <AgentVM>(option);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx4 = "";
// where object --> no where
var res4 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.QueryListAsync();
var tuple4 = (XDebug.SQL, XDebug.Parameters);
// no where --> and or
var res41 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.And(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"))
.Or(it => it.AgentLevel == AgentLevel.DistiAgent)
.QueryListAsync();
var tuple41 = (XDebug.SQL, XDebug.Parameters);
// no where --> or and
var res42 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.Or(it => it.AgentLevel == AgentLevel.Customer)
.And(it => it.Name == "金月琴")
.QueryListAsync();
var tuple42 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx5 = "";
var option2 = new ProductQueryOption
{
VipProduct = null // true fals null
};
// where method -- option orderby
var res5 = await Conn.OpenDebug()
.Selecter <Product>()
.Where(option2.GetCondition())
.QueryPagingListAsync(option2);
var tuple5 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var option6 = new AgentQueryOption();
option6.AgentLevel = AgentLevel.DistiAgent;
var xx6 = "";
var res6 = await Conn.OpenDebug()
.Joiner <Agent, AgentInventoryRecord>(out var agent6, out var record6)
.From(() => agent6)
.InnerJoin(() => record6)
.On(() => agent6.Id == record6.AgentId)
.Where(() => agent6.AgentLevel == AgentLevel.DistiAgent)
.QueryPagingListAsync <Agent>(option6);
Assert.True(res6.TotalCount == 574);
var tuple6 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx7 = "";
// where method -- option orderby
var res7 = await Conn.OpenDebug()
.Selecter <Agent>()
//.Where(option.GetCondition())
.Where(it => it.Name == "樊士芹")
.QueryPagingListAsync(option, agent => new AgentVM
{
XXXX = agent.Name,
YYYY = agent.PathId
});
var tuple7 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx = "";
}
public async Task test()
{
/*************************************************************************************************************************/
var xx1 = "";
// where object
var res1 = await Conn
.Selecter <Agent>()
.Where(new
{
Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
Name = "樊士芹",
xxx = "xxx"
})
.ListAsync();
Assert.True(res1.Count == 1);
Assert.True(res1.First().Name == "樊士芹");
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx2 = "";
var option = new AgentQueryOption();
option.Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b");
option.Name = "樊士芹";
// where method
var res2 = await Conn
.Selecter <Agent>()
.Where(option.GetCondition())
.PagingListAsync(option);
Assert.True(res2.TotalCount == 1);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx3 = "";
option.OrderBys = new List <OrderBy>
{
new OrderBy
{
Field = "Name",
Desc = true
}
};
// where method -- option orderby
var res3 = await Conn
.Selecter <Agent>()
.Where(option.GetCondition())
.PagingListAsync <AgentVM>(option);
Assert.True(res3.TotalCount == 1);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx4 = "";
// where object --> no where
var res4 = await Conn
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.ListAsync();
Assert.True(res4.Count == 28620);
var tuple4 = (XDebug.SQL, XDebug.Parameters);
// no where --> and or
var res41 = await Conn
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.And(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"))
.Or(it => it.AgentLevel == AgentLevel.DistiAgent)
.ListAsync();
Assert.True(res41.Count == 556);
var tuple41 = (XDebug.SQL, XDebug.Parameters);
// no where --> or and
var res42 = await Conn
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.Or(it => it.AgentLevel == AgentLevel.Customer)
.And(it => it.Name == "金月琴")
.ListAsync();
Assert.True(res42.Count == 1);
var tuple42 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx5 = "";
var option2 = new ProductQueryOption
{
VipProduct = null // true fals null
};
// where method -- option orderby
var res5 = await Conn
.Selecter <Product>()
.Where(option2.GetCondition())
.PagingListAsync(option2);
Assert.True(res5.Data.Count == 4);
option2.VipProduct = false;
var res51 = await Conn
.Selecter <Product>()
.Where(option2.GetCondition())
.PagingListAsync(option2);
Assert.True(res51.Data.Count == 4);
option2.VipProduct = true;
var res52 = await Conn
.Selecter <Product>()
.Where(option2.GetCondition())
.PagingListAsync(option2);
Assert.True(res52.Data.Count == 0);
var tuple5 = (XDebug.SQL, XDebug.Parameters);
}
public async Task WhereObjQueryOptionTest()
{
var xx1 = "";
// where object
var res1 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
Name = "樊士芹",
xxx = "xxx"
})
.QueryListAsync();
var tuple1 = (XDebug.SQL, XDebug.Parameters);
var xx2 = "";
var option = new AgentQueryOption();
option.Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b");
option.Name = "樊士芹";
// where method
var res2 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(option.GetCondition())
.QueryPagingListAsync(option);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
var xx3 = "";
option.OrderBys = new List <OrderBy>
{
new OrderBy
{
Field = "Name",
Desc = true
}
};
// where method -- option orderby
var res3 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(option.GetCondition())
.QueryPagingListAsync <AgentVM>(option);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
var xx4 = "";
// where object --> no where
var res4 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.QueryListAsync();
var tuple4 = (XDebug.SQL, XDebug.Parameters);
// no where --> and or
var res41 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.And(it => it.Id == Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"))
.Or(it => it.AgentLevel == AgentLevel.DistiAgent)
.QueryListAsync();
var tuple41 = (XDebug.SQL, XDebug.Parameters);
// no where --> or and
var res42 = await Conn.OpenDebug()
.Selecter <Agent>()
.Where(new
{
//Id = Guid.Parse("000c1569-a6f7-4140-89a7-0165443b5a4b"),
//Name = "樊士芹",
xxx = "xxx"
})
.Or(it => it.AgentLevel == AgentLevel.Customer)
.And(it => it.Name == "金月琴")
.QueryListAsync();
var tuple42 = (XDebug.SQL, XDebug.Parameters);
var xx5 = "";
var option2 = new ProductQueryOption
{
VipProduct = null // true fals null
};
// where method -- option orderby
var res5 = await Conn.OpenDebug()
.Selecter <Product>()
.Where(option2.GetCondition())
.QueryPagingListAsync(option2);
var tuple5 = (XDebug.SQL, XDebug.Parameters);
var xx = "";
}
public async Task test()
{
var xx9 = "";
var res9 = await Conn
.Joiner <Agent, AgentInventoryRecord>(out var agent9, out var record9)
.From(() => agent9)
.InnerJoin(() => record9)
.On(() => agent9.Id == record9.AgentId)
.Where(() => agent9.AgentLevel == AgentLevel.DistiAgent)
.PagingListAsync(1, 10, () => new AgentVM
{
XXXX = agent9.Name,
YYYY = agent9.PathId
});
Assert.True(res9.TotalCount == 574);
var tuple9 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx10 = "";
var option10 = new AgentQueryOption();
option10.AgentLevel = AgentLevel.DistiAgent;
var res10 = await Conn
.Joiner <Agent, AgentInventoryRecord>(out var agent10, out var record10)
.From(() => agent10)
.InnerJoin(() => record10)
.On(() => agent10.Id == record10.AgentId)
.Where(() => agent10.AgentLevel == AgentLevel.DistiAgent)
.PagingListAsync(option10, () => new AgentVM
{
XXXX = agent10.Name,
YYYY = agent10.PathId
});
Assert.True(res10.TotalCount == 574);
var tuple10 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
var xx11 = "";
var option11 = new AgentQueryOption();
option11.AgentLevel = AgentLevel.DistiAgent;
option11.PageIndex = 5;
option11.PageSize = 10;
var res11 = await Conn
.Joiner <Agent, AgentInventoryRecord>(out var agent11, out var record11)
.From(() => agent11)
.InnerJoin(() => record11)
.On(() => agent11.Id == record11.AgentId)
.Where(() => agent11.AgentLevel == AgentLevel.DistiAgent)
.PagingListAsync(option11, () => new AgentVM
{
XXXX = agent11.Name,
YYYY = agent11.PathId
});
Assert.True(res11.TotalCount == 574);
Assert.True(res11.PageSize == 10);
Assert.True(res11.PageIndex == 5);
Assert.True(res11.Data.Count == 10);
var tuple11 = (XDebug.SQL, XDebug.Parameters);
/*************************************************************************************************************************/
}
public async Task test()
{
/*****************************************************************************************************************************/
var xx1 = "";
var option1 = new AgentQueryOption();
option1.StartTime = WhereTest.CreatedOn;
option1.EndTime = DateTime.Now;
option1.AgentLevel = AgentLevel.DistiAgent;
// = >= <=
var res1 = await Conn
.Selecter <Agent>()
.Where(option1)
.ListAsync();
Assert.True(res1.Count == 555);
var tuple1 = (XDebug.SQL, XDebug.Parameters);
/*****************************************************************************************************************************/
var xx2 = "";
var option2 = new AgentQueryOption();
option2.StartTime = WhereTest.CreatedOn;
option2.EndTime = DateTime.Now;
// >= <=
var res2 = await Conn
.Selecter <Agent>()
.Where(option2)
.ListAsync();
Assert.True(res2.Count == 28619);
var tuple2 = (XDebug.SQL, XDebug.Parameters);
/*****************************************************************************************************************************/
var xx3 = "";
var option3 = new AgentQueryOption();
option3.Name = "张";
// like
var res3 = await Conn
.Selecter <Agent>()
.Where(option3)
.ListAsync();
Assert.True(res3.Count == 2002);
var tuple3 = (XDebug.SQL, XDebug.Parameters);
/*****************************************************************************************************************************/
var xx4 = "";
var option4 = new AgentQueryOption();
option4.EnumListIn = new List <AgentLevel>
{
AgentLevel.CityAgent,
AgentLevel.DistiAgent
};
// in
var res4 = await Conn
.Selecter <Agent>()
.Where(option4)
.ListAsync();
Assert.True(res4.Count == 555);
var tuple4 = (XDebug.SQL, XDebug.Parameters, XDebug.SqlWithParams);
/*****************************************************************************************************************************/
var xx5 = "";
var option5 = new AgentQueryOption();
option5.EnumListNotIn = new List <AgentLevel>
{
AgentLevel.CityAgent,
AgentLevel.DistiAgent
};
// in
var res5 = await Conn
.Selecter <Agent>()
.Where(option5)
.ListAsync();
Assert.True(res5.Count == 28064 || res5.Count == 28065);
var tuple5 = (XDebug.SQL, XDebug.Parameters, XDebug.SqlWithParams);
/*****************************************************************************************************************************/
var xx = "";
}
