ConstructionCost/web/building_saas/main/js/views/project_view.js

/**
 * Created by Mai on 2017/6/21.
 */

var projectObj = {
    project: null,
    mainSpread: null,
    mainController: null,
    gljSpreed:null,
    beforeMainTreeSelectedChange: function (pre) {
        /*if (node) {
            subViewObj.saveComments(node);
        }*/
    },
    // CSL, 2018-02-09 用于测试显示。使用示例：projectObj.testDisplay(‘总额’, 100);
    testDisplay: function (caption, value) {
        let c = '';
        if (caption) c = caption + ': ';
        let s = `          ${c}${value}`;
        $('#testDisplay').html(s);
    },
    treeSelectedChanged: function (node) {
        let project = projectObj.project;
        let mainSheet = projectObj.mainController.sheet;
        //设置选中行底色和恢复前选中行底色
        let refreshNodes = [node];
        if(!project.mainTree.preSelected){
            refreshNodes.push(project.mainTree.items[0]);
        }
        else {
            refreshNodes.push(project.mainTree.preSelected);
        }
        project.mainTree.preSelected = node;
        projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
        if($('#linkComments').hasClass('active')){
            subViewObj.loadComments(node);
        }
        gljOprObj.showDataIfRationSelect(node);
        if (activeSubSheetIsCalcProgram())
            calcProgramObj.refreshCalcProgram(node, 3);

        //zhong 2017-9-1 特征及内容
        if(pageCCOprObj.active){
            pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
            pageCCOprObj.setCacheAndShow(node);
        }
        // for test interface.  CSLAAAAA
        // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));

        // 基数
        // node.data.isSubcontract = true;
        // node.data.gljList = project.ration_glj.getGljArrByRation(node.data);
        // let bname = '甲供定额基价材料费';
        // projectObj.testDisplay(bname, rationCalcBases[bname](node));
    },
    refreshBaseActn: function (tree) {
        let setButtonValid = function (valid, btn) {
            if (valid) {
                btn.removeClass('disabled');
            } else {
                btn.addClass('disabled');
            }
        };
        let selected = tree.selected, that = projectObj;

        let canUpLevel = function (node) {
            if(!node){
                return false;
            }
            if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
                return false;
            }
            if(node.depth()<=1){//焦点行是树结构的第一/二层节点，灰显。
                return false;
            }
            if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机，灰显。
                return false;
            }else {
                if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项，或者补项灰显。
                    return false;
                }
                if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟，有子项.
                     if(node.children[0].data.type==billType.FX || node.children[0].data.type==billType.BX){ //焦点行子项是分项
                         return false;
                     }
                }
                if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
                    if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
                        return false;
                    }
                    if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
                        return false;
                    }
                }
            }
            return true;
        };
        let canDownLevel = function (node) {
            if(!node){
                return false;
            }
            if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
                return false;
            }
            if(node.depth()==0){//焦点行是树结构的第一层节点，灰显。
                return false;
            }
            if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机，灰显。
                return false;
            }else {
                if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项，灰显。
                    return false;
                }
                if(!node.preSibling){//无前兄弟，灰显
                    return false;
                }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
                    return false
                }
                if(node.preSibling.children.length>0){//前兄弟有子项，子项是分项，灰显。
                    if(node.data.type==billType.FB&&(node.preSibling.children[0].data.type==billType.FX||node.preSibling.children[0].data.type==billType.BX)){//焦点行是分部前兄弟有子项，子项是分项，灰显。
                        return false;
                    }
                    if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单，子项不是清单
                        return false
                    }
                }
            }
            return true;
        };
        let canUpMove = function (node) {
            if(node&&node.preSibling){//有前兄弟
                if(node.sourceType==that.project.Bills.getSourceType()){
                    if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
                        return false;
                    }
                    if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
                        return false;
                    }
                }
                return true
            }
            return false
        };
        let canDownMove = function (node) {
            if(node&&node.nextSibling){
                if(node.sourceType==that.project.Bills.getSourceType()){
                    if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
                        return false;
                    }
                    if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
                        return false;
                    }
                }
                return true;
            }
            return false
        };

        setButtonValid(canInsertRationNode(selected), $('#insertRation'));
        setButtonValid(ifCanDelete(), $('#delete'));
        setButtonValid(canUpLevel(selected), $('#upLevel'));
        setButtonValid(canDownLevel(selected), $('#downLevel'));
        setButtonValid(canUpMove(selected) , $('#upMove'));
        setButtonValid(canDownMove(selected), $('#downMove'));
        setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLFB_btn'));

    },
    checkCommonField: function (editingText, colSetting) {
        let value;
        if (colSetting.data.decimal) {
            value = Number(editingText);
            if (number_util.isNumber(value)) {
                if (colSetting.data.decimal) {
                    value = value.toDecimal(colSetting.data.decimal);
                }
            } else {
                value = null;
                alert('当前输入的数据类型不正确，请重新输入。');
            }
        } else {
            value = editingText;
        }
        return value;
    },
    checkFormulaValidField: function (editingText, colSetting) {
        let value = Number(editingText);
        if (!value) {
            try {
                let exp = new Expression('');
                exp.Expression(editingText);
                value = Number(exp.Evaluate());
            } catch (error) {
                value = null;
            }
        }
        if (value!=undefined||value!=null) {
            if (colSetting.data.decimal) {
                value = value.toDecimal(colSetting.data.decimal);   
            }
        } else if (editingText && editingText !== '') {
            value = null;
            alert('当前输入的数据类型不正确，请重新输入。');
        }
        return value;
    },
    checkSpreadEditingText: function (editingText, colSetting) {
        if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
            return this.checkFormulaValidField(editingText, colSetting);
        }
        else if (colSetting.data.field === 'programID') {
            return this.project.calcProgram.compiledTemplateMaps[editingText];
        }
        else if (colSetting.data.field === 'subType') {
            if (typeof(editingText) !== "number")
                return volumePriceMaps[editingText]
            else
                return editingText;
        }
        else {
            return this.checkCommonField(editingText, colSetting);
        }
    },
    getVisibleRows: function (sRow, count) {
        let rst = [];
        let nodes = projectObj.project.mainTree.items;
        for(let i = sRow, len = nodes.length; i < len; i++){
            if(count <= 0){
                break;
            }
            if(nodes[i].visible){
                rst.push(i);
                count--;
            }
        }
        return rst;
    },
    //根据列标段设置焦点单元格
    setActiveCell(field, moveScroll){
        projectObj.mainSpread.focus(true);
        let mainSheet = projectObj.mainSpread.getActiveSheet();
        let fieldCol = colSettingObj.getColByField(field);
        if(fieldCol){
            if(moveScroll){
                mainSheet.showColumn(fieldCol, GC.Spread.Sheets.HorizontalPosition.left);
            }
            mainSheet.setActiveCell(projectObj.project.mainTree.selected.serialNo(), fieldCol);
        }
    },
    //获取粘贴更改的单元格（粘贴时，跳过隐藏行）
    checkSpreadChangedCells: function (info) {
        let rst = {refreshRows: [], changedCells: []};
        //获取显示行号
        let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
        let vCount = vRows.length;
        let lastRow = null, count = 0;
        for(let cell of info.changedCells){
            cell.text = info.sheet.getCell(cell.row, cell.col).text();
            if(cell.row !== lastRow){
                count++;
                lastRow = cell.row;
            }
            if(count <= vCount){
                if(vRows[count - 1] !== cell.row){
                    rst.refreshRows.push(cell.row);
                }
                rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
            }
            else {
                rst.refreshRows.push(cell.row);
            }
        }
        rst.refreshRows = Array.from(new Set(rst.refreshRows));
        return rst;
    },
    updateBillsCode: function (node, value) {
        let project = projectObj.project,me = this;
        let stdMatchCode, formatCode, matchs;
        let searchStdBillsAndUpdate = function (stdCode, formatCode) {
            let orgCode = node.data.code?node.data.code.substr(0, 9):"";
            if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
                normalUpdate(node,value,stdCode === orgCode);
            } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
                let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
                CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
                    if (data) {
                        //data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
                        node.data.name = data.name;
                        if(node.data.type == billType.BX){//从清单库中找到标准清单的话，要把补项改成分项
                            node.data.type = billType.FX;
                        }
                        pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
                        if (/\//.test(data.unit)) {
                            let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
                            if (existB) {
                                data.unit = existB.unit;
                                //
                                project.Bills.replaceBills(node.source, data, formatCode);
                                projectObj.mainController.refreshTreeNode([node], false);
                            } else {
                                ConfirmModal.stdBillsUnit.check(data, function (std) {
                                    project.Bills.replaceBills(node.source, std, formatCode);
                                    projectObj.mainController.refreshTreeNode([node], false);
                                }, function () {
                                    projectObj.mainController.refreshTreeNode([node], false);
                                });
                            }
                        } else {
                            project.Bills.replaceBills(node.source, data, formatCode);
                            projectObj.mainController.refreshTreeNode([node], false);
                        }
                    } else {
                        normalUpdate(node,value);
                    }
                });
            }
        }
        //分部分项、措施项目才匹配
        let withinValidFixed = false;
        let matchFixedFlags = [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE];
        let rootNode = getRootFixedNode(node);
        if(rootNode && rootNode.data.flagsIndex && rootNode.data.flagsIndex.fixed && matchFixedFlags.includes(rootNode.data.flagsIndex.fixed.flag)){
            withinValidFixed = true;
        }
        if(withinValidFixed && (node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0))){//是分项、补项或者叶子清单的情况下才需要查找替换
            if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
                stdMatchCode = value;
                formatCode = project.Bills.newFormatCode(stdMatchCode);
                searchStdBillsAndUpdate(stdMatchCode, formatCode);
                return;
            } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
                stdMatchCode = value.substr(0, 9);
                matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
                if (matchs.indexOf(value) === -1) {
                    searchStdBillsAndUpdate(stdMatchCode, value);
                    return;
                } else {
                    hintBox.infoBox("系统提示","已存在该编码的清单，是否继续？",2,function () {
                        searchStdBillsAndUpdate(stdMatchCode, value);
                    },function () {
                        me.mainController.refreshTreeNode([node], false);
                    },['确定','取消']);
                    return;
                   /*if (confirm('已存在该编码的清单，是否继续？')) {
                       // formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
                        searchStdBillsAndUpdate(stdMatchCode, value);
                        return;
                    }else {
                       this.mainController.refreshTreeNode([node], false);
                       return;
                   }*/
                }
            }
        }
        normalUpdate(node,value);


        function normalUpdate(billnode,codeValue,onNeedCheck) {//在标准库中没有找到清单时改分项为补项再更新
            let toBX = false;
            if(onNeedCheck!==true && billnode.data.type == billType.FX){
                billnode.data.type = billType.BX;
                 toBX = true;
            }
            project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
            me.mainController.refreshTreeNode([billnode], false);
        }
    },
    updateRationCode: function (node, value) {
        if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
            return;
        }
        if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
            alert('当前项目无定额库，请添加定额库。');
            this.mainController.refreshTreeNode([node], false);
        } else {
            let libId = parseInt($('#stdRationLibSelect').val());
            CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
                if (data) {
                    projectObj.project.Ration.replaceRation(node.source, data);
                    projectObj.project.ration_glj.addRationGLJ(node.source, data);
                } else {
                    alert('当前库中找不到定额"' + value + '"');
                }
                projectObj.mainController.refreshTreeNode([node], false);
            });
        }
    },
    updateCode: function (node, value) {
        let project = projectObj.project;
        if (node.sourceType === project.Bills.getSourceType()) {
            this.updateBillsCode(node, value);   // 新清单不适合实时计算，下面套什么还不能确定，无数量计算也无意义
        } else if (node.sourceType === project.Ration.getSourceType()) {
            if(value && typeof(value) == 'string'){//小写转换成大写
                value = value.toUpperCase();
            }
            project.Ration.updateRationCodes([{'node':node,value:value}]);
          //  this.updateRationCode(node, value);  // 新套定额适合实时计算
            // 这里因异步问题暂时缺少工料机价格。该过程移到：ration_glj.js的refreshAfterSave方法中。
        }
    },
    updateNodeField : function (node,value,filedID,callback) {
        if(node.data[filedID] == value){
            return;
        }
        let data =  {
            type:node.sourceType,
            data:{
                ID:node.data.ID
            }
        };
        data.data[filedID] = value;
        $.bootstrapLoading.start();
        projectObj.project.updateNodes([data],function () {
            node.data[filedID] = value;
            if(callback){
                callback();
            }
            $.bootstrapLoading.end();
        })
    },
    updateCellValue: function (node, value, colSetting,editingText) {
        let project = projectObj.project, fieldName = colSetting.data.field;
        if(node.sourceType==project.ration_glj.getSourceType()){
            project.ration_glj.updateFromMainSpread(value,node,fieldName);
        }
        else if(fieldName === 'remark'){
            projectObj.updateNodeField(node,value,'remark');
        }
        else if(calcTools.isGljRation(node)){
            gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
        }
        else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换，所以做特殊处理
            if (fieldName === 'code' && value != '' && !calcTools.isVolumePrice(node)) {
                projectObj.updateCode(node, value);
            }
            else if(fieldName ==='feeRate'){
                project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
            }
            else if(fieldName ==='contain'){//编辑含量
                project.Ration.updateContain(value,node);
            }
            else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee' || fieldName === 'programID' ||
                fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
                if (fieldName === 'quantity') {
                    project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
                    return;
                }
                else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
                    if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
                }
                else if (fieldName === 'calcBase') {
                    //zhong
                    if(value === undefined ||value === null || value.toString().trim() === ''){
                        value = '';
                    }
                    node.data.userCalcBase = value;
                    project.calcBase.calculate(node);
                    if(!project.calcBase.success){
                        let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
                        projectObj.mainController.refreshTreeNode([node]);
                        return;
                    }
                    // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
                };
                //计算基数赋值要经过解析和标准化，已在calculate里赋值
                if(fieldName !== 'calcBase'){
                    calcTools.setFieldValue(node, fieldName, value);
                };

                project.calcProgram.calcAndSave(node);
                gljOprObj.showRationGLJSheetData();
            }
            else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
                node.data[fieldName] = value;
                node.changed = true;
                if(node.data.quantity){
                    node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
                }
                project.calcProgram.calcAndSave(node);
            }
            else {
                if (node.sourceType === project.Bills.getSourceType()) {
                    project.Bills.updateField(node.source, fieldName, value, false);
                }
                else if (node.sourceType === project.Ration.getSourceType()) {
                    project.Ration.updateField(node.source, fieldName, value);
                };

                if (colSetting.data.wordWrap) {
                    this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
                }
                projectObj.mainController.refreshTreeNode([node]);
            }
        }
        else if(value==null && fieldName ==='feeRate'){
            project.FeeRate.cleanFeeRateID(node);
        }
        else {
            projectObj.mainController.refreshTreeNode([node], false);
        }
    },
    mainSpreadLeaveCell: function (sender, info) {
        let colSetting = projectObj.mainController.setting.cols[info.col];
        projectObj.lastCol = colSetting;
        projectObj.lastCell = {row: info.row, col: info.col};
    },
    //repaint 动态下拉框
    mainSpreadEnterCell: function (sender, info) {
        let colSetting = projectObj.mainController.setting.cols[info.col];
        if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
            || (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
            let rects = [];
            rects.push(info.sheet.getCellRect(info.row, info.col));
            if(projectObj.lastCell){
                rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
            }
            for(let rect of rects){
                info.sheet.repaint(rect);
            }
        }
    },
    mainSpreadEditStarting: function (sender, info) {
        let project = projectObj.project;
        let node = project.mainTree.items[info.row];
        let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
        let orgV = info.sheet.getValue(info.row, info.col);
        let newV;
        if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
            && isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none && fieldName === 'code'){
/*            if(node.data.prefix === rationPrefix.complementary){
                newV = orgV.replace(new RegExp(rationPrefix.complementary), '');
            }
            if(node.data.prefix === rationPrefix.borrow){
                newV = orgV.replace(new RegExp(rationPrefix.borrow), '');
            }*/
            if(node.data.prefix){
                newV = orgV.replace(new RegExp(node.data.prefix), '');
            }
            info.sheet.setValue(info.row, info.col, newV);
        }
    },
    onCellDoubleClick: function (sender, info){
        let project = projectObj.project;
        let node = project.mainTree.items[info.row];
        let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
        if(fieldName == 'marketUnitFee'){
            if(gljOprObj.hasComposition(node.data,true)){
                alert("当前人材机的市场价由组成物计算得出，不可直接修改。");
                return;
            }
        }

    },
    onColumnWidthChanged: function (sender, info) {
        projectObj.mainSpread.getActiveSheet().setColumnVisible(4, false);
        projectObj.mainSpread.getActiveSheet().setColumnVisible(4, true);
        projectObj.mainSpread.refresh();
        projectObj.mainSpread.repaint();
    },
    mainSpreadEditEnded: function (sender, info) {
        console.log('enterEDEnd');
        let project = projectObj.project;
        let node = project.mainTree.items[info.row];
        project.withinBillsLocked(node);
        let colSetting = projectObj.mainController.setting.cols[info.col];
        let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
        // 检查输入类型等
        let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
        projectObj.updateCellValue(node, value, colSetting,info.editingText);

        // 自动行高
        const autoHeight = project.property.displaySetting.autoHeight;
        if (autoHeight) {
            projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
        }
    },
    msClipboardChanged: function (sender, info) {
        let colSettings = projectObj.mainController.setting.cols;
        let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
        sheetCommonObj.copyTextToClipboard(cDatas);
        return;
    },
    mainSpreadRangeChanged: function (sender, info) {
        let project = projectObj.project, setting = projectObj.mainController.setting;
        let changedObj = projectObj.checkSpreadChangedCells(info);
        let refreshNodes = [];
        for(let row of changedObj.refreshRows){
            refreshNodes.push(project.mainTree.items[row]);
        }
        let updateRationCodes = [];//更新定额编码时要用同步的方式
        if(changedObj.changedCells.length > 0){
            for (let changedCell of changedObj.changedCells) {
                let node = project.mainTree.items[changedCell.row];
                let colSetting = setting.cols[changedCell.col];
                let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
                if(colSetting.data.field=='code' && value != '' && node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
                    updateRationCodes.push({'node':node,value:value});
                }else {
                    projectObj.updateCellValue(node, value, colSetting,changedCell.text);
                }
            }
        }
        if(updateRationCodes.length>0){
            project.Ration.updateRationCodes(updateRationCodes);
        }
        if(refreshNodes.length > 0){
            projectObj.mainController.refreshTreeNode(refreshNodes);
        }
    },
    checkMainSpread: function () {
        if (!this.mainSpread) {
            this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
            this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
            this.mainSpread.getActiveSheet().name('mainSheet');
            this.mainSpread.getActiveSheet().options.isProtected = true;
        }
    },
    refreshMainSpread: function () {
        if (this.mainSpread) {
            this.mainSpread.refresh();
        }
    },
    loadProjectData: function () {
        var that = this;
        this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
        let startTime = +new Date();
        console.log("开始加载-----"+startTime);
        $.bootstrapLoading.start();
        this.project.loadDatas(function (err) {
            let mTime = +new Date();
            console.log(`get data时间——${mTime - startTime}`);
            //快速列设置
            if(!colSettingObj.getVisible('itemCharacterText') && !colSettingObj.getVisible('jobContentText')){
                switchTznrHtml(true);
            }
            if(colSettingObj.getVisible('itemCharacterText') && colSettingObj.getVisible('jobContentText')){
                switchTznrHtml(false);
            }
            if (!err) {
                that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
                gljCol.initGljCol(that.project.projSetting.glj_col?that.project.projSetting.glj_col.showAdjustPrice:false);
                subObj.initSubSpread();//初始化主界面下方的表格

                let quantityTime = +new Date();
                console.log(`计算quantity时间——${quantityTime - mTime}`);
                that.project.property = projectInfoObj.projectInfo.property;
                //that.project.calcProgram.compileAllTemps();
                that.project.calcBase.init(that.project);
                // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
                // that.project.initCalcFields();
                let str = JSON.stringify(that.project.projSetting.main_tree_col);
                that.project.projSetting.mainGridSetting = JSON.parse(str);
                that.project.projSetting.mainGridSetting.frozenCols = 4;
                TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
                that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
                that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
                    col.data.splitFields = col.data.field.split('.');
                    if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
                        col.data.getText = MainTreeCol.getEvent(col.data.getText);
                    }
                    if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
                        col.readOnly = MainTreeCol.getEvent(col.readOnly);
                    }
                    if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
                        let getCellType = MainTreeCol.getEvent(col.data.cellType);
                        col.data.cellType = getCellType;
                    }
                    // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
                    //     col.data.decimal = that.project.getDecimal(col.data.digit);
                    //     col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
                    // }
                    if (col.data.field === 'code') {
                        col.data.formatter = '@';
                    }
                    col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
                    col.editChecking = MainTreeCol.getEvent("editChecking");
                    // 根据配置设置自动行高,在这里先做个标记，然后对每个单元格单独配置
                    if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
                        col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
                        col.data.autoHeight = true;
                        col.showHint = true;
                    }
                    if(col.data.field ==='quantity' || col.data.field ==='remark'){
                        col.showHint = true;
                    }

                    // 综合单价、综合合价，小数部分应补0对齐。  CSLAAAAA
                    // if (col.data.field.hasSubStr("common")){
                        if (col.data.field.hasSubStr(".totalFee"))
                            col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true);
                        else if (col.data.field.hasSubStr(".unitFee"))
                            col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true);
                    // }

                });
                let startShowTime = +new Date();
                that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
                that.mainController.showTreeData();
                let endShowTime = +new Date();
                console.log(`show data时间——${endShowTime - startShowTime}`);
                that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
                that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
                that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
                if(!projectReadOnly){
                    sheetCommonObj.bindEnterKey(that.mainSpread, that.mainSpreadEnterKey);
                }
                sheetCommonObj.bindEscKey(that.mainSpread, that.mainSpreadEditStarting, that.mainSpreadEditEnded);
                setTimeout(function () {
                    that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发，而这些又不影响计算，所以这里用异步的方法
                    that.mainSpread.getActiveSheet().endEdit();

                    that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
                },100);
                that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);//选中统计专用，节点相关操作在treeSelectedChanged里些
                that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
                that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
                that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);

                that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
                that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
                that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
                that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
                that.mainSpread.bind(GC.Spread.Sheets.Events.ColumnWidthChanged, that.onColumnWidthChanged);

                //let loadOtherStartTime = +new Date();
                if(!projectReadOnly){
                    that.loadMainSpreadContextMenu();
                }
                that.loadFocusLocation();
                socketObject.connect();//连接socket服务器
                let endTime = +new Date();
                console.log(`其它时间——${endTime - endShowTime}`);
                console.log("加载完成-----"+endTime);
                console.log(`时间——${endTime - startTime}`);
                that.project.projectMarkChecking();//是否需要重新进行造价计算
                installationFeeObj.engineeringTypeChecking();//检查是否安装工程
                autoFlashHeight();
                projectObj.refreshMainSpread();
                //定位到会话中的选项
                let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
                $(`${mainTabFocus}`).click();
                if(projectReadOnly){
                    disableSpread(that.mainSpread);
                }
                $.bootstrapLoading.end();
            }
            else {

            }
        });

    },
    mainSpreadEnterKey: function () {
        let me = projectObj;
        let sheet = me.mainSpread.getActiveSheet();
        let orgRow = sheet.getActiveRowIndex();
        let orgCol = sheet.getActiveColumnIndex();
        let orgField = colSettingObj.getFieldByCol(orgCol);
        let selected = me.project.mainTree.items[orgRow];
        if(sheet.isEditing()){
            sheet.endEdit();
        }
        //正常情况，焦点应该是在下一行的同一列
        let newRow = orgRow + 1, newCol = orgCol;
        //getColByField getVisible都不提出来，减少调用次数
        if(selected){
            //在分项/补项的编码单元格回车，焦点应跳动至本行的工程量单元格
            if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){
                let quantityCol = colSettingObj.getColByField('quantity');
                let quantityVisible = colSettingObj.getVisible('quantity');
                if(quantityCol !== null && quantityVisible !== false){
                    newRow = orgRow;
                    newCol = quantityCol;
                }
            }
            else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){
                //在分项/补项的工程量单元格回车，如果其下有定额/量价/人材机，焦点应跳动至其下第一条定额/量价/人材机的工程量，如果是空行，则跳到至第一条定额xx的编码；
                if(selected.children.length !== 0 && !(isDef(selected.children[0].data.code) && selected.children[0].data.code.toString().trim() !== '')){
                    let codeCol = colSettingObj.getColByField('code');
                    let codeVisible = colSettingObj.getVisible('code');
                    newRow = orgRow + 1;
                    if(codeCol !== null && codeVisible !== false){
                        newCol = codeCol;
                    }
                }
                //如果其下没有定额/量价/人材机，则自动在其下插入一条定额空行，在其后自动插入一条分项空行，焦点跳动至定额空行的编码单元格。
                else if(selected.children.length === 0){
                    //在其后插入分项
                    if(!(projectInfoObj.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected))){
                        ProjectController.addFX(me.project, me.mainController);
                        //将焦点行设置成原本的行，以插入定额
                        me.mainController.setTreeSelected(me.project.mainTree.items[orgRow]);
                    }
                    //插入定额
                    me.project.Ration.addNewRation(null, rationType.ration, function () {
                        newRow = sheet.getActiveRowIndex();
                        let codeCol = colSettingObj.getColByField('code');
                        let codeVisible = colSettingObj.getVisible('code');
                        if(codeCol !== null && codeVisible !== false){
                            newCol = codeCol;
                        }
                        sheet.setActiveCell(newRow, newCol);
                    });
                }
            }
            //在定额/量价/人材机的编码单元格回车，焦点应跳动至本行的工程量单元格
            else if(orgField && orgField === 'code' && selected.sourceType === me.project.Ration.getSourceType()){
                let quantityCol = colSettingObj.getColByField('quantity');
                let quantityVisible = colSettingObj.getVisible('quantity');
                if(quantityCol !== null && quantityVisible !== false){
                    newRow = orgRow;
                    newCol = quantityCol;
                }
            }
            //在定额/量价/人材机的工程量单元格回车
            else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Ration.getSourceType()){
                let nextSibling = selected.nextSibling;
                //如果其后有定额/量价/人材机(空行:编码为空不算)，焦点应跳动至下一行定额/量价/人材机的工程量，不需处理

                //如果其后没有定额/量价/人材机(空行也没有)，则自动在其后插入一行定额空行，焦点跳动至定额空行的编码单元格
                if(!nextSibling){
                    let codeCol = colSettingObj.getColByField('code');
                    let codeVisible = colSettingObj.getVisible('code');
                    me.project.Ration.addNewRation(null, rationType.ration, function () {
                        newRow = sheet.getActiveRowIndex();
                        if(codeCol !== null && codeVisible !== false){
                            newCol = codeCol;
                        }
                        sheet.setActiveCell(newRow, newCol);
                    });
                }
                //如果其后有定额空行，焦点跳动至定额空行的编码单元格
                else if(nextSibling && !(isDef(nextSibling.data.code) && nextSibling.data.code.toString().trim() !== '')) {
                    let codeCol = colSettingObj.getColByField('code');
                    let codeVisible = colSettingObj.getVisible('code');
                    if(codeCol !== null && codeVisible !== false){
                        newRow = orgRow + 1;
                        newCol = codeCol;
                    }
                }
            }
            //在清单的编码单元格回车，如果清单是叶子节点，焦点跳动至本行的工程量单元格
            else if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType()
                && selected.data.type === billType.BILL && selected.source.children.length === 0){
                let quantityCol = colSettingObj.getColByField('quantity');
                let quantityVisible = colSettingObj.getVisible('quantity');
                if(quantityCol && quantityVisible){
                    newRow = orgRow;
                    newCol = quantityCol;
                }
            }
        }
        //设置焦点
        sheet.setActiveCell(newRow, newCol);
        //触发表格事件
        me.mainController.setTreeSelected(me.project.mainTree.items[newRow]);//SelectionChanged
        me.mainSpreadLeaveCell({type: 'LeaveCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: orgRow, col: orgCol});
        me.mainSpreadEnterCell({type: 'EnterCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: newRow, col: newCol});

    },
    loadMainSpreadContextMenu: function () {
        var project = this.project, spread = this.mainSpread, controller = this.mainController;
        $.contextMenu({
            selector: '#billsSpread',
            build: function ($trigger, e) {
                var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
                controller.setTreeSelected(controller.tree.items[target.row]);
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                "insertRootBill": {
                    name: "插入大项费用",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        return projectObj.project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected);
                        //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
                    },
                    callback: function (key, opt) {
                        ProjectController.addRootBill(project, controller);
                    },
                    visible: function(key, opt){
                        return project.mainTree.selected&&project.mainTree.selected.parent==null;
                    }
                },
                "insertFB": {
                    name: "插入分部",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        let selected = project.mainTree.selected;
                        if(projectObj.project.isBillsLocked()== false&&selected&&selected.sourceType==project.Bills.getSourceType()){
                            if(selected.data.type==billType.FB){
                                return false;
                            }
                            if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
                                if(selected.children.length>0){
                                   return selected.children[0].data.type==billType.FX ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程，且子项是分项或补项
                                }else {
                                    return false
                                }
                            }
                        }
                        return true;//除了清单，其它类型都只读
                    },
                    callback: function (key, opt) {
                        ProjectController.addFB(project, controller);
                    },
                    visible: function(key, opt){
                        if(project.mainTree.selected){
                            return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
                        }else {
                            return false;
                        }
                    }
                },
                "insertFX": {
                    name: "插入分项",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        let selected = project.mainTree.selected;
                        if(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
                            if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项，有效显示
                                return false
                            }
                            if(selected.data.type==billType.FB){//点行是分部，
                                if(selected.children.length>0){//且有子项，子项是分部，灰显。
                                    return selected.children[0].data.type == billType.FB
                                }else {
                                    return false;
                                }
                            }
                            if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
                                if(selected.children.length>0){
                                    return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程，且子项是分部时灰显
                                }else {
                                    return false
                                }
                            }
                        }
                        return true;//除了清单，其它类型都只读
                    },
                    callback: function (key, opt) {
                        ProjectController.addFX(project, controller);
                    },
                    visible: function(key, opt){
                        if(project.mainTree.selected){
                            return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
                        }else {
                            return false;
                        }
                    }
                },
                "insertBills": {
                    name: "插入清单",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        let selected = project.mainTree.selected;
                        if(!(projectObj.project.isBillsLocked()== true && project.withinBillsLocked(selected)) && selected && selected.sourceType === project.Bills.getSourceType()){
                            return false
                        }
                        return true;
                    },
                    callback: function (key, opt) {
                        if(project.mainTree.selected.data.type == billType.DXFY){
                            if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
                                alert("当前有基数计算不能插入子项。");
                                return;
                            }
                        }
                        ProjectController.addBills(project, controller);
                    },
                     visible: function(key, opt){
                         if(project.mainTree.selected){
                             return  project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
                         }else {
                             return false;
                         }
                     }
                },
                "insertRation": {
                    name: "插入定额",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        project.Ration.addNewRation(null,rationType.ration);
                       // ProjectController.addRation(project, controller, rationType.ration);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        return canInsertRationNode(selected);
                    }
                },
                "insertLJ": {
                    name: "插入量价",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        project.Ration.addNewRation(null,rationType.volumePrice);
                       // ProjectController.addRation(project, controller, rationType.volumePrice);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        if(selected){
                           return canInsertRationNode(selected);
                        }
                       return false;
                    }
                },
                "insertGLJ": {
                    name: "插入人材机",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        var selected = project.mainTree.selected;
                        if(selected.sourceType == ModuleNames.bills){
                            if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
                                if(selected.data.calcBase&&selected.data.calcBase!=""){
                                    alert("当前有基数计算不能插入子项。");
                                    return;
                                }
                            }
                        }
                        getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        if(selected){
                          return canInsertRationNode(selected);
                        }
                        return false;
                    }
                },
                "calc_installation_fee": {
                    name: "计取安装费用",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        return false;
                    },
                    callback: function (key, opt) {
                        installationFeeObj.showCalcInstallSettingDiv();
                    },
                    visible: function(key, opt){
                        let engineering = projectInfoObj.projectInfo.property.engineering;
                        return engineering==engineeringType.BUILD_IN;
                    }
                },
                "spr1": '--------',
                "delete": {
                    name: '删除',
                    icon: 'fa-remove',
                    disabled: function () {
                        return !ifCanDelete();
                    },
                    callback: function () {
                        var selected = project.mainTree.selected;
                        if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部，并且没有子项，直接删除
                            project.Bills.deleteSelectedNode();
                        }else {
                            $("#delete_row").modal({show:true});//弹出删除提示框;
                        }
                    }
                },
                "spr2":'--------',
                "calculateAll_RationContent": {
                    name: '造价计算',
                    callback: function () {
                        project.calcProgram.calcAllNodesAndSave();
                    }
                },
                "spr2":'--------',
                "copyBlock": {
                    name: '复制整块',
                    icon: 'fa-copy',
                    disabled: function () {
                        let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
                        let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况，用mainTree.selected判断不正确,要用第一个选中的节点
                        for(let i = 0;i< selection.rowCount;i++){ //多选的时候判断所有与第一个节点同级的节点
                            let temNode = projectObj.project.mainTree.items[selection.row + i];
                            if(firstNode.getParentID() == temNode.getParentID()){
                                if(BlockController.copyBtnDisable(temNode) == true){
                                    return true;
                                }
                            }
                        }
                        return false;
                    },
                    callback: function () {
                        $.bootstrapLoading.start();
                        //let selected = project.mainTree.selected;
                        let selections = projectObj.mainSpread.getActiveSheet().getSelections();
                        setTimeout(function () {
                            BlockController.copyBlock(selections[0]);
                            $.bootstrapLoading.end();
                        },100)

                    }
                },
                "spr2":'--------',
                "pasteBlock": {
                    name: '粘贴整块',
                    icon: 'fa-paste',
                    disabled: function (){
                        return BlockController.pasteBtnDisable(project.mainTree.selected);
                    },
                    callback: function () {
                        BlockController.pasteBlock(project.mainTree.selected);
                    }
                },
                "editEngineer": {
                    name: '编辑工程内容',
                    icon: 'fa-edit',
                    visible: function(key, opt){
                         return project.Bills.isEngineerEst(project.mainTree.selected);//当焦点行是“专业工程暂估价”时，右键可见并有效。
                    },
                    callback: function () {
                        let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.ENGINEERING_ESITIMATE);
                        if(node){
                            projectObj.editContent(node,'engineeringContent');
                        }
                    }
                },
                "editService": {
                    name: '编辑服务内容',
                    icon: 'fa-edit',
                    visible: function(key, opt){
                        return project.Bills.isTotalService(project.mainTree.selected);//当焦点行是“总承包服务费”时，右键可见并有效。
                    },
                    callback: function () {
                        let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.TURN_KEY_CONTRACT);
                        if(node){
                            projectObj.editContent(node,'serviceContent');
                        }
                    }
                },
                "editAccording": {
                    name: '编辑签证及索赔依据',
                    icon: 'fa-edit',
                    visible: function(key, opt){
                        return project.Bills.isClaimVisa(project.mainTree.selected);//当焦点行是“签证及索赔计价”时，右键可见并有效。
                    },
                    callback: function () {
                        let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.CLAIM_VISA);
                        if(node){
                            projectObj.editContent(node,'claimVisa');
                        }
                    }
                }
            }
        });
    },
    // 计算node及node的所有父项
    converseCalculateBills: function (node) {
/*        if (node) {
            let calc = new BillsCalcHelper(this.project);
            calc.calcNode(node, true);
            let cur = node, nodes = [];
            while (cur) {
                nodes.push(cur);
                cur = cur.parent;
            }
            this.mainController.refreshTreeNode(nodes, false);
            this.project.Bills.updateNodes(nodes, true);
            calc = null;
        }*/
        projectObj.project.calcProgram.calcAndSave(node);
},
    // 计算全部清单
