Exemplo n.º 1
0
 protected function DoBeforeCreate()
 {
     $this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."FOTO"');
     $field = new IntegerField('FOTO_ID');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, true);
     $field = new BlobField('RUTA');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('USERNAME');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('TITULO');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new DateField('FEC_CREACION');
     $this->dataset->AddField($field, false);
     $field = new StringField('USUARIO_CREACION');
     $this->dataset->AddField($field, false);
     $field = new DateField('FEC_ULTIMA_MOD');
     $this->dataset->AddField($field, false);
     $field = new StringField('USUARIO_ULTIMA_MOD');
     $this->dataset->AddField($field, false);
     $this->dataset->AddLookupField('USERNAME', 'GE.PERSONA', new StringField('USERNAME'), new StringField('ES_ADMIN', 'LA1', 'LT1'), 'LT1');
 }
Exemplo n.º 2
0
 protected function DoBeforeCreate()
 {
     $this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."webreports"');
     $field = new IntegerField('rpt_id');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, true);
     $field = new StringField('rpt_name');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('rpt_title');
     $this->dataset->AddField($field, false);
     $field = new DateField('rpt_cdate');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new DateField('rpt_mdate');
     $this->dataset->AddField($field, false);
     $field = new BlobField('rpt_content');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('rpt_owner');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('rpt_status');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('rpt_type');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
 }
Exemplo n.º 3
0
 protected function DoBeforeCreate()
 {
     $this->dataset = new TableDataset(new OracleConnectionFactory(), GetConnectionOptions(), '"GE"."webreport_style"');
     $field = new IntegerField('report_style_id');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, true);
     $field = new StringField('type');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new IntegerField('field');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new IntegerField('group');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new BlobField('style_str');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new IntegerField('uniq');
     $this->dataset->AddField($field, false);
     $field = new StringField('repname');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
     $field = new StringField('styletype');
     $field->SetIsNotNull(true);
     $this->dataset->AddField($field, false);
 }