chentianrui
170 lines
18 KiB
XML
170 lines
18 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<ReportCfg templateVersion="1.0">
|
||
<GlobalFilters/>
|
||
<RowConfigs>
|
||
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="组件分类" DataSourceName="组件分类" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="线路组件">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(B4)==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("名称","")" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="组件参数" DataSourceName="组件参数" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="线路特有">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(B4)==0){1}" ConditionName="删除组件分类" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组件分类id]" LeftShowName="" RightValue="组件分类.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="组件物料" DataSourceName="组件物料" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="线路组件">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组件参数id]" LeftShowName="" RightValue="组件参数.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D4==0 or D4==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("","线重")" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D5==0 or D5==""){1}" ConditionName="删除合计行" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</RowConfigs>
|
||
<rows freezingRow="-1" freezingCol="-1" startRow="0" startCol="-1">
|
||
<cells rowNum="0" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="文本" text="构件类型" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="文本" text="构件型号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="单重（kg）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="文本" text="数量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="文本" text="总重（kg）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="1" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="2" rowHeight="0" HideRowHeight="27" AdaptiveRowHeight="false">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[组件名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="3" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="组件参数.[组件名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[线重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="组件参数.[基数]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if(IN(组件参数.[所属组件分类名称],"底盘,卡盘,现浇基础,挖孔基础,保护帽,基础防护")==1) {组件参数.[基数]*组件参数.[每基坑数]} else if(IN(组件参数.[所属组件分类名称],"套筒,预制桩基础,钢管桩基础")==1) {组件参数.[基数]*组件参数.[每基根数]} else if(IN(组件参数.[所属组件分类名称],"拉线盘")==1) {组件参数.[组数]*组件参数.[每组坑数]} else if(IN(组件参数.[所属组件分类名称],"混凝土装配式基础")==1) {组件参数.[基数]*组件参数.[每基腿数]} else if(IN(组件参数.[所属组件分类名称],"灌注桩基础,岩石锚杆基础")==1) {组件参数.[基数]*组件参数.[每基孔数]} else if(IN(组件参数.[所属组件分类名称],"混凝土杆,钢管杆,铁塔,杆塔刷漆")==1) {组件参数.[基数]} else if(IN(组件参数.[所属组件分类名称],"拉线")==1) {组件参数.[根数]} else if(IN(组件参数.[所属组件分类名称],"接地装置")==1) {组件参数.[基数]} else if(IN(组件参数.[所属组件分类名称],"导线架设,避雷线架设,OPGW架设,耦合屏蔽线架设")==1) {组件参数.[长度]*1000*组件参数.[线长系数]*组件参数.[根数]} else if(IN(组件参数.[所属组件分类名称],"跨越")==1) {组件参数.[数量处]} else if(IN(组件参数.[所属组件分类名称],"特殊跨越,拦河线")==1) {组件参数.[处数]} else if(IN(组件参数.[所属组件分类名称],"悬垂串,跳线串")==1) {组件参数.[串只数]} else if(IN(组件参数.[所属组件分类名称],"耐张串")==1) {组件参数.[组数]} else if(IN(组件参数.[所属组件分类名称],"防振锤,阻冰环")==1) {组件参数.[个数]} else if(IN(组件参数.[所属组件分类名称],"间隔棒")==1) {组件参数.[个组数]} else if(IN(组件参数.[所属组件分类名称],"重锤,阻尼线")==1) {组件参数.[相数]} else if(IN(组件参数.[所属组件分类名称],"避雷器")==1) {组件参数.[相组数]} else if(IN(组件参数.[所属组件分类名称],"排水沟,尖峰及施工基面,护坡、挡土墙及排洪沟")==1) {组件参数.[数量]} else if(IN(组件参数.[所属组件分类名称],"杆塔附属设施")==1) {组件参数.[基数]} else if(IN(组件参数.[所属组件分类名称],"索道站")==1) {组件参数.[索道处数]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="公式" text="" formual="=C4*D4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="4" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="文本" text="合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="公式" text="" formual="=SUM(D4)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="公式" text="" formual="=E4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="5" rowHeight="25" HideRowHeight="25" AdaptiveRowHeight="true"/>
|
||
</rows>
|
||
<cols>
|
||
<col colNum="0" colWidth="70" hideColWidth="158" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="构件类型" Filed="构件类型"/>
|
||
<col colNum="1" colWidth="128" hideColWidth="78" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="构件型号" Filed="构件型号"/>
|
||
<col colNum="2" colWidth="70" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单重（kg）" Filed="单重（kg）"/>
|
||
<col colNum="3" colWidth="102" hideColWidth="70" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="数量" Filed="数量"/>
|
||
<col colNum="4" colWidth="70" hideColWidth="70" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="总重（kg）" Filed="总重（kg）"/>
|
||
</cols>
|
||
<mergeCells/>
|
||
</ReportCfg>
|