protected internal DataTable GetClientAttribute(int clientID, string componentID) { string[] cid = componentID.Split(','); List <DBClause> cids = new List <DBClause>(); for (int i = 0; i < cid.Length; i++) { cids.Add(DBConst.String(cid[i])); } DBComparison client = DBComparison.Equal(DBField.Field(TalentozSchemaClientInfo.ClientID.Name), DBConst.Int32(clientID)); DBComparison comp = DBComparison.In(DBField.Field(TalentozSchemaClientInfo.ComponentID.Name), cids.ToArray()); DBQuery select = DBQuery.SelectAll().From(TalentozSchemaClientInfo.Table).WhereAll(client, comp); return(db.GetDatatable(select)); }
protected internal DataTable GetComponents(string compID) { string[] cid = compID.Split(','); List <DBClause> cids = new List <DBClause>(); for (int i = 0; i < cid.Length; i++) { cids.Add(DBConst.String(cid[i])); } DBComparison comp = DBComparison.In(DBField.Field(TalentozSchema.ComponentID.Name), cids.ToArray()); //DBComparison tb = DBComparison.Equal(DBField.Field(TalentozSchema.TableName.Name), DBConst.String(compID)); //DBComparison cname = DBComparison.Equal(DBField.Field(TalentozSchema.ComponentName.Name), DBConst.String(compID)); DBQuery select = DBQuery.SelectAll().From(TalentozSchema.Table).WhereAny(comp).OrderBy(TalentozSchema.ComponentName.Name, Order.Ascending); return(db.GetDatatable(select)); }
public static DataTable GetLookup(int clientID, string FieldInstanceIDs, string conn) { DataBase db = new DataBase(); db.InitDbs(conn); List <DBClause> items = new List <DBClause>(); var fids = FieldInstanceIDs.Split(','); foreach (string itm in fids) { items.Add(DBConst.Const(itm)); } DBQuery select; DBComparison client = DBComparison.Equal(DBField.Field("ClientID"), DBConst.Int32(clientID)); DBComparison fieldinstance = DBComparison.In(DBField.Field("FieldInstanceID"), items.ToArray()); DBConst dbclientid = DBConst.String("ClientID"); select = DBQuery.SelectAll("sys_FieldInstanceLookUp").From("sys_FieldInstanceLookUp") .WhereAll(client, fieldinstance); return(db.Database.GetDatatable(select)); }