| | |
| | | { |
| | | } |
| | | |
| | | public List<MeasurementUnitResult> GetMeasurementUnitResult(MeasurementUnitResultRequest request) |
| | | public List<MeasurementUnitResult_DTO> GetMeasurementUnitResult(MeasurementUnitResultRequest request) |
| | | { |
| | | using (DBModel context = new DBModel()) |
| | | { |
| | |
| | | join measurementUnitResult in mList |
| | | on productionMeasurementRecords.ID equals measurementUnitResult.ProductionMeasurementRecordsId |
| | | //into pmList |
| | | select new MeasurementUnitResult |
| | | select new MeasurementUnitResult_DTO |
| | | { |
| | | ProductionCode = productionMeasurementRecords.ProductionCode, |
| | | ProductionBarcode = productionMeasurementRecords.ProductionBarcode |
| | | ProductionBarcode = productionMeasurementRecords.ProductionBarcode, |
| | | ProductionMeasurementRecordsId = productionMeasurementRecords.ID, |
| | | OperationStartTime= productionMeasurementRecords.OperationStartTime, |
| | | OperationEndTime = productionMeasurementRecords.OperationEndTime, |
| | | |
| | | Id= measurementUnitResult.ID, |
| | | MeasurementName= measurementUnitResult.MeasurementName, |
| | | MeasurementType = measurementUnitResult.MeasurementType, |
| | | MeasurementValue = measurementUnitResult.MeasurementValue, |
| | | MeasurementResult = measurementUnitResult.MeasurementResult |
| | | }; |
| | | var pageList = query.OrderBy(u => u.CREATE_TIME).ToPagedList(request); |
| | | var pageList = query.OrderBy(u => u.OperationStartTime).ToPagedList(request); |
| | | request.TotalNum = mList.Count(); |
| | | return pageList; |
| | | } |