Sp_ProcessInspection_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 PROCEDURESpProcessInspection_BtnRepair'._

Narrative

Business context: 品质管理 → 工序检验 — bulk-edit handler for qlyprocesstestmaster (工序检验单). When the inspector marks one or more inspection rows as 异常 from the grid and types a memo in the popup textarea, this proc updates the selected rows with iTestResult=2 (异常) and writes the memo into sExceptionMemo, plus any extra columns the grid passes via changeValue.valueKey.

What it does: Parses $.params[*].value[*].sId and $.changeValue.{valueKey,textareaValue,...} from sProInParam. Splits valueKey (comma-separated field-name list) and composes a dynamic SET col1=val1, col2=val2 … clause by extracting each named field out of changeValue. For every selected sId appends iTestResult=2, sExceptionMemo=p_textareaValue to the SET clause, then PREPARE/EXECUTE an UPDATE qlyprocesstestmaster SET … WHERE sId=p_sTmpId AND sBrandsId=sBrId AND sSubsidiaryId=sSuId. Defaults p_textareaValue to '''' when missing.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() — qlyprocesstestmaster 工序检验 grid's 标异常 (or similarly-named bulk-edit) toolbar button names this proc. No gdsmodule.sProcName binding, no form-master sSqlStr reference, no xly-src install script located.