| | |
| | | { |
| | | public class WorkPieceInfoManager |
| | | { |
| | | public static WorkPieceInfo GetWorkPieceInfo(string WorkPieceID) |
| | | { |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | //查询所有 |
| | | var query = db.WorkPieceInfo.Where(o => o.WorkPieceID == WorkPieceID).FirstOrDefault(); |
| | | return query; |
| | | } |
| | | } |
| | | //public static WorkPieceInfo GetWorkPieceInfo(string WorkPieceID) |
| | | //{ |
| | | // using (DbModel db = new DbModel()) |
| | | // { |
| | | // //查询所有 |
| | | // var query = db.WorkPieceInfo.Where(o => o.WorkPieceID == WorkPieceID).FirstOrDefault(); |
| | | // return query; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | public static long InsertWorkPieceInfo(WorkPieceInfo workPiece) |
| | | { |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | db.WorkPieceInfo.Add(workPiece); |
| | | db.SaveChanges(); |
| | | return workPiece.Id; |
| | | } |
| | | } |
| | | //public static long InsertWorkPieceInfo(WorkPieceInfo workPiece) |
| | | //{ |
| | | // using (DbModel db = new DbModel()) |
| | | // { |
| | | // db.WorkPieceInfo.Add(workPiece); |
| | | // db.SaveChanges(); |
| | | // return workPiece.Id; |
| | | // } |
| | | //} |
| | | |
| | | public static WorkPieceLogMiddle GetAddWorkPieceLog(WorkPieceLogMiddle loginfo) |
| | | { |
| | | loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | return loginfo; |
| | | } |
| | | //public static WorkPieceLogMiddle GetAddWorkPieceLog(WorkPieceLogMiddle loginfo) |
| | | //{ |
| | | // loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | // return loginfo; |
| | | //} |
| | | |
| | | /// <summary> |
| | | /// 给WorkPieceLog主键等公共的的属性赋值 |
| | |
| | | qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); |
| | | if (loginfo.WorkingProcedure.Equals("OP35")) |
| | | {//为了解决OP35的采集到的质量信息是OK还NOOK的情况,OP35 NOOK时更新质量信息 |
| | | loginfo2.Remarks =$"OP35NOOK原质量信息{(cur_db_info.QualityState.HasValue ? cur_db_info.QualityState.Value.ToString() : "空")}"; |
| | | loginfo2.Remarks = $"OP35NOOK原质量信息{(cur_db_info.QualityState.HasValue ? cur_db_info.QualityState.Value.ToString() : "空")}"; |
| | | cur_db_info.QualityState = (int)QualityState.NG; |
| | | if (!cur_db_info.QualityState.Equals(((int)QualityState.OK).ToString())) |
| | | { |