public function InsertOrderDetailExtensionEbay($detailId, $orderDetailExtend) { $table = C('DB_PREFIX') . 'unshipped_order_detail_extension_ebay'; $orderDetailExtend['omOrderdetailId'] = $detailId; $orderDetailExtend['transactionID'] = '360863697815'; $orderDetailExtend['itemURL'] = '0'; $orderDetailExtend['conditionID'] = '1000'; $orderDetailExtend['conditionDisplayName'] = 'Brand New'; $orderDetailExtend['finalValueFeeCurrency'] = 'GBP'; $orderDetailExtend['finalValueFee'] = '0.59'; $orderDetailExtend['handlingFee'] = '0.59'; $fdata = $this->formatInsertField($table, $orderDetailExtend); if ($fdata === false) { self::$errMsg = $this->validatemsg; return false; } echo "INSERT " . $table . " SET " . array2sql($fdata); //return $this->sql("INSERT ".$table." SET ".array2sql($fdata))->insert(); }
/** *修改指定表记录(只要sql运行成功就算成功) */ public static function batchMove($data, $where) { self::initDB(); $string = array2sql($data); $tName = 'om_unshipped_order'; $sql = "UPDATE {$tName} SET {$string} {$where}"; //echo $sql; exit; $query = self::$dbConn->query($sql); if ($query) { self::$errCode = "200"; self::$errMsg = "修改成功"; return true; //成功, 返回真 } else { self::$errCode = "003"; self::$errMsg = "修改失败"; return false; //失败则设置错误码和错误信息, 返回false } }