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.