public int AddDeviceWorkRecord(DeviceWorkRecord model) { int result = 0; try { //string sql = GetInsertSql(model); _context.DeviceWorkRecords.Add(model); result = _context.SaveChanges(); } catch (Exception ex) { Console.WriteLine($"AddDeviceWorkRecord出错:{ex.Message}"); } return(result); }
public JsonResult EditDeviceWorkRecord(int id, DeviceEnum deviceName, string productionLine, OBTStationNameEnum stationName, string description, string createDate, string submitPerson) { string device = DataProcess.GetEnumName(deviceName); string station = DataProcess.GetEnumName(stationName); DeviceWorkRecord model = new DeviceWorkRecord { Id = id, DeviceName = device, CraftName = createDate, StationName = station, Description = description, CreateDate = createDate, SubmitPerson = submitPerson }; int result = _repository.EditDeviceWorkRecord(model); int code = 0; if (result > 0) { code = 0; } else { code = 1; } var json = new { code = code }; return(Json(json)); }
public JsonResult AddDeviceWorkRecord(DeviceEnum deviceName, string productionLine, OBTStationNameEnum stationName, string description, string createDate, string submitPerson) { string device = DataProcess.GetEnumName(deviceName); string station = DataProcess.GetEnumName(stationName); int maxId = _repository.GetDeviceWorkRecords().Max(item => item.Id); DeviceWorkRecord record = new DeviceWorkRecord { Id = maxId + 1, DeviceName = device, CraftName = productionLine, StationName = station, Description = description, CreateDate = createDate, SubmitPerson = submitPerson }; int result = _repository.AddDeviceWorkRecord(record); int code = 0; if (result > 0) { code = 0; } else { code = 1; } var json = new { code = code }; return(Json(json)); }
public int EditDeviceWorkRecord(DeviceWorkRecord model) { int result = 0; try { var record = _context.DeviceWorkRecords .Where(item => item.Id == model.Id).ToList()[0]; record.DeviceName = model.DeviceName; record.CraftName = model.CraftName; record.StationName = model.StationName; record.Description = model.Description; record.CreateDate = model.CreateDate; record.SubmitPerson = model.SubmitPerson; result = _context.SaveChanges(); } catch (Exception ex) { Console.WriteLine($"DelDeviceWorkRecord出错:{ex.Message}"); } return(result); }