Sp_Con_Reset (procedure)

配置还原

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

Parameters

No parameters.

Body

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

Narrative

Business context: 系统平台 → 表单配置 — 配置还原 ("config restore") for every approval-info config row in the tenant. Walks all sysbillcheckresult-bound gdsconfigformmaster rows under brand/subsidiary 1111111111/1111111111 and resets each one's sSqlStr/sOrder/slave columns back to the canonical 审批信息 layout, so a tenant-wide layout corruption can be undone in one shot.

What it does: Counts the gdsconfigformmaster rows whose sTbName='sysbillcheckresult' for the hardcoded standard-tenant id, then cursors over each sId: DELETE FROM gdsconfigformslave WHERE sParentId=p_sParentId, UPDATE gdsconfigformmaster to restore the standard biz_todo_item × biz_flow data-source SQL, and INSERT INTO gdsconfigformslave the full canonical column set (sItemName, sNodeName, bView, bHandle, tToDate, tHandleDate, …).

Invocation: Status: appears orphaned. No gdsmodule hook, gdsconfigformmaster reference, or other-routine caller; xly-src only ships the install script script/标版/30100101/Sp_Con_Reset.sql. Tenant-wide variant of Sp_Con_FormsReset; intended as a maintenance/seeding tool, not normal runtime traffic.