# `Sp_Calc_sAcod` (procedure)

> 客户框架协议


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `iFlag` | `int` |
| 2 | IN | `iTmpCheck` | `int` |
| 3 | IN | `sFormGuid` | `varchar(100)` |
| 4 | IN | `sGuid` | `varchar(100)` |
| 5 | IN | `sLoginId` | `varchar(100)` |
| 6 | OUT | `sReturn` | `varchar(5000)` |
| 7 | IN | `sBrId` | `varchar(100)` |
| 8 | IN | `sSuId` | `varchar(100)` |
| 9 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 销售管理 / 客户档案 — 客户框架协议 (customer framework agreement / accord) check / uncheck on `elecustomeraccord`. Approves a multi-period sales-pricing-or-volume agreement with a customer so it can act as a price/discount baseline downstream.

**What it does:** Validates `sGuid`. With `iFlag=1`: refuses if already `bCheck=1` (returns `sNoCanCheckBybCheck`); else sets `bCheck=1, sStatus=1, sCheckPerson=sLoginId, tCheckDate=NOW()`. With `iFlag<>1`: guards on `bCheck=0` then clears the four fields. Scoped by `sBrandsId/sSubsidiaryId`. No accounting-period or invalid-flag guard.

**Invocation:** Status: appears orphaned. No caller found in any channel (gdsmodule hooks, gdsmoduleflow, form-master, other routines, xly-src grep) — candidate for maintainer audit. Standard `Sp_Calc_*` check-hook signature; likely bound only in customer-specific overrides.

Flag: uncheck branch reuses `sNoCanCheckBybCheck` instead of `sNoCanCheckBybUnCheck` — same copy-paste bug as `Sp_Calc_Product`.