/** * 是否為一門課的任課教師 * * @return */ public boolean Dtime_techid(String Dtime_oid, String techid) { if (dataFinder.sqlGetInt( "SELECT COUNT(*)FROM Dtime WHERE techid='" + techid + "' AND Oid=" + Dtime_oid) > 0) { return true; } return false; }
/** * 依日期查詢當日應到人數 * * @param Dtime_oid * @param date * @return */ public int DilgLog_date_due(String Dtime_oid, String date) { return dataFinder.sqlGetInt( "SELECT due FROM DilgLog WHERE date='" + date + "' AND Dtime_oid=" + Dtime_oid); }
/** * 依課程查詢選課人數 * * @param Dtime_oid * @return */ public int Seld_count(String Dtime_oid) { return dataFinder.sqlGetInt( "SELECT COUNT(*)FROM Seld WHERE status IS NULL AND Dtime_oid=" + Dtime_oid); }