用yii中的CSqlDataProvider排序

这样的事情应该起作用：

$arHospitals = new CSqlDataProvider($sql, array(    'totalItemCount'=>$count,    'sort'=>array(        'attributes'=>array( 'virtualFieldName'=>array( //virtual field name     //give no possibility to sort in any other order than     'asc'=>'same_city DESC, same_state DESC, hospital_name ASC',      'desc'=>'same_city DESC, same_state DESC, hospital_name ASC',      'label'=>'Default Sort Order' ),        ),        'defaultOrder'=>array( 'virtualFieldName'=>CSort::SORT_ASC, //default sort value        ),    ),    'pagination'=>array(        'pageSize'=>30,    ),));

有关更多信息，请参见http://www.yiiframework.com/doc/api/1.1/CSort#attributes-
detail
。