| | |
|---|
| | | /// <returns></returns> |
|---|
| | | public Task<List<MaterialsDto>> GetMateList(string skuNo, string skuName, string auditStatusNo, string type, string isControlled, string isInspect, string environment, string categoryNo) |
|---|
| | | { |
|---|
| | | return Db.Queryable<SysMaterials>() |
|---|
| | | var DA = Db.Queryable<SysMaterials>() |
|---|
| | | .LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id) |
|---|
| | | .LeftJoin<SysPackag>((a, b,c) => a.PackagNo == c.PackagNo) |
|---|
| | | .LeftJoin<SysUnit> ((a,b,c,d)=>a.UnitNo == d.UnitNo) |
|---|
| | | .LeftJoin<SysMaterialCategory>((a,b,c,d,e)=>a.CategoryNo == e.CategoryNo) |
|---|
| | | .Where((a,b,c,d,e) => d.IsDel == "0" && e.IsDel =="0") |
|---|
| | | //.LeftJoin<SysUnit> ((a,b,c,d)=>a.UnitNo == d.UnitNo) |
|---|
| | | .LeftJoin<SysMaterialCategory>((a,b,c,d)=>a.CategoryNo == d.CategoryNo) |
|---|
| | | .Where((a,b,c,d) => a.IsDel == "0" && d.IsDel == "0" ) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo)) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(skuName), a => a.SkuName.Contains(skuName)) |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(auditStatusNo), a => a.AuditStatusNo == auditStatusNo) |
|---|
| | |
|---|
| | | .WhereIF(!string.IsNullOrEmpty(isInspect), a => a.IsInspect == isInspect) |
|---|
| | | .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, c,d,e) => new MaterialsDto() { CreateUserName = b.RealName,PackagName = c.PackagName }, true) |
|---|
| | | .Select<MaterialsDto>((a, b, c,d) => new MaterialsDto() { CreateUserName = b.RealName,PackagName = c.PackagName }, true) |
|---|
| | | .ToListAsync(); |
|---|
| | | return DA; |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
