李维强-15级 发表于 2019-9-16 00:43:04

Echarts使用：https://www.echartsjs.com/examples/zh/editor.html?c=watermark

李维强-15级 发表于 2019-10-22 15:01:21

本帖最后由 李维强-15级 于 2019-10-23 21:50 编辑

BEGIN
DECLARE @CoordFee FLOAT,@TestFee FLOAT,@MeterialFee FLOAT,@EquipFee FLOAT,@CivilPrice FLOAT,@InstallFee FLOAT;

SET @CoordFee=(SELECT SUM(money*Quantity) as num FROM o_PECoordFee where IsDelete<>1 and PreEstId=17 AND PreEstType='用户工程前期测算');
SET @TestFee=(SELECT SUM(money*Quantity) as num FROM o_PETestFee where IsDelete<>1 andPreEstId=17 AND PreEstType='用户工程前期测算');
SET @MeterialFee=(SELECT SUM(NormalPrice*Quantity) as num FROM o_PEMaterialFeeUser where IsDelete<>1 AND PreEstId=17 AND PreEstType='用户工程前期测算');
SET @EquipFee=(SELECT SUM(NormalPrice*Quantity) as num FROM o_PEEquipFee where IsDelete<>1 AND PreEstId=17 AND PreEstType='用户工程前期测算');
SET @CivilPrice=(SELECT SUM(b.UnitPrice*a.Quantity) AS num FROM o_PECivilPrice a INNER JOIN t_d_CivilPrice b ON a.OrgCivilPriceId=b.CivilPriceId
where a.IsDelete<>1 and a.PreEstId=17 AND a.PreEstType='用户工程前期测算');
SET @InstallFee=(SELECT SUM(Money*Quantity) AS num FROM o_PEInstallFee WHERE IsDelete<>1 AND PreEstId=17 AND PreEstType='用户工程前期测算');

SELECT @CoordFee as CKCoordFee,@TestFee AS CKTestFee,@MeterialFee AS CKMeterialFee,@EquipFee AS CKEquipFee,@CivilPrice AS CKCivilPrice,@InstallFee as CKInstallFee

END

李维强-15级 发表于 2019-11-3 14:21:02

本帖最后由 李维强-15级 于 2019-11-7 12:30 编辑

报价书
测算表新增字段和编辑某个字段的公式
测算对比重新提取
测算加入 图纸量和实际量
生成刘总钉钉上的表格（用户前期测算）

流程图

BEGIN
SELECT * INTO #temp FROM
(
SELECT TypeL1 as Name,0 as BJTZNum,0 as BJSJNum,SUM(DesignQuantity) AS CSTZNum,SUM(Quantity) as CSSJNum FROM o_PEEquipFee
where PreEstType='用户工程前期测算' AND PreEstId=11 AND TabType='WX' AND TypeL1 is not NULL GROUP BY TypeL1,Quantity
UNION
SELECT TypeL1 as Name,SUM(DesignQuantity) AS BJTZNum,SUM(Quantity) as BJSJNum,0 as CSTZNum,0 as CSSJNum FROM o_PEEquipFee
where PreEstType='用户工程' AND PreEstId=9 AND TabType='WX' AND TypeL1 is not NULL GROUP BY TypeL1,Quantity
) as a
SELECT Name,SUM(BJTZNum) as BJTZNum, SUM(BJSJNum) as BJSJNum, SUM(CSTZNum) as CSTZNum, SUM(CSSJNum) as CSSJNum
FROM #temp GROUP BYName

END

李维强-15级 发表于 2020-2-9 22:02:52

技经：胡豪杰
财务：宋春杰
行政：李小英
业务部: 王春林
市场部：殷培培
工程部： 主业（梅建涛）
工程部： 用户（周小峰）

主业工程：项目前期（业务部）
前期测算（技经部）
项目实施（工程部）
竣工结算（技经部）
决算收款（业务部）

项目前期（市场部）
前期测算（技经部）
项目实施（工程部）
竣工结算（技经部）
决算收款（业务部）
页: 1 [2]
查看完整版本: 远扬企业工程管理系统