Sp_Check_sPca1 (procedure)
供应商送货保存之前数据校验
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sTableName |
varchar(100) |
| 2 | IN | sGuid |
varchar(100) |
| 3 | IN | sFormGuid |
varchar(100) |
| 4 | IN | sLoginId |
varchar(100) |
| 5 | IN | sBrId |
varchar(100) |
| 6 | IN | sSuId |
varchar(100) |
| 7 | IN | iFlag |
int |
| 8 | OUT | sCode |
int |
| 9 | OUT | sReturn |
varchar(4000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpCheck_sPca1'._
Narrative
Business context: Post-save validator nominally for 供应商送货 (per procedure summary), targeting purpurchasearriveshmaster/purpurchasearriveshslave (the *sh send-delivery variant of 采购到货). Same shape as Sp_Check_sPca but cursors over the *sh slave table.
What it does: Reads NetMoney/NetPrice precision from SysSystemSettings, gates on IFNULL(sFormGuid,'') <> '', then opens a cursor over purpurchasearriveshslave joined to elematerials (for bInverse, sReComputeId, sComputeId, sMaterialsName) and sistax (for dRate). For each row recomputes dMaterialsMoney/dMaterialsNoTaxMoney/dMaterialsTaxMoney/dAuxiliaryQty via the material's 正算/反算 formula and rounds to p_NetMoney/p_NetPrice.
Invocation: Status: appears orphaned. No gdsmodule.sSaveProName/sSaveProNameBefore/sProcName/sDeleteProName row references it; no form-master sSqlStr ref; no other DB routine calls it; xly-src grep yields no hit (no install script under script/标版/). Looks like a _1 variant of Sp_Check_sPca that was forked for the *sh送货 flow but never wired up — candidate for maintainer audit.