ConstructionCost/web/fees/feeRate.js

/**
 * Created by CSL on 2017-03-23.
 */
var region = '重庆';
var feeRateFileID = 5;
var spreadView;

$(document).ready(function () {
    $("#inlineFormCustomSelect").change(function () {
        var libID = $("#inlineFormCustomSelect").val();
        loadLibFeeRates(libID);
    });

    $("#projectFeeFile").click(function () {
        loadProjectFeeRates(feeRateFileID);
    });
});

function loadProjectFeeRates(fileID) {
    $.ajax({
        type: "POST",
        url: '/fees/getProjectFeeRates',
        data: {"fileID": fileID},
        success: function (result) {
            if (result.data) {
                createSpreadView(result.data[0].rates, true);
            }
        },
        error: function (result) {
            alert('内部程序错误！');
        }
    });
}

function loadStdFeeRateLibNames(region) {
    $('#inlineFormCustomSelect').empty();

    $.ajax({
        type: "POST",
        url: '/fees/getLibNames',
        data: {"region": region},
        success: function (result) {
            if (result.data) {
                for (var i = 0; i < result.data.length; i++) {
                    $("#inlineFormCustomSelect").append("<option value=" + result.data[i].libID + '>' +
                        result.data[i].libName + "</option>");
                }
                $("#inlineFormCustomSelect").get(0).selectedIndex = 0;
            }
        },
        error: function (result) {
            alert('内部程序错误！');
        }
    });
}

function loadLibFeeRates(libID) {
    $.ajax({
        type: "POST",
        url: '/fees/getLibFeeRates',
        data: {"libID": libID},
        success: function (result) {
            if (result.data) {
                createSpreadView(result.data[0].rates, false);
            }
        },
        error: function (result) {
            alert('内部程序错误！');
        }
    });
}

function createSpreadView(data, canEdit) {
    // 创建前先销毁旧树表。
    //$('#divFee').empty();  // 清空不行，浏览器跟踪显示错误数狂飚：TypeError: G is null
    //$('#divFee').remove(); // 删除可以，但是太山寨。
    //$('#content').append($('<div class="grid" id="divFee"></div>'));
    // 以下找到官方的处理方法，比较面向对象
    if (spreadView) {
        spreadView.destroy();
        spreadView = null;
    }

    var columns = [
        {
            id: 'name',
            caption: '名称',
            dataField: 'name',
            width: 250
        },
        {
            id: 'rate',
            caption: '费率',
            dataField: 'rate',
            format: '0.000',
            width: 80,
            minWidth: 50
        },
        {
            id: 'memo',
            caption: '说明',
            dataField: 'memo',
            width: 200,
            minWidth: 120
        },
        {
            id: 'ID',
            caption: 'ID',
            dataField: 'ID',
            width: 80,
            visible: false
        },
        {
            id: 'ParentID',
            caption: '父结点ID',
            dataField: 'ParentID',
            width: 80,
            visible: false
        }
    ];

    var option = {
        allowSorting: false,
        showRowHeader: true,
        colMinWidth: 80,
        colHeaderHeight: 35,
        rowHeight: 30,
        allowEditing: canEdit,
        hierarchy: {
            keyField: 'ID',
            parentField: 'ParentID',
            collapsed: false,
            column: 'name'
        }
    };

    spreadView = new GC.Spread.Views.DataView($('#divFee')[0],
        data, columns, new GC.Spread.Views.Plugins.GridLayout(option));
    var opts = spreadView.layoutEngine.options;
    opts.editMode = 'inline';
    opts.editUnit = 'cell';
    if (canEdit){ opts.selectionUnit = 'cell'; }
    else{ opts.selectionUnit = 'row'; }
    spreadView.invalidate();
    document.querySelector('#divFee').focus();
}