public int Save(int pClientID, string pName, bool pIsCore, bool haveChild, TechSharpy.Entitifier.Core.LookUpType lookupType)
{
int NextID = rd.getNextID("LookUp");
Query iQuery = new QueryBuilder(QueryType._Insert
).AddTable("s_entitylookup")
.AddField("LookUpID", "s_entitylookup", FieldType._Number, "", NextID.ToString())
.AddField("LookUpName", "s_entitylookup", FieldType._String, "", pName.ToString())
.AddField("IsCore", "s_entitylookup", FieldType._Question, "", pIsCore.ToString())
.AddField("HaveChild", "s_entitylookup", FieldType._Question, "", haveChild.ToString())
.AddField("ClientID", "s_entitylookup", FieldType._Number, "", pClientID.ToString())
.AddField("LookUpType", "s_entitylookup", FieldType._Number, "", ((int)lookupType).ToString())
.AddField("LastUPD", "s_entitylookup", FieldType._DateTime, "", DateTime.Now.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(NextID);
}
else
{
return(-1);
}
}
public bool Save(int pClientID, int pLookUpId, string pName, bool pIsCore, bool haveChild, TechSharpy.Entitifier.Core.LookUpType lookupType)
{
Query iQuery = new QueryBuilder(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", "ClientID", FieldType._Number, Operator._Equal, pClientID.ToString(), Condition._And).
AddWhere(0, "s_entitylookup", "LookUpID", FieldType._Number, Operator._Equal, pLookUpId.ToString());
//AddWhere(0, "s_entitylookup", "LookUpId", FieldType._Number, Operator._Equal, pLookUpId.ToString());
if (rd.ExecuteQuery(iQuery).Result)
{
return(true);
}
else
{
return(false);
}
}
