PHP UserAccount::QueryCount方法代碼示例

 /**
  * Count Active UserAccounts
  * @return int
  */
 public static function CountActive()
 {
     // Call UserAccount::QueryCount to perform the Count query
     return UserAccount::QueryCount(QQ::Equal(QQN::UserAccount()->ActiveFlag, 1));
 }

 /**
  * Main utility method to aid with data binding.  It is used by the default BindAllRows() databinder but
  * could and should be used by any custom databind methods that would be used for instances of this
  * MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause. 
  *
  * If a paginator is set on this DataBinder, it will use it.  If not, then no pagination will be used.
  * It will also perform any sorting (if applicable).
  *
  * @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
  * @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query		 
  * @return void
  */
 public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null)
 {
     // Setup input parameters to default values if none passed in
     if (!$objCondition) {
         $objCondition = QQ::All();
     }
     $objClauses = $objOptionalClauses ? $objOptionalClauses : array();
     // We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
     if ($this->Paginator) {
         $this->TotalItemCount = UserAccount::QueryCount($objCondition, $objClauses);
     }
     // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
     // the OrderByClause to the $objClauses array
     if ($objClause = $this->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     // Add the LimitClause information, as well
     if ($objClause = $this->LimitClause) {
         array_push($objClauses, $objClause);
     }
     // Set the DataSource to be a Query result from UserAccount, given the clauses above
     $this->DataSource = UserAccount::QueryArray($objCondition, $objClauses);
 }

 /**
  * Count UserAccounts
  * by RoleId Index(es)
  * @param integer $intRoleId
  * @return int
  */
 public static function CountByRoleId($intRoleId, $objOptionalClauses = null)
 {
     // Call UserAccount::QueryCount to perform the CountByRoleId query
     return UserAccount::QueryCount(QQ::Equal(QQN::UserAccount()->RoleId, $intRoleId), $objOptionalClauses);
 }

 public function dtgUserAccount_Bind()
 {
     $objClauses = array();
     if ($objClause = $this->dtgUserAccount->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     $objClause = QQ::Expand(QQN::UserAccount()->CreatedByObject);
     array_push($objClauses, $objClause);
     $objClause = QQ::Expand(QQN::UserAccount()->Role);
     array_push($objClauses, $objClause);
     $this->strUsername = $this->txtUsername->Text;
     if ($this->strUsername) {
         $this->dtgUserAccount->TotalItemCount = UserAccount::QueryCount(QQ::Like(QQN::UserAccount()->Username, '%' . $this->strUsername . '%'), $objClauses);
         if ($this->dtgUserAccount->TotalItemCount > 0) {
             $this->dtgUserAccount->ShowHeader = true;
             // Add the LimitClause information, as well
             if ($objClause = $this->dtgUserAccount->LimitClause) {
                 array_push($objClauses, $objClause);
             }
             $this->dtgUserAccount->DataSource = UserAccount::QueryArray(QQ::Like(QQN::UserAccount()->Username, '%' . $this->strUsername . '%'), $objClauses);
         } else {
             $this->dtgUserAccount->ShowHeader = false;
         }
     } else {
         // Get Total Count b/c of Pagination
         $this->dtgUserAccount->TotalItemCount = UserAccount::CountAll();
         if ($this->dtgUserAccount->TotalItemCount == 0) {
             $this->dtgUserAccount->ShowHeader = false;
         } else {
             if ($objClause = $this->dtgUserAccount->LimitClause) {
                 array_push($objClauses, $objClause);
             }
             $this->dtgUserAccount->DataSource = UserAccount::LoadAll($objClauses);
             $this->dtgUserAccount->ShowHeader = true;
         }
     }
 }

 /**
  * Count UserAccounts
  * by RoleId Index(es)
  * @param integer $intRoleId
  * @return int
  */
 public static function CountByRoleId($intRoleId)
 {
     // Call UserAccount::QueryCount to perform the CountByRoleId query
     return UserAccount::QueryCount(QQ::Equal(QQN::UserAccount()->RoleId, $intRoleId));
 }