Sp_BtnEvent_KLLMaterialsItestFast.md 1.56 KB

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

Body

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

Narrative

Business context: 采购 / 客来料请购 — button-click handler that marks selected purpurchaseapplyslave (purchase-apply slave) rows for the "客来料" (customer-supplied material, KLL) flow as 快速检验 (fast inspection), so the QC stage uses the abbreviated test path instead of full incoming-inspection.

What it does: Validates sProInParam length, parses $.params[*].value[*].sSlaveId, and per id UPDATE purpurchaseapplyslave SET bFast=1, tFastDate=NOW(), sFastPerson=sMakePerson. Default sReturn='确认成功!'.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — 客来料请购 grid's 设置快速检验 toolbar button names Sp_BtnEvent_KLLMaterialsItestFast as the action. Sibling of Sp_BtnEvent_MaterialsItestFast (which acts on purpurchasearriveslave for normal purchase-arrival rows).