/*    calculateAll: function () {
        let calc = new BillsCalcHelper(this.project);
        calc.calcAll();
        this.mainController.showTreeData();
        this.project.Bills.updateAll();
        calc = null;
    }*/
    // 获取上次退出时的焦点位置
    loadFocusLocation: function() {
        const projectId = scUrlUtil.GetQueryString('project');
        let row = getLocalCache('lastRow:' + projectId);
        let col = getLocalCache('lastCol:' + projectId);
        if(row == null || col == null){
            row = 0;
            col = 0;
       }
        row = parseInt(row);
        col = parseInt(col);
        const sheet = this.mainSpread.getActiveSheet();
        sheet.setSelection(row, col, 1, 1);
        this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
    },
    // 选中区域合计数字
    amountAreaNumber: function(e, info) {
        if (info.newSelections === undefined || info.newSelections.length <= 0) {
            return false;
        }
        const selectedArea = info.newSelections[0];
        const sheet = info.sheet;
        if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
            return false;
        }
        //获取最左最右坐标
        let maxCell = {row: selectedArea.row, col: selectedArea.col + selectedArea.colCount};
        let maxCellX = sheet.getCellRect(maxCell.row, maxCell.col).x ? sheet.getCellRect(maxCell.row, maxCell.col).x : sheet.getCellRect(maxCell.row, maxCell.col - 1).x;
        let minCell = {row: selectedArea.row, col: selectedArea.col};
        let minCellX = sheet.getCellRect(minCell.row, minCell.col).x ? sheet.getCellRect(minCell.row, minCell.col).x : sheet.getCellRect(minCell.row, minCell.col + 1).x;
        // 获取鼠标位置
        let x = window.event.clientX;
        let y = window.event.clientY;

        // 匹配数字或小数
        const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
        // 小数点最高位数
        let max = 0;
        let total = 0;
        let counter = 0;
        for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
            for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
                const value = sheet.getCell(row, col).text();
                if (!regular.test(value)) {
                    continue;
                }
                counter++;
                // 获取当前数据小数位数
                let pointPosition = value.toString().indexOf(".");
                pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
                const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
                max = current > max ? current : max;
                total += parseFloat(value);
            }
        }
        // 如果不为0则悬浮显示
        if (total > 0 && counter > 1) {
            const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
            div.css({
                position: "absolute",
                border: "1px #C0C0C0 solid",
                background: "#fff",
                boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
            });
            div.children("p").css({
                textAlign: "center",
                padding: 8,
                marginBottom: 2,
            });
            div.children("p").first().css({
                borderBottom: "1px #C0C0C0 solid"
            });
            const totalString = total.toFixed(max);
            // input长度
            const inputWidth = totalString.length * 8;
            // 计算是否会超出显示范围
            const baseWidth = 48;
            const baseHeight = 81;
            const canvasWidth = $("#billsSpreadvp_vp").width();
            const canvasHeight = $("#billsSpreadvp_vp").height();
            //x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
            x = maxCellX + baseWidth + inputWidth > canvasWidth ? minCellX - baseWidth - inputWidth : maxCellX + baseWidth;
            y = y + baseHeight > canvasHeight ? y - baseHeight : y;
            //test
            let testT = sheet.getParent().hitTest(x, y);
            //test
            div.css({
                left: x,
                top: y,
            });

            div.children().children("#total").width(inputWidth).val(totalString);
            $("body").append(div);
            // 用于判断是否要关闭窗体
            setTimeout(function() {
                isTotalShowing = true;
            }, 200);
        };
    },
    /*amountAreaNumber: function(e, info) {
        if (info.newSelections === undefined || info.newSelections.length <= 0) {
            return false;
        }
        const selectedArea = info.newSelections[0];
        const sheet = info.sheet;
        if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
            return false;
        }
        // 获取鼠标位置
        let x = window.event.clientX;
        let y = window.event.clientY;

        // 匹配数字或小数
        const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
        // 小数点最高位数
        let max = 0;
        let total = 0;
        let counter = 0;
        for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
            for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
                const value = sheet.getCell(row, col).text();
                if (!regular.test(value)) {
                    continue;
                }
                counter++;
                // 获取当前数据小数位数
                let pointPosition = value.toString().indexOf(".");
                pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
                const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
                max = current > max ? current : max;
                total += parseFloat(value);
            }
        }
        // 如果不为0则悬浮显示
        if (total > 0 && counter > 1) {
            const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
            div.css({
                position: "absolute",
                border: "1px #C0C0C0 solid",
                background: "#fff",
                boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
            });
            div.children("p").css({
                textAlign: "center",
                padding: 8,
                marginBottom: 2,
            });
            div.children("p").first().css({
                borderBottom: "1px #C0C0C0 solid"
            });
            const totalString = total.toFixed(max);
            // input长度
            const inputWidth = totalString.length * 8;
            // 计算是否会超出显示范围
            const baseWidth = 48;
            const baseHeight = 81;
            const canvasWidth = $("#billsSpreadvp_vp").width();
            const canvasHeight = $("#billsSpreadvp_vp").height();
            x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
            y = y + baseHeight > canvasHeight ? y - baseHeight : y;
            //test
            let testT = sheet.getParent().hitTest(x, y);
            console.log(sheet.getCellRect(0, 0));
            //test
            div.css({
                left: x,
                top: y,
            });

            div.children().children("#total").width(inputWidth).val(totalString);
            $("body").append(div);
            // 用于判断是否要关闭窗体
            setTimeout(function() {
                isTotalShowing = true;
            }, 200);
        };
 },*/

    onButtonClick: function (e, info) {
        let colSetting = projectObj.mainController.setting.cols[info.col];
        let node = projectObj.project.mainTree.items[info.row];
        let fieldName = colSetting.data.field;
        if(fieldName == "isSubcontract"){
            projectObj.onSubcontractClick(node);
        }else if(fieldName == "isEstimate"){
            projectObj.onIsEstimateClick(node,info);
        }
    },
    onIsEstimateClick: function(node,info){
        let checkboxValue = info.sheet.getCell(info.row, info.col).value();
        let cell = info.sheet.getCell(info.row, info.col), newval = 0;
        if (checkboxValue) {
            newval = 0;
            cell.value(newval);
        } else {
            newval = 1;
            cell.value(newval);
        }
        if(MainTreeCol.readOnly.bills(node)){
            projectObj.updateNodeField(node,newval,'isEstimate');
        }else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
            console.log(node);
            let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
            projectObj.project.projectGLJ.pGljUpdate(updateData);
        }
    },
    onSubcontractClick:function (node) {//点击分包费checkbox
        if (node.data.isSubcontract) node.data.isSubcontract = false;
        else node.data.isSubcontract = true;
        node.changed = true;
        projectObj.project.calcProgram.calcAndSave(node);
    },

    //根据节点获取行style(颜色、字体加粗)
    getNodeColorStyle: function (sheet, node, tree) {
        let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
        let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
            FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
        let styleMap = null;
        tree?'':tree =  this.project.mainTree;
        //中文字段名，由于同一节点中，中文字体大小和数字字体大小不同
        if(colorSetting == null){
            return null;
        }
        let stringFields = [
            'code',
            'subType',
            'name',
            'unit',
            'itemCharacterText',
            'jobContentText',
            'adjustState',
            'calcBase',
            'programID',
            'ruleText'
        ];
        if(!isDef(node)){
            return null;
        }
        //清单大类
        if(node.sourceType === this.project.Bills.getSourceType()){
            //大项费用
            if(node.data.type === billType.DXFY){
                styleMap = mapping.DXFY;
            }
            //分部
            if(node.data.type === billType.FB){
                styleMap = mapping.FB;
            }
            //分项
            else if(node.data.type === billType.FX){
                styleMap = mapping.FX;
            }
            //补项
            else if(node.data.type === billType.BX){
                styleMap = mapping.BX;
            }
            //清单
            else if(node.data.type === billType.BILL){
                //非叶子节点的清单
                if(node.source.children.length > 0){
                    styleMap = mapping.UNLEAFBILL;
                }
                //未使用基数计算的叶子节点的清单
                else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
                    styleMap = mapping.UNCBBILL;
                }
                //使用基数计算的叶子节点的清单
                else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
                    styleMap = mapping.CBBILL;
                }
            }
        }
        //定额下的主材、设备
        else if(node.sourceType === this.project.ration_glj.getSourceType()){
            styleMap = mapping.ZCSB;
        }
        else {
            styleMap = mapping.DEFAULT;
        }
        let styleSetting = colorSetting[styleMap];
        let defaultSetting = colorSetting[mapping.DEFAULT];
        if(!isDef(styleSetting)){
            return null;
        }
        let style = new GC.Spread.Sheets.Style();
        //设置style属性
        for(let attr in styleSetting){
            if(attr !== 'stringFont' && attr !== 'numFont'){
                style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
            }
            //暂时不开放字体设置，开放的话只能每个单元格进入此方法
           /* else {
                if(stringFields.indexOf(colSetting.data.field) > 0){
                    style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
                }
                else {
                    style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
                }
            }*/
        }
        //选中行-替换底色
        if(node === tree.selected){
             style.backColor = colorSetting[mapping.SELECTED]['backColor'];
        }
        style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        return style;
    },
    //大项费用则字体加粗，String 15px, Number 13px
    getBoldFontStyle: function (node, colSetting) {
        let style = new GC.Spread.Sheets.Style();
        if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
            return null;
        }

        //备注暂无字段
        let stringFields = [
            'code',
            'subType',
            'name',
            'unit',
            'itemCharacterText',
            'jobContentText',
            'adjustState',
            'calcBase',
            'programID',
            'ruleText'
        ];

        if(stringFields.indexOf(colSetting.data.field) > 0){
            style.font = 'bold 15px Arial';
        }
        else {
            style.font = 'bold 13px Arial';
        }
        return style;
    },
   //设置节点style
    setNodesStyle: function (sheet, nodes,tree) {
        let me = this;
        TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
            for(let node of nodes){
                if(node && node.serialNo()!= -1){
                    sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node,tree).backColor);
                }
            }
        });

    },
    loadLockBillsButton:function () {
        if(projectInfoObj.projectInfo.property.lockBills == true){
            $("a[name='lockBills']").prop("title","解锁清单");
            $("a[name='lockBills']").html('<i class="fa fa-unlock-alt" aria-hidden="true"></i> 解锁清单');
        }else {
            $("a[name='lockBills']").prop("title","锁定清单");
            $("a[name='lockBills']").html('<i class="fa fa-lock" aria-hidden="true"></i> 锁定清单');
        }
    },
    editContent:function (node,fieldID) {//右键编辑工程内容、服务内容、签证及索赔依据
        let infoText = "请输入";
        switch (fieldID){
            case "engineeringContent":
                infoText +='工程内容:';
                break;
            case "serviceContent":
                infoText +='服务内容:';
                break;
            case "claimVisa":
                infoText +='签证及索赔依据:';
                break;
        }

        hintBox.valueBox(infoText, node.data[fieldID], function () {
            let newValue = hintBox.value;
            projectObj.updateNodeField(node,newValue,fieldID);
        });
    }

};

