/** * Created by Mai on 2017/7/28. */ let calcProgramSetting ={ "emptyRows":0, "headRows":1, "headRowHeight":[ 35 ], "cols":[ { "width":75, "readOnly": true, "head":{ "titleNames":["序号"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"serialNo", "vAlign":1, "hAlign":1, "font":"Arial" } }, { "width":75, "readOnly": false, "head":{ "titleNames":["费用代号"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"code", "vAlign":1, "hAlign":0, "font":"Arial" } }, { "width":200, "readOnly":false, "head":{ "titleNames":["名称"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"name", "vAlign":1, "hAlign":0, "font":"Arial" } }, { "width":280, "readOnly":false, "head":{ "titleNames":["计算基数"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"dispExpr", "vAlign":1, "hAlign":0, "font":"Arial" } }, { "width":220, "readOnly":false, "head":{ "titleNames":["基数说明"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"statement", "vAlign":1, "hAlign":0, "font":"Arial" } }, { "width":80, "readOnly": false, "head":{ "titleNames":["费率"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"feeRate", "vAlign":1, "hAlign":2, "font":"Arial" } }, { "width": 100, "readOnly":true, "head":{ "titleNames":["单价"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"unitFee", "vAlign":1, "hAlign":2, "font":"Arial" } }, { "width":100, "readOnly":true, "head":{ "titleNames":["合价"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"totalFee", "vAlign":1, "hAlign":2, "font":"Arial" } }, { "width":80, "readOnly": true, "head":{ "titleNames":["费用类别"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"type", "vAlign":1, "hAlign":0, "font":"Arial", "getText": function (record) { if (record.type) { for (let ft of feeType) { if (ft.type === record.type) { return ft.name; } } } return ''; } } }, { "width":120, "readOnly":false, "head":{ "titleNames":["备注"], "spanCols":[1], "spanRows":[1], "vAlign":[1], "hAlign":[1], "font":["Arial"] }, "data":{ "field":"memo", "vAlign":1, "hAlign":0, "font":"Arial" } } ] }; let calcProgramObj = { showBillsCalcProgram: function (node, calcProgram, sheet) { SheetDataHelper.loadSheetHeader(calcProgramSetting, sheet); SheetDataHelper.loadSheetData(calcProgramSetting, sheet, calcProgram); } };