示例#1
0
 public function run()
 {
     //$this->_createNewMember();
     //$this->_updateMember();
     $Query = $this->model->query->select('first_name', 'last_name');
     //$Query->whereEQ('id', 1); // work
     $Query->whereEQ('first_name', 'Pao');
     // work
     $Query->whereEQ('last_name', 'IM', 'or');
     // work
     $Query->whereNEQ('id', 3);
     // work
     //$Query->whereNULL('first_name'); // need to test
     //$Query->whereNNULL('first_name'); //not work
     //$Query->whereNNULL('id'); // ot work
     $Query->orderBy(array('last_name' => 'Desc', 'first_name' => 'Asc'));
     //$Query->groupBy('FieldA', 'FieldB');
     //$Query->limit();
     $DataList = $Query->run();
     PrintUtil::display($DataList);
 }