static function GetTotalMoney($filter) { $sql = "SELECT SUM(Amount) AS TotalMoney FROM detail "; $sql .= $filter->GetWhereClauseCommand(); $result = CDataManager::ExercuseQuery($sql); $first_row = mysql_fetch_array($result); return $first_row['TotalMoney']; }
static function DropTable() { $sql = "DROP TABLE IF EXISTS setting"; return CDataManager::ExercuseQuery($sql); }