Sp_BtnEvent_UpdateOpsAgainCar (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_UpdateOpsAgainCar'._

Narrative

Business context: 工序发外 — toolbar handler for the "再次派车" (re-dispatch transport) flow on 工序发外明细 (opsoutsideprocessslave). Allows resetting send-out and send-back carrier quantities so a fresh派车单 can be issued against the same outsource process line.

What it does: Parses $.params[*].value[*].sId from sProInParam. For each master id, updates every opsoutsideprocessslave row whose sParentId=p_sId: increments iOutNum=iOutNum+1, resets dInSendCarQty=0, dOutSendCarQty=0. Returns sCode=-1, paramsErro on missing input.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — 工序发外 grid's 再次派车 toolbar button names this proc as its action. Sibling: Sp_BtnEvent_UpdateOutProcessLogistics for setting the in/out logistics method on the same slave table.