public int Save(int pClientID, string pName, bool pIsCore, bool haveChild, Entitifier.LookUpType lookupType)
{
int NextID = this.getNextID("LookUp");
Query iQuery = new Query(QueryType._Insert
).AddTable("s_entitylookup")
.AddField("LookUpID", "s_entitylookup", FieldType._Number, "", NextID.ToString())
.AddField("Name", "s_entitylookup", FieldType._String, "", pName.ToString())
.AddField("IsCore", "s_entitylookup", FieldType._Question, "", pIsCore.ToString())
.AddField("HaveChild", "s_entitylookup", FieldType._Question, "", pIsCore.ToString())
.AddField("ClientID", "s_entitylookup", FieldType._Number, "", pClientID.ToString())
.AddField("LookUpType", "s_entitylookup", FieldType._Number, "", lookupType.ToString())
.AddField("LastUPD", "s_entitylookup", FieldType._DateTime, "", DateTime.Now.ToString());
if (this.ExecuteQuery(iQuery) > 0)
{
return(NextID);
}
else
{
return(-1);
}
}
public bool Save(int pClientID, int pLookUpId, string pName, bool pIsCore, bool haveChild, Entitifier.LookUpType lookupType)
{
Query iQuery = new Query(QueryType._Update
).AddTable("s_entitylookup")
.AddField("LookUpName", "s_entitylookup", FieldType._String, "", pName.ToString())
.AddField("IsCore", "s_entitylookup", FieldType._String, "", pIsCore.ToString())
.AddField("HaveChild", "s_entitylookup", FieldType._String, "", haveChild.ToString())
.AddField("LookUpType", "s_entitylookup", FieldType._Number, "", lookupType.ToString())
.AddField("lastUpD", "s_entitylookup", FieldType._DateTime, "", DateTime.Now.ToString())
.AddWhere(0, "s_entitylookup", "ClientID", FieldType._Number, Operator._Equal, pClientID.ToString()).
AddWhere(0, "s_entitylookup", "LookUpId", FieldType._Number, Operator._Equal, pLookUpId.ToString());
if (this.ExecuteQuery(iQuery) > 0)
{
return(true);
}
else
{
return(false);
}
}
