public function GetSQL() { $result = $this->sql; foreach ($this->GetKeyFieldValues() as $fieldName => $value) { $fieldInfo = $this->GetFieldByName($fieldName); if (isset($fieldInfo) && $this->HasKeyFieldValueFor($fieldInfo->Name)) { $result = ReplaceFirst($result, ':OLD_' . $fieldName, $this->GetCommandImp()->GetFieldValueAsSQLForUpdate($fieldInfo, $this->GetKeyFieldValueByName($fieldInfo->Name), $this->IsSetFieldValueToDefault($fieldName))); } } foreach ($this->GetFields() as $fieldInfo) { if ($this->HasFieldValueFor($fieldInfo->Name)) { $result = ReplaceFirst($result, ':' . $fieldInfo->Name, $this->GetCommandImp()->GetFieldValueAsSQLForUpdate($fieldInfo, $this->GetFieldValueByName($fieldInfo->Name), $this->IsSetFieldValueToDefault($fieldName))); } } return $result; }
public function GetSQL() { assert(count($this->keyFieldValues) > 0); $result = $this->sql; foreach ($this->keyFieldValues as $fieldName => $value) { $result = ReplaceFirst($result, ':' . $fieldName, $this->GetCommandImp()->GetFieldValueAsSQLForDelete($this->GetFieldByName($fieldName), $value)); } return $result; }
public function GetSQL() { $result = $this->sql; foreach ($this->fields as $fieldInfo) { if (array_key_exists($fieldInfo->Name, $this->fieldValues)) { $result = ReplaceFirst($result, ':' . $fieldInfo->Name, $this->GetCommandImp()->GetFieldValueForInsert($fieldInfo, $this->fieldValues[$fieldInfo->Name], isset($this->setToDefaultFields[$fieldInfo->Name]))); } } return $result; }