# `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 PROCEDURE `Sp_Create_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.