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