// 点击合计框中的复制
$("body").on("click", "#total-tips a", function() {
    const totalElement = $(this).parent().siblings("p").find("#total");
    totalElement.select();
    document.execCommand("Copy");
    $(this).text("已复制");
});
// 合计框点击其他位置关闭
let isTotalShowing = false;
$("body").on("click",  function(e) {
    if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
        $("#total-tips").remove();
        isTotalShowing = false;
    }
});

$('#insert').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected;

    if (!selected || selected.sourceType === project.Bills.getSourceType()) {
        ProjectController.addBills(project, controller);
    } else if (selected.sourceType === project.Ration.getSourceType()) {
        ProjectController.addRation(project, controller, selected.data.type);
    };
});

$('#delete').click(function () {
    let project = projectObj.project;
    let selected = project.mainTree.selected;
    if(isSingleSelect()&&selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部，并且没有子项，直接删除
        project.Bills.deleteSelectedNode();
    }else {
        $("#delete_row").modal({show:true});//弹出删除提示框;
    }
});

$('#upLevel').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, orgParent = selected.parent;

    if (selected && selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.upLevelBills(selected.source);
        controller.upLevel();
        controller.refreshTreeNode([orgParent]);
        projectObj.project.calcProgram.calcNodesAndSave([selected,orgParent]);
    }
});
$('#downLevel').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected;
    if (selected && selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.downLevelBills(selected.source);
        controller.downLevel();
        controller.refreshTreeNode([selected.parent]);
        projectObj.converseCalculateBills(selected.parent);
    }
});
$('#upMove').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;

    if (selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.upMoveBills(selected.source);
        controller.upMove();
    } else if (selected.sourceType === project.Ration.getSourceType()) {
        project.Ration.changePos(selected.source, selected.preSibling.source);
        controller.upMove();
    };
});
$('#downMove').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, next, nextSerialNo;

    if (selected) {
        if (selected.sourceType === project.Bills.getSourceType()) {
            project.Bills.downMoveBills(selected.source);
            controller.downMove();
        } else if (selected.sourceType === project.Ration.getSourceType()) {
            project.Ration.changePos(selected.source, selected.nextSibling.source);
            controller.downMove();
        };
    }
});
$("a[name='lockBills']").click(function () {//
    let lockBills = projectInfoObj.projectInfo.property.lockBills;
    lockBills = !lockBills;
    projectObj.project.updateLockBills(lockBills,function () {
        var controller = projectObj.mainController, project = projectObj.project;
        var selected = controller.tree.selected;
        let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
        controller.refreshTreeNode(nodes);
        projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
        projectObj.loadLockBillsButton();
        if(!projectReadOnly){
            pageCCOprObj.refreshRuleTools(lockBills);
        }
    });
});
$('#ZLFB_btn').click(function () {
    zlfb_object.getSectionInfo();
});

