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'); }
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); }
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); }