public Result PostApplicationLibrary([FromBody] ApplicationLibrary processLibrary) { processLibrary.CreateUserId = Request.GetIdentityInformation(); processLibrary.MarkedDateTime = DateTime.Now; ServerConfig.DeviceDb.Execute( "INSERT INTO application_library (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `ApplicationName`, `FilePath`, `Description`) " + "VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @ApplicationName, @FilePath, @Description);", processLibrary); return(Result.GenError <Result>(Error.Success)); }
public Result PutApplicationLibrary([FromRoute] int id, [FromBody] ApplicationLibrary processLibrary) { var cnt = ServerConfig.DeviceDb.Query <int>("SELECT COUNT(1) FROM `application_library` WHERE Id = @id AND `MarkedDelete` = 0;", new { id }).FirstOrDefault(); if (cnt == 0) { return(Result.GenError <Result>(Error.ApplicationLibraryNotExist)); } processLibrary.Id = id; processLibrary.CreateUserId = Request.GetIdentityInformation(); processLibrary.MarkedDateTime = DateTime.Now; ServerConfig.DeviceDb.Execute( "UPDATE application_library SET `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, `ModifyId` = @ModifyId, " + "`ApplicationName` = @ApplicationName, `FilePath` = @FilePath, `Description` = @Description WHERE `Id` = @Id;", processLibrary); return(Result.GenError <Result>(Error.Success)); }