// Add or update station entity public GL_StationDTO AddOrUpdateStation(GL_StationDTO dto, out string errorMessage) { errorMessage = string.Empty; GL_Station entity = AutoMapper.Mapper.Map <GL_Station>(dto); if (entity.IsBirth == true || entity.IsOutput == true) { var entities = _stationRepository.GetMany(x => x.LineID == entity.LineID); if (entity.IsBirth == true) { foreach (var e in entities) { e.IsBirth = false; } } if (entity.IsOutput == true) { foreach (var e in entities) { e.IsOutput = false; } } } try { GL_Station entityContext; if (dto.StationID == 0) { entity.MESStationName = entity.MESStationName ?? ""; entityContext = _stationRepository.Add(entity); _unitOfWork.Commit(); } else { entityContext = _stationRepository.GetById(entity.StationID); entityContext.Seq = entity.Seq; entityContext.StationName = entity.StationName; entityContext.MESStationName = entity.MESStationName ?? ""; entityContext.CycleTime = entity.CycleTime; entityContext.IsBirth = entity.IsBirth; entityContext.IsOutput = entity.IsOutput; entityContext.IsTest = entity.IsTest; entityContext.Modified_UID = entity.Modified_UID; entityContext.Modified_Date = entity.Modified_Date; entityContext.IsEnabled = entity.IsEnabled; entityContext.DashboardTarget = entity.DashboardTarget; _stationRepository.Update(entityContext); _unitOfWork.Commit(); } var returnDto = AutoMapper.Mapper.Map <GL_StationDTO>(entityContext); return(returnDto); } catch (Exception ex) { errorMessage = ex.Message; return(null); } }
public GL_QADetectionPointDTO GetStationsDetectionPointByID(int StationID) { GL_Station Station = _stationRepository.GetById(StationID); GL_QADetectionPointDTO qADetectionPointDTO = new GL_QADetectionPointDTO(); var gGL_QADetectionPointDTO = gL_QADetectionPointRepository.GetStationsDetectionPointByID(StationID); if (gGL_QADetectionPointDTO != null) { qADetectionPointDTO = gGL_QADetectionPointDTO; } else { qADetectionPointDTO.StationID = Station.StationID; qADetectionPointDTO.StationName = Station.StationName; qADetectionPointDTO.MESStationName = Station.MESStationName; } return(qADetectionPointDTO); }
// Remove Shift Time by Id public bool RemoveStationByID(int StationID) { IQueryable <GL_Station> result = _stationRepository.GetMany( x => x.StationID == StationID); if (result.Count() > 0) { //GL_Station entity = result.First(); //entity.IsEnabled = false; //_stationRepository.Update(entity); //_unitOfWork.Commit(); //return true; GL_Station entity = result.First(); _stationRepository.Delete(entity); _unitOfWork.Commit(); return(true); } else { return(false); } }
public string AddOrUpdateGLStations(GL_StationDTO dto, bool isEdit) { string errorMessage = string.Empty; GL_Station entity = AutoMapper.Mapper.Map <GL_Station>(dto); if (entity.IsBirth == true || entity.IsOutput == true) { var entities = _stationRepository.GetMany(x => x.LineID == entity.LineID); if (entity.IsBirth == true) { foreach (var e in entities) { e.IsBirth = false; } } if (entity.IsOutput == true) { foreach (var e in entities) { e.IsOutput = false; } } } try { GL_Station entityContext; if (dto.StationID == 0) { var entities = _stationRepository.GetMany(x => x.LineID == entity.LineID && x.Binding_Seq == dto.Binding_Seq).ToList(); if (entities != null && entities.Count > 0) { return(string.Format("此线下已经有绑定序号{0}", dto.Binding_Seq)); } entity.MESStationName = entity.MESStationName ?? ""; entityContext = _stationRepository.Add(entity); _unitOfWork.Commit(); } else { entityContext = _stationRepository.GetById(entity.StationID); entityContext.Seq = entity.Seq; entityContext.StationName = entity.StationName; entityContext.MESStationName = entity.MESStationName ?? ""; entityContext.CycleTime = entity.CycleTime; entityContext.IsBirth = entity.IsBirth; entityContext.IsOutput = entity.IsOutput; entityContext.IsTest = entity.IsTest; entityContext.DashboardTarget = entity.DashboardTarget; entityContext.Binding_Seq = entity.Binding_Seq; entityContext.IsGoldenLine = entity.IsGoldenLine; entityContext.IsOEE = entity.IsOEE; entityContext.IsOne = entity.IsOne; entityContext.IsTwo = entity.IsTwo; entityContext.IsThree = entity.IsThree; entityContext.IsFour = entity.IsFour; entityContext.IsFive = entity.IsFive; entityContext.Modified_UID = entity.Modified_UID; entityContext.Modified_Date = entity.Modified_Date; entityContext.IsEnabled = dto.IsEnabled; _stationRepository.Update(entityContext); _unitOfWork.Commit(); } return("0"); } catch (Exception ex) { errorMessage = ex.Message; return(ex.Message); } }