public QCPointProgram QueryByPart3D(string ELE3DName, int Version)
{
QCPointProgram _program = _context.QCPointPrograms
.Where(p => p.Part3D == ELE3DName)
.Where(p => p.Rev == Version)
.FirstOrDefault();
return(null);
}
/// <summary>
/// PR_AddOrUpdateQCPointProgram
/// </summary>
/// <param name="QCProgram"></param>
/// <returns></returns>
public bool SaveQCPointProgram(QCPointProgram QCProgram)
{
string _url = "/Task/SaveQCPointProgram";
try
{
string _id = _server.SendObject(_url, "QCPointProgram", QCProgram);
return(true);
}
catch
{
return(false);
}
}
public int Save(QCPointProgram QCPointProgram)
{
bool _newItem = false;
QCPointProgram _dbEntry = null;
if (QCPointProgram.QCPointProgramID == 0)
{
_dbEntry = _context.QCPointPrograms.Where(q => q.ElectrodeName == QCPointProgram.ElectrodeName)
.Where(q => q.Rev == QCPointProgram.Rev).Where(q => q.Enabled == QCPointProgram.Enabled).FirstOrDefault();
if (_dbEntry == null)
{
_newItem = true;
QCPointProgram.CreateDate = DateTime.Now;
_context.QCPointPrograms.Add(QCPointProgram);
}
else
{
_dbEntry.ElectrodeName = QCPointProgram.ElectrodeName;
_dbEntry.Rev = QCPointProgram.Rev;
_dbEntry.LatestFlat = QCPointProgram.LatestFlat;
_dbEntry.Clearance = QCPointProgram.Clearance;
_dbEntry.X = QCPointProgram.X;
_dbEntry.Y = QCPointProgram.Y;
_dbEntry.PartPath = QCPointProgram.PartPath;
_dbEntry.XYZFlieName = QCPointProgram.XYZFlieName;
_dbEntry.PartName3D = QCPointProgram.PartName3D;
_dbEntry.Part3D = QCPointProgram.Part3D;
_dbEntry.Part3DRev = QCPointProgram.Part3DRev;
_dbEntry.CreateBy = QCPointProgram.CreateBy;
_dbEntry.CreateDate = DateTime.Now;
_dbEntry.CreateComputer = QCPointProgram.CreateComputer;
_dbEntry.Enabled = QCPointProgram.Enabled;
_dbEntry.OldID = QCPointProgram.OldID;
}
}
else
{
_dbEntry = _context.QCPointPrograms.Find(QCPointProgram.QCPointProgramID);
_dbEntry.ElectrodeName = QCPointProgram.ElectrodeName;
_dbEntry.Rev = QCPointProgram.Rev;
_dbEntry.LatestFlat = QCPointProgram.LatestFlat;
_dbEntry.Clearance = QCPointProgram.Clearance;
_dbEntry.X = QCPointProgram.X;
_dbEntry.Y = QCPointProgram.Y;
_dbEntry.PartPath = QCPointProgram.PartPath;
_dbEntry.XYZFlieName = QCPointProgram.XYZFlieName;
_dbEntry.PartName3D = QCPointProgram.PartName3D;
_dbEntry.Part3D = QCPointProgram.Part3D;
_dbEntry.Part3DRev = QCPointProgram.Part3DRev;
_dbEntry.CreateBy = QCPointProgram.CreateBy;
_dbEntry.CreateDate = DateTime.Now;
_dbEntry.CreateComputer = QCPointProgram.CreateComputer;
_dbEntry.Enabled = QCPointProgram.Enabled;
_dbEntry.OldID = QCPointProgram.OldID;
}
_context.SaveChanges();
if (_newItem)
{
return(QCPointProgram.QCPointProgramID);
}
else
{
return(_dbEntry.QCPointProgramID);
}
}
