MyK3CloudCore.IOC 2023.7.28.1619

1.切换账套配置查询

// 默认配置文件第一个账套
var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>().ToListAsync();
// 切换到config2账套
res = await K3Scoped.GetClient("config2").Queryable<SAL_SaleOrder>().ToListAsync();

2.条件查询

var result = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .Where(t=>t.FBillNo=="XSDD0001")
                .ToListAsync();
// 复杂一点的
string[] FDepts = new string[] { "04", "06", "07", "08", "09", "10", "11" };
Expression<Func<STK_OutStockApply, bool>> t = t => t.FDate > DateTime.Parse("2023-07-10") && t.FDate < DateTime.Parse("2023-07-14");
t = t.AndFilter(t => t.FDocumentStatus == "C");
t = t.AndFilter(t => FDepts.Contains(t.FDeptId__FNumber));
var result = await K3Scoped.Client.Queryable<STK_OutStockApply>()
            .Where(t)
            .ToPageAsync();

3.查询某列

var result = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .Where(t=>t.FBillNo=="XSDD0001")
                .Select(t => new { t.FBillNo })
                .ToListAsync();
var result = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .Where(t=>t.FBillNo=="XSDD0001")
                .Select(t => new { t.FBillNo, t.FCUSTIDFName, t.FMaterialId, t.FQty })
                .ToListAsync();

4.排序

var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .OrderBy(u => new { u.FId, u.FQty }, new[] { OrderType.Descending, OrderType.Ascending })
                .ToListAsync();

5.分页

var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .ToPageListAsync(page, limit);
// 返回查询数据总条数
Refasync<int> total = 0;
var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .ToPageListAsync(page, limit, total);
// 自定义统计返回条数字段（total返回不准确跟字段有关，需要自己定义）
var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>()
                .ToPageListAsync(page, limit, t => t.FMaterialId_FNumber, total);

6.汇总

var sumData = await K3Scoped.Client.Queryable<SAL_SaleOrder>().SumAsync(t => t.FQty );
var sumData = await K3Scoped.Client.Queryable<SAL_SaleOrder>().SumAsync(t => new { t.FQty, t.FStockOutQty, t.FRemainOutQty });

7.计数

var total = await K3Scoped.Client.Queryable<SAL_SaleOrder>().CountAsync(u => u.FMaterialName);

8.缓存

var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>().WithCache().ToListAsync();
// 缓存60秒
var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>().WithCache(60).ToListAsync();
// 自定义缓存键
var res = await K3Scoped.Client.Queryable<SAL_SaleOrder>().WithCache("{EA97F979-5B45-4EFA-95D1-6208F8323308}").ToListAsync();