# `Sp_System_CheckFlow` (procedure)

> 业务单据校验


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sAllGuids` | `varchar(1000)` |
| 2 | IN | `sSlaveGuid` | `varchar(1000)` |
| 3 | IN | `sTbNames` | `varchar(1000)` |
| 4 | IN | `sTypes` | `varchar(1000)` |
| 5 | IN | `sFormGuid` | `varchar(100)` |
| 6 | IN | `sGuid` | `varchar(100)` |
| 7 | OUT | `sReturn` | `varchar(4000)` |
| 8 | IN | `sLoginId` | `varchar(100)` |
| 9 | IN | `sBrId` | `varchar(100)` |
| 10 | IN | `sSuId` | `varchar(100)` |
| 11 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** Generic 审批流条件检查 — evaluates every active `elecheckmodel` row tied to a form id against the candidate bill's joined master/slave/base-entity values via `Sisformula`, returning a pipe-delimited `slave-master-formula` digest of which conditions matched. Invoked by the `Sp_Calc_s*` audit slot of every business module whose `SysSystemSettings.CkxDefineCheck=1`, so 销售/采购/生产/委外/品质 audit buttons all share this single approval-routing engine.

**What it does:** First rejects re-submission while `sysMsg` already holds a pending 审批 message for the same `sGuid`/`sType=2`. Then cursors over `elecheckmodel WHERE sFormId=sFormGuid AND bActivate=1`, and inside each model cursors `elecheckmodelcondition` joined to `Sisformula`; for every condition it calls `Sp_System_ReplaceField` with the caller's `sAllGuids/sTbNames/sTypes` payload to evaluate the formula and, if the returned `p_sFieldsReturn=1`, appends `slaveGuid-modelGuid-formulaName` to `sReturn`. `sCode` stays 1 unless `Sp_System_ReplaceField` itself reports an error.

**Invocation:** Static `CALL Sp_System_CheckFlow(...)` from virtually every `Sp_Calc_s<Code>` (e.g. `Sp_Calc_sAcc`, `Sp_Calc_sDgn`, `Sp_Calc_sQtt_hm`, ~50 more) inside their `iFlag=1 AND iDefineCheck=1 AND iTmpCheck<>1` audit branch. No direct form-master / gdsmodule / Java wiring — exclusively a helper for the `Sp_Calc_s*` audit family. Install script at `script/标版/30100101/Sp_System_CheckFlow.sql`.
