Sp_MaterialCheck_BtnEventMaterialCheckFail (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 PROCEDURESpMaterialCheck_BtnEventMaterialCheckFail'._

Narrative

Business context: 生产管理 — 主辅料稽查：稽查失败 (mark material-check fail). Per-row negative-disposition button: when stock cannot satisfy the line, the user clicks 稽查失败, optionally edits per-row fields (purchase ETA, supplier, memo) in the inline dialog, and this proc records the failure on each selected mftworkordermaterials row along with the captured fields.

What it does: Parses sProInParam. Reads $.changeValue (the dialog's edited cells) into p_changeValue, expands $[*].valueKey (the comma-separated list of edited column names) into a dynamic SET col=val, col=val ... clause p_updatefields. Appends the sMCMemo textarea if present. Then for each selected sId issues Update mftworkordermaterials with bPlanMaterialCheck=1, bPlanMaterialCheckResult=0 plus the dynamic field set. Empty payload returns the localised paramsErro message via Sp_Sis_GetConst and sCode=-1.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() — the 稽查失败 button on the 主辅料稽查 form names Sp_MaterialCheck_BtnEventMaterialCheckFail (Sp_<Module>_BtnEvent* pattern). Companion to Sp_MaterialCheck_BtnEventMaterialCheckPass and the parent enumerator Sp_MaterialCheck_BtnEventMaterialCheck. Install script ships at script/标版/30100101/schedule/Sp_MaterialCheck_BtnEventMaterialCheckFail.sql.