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