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