# `Sp_OpsOutsideprocess_CheckUpdate` (procedure)

> 成品外购保存校验


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sGuid` | `varchar(100)` |
| 2 | IN | `sFormGuid` | `varchar(100)` |
| 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_OpsOutsideprocess_CheckUpdate`'`._

## Narrative

**Business context:** 外协管理 / 工序发外 (variant: 成品外购) — pre-save validator/recompute for the 成品外购 master record. Aggregates 其它费用 onto each product line, recomputes 单价/金额 and tax-decomposition columns, and refuses to save when the same product appears at multiple prices on one master.

**What it does:** For the master `sGuid`: zeros `dOldMaterialsPrice` on rows where `dMaterialsPrice=0`, snapshots `dMaterialsPrice → dOldMaterialsPrice`, recomputes `dOldMaterialsMoney`. If any slaves exist on the master, aggregates per (`sParentId,sProductId,sId`) summing `dOldMaterialsMoney + dOtherMoney` into a new `dMaterialsMoney`, then derives `dMaterialsPrice = ROUND(dMaterialsMoney/dMaterialsQty,6)`. Joins `sistax` to refresh `dMaterialsNoTaxPrice/dMaterialsNoTaxMoney/dMaterialsTaxMoney`. Aborts with `sCode=-1` and `'该订单存在相同产品，单价不一致数据，请检查修改后重新保存！'` when the same `sProductId` ends up with multiple distinct `dMaterialsPrice` values. Finally clears the `dOld*` snapshot columns when `iCheckCount=0`.

**Invocation:** Called by sibling check-routines `Sp_Check_sOpc` and `Sp_Check_sOpp` — i.e. wired into the pre-save validator chain (`gdsmodule.sSaveProName`/`sSaveProNameBefore`) of the 成品外购 / 工序发外 forms, dispatched by `BusinessBaseServiceImpl` during the save flow.
