public Result PostFirmwareLibrary([FromBody] FirmwareLibrary firmwareLibrary)
{
firmwareLibrary.CreateUserId = Request.GetIdentityInformation();
firmwareLibrary.MarkedDateTime = DateTime.Now;
ServerConfig.DeviceDb.Execute(
"INSERT INTO firmware_library (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `FirmwareName`, `VarNumber`, `CommunicationProtocol`, `FilePath`, `Description`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @FirmwareName, @VarNumber, @CommunicationProtocol, @FilePath, @Description);",
firmwareLibrary);
return(Result.GenError <Result>(Error.Success));
}
public Result PutFirmwareLibrary([FromRoute] int id, [FromBody] FirmwareLibrary firmwareLibrary)
{
var cnt =
ServerConfig.DeviceDb.Query <int>("SELECT COUNT(1) FROM `firmware_library` WHERE Id = @id AND `MarkedDelete` = 0;", new { id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.FirmwareLibraryNotExist));
}
firmwareLibrary.Id = id;
firmwareLibrary.CreateUserId = Request.GetIdentityInformation();
firmwareLibrary.MarkedDateTime = DateTime.Now;
ServerConfig.DeviceDb.Execute(
"UPDATE firmware_library SET `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, `ModifyId` = @ModifyId, " +
"`FirmwareName` = @FirmwareName, `VarNumber` = @VarNumber, `CommunicationProtocol` = @CommunicationProtocol, `FilePath` = @FilePath, `Description` = " +
"@Description WHERE `Id` = @Id;", firmwareLibrary);
return(Result.GenError <Result>(Error.Success));
}
