合同服务合同报价单成本价自动取产品的参考成本价

一、demo脚本

-- 模块名称： @modulename
SET @modulename='SalesOrder';
INSERT INTO ld_related_producttoolfield(modulename,trigger_columnname,effect_columnname,query_sql)
SELECT @modulename,'hdnProductId','productcost',"SELECT ROUND(costprice,2) AS productcost FROM ld_products WHERE productid='{hdnProductId}'" FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_related_producttoolfield WHERE modulename=@modulename AND effect_columnname='productcost');
delimiter;

-- 模块名称： @modulename
SET @modulename='ServiceContracts';
INSERT INTO ld_related_producttoolfield(modulename,trigger_columnname,effect_columnname,query_sql)
SELECT @modulename,'hdnProductId','productcost',"SELECT ROUND(costprice,2) AS productcost FROM ld_products WHERE productid='{hdnProductId}'" FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_related_producttoolfield WHERE modulename=@modulename AND effect_columnname='productcost');
delimiter;

-- 模块名称： @modulename
SET @modulename='Quotes';
INSERT INTO ld_related_producttoolfield(modulename,trigger_columnname,effect_columnname,query_sql)
SELECT @modulename,'hdnProductId','productcost',"SELECT ROUND(costprice,2) AS productcost FROM ld_products WHERE productid='{hdnProductId}'" FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_related_producttoolfield WHERE modulename=@modulename AND effect_columnname='productcost');
delimiter;

合同服务合同报价单成本价自动取产品的参考成本价.sql