Sp_BtnEvent_MaterialsItestFast.md 1.5 KB

Sp_BtnEvent_MaterialsItestFast (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_MaterialsItestFast'._

Narrative

Business context: 采购 / 采购到货 — button-click handler that marks selected purpurchasearriveslave (purchase-arrival slave) lines as 快速检验 (fast inspection), shortening the QC path on the arrival document.

What it does: Validates sProInParam length, parses $.params[*].value[*].sSlaveId, and per id UPDATE purpurchasearriveslave SET bFast=1, tFastDate=NOW(), sFastPerson=sMakePerson.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — 采购到货 grid's 设置快速检验 toolbar button names Sp_BtnEvent_MaterialsItestFast as the action. Sibling of Sp_BtnEvent_KLLMaterialsItestFast (acts on purpurchaseapplyslave for customer-supplied material). Companion of Sp_BtnEvent_MaterialsItestType (which marks the material master as 免检).