dotnetcore / dotnetcore/FreeSql
多表联查后怎么返回一个新的对象呢
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
var query = freeSql.Select()
.WhereIf(req.JobId > 0, a => a.Id == req.JobId)
.WhereIf(req.ProcessId > 0, a => a.ProcessId == req.ProcessId)
.WhereIf(!string.IsNullOrEmpty(req.JobName), a => a.JobName.Contains(req.JobName))
.WhereIf(!string.IsNullOrEmpty(req.Enable), a => a.Enable == req.Enable)
.OrderByDescending(a => a.UpdateTime)
.LeftJoin((rpaScheduleInfo, rpaProcessInfo) =>
rpaScheduleInfo.ProcessId == rpaProcessInfo.Id)
.Select((a, b) => new RpaProcessJobReq
{
JobId = a.Id,
JobName = a.JobName,
CronExpression = a.CronExpression,
CronDesc = a.CronDesc,
CronType = a.CronType,
Mark = a.Mark,
Enable = a.Enable,
ConflictChoose = a.ConflictChoose,
ProcessId = a.ProcessId,
CreateTime = a.CreateTime,
UpdateTime = a.UpdateTime,
ProcessName = b.ProcessName,
VersionNum = b.VersionNum,
PublishDirAddress = b.PublishDirAddress,
ProcessDesc = b.ProcessDesc,
VersionDesc = b.VersionDesc
})
.Page(req.PageNum, req.PageSize)
.ToList();
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.