Sp_BtnEventMaterialsPost_New (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 PROCEDURESpBtnEventMaterialsPost_New'._

Narrative

Business context: 材料存货核算 / 材料盘点 — toolbar handler that re-posts an inventory-gain (盘盈) price/value onto an accmaterialsstore row whose source form is the 材料盘点单据 (sFormId=192116810113315228128521360). Used to back-fill an inventory-take adjustment with a unit price entered after the original count, recomputing total money.

What it does: Resolves the latest frozen sysaccountperiod (bFrozen=1, ORDER BY tStartDate DESC LIMIT 1) into p_sPeriodId (read but not used in the UPDATE — only the form gate matters). Parses $.params[*].value[*] with sId, dMaterialsPrice, sFormId. For each row where sFormId='192116810113315228128521360' AND dMaterialsPrice>0, sets accmaterialsstore.dMaterialsPrice=p_dMaterialsPrice, dMaterialsMoney=ROUND(p_dMaterialsPrice*dMaterialsQty,2) for matching (sId, sBrId, sSuId). Other form sources are silently skipped.

Invocation: Dispatched dynamically by GenericProcedureCallServiceImpl.doGenericProcedureCall() (POST /procedureCall/doGenericProcedureCall) — 材料盘点 grid's 盘盈回写 toolbar button (or similar 价格补录 action) names this proc as its action.