$rs->close(); if ($action == 'save') { //保存退货单及记录 $bsql = new Dedesql(false); $query = "select * from #@__sale where rdh='{$r_dh}'"; //遍历此单产品 $bsql->SetQuery($query); $bsql->Execute(); $rowcount = $bsql->GetTotalRow(); if ($rowcount == 0) { ShowMsg('非法参数或没有要销售的产品!', '-1'); exit; } else { checkbank(); $money = 0; while ($row = $bsql->getArray()) { $money += $row['number'] * getsale($row['productid']); $csql = new dedesql(false); $csql->setquery("select * from #@__mainkc where p_id='" . $row['productid'] . "'"); $csql->execute(); $totalrec = $csql->gettotalrow(); if ($totalrec != 0) { $csql->executenonequery("update #@__mainkc set number=number-" . $row['number'] . " where p_id='" . $row['productid'] . "'"); } } $csql->close(); $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); WriteNote('退货单' . $r_dh . '成功保存', $logindate, $loginip, $username); $newsql = new dedesql(false);