//工料机库
$('#compleGljLib').click(function () {
    let newTab = window.open('about:blank');
    let newHref = '/complementaryGlj';
    CommonAjax.get(newHref, [], function () {
        newTab.location.href = newHref;
    });
});

//显示至..
let displayLevel = function(nodes, depth, type){
    let refreshNodes = [];
    function getExpandedController(){
        if(type === 'DXFY' || type === 'FB'){
            if(type === 'FB'){
                projectObj.project.mainTree.items[0].setExpanded(true);
                refreshNodes.push(projectObj.project.mainTree.items[0]);
            }
            return  function expandedControl(nodes, depth){
                let bType = type === 'FB' ? billType.FB : billType.DXFY;
                for(let node of nodes){
                    let nodeDepth = node.depth();
                    if(nodeDepth <= depth){
                        let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
                        node.setExpanded(expanded);
                        refreshNodes.push(node);
                        if(nodeDepth < depth){
                            expandedControl(node.children, depth);
                        }
                    }
                }
            }
        }
        else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
            return  function expandedControl(nodes){
                for(let node of nodes){
                    if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
                        let expanded = true;
                        if(type === 'FX'){
                            expanded =  !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
                        }
                        else if(type === 'ZM'){
                            expanded =  !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
                        }
                        node.setExpanded(expanded);
                        refreshNodes.push(node);
                        expandedControl(node.children);
                    }
                }
            }
        }
    }
    getExpandedController()(nodes, depth);
    let sheet = projectObj.mainSpread.getActiveSheet();
    TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
        TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
    });
};
$('#displayDXFY').click(function () {
   displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
});
//显示至一级分部
$('#displayFB1').click(function () {
   displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
});
//二级分部
$('#displayFB2').click(function () {
    displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
});
//三级分部
$('#displayFB3').click(function () {
    displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
});
//四级分部
$('#displayFB4').click(function () {
    displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
});
//分项
$('#displayFX').click(function () {
    displayLevel(projectObj.project.mainTree.items, null, 'FX');
});
//子目
$('#displayZM').click(function () {
    displayLevel(projectObj.project.mainTree.items, null, 'ZM');
});
//最底层
$('#displayZD').click(function () {
   displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
});

