public int Save(SteelCAMDrawing CAMDrawing) { bool _isnew = false; SteelCAMDrawing _dbEntry = null; if (CAMDrawing.SteelCAMDrawingID == 0) { _isnew = true; _context.SteelCAMDrawngs.Add(CAMDrawing); } else { _dbEntry = _context.SteelCAMDrawngs.Find(CAMDrawing.SteelCAMDrawingID); if (_dbEntry != null) { _dbEntry.FullPartName = CAMDrawing.FullPartName; _dbEntry.DrawName = CAMDrawing.DrawName; _dbEntry.DrawREV = CAMDrawing.DrawREV; _dbEntry.CADPartName = CAMDrawing.CADPartName; _dbEntry.MoldName = CAMDrawing.MoldName; _dbEntry.CreateDate = CAMDrawing.CreateDate; _dbEntry.DrawLock = CAMDrawing.DrawLock; _dbEntry.LastestFlag = CAMDrawing.LastestFlag; _dbEntry.NCID = CAMDrawing.NCID; _dbEntry.Programmer = CAMDrawing.Programmer; _dbEntry.IssuePerson = CAMDrawing.IssuePerson; _dbEntry.IssueDate = CAMDrawing.IssueDate; _dbEntry.Undo_person = CAMDrawing.Undo_person; _dbEntry.Undo_date = CAMDrawing.Undo_date; _dbEntry.Delete_time = CAMDrawing.Delete_time; _dbEntry.Delete_person = CAMDrawing.Delete_person; _dbEntry.active = CAMDrawing.active; _dbEntry.QCPoint = CAMDrawing.QCPoint; } } _context.SaveChanges(); if (_isnew) { return(CAMDrawing.SteelCAMDrawingID); } else { try { return(_dbEntry.SteelCAMDrawingID); } catch { return(-1); } } }
public SteelCAMDrawing QueryByNCID(int NCID) { SteelCAMDrawing _steelCAMDrawing = _context.SteelCAMDrawngs.Where(s => s.NCID == NCID).FirstOrDefault(); return(_steelCAMDrawing); }