public DataTable LoadAll()
{
int iResult = 1;
DataCollections col = new DataCollections("V_" + TABLE_NAME);
col.Add(DataTypes.NVarchar, "*", FieldTypes.DefaultValue, "", "");
return(dao.DoQuery(col, ref iResult));
}
public DataTable selectEnable()
{
int iResult = 1;
DataCollections _col = new DataCollections(TABLE_NAME);
_col.Add(DataTypes.NVarchar, "*", FieldTypes.DefaultValue, "", "");
_col.Add(DataTypes.Number, "IsEnable", FieldTypes.Criterion, 1, "=");
return(dao.DoQuery(_col, ref iResult));
}
//public DataTable LoadAll()
//{
// int iResult = 1;
// DataCollections col = new DataCollections("V_" + TABLE_NAME);
// col.Add(DataTypes.NVarchar, "*", FieldTypes.DefaultValue, "", "");
// return dao.DoQuery(col, ref iResult);
//}
public DataTable LoadByContestID(long id)
{
int iResult = 1;
DataCollections col = new DataCollections(TABLE_NAME);
col.Add(DataTypes.Number, "ProblemsId", FieldTypes.DefaultValue, ProblemsId, "");
if (id > 0)
{
col.Add(DataTypes.Number, "ContestsId", FieldTypes.Criterion, id, "=");
}
return(dao.DoQuery(col, ref iResult));
}
public DataTable LoadByStatus(String p_Proj_Status)
{
int iResult = 1;
DataCollections col = new DataCollections("V_FMS_B_PROJECT");
col.Add(DataTypes.NVarchar, "*", FieldTypes.DefaultValue, "", "");
if (p_Proj_Status.Trim() != "")
{
col.Add(DataTypes.NVarchar, "status", FieldTypes.Criterion, p_Proj_Status, "LIKE");
}
col.ORDERBY = "ORDER BY PROJECT_NAME";
return(dao.DoQuery(col, ref iResult));
}