Sp_Calc_sBBProcess (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_sBBProcess'._

Narrative

Business context: 补版任务 (re-plate / patch-plate outsourced process) — audit / un-audit hook on mftoutprocessmaster. A 补版任务 is a small outsourced rework job (typically when a printing plate needs partial re-engraving); this routine flips its check state.

What it does: Validates sGuid. With iFlag=1: refuses if the row is already bCheck=1, otherwise sets mftoutprocessmaster.bCheck=1, sStatus=1, sCheckPerson=sLoginId, tCheckDate=NOW(). With iFlag=0: symmetric uncheck — refuses if already unchecked, then clears the same fields. Lightweight: no slave-row posting, no cross-table writes.

Invocation: Status: appears orphaned. No gdsmodule.sProcName/sSaveProName/sDeleteProName/sSaveProNameBefore binding, no gdsconfigformmaster reference, no other procedure or function calls it, no xly-src hit. The proc comment 补版任务 plus the standard Sp_Calc_s* audit signature suggests it was authored for a planned 补版任务 module that either ships disabled or is wired only at a customer site not represented in this DB instance. Candidate for maintainer audit.