Sp_Quotation_CalcDataFlex (procedure)

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

Parameters

#	Mode	Name	Type
1	IN	sGuid	varchar(100)
2	IN	bChangeRate	int
3	IN	sLoginId	varchar(100)
4	IN	sBrId	varchar(100)
5	IN	sSuId	varchar(100)
6	OUT	sCode	int
7	OUT	sReturn	varchar(5000)

Body

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

Narrative

Business context: 销售管理 → 报价&估计管理 — top-level quote-cost calculator for the 柔印 / 柔性 (flex / flexible-substrate) product family. Sibling of Sp_Quotation_CalcDataBookStd (书刊), Sp_Quotation_CalcDataPack (包装), Sp_Quotation_CalcDataSetStd (套装) and Sp_Quotation_CalcDataStd (general). Adds paper-rate (dPaperRate) and per-process paper input/output (dProcessPaperInQty/dProcessPaperOutQty) variables for the flex-print paper-handling model.

What it does: Same shape as the rest of the family — walks quoquotationmaster_tmp and slave/control/materials/process/control-combine _tmp snapshots populated by the front-end submission, opens cursors over the temp tables, and per control row computes dProcessInQty/dProcessOutQty, dPaperRate, dAdjustRate, dPartsQty, then writes back via Update QuoQuotationControl_Tmp / QuoQuotationMaterials_Tmp / QuoQuotationProcess_Tmp / QuoQuotationSlave_Tmp / QuoQuotationParam_tmp / quoquotationmaster_tmp. Calls Sp_Sis_GetConst for localized constants and Sp_System_ReplaceField for the localized return strings.

Invocation: Enumerated in CaclProNameEnum.SP_QUOTATION_CALCDATAFLEX (java xlyBusinessService/contant/enumeration/CaclProNameEnum.java). The proc name is passed to ManyQuoServiceImpl.addQuotationsheetManyThread(params, userInfo, sProName) for the multi-quantity quote flow and is the dispatch target read from gdsmodule.sCalcProName for the single-quantity save path. No live gdsmodule row has sCalcProName='Sp_Quotation_CalcDataFlex' in the queried tenant — the binding is present in the enum constants and tenant-specific module config; xly-src ships the install body at script/标版/30100101/Sp_Quotation_CalcDataFlex.sql.