Sp_Quotation_CalcDataPackStd.md 2.07 KB

Edit Raw Blame History



Sp_Quotation_CalcDataPackStd (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_CalcDataPackStd'._


Narrative

Business context: 销售管理 → 销售单据 — standard packaging-quotation price calculator. The packaging variant of Sp_Quotation_CalcDataStd: same staging-table contract (QuoQuotationmaster_Tmp / slave / control / material / process / param), additional 包装控件 (pack-control) tables, and adjustments for multi-product packs.

What it does: Walks slave/control/material/process/print-process cursors against the Quo*Tmp staging set. Reads element rates from eleproduct, EleMaterials, EleProcess, applies form-level overrides from sysformsetting, system toggles from SysSystemSettings, and constants via Sp_Sis_GetConst/Sp_System_ReplaceField. Writes the computed per-row money/qty into `QuoQuotationMaterialsTmp,QuoQuotationProcess_Tmp,QuoQuotationControl_Tmp,QuoQuotationSlave_Tmp; rolls up totals intoquoquotationmaster_tmp. Includes a pack-rate handling block (p_bRateTransformSet) absent from_CalcDataStd`.

Invocation: Registered in CaclProNameEnum.SP_QUOTATION_PACKSTD/SP_QUOTATION_CALCDATASETSTD family. Dispatched by BusinessBaseServiceImpl when a form's gdsmodule.sCalcProName='Sp_Quotation_CalcDataPackStd'. No current sCalcProName row binds to this name — the live pack-quote form (新报价单, 101251240115016076506222050) routes through Sp_Quotation_CalcDataPack, which calls this proc indirectly via workOrderCalcDataPackService.doCalcDataPackStd. Install: script/标版/30100101/Sp_Quotation_CalcDataPackStd.sql.