sp_OEE_Exit.md 1.55 KB

Edit Raw Blame History Permalink



sp_OEE_Exit (procedure)


@author:钱豹
                            @date:20210908 封存
                            @describe: OEE登录成功时：
                            1、更新班组下岗标记


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL


Parameters


#
Mode
Name
Type


1
IN
sMachineId
varchar(100)


2
IN
sTeamId
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 PROCEDUREspOEE_Exit'._


Narrative

Business context: OEE管理 — "下岗" (sign-off) hook fired when a 班组 (shift team) leaves an OEE machine workstation. Counterpart to sp_OEE_loading (sign-on); flips the team's bWorking flag back to 0 so the next sign-on starts from a clean slate.

What it does: Single UPDATE eleteam SET bWorking = 0 WHERE sId = sTeamId AND sBrandsId = sBrId AND sSubsidiaryId = sSuId. Header comment @author:钱豹 @date:20210908 封存 marks the routine as archived/legacy. The "登录成功时" wording in the comment is mislabelled — the body acts on sign-off.

Invocation: Install script ships at script/标版/30100101/schedule/sp_OEE_Exit.sql. No gdsconfigformmaster binding, no gdsmodule hook, no other proc/function call, no Java reference in xly-src — paired logically with sp_OEE_loading but currently not reached by any code path. Status: appears orphaned; candidate for maintainer audit.