// 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);
}
}
