Sp_BtnUpdate_RevSupply (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_RevSupply'._

Narrative

Business context: 供应商评审 / 供应商评审提交打分 — supplier-rating workflow: toggles the "score submitted" flag on a revsupplymaster (supplier evaluation header) once a reviewer has finalised their scorecard.

What it does: Parses $.params[*].value[*].sId and for each master row whose bCheck=0 (note the WHERE column is bCheck, not the toggled bSubCheck), sets bSubCheck to its toggle (CASE 1↔0), stamps tSubCheckDate=NOW(), sSubCheckPerson=sMakePerson. Reads $.changeValue.textareaValue but does not persist it.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — toolbar "提交打分" button on the 供应商评审 grid. No callers in DB metadata or xly-src grep for this DB instance.

Flag: WHERE-clause column mismatch — guards on bCheck=0 (final-check) but mutates bSubCheck (sub-check). Once the parent evaluation is checked, the score-submit toggle can no longer fire even if the score itself was never recorded. Likely a copy-paste bug from the OnPurOrder template.