public EntitySchema(EntityType entityType)
{
EntityType = entityType;
EntityKey = -1;
dataEntity = new Data.EntitySchema();
PrimaryKeys = new List <string>();
}
public bool Update(int pClientID, Int64 pEntityID, string pTableName, string Name, string pDescription, string keys,
TechSharpy.Entitifier.EntityType pType)
{
Query iQuery = new Query(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 (this.ExecuteQuery(iQuery) > 0)
{
return(true);
}
else
{
return(false);
}
}
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();
}
/// <summary>
/// Load EntitySchema
/// </summary>
public void Init()
{
DataTable dt = new DataTable();
dt = dataEntity.GetEntity(-1, this.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") ? "" : g.Field <string>("Keys"),
Description = g.IsNull("Description") ? "" : g.Field <string>("Description"),
EntityType = g.IsNull("Type") ? EntityType._Master : g.Field <EntityType>("Type")
}).First();
this.EntityKey = e.EntityID;
this.Name = e.Name;
this.TableName = e.TableName;
this.EntityType = e.Type;
this.Description = e.Description;
this.PrimaryKeys = e.Keys;
InitField();
}
public int Save(int pClientID, string pTableName, string Name, string pDescription, string keys, TechSharpy.Entitifier.EntityType pType)
{
int NextID = this.getNextID("Entity");
Query iQuery = new Query(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 (this.ExecuteQuery(iQuery) > 0)
{
return(NextID);
}
else
{
return(-1);
}
}
