Sp_Check_eleteststandardProcess (procedure)

外发工序检验规则保存之前数据校验

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

Parameters

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

Body

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

Narrative

Business context: 外发工序检验规则 (form 1691254111217054007077750, currently not present in this tenant's gdsmodule) under 质检规则设定 → 质量管理 — before saving an outsourced-process inspection rule, prevent the same process from being registered in more than one active rule.

What it does: Cursors eleteststandardobject rows under sGuid, and for each sTestObjectId (process), counts other eleteststandard rows in form 1691254111217054007077750 carrying the same object. If any exist, returns sCode = -1 with the localised sStandardHaveProcess message plus conflicting rule names. Also rejects duplicate processes within sGuid itself.

Invocation: Save-time check for the 外发工序检验规则 form — invoked via the Sp_Check_* dispatcher from the form's Sp_Calc_* save procedure.

The target form id (1691254111217054007077750) is not present in this tenant's gdsmodule/gdsconfigformmaster, so this routine may be dormant on the current deployment — likely a feature reserved for tenants that enable outsourced-process inspection.