PHP Transaction::LoadAll方法代码示例

 protected function lstTransaction_Create()
 {
     $this->lstTransaction = new QListBox($this);
     $this->lstTransaction->Name = QApplication::Translate('Transaction');
     $this->lstTransaction->Required = true;
     if (!$this->blnEditMode) {
         $this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
     }
     $objTransactionArray = Transaction::LoadAll();
     if ($objTransactionArray) {
         foreach ($objTransactionArray as $objTransaction) {
             $objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
             if ($this->objShipment->Transaction && $this->objShipment->Transaction->TransactionId == $objTransaction->TransactionId) {
                 $objListItem->Selected = true;
             }
             $this->lstTransaction->AddItem($objListItem);
         }
     }
 }

 /**
  * Refresh this MetaControl with Data from the local Shipment object.
  * @param boolean $blnReload reload Shipment from the database
  * @return void
  */
 public function Refresh($blnReload = false)
 {
     if ($blnReload) {
         $this->objShipment->Reload();
     }
     if ($this->lblShipmentId) {
         if ($this->blnEditMode) {
             $this->lblShipmentId->Text = $this->objShipment->ShipmentId;
         }
     }
     if ($this->txtShipmentNumber) {
         $this->txtShipmentNumber->Text = $this->objShipment->ShipmentNumber;
     }
     if ($this->lblShipmentNumber) {
         $this->lblShipmentNumber->Text = $this->objShipment->ShipmentNumber;
     }
     if ($this->lstTransaction) {
         $this->lstTransaction->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objTransactionArray = Transaction::LoadAll();
         if ($objTransactionArray) {
             foreach ($objTransactionArray as $objTransaction) {
                 $objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
                 if ($this->objShipment->Transaction && $this->objShipment->Transaction->TransactionId == $objTransaction->TransactionId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstTransaction->AddItem($objListItem);
             }
         }
     }
     if ($this->lblTransactionId) {
         $this->lblTransactionId->Text = $this->objShipment->Transaction ? $this->objShipment->Transaction->__toString() : null;
     }
     if ($this->lstFromCompany) {
         $this->lstFromCompany->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstFromCompany->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objFromCompanyArray = Company::LoadAll();
         if ($objFromCompanyArray) {
             foreach ($objFromCompanyArray as $objFromCompany) {
                 $objListItem = new QListItem($objFromCompany->__toString(), $objFromCompany->CompanyId);
                 if ($this->objShipment->FromCompany && $this->objShipment->FromCompany->CompanyId == $objFromCompany->CompanyId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstFromCompany->AddItem($objListItem);
             }
         }
     }
     if ($this->lblFromCompanyId) {
         $this->lblFromCompanyId->Text = $this->objShipment->FromCompany ? $this->objShipment->FromCompany->__toString() : null;
     }
     if ($this->lstFromContact) {
         $this->lstFromContact->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstFromContact->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objFromContactArray = Contact::LoadAll();
         if ($objFromContactArray) {
             foreach ($objFromContactArray as $objFromContact) {
                 $objListItem = new QListItem($objFromContact->__toString(), $objFromContact->ContactId);
                 if ($this->objShipment->FromContact && $this->objShipment->FromContact->ContactId == $objFromContact->ContactId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstFromContact->AddItem($objListItem);
             }
         }
     }
     if ($this->lblFromContactId) {
         $this->lblFromContactId->Text = $this->objShipment->FromContact ? $this->objShipment->FromContact->__toString() : null;
     }
     if ($this->lstFromAddress) {
         $this->lstFromAddress->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstFromAddress->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objFromAddressArray = Address::LoadAll();
         if ($objFromAddressArray) {
             foreach ($objFromAddressArray as $objFromAddress) {
                 $objListItem = new QListItem($objFromAddress->__toString(), $objFromAddress->AddressId);
                 if ($this->objShipment->FromAddress && $this->objShipment->FromAddress->AddressId == $objFromAddress->AddressId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstFromAddress->AddItem($objListItem);
             }
         }
     }
     if ($this->lblFromAddressId) {
         $this->lblFromAddressId->Text = $this->objShipment->FromAddress ? $this->objShipment->FromAddress->__toString() : null;
     }
     if ($this->lstToCompany) {
         $this->lstToCompany->RemoveAllItems();
         if (!$this->blnEditMode) {
//.........这里部分代码省略.........

 /**
  * Refresh this MetaControl with Data from the local InventoryTransaction object.
  * @param boolean $blnReload reload InventoryTransaction from the database
  * @return void
  */
 public function Refresh($blnReload = false)
 {
     if ($blnReload) {
         $this->objInventoryTransaction->Reload();
     }
     if ($this->lblInventoryTransactionId) {
         if ($this->blnEditMode) {
             $this->lblInventoryTransactionId->Text = $this->objInventoryTransaction->InventoryTransactionId;
         }
     }
     if ($this->lstInventoryLocation) {
         $this->lstInventoryLocation->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstInventoryLocation->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objInventoryLocationArray = InventoryLocation::LoadAll();
         if ($objInventoryLocationArray) {
             foreach ($objInventoryLocationArray as $objInventoryLocation) {
                 $objListItem = new QListItem($objInventoryLocation->__toString(), $objInventoryLocation->InventoryLocationId);
                 if ($this->objInventoryTransaction->InventoryLocation && $this->objInventoryTransaction->InventoryLocation->InventoryLocationId == $objInventoryLocation->InventoryLocationId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstInventoryLocation->AddItem($objListItem);
             }
         }
     }
     if ($this->lblInventoryLocationId) {
         $this->lblInventoryLocationId->Text = $this->objInventoryTransaction->InventoryLocation ? $this->objInventoryTransaction->InventoryLocation->__toString() : null;
     }
     if ($this->lstTransaction) {
         $this->lstTransaction->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objTransactionArray = Transaction::LoadAll();
         if ($objTransactionArray) {
             foreach ($objTransactionArray as $objTransaction) {
                 $objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
                 if ($this->objInventoryTransaction->Transaction && $this->objInventoryTransaction->Transaction->TransactionId == $objTransaction->TransactionId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstTransaction->AddItem($objListItem);
             }
         }
     }
     if ($this->lblTransactionId) {
         $this->lblTransactionId->Text = $this->objInventoryTransaction->Transaction ? $this->objInventoryTransaction->Transaction->__toString() : null;
     }
     if ($this->txtQuantity) {
         $this->txtQuantity->Text = $this->objInventoryTransaction->Quantity;
     }
     if ($this->lblQuantity) {
         $this->lblQuantity->Text = $this->objInventoryTransaction->Quantity;
     }
     if ($this->lstSourceLocation) {
         $this->lstSourceLocation->RemoveAllItems();
         $this->lstSourceLocation->AddItem(QApplication::Translate('- Select One -'), null);
         $objSourceLocationArray = Location::LoadAll();
         if ($objSourceLocationArray) {
             foreach ($objSourceLocationArray as $objSourceLocation) {
                 $objListItem = new QListItem($objSourceLocation->__toString(), $objSourceLocation->LocationId);
                 if ($this->objInventoryTransaction->SourceLocation && $this->objInventoryTransaction->SourceLocation->LocationId == $objSourceLocation->LocationId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstSourceLocation->AddItem($objListItem);
             }
         }
     }
     if ($this->lblSourceLocationId) {
         $this->lblSourceLocationId->Text = $this->objInventoryTransaction->SourceLocation ? $this->objInventoryTransaction->SourceLocation->__toString() : null;
     }
     if ($this->lstDestinationLocation) {
         $this->lstDestinationLocation->RemoveAllItems();
         $this->lstDestinationLocation->AddItem(QApplication::Translate('- Select One -'), null);
         $objDestinationLocationArray = Location::LoadAll();
         if ($objDestinationLocationArray) {
             foreach ($objDestinationLocationArray as $objDestinationLocation) {
                 $objListItem = new QListItem($objDestinationLocation->__toString(), $objDestinationLocation->LocationId);
                 if ($this->objInventoryTransaction->DestinationLocation && $this->objInventoryTransaction->DestinationLocation->LocationId == $objDestinationLocation->LocationId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstDestinationLocation->AddItem($objListItem);
             }
         }
     }
     if ($this->lblDestinationLocationId) {
         $this->lblDestinationLocationId->Text = $this->objInventoryTransaction->DestinationLocation ? $this->objInventoryTransaction->DestinationLocation->__toString() : null;
     }
     if ($this->lstCreatedByObject) {
         $this->lstCreatedByObject->RemoveAllItems();
         $this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
         $objCreatedByObjectArray = UserAccount::LoadAll();
         if ($objCreatedByObjectArray) {
             foreach ($objCreatedByObjectArray as $objCreatedByObject) {
                 $objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
//.........这里部分代码省略.........

 public function dtgTransaction_Bind()
 {
     // Get Total Count b/c of Pagination
     $this->dtgTransaction->TotalItemCount = Transaction::CountAll();
     $objClauses = array();
     if ($objClause = $this->dtgTransaction->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     if ($objClause = $this->dtgTransaction->LimitClause) {
         array_push($objClauses, $objClause);
     }
     $this->dtgTransaction->DataSource = Transaction::LoadAll($objClauses);
 }

 /**
  * Refresh this MetaControl with Data from the local AssetTransaction object.
  * @param boolean $blnReload reload AssetTransaction from the database
  * @return void
  */
 public function Refresh($blnReload = false)
 {
     if ($blnReload) {
         $this->objAssetTransaction->Reload();
     }
     if ($this->lblAssetTransactionId) {
         if ($this->blnEditMode) {
             $this->lblAssetTransactionId->Text = $this->objAssetTransaction->AssetTransactionId;
         }
     }
     if ($this->lstAsset) {
         $this->lstAsset->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstAsset->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objAssetArray = Asset::LoadAll();
         if ($objAssetArray) {
             foreach ($objAssetArray as $objAsset) {
                 $objListItem = new QListItem($objAsset->__toString(), $objAsset->AssetId);
                 if ($this->objAssetTransaction->Asset && $this->objAssetTransaction->Asset->AssetId == $objAsset->AssetId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstAsset->AddItem($objListItem);
             }
         }
     }
     if ($this->lblAssetId) {
         $this->lblAssetId->Text = $this->objAssetTransaction->Asset ? $this->objAssetTransaction->Asset->__toString() : null;
     }
     if ($this->lstTransaction) {
         $this->lstTransaction->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objTransactionArray = Transaction::LoadAll();
         if ($objTransactionArray) {
             foreach ($objTransactionArray as $objTransaction) {
                 $objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
                 if ($this->objAssetTransaction->Transaction && $this->objAssetTransaction->Transaction->TransactionId == $objTransaction->TransactionId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstTransaction->AddItem($objListItem);
             }
         }
     }
     if ($this->lblTransactionId) {
         $this->lblTransactionId->Text = $this->objAssetTransaction->Transaction ? $this->objAssetTransaction->Transaction->__toString() : null;
     }
     if ($this->lstParentAssetTransaction) {
         $this->lstParentAssetTransaction->RemoveAllItems();
         $this->lstParentAssetTransaction->AddItem(QApplication::Translate('- Select One -'), null);
         $objParentAssetTransactionArray = AssetTransaction::LoadAll();
         if ($objParentAssetTransactionArray) {
             foreach ($objParentAssetTransactionArray as $objParentAssetTransaction) {
                 $objListItem = new QListItem($objParentAssetTransaction->__toString(), $objParentAssetTransaction->AssetTransactionId);
                 if ($this->objAssetTransaction->ParentAssetTransaction && $this->objAssetTransaction->ParentAssetTransaction->AssetTransactionId == $objParentAssetTransaction->AssetTransactionId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstParentAssetTransaction->AddItem($objListItem);
             }
         }
     }
     if ($this->lblParentAssetTransactionId) {
         $this->lblParentAssetTransactionId->Text = $this->objAssetTransaction->ParentAssetTransaction ? $this->objAssetTransaction->ParentAssetTransaction->__toString() : null;
     }
     if ($this->lstSourceLocation) {
         $this->lstSourceLocation->RemoveAllItems();
         $this->lstSourceLocation->AddItem(QApplication::Translate('- Select One -'), null);
         $objSourceLocationArray = Location::LoadAll();
         if ($objSourceLocationArray) {
             foreach ($objSourceLocationArray as $objSourceLocation) {
                 $objListItem = new QListItem($objSourceLocation->__toString(), $objSourceLocation->LocationId);
                 if ($this->objAssetTransaction->SourceLocation && $this->objAssetTransaction->SourceLocation->LocationId == $objSourceLocation->LocationId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstSourceLocation->AddItem($objListItem);
             }
         }
     }
     if ($this->lblSourceLocationId) {
         $this->lblSourceLocationId->Text = $this->objAssetTransaction->SourceLocation ? $this->objAssetTransaction->SourceLocation->__toString() : null;
     }
     if ($this->lstDestinationLocation) {
         $this->lstDestinationLocation->RemoveAllItems();
         $this->lstDestinationLocation->AddItem(QApplication::Translate('- Select One -'), null);
         $objDestinationLocationArray = Location::LoadAll();
         if ($objDestinationLocationArray) {
             foreach ($objDestinationLocationArray as $objDestinationLocation) {
                 $objListItem = new QListItem($objDestinationLocation->__toString(), $objDestinationLocation->LocationId);
                 if ($this->objAssetTransaction->DestinationLocation && $this->objAssetTransaction->DestinationLocation->LocationId == $objDestinationLocation->LocationId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstDestinationLocation->AddItem($objListItem);
             }
         }
//.........这里部分代码省略.........

 protected function dtgTransaction_Bind()
 {
     // Because we want to enable pagination AND sorting, we need to setup the $objClauses array to send to LoadAll()
     // Remember!  We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
     $this->dtgTransaction->TotalItemCount = Transaction::CountAll();
     // Setup the $objClauses Array
     $objClauses = array();
     // 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->dtgTransaction->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     // Add the LimitClause information, as well
     if ($objClause = $this->dtgTransaction->LimitClause) {
         array_push($objClauses, $objClause);
     }
     // Set the DataSource to be the array of all Transaction objects, given the clauses above
     $this->dtgTransaction->DataSource = Transaction::LoadAll($objClauses);
 }