function PF_amount($conn, $XmlDoc, $memberid, $logistickind, $amount, $memo) { $DB = new DBclass(); $DB->conn = $conn; $DB->Table = "amount"; $DB->FieldAdd("memberid", $memberid, "N"); //店名 $DB->FieldAdd("logistickind", $logistickind, "N"); //點數狀態 $DB->FieldAdd("amount", $amount, "N"); //數量 $DB->FieldAdd("userid", $_SESSION['userid'], "N"); //服務人員 $DB->FieldAdd("memo", $memo, "S"); //備註 $DB->FieldAdd("adddate", "DATE", "D"); //建立時間; $DB->Action = "insert"; //$DB->Debug="1"; $DB->Execute(); $sSQLCmd = "update member set memberbouns=memberbouns" . PF_SearchXML($XmlDoc, "//參數設定檔/點數狀態/KIND/傳回值", "加減項", $logistickind) . $amount . " where memberid=" . $memberid; PF_Get_rs($conn, $sSQLCmd); $amountid = PF_GETField($conn, "select max(amountid) from amount"); $sSQLCmd = "update amount set lastamount=(select memberbouns from member where memberid=" . PF_ReSqlCmd($memberid, "N") . ") where amountid=" . PF_ReSqlCmd($amountid, "N"); PF_Get_rs($conn, $sSQLCmd); }