Sp_afterSave_sDgd (procedure)
送货单保存后反写数量
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sGuid |
varchar(2000) |
| 2 | IN | sBrId |
varchar(100) |
| 3 | IN | sSuId |
varchar(100) |
| 4 | OUT | sCode |
int |
| 5 | OUT | sReturn |
varchar(4000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpafterSave_sDgd'._
Narrative
Business context: 送货单 (delivery / shipment note) — thin save-phase wrapper in the historic Sp_afterSave_s<Code> family. Each member is a 1-line delegator to Sp_saveReturn_s<Code> with iFlag=2 (the "after save" phase code). For _sDgd the worker is Sp_saveReturn_sDgd ("送货单单据反写") — meant to reverse-write shipped-qty onto upstream sales-order / 送货通知 rows after a 送货单 is saved.
What it does: Wraps sGuid in double-quotes if not already quoted and, when sGuid is non-empty, calls Sp_saveReturn_sDgd(sGuid, sBrId, sSuId, 2, @sCode, @sReturn). Declares a sDeliverSrc VARCHAR(100) that is never assigned or used (template artefact). Does not propagate @sCode/@sReturn to its own OUT params.
Invocation: Status: appears orphaned. No caller found in any channel (gdsmodule.sSaveProName/sCalcProName/sProcName, form-master, other routines, xly-src grep) — same decommissioned-legacy condition as the rest of the Sp_afterSave_* family; production save-phase hooks dispatch to Sp_Check_s<Code> instead. Candidate for maintainer audit.