sp_getAllPartsName (procedure)

实际库存

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

Parameters

#	Mode	Name	Type
1	IN	sProductclassifyld	varchar(4000)
2	IN	sBrId	varchar(100)
3	IN	sSuId	varchar(100)

Body

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

Narrative

Business context: Splits the comma-delimited sAllPartsName string stored on sisproductclassify (产品分类's pre-aggregated parts list) into a per-row sId/sName resultset. The carried COMMENT '实际库存' is a copy-paste leftover; the actual purpose is a dropdown/lookup helper that returns each 部件名称 (parts name) configured for a product classification.

What it does: Looks up sAllPartsName from sisproductclassify for the given sProductclassifyld. If non-empty, walks the comma-split tokens via Fn_spit_length and Fn_split_string (split-string helpers), inserting each non-blank token as a row into the temporary table p_t_sId(sId, sName) where both columns hold the same string. Then SELECT * FROM p_t_sId — returning the parts-name list to the caller. No reads from any stock/inventory table.

Invocation: Status: appears orphaned via static scan. No gdsmodule hook, no gdsconfigformmaster reference, no other proc CALLs it, no xly-src grep hit. The proc's signature and output shape match the conventional 下拉选项 (dropdown options) data-source — most likely wired into a front-end cascade selector through a registration channel outside gdsconfigformmaster. Candidate for maintainer audit to confirm.