CActiveDataProvider

$dataProvider=new CActiveDataProvider('MerchantBatchCode', array(
    'criteria'=>array(
        'condition'=>'merchant_code_exp=1',
        'order'=>'id ASC'
    ),
    'pagination'=>array(
        'pageSize'=>3,
    ),
));
$model = $dataProvider->getData();