Sp_Create_sControlFaceNameTableOne (procedure)

插入ControlFaceName

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	p_sControlFaceName	longtext
2	IN	p_i	int
3	OUT	p_iOut	int
4	IN	p_sControlFacesCharDefalut	varchar(255)
5	IN	p_sControlFacesTitleFirst	varchar(255)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpCreate_sControlFaceNameTableOne'._

Narrative

Business context: 生产管理 → 排版/拼版 — case 1 of the 控版面名 (sControlFaceName) splitter: the simple single-signature shape A with no +, -, or ,. Inserts a single canonical row into sControlFaceName_tmp so the downstream 制造计划 slave generator can iterate signatures uniformly even for the trivial case.

What it does: Guards on INSTR(p_sControlFaceName,'-')=0 AND INSTR(...,'+')=0 AND INSTR(...,',')=0. Resolves the title-first override (p_sControlFacesTitleFirst) when supplied, applies Fun_GetGb for char-class normalisation via Fn_split_string/Fn_spit_length, then INSERT INTO sControlFaceName_tmp(iIndex, sControlFacesChar, sId) one row with the cleaned name plus a fresh NewId(), and copies p_i to p_iOut.

Invocation: Called by Sp_Create_sControlFaceNameTable (the public entry point) as the first dispatch branch in the signature-shape ladder.