PHP Grid::GetDataset方法代码示例

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $Grid->GetDataset()->Open();
     while ($Grid->GetDataset()->Next()) {
         $rowValues = $Grid->GetDataset()->GetCurrentFieldValues();
         $Row = array();
         foreach ($Grid->GetExportColumns() as $column) {
             $Row[$this->PrepareColumnCaptionForXml($column->GetCaption())] = $this->RenderViewColumn($column, $rowValues);
         }
         $Rows[] = $Row;
     }
     $this->DisplayTemplate('export/xml_grid.tpl', array('Grid' => $Grid), array('Rows' => $Rows, 'TableName' => $Grid->GetPage()->GetCaption()));
 }

 function RenderGrid(Grid $grid)
 {
     $hiddenValues = array(OPERATION_PARAMNAME => OPERATION_COMMIT);
     AddPrimaryKeyParametersToArray($hiddenValues, $grid->GetDataset()->GetPrimaryKeyValues());
     $template = $grid->GetPage()->GetCustomTemplate(PagePart::VerticalGrid, PageMode::Edit, 'edit/grid.tpl');
     $this->DisplayTemplate($template, array('Grid' => $grid->GetEditViewData($this)), array('Authentication' => $grid->GetPage()->GetAuthenticationViewData(), 'HiddenValues' => $hiddenValues));
 }

 function RenderGrid(Grid $Grid)
 {
     $primaryKeyMap = array();
     $Grid->GetDataset()->Open();
     $Row = array();
     $hiddenValues = '';
     if ($Grid->GetDataset()->Next()) {
         foreach ($Grid->GetSingleRecordViewColumns() as $column) {
             $Row[] = $this->Render($column);
         }
         $hiddenValues = array(OPERATION_PARAMNAME => OPERATION_COMMIT_DELETE);
         AddPrimaryKeyParametersToArray($hiddenValues, $Grid->GetDataset()->GetPrimaryKeyValues());
         $primaryKeyMap = $Grid->GetDataset()->GetPrimaryKeyValuesMap();
     }
     $this->DisplayTemplate('delete/grid.tpl', array('Grid' => $Grid, 'Columns' => $Grid->GetSingleRecordViewColumns()), array('Title' => $Grid->GetPage()->GetShortCaption(), 'PrimaryKeyMap' => $primaryKeyMap, 'ColumnCount' => count($Grid->GetSingleRecordViewColumns()), 'Row' => $Row, 'HiddenValues' => $hiddenValues));
 }

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $Grid->GetDataset()->Open();
     while ($Grid->GetDataset()->Next()) {
         $rowValues = $Grid->GetDataset()->GetCurrentFieldValues();
         $Rows[] = Q::ToArray(Q::Select($Grid->GetPrintColumns(), Q::L('$c => $_1->RenderViewColumn($c, $_2)', $this, $rowValues)));
     }
     $totals = array();
     if ($Grid->HasTotals()) {
         $totalValues = $Grid->GetTotalValues();
         foreach ($Grid->GetPrintColumns() as $column) {
             $totals[] = $column->GetTotalPresentationData(ArrayUtils::GetArrayValueDef($totalValues, $column->GetName(), null));
         }
     }
     $this->DisplayTemplate('print/grid.tpl', array('Grid' => $Grid), array('Columns' => $Grid->GetPrintColumns(), 'Rows' => $Rows, 'Totals' => $totals));
 }

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $HeaderCaptions = array();
     $Grid->GetDataset()->Open();
     foreach ($Grid->GetExportColumns() as $Column) {
         $HeaderCaptions[] = $Column->GetCaption();
     }
     while ($Grid->GetDataset()->Next()) {
         $rowValues = $Grid->GetDataset()->GetCurrentFieldValues();
         $Row = array();
         foreach ($Grid->GetExportColumns() as $Column) {
             $Row[] = htmlspecialchars($this->RenderViewColumn($Column, $rowValues));
         }
         $Rows[] = $Row;
     }
     $this->DisplayTemplate('export/csv_grid.tpl', array('Grid' => $Grid), array('HeaderCaptions' => $HeaderCaptions, 'Rows' => $Rows));
 }

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $HeaderCaptions = array();
     $Grid->GetDataset()->Open();
     foreach ($Grid->GetExportColumns() as $Column) {
         $HeaderCaptions[] = $Column->GetCaption();
     }
     while ($Grid->GetDataset()->Next()) {
         $rowValues = $Grid->GetDataset()->GetCurrentFieldValues();
         $Row = array();
         foreach ($Grid->GetExportColumns() as $Column) {
             $Row[] = StringUtils::EscapeString($this->RenderViewColumn($Column, $rowValues), $Column->GetGrid()->GetPage()->GetContentEncoding());
         }
         $Rows[] = $Row;
     }
     $this->DisplayTemplate('export/csv_grid.tpl', array('Grid' => $Grid), array('HeaderCaptions' => $HeaderCaptions, 'Rows' => $Rows));
 }

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $HeaderCaptions = array();
     $Grid->GetDataset()->Open();
     foreach ($Grid->GetExportColumns() as $Column) {
         $HeaderCaptions[] = $this->PrepareForExcel($Column->GetCaption());
     }
     while ($Grid->GetDataset()->Next()) {
         $rowValues = $Grid->GetDataset()->GetCurrentFieldValues();
         $Row = array();
         foreach ($Grid->GetExportColumns() as $Column) {
             $cell['Value'] = $this->PrepareForExcel($this->RenderViewColumn($Column, $rowValues));
             $cell['Align'] = $Column->GetAlign();
             $Row[] = $cell;
         }
         $Rows[] = $Row;
     }
     $this->DisplayTemplate('export/excel_grid.tpl', array('Grid' => $Grid), array('HeaderCaptions' => $HeaderCaptions, 'Rows' => $Rows));
 }

 public final function ProcessMessages()
 {
     $storageProperty = $this->GetStorageProperty();
     if ($this->superGlobals->IsPostValueSet($storageProperty) || $this->superGlobals->IsSessionVariableSet($this->parentGrid->GetId() . $storageProperty)) {
         if ($this->superGlobals->IsPostValueSet($storageProperty)) {
             $filterJson = $this->superGlobals->GetPostValue($storageProperty);
         } else {
             $filterJson = $this->superGlobals->GetSessionVariable($this->parentGrid->GetId() . $storageProperty);
         }
         $this->filter->LoadFromJson($filterJson);
         $this->updateEnabled();
         if (!$this->filter->IsEmpty() && $this->isEnabled()) {
             $this->parentGrid->GetDataset()->AddCustomCondition($this->generator->Generate($this->parentGrid->GetDataset(), $this->filter->GetRoot()));
         }
         $this->superGlobals->SetSessionVariable($this->parentGrid->GetId() . $storageProperty, $filterJson);
     }
     return $this->superGlobals->IsPostValueSet($storageProperty);
 }

 function RenderGrid(Grid $Grid)
 {
     $Rows = array();
     $HeaderCaptions = array();
     $Grid->GetDataset()->Open();
     foreach ($Grid->GetExportColumns() as $Column) {
         $HeaderCaptions[] = $Column->GetCaption();
     }
     while ($Grid->GetDataset()->Next()) {
         $Row = array();
         $rowValues = $Grid->GetDataset()->GetFieldValues();
         $cellStyles = $this->GetStylesForColumn($Grid, $rowValues);
         foreach ($Grid->GetExportColumns() as $column) {
             $columnName = $Grid->GetColumnName($column);
             $cell['Value'] = $this->RenderViewColumn($column, $rowValues);
             $cell['Align'] = $column->GetAlign();
             $cellStyle = new StyleBuilder();
             $cellStyle->Add('width', $column->GetFixedWidth());
             if (!$column->GetWordWrap()) {
                 $cellStyle->Add('white-space', 'nowrap');
             }
             $cellStyle->AddStyleString(ArrayUtils::GetArrayValueDef($cellStyles, $columnName));
             $cell['Style'] = $cellStyle->GetStyleString();
             $Row[] = $cell;
         }
         $Rows[] = $Row;
     }
     $this->DisplayTemplate('export/pdf_grid.tpl', array(), array('TableHeader' => $this->CreateTableHeaderData($Grid), 'Rows' => $Rows));
 }

 function RenderGrid(Grid $Grid)
 {
     $Grid->GetDataset()->Open();
     $this->doRenderGrid($Grid, PageMode::PrintOneRecord, 'view/print_grid.tpl');
 }

 protected function GetDataset()
 {
     return $this->grid->GetDataset();
 }

 function RenderGrid(Grid $grid)
 {
     $columnEditors = array();
     $dataset = $grid->GetDataset();
     if ($grid->GetErrorMessage() != '') {
         foreach ($grid->GetViewColumns() as $column) {
             $editor = $column->GetInsertOperationEditor();
             if (isset($editor)) {
                 $columnEditors[$column->GetName()]['Html'] = $this->Render($editor, false, true);
                 $columnEditors[$column->GetName()]['Script'] = $this->Render($editor, true, false);
             }
         }
         $this->DisplayTemplate('inline_operations/grid_edit_error_response.tpl', array('ErrorCaption' => 'ErrorsDuringInsertProcess', 'ErrorMessage' => $grid->GetErrorMessage(), 'ColumnEditors' => $columnEditors), array());
         return;
     }
     $cellClasses = array();
     $rowStyleByColumns = $grid->GetRowStylesByColumn($grid->GetDataset()->GetFieldValues(), $cellClasses);
     $columns = array();
     foreach ($grid->GetViewColumns() as $column) {
         $columnName = $dataset->IsLookupField($column->GetName()) ? $dataset->IsLookupFieldNameByDisplayFieldName($column->GetName()) : $column->GetName();
         $columns[$column->GetName()]['Value'] = $grid->RenderColumn($this, $column);
         $columns[$column->GetName()]['AfterRowControl'] = $this->Render($column->GetAfterRowControl());
         $columns[$column->GetName()]['Style'] = $rowStyleByColumns[$columnName];
     }
     $primaryKeys = array();
     if ($grid->GetAllowDeleteSelected()) {
         $primaryKeys = $grid->GetDataset()->GetPrimaryKeyValues();
     }
     $actionsRowViewData = array();
     foreach ($grid->getActions()->getOperations() as $operation) {
         $operationName = $dataset->IsLookupField($operation->GetName()) ? $dataset->IsLookupFieldNameByDisplayFieldName($operation->GetName()) : $operation->GetName();
         $actionsRowViewData[$operationName] = array('OperationName' => $operationName, 'Data' => $operation->GetValue());
     }
     $detailsViewData = $grid->GetDetailsViewData();
     $this->DisplayTemplate('inline_operations/grid_insert_commit_response.tpl', array('encoding' => $grid->GetPage()->GetContentEncoding(), 'AllowDeleteSelected' => $grid->GetAllowDeleteSelected(), 'PrimaryKeys' => $primaryKeys, 'Columns' => $columns, 'Actions' => $actionsRowViewData, 'RecordUID' => Random::GetIntRandom(), 'HasDetails' => $grid->GetHasDetails(), 'Details' => array('Items' => $detailsViewData, 'JSON' => htmlspecialchars(SystemUtils::ToJSON($detailsViewData)))), array());
 }

 function RenderGrid(Grid $Grid)
 {
     /*
             $Rows = array();
             $RowPrimaryKeys = array();
             $AfterRows = array();
             $rowCssStyles = array();
             $rowColumnsChars = array();
             $rowColumnsCssStyles = array();
             $bandHeadColumnsStyles = array();
             $columnsNames = array();
     
             $exportColumns = $Grid->GetExportColumns();
             foreach($exportColumns as $Column)
             {
                 $headColumnsStyleBuilder = new StyleBuilder();
     
                 if ($Column->GetFixedWidth() != null)
                     $headColumnsStyleBuilder->Add('width', $Column->GetFixedWidth());
     
                 $headColumnsStyles[] = $headColumnsStyleBuilder->GetStyleString();
                 $columnsNames[] = $Column->GetName();
             }
     
             $Grid->GetDataset()->Open();
             $recordCount = 0;
             while($Grid->GetDataset()->Next())
             {
                 $show = true;
                 $Grid->BeforeShowRecord->Fire(array(&$show));
                 if (!$show)
                     continue;
     
                 $Row = array();
                 $AfterRowControls = '';
     
                 $rowValues = $Grid->GetDataset()->GetFieldValues();
                 $rowCssStyle = '';
                 $cellCssStyles = array();
     
                 $Grid->OnCustomDrawCell->Fire(array($rowValues, &$cellCssStyles, &$rowCssStyle));
                 $cellCssStyles_Simple = $this->GetStylesForColumn($Grid, $rowValues);
                 $cellCssStyles = array_merge($cellCssStyles_Simple, $cellCssStyles);
     
                 $currentRowColumnsCssStyles = array();
     
                 $columnsChars = array();
                 for($i = 0; $i < count($bands); $i++)
                 {
                     $band = $bands[$i];
     
                     foreach($band->GetColumns() as $Column)
                     {
                         $columnName = $Grid->GetDataset()->IsLookupField($Column->GetName()) ?
                             $Grid->GetDataset()->IsLookupFieldNameByDisplayFieldName($Column->GetName()) :
                             $Column->GetName();
     
     
                         if (array_key_exists($columnName, $cellCssStyles))
                         {
                             $styleBuilder = new StyleBuilder();
                             $styleBuilder->AddStyleString($rowCssStyle);
                             $styleBuilder->AddStyleString($cellCssStyles[$columnName]);
                             $currentRowColumnsCssStyles[] = $styleBuilder->GetStyleString();
                         }
                         else
                             $currentRowColumnsCssStyles[] = $rowCssStyle;
     
                         if ($Column->GetFixedWidth() != null)
                             $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .=  sprintf('width: %s;', $Column->GetFixedWidth());
                         if (!$Column->GetWordWrap())
                             $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .=  sprintf('white-space: nowrap;', $Column->GetFixedWidth());
     
     
                         $columnRenderResult = '';
                         $customRenderColumnHandled = false;
                         $Grid->OnCustomRenderColumn->Fire(array($columnName, $Column->GetData(), $rowValues, &$columnRenderResult, &$customRenderColumnHandled));
                         $columnRenderResult = $customRenderColumnHandled ? $Grid->GetPage()->RenderText($columnRenderResult) : $this->Render($Column);
                         $Row[] = $columnRenderResult;
                         $columnsChars[] = ($Column->IsDataColumn() ? 'data' : 'misc');
     
                         $afterRow = $Column->GetAfterRowControl();
                         if (isset($afterRow))
                             $AfterRowControls .= $this->Render($afterRow);
                     }
     
                     if ($i < (count($bands) - 1))
                         $currentRowColumnsCssStyles[count($currentRowColumnsCssStyles) - 1] .= ($Grid->GetPage()->GetPageDirection() == 'rtl' ? 'border-left: ' : 'border-right: ' ). 'solid 2px' . ' #000000;';
                 }
                 $recordCount++;
                 if ($Grid->GetAllowDeleteSelected())
                     $RowPrimaryKeys[] = $Grid->GetDataset()->GetPrimaryKeyValues();
                 $Rows[] = $Row;
                 $AfterRows[] = $AfterRowControls;
                 $rowCssStyles[] = $rowCssStyle;
                 $rowColumnsCssStyles[] = $currentRowColumnsCssStyles;
                 $rowColumnsChars[] = $columnsChars;
             }
     */
     $Rows = array();
//.........这里部分代码省略.........

 function RenderGrid(Grid $grid)
 {
     $columnEditors = array();
     $dataset = $grid->GetDataset();
     if ($grid->GetErrorMessage() != '') {
         foreach ($grid->GetViewColumns() as $column) {
             $editor = $column->GetInsertOperationEditor();
             if (isset($editor)) {
                 $columnEditors[$column->GetName()]['Html'] = $this->Render($editor, false, true);
                 $columnEditors[$column->GetName()]['Script'] = $this->Render($editor, true, false);
             }
         }
         $this->DisplayTemplate('inline_operations/grid_edit_error_response.tpl', array('ErrorMessage' => $grid->GetErrorMessage(), 'ColumnEditors' => $columnEditors), array());
         return;
     }
     $rowStyleByColumns = $grid->GetRowStylesByColumn($grid->GetDataset()->GetFieldValues());
     $columns = array();
     foreach ($grid->GetViewColumns() as $column) {
         $columnName = $dataset->IsLookupField($column->GetName()) ? $dataset->IsLookupFieldNameByDisplayFieldName($column->GetName()) : $column->GetName();
         $columns[$column->GetName()]['Value'] = $grid->RenderColumn($this, $column);
         $columns[$column->GetName()]['AfterRowControl'] = $this->Render($column->GetAfterRowControl());
         $columns[$column->GetName()]['Style'] = $rowStyleByColumns[$columnName];
     }
     $primaryKeys = array();
     if ($grid->GetAllowDeleteSelected()) {
         $primaryKeys = $grid->GetDataset()->GetPrimaryKeyValues();
     }
     $this->DisplayTemplate('inline_operations/grid_insert_commit_response.tpl', array('AllowDeleteSelected' => $grid->GetAllowDeleteSelected(), 'PrimaryKeys' => $primaryKeys, 'Columns' => $columns, 'RecordUID' => Random::GetIntRandom()), array());
 }