/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $cstFieldValidators = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from cst_field_validator"; Sql::splice($sql, CstFieldValidatorDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $cstFieldValidator = new CstFieldValidator(); $cstFieldValidator->setId($row['id']); $cstFieldValidator->setFieldId($row['field_id']); $cstFieldValidator->setValidatorId($row['validator_id']); array_push($cstFieldValidators, $cstFieldValidator); } $stmt->closeCursor(); return $cstFieldValidators; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $cstKlasss = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from cst_klass"; Sql::splice($sql, CstKlassDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $cstKlass = new CstKlass(); $cstKlass->setId($row['id']); $cstKlass->setTble($row['tble']); $cstKlass->setKlass($row['klass']); $cstKlass->setLabel($row['label']); array_push($cstKlasss, $cstKlass); } $stmt->closeCursor(); return $cstKlasss; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $tmpProjects = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from tmp_project"; Sql::splice($sql, TmpProjectDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $tmpProject = new TmpProject(); $tmpProject->setId($row['id']); $tmpProject->setName($row['name']); $tmpProject->setCreateTime($row['create_time']); $tmpProject->setUpdateTime($row['update_time']); array_push($tmpProjects, $tmpProject); } $stmt->closeCursor(); return $tmpProjects; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $metaTables = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from meta_table"; Sql::splice($sql, MetaTableDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $metaTable = new MetaTable(); $metaTable->setId($row['id']); $metaTable->setDatabaseId($row['database_id']); $metaTable->setDatabaseName($row['database_name']); $metaTable->setName($row['name']); $metaTable->setKeyId($row['key_id']); $metaTable->setKeyName($row['key_name']); array_push($metaTables, $metaTable); } $stmt->closeCursor(); return $metaTables; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $metaFields = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from meta_field"; Sql::splice($sql, MetaFieldDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $metaField = new MetaField(); $metaField->setId($row['id']); $metaField->setDatabaseId($row['database_id']); $metaField->setDatabaseName($row['database_name']); $metaField->setKlassId($row['klass_id']); $metaField->setKlassName($row['klass_name']); $metaField->setLabel($row['label']); $metaField->setName($row['name']); $metaField->setType($row['type']); $metaField->setShortType($row['short_type']); $metaField->setGetter($row['getter']); $metaField->setSetter($row['setter']); $metaField->setColumnId($row['column_id']); $metaField->setColumnName($row['column_name']); $metaField->setWidth($row['width']); $metaField->setLength($row['length']); $metaField->setIsKey($row['is_key']); $metaField->setIsCondition($row['is_condition']); $metaField->setIsRequired($row['is_required']); $metaField->setIsRemote($row['is_remote']); $metaField->setValidators($row['validators']); $metaField->setInputType($row['input_type']); array_push($metaFields, $metaField); } $stmt->closeCursor(); return $metaFields; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $metaColumns = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from meta_column"; Sql::splice($sql, MetaColumnDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $metaColumn = new MetaColumn(); $metaColumn->setId($row['id']); $metaColumn->setDatabaseId($row['database_id']); $metaColumn->setDatabaseName($row['database_name']); $metaColumn->setTableId($row['table_id']); $metaColumn->setTableName($row['table_name']); $metaColumn->setName($row['name']); $metaColumn->setType($row['type']); $metaColumn->setComment($row['comment']); $metaColumn->setIsKey($row['is_key']); array_push($metaColumns, $metaColumn); } $stmt->closeCursor(); return $metaColumns; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $tmpDataTemplates = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from tmp_data_template"; Sql::splice($sql, TmpDataTemplateDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $tmpDataTemplate = new TmpDataTemplate(); $tmpDataTemplate->setId($row['id']); $tmpDataTemplate->setDatabaseId($row['database_id']); $tmpDataTemplate->setDatabaseName($row['database_name']); $tmpDataTemplate->setTableId($row['table_id']); $tmpDataTemplate->setTableName($row['table_name']); $tmpDataTemplate->setName($row['name']); $tmpDataTemplate->setMode($row['mode']); $tmpDataTemplate->setContent($row['content']); $tmpDataTemplate->setCreateTime($row['create_time']); $tmpDataTemplate->setUpdateTime($row['update_time']); array_push($tmpDataTemplates, $tmpDataTemplate); } $stmt->closeCursor(); return $tmpDataTemplates; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $cstFields = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from cst_field"; Sql::splice($sql, CstFieldDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $cstField = new CstField(); $cstField->setId($row['id']); $cstField->setClmn($row['clmn']); $cstField->setField($row['field']); $cstField->setLabel($row['label']); $cstField->setType($row['type']); $cstField->setWidth($row['width']); $cstField->setLength($row['length']); $cstField->setIsCondition($row['is_condition']); $cstField->setIsRequired($row['is_required']); $cstField->setIsRemote($row['is_remote']); array_push($cstFields, $cstField); } $stmt->closeCursor(); return $cstFields; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $metaDatabases = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from meta_database"; Sql::splice($sql, MetaDatabaseDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $metaDatabase = new MetaDatabase(); $metaDatabase->setId($row['id']); $metaDatabase->setName($row['name']); $metaDatabase->setUrl($row['url']); $metaDatabase->setUsername($row['username']); $metaDatabase->setPassword($row['password']); $metaDatabase->setType($row['type']); $metaDatabase->setCreater($row['creater']); $metaDatabase->setUpdater($row['updater']); $metaDatabase->setCreateTime($row['create_time']); $metaDatabase->setUpdateTime($row['update_time']); array_push($metaDatabases, $metaDatabase); } $stmt->closeCursor(); return $metaDatabases; }
/** * 查询记录集 * @return array */ static function results($query = null) { $pdo = Database::pdo(); $basAttachments = array(); $params = $query->getParameters(); $ops = $query->getOperators(); $sql = "select * from bas_attachment"; Sql::splice($sql, BasAttachmentDao::$fields, $params, $ops); Sql::addtion($sql, $query); $stmt = $pdo->prepare($sql); Sql::params($stmt, $params); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $basAttachment = new BasAttachment(); $basAttachment->setId($row['id']); $basAttachment->setModule($row['module']); $basAttachment->setType($row['type']); $basAttachment->setName($row['name']); $basAttachment->setMime($row['mime']); $basAttachment->setSuffix($row['suffix']); $basAttachment->setPath($row['path']); $basAttachment->setAbsolutePath($row['absolute_path']); $basAttachment->setData($row['data']); $basAttachment->setStatus($row['status']); $basAttachment->setCreater($row['creater']); $basAttachment->setUpdater($row['updater']); $basAttachment->setCreateTime($row['create_time']); $basAttachment->setUpdateTime($row['update_time']); array_push($basAttachments, $basAttachment); } $stmt->closeCursor(); return $basAttachments; }