统计电缆长度时,统一设置冗余度系数并计算显示到报表中
1. 敷设完成后,在输出管理器中编辑报表模板
2. 编辑报表模板中,清空SQL Query中的默认值。
3. 将下方sql查询语句拷贝到SQL Query中。这样就设置完成,生成的电缆时长度同时增加10%的冗余度。
SELECT distinct CLIST.RECNO, CLIST.CABLENO, CLIST.CABLETYPE, CLIST.CIRCUITNUMBER, CLIST.FROM_ID, CLIST.FROM_DESCR, CLIST.FROM_LOC, CLIST.TO_ID, CLIST.TO_DESCR, CLIST.TO_LOC, cast(CLIST.LENGTH as float)*1.10 AS LENGTH, CLIST.CSTATUS, CLIST.CSTATDATE, CLIST.CSTATUSR, CLIST.TOTAL_BEND, CLIST.DESIGN_STATUS, CLIST.ROUTING_FILTER, CLIST.VOLTAGE_LEVEL, REPLACE(REPLACE(substring((SELECT RSEGNAME + ',' FROM $(P)_$(S)_EXT_CABLEROUTE WHERE ((CABLENO = CROUTE.CABLENO) and RSEGNAME != 'Air Gap') FOR XML PATH ('')),1,len((SELECT RSEGNAME + ',' FROM $(P)_$(S)_EXT_CABLEROUTE WHERE ((CABLENO = CROUTE.CABLENO) and RSEGNAME != 'Air Gap') FOR XML PATH ('')))-1) ,'<', '<'),'>', '>') AS VIA FROM $(P)_$(S)_EXT_CABLEROUTE CROUTE FULL OUTER JOIN $(P)_$(S)_EXT_CABLES CLIST ON CLIST.CABLENO = CROUTE.CABLENO ORDER BY CLIST.RECNO
说明:查询语句中*1.10表示增加10%的冗余度,有需要可以在此处修改任意值的系数。