public DataTable getDataSource(int DataSourceID) { iQuery = new QueryBuilder(QueryType._Select).AddField("*", "s_DataSource") .AddWhere(0, "s_DataSource", "DataSourceID", FieldType._Text, Operator._Equal, DataSourceID.ToString(), Condition._None); dtResult = rd.ExecuteQuery(iQuery).GetResult; return(dtResult); }
public DataTable GetLookUpItems(int pClientID, int pLookUpID) { dtResult = new DataTable(); Query selectQ = new QueryBuilder(QueryType._Select).AddTable("vw_lookupitem").AddField("*", "vw_lookupitem"). AddWhere(0, "vw_lookupitem", "ClientID", FieldType._Number, Operator._Equal, pClientID.ToString(), Condition._And). AddWhere(0, "vw_lookupitem", "LookUpID", FieldType._Number, Operator._Equal, pLookUpID.ToString()); dtResult = rd.ExecuteQuery(selectQ).GetResult; return(dtResult); }
public DataTable GetProcedure(int procedureID) { dtResult = new DataTable(); Query iQuery = new QueryBuilder(QueryType._Select) .AddField("ProcedureID", "s_entity_procedure") .AddField("Name", "s_entity_procedure") .AddField("Steps", "s_entity_procedure") .AddField("datasourcekey", "s_entity_procedure"); dtResult = rd.ExecuteQuery(iQuery).GetResult; return(dtResult); }
public DataTable GetJob(int JobID) { iQuery = new QueryBuilder(QueryType._Select) .AddField("jobid", "s_entityjob", FieldType._Number, "") .AddField("datasourcekey", "s_entityjob", FieldType._String, "") .AddField("name", "s_entityjob", FieldType._String, "") .AddField("description", "s_entityjob", FieldType._String, "") .AddField("steps", "s_entityjob", FieldType._String, "") .AddField("jobstartdate", "s_entityjob", FieldType._DateTime, "") .AddField("jobtime", "s_entityjob", FieldType._DateTime, "") .AddField("currentschedule", "s_entityjob", FieldType._DateTime, "") .AddField("type", "s_entityjob", FieldType._Number, "") .AddField("status", "s_entityjob", FieldType._Number, ""); dtResult = rd.ExecuteQuery(iQuery).GetResult; return(dtResult); }
public int Save(string Name, string inputParam, string outputParam, string steps) { int NextID = rd.getNextID("Function"); Query iQuery = new QueryBuilder(QueryType._Insert ).AddTable("s_entity_function") .AddField("FunctionID", "s_entity_function", FieldType._Number, "", NextID.ToString()) .AddField("Name", "s_entity_function", FieldType._String, "", Name.ToString()) .AddField("Inputparam", "s_entity_function", FieldType._String, "", inputParam.ToString()) .AddField("Outputparam", "s_entity_function", FieldType._String, "", outputParam.ToString()) .AddField("Steps", "s_entity_function", FieldType._String, "", steps.ToString()) .AddField("LastUPD", "s_entity_function", FieldType._DateTime, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(NextID); } else { return(-1); } }
public int Save(string Name, int entityKey, TechSharpy.Entitifier.Core.ActionType type, TechSharpy.Entitifier.Core.EventType eventType, string steps) { int NextID = rd.getNextID("Trigger"); Query iQuery = new QueryBuilder(QueryType._Insert ).AddTable("s_entity_trigger") .AddField("TriggerID", "s_entity_trigger", FieldType._Number, "", NextID.ToString()) .AddField("Name", "s_entity_trigger", FieldType._String, "", Name.ToString()) .AddField("entityKey", "s_entity_trigger", FieldType._String, "", entityKey.ToString()) .AddField("Actiontype", "s_entity_trigger", FieldType._String, "", type.ToString()) .AddField("eventType", "s_entity_trigger", FieldType._String, "", eventType.ToString()) .AddField("LastUPD", "s_entity_trigger", FieldType._DateTime, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(NextID); } else { return(-1); } }
public int Save(int formComponentID, string name, string code, string description, string category) { var nextid = rd.getNextID("form"); iQuery = new QueryBuilder(QueryType._Insert) .AddField("FormID", "s_form", FieldType._Number, "", nextid.ToString()) .AddField("Name", "s_form", FieldType._String, "", name.ToString()) .AddField("code", "s_form", FieldType._String, "", code.ToString()) .AddField("Description", "s_form", FieldType._String, "", description.ToString()) .AddField("Category", "s_form", FieldType._String, "", category.ToString()) .AddField("FormComponentID", "s_form", FieldType._Number, "", formComponentID.ToString()) .AddField("LastUPD", "s_form", FieldType._DateTime, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(nextid); } else { return(-1); } }
public int Save(int formID, int elementtype, string title, string code, int mode, string elementattribute , int componentid) { int nextid = rd.getNextID("formelement"); iQuery = new QueryBuilder(QueryType._Insert) .AddField("elementid", "s_formelement", FieldType._Number, "", nextid.ToString()) .AddField("formID", "s_formelement", FieldType._Number, "", formID.ToString()) .AddField("elementtype", "s_formelement", FieldType._Number, "", elementtype.ToString()) .AddField("title", "s_formelement", FieldType._String, "", title.ToString()) .AddField("code", "s_formelement", FieldType._String, "", code.ToString()) .AddField("Mode", "s_formelement", FieldType._Number, "", mode.ToString()) .AddField("componentid", "s_formelement", FieldType._Number, "", componentid.ToString()) .AddField("elementattribute", "s_formelement", FieldType._Text, "", elementattribute) .AddField("LastUPD", "s_form", FieldType._DateTime, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(nextid); } else { return(-1); } }
public int SaveAction(int pEntitykey, int pActionType, bool pIsInclude, string pActionName, string pActionSchema) { int NextID = rd.getNextID("Action"); Query iQuery = new QueryBuilder(QueryType._Insert ).AddTable("s_entity_action") .AddField("ActionID", "s_entity_action", FieldType._Number, "", NextID.ToString()) .AddField("ActionName", "s_entity_action", FieldType._String, "", pActionName.ToString()) .AddField("ActionType", "s_entity_action", FieldType._String, "", pActionType.ToString()) .AddField("ActionSchema", "s_entity_action", FieldType._String, "", pActionSchema.ToString()) .AddField("entityKey", "s_entity_action", FieldType._String, "", pEntitykey.ToString()) .AddField("ActionDate", "s_entity_action", FieldType._String, "", DateTime.Now.ToString()) .AddField("IsInclude", "s_entity_action", FieldType._Question, "", pIsInclude.ToString()) .AddField("lastUPD", "s_entity_action", FieldType._Question, "", DateTime.Now.ToString()); if (rd.ExecuteQuery(iQuery).Result) { return(NextID); } else { return(-1); } }
public DataTable GetNodeByEntityKey(int entitykey, int modelID) { iQuery = new QueryBuilder(QueryType._Select) .AddField("left", "s_EntityModelNode") .AddField("right", "s_EntityModelNode") .AddField("NodeID", "s_EntityModelNode") .AddField("depth", "s_EntityModelNode") .AddField("nodekey", "s_EntityModelNode") .AddField("entitykey", "s_EntityModelNode") .AddWhere(0, "s_EntityModelNode", "Entitykey", FieldType._Number, entitykey.ToString(), Condition._And) .AddWhere(0, "s_EntityModelNode", "modelID", FieldType._Number, modelID.ToString()); return(rd.ExecuteQuery(iQuery).GetResult); }
public DataTable GetEntityList(int ClientID) { dtResult = new DataTable(); //dtResult.Pivot("",""); Query selectQ = new QueryBuilder(QueryType._Select).AddTable("s_entity").AddField("*", "s_entity"). AddWhere(0, "s_entity", "ClientID", FieldType._Number, Operator._Equal, ClientID.ToString()); dtResult = rd.ExecuteQuery(selectQ).GetResult; return(dtResult); }