| | |
|---|
| | | { |
|---|
| | | return Db.Queryable<SysMaterials>() |
|---|
| | | .LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id) |
|---|
| | | .LeftJoin<SysPackag>((a, b,c) => a.PackagNo == c.PackagNo) |
|---|
| | | .Where((a,b,c) => c.IsDel == "0") |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo)) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(skuName), a => a.SkuNo.Contains(skuName)) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(auditStatusNo), a => a.AuditStatusNo == auditStatusNo) |
|---|
| | |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(environment), a => a.Environment == environment) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(categoryNo), a => a.CategoryNo == categoryNo) |
|---|
| | | .Where(a => a.IsDel == "0") |
|---|
| | | .Select<MaterialsDto>((a, b) => new MaterialsDto() { CreateUserName = b.RealName }, true) |
|---|
| | | .Select<MaterialsDto>((a, b, c) => new MaterialsDto() { CreateUserName = b.RealName,PackagName = c.PackagName }, true) |
|---|
| | | .ToListAsync(); |
|---|
| | | } |
|---|
| | | |
|---|
