public Result PostUsuallyDictionary([FromBody] UsuallyDictionary usuallyDictionary)
{
usuallyDictionary.CreateUserId = Request.GetIdentityInformation();
usuallyDictionary.MarkedDateTime = DateTime.Now;
UsuallyDictionaryHelper.Instance.Add(usuallyDictionary);
RedisHelper.PublishToTable(UsuallyDictionaryHelper.Instance.Table);
return(Result.GenError <Result>(Error.Success));
}
public Result PostUsuallyDictionary([FromBody] UsuallyDictionary usuallyDictionary)
{
usuallyDictionary.CreateUserId = Request.GetIdentityInformation();
usuallyDictionary.MarkedDateTime = DateTime.Now;
ServerConfig.DeviceDb.Execute(
"INSERT INTO data_name_dictionary (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `ScriptId`, `VariableTypeId`, `PointerAddress`, `VariableName`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @ScriptId, @VariableTypeId, @PointerAddress, @VariableName);",
usuallyDictionary);
ServerConfig.RedisHelper.PublishToTable();
return(Result.GenError <Result>(Error.Success));
}
public Result PutUsuallyDictionary([FromRoute] int id, [FromBody] UsuallyDictionary usuallyDictionary)
{
var cnt = UsuallyDictionaryHelper.Instance.GetCountById(id);
if (cnt == 0)
{
return(Result.GenError <Result>(Error.UsuallyDictionaryNotExist));
}
usuallyDictionary.Id = id;
usuallyDictionary.CreateUserId = Request.GetIdentityInformation();
usuallyDictionary.MarkedDateTime = DateTime.Now;
UsuallyDictionaryHelper.Instance.Add(usuallyDictionary);
RedisHelper.PublishToTable(UsuallyDictionaryHelper.Instance.Table);
return(Result.GenError <Result>(Error.Success));
}
public Result PutUsuallyDictionary([FromRoute] int id, [FromBody] UsuallyDictionary usuallyDictionary)
{
var cnt =
ServerConfig.DeviceDb.Query <int>("SELECT COUNT(1) FROM `usually_dictionary` WHERE Id = @id AND `MarkedDelete` = 0;", new { id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.UsuallyDictionaryNotExist));
}
usuallyDictionary.Id = id;
usuallyDictionary.CreateUserId = Request.GetIdentityInformation();
usuallyDictionary.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 WHERE `Id` = @Id;", usuallyDictionary);
ServerConfig.RedisHelper.PublishToTable();
return(Result.GenError <Result>(Error.Success));
}
public Result PostUsuallyDictionaryType([FromBody] UsuallyDictionaryTypeDetail usuallyDictionaryType)
{
var cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `usually_dictionary_type` WHERE VariableName = @VariableName;", new { usuallyDictionaryType.VariableName }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.UsuallyDictionaryTypeIsExist));
}
cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `variable_type` WHERE Id = @id AND `MarkedDelete` = 0;", new { id = usuallyDictionaryType.VariableTypeId }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.VariableTypeNotExist));
}
var createUserId = Request.GetIdentityInformation();
usuallyDictionaryType.CreateUserId = createUserId;
usuallyDictionaryType.MarkedDateTime = DateTime.Now;
var index = UsuallyDictionaryTypeHelper.Instance.AddBackId(usuallyDictionaryType);
var usuallyDictionary = new UsuallyDictionary
{
CreateUserId = createUserId,
MarkedDateTime = DateTime.Now,
ScriptId = 0,
VariableNameId = index,
DictionaryId = usuallyDictionaryType.DictionaryId,
VariableTypeId = usuallyDictionaryType.VariableTypeId,
};
UsuallyDictionaryHelper.Instance.Add(usuallyDictionary);
RedisHelper.PublishToTable(UsuallyDictionaryHelper.Instance.Table);
return(Result.GenError <Result>(Error.Success));
}
