Sp_DieCut_BtnEventReceive.md 2.13 KB

Sp_DieCut_BtnEventReceive (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 IN sMachineId 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 PROCEDURESpDieCut_BtnEventReceive'._

Narrative

Business context: 移动端管理 → 现场 → 功能操作 → 领用模具 — die-cut / knife-mould checkout button on the mobile shopfloor app. The worker scans the knife-mould product on a machine; this proc flips the mould's state to "in use", stamps the recipient, and logs a store-out history row.

What it does: Validates sProInParam as JSON (aborts with localized "paramsErro" if not), extracts $.params[0].value (the slave array, "请选择数据" if empty). For each row: resolves the knife-mould master sParentId from eleknifemouldproduct.sId = p_sSlaveId; UPDATE eleknifemould SET sState=2 (领用中), sRecipientPerson=sMakePerson, tRecipientPerson=NOW(); reads elemachine.sMachineName for the destination; computes next iOrder from eleknifemouldproductstore; INSERT INTO eleknifemouldproductstore a history row carrying the product/customer/technology-ver/recipient/machine/state(=领用)/knife-mould-id/sSrcFormId.

Invocation: Parameter shape matches the GenericProcedureCallServiceImpl.doGenericProcedureCall toolbar-button contract (Sp_<Module>_BtnEvent*). No live gdsmodule hook, no gdsconfigformmaster data-source, no other routine references it, and the only xly-src hit is the install script script/标版/30100101/Sp_DieCut_BtnEventReceive.sql. Wired up via a sysbtn/toolbar action descriptor in the mobile shopfloor 领用模具 page (sId 101251240115015902879009710) — verify in BACK that the binding is still attached. Paired with Sp_DieCut_BtnEventReturn for the mould return.