$('#poj-set').on('show.bs.modal', function () {
    let setCalcFlag = function (obj, val, curFlag) {
        obj.val(val);
        if (val === curFlag) {
            obj.prop('checked', true);
        } else {
            obj.prop('checked', false);
        }
    }
    if (projectObj.project) {
        let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
        let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
        setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
        setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
        setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
        setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
        setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
        setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);

        let showAdjustPrice = projectObj.project.projSetting.glj_col?projectObj.project.projSetting.glj_col.showAdjustPrice:false;
        showAdjustPrice === true ? $("#tab_poj-settings-6").show():$("#tab_poj-settings-6").hide();
        projDisplayView.init();
        calcOptions.init();
    }
});

//恢复默认列设置
$('#recColSetting').click(function () {
    let libID = projectObj.project.property.colLibID ? projectObj.project.property.colLibID : null;
    if(!libID){
        alert('项目没有绑定标准列设置');
        return;
    }
    $(this).addClass('disabled');
    CommonAjax.post('/project/getDefaultColSetting', {libID: libID}, function (rstData) {
        if(!rstData || rstData.length === 0){
            alert('标准列设置没有数据');
            $('#recColSetting').removeClass('disabled');
            return;
        }
        let sheet = colSettingObj.settingSpread.getActiveSheet();
        SheetDataHelper.massOperationSheet(sheet, function () {
            for(let row = 0; row < sheet.getRowCount(); row++){
                sheet.setValue(row, 0, rstData.main_tree_col.cols[row].visible);
            }
        });
        $('#recColSetting').removeClass('disabled');
    }, function () {
        $('#recColSetting').removeClass('disabled');
    });
});

