Sp_Quotation_CalcDataStd (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_CalcDataStd'._
Narrative
Business context: 销售管理 → 销售单据 — standard quotation-form price calculator. Runs the full quote-cost pipeline against the temp staging tables (QuoQuotationmaster_Tmp / _slave_tmp / _control_tmp / _material_tmp / _process_tmp / _param_tmp) populated during the form's edit session. Used by the legacy 报价单单据(兼容停用), 卷筒产品报价单据, 报价单单据(膜类), 套装产品报价单据 forms.
What it does: Iterates per-slave (QuoQuotationSlave_Tmp) and walks materials/process/control cursors. Reads element rates from EleMaterials, EleProcess, eleproduct, plus form-level overrides in sysformsetting and global toggles in SysSystemSettings. Resolves dynamic field formulas via Sp_System_ReplaceField and consts via Sp_Sis_GetConst. Writes back per-row money/qty into QuoQuotationMaterials_Tmp, QuoQuotationProcess_Tmp, QuoQuotationControl_Tmp, QuoQuotationSlave_Tmp; finally rolls slave totals into QuoQuotationmaster_tmp (dAllMoney, etc.).
Invocation: Dispatched by BusinessBaseServiceImpl via the CaclProNameEnum.SP_QUOTATION_CALCDATASTD mapping — selected when the form's gdsmodule.sCalcProName='Sp_Quotation_CalcDataStd' (modules 报价单单据(兼容停用) 19211681019715780306452560, 卷筒产品报价单据 101251240115016002356125200, 报价单单据(膜类) 101251240115016036175782700, 套装产品报价单据 12012615914116361104593880). Install: script/标版/30100101/Sp_Quotation_CalcDataStd.sql.