/**
* 是否為一門課的任課教師
*
* @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);
}
