| | |
| | | { |
| | | public class MeasurementUnitResultManager : ModelManager<MeasurementUnitResult> |
| | | { |
| | | DbProviderFactory Dbfactory = SQLiteFactory.Instance; |
| | | //DbProviderFactory Dbfactory = SQLiteFactory.Instance; |
| | | protected override void ActionBeforeNewModel(DBModel context, MeasurementUnitResult config) |
| | | { |
| | | CheckProductionCodeDuplicate(context, config); |
| | |
| | | { |
| | | } |
| | | |
| | | public List<MeasurementUnitResult_DTO> GetMeasurementUnitResult(MeasurementUnitResultRequest request) |
| | | public List<MeasurementUnitResult> GetMeasurementUnitResult(MeasurementUnitResultRequest request) |
| | | { |
| | | using (DBModel context = new DBModel()) |
| | | { |
| | |
| | | } |
| | | if (!string.IsNullOrWhiteSpace(request.MeasurementResult)) |
| | | { |
| | | mList = mList.Where(u => u.MeasurementResult==request.MeasurementResult); |
| | | mList = mList.Where(u => u.MeasurementResult == request.MeasurementResult); |
| | | } |
| | | if (!string.IsNullOrWhiteSpace(request.MeasurementType)) |
| | | { |
| | |
| | | join measurementUnitResult in mList |
| | | on productionMeasurementRecords.ID equals measurementUnitResult.ProductionMeasurementRecordsId |
| | | //into pmList |
| | | select new MeasurementUnitResult_DTO |
| | | select new MeasurementUnitResult |
| | | { |
| | | ProductionCode = productionMeasurementRecords.ProductionCode, |
| | | ProductionBarcode = productionMeasurementRecords.ProductionBarcode |
| | | |
| | | }; |
| | | var pageList = query.OrderBy(u => u.CREATE_TIME).ToPagedList(request); |
| | | request.TotalNum = mList.Count(); |