# `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 FUNCTION `Fun_Sis_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.
