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