PHP global_common::ExecutequeryWithCheckExistedTable方法代码示例

 public function update($storeid, $categoryid)
 {
     $strTableName = self::TBL_SL_STORECATEGORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_STORECATEGORY, array($strTableName, global_common::escape_mysql_string($storeid), global_common::escape_mysql_string($categoryid)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_STORECATEGORY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_storecategory:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($trackerID, $userID, $trackType, $value, $description, $trackDate)
 {
     $strTableName = self::TBL_SL_TRACKER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_TRACKER, array($strTableName, global_common::escape_mysql_string($trackerID), global_common::escape_mysql_string($userID), global_common::escape_mysql_string($trackType), global_common::escape_mysql_string($value), global_common::escape_mysql_string($description), global_common::escape_mysql_string($trackDate)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_TRACKER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add SL_TRACKER:' . $strSQL, 1);
         return false;
     }
     return $trackerID;
 }

 public function update($advertisingid, $advertisingname, $partnerid, $startdate, $enddate, $adtypeid, $catID, $content, $imagelink, $preferlink, $order, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_ADVERTISING;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_ADVERTISING, array($strTableName, global_common::escape_mysql_string($advertisingid), global_common::escape_mysql_string($advertisingname), global_common::escape_mysql_string($partnerid), global_common::formatDateTimeSQL($startdate), global_common::formatDateTimeSQL($enddate), global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($content), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($preferlink), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status), $catID));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_advertising:' . $strSQL, 1);
         return false;
     }
     return $advertisingid;
 }

 public function update($paymentmodeid, $paymentmodename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_PAYMENT_MODE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PAYMENT_MODE, array($strTableName, global_common::escape_mysql_string($paymentmodeid), global_common::escape_mysql_string($paymentmodename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PAYMENT_MODE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_payment_mode:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($currencyid, $currencyname, $eurorate, $usdrate, $audrate, $ndtrate, $cadrate, $gbprate, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_CURRENCY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CURRENCY, array($strTableName, global_common::escape_mysql_string($currencyid), global_common::escape_mysql_string($currencyname), global_common::escape_mysql_string($eurorate), global_common::escape_mysql_string($usdrate), global_common::escape_mysql_string($audrate), global_common::escape_mysql_string($ndtrate), global_common::escape_mysql_string($cadrate), global_common::escape_mysql_string($gbprate), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CURRENCY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_currency:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($adtypeid, $adtypename, $width, $height, $numofday, $displaypage, $shareditem, $price, $cityid, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_AD_TYPE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_AD_TYPE, array($strTableName, global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($adtypename), global_common::escape_mysql_string($width), global_common::escape_mysql_string($height), global_common::escape_mysql_string($numofday), global_common::escape_mysql_string($displaypage), global_common::escape_mysql_string($shareditem), global_common::escape_mysql_string($price), global_common::escape_mysql_string($cityid), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_AD_TYPE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_ad_type:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($requesid, $contentrequest, $requestedby, $requesteddate, $contentrespone, $responedby, $responeddate, $isapproved, $isdeleted)
 {
     $strTableName = self::TBL_SL_REQUEST;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_REQUEST, array($strTableName, global_common::escape_mysql_string($requesid), global_common::escape_mysql_string($contentrequest), global_common::escape_mysql_string($requestedby), global_common::escape_mysql_string($requesteddate), global_common::escape_mysql_string($contentrespone), global_common::escape_mysql_string($responedby), global_common::escape_mysql_string($responeddate), global_common::escape_mysql_string($isapproved), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_REQUEST, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_request:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($auctionid, $userid, $price, $offereddate, $deleteddate, $isdelete, $status)
 {
     $strTableName = self::TBL_SL_OFFER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_OFFER, array($strTableName, global_common::escape_mysql_string($auctionid), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($price), global_common::escape_mysql_string($offereddate), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdelete), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_OFFER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_offer:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($productpriceid, $productid, $retailer, $productlink, $typeid, $order, $statusid, $status)
 {
     $strTableName = self::TBL_SL_PRODUCT_PRICE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PRODUCT_PRICE, array($strTableName, global_common::escape_mysql_string($productpriceid), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($retailer), global_common::escape_mysql_string($productlink), global_common::escape_mysql_string($typeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($statusid), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT_PRICE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product_price:' . $strSQL, 1);
         return false;
     }
     return $productpriceid;
 }

 public function update($contentid, $subcontents, $periodtime, $type)
 {
     $strTableName = self::TBL_SL_CONTENT_SUMMARY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CONTENT_SUMMARY, array($strTableName, global_common::escape_mysql_string($contentid), global_common::escape_mysql_string($subcontents), global_common::escape_mysql_string($periodtime), global_common::escape_mysql_string($type)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CONTENT_SUMMARY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_content_summary:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($propertyid, $propertyname, $productid, $propertyvalue, $datatypeid, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_PROPERTY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PROPERTY, array($strTableName, global_common::escape_mysql_string($propertyid), global_common::escape_mysql_string($propertyname), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($propertyvalue), global_common::escape_mysql_string($datatypeid), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PROPERTY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_property:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($likeid, $likeamount, $unlikeamount, $likeusers, $unlikeusers)
 {
     $strTableName = self::TBL_SL_LIKE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_LIKE, array($strTableName, global_common::escape_mysql_string($likeid), global_common::escape_mysql_string($likeamount), global_common::escape_mysql_string($unlikeamount), global_common::escape_mysql_string($likeusers), global_common::escape_mysql_string($unlikeusers)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_LIKE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_like:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($manufactoryid, $manufactoryname, $categoryid, $order, $modifiedby, $isdeleted)
 {
     $strTableName = self::TBL_SL_MANUFACTORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_MANUFACTORY, array($strTableName, global_common::escape_mysql_string($manufactoryid), global_common::escape_mysql_string($manufactoryname), global_common::escape_mysql_string($categoryid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), $isdeleted));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_MANUFACTORY, $this->_objConnection, $strTableName)) {
         echo $strSQL;
         global_common::writeLog('Error add sl_manufactory:' . $strSQL, 1);
         return false;
     }
     return $manufactoryid;
 }

 public function activeRetailer($retailerID, $statusID)
 {
     $strTableName = self::TBL_SL_RETAILER;
     $strSQL = global_common::prepareQuery(self::SQL_ACTIVE_SL_RETAILER, array($strTableName, global_common::escape_mysql_string($retailerID), $statusID));
     //echo $strSQL;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RETAILER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error activeRetailer sl_retailer:' . $strSQL, 1);
         return false;
     }
     return $retailerID;
 }

 public function cloneProduct($productid, $createdBy)
 {
     $strTableName = self::TBL_SL_PRODUCT;
     $intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ProductID, $strTableName) + 1;
     $strSQL = global_common::prepareQuery(self::SQL_CLONE_SL_PRODUCT, array($strTableName, $productid, $intID, global_common::escape_mysql_string($createdBy), global_common::nowSQL()));
     //echo $strSQL;
     //return;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product:' . $strSQL, 1);
         return false;
     }
     return $intID;
 }