# `Sp_System_BatchNPriceMoney` (procedure)

> @author:       qmj
		     @date:         20210707 封存
			 @describe: 价格批量更新，按产品金额，目前仅订单可使用


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sFormGuid` | `varchar(100)` |
| 2 | IN | `sSrcGuid` | `varchar(100)` |
| 3 | IN | `dPrice` | `decimal(18,6)` |
| 4 | IN | `dMoney` | `decimal(18,6)` |
| 5 | IN | `dQty` | `decimal(18,6)` |
| 6 | IN | `oldQty` | `decimal(18,6)` |
| 7 | IN | `tDeliverDate` | `datetime` |
| 8 | IN | `sLoginId` | `varchar(100)` |
| 9 | IN | `sBrId` | `varchar(100)` |
| 10 | IN | `sSuId` | `varchar(100)` |
| 11 | IN | `sChangePriceMemo` | `longtext` |
| 12 | OUT | `sCode` | `int` |
| 13 | OUT | `sReturn` | `varchar(4000)` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_System_BatchNPriceMoney`'`._

## Narrative

**Business context:** 销售管理 → 销售订单 / 改价 — batch price update by 产品金额 for a sales-order line. Header comment marks it `封存` (qmj, 2021-07-07) — "目前仅订单可使用". When the user re-prices a 销售订单从表 row, this proc recomputes the line money/tax/foreign-currency fields from the new price and propagates the change to any linked 印刷工单 (`MftWorkOrderSlave`) and 送货通知/送货单 not yet confirmed, so downstream documents stay in sync with the new agreed price.

**What it does:** Reads `NetMoney`/`NetPrice` decimal settings and the `CbxDeliverGoods`/`CbxDeliverGoodsNotify` system flags from `SysSystemSettings`. Resolves the parent `SalSalesOrderMaster` for the slave id `sSrcGuid` and the order's `tCreateDate`. Checks `sysaccountperiod` — if the order's period is `bFrozen=1`, aborts with `sNoCanCheckByAccountPeriod`. Otherwise updates `SalSalesOrderSlave` with the new `dProductPrice`/`dProductMoney`/`dForeignPrice`/`dForeignMoney`/`dTax*`, joining `sistax` for the tax rate; replicates the change to `MftWorkOrderSlave` (when the slave is order-driven) and any in-flight 送货通知/送货单 rows controlled by the system settings.

**Invocation:** Dispatched dynamically by `GenericProcedureCallServiceImpl.doGenericProcedureCall()` from the 销售订单 改价 button. Java `BusinessBaseServiceImpl.updatePriceBatch` recognises the name (`equalsIgnoreCase("Sp_System_BatchNPriceMoney")`) and, after a successful run, pushes the updated `dProductMoney` to RocketMQ via `rocketMQService.pushERPOrderAmount(dict)` so a 印工厂B2B partner / cloud order (`sWebOrderId`) sees the new amount. Also called by `Sp_Calc_sQtt_hm` (报价单 audit) and the variant `Sp_System_BatchNPriceMoney_quo`. Companion: `Sp_System_BatchPriceMoney` (external-currency variant). Install: `script/标版/30100101/Sp_System_BatchNPriceMoney.sql`.