function terminateCaiGou($rowid)
{
$sql = "select * from buyplanmain where billid=" . $rowid;
$rs = $this->db->Execute($sql);
$rs_a = $rs->GetArray();
$rukumoney = $rs_a[0]['rukumoney'];
$paymoney = $rs_a[0]['paymoney'];
$supplyid = $rs_a[0]['supplyid'];
if (count($rs_a) != 1) {
throw new Exception("单号不存在");
}
$sql = "update buyplanmain set totalmoney=rukumoney,paymoney=rukumoney where billid={$rowid}";
$this->db->Execute($sql);
$sql = "update buyplanmain_detail set num=recnum,jine=recnum*zhekou*price where mainrowid={$rowid}";
$this->db->Execute($sql);
//多付金额转为预付款
if ($paymoney > $rukumoney) {
$jine = $paymoney - $rukumoney;
$id = returnAutoIncrementUnitBillid("prepaybillid");
$curchuzhi = floatvalue(returntablefield("supply", "rowid", $supplyid, "yufukuan"));
$sql = "insert into accessprepay (id,supplyid,linkmanid,curchuzhi,jine,accountid,createman,createtime,opertype,beizhu)\n\t\t\tvalues(" . $id . "," . $supplyid . ",''," . $curchuzhi . "," . $jine . ",'','" . $_SESSION['LOGIN_USER_ID'] . "','" . date("Y-m-d H:i:s") . "','预付货款','采购单 {$rowid} 多付的金额转预付款')";
$this->db->Execute($sql);
$sql = "update supply set yufukuan=yufukuan+({$jine}) where rowid=" . $supplyid;
$this->db->Execute($sql);
}
//改变采购单状态
$this->updatebuyplanmainfahuo($rowid);
$CaiWu = new CaiWu($this->db);
$CaiWu->updatebuyplanmainfukuan($rowid);
}
