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