function act_updateTNameRow($tName, $set, $where)
{
$ret = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($ret !== FALSE) {
return $ret;
} else {
self::$errCode = WhIoStoreModel::$errCode;
self::$errMsg = WhIoStoreModel::$errMsg;
return false;
}
}
function act_updateTNameRow()
{
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串
if (empty($jsonArr)) {
self::$errCode = 101;
self::$errMsg = '参数数组为空';
return false;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = 103;
self::$errMsg = '参数数组不是数组格式';
return false;
}
$tName = $jsonArr['tName'];
//表名
$set = $jsonArr['set'];
//set，用关键字SET
$where = $jsonArr['where'];
//where,要带上关键字WHERE
if (empty($tName) || empty($set) || empty($where)) {
self::$errCode = '300';
self::$errMsg = '必要参数不完整';
return false;
}
$affectRows = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($affectRows !== FALSE) {
self::$errCode = '200';
self::$errMsg = '成功';
return $affectRows;
} else {
self::$errCode = '404';
self::$errMsg = '数据库操作错误';
return false;
}
}
function act_updateWhIoStoreStatus()
{
$id = isset($_GET['id']) ? $_GET['id'] : '';
//id
$ioStatus = $_GET['ioStatus'];
//待修改数量的sku
if (empty($id)) {
self::$errCode = 0101;
self::$errMsg = 'empty id';
return 0;
}
if (!isset($_GET['ioStatus'])) {
self::$errCode = 0201;
self::$errMsg = 'unset ioStatus';
return 0;
}
$ioStatus = intval($ioStatus);
if ($ioStatus != 0 && $ioStatus != 1) {
self::$errCode = 0301;
self::$errMsg = 'illegal ioStatus';
return 0;
}
$tName = 'wh_iostore';
$set = "SET ioStatus='{$ioStatus}' ";
$where = "WHERE id='{$id}' ";
$affectRows = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($affectRows === FALSE) {
//执行错误或者无affectedRow
self::$errCode = 0401;
self::$errMsg = 'updateRow error';
return 0;
} else {
self::$errCode = 200;
self::$errMsg = 'success';
return $affectRows;
}
}
