ConstructionCost/web/rationRepository/js/coeList.js

/**
 * Created by CSL on 2017-05-18.
 */

$("#drirect-dinge").click(function(){
    $(this).attr('href', "/rationRepository/ration" + "?repository=" + getQueryString("repository"))
});

$("#gongliao").click(function(){
    $(this).attr('href', "/rationRepository/lmm" + "?repository=" + getQueryString("repository"))
});

pObj = {
    spread: null,

    createSheet: function (container, colDef, datas){
        var me = this;
        me.spread = new GC.Spread.Sheets.Workbook(container, {sheetCount:1});
        me.spread.suspendPaint();

        me.spread.options.tabStripVisible = false;
        me.spread.options.showHorizontalScrollbar = false;

        var sheet = me.spread.getSheet(0);
        var sheetArea = GC.Spread.Sheets.SheetArea;
        sheet.setRowHeight(0, 30, sheetArea.colHeader);
        sheet.autoGenerateColumns = false;
        sheet.setDataSource(datas);
        sheet.bindColumns(colDef);
        sheet.getRange(-1, 2, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign.center);

        me.spread.resumePaint();
    }
};


var colDefMain = [
    {name: "ID", displayName: "编号", size: 100},
    {name: "name", displayName: "名称", size: 200},
    {name: "content", displayName: "内容", size: 250}
];

var colDefContent = [
    {name: "coeType", displayName: "类型", size: 100},
    {name: "gljID", displayName: "工料机ID", size: 100},
    {name: "operator", displayName: "操作符", size: 60},
    {name: "amount", displayName: "数量", size: 80}
];

pObj.createSheet($('#mainSpread')[0], colDefMain, createDatas(50));
pObj.createSheet($('#contentSpread')[0], colDefContent, createContents(10));


function createDatas(counts){
    var datas = [];
    var names = ['洞内排水量15m3/h以内', '二级以上松土', '三四级石方', '灌注桩，水平泵送混凝土距离100m', '用于拆除工程'];
    for (var i = 0; i < counts; i++) {
        var data = new Object();
        data.ID = i;
        data.name = names[i % names.length] + i;
        data.content = '附注条件' + data.name + '之内容部分';
        datas.push(data);
    };
    return datas;
}

function createContents(counts){
    var datas = [];
    var types = ['人工类', '材料类', '机械类','单GLJ','全部'];
    var operators = ['+', '-', '*', '/', '='];
    for (var i = 0; i < counts; i++) {
        var data = new Object();
        data.coeType = types[i % types.length];
        data.gljID = (data.coeType == '单GLJ') ? Math.floor(Math.random() * 1000) : 0;
        data.operator = operators[i % operators.length];
        data.amount = Math.floor(Math.random() * 1000) / 100;
        datas.push(data);
    };
    return datas;
}

function testObj2(obj) {
    var str = "";
    var spr = "";
    for (var x in obj) {
        if (obj.hasOwnProperty(x)) {
            if(str == ''){ spr = '' } else { spr = ', '};
            str += spr + x + ':' + obj[x];
        }
    }
    return str;
};