private static void Demo2(SqlSugarClient db)
{
var list = db.Queryable <OrderItem>().ToList();
var query1 = db.Queryable <Order>();
var queryable2 = db.Reportable(list).ToQueryable();
var x = db.Queryable(query1, queryable2, (x1, x2) => x1.Id.Equals(x2.OrderId))
.Select((x1, x2) => new { name = x1.Name, id = x1.Id, orderid = x2.OrderId }).ToList();
}
private static void Demo1(SqlSugarClient db)
{
var list = new List <int>()
{
1, 2, 3, 1, 2
};
var query1 = db.Queryable <Order>();
var queryable2 = db.Reportable(list).ToQueryable <int>();
var x = db.Queryable(query1, queryable2, (x1, x2) => x1.Id.Equals(x2.ColumnName))
.Select((x1, x2) => new { x = x1.Id, x2 = x2.ColumnName }).ToList();
}
private static void Demo3(SqlSugarClient db)
{
db.CodeFirst.InitTables <operateinfo>();
db.Deleteable <operateinfo>().ExecuteCommand();
db.Insertable(new operateinfo()
{
id = 1,
operate_type = 1,
operate_time = Convert.ToDateTime("2021-1-1")
}).ExecuteCommand();
db.Insertable(new operateinfo()
{
id = 1,
operate_type = 1,
operate_time = Convert.ToDateTime("2021-1-2")
}).ExecuteCommand();
db.Insertable(new operateinfo()
{
id = 1,
operate_type = 1,
operate_time = Convert.ToDateTime("2021-3-1")
}).ExecuteCommand();
db.Insertable(new operateinfo()
{
id = 1,
operate_type = 1,
operate_time = Convert.ToDateTime("2021-3-2")
}).ExecuteCommand();
db.Insertable(new operateinfo()
{
id = 1,
operate_type = 1,
operate_time = Convert.ToDateTime("2021-4-2")
}).ExecuteCommand();
var queryableLeft = db.Reportable(ReportableDateType.MonthsInLast1years).ToQueryable <DateTime>();
var queryableRight = db.Queryable <operateinfo>();
var list = db.Queryable(queryableLeft, queryableRight, JoinType.Left,
(x1, x2) => x2.operate_time.ToString("yyyy-MM") == x1.ColumnName.ToString("yyyy-MM"))
.GroupBy((x1, x2) => x1.ColumnName)
.Where(x1 => SqlFunc.Between(x1.ColumnName, "2021-01-01", DateTime.Now))
.Select((x1, x2) => new
{
count = SqlFunc.AggregateSum(SqlFunc.IIF(x2.id > 0, 1, 0)),
date = x1.ColumnName.ToString("yyyy-MM")
}).ToList();
}