protected function AddSingleRecordViewColumns(Grid $grid)
{
//
// View column for cli-codcli field
//
$column = new TextViewColumn('cli-codcli', 'Codice Cliente', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(10);
$column->SetFullTextWindowHandlerName('clientiGrid_cli-codcli_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('cli-ragsoc', 'Ragione sociale', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('clientiGrid_cli-ragsoc_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Data inserimento', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Data modifica', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
}
function CreateMasterDetailRecordGridForproject_timeline_detailDetailEdit2projectGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForproject_timeline_detailDetailEdit2project');
$result->SetAllowDeleteSelected(false);
$result->OnCustomDrawCell->AddListener('MasterDetailRecordGridForproject_timeline_detailDetailEdit2project' . '_OnCustomDrawRow', $this);
$result->OnCustomRenderColumn->AddListener('MasterDetailRecordGridForproject_timeline_detailDetailEdit2project' . '_' . 'OnCustomRenderColumn', $this);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetShowKeyColumnsImagesInHeader(false);
$result->SetName('master_grid');
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(true);
$column->SetWordWrap(false);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Objectives', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for Name field
//
$column = new TextViewColumn('priority_Name', 'Priority', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('projectGrid_public_engagement_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for approved field
//
$column = new TextViewColumn('approved', 'Approved by CAO', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('dept_id_DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for program_name field
//
$column = new TextViewColumn('programm_id_program_name', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$column->SetEscapeHTMLSpecialChars(true);
$column->SetWordWrap(false);
$result->AddPrintColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for Name field
//
$column = new TextViewColumn('priority_Name', 'Priority', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$result->AddPrintColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$column = new CurrencyFormatValueViewColumnDecorator($column, 2, ',', '.', $this->RenderText('$'));
$result->AddPrintColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$result->AddPrintColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for approved field
//
$column = new TextViewColumn('approved', 'Approved by CAO', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$result->AddPrintColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('dept_id_DEPARTMENT', 'Department', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_accion field
//
$column = new TextViewColumn('id_accion', 'Id Accion', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_accion_ds_referencia', 'Tipo Accion', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'tipo_accion.php?operation=view&pk0=%id_tipo_accion%' , '_self');
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_tipo_espacio_ds_referencia', 'Tipo Espacio', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'tipo_espacio.php?operation=view&pk0=%id_tipo_espacio%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_sector field
//
$column = new TextViewColumn('id_sector_no_sector', 'Sector', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'sector.php?operation=view&pk0=%id_sector%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_origen field
//
$column = new TextViewColumn('id_origen_no_origen', 'Origen', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'origen.php?operation=view&pk0=%id_origen%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_metodologia field
//
$column = new TextViewColumn('id_metodologia_no_metodologia', 'Metodología', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'metodologia.php?operation=view&pk0=%id_metodologia%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_periodicidad field
//
$column = new TextViewColumn('id_periodicidad_no_periodicidad', 'Periodicidad', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'periodicidad.php?operation=view&pk0=%id_periodicidad%' , '_self');
$grid->AddExportColumn($column);
//
// View column for fl_a_demanda field
//
$column = new TextViewColumn('fl_a_demanda', 'A Demanda', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for nu_personas field
//
$column = new TextViewColumn('nu_personas', 'Personas', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for tm_carga_horaria field
//
$column = new DateTimeViewColumn('tm_carga_horaria', 'Carga Horária', $this->dataset);
$column->SetDateTimeFormat('H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_horas field
//
$column = new TextViewColumn('fe_horas', 'Fe Horas', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('ds_referencia', 'Ds Referencia', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddSingleRecordViewColumns(Grid $grid)
{
//
// View column for Process ID field
//
$column = new TextViewColumn('Process ID', 'Process ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for HostName field
//
$column = new TextViewColumn('HostName', 'HostName', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('dbo_procesosbdGrid_HostName_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for User field
//
$column = new TextViewColumn('User', 'User', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('dbo_procesosbdGrid_User_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for Database field
//
$column = new TextViewColumn('Database', 'Database', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('dbo_procesosbdGrid_Database_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for Status field
//
$column = new TextViewColumn('Status', 'Status', $this->dataset);
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for CPU field
//
$column = new TextViewColumn('CPU', 'CPU', $this->dataset);
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for Physical IO field
//
$column = new TextViewColumn('Physical IO', 'Physical IO', $this->dataset);
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for Login Time field
//
$column = new DateTimeViewColumn('Login Time', 'Login Time', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for USERNAME field
//
$column = new TextViewColumn('USERNAME', 'USERNAME', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_REAL field
//
$column = new TextViewColumn('ES_REAL', 'ES REAL', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('LA1', 'EJERCICIO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_type field
//
$column = new TextViewColumn('project_type', 'Project Type', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Objective field
//
$column = new TextViewColumn('Objective', 'Objective', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for priority field
//
$column = new TextViewColumn('priority', 'Priority', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_lead field
//
$column = new TextViewColumn('project_lead', 'Project Lead', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for approved_budget field
//
$column = new TextViewColumn('approved_budget', 'Approved Budget', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for budget_spent field
//
$column = new TextViewColumn('budget_spent', 'Budget Spent', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for multi_year field
//
$column = new TextViewColumn('multi_year', 'Multi Year', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for public_engagement field
//
$column = new TextViewColumn('public_engagement', 'Public Engagement', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for level_of_service field
//
$column = new TextViewColumn('level_of_service', 'Level Of Service', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for approved_by_cao field
//
$column = new TextViewColumn('approved_by_cao', 'Approved By Cao', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for DEPARTMENT field
//
$column = new TextViewColumn('DEPARTMENT', 'DEPARTMENT', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for total_hours field
//
$column = new TextViewColumn('total_hours', 'Total Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$grid->AddExportColumn($column);
//
// View column for assigned_hours field
//
$column = new TextViewColumn('assigned_hours', 'Assigned Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$grid->AddExportColumn($column);
//
// View column for assigned_progress field
//
$column = new TextViewColumn('assigned_progress', 'Assigned Progress', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_tarea_plan field
//
$column = new TextViewColumn('id_tarea_plan', 'Id Tarea Plan', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_accion_ds_referencia', 'Acción', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'accion.php?operation=view&pk0=%id_accion%' , '_self');
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('id_espacio_ds_referencia', 'Espacio', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'espacio.php?operation=view&pk0=%id_espacio%' , '_self');
$grid->AddExportColumn($column);
//
// View column for ds_observacion field
//
$column = new TextViewColumn('id_bien_ds_observacion', 'Bien', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'bien.php?operation=view&pk0=%id_bien%' , '_self');
$grid->AddExportColumn($column);
//
// View column for no_periodicidad field
//
$column = new TextViewColumn('id_periodicidad_no_periodicidad', 'Periodicidad', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'periodicidad.php?operation=view&pk0=%id_periodicidad%' , '_self');
$grid->AddExportColumn($column);
//
// View column for ds_detalle field
//
$column = new TextViewColumn('ds_detalle', 'Ds Detalle', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_referencia field
//
$column = new TextViewColumn('ds_referencia', 'Ds Referencia', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_inicio field
//
$column = new DateTimeViewColumn('fe_inicio', 'Fecha Início', $this->dataset);
$column->SetDateTimeFormat('d/m/Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id field
//
$column = new TextViewColumn('id', 'Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for descrizione field
//
$column = new TextViewColumn('ivo-codart_descrizione', 'Codice Articolo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for voc-descriz field
//
$column = new TextViewColumn('ivo-codvoc_voc-descriz', 'Codice Tipo Voce', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ivo-przunit field
//
$column = new TextViewColumn('ivo-przunit', 'Prezzo unitario', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ivo-flagart field
//
$column = new TextViewColumn('ivo-flagart', 'Altro articolo', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for ivo-flagsmu field
//
$column = new TextViewColumn('ivo-flagsmu', 'Prevede smusso', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for ivo-dataini field
//
$column = new DateTimeViewColumn('ivo-dataini', 'Data decorrenza listino', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ivo-datafin field
//
$column = new DateTimeViewColumn('ivo-datafin', 'Data fine decorrenza listino', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_date_start field
//
$column = new DateTimeViewColumn('project_date_start', 'Project Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_date_end field
//
$column = new DateTimeViewColumn('project_date_end', 'Project Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lead field
//
$column = new TextViewColumn('lead', 'Lead', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for year field
//
$column = new TextViewColumn('year', 'Year', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for progress field
//
$column = new TextViewColumn('progress', 'Progress', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_id field
//
$column = new TextViewColumn('task_id', 'Task Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_project_id field
//
$column = new TextViewColumn('task_project_id', 'Task Project Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_date_start field
//
$column = new DateTimeViewColumn('task_date_start', 'Task Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_date_end field
//
$column = new DateTimeViewColumn('task_date_end', 'Task Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for staff_id field
//
$column = new TextViewColumn('staff_id', 'Staff Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Lead', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for FOTO_ID field
//
$column = new TextViewColumn('FOTO_ID', 'FOTO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for RUTA field
//
$column = new DownloadDataColumn('RUTA', 'RUTA', $this->dataset, $this->GetLocalizerCaptions()->GetMessageString('Download'));
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('LA1', 'USERNAME', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for TITULO field
//
$column = new TextViewColumn('TITULO', 'TITULO', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for Process ID field
//
$column = new TextViewColumn('Process ID', 'Process ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for HostName field
//
$column = new TextViewColumn('HostName', 'HostName', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for User field
//
$column = new TextViewColumn('User', 'User', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Database field
//
$column = new TextViewColumn('Database', 'Database', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Query field
//
$column = new TextViewColumn('Query', 'Query', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Status field
//
$column = new TextViewColumn('Status', 'Status', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Open Transactions field
//
$column = new TextViewColumn('Open Transactions', 'Open Transactions', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Command field
//
$column = new TextViewColumn('Command', 'Command', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Application field
//
$column = new TextViewColumn('Application', 'Application', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Wait Time field
//
$column = new TextViewColumn('Wait Time', 'Wait Time', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Wait Type field
//
$column = new TextViewColumn('Wait Type', 'Wait Type', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for CPU field
//
$column = new TextViewColumn('CPU', 'CPU', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Physical IO field
//
$column = new TextViewColumn('Physical IO', 'Physical IO', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Memory Usage field
//
$column = new TextViewColumn('Memory Usage', 'Memory Usage', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Login Time field
//
$column = new DateTimeViewColumn('Login Time', 'Login Time', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Last Batch field
//
$column = new DateTimeViewColumn('Last Batch', 'Last Batch', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Blocked By field
//
$column = new TextViewColumn('Blocked By', 'Blocked By', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Blocked By Query field
//
$column = new TextViewColumn('Blocked By Query', 'Blocked By Query', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for Blocking field
//
$column = new TextViewColumn('Blocking', 'Blocking', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
function CreateMasterDetailRecordGridFortimesheetDetailEdit0taskGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridFortimesheetDetailEdit0task');
$result->SetAllowDeleteSelected(false);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetShowKeyColumnsImagesInHeader(false);
$result->SetName('master_grid');
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'project.php?operation=view&pk0=%project_id%', '');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Name', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskGrid_task_name_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('taskGrid_notes_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Allocated Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for project_id field
//
$column = new TextViewColumn('project_id', 'Project', $this->dataset);
$column->SetOrderable(true);
$column = new ExtendedHyperLinkColumnDecorator($column, $this->dataset, 'project.php?operation=view&pk0=%project_id%', '');
$result->AddPrintColumn($column);
//
// View column for task_name field
//
$column = new TextViewColumn('task_name', 'Task Name', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for hrs field
//
$column = new TextViewColumn('hrs', 'Allocated Hours', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, ',', '.');
$result->AddPrintColumn($column);
//
// View column for assigned_to field
//
$column = new TextViewColumn('assigned_to', 'Assigned To', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_tarea field
//
$column = new TextViewColumn('id_tarea', 'Id Tarea', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for id_periodicidad field
//
$column = new TextViewColumn('id_tarea_plan_id_periodicidad', 'Id Tarea Plan', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_ejecucion field
//
$column = new DateTimeViewColumn('fe_ejecucion', 'Fecha Ejecucion', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fl_realizada field
//
$column = new TextViewColumn('fl_realizada', 'Fl Realizada', $this->dataset);
$column->SetOrderable(true);
$column = new CheckBoxFormatValueViewColumnDecorator($column);
$column->SetDisplayValues($this->RenderText('<img src="images/checked.png" alt="true">'), $this->RenderText(''));
$grid->AddExportColumn($column);
//
// View column for ds_observaciones field
//
$column = new TextViewColumn('ds_observaciones', 'Ds Observaciones', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for MASCOTA_ID field
//
$column = new TextViewColumn('MASCOTA_ID', 'MASCOTA ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for TIPO field
//
$column = new TextViewColumn('TIPO', 'TIPO', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
function CreateMasterDetailRecordGridForprojectDetailEdit0programGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForprojectDetailEdit0program');
$result->SetAllowDeleteSelected(false);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetShowKeyColumnsImagesInHeader(false);
$result->SetName('master_grid');
//
// View column for program_name field
//
$column = new TextViewColumn('program_name', ' Name', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for description field
//
$column = new TextViewColumn('description', 'Description', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('programGrid_description_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for username field
//
$column = new TextViewColumn('lead_username', 'Lead', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('programGrid_username_handler_list');
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for program_name field
//
$column = new TextViewColumn('program_name', ' Name', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for description field
//
$column = new TextViewColumn('description', 'Description', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for lead field
//
$column = new TextViewColumn('lead', 'Lead', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_start field
//
$column = new DateTimeViewColumn('date_start', 'Date Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for date_end field
//
$column = new DateTimeViewColumn('date_end', 'Date End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for COLOR_PELO_ID field
//
$column = new TextViewColumn('COLOR_PELO_ID', 'COLOR PELO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('district_id_name', 'Political District Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for title field
//
$column = new TextViewColumn('office_id_title', 'Office Title', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fullname field
//
$column = new TextViewColumn('office_holder_id_fullname', 'Office Holder Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for position_name field
//
$column = new TextViewColumn('position_name', 'Position Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for term_start field
//
$column = new DateTimeViewColumn('term_start', 'Term Start', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for term_end field
//
$column = new DateTimeViewColumn('term_end', 'Term End', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for filing_deadline field
//
$column = new DateTimeViewColumn('filing_deadline', 'Filing Deadline', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for next_election field
//
$column = new DateTimeViewColumn('next_election', 'Next Election', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for notes field
//
$column = new TextViewColumn('notes', 'Notes', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for office_rank field
//
$column = new TextViewColumn('office_rank', 'Office Rank', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for descrizione field
//
$column = new TextViewColumn('lis-codart_descrizione', 'Codice Articolo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lisdesc field
//
$column = new TextViewColumn('lisdesc', 'Lisdesc', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lis-unimis field
//
$column = new TextViewColumn('lis-unimis', 'Unità misura', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lis-przacq field
//
$column = new TextViewColumn('lis-przacq', 'Prezzo acquisto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for lis-moltipl field
//
$column = new TextViewColumn('lis-moltipl', 'Moltiplicatore', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lis-oneriacc field
//
$column = new TextViewColumn('lis-oneriacc', 'Oneri e accessori', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for lis-scarto field
//
$column = new TextViewColumn('lis-scarto', 'Scarto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for lis-dataini field
//
$column = new DateTimeViewColumn('lis-dataini', 'Data inizio decorrenza', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for lis-datafin field
//
$column = new DateTimeViewColumn('lis-datafin', 'Data fine decorrenza', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id field
//
$column = new TextViewColumn('id', 'Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofa-numoff field
//
$column = new TextViewColumn('ofa-numoff', 'Numero Offerta', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for art-descart field
//
$column = new TextViewColumn('ofa-codart_art-descart', 'Codice articolo', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofa-descart field
//
$column = new TextViewColumn('ofa-descart', 'Ofa-descart', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofa-lunghezza field
//
$column = new TextViewColumn('ofa-lunghezza', 'Lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-larghezza field
//
$column = new TextViewColumn('ofa-larghezza', 'Ofa-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-spessore field
//
$column = new TextViewColumn('ofa-spessore', 'Ofa-spessore', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-quantita field
//
$column = new TextViewColumn('ofa-quantita', 'Ofa-quantita', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofa-przacq-net field
//
$column = new TextViewColumn('ofa-przacq-net', 'Ofa-przacq-net', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-przacq-lor field
//
$column = new TextViewColumn('ofa-przacq-lor', 'Ofa-przacq-lor', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-totuni field
//
$column = new TextViewColumn('ofa-totuni', 'Ofa-totuni', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-totunit-fin field
//
$column = new TextViewColumn('ofa-totunit-fin', 'Ofa-totunit-fin', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-totgen field
//
$column = new TextViewColumn('ofa-totgen', 'Ofa-totgen', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofa-przven field
//
$column = new TextViewColumn('ofa-przven', 'Ofa-przven', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for EVENTO_ID field
//
$column = new TextViewColumn('EVENTO_ID', 'EVENTO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FECHA_HORA field
//
$column = new DateTimeViewColumn('FECHA_HORA', 'FECHA HORA', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for LUGAR field
//
$column = new TextViewColumn('LUGAR', 'LUGAR', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for DESCRIPCION field
//
$column = new TextViewColumn('DESCRIPCION', 'DESCRIPCION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('LA1', 'CIUDAD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for TIPO_RELACION_ID field
//
$column = new TextViewColumn('TIPO_RELACION_ID', 'TIPO RELACION ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FECHA_CREACION field
//
$column = new DateTimeViewColumn('FECHA_CREACION', 'FECHA CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FECHA_MODIFICACION field
//
$column = new DateTimeViewColumn('FECHA_MODIFICACION', 'FECHA MODIFICACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_MODIFICACION field
//
$column = new TextViewColumn('USUARIO_MODIFICACION', 'USUARIO MODIFICACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for name field
//
$column = new TextViewColumn('name', 'Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for date field
//
$column = new DateTimeViewColumn('date', 'Timesheet Date', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for project_name field
//
$column = new TextViewColumn('project_name', 'Project Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for pay_period_number field
//
$column = new TextViewColumn('pay_period_number', 'Pay Period ', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for hours field
//
$column = new TextViewColumn('hours', 'Hours', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for position field
//
$column = new TextViewColumn('position', 'Position', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for emp_number field
//
$column = new TextViewColumn('emp_number', 'Emp Number', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for rpt_id field
//
$column = new TextViewColumn('rpt_id', 'Rpt Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_name field
//
$column = new TextViewColumn('rpt_name', 'Rpt Name', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_title field
//
$column = new TextViewColumn('rpt_title', 'Rpt Title', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_cdate field
//
$column = new DateTimeViewColumn('rpt_cdate', 'Rpt Cdate', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_mdate field
//
$column = new DateTimeViewColumn('rpt_mdate', 'Rpt Mdate', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_content field
//
$column = new DownloadDataColumn('rpt_content', 'Rpt Content', $this->dataset, $this->GetLocalizerCaptions()->GetMessageString('Download'));
$grid->AddExportColumn($column);
//
// View column for rpt_owner field
//
$column = new TextViewColumn('rpt_owner', 'Rpt Owner', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_status field
//
$column = new TextViewColumn('rpt_status', 'Rpt Status', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for rpt_type field
//
$column = new TextViewColumn('rpt_type', 'Rpt Type', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id field
//
$column = new TextViewColumn('id', 'Id', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-numoff field
//
$column = new TextViewColumn('ofv-numoff', 'Ofv-numoff', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-codvoce field
//
$column = new TextViewColumn('ofv-codvoce', 'Ofv-codvoce', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-quantita field
//
$column = new TextViewColumn('ofv-quantita', 'Ofv-quantita', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-lunghezza field
//
$column = new TextViewColumn('ofv-lunghezza', 'Ofv-lunghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-larghezza field
//
$column = new TextViewColumn('ofv-larghezza', 'Ofv-larghezza', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-tiposmu field
//
$column = new TextViewColumn('ofv-tiposmu', 'Ofv-tiposmu', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ofv-przacq field
//
$column = new TextViewColumn('ofv-przacq', 'Ofv-przacq', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-sconto field
//
$column = new TextViewColumn('ofv-sconto', 'Ofv-sconto', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-valuni-cal field
//
$column = new TextViewColumn('ofv-valuni-cal', 'Ofv-valuni-cal', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for ofv-valuni-fin field
//
$column = new TextViewColumn('ofv-valuni-fin', 'Ofv-valuni-fin', $this->dataset);
$column->SetOrderable(true);
$column = new NumberFormatValueViewColumnDecorator($column, 2, '.', ',');
$grid->AddExportColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
function CreateMasterDetailRecordGridForofferte_dettaglio_articoliDetailEdit0offerteGrid()
{
$result = new Grid($this, $this->dataset, 'MasterDetailRecordGridForofferte_dettaglio_articoliDetailEdit0offerte');
$result->SetAllowDeleteSelected(false);
$result->SetShowFilterBuilder(false);
$result->SetAdvancedSearchAvailable(false);
$result->SetFilterRowAvailable(false);
$result->SetShowUpdateLink(false);
$result->SetEnabledInlineEditing(false);
$result->SetShowKeyColumnsImagesInHeader(false);
$result->SetName('master_grid');
//
// View column for off-numoff field
//
$column = new TextViewColumn('off-numoff', 'Off-numoff', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('off-codcli_cli-ragsoc', 'cod.Cliente', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-descriz field
//
$column = new TextViewColumn('off-descriz', 'Off-descriz', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-gg-termine-consegna field
//
$column = new TextViewColumn('off-gg-termine-consegna', 'Off-gg-termine-consegna', $this->dataset);
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-datains field
//
$column = new DateTimeViewColumn('off-datains', 'Data inserimento', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-dataeva field
//
$column = new DateTimeViewColumn('off-dataeva', 'Data evasione', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Data ins', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$column->SetDescription($this->RenderText(''));
$column->SetFixedWidth(null);
$result->AddViewColumn($column);
//
// View column for off-numoff field
//
$column = new TextViewColumn('off-numoff', 'Off-numoff', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for cli-ragsoc field
//
$column = new TextViewColumn('off-codcli_cli-ragsoc', 'cod.Cliente', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-descriz field
//
$column = new TextViewColumn('off-descriz', 'Off-descriz', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-gg-termine-consegna field
//
$column = new TextViewColumn('off-gg-termine-consegna', 'Off-gg-termine-consegna', $this->dataset);
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-datains field
//
$column = new DateTimeViewColumn('off-datains', 'Data inserimento', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for off-dataeva field
//
$column = new DateTimeViewColumn('off-dataeva', 'Data evasione', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Data ins', $this->dataset);
$column->SetDateTimeFormat('d-m-Y');
$column->SetOrderable(true);
$result->AddPrintColumn($column);
return $result;
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for FEC_WINK field
//
$column = new DateTimeViewColumn('FEC_WINK', 'FEC WINK', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('LA1', 'USERNAME EMISOR', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('LA2', 'USERNAME RECEPTOR', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddSingleRecordViewColumns(Grid $grid)
{
//
// View column for codice field
//
$column = new TextViewColumn('codice', 'Codice', $this->dataset);
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for formula field
//
$column = new TextViewColumn('formula', 'Formula', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('formule_calcoloGrid_formula_handler_view');
$grid->AddSingleRecordViewColumn($column);
//
// View column for datains field
//
$column = new DateTimeViewColumn('datains', 'Datains', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for datamod field
//
$column = new DateTimeViewColumn('datamod', 'Datamod', $this->dataset);
$column->SetDateTimeFormat('d-m-Y H:i:s');
$column->SetOrderable(true);
$grid->AddSingleRecordViewColumn($column);
//
// View column for descrizione field
//
$column = new TextViewColumn('descrizione', 'Descrizione', $this->dataset);
$column->SetOrderable(true);
$column->SetMaxLength(75);
$column->SetFullTextWindowHandlerName('formule_calcoloGrid_descrizione_handler_view');
$grid->AddSingleRecordViewColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for USERNAME field
//
$column = new TextViewColumn('USERNAME', 'USERNAME', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ES_ADMIN field
//
$column = new TextViewColumn('ES_ADMIN', 'ES ADMIN', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NACIMIENTO field
//
$column = new DateTimeViewColumn('NACIMIENTO', 'NACIMIENTO', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for PRIMER_APELLIDO field
//
$column = new TextViewColumn('PRIMER_APELLIDO', 'PRIMER APELLIDO', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for SEGUNDO_APELLIDO field
//
$column = new TextViewColumn('SEGUNDO_APELLIDO', 'SEGUNDO APELLIDO', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('NOMBRE', 'NOMBRE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('LA1', 'GENERO ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for NOMBRE field
//
$column = new TextViewColumn('LA2', 'CIUDAD ID', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for SLOGAN field
//
$column = new TextViewColumn('SLOGAN', 'SLOGAN', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_CREACION field
//
$column = new DateTimeViewColumn('FEC_CREACION', 'FEC CREACION', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_CREACION field
//
$column = new TextViewColumn('USUARIO_CREACION', 'USUARIO CREACION', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for FEC_ULTIMA_MOD field
//
$column = new DateTimeViewColumn('FEC_ULTIMA_MOD', 'FEC ULTIMA MOD', $this->dataset);
$column->SetDateTimeFormat('Y-m-d');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for USUARIO_ULTIMA_MOD field
//
$column = new TextViewColumn('USUARIO_ULTIMA_MOD', 'USUARIO ULTIMA MOD', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for EMAIL field
//
$column = new TextViewColumn('EMAIL', 'EMAIL', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for CLAVE field
//
$column = new TextViewColumn('CLAVE', 'CLAVE', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
protected function AddExportColumns(Grid $grid)
{
//
// View column for id_lectura field
//
$column = new TextViewColumn('id_lectura', 'Id Lectura', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for id_tipo_persona field
//
$column = new TextViewColumn('id_persona_id_tipo_persona', 'Id Persona', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for co_lugar field
//
$column = new TextViewColumn('id_lugar_co_lugar', 'Id Lugar', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for co_origen_lectura field
//
$column = new TextViewColumn('id_origen_lectura_co_origen_lectura', 'Id Origen Lectura', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for fe_fecha_lectura field
//
$column = new DateTimeViewColumn('fe_fecha_lectura', 'Fe Fecha Lectura', $this->dataset);
$column->SetDateTimeFormat('Y-m-d H:i:s');
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for no_usuario field
//
$column = new TextViewColumn('no_usuario', 'Nombre Usuario', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_usuario field
//
$column = new TextViewColumn('ds_usuario', 'Descripción Usuario', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for co_lector field
//
$column = new TextViewColumn('co_lector', 'Código Lector', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for ds_observaciones field
//
$column = new TextViewColumn('ds_observaciones', 'Ds Observaciones', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
//
// View column for id_carga field
//
$column = new TextViewColumn('id_carga', 'Id Carga', $this->dataset);
$column->SetOrderable(true);
$grid->AddExportColumn($column);
}
