Sp_Calc_sEmp (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 PROCEDURESpCalc_sEmp'._

Narrative

Business context: 设备管理 → 设备单据 — equipment-plan audit on etpmachineplanmaster. Thin check/uncheck hook for a machine-plan (设备计划) master record — sets the bill bCheck=1, sStatus=1 so the planned schedule becomes the system of record.

What it does: Validates sGuid, refuses when bInvalid=1. With iFlag=1: guards on already-bCheck=1 then Update etpmachineplanmaster setting bCheck=1, sStatus=1, sCheckPerson, tCheckDate. With iFlag<>1: symmetric uncheck guard on bCheck=0. Standard thin Sp_Calc_s<Code> audit shape.

Invocation: Status: dormant — no live gdsmodule.sProcName binding, no sSaveProName hook, no other-routine CALLs, no Java reference. Ships only as xly-src/script/标版/30100101/Sp_Calc_sEmp.sql install script. The proc is deployed but the matching etpmachineplanmaster module hook is wired only via customer-specific override scripts.

Note: COMMENT reads '商机跟进', copy-paste artefact from the template — ignore.