/** * 删除数据 * @param string $datalist 数据集合 */ public function Del_Form_Data($vid, $mid) { $db_form = new DbformModel(); $tables = $db_form->GetDBFormVid($vid); $Model = new Model(); $tmd = $Model->table($tables['form_table']); $result = $tmd->where('id=' . $mid)->delete(); return $result; }
/** * 通过$vid获取数据列表 */ public function GetListForVid($vid, $page_size, $where) { $dbform = new DbformModel(); $dbFormList = $dbform->GetDBFormVid($vid); //通过vid获取视图信息 $view_column = $this->GetColumnForVid($vid); //获取列头 $column = 'id'; foreach ($view_column as $key => $value) { $column .= ',' . $value['vname']; } if ($dbFormList) { $dbtable = new TableModel(); $tablelist = $dbtable->GetDataForTable($dbFormList['form_table'], $page_size, $column, $where); //传递表名、使用中文显示字段名,返回查询数据集 } return $tablelist; }