From d5eb713888715e8f18d2ccf508a8eb0b1a483ad1 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Tue, 24 Apr 2007 06:14:56 +0000
Subject: add active record Relations

---
 framework/Data/Common/TDbCommandBuilder.php | 13 ++++++-------
 1 file changed, 6 insertions(+), 7 deletions(-)

(limited to 'framework/Data/Common')

diff --git a/framework/Data/Common/TDbCommandBuilder.php b/framework/Data/Common/TDbCommandBuilder.php
index c90b913c..3a08d890 100644
--- a/framework/Data/Common/TDbCommandBuilder.php
+++ b/framework/Data/Common/TDbCommandBuilder.php
@@ -140,6 +140,11 @@ class TDbCommandBuilder extends TComponent
 			$where='1=1';
 		$table = $this->getTableInfo()->getTableFullName();
 		$sql = "SELECT * FROM {$table} WHERE {$where}";
+		return $this->applyCriterias($sql, $parameters, $ordering, $limit, $offset);
+	}
+
+	public function applyCriterias($sql, $parameters=array(),$ordering=array(), $limit=-1, $offset=-1)
+	{
 		if(count($ordering) > 0)
 			$sql = $this->applyOrdering($sql, $ordering);
 		if($limit>=0 || $offset>=0)
@@ -161,13 +166,7 @@ class TDbCommandBuilder extends TComponent
 			$where='1=1';
 		$table = $this->getTableInfo()->getTableFullName();
 		$sql = "SELECT COUNT(*) FROM {$table} WHERE {$where}";
-		if(count($ordering) > 0)
-			$sql = $this->applyOrdering($sql, $ordering);
-		if($limit>=0 || $offset>=0)
-			$sql = $this->applyLimitOffset($sql, $limit, $offset);
-		$command = $this->createCommand($sql);
-		$this->bindArrayValues($command, $parameters);
-		return $command;
+		return $this->applyCriterias($sql, $parameters, $ordering, $limit, $offset);
 	}
 
 	/**
-- 
cgit v1.2.3