/**
*
* @param 产品id $productID
* @param 产品基本信息id $basicinfoID
* @return boolean 执行结果
* 1. 删除product表中数据
* 2. 删除product_basicinfo 表中数据
*/
public function deleteProduct($productID, $basicinfoID)
{
$result = false;
$productResult = false;
$basicinfoResult = false;
//获取数据库连接
$conn = DaoBase::_getConn();
mysql_query("BEGIN");
//或者mysql_query("START TRANSACTION");
if (!empty($productID) && !empty($basicinfoID)) {
$daoProdcut = new DaoProduct();
$productResult = $daoProdcut->updateTransaction($conn, array("product_isdelete" => 1), array("product_id = " => $productID));
$daoProductBasicinfo = new DaoProductBasicinfo();
$basicinfoResult = $daoProductBasicinfo->updateTransaction($conn, array("basicinfo_isdelete" => 1), array("basicinfo_id = " => $basicinfoID));
}
$result = $productResult && $basicinfoResult;
if ($result) {
mysql_query("COMMIT");
} else {
mysql_query("ROLLBACK");
}
DaoBase::_closeConn($conn);
return $result;
}
/**
* 保存产品基本信息
* 分为两种情况，1、更新产品信息;2、新建产品基本信息
*/
private function saveBasicinfo($basicinfo, $conn)
{
$res = array("result" => false);
if (empty($basicinfo)) {
return $res;
}
if (empty($basicinfo['basicinfo_id'])) {
//新建产品基本信息
//添加参数 basicinfo_status = 1，basicinfo_isdelete = 0
$basicinfo['basicinfo_status'] = 1;
$basicinfo['basicinfo_isdelete'] = 0;
//增加basicinfo_time
$basicinfo['basicinfo_time'] = Tools::getNowTime();
$dao = new DaoProductBasicinfo();
$resInsert = $dao->insertTransaction($basicinfo, $conn);
if ($resInsert) {
$res['result'] = true;
$res["basicinfo_id"] = (int) $dao->_getLastId($conn);
}
} else {
//更新产品基本信息
$basicinfoID = $basicinfo['basicinfo_id'];
unset($basicinfo['basicinfo_id']);
$dao = new DaoProductBasicinfo();
$resUpdate = $dao->updateTransaction($conn, $basicinfo, array("basicinfo_id =" => $basicinfoID));
if ($resUpdate) {
$res['result'] = true;
$res["basicinfo_id"] = $basicinfoID;
}
}
return $res;
}
