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