internal static List <FProbRelationBLL> getAllRelation()
{
//"SELECT * FROM SystemRelation", "system_relation")
List <FProbRelationBLL> relations = new List <FProbRelationBLL>();
DataBase db = new DataBase();
DataSet dts = new DataSet();
dts.Tables.Add(db.GetDataTable("SELECT * FROM SystemRelation", "system_relation"));
try
{
foreach (DataRow row in dts.Tables["system_relation"].Rows)
{
string relationname = row[1].ToString();
int schemeID = Convert.ToInt16(row[2]);
FProbSchemaBLL schemeName = new FProbSchemaBLL(schemeID).getSchemeById();
List <FProbTupleBLL> probTuples = new List <FProbTupleBLL>();
int nTriples = schemeName.FproAttributes.Count;
probTuples = new FProbTupleBLL().getAllTypleByRelationName(relationname, nTriples);
FProbRelationBLL relation = new FProbRelationBLL(Convert.ToInt16(row[0]), relationname, probTuples, schemeName);
relations.Add(relation);
}
return(relations);
}
catch
{
return(null);
}
}
internal static List <FProbTupleBLL> getAllTypleByRelationName(string relationname, int nTriples)
{
List <FProbTupleBLL> probTuple = new List <FProbTupleBLL>();
DataBase db = new DataBase();
DataTable dtb = db.GetDataTable("Select * From " + relationname);
foreach (DataRow tuplerow in dtb.Rows)
{
FProbTupleBLL NewTuple = new FProbTupleBLL();
for (int i = 0; i < nTriples; i++)
{
FProbTripleBLL NewTriple = new FProbTripleBLL(tuplerow[i].ToString());
NewTuple.FproTriples.Add(NewTriple);
}
probTuple.Add(NewTuple);
}
return(probTuple);
}