$('#property_ok').click(function () {
    let project = projectObj.project,
        projectID = project.ID(),

        properties = {},
        labourCoes = {},
        rations = [],
        bills = [],

        mixDatas = {
            projectID: projectID,
            updateType: 'update',
            properties: properties,
            labourCoes: labourCoes,
            rations: rations,
            bills: bills
        },

        reCalcBills = false,
        reCalcRations = false;

    let b = parseInt($("input[name='calcFlag']:checked").val());
    if (b !== project.property.billsCalcMode) {
        properties['property.billsCalcMode'] = b;
        project.property.billsCalcMode = b;
        reCalcBills = true;
    };

    let zg = parseInt($("input[name='zangu']:checked").val());
    if (zg !== project.property.zanguCalcMode) {
        properties['property.zanguCalcMode'] = zg;
        project.property.zanguCalcMode = zg;
        reCalcRations = true;
    };

    //基本信息
    if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
        let saveData = basicInfoView.toSaveDatas(basicInfoView.datas);
        projectObj.project.property.basicInformation = saveData;
        properties['property.basicInformation'] = saveData;
    }
    //工程特征
    if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
        let saveData = projFeatureView.toSaveDatas(projFeatureView.datas);
        projectObj.project.property.projectFeature = saveData;
        properties['property.projectFeature'] = saveData;
    }
    //清单工程量精度
    let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
    if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
        billsQuanDecimal.datas = newBillsDecimalDatas;
        reCalcBills = true;
        properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
    }
    //小数位数
    let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
    if(toUpdateDecimal(decimalObj, updateDecimal)) {
        let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
        setDecimal(decimalObj, updateDecimal);
        if (frChanged) {
            project.calcProgram.compileAllTemps()
        }
        reCalcRations = true;
        reCalcBills = true;
        properties['property.decimal'] = updateDecimal;
    }
    // 呈现选项
    projDisplayView.updateChecking(properties);
    //列设置（独立逻辑，只是通过项目属性确定按钮触发）
    if(colSettingObj.dataChanged()){
        colSettingObj.updateColSetting();
    }

    if(calcOptions.updateChecking(properties)){
        reCalcRations = true;
    }

    // 人工系数
    if (labourCoeView.needSave()){
        let libID = $("#std_labour_coe_files").children("option:selected").val();
        let libName = $("#std_labour_coe_files").children("option:selected").text();

        labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
        project.labourCoe.refreshData(labourCoes.updateData);  // 全编译所用到的人工系数来自project.labourCoe，所以必须先刷新project.labourCoe
        project.calcProgram.compileAllTemps();
        reCalcRations = true;
        reCalcBills = true;
    };
    // 重新计算树节点
    let changedNodes = [];
    if (reCalcRations)    // 定额动，全部计算。算完先不存储，和后面的数据一起提交，一次通讯。
        changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
    else if (reCalcBills)  // 清单动，可以只计算清单。
        changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
    if (changedNodes.length > 0) {
        for (let node of changedNodes){
            let data = calcTools.cutNodeForSave(node);
            if (node.sourceType == 'ration') rations.push(data)
            else if (node.sourceType == 'bills') bills.push(data);
        };
    };

    // for test.
/*    console.log(mixDatas);
    return; */
    function hasMixData() {
        return Object.keys(mixDatas.properties).length > 0 ||
            mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
    }

    function needToReload(mixDatas){
        if(Object.keys(mixDatas.labourCoes).length > 0){
            return true;
        }
        if(Object.keys(mixDatas.properties).length > 0){
            if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
                mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
                mixDatas.properties.hasOwnProperty('property.calcOptions')||
                mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
                mixDatas.properties.hasOwnProperty('property.decimal')||
                mixDatas.properties.hasOwnProperty('property.displaySetting')){
                return true;
            }
        }
        return false;
    }

    if(hasMixData()){
        CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
            //需要重载页面
            if(needToReload(mixDatas)){
                window.location.href = '/main?project=' + projectID;
            }
            else{
                if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
                    basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
                }
                if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
                    projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
                }
            }
        });
    }
});

