Fun_Sis_GetConstNew (function)

获取常量存储过程

• Type: FUNCTION
• Returns: longtext
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sLoginId	varchar(100)
2	IN	sStr	varchar(100)
3	IN	sGuid	varchar(100)
4	IN	sBrId	varchar(100)
5	IN	sSuId	varchar(100)

Body

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

Narrative

Business context: Per-user variant of Fun_Sis_GetConst. Resolves a localized constant from gdsformconst, but consults the calling user's sftlogininfo.sLanguage first before falling back to the tenant-wide SysSystemSettings.CbxLanguage. Lets individual operators see UI strings in their own preferred language even within a shared tenant.

What it does: Reads sLanguage from sftlogininfo matching sUserName/sId = sLoginId; if blank, falls back to SysSystemSettings.CbxLanguage for the tenant; then selects the matching sChinese/sEnglish/sBig5 column from gdsformconst filtered by sParentId=sGuid and sName=sStr.

Invocation: 132 routine callers — the migration target for routines that need per-login translation (subset of the Sp_BtnEvent*, Sp_Calc_s*, Sp_Check_s*, and Sp_calc_*storeLimit chains). Coexists with the older Fun_Sis_GetConst; new code is expected to favor this variant.