public bool Save(int triggerID, string Name, int entityKey, TechSharpy.Entitifier.Core.ActionType type, TechSharpy.Entitifier.Core.EventType eventType, string steps) { Query iQuery = new QueryBuilder(QueryType._Update ).AddTable("s_entity_trigger") .AddField("Name", "s_entity_trigger", FieldType._String, "", Name.ToString()) .AddField("entityKey", "s_entity_trigger", FieldType._Number, "", entityKey.ToString()) .AddField("Actiontype", "s_entity_trigger", FieldType._Number, "", type.ToString()) .AddField("eventType", "s_entity_trigger", FieldType._Number, "", eventType.ToString()) .AddField("steps", "s_entity_trigger", FieldType._String, "", steps.ToString()) .AddField("LastUPD", "s_entity_trigger", FieldType._DateTime, "", DateTime.Now.ToString()) .AddWhere(0, "s_entity_trigger", "TriggerID", FieldType._Number, Operator._Equal, triggerID.ToString(), Condition._None); if (rd.ExecuteQuery(iQuery).Result) { return(true); } else { return(false); } }
public int Save(string Name, int entityKey, TechSharpy.Entitifier.Core.ActionType type, TechSharpy.Entitifier.Core.EventType eventType, string steps) { int NextID = rd.getNextID("Trigger"); Query iQuery = new QueryBuilder(QueryType._Insert ).AddTable("s_entity_trigger") .AddField("TriggerID", "s_entity_trigger", FieldType._Number, "", NextID.ToString()) .AddField("Name", "s_entity_trigger", FieldType._String, "", Name.ToString()) .AddField("entityKey", "s_entity_trigger", FieldType._String, "", entityKey.ToString()) .AddField("Actiontype", "s_entity_trigger", FieldType._String, "", type.ToString()) .AddField("eventType", "s_entity_trigger", FieldType._String, "", eventType.ToString()) .AddField("LastUPD", "s_entity_trigger", FieldType._DateTime, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(NextID); } else { return(-1); } }