Sp_BtnUpdate_OnPurOrder (procedure)

供应商接收订单

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sProInParam	varchar(10000)
2	IN	sMakePerson	varchar(100)
3	IN	sUserId	varchar(100)
4	IN	sBrId	varchar(100)
5	IN	sSuId	varchar(100)
6	OUT	sReturn	varchar(1000)
7	OUT	sCode	int

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpBtnUpdate_OnPurOrder'._

Narrative

Business context: 采购订单 / 供应商接收订单 — supplier portal: lets a vendor mark a purpurchaseordermaster purchase order as received/acknowledged once they have seen it in the supplier-facing grid.

What it does: Parses $.params[*].value[*].sId (master rows) and for each row whose current bSupply=0, sets bSupply to its toggle (CASE 1↔0), stamps tSupplyDate=NOW(), sSupplyPerson=sMakePerson. Reads $.changeValue.textareaValue but does not persist it.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — toolbar "接收订单" button on the 采购订单 supplier-portal grid. No callers in DB metadata or xly-src grep for this DB instance.

Flag: same bSupply=0 guard as the OnOpsOrder/OnOpsConfirm/RevSupply siblings — effectively one-way receipt-acknowledge, not a toggle.