function testShow() {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, parent = selected.parent;
    var showinfo = "<label>确认要删除当前选中行吗？</label>";
    var showN = false;
    var cancelText = "否";
    if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部，并且有子项
        if(isSingleSelect()||selectionChecking()){
            showinfo = "<label>是否删除其下的子项？</label><br><label>【是】则删除分部行及其下的所有子项，</label><br><label>【否】则仅删除当前分部行，子项保留，</label><br><label>【取消】则取消删除</label>";
            showN = true;
            cancelText = "取消";
        }
    }
    $('#delete_showinfo').html(showinfo);
    showN==true? $('#deleteN').show():$('#deleteN').hide();
    $('#deleteCancel').text(cancelText);

    function selectionChecking() {
        let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
        let mainTreeMap = {};
        for(let i =0;i<selection.rowCount;i++){
            let tem_node = controller.tree.items[selection.row+i];
            if(i==0){//第一个直接添加;
                mainTreeMap[tem_node.getID()] = tem_node;
            }else {
                project.Bills.setNodeToMap(tem_node,mainTreeMap);
            }
        }
        let nodes = changeMapToArray(mainTreeMap);
        if(nodes.length==1){
            return true
        }
        return false;
    }
}

$('#delete_row').on('show.bs.modal', function (e) {//这里用show,在shown之前调用，页面不会出现按钮闪现的情况
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, parent = selected.parent;
    var showinfo = "<label>确认要删除当前选中行吗？</label>";
    var showN = false;
    var cancelText = "否";
    if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部，并且有子项
        if(isSingleSelect()||selectionChecking()){
            showinfo = "<label>是否删除其下的子项？</label><br><label>【是】则删除分部行及其下的所有子项，</label><br><label>【否】则仅删除当前分部行，子项保留，</label><br><label>【取消】则取消删除</label>";
            showN = true;
            cancelText = "取消";
        }
    }
    $('#delete_showinfo').html(showinfo);
    showN==true? $('#deleteN').show():$('#deleteN').hide();
    $('#deleteCancel').text(cancelText);

    function selectionChecking() {
        let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
        let mainTreeMap = {}, nodes = [];
        for(let i =0;i<selection.rowCount;i++){
            let tem_node = controller.tree.items[selection.row+i];
            if(i==0){//第一个直接添加;
                mainTreeMap[tem_node.getID()] = tem_node;
            }else {
                project.Bills.setNodeToMapAndArray(tem_node,mainTreeMap,nodes);
            }
        }
        if(nodes.length==1){
            return true
        }
        return false;
    }
});

function changeMapToArray(map) {
    let newArray = [];
    for(let key in map){
        newArray.push(map[key]);
    }
    return newArray;
}


$('#deleteY').click(function () { //正常删除，级联删除子项
    let project = projectObj.project;
    project.Bills.deleteSelectedNodes();
    /*if(isSingleSelect()){
        project.Bills.deleteSelectedNode();//这个方法不用了，会出现异步删除干净的问题
    }else {
        project.Bills.deleteSelectedNodes();
    }*/
});

$('#deleteN').click(function () {//不删除子项
    let controller = projectObj.mainController, project = projectObj.project;
    let selected = controller.tree.selected, parent = selected.parent;
    if(selected){
        let preNode = selected.preSibling;
        let nextNode = selected.nextSibling;
        if(preNode){//有前兄弟
            if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
                alert("删除分部会导致分部和分项同级，不允许该操作！");
                return;
            }
        }else if(nextNode){
            if(nextNode.data.type != selected.children[0].data.type){
                alert("删除分部会导致分部和分项同级，不允许该操作！ ");
                return;
            }
        }
        project.Bills.singleDeleteBills(selected,controller);
    }
});

function isSingleSelect() {//是否选中造价书中的单行
    let selections = projectObj.mainSpread.getActiveSheet().getSelections();
    if (selections[0].rowCount == 1) {
        return true;
    }
    return false;
}
function ifCanDelete() {
    let selections = projectObj.mainSpread.getActiveSheet().getSelections();
    let tree = projectObj.project.mainTree;
    let selected = projectObj.project.mainTree.selected;
    if(selections[0].rowCount==1){//选中单行
        return canDelete(selected);
    }else {
       return canDelete_m(selections[0]);
    }

    function canDelete(node,m_selection) {
        if (node) {
            if (node.sourceType === projectObj.project.Bills.getSourceType()) {
                if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
                    return false;
                }
                if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
                    return false;
                }
                if(projectObj.project.Bills.hasFlags(node)){
                    return false;
                }
            }
            if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
                return false;
            }
            return true;
        } else {
            return false;
        }
    };

    function canDelete_m(selection) {
        for(let i =0;i<selection.rowCount;i++){
            if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
                return false;
            }
            if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
                return false
            }
            if(canDelete(tree.items[selection.row+i],true)==false){
                return false
            }
        }
        return true
    };
}

function canInsertRationNode(selected) {//判断是否能插入定额、量价、定额类型工料机, false 不能，true能
    if(!selected)
        return false;
    let project = projectObj.project;
    if(selected.sourceType == ModuleNames.bills && selected.data.type == billType.DXFY){
        return false
    }else if(!(project.Bills.isMeasure(selected)||project.Bills.isFBFX(selected))){
        return false
    }else if(selected.sourceType == ModuleNames.bills && selected.source.children.length > 0){
        return false
    }
    else {
        return true
    }

/*    if (selected) {// Vincent, 2018-01-02
        if(selected.sourceType === project.Ration.getSourceType()){ // 焦点行是定额/量价/工料机，有效显示。
            return false;
        }else if(selected.sourceType === project.Bills.getSourceType()){
            if(selected.data.type == billType.FX || selected.data.type == billType.BX){//焦点行是分项，有效显示。
                return false
            }
            if(selected.data.type == billType.BILL && selected.source.children.length === 0){//焦点行是清单，且没有子项，有效显示。
                return false
            }
        }
    }
    return true;*/
}

//导入类型（09表、广联达）
const uploadType = {lj: 'lj', gld: 'gld'};
let fileType = uploadType.lj;

$('#uploadLj').click(function () {
    fileType = uploadType.lj;
});
$('#uploadGld').click(function () {
   fileType = uploadType.gld;
});

//设置导入表内容
function setUploadSheets(sheetNames){
    let sheetArea = $('#uploadSheets');
    $('#uploadSheets').height('');
    sheetArea.empty();
    for(let sheetName of sheetNames){
        let sheetDiv = $(`<div style="margin-left: 5px;margin-top: 5px;" class="input-group form-check"><label class="form-check-label" style="width:270px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis">
                           <input class="form-check-input" type="checkbox">${sheetName}</label></div>`);
        sheetDiv.find('input[type="checkbox"]').click(function () {
            if($('#uploadAlert').is(':visible')){
                $('#uploadAlert').hide();
            }
        });
        let sel = $(`<select style="margin-left: 5px; border-radius: .20rem;"><option value="fbfx">分部分项工程</option><option value="zzcsxm">施工组织措施项目</option><option value="jscsxm">施工技术措施项目</option></select>`);
        if(sheetName.includes('分部分项工程项目清单计价表')){
            sheetDiv.find('input[type="checkbox"]').prop('checked', true);
            sel.find('option:eq(0)').prop('selected', true);
        }
        else if(sheetName.includes('施工组织措施项目清单计价表')){
            sheetDiv.find('input[type="checkbox"]').prop('checked', true);
            sel.find('option:eq(1)').prop('selected', true);
        }
        else if(sheetName.includes('施工技术措施项目清单计价表')){
            sheetDiv.find('input[type="checkbox"]').prop('checked', true);
            sel.find('option:eq(2)').prop('selected', true);
        }
        sheetDiv.append(sel);
        sheetArea.append(sheetDiv);

    }
    if(sheetNames.length > 0){
        sheetArea.show();
    }
    if($('#uploadSheets').height() > 250){
        console.log('aa');
        sheetArea.css('overflow', 'auto');
        sheetArea.height(250);
    }
    else {
        sheetArea.css('overflow', 'hidden');
    }
}
//获得选择导入的表信息(表索引及导入位置)
function getUploadSheets(){
    let rst = [];
    let sheetArea = $('#uploadSheets');
    let checkedInputs = sheetArea.find('input:checked');
    for(let checked of checkedInputs){
        rst.push({sheetIdx: $(checked).parent().parent().index(), position: $(checked).parent().next().select().val()})
    }
    return rst;
}

//选择要导入的excel文件
$('#customFile').change(function () {
    let file = $(this)[0];
    if(file.files.length > 0){
        $('.custom-file-label').text(`${file.files[0].name}`);
        $('#uploadAlert').hide();
        //读取各个表及表名
        $.bootstrapLoading.start();
        let fileReader = new FileReader();
        fileReader.onload = function(ev) {
            try {
                let data = ev.target.result;
                // 以二进制流方式读取得到整份excel表格对象
                let workbook = XLSX.read(data, {type: 'binary'});
                // 遍历每张表读取
                let sheetNames = [];
                for (let sheetName in workbook.Sheets) {
                    sheetNames.push(sheetName);
                }
                setUploadSheets(sheetNames);
                $.bootstrapLoading.end();
            } catch (e) {
                console.log(e);
                $.bootstrapLoading.end();
                alert('文件类型不正确');
                return;
            }
        };
        // 以二进制方式打开文件
        fileReader.readAsBinaryString(file.files[0]);
    }
    else{
        $('.custom-file-label').text(`请选择上传文件`);
    }
});
//从excel导入清单
$('#uploadConfirm').click(function () {
    let me = this;
    $(me).addClass('disabled');
    try{
        let formData = new FormData();
        let file = $('#customFile')[0];
        if(file.files.length <= 0){
            throw '未选择文件';
        }
        formData.append('file', file.files[0]);
        let projectID = scUrlUtil.GetQueryString('project');
        if(!projectID || projectID <= 0){
            throw '项目数据出错';
        }
        //导入表类型（09lj、广联达gld）
        formData.append('fileType', fileType);
        //选择的表及导入位置
        let uploadWorkBook = getUploadSheets();
        if(uploadWorkBook.length === 0){
            throw '请选择要导入的表';
        }
        formData.append('uploadWorkBook', JSON.stringify(uploadWorkBook));
        formData.append('projectID', projectID);
        //要去匹配的清单库（第一个）
        let matchBillLibId = projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id : null;
        formData.append('billsLibId', matchBillLibId);
        let uploadS = +new Date();
        $.ajax({
            url: '/bills/upload',
            type: 'POST',
            data: formData,
            cache: false,
            contentType: false,
            processData: false,
            beforeSend: function() {
                $.bootstrapLoading.start();
            },
            success: function(response){
                if (response.err === 0) {
                    const message = response.msg !== undefined ? response.msg : '';
                    if (message !== '') {
                        alert(message);
                    }
                    let uploadE = +new Date();
                    console.log(`导入时间：${uploadE-uploadS}`);
                    // 成功则关闭窗体
                    $('#import').modal("hide");
                    //更新前端
                    doAfterImport(response.data);
                    if($.bootstrapLoading.isLoading()){
                        $.bootstrapLoading.end();
                    }
                } else {
                    const message = response.msg !== undefined ? response.msg : '上传失败!';
                    $.bootstrapLoading.end();
                    alert(message);
                }
                $(me).removeClass('disabled');
            },
            error: function(){
                alert("与服务器通信发生错误");
                $.bootstrapLoading.end();
                $(me).removeClass('disabled');
            }
        });
    }
    catch (err){
        //alert(err);
        showUploadAlert(false, err);
        $(me).removeClass('disabled');
    }
});
function showUploadAlert(success, msg){
    if(!success){
        $('#uploadAlert').removeClass('alert-success');
        $('#uploadAlert').addClass('alert-danger');
    }
    else{
        $('#uploadAlert').removeClass('alert-danger');
        $('#uploadAlert').addClass('alert-success');
    }
    $('#uploadAlert').text(msg);
    $('#uploadAlert').show();
}
//导入清单到一个固定行位置后，更新数据
function doAfterImportPosition(positionData){
    let nodes = projectObj.project.mainTree.nodes;
    let bills_datas = projectObj.project.Bills.datas;
    let ration_datas = projectObj.project.Ration.datas;
    let quantity_detail_datas = projectObj.project.quantity_detail.datas;
    let ration_glj_datas = projectObj.project.ration_glj.datas;
    let ration_coe_datas = projectObj.project.ration_coe.datas;
    let ration_install_datas = projectObj.project.ration_installation.datas;
    let delNodes = [];
    for(let billID of positionData.remove.bill){
        if(nodes['id_' + billID]){
            delNodes.push(nodes['id_' + billID]);
        }
        //清除清单数据
        _.remove(bills_datas, {ID: billID});
        //清除清单工程量明细数据
        _.remove(quantity_detail_datas, {billID: billID});
    }
    for(let rationID of positionData.remove.ration){
        //清除定额数据
        _.remove(ration_datas, {ID: rationID});
        //清除定额下的相关数据
        _.remove(ration_glj_datas, {rationID: rationID});
        _.remove(ration_coe_datas, {rationID: rationID});
        _.remove(ration_install_datas, {rationID: rationID});
        _.remove(quantity_detail_datas, {rationID: rationID});

    }
    //删除节点
    if(delNodes.length > 0){
        //通过固定清单获得删除节点的起始行索引
        let beginRow = null;
        if(positionData.fixedBill){
            let fixedNode = nodes['id_' + positionData.fixedBill.ID];
            if(fixedNode){
                beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
            }
        }
        //删除主树节点
        projectObj.mainController.m_delete(delNodes, beginRow);
        //删除清单树节点
        let delIdNodes = [];
        for(let delNode of delNodes){
            delIdNodes.push(delNode.source);
        }
        projectObj.project.Bills.tree.m_delete(delIdNodes);
    }
    if(positionData.insert.bill.length > 0){
        //设置flagsIndex
        for(let insertBill of positionData.insert.bill){
            insertBill.flagsIndex = {};
            if (insertBill.flags) {
                insertBill.flags.forEach(function (flag) {
                    insertBill.flagsIndex[flag.fieldName] = flag;
                });
            }
        }
        //插入清单节点
        projectObj.project.Bills.tree.insertByDatas(positionData.insert.bill);
        //插入主树节点
        let newNodes = projectObj.project.mainTree.insertByDatas(positionData.insert.bill);
        for(let node of newNodes){
            node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
            node.data = node.source.data;
            node.sourceType = projectObj.project.Bills.getSourceType();
        }
        ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
    }
}
//导入后更新操作
function doAfterImport(resData){
    if(resData && resData.length > 0){
        for(let positionData of resData){
            doAfterImportPosition(positionData);
        }
        //如果清单未锁定，导入后锁定清单
        if(!projectInfoObj.projectInfo.property.lockBills){
            $("a[name='lockBills']").click();
        }
        $.bootstrapLoading.end();
        //重算
        projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
            projectObj.project.projectGLJ.loadData(function () {
                $.bootstrapLoading.end();
            });
        });
    }
}
//下载导入清单示例文件
$('#uploadExample').click(function () {
    window.location.href = '/bills/downloadExamp';
});

$(function () {
    //清空导入清单选择文件
    $('#import').on('show.bs.modal', function(){
        $('#customFile').val('');
        $('#uploadAlert').hide();
        $('.custom-file-label').text(`请选择上传文件`);
    });

    $('#import').on('hidden.bs.modal', function () {
        //恢复选择表高度
        $('#uploadSheets').height('');
        $('#uploadSheets').hide();
    });

    $("#billsSpread").mouseover(function(){
        spreadAutoFocus(projectObj.mainSpread,subSpread);
    });

    $("#subSpread").mouseover(function(){
        spreadAutoFocus(subSpread,projectObj.mainSpread);
    });

    $("#paste_confirm").click(function (){
        let selected = projectObj.project.mainTree.selected;
        let blockData = BlockController.getBlockData();
        let position = $("input[name='pastePositionRadio']:checked").val();
        BlockController.confirmPaste(blockData,selected,position);
        $("#pastePosition").modal("hide");

    });


    function spreadAutoFocus(spread,relateSpread) {
        if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下，才自动获得焦点;
            return;
        }else {
            spread?spread.focus():'';
        }
    }
    //项目为只读
    if(projectReadOnly){
        disableTools();
    }
});

//项目只读，处理不可操作的工具栏
function disableTools(){
    //造价书按钮
    $('#delete').remove();
    $('#upLevel').remove();
    $('#downLevel').remove();
    $('#upMove').remove();
    $('#downMove').remove();
    $('#ZLFB_btn').remove();
    $('#switchTznr').remove();
    $('a[name="lockBills"]').remove();
    //关于计算
    $('#poj-settings-4').find('input').prop('disabled', 'disabled');
    //小数位数
    $('#poj-settings-decimal').find('input').prop('disabled', 'disabled');
    //人工单价调整
    $('#std_labour_coe_files').prop('disabled', 'disabled');
    //呈现选项
    $('#display-setting').find('input').prop('disabled', 'disabled');
    $('#recColSetting').remove();
    //项目属性确定
    $('#property_ok').addClass('disabled');
    //特征及内容
    $('#add-rule').find('select').prop('disabled', 'disabled');
    $('#use-to-current').addClass('disabled');
    $('#use-to-all').addClass('disabled');
    $('.bottom-tools').remove();
    //导入
    $('#uploadConfirm').addClass('disabled');
    //选项
    $('#generalOpts1').prop('disabled', 'disabled');
    $('#generalOpts2').prop('disabled', 'disabled');
    //补充库编辑器
    $('#compleRationLib').addClass('disabled');
    $('#compleGljLib').addClass('disabled')
    //库
    $('#stdBillsGuidanceTab').addClass('disabled');
    $('#stdBillsTab').addClass('disabled');
    $('#stdRationTab').addClass('disabled');
    //人材机汇总,选择其他、另存使用
    $('a[data-target="#change-unitFile"]').remove();
    $('a[data-target="#unitFile-save-as"]').remove();
    //费率,选择其他、另存使用、重选标准、统一设置相同参数
    $('a[data-target="#change-lv"]').remove();
    $('a[data-target="#copy-lv"]').remove();
    $('#standardSelect').prop('disabled', 'disabled');
    $('#cascadeSet').prop('disabled', 'disabled');
    //计算程序标准
    $('#calcProgramFileSelect').prop('disabled', 'disabled');
    //调价
    $('#calcPriceOption').prop('disabled', 'disabled');
    $('#gljPriceTenderCoe').prop('disabled', 'disabled');
    $('#tenderGLJQuantity').prop('disabled', 'disabled');
    $('#tenderRationQuantity').prop('disabled', 'disabled');
    $('#tenderPrice').prop('disabled', 'disabled');
    $('#cleanTender').prop('disabled', 'disabled');
}
//项目只读，表格只读
function disableSpread(spread){
    spread.unbind(GC.Spread.Sheets.Events.ButtonClicked);
    let sheetCount = spread.getSheetCount();
    console.log(sheetCount);
    for(let i = 0; i < sheetCount; i++){
        let sheet = spread.getSheet(i);
        sheet.unbind(GC.Spread.Sheets.Events.ButtonClicked);
        sheet.unbind(GC.Spread.Sheets.Events.EditStarting);
        sheet.unbind(GC.Spread.Sheets.Events.EditEnded);
        sheet.unbind(GC.Spread.Sheets.Events.RangeChanged);
        sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanging);
        sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanged);
        sheet.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
        sheet.unbind(GC.Spread.Sheets.Events.CellClick);
        sheet.unbind(GC.Spread.Sheets.Events.ValueChanged);
        console.log(sheet.name());
        sheet.suspendPaint();
        sheet.suspendEvent();
        sheet.options.isProtected = true;
        let rowCount = sheet.getRowCount();
        let colCount = sheet.getColumnCount();
        for(let row = 0; row < rowCount; row++){
            for(let col = 0; col < colCount; col++){
                sheet.getCell(row, col).locked(true);
            }
        }
        sheet.resumePaint();
        sheet.resumeEvent();
    }
}