public bool Update(int pClientID, Int64 pEntityID, string pTableName, string Name, string pDescription, string keys, TechSharpy.Entitifier.Core.EntityType pType) { Query iQuery = new QueryBuilder(QueryType._Update ).AddTable("s_entity") .AddField("Description", "s_entity", FieldType._String, "", pDescription.ToString()) .AddField("Name", "s_entity", FieldType._String, "", Name.ToString()) .AddField("Keys", "s_entity", FieldType._String, "", keys.ToString()) .AddField("TableName", "s_entity", FieldType._String, "", pTableName.ToString()) .AddField("Description", "s_entity", FieldType._String, "", pDescription.ToString()) .AddField("Type", "s_entity", FieldType._Number, "", Convert.ToInt32(pType).ToString()) // .AddField("ClientID", "s_entity", FieldType._Number, "", pClientID.ToString()) .AddField("lastUpD", "s_entity", FieldType._DateTime, "", DateTime.Now.ToString()) .AddWhere(0, "s_entity", "ClientID", FieldType._Number, Operator._Equal, pClientID.ToString()). AddWhere(0, "s_entity", "EntityID", FieldType._Number, Operator._Equal, pEntityID.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(true); } else { return(false); } }
/// <summary> /// /// </summary> /// <param name="entityType"></param> public EntitySchema(EntityType entityType) { this.Name = ""; this.Description = ""; EntityType = entityType; EntityKey = -1; dataEntity = new Data.EntitySchema(); EntityInstances = new List <EntityField>(); PrimaryKeys = new List <string>(); Errors = new Services.ErrorHandling.ErrorInfoCollection(); Triggers = new List <Trigger>(); }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="description"></param> /// <param name="entityType"></param> /// <param name="entityKey"></param> /// <param name="tableName"></param> /// <param name="primaryKeys"></param> public EntitySchema(string name, string description, EntityType entityType, int entityKey, string tableName, List <string> primaryKeys) { Description = description; Name = name; EntityType = entityType; EntityKey = entityKey; TableName = tableName; PrimaryKeys = primaryKeys; IsShow = true; dataEntity = new Data.EntitySchema(); EntityInstances = new List <EntityField>(); Triggers = new List <Trigger>(); Errors = new Services.ErrorHandling.ErrorInfoCollection(); }
/// <summary> /// Load EntitySchema /// </summary> internal protected void Init() { DataTable dt = new DataTable(); dt = dataEntity.GetEntity(-1, EntityKey); var e = dt.AsEnumerable().Select(g => new EntitySchema { EntityKey = g.IsNull("EntityID") ? 0 : g.Field <int>("EntityID"), Name = g.IsNull("Name") ? "" : g.Field <string>("Name"), TableName = g.IsNull("TableName") ? "" : g.Field <string>("TableName"), PrimaryKeys = g.IsNull("Keys") ? new List <string>() : g.Field <string>("Keys").Split(',').ToList(), Description = g.IsNull("Description") ? "" : g.Field <string>("Description"), EntityType = g.IsNull("Type") ? EntityType._Master : g.Field <EntityType>("Type") }).First(); this.EntityKey = e.EntityKey; this.Name = e.Name; this.TableName = e.TableName; this.EntityType = e.EntityType; this.Description = e.Description; this.PrimaryKeys = e.PrimaryKeys; InitField(); // InitTrigger(); }
public int Save(int pClientID, string pTableName, string Name, string pDescription, string keys, TechSharpy.Entitifier.Core.EntityType pType) { int NextID = rd.getNextID("Entity"); Query iQuery = new QueryBuilder(QueryType._Insert ).AddTable("s_entity") .AddField("EntityID", "s_entity", FieldType._Number, "", NextID.ToString()) .AddField("Name", "s_entity", FieldType._String, "", Name.ToString()) .AddField("Keys", "s_entity", FieldType._String, "", keys.ToString()) .AddField("TableName", "s_entity", FieldType._String, "", pTableName.ToString()) .AddField("Description", "s_entity", FieldType._String, "", pDescription.ToString()) .AddField("Type", "s_entity", FieldType._Number, "", Convert.ToInt32(pType).ToString()) .AddField("ClientID", "s_entity", FieldType._Number, "", pClientID.ToString()) .AddField("LastUPD", "s_entity", FieldType._DateTime, "", DateTime.Now.ToString()); if ((rd.ExecuteQuery(iQuery).Result)) { return(NextID); } else { return(-1); } }