public function btnGenerar_Angel_Click($sender, $param)
{
$def = array(array('nombre' => 'numero', 'tipo' => 'N', 'longitud' => 10, 'decimales' => 0), array('nombre' => 'nombre', 'tipo' => 'C', 'longitud' => 50, 'decimales' => 0), array('nombre' => 'paterno', 'tipo' => 'C', 'longitud' => 50, 'decimales' => 0), array('nombre' => 'fec_ingre', 'tipo' => 'D', 'longitud' => 8, 'decimales' => 0), array('nombre' => 'sexo', 'tipo' => 'C', 'longitud' => 50, 'decimales' => 0));
$sql_query = "SELECT e.numero as numero, e.nombre as nombre, e.paterno as paterno, date_format(e.fec_ingre, '%Y%m%d') as fec_ingre, e.sexo as sexo FROM empleados e WHERE e.status = :idStatus";
$comando = $this->dbConexion->createCommand($sql_query);
$comando->bindValue(":idStatus", $this->ddlTipo->Text);
$db_records = $comando->query()->readAll();
UsaDBF::esc("cosarara.dbf", $def, $db_records);
//var_dump($db_records);
}
