# `Sp_System_BatchNPriceMoney_quo` (procedure)

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


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sSrcGuid` | `varchar(100)` |
| 2 | IN | `p_dPrice` | `decimal(18,6)` |
| 3 | IN | `sLoginId` | `varchar(100)` |
| 4 | IN | `sBrId` | `varchar(100)` |
| 5 | IN | `sSuId` | `varchar(100)` |
| 6 | OUT | `sCode` | `int` |
| 7 | OUT | `sReturn` | `varchar(4000)` |

## Body

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

## Narrative

**Business context:** 销售管理 → 报价单 / 改价 (报价(quo)variant) — quotation-side trimmed copy of `Sp_System_BatchNPriceMoney`. Same intent (按产品金额 batch re-pricing) but the signature is reduced to `(sSrcGuid, p_dPrice, sLoginId, sBrId, sSuId, OUT sCode, OUT sReturn)` — only price comes from the caller, money/qty/dates are derived. Header `封存` (qmj, 2021-07-07).

**What it does:** Reads `NetMoney`/`NetPrice` decimal settings and `CbxDeliverGoods`/`CbxDeliverGoodsNotify` flags from `SysSystemSettings`. Resolves the parent `SalSalesOrderMaster` for slave id `sSrcGuid` and checks the order's `sysaccountperiod` — aborts with `sNoCanCheckByAccountPeriod` when frozen. Updates `MftWorkOrderSlave` (joined with `sistax`) with the new `dNProductPrice`-driven money/tax fields. The proc-comment leftover ("目前仅订单可使用") and the `_quo` suffix reflect that this body was peeled out of the order variant for the 报价单 audit path.

**Invocation:** Called by `Sp_Calc_sQtt_hm` — the audit (`Sp_Calc_s*`) handler for 报价单, dispatched by `BusinessBaseServiceImpl.getPrcName(sFormGuid, …)` on report audit. No xly-src file references this name directly — DB-only wiring. No standalone install script ships in `script/标版/30100101/` for this `_quo` variant; deploy from `Sp_System_BatchNPriceMoney.sql` family if missing.
