/**
* ProductStockalarmModel::updateWarnInfo()
* 更新选择料号的预警信息
* @param array $dataarray 预警信息
* @param string $sku 料号
* @return bool
*/
public static function updateWarnInfo($sku, $dataarray)
{
self::initDB();
$res = self::isWarnInfo($sku);
if ($res) {
$sql = array2sql($dataarray);
$sql = "UPDATE `" . self::$prefix . self::$tab_skuInfo . "` SET " . $sql . " WHERE sku = '{$sku}'";
} else {
$dataarray['sku'] = $sku;
$sql = array2sql($dataarray);
$sql = "INSERT INTO `" . self::$prefix . self::$tab_skuInfo . "` SET " . $sql;
}
$query = self::$dbConn->query($sql);
if ($query) {
return true;
} else {
self::$errCode = 20000;
self::$errMsg = "执行SQL语句出错";
return false;
}
}
