Sp_elematerials_UpdateStyle (procedure)
物料信息保存过程
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sGuid |
varchar(2000) |
| 2 | IN | sData |
longtext |
| 3 | IN | sAllData |
longtext |
| 4 | IN | sFormGuid |
varchar(100) |
| 5 | IN | sLoginId |
varchar(100) |
| 6 | IN | sBrId |
varchar(100) |
| 7 | IN | sSuId |
varchar(100) |
| 8 | OUT | sCode |
int |
| 9 | OUT | sReturn |
varchar(4000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpelematerials_UpdateStyle'._
Narrative
Business context: "卷筒料只能输入材料宽" guard. For reel-stock materials (elematerials.bReel=1), the safety-stock rows on elematerialssafe must not carry a length spec (sLength1) — only width is meaningful for a reel. Same body as the trailing block of Sp_elematerials_AfterUpdate, factored into a standalone proc.
What it does: Two COUNT(*) probes against elematerialssafe JOIN elematerials on bReel=1 AND sLength1<>'': one keyed by exact sId=sGuid, one by LOCATE(A.sId, sGuId)>0 (multi-id selection). If either count is positive, aborts with sCode=-1 and sReturn = Fun_Sis_GetConstNew('', 'sJtMaterialOnlyInputWidth', '', sBrId, sSuId).
Invocation: Status: appears orphaned. No gdsmodule hook, no form-master, no other routine CALLs it, no xly-src reference. The "UpdateStyle" suffix is non-standard for xly's dispatcher slots; appears to be a refactor extract of the reel-stock check from `Spelematerials_AfterUpdate` that was never wired. Candidate for maintainer audit.