# `Sp_commonList_BtnEventUpdatedDoing` (procedure)

> @author:杨恒林
							@date:20210616 封存
							@describe: 当系统的计算的成本不准确时，可以人工调整， 在产品存货核算界面 调用


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 2 | IN | `sMakePerson` | `varchar(100)` |
| 3 | IN | `sBrId` | `varchar(100)` |
| 4 | IN | `sSuId` | `varchar(100)` |
| 5 | OUT | `sReturn` | `varchar(1000)` |
| 6 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 成本管理 → 产品存货核算 — manual cost-price override for in-progress products. Body comment marks it "封存" (sealed/archived since 20210616) — was the list-button handler that let an operator overwrite the system-computed cost when WIP product accounting numbers came back wrong, scoped to the previous month's period window.

**What it does:** Computes the previous month's window (`p_tStratdate` = first-of-last-month, `p_tEnddate` = first-of-current-month) from `NOW()`, parses the `sProInParam` JSON envelope to pull selected `sSlaveId` rows and the new `dCostPrice` from `changeValue`, then iterates the selection writing the override into in-progress product cost tables driven by a dynamic `valueKey` column.

**Invocation:** Status: appears orphaned. No `gdsmodule` hook, `gdsconfigformmaster` reference, or other-routine caller, and no xly-src hit. Author comment explicitly marks it as sealed/封存 — superseded by newer cost-adjustment routines. Candidate for maintainer audit before deletion.
