| | |
| | | .WhereIF(input.PackageNum>0, u => u.PackageNum == input.PackageNum) |
| | | .WhereIF(input.UnLinePackageNum>0, u => u.UnLinePackageNum == input.UnLinePackageNum) |
| | | .WhereIF(input.NoUnLinePackageNum>0, u => u.NoUnLinePackageNum == input.NoUnLinePackageNum) |
| | | .WhereIF(input.NgPackageNum>0, u => u.NgPackageNum == input.NgPackageNum) |
| | | .Select<Mes_Order_GatherOutput>(); |
| | | if(input.UnlineTimeRange != null && input.UnlineTimeRange.Count >0) |
| | | { |
| | | DateTime? start= input.UnlineTimeRange[0].Value.AddDays(-1); |
| | | query = query.WhereIF(start.HasValue, u => u.UnlineTime > start); |
| | | DateTime? start= input.UnlineTimeRange[0].Value; |
| | | query = query.WhereIF(start.HasValue, u => u.UnlineTime >= start); |
| | | if (input.UnlineTimeRange.Count >1 && input.UnlineTimeRange[1].HasValue) |
| | | { |
| | | var end = input.UnlineTimeRange[1].Value.AddDays(1); |
| | | query = query.Where(u => u.UnlineTime < end); |
| | | var end = input.UnlineTimeRange[1].Value; |
| | | query = query.Where(u => u.UnlineTime <= end); |
| | | } |
| | | } |
| | | return query; |