public Result PostDataNameDictionary([FromBody] DataNameDictionary dataNameDictionary)
{
dataNameDictionary.CreateUserId = Request.GetIdentityInformation();
dataNameDictionary.MarkedDateTime = DateTime.Now;
DataNameDictionaryHelper.Instance.Add(dataNameDictionary);
//CheckScriptVersion(dataNameDictionary.ScriptId);
return(Result.GenError <Result>(Error.Success));
}
public Result PostDataNameDictionary([FromBody] DataNameDictionary dataNameDictionary)
{
dataNameDictionary.CreateUserId = Request.GetIdentityInformation();
dataNameDictionary.MarkedDateTime = DateTime.Now;
ServerConfig.DeviceDb.Execute(
"INSERT INTO data_name_dictionary (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `ScriptId`, `VariableTypeId`, `PointerAddress`, `VariableName`, `Remark`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @ScriptId, @VariableTypeId, @PointerAddress, @VariableName, @Remark);",
dataNameDictionary);
CheckScriptVersion(dataNameDictionary.ScriptId);
return(Result.GenError <Result>(Error.Success));
}
public Result PutDataNameDictionary([FromRoute] int id, [FromBody] DataNameDictionary dataNameDictionary)
{
var cnt =
ServerConfig.DeviceDb.Query <int>("SELECT COUNT(1) FROM `data_name_dictionary` WHERE Id = @id AND `MarkedDelete` = 0;", new { id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.DataNameDictionaryNotExist));
}
dataNameDictionary.Id = id;
dataNameDictionary.CreateUserId = Request.GetIdentityInformation();
dataNameDictionary.MarkedDateTime = DateTime.Now;
ServerConfig.DeviceDb.Execute(
"UPDATE data_name_dictionary SET `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, `ModifyId` = @ModifyId, " +
"`ScriptId` = @ScriptId, `VariableTypeId` = @VariableTypeId, `PointerAddress` = @PointerAddress, `VariableName` = @VariableName, `Remark` = @Remark WHERE `Id` = @Id;", dataNameDictionary);
return(Result.GenError <Result>(Error.Success));
}
