/** * * @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; }