Sp_OutsideInspection_BtnRepair (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	sBrId	varchar(100)
4	IN	sSuId	varchar(100)
5	OUT	sReturn	varchar(1000)
6	OUT	sCode	int

Body

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

Narrative

Business context: 质量管理 / 外协检验 — Sp_BtnRepair_* family handler that marks selected 外协检验 lines as 返修 (rework / iTestResult=2) and writes the operator's exception memo back, optionally applying any other column edits captured in the dialog's valueKey list.

What it does: Validates sProInParam length (paramsErro from Sp_Sis_GetConst on failure). Parses $.params[*].value[*].sId and $.changeValue JSON. From $.changeValue.valueKey (a comma list of column names) builds a dynamic SET col=$.changeValue[0].col, ... fragment by walking the list. For each selected sId runs an UPDATE that always sets iTestResult=2, sExceptionMemo=<textareaValue> and adds the dynamic SET fragment when present.

Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep across all extensions, dynamic-dispatch search). Naming and JSON-shape match the generic Sp_BtnRepair_* contract dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() for a 返修 toolbar button on a 外协检验 grid — likely either renamed (current outside-process inspection flows use Sp_OutSideInspection_*) or wired through a customer override; verify before relying on it.