Sp_Calc_sProd (procedure)

产品价格审核

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

Parameters

#	Mode	Name	Type
1	IN	iFlag	int
2	IN	iTmpCheck	int
3	IN	sFormGuid	varchar(100)
4	IN	sGuid	varchar(100)
5	IN	sLoginId	varchar(100)
6	OUT	sReturn	varchar(5000)
7	IN	sBrId	varchar(100)
8	IN	sSuId	varchar(100)
9	OUT	sCode	int

Body

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

Narrative

Business context: Master-data product (eleproduct) audit / un-audit — the "产品价格审核" routine, intended to lock a product master row after pricing is approved. The audit flips bCheck=1, sStatus=1, stamps sCheckPerson/tCheckDate; un-audit reverses it.

What it does: Validates sGuid; guards on bCheck (refuses to re-audit / re-uncheck the same state); UPDATE eleproduct accordingly, tenant-scoped by sBrandsId/sSubsidiaryId. No back-writing, no chain calls, no workflow hook.

Invocation: Standard Sp_Calc_s<Code> audit-button slot, dispatched by Java BusinessBaseServiceImpl.getPrcName(...) against gdsmodule.sProcName. No module currently sets sProcName='Sp_Calc_sProd' in this snapshot — so although the proc is wired for the standard 审核 dispatcher contract, no live form points at it. Candidate for maintainer audit: either the binding lives in a customer overlay not in this snapshot, or this is dead/staging code superseded by another product-audit path.