ConstructionCost/web/rationLibEditor/js/sheetCommon.js

/**
 * Created by Tony on 2017/4/28.
 */
var sheetCommonObj = {
    buildSheet: function(container, setting, rowCount) {
        var me = this;
        var spreadBook = new GC.Spread.Sheets.Workbook(container, { sheetCount: 1 });
        spreadBook.options.tabStripVisible = false;
        spreadBook.options.showHorizontalScrollbar = false;
        var spreadNS = GC.Spread.Sheets;
        var sheet = spreadBook.getSheet(0);
        sheet.suspendPaint();
        sheet.suspendEvent();
        //Set rowHeader count and columnHeader count.
        sheet.setRowCount(1, spreadNS.SheetArea.colHeader);
        sheet.setColumnCount(setting.header.length, spreadNS.SheetArea.viewport);
        sheet.options.colHeaderAutoTextIndex = 1;
        sheet.options.colHeaderAutoText = spreadNS.HeaderAutoText.numbers;
        sheet.showRowOutline(false);
        //setup column header
        me.buildHeader(sheet, setting);
        //setup cells
        if (rowCount > 0) sheet.setRowCount(rowCount);
        sheet.resumeEvent();
        sheet.resumePaint();
        return spreadBook;
    },
    buildHeader: function(sheet, setting){
        var me = this, ch = GC.Spread.Sheets.SheetArea.colHeader;
        for (var i = 0; i < setting.header.length; i++) {
            sheet.setValue(0, i, setting.header[i].headerName, ch);
            sheet.setColumnWidth(i, setting.header[i].headerWidth?setting.header[i].headerWidth:100);
        }
    },
    cleanSheet: function(sheet, setting, rowCount) {
        sheet.suspendPaint();
        sheet.suspendEvent();
        sheet.clear(-1, 0, -1, setting.header.length, GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
        if (rowCount > 0) sheet.setRowCount(rowCount);
        sheet.resumeEvent();
        sheet.resumePaint();
    },
    showData: function(sheet, setting, data) {
        var me = this, ch = GC.Spread.Sheets.SheetArea.viewport;
        sheet.suspendPaint();
        sheet.suspendEvent();
        var private_setCellAlign = function(cell, hAlign, vAlign) {
            if (!(hAlign) || hAlign === "left") {
                cell.hAlign(GC.Spread.Sheets.HorizontalAlign.left);
            } else if (hAlign === "right") {
                cell.hAlign(GC.Spread.Sheets.HorizontalAlign.right);
            } else if (hAlign === "center") {
                cell.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
            } else {
                cell.hAlign(GC.Spread.Sheets.HorizontalAlign.left);
            }
            if (!(vAlign) || vAlign === "center") {
                cell.vAlign(GC.Spread.Sheets.VerticalAlign.center);
            } else if (vAlign === "top") {
                cell.vAlign(GC.Spread.Sheets.VerticalAlign.top);
            } else if (vAlign === "bottom") {
                cell.vAlign(GC.Spread.Sheets.VerticalAlign.bottom);
            } else {
                cell.vAlign(GC.Spread.Sheets.VerticalAlign.center);
            }
        };
        for (var row = 0; row < data.length; row++) {
            for (var col = 0; col < setting.header.length; col++) {
                var cell = sheet.getCell(row, col, GC.Spread.Sheets.SheetArea.viewport)
                    hAlign = "left", vAlign = "center";
                sheet.setValue(row, col, data[row][setting.header[col].dataCode], ch);
                if (setting.header[col].hAlign) {
                    hAlign = setting.header[col].hAlign;
                } else if (setting.header[col].dataType !== "String"){
                    hAlign = "right";
                }
                vAlign = setting.header[col].vAlign?setting.header[col].vAlign:vAlign;
                private_setCellAlign(cell, hAlign, vAlign);
                if (setting.header[col].formatter) {
                    var style = new GC.Spread.Sheets.Style();
                    style.formatter = setting.header[col].formatter;
                    sheet.setStyle(row,col,style,GC.Spread.Sheets.SheetArea.viewport);
                }
            }
        }
        sheet.resumeEvent();
        sheet.resumePaint();
        //me.shieldAllCells(sheet);
    },
    analyzePasteData: function(setting, pastedInfo) {
        var rst = [], propId = 0, preStrIdx = 0, itemObj = {};
        for (var i = 0; i < pastedInfo.pasteData.text.length; i++) {
            if (pastedInfo.pasteData.text[i] === "\n") {
                propId = 0;
                preStrIdx = i + 1;
                rst.push(itemObj);
                if (i < pastedInfo.pasteData.text.length - 1) {
                    itemObj = {};
                }
            } else if (pastedInfo.pasteData.text[i] === "\t" || pastedInfo.pasteData.text[i] === "\r") {
                itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx, i);
                propId++;
                preStrIdx = i + 1;
                //if the last copied-cell were empty, should check whether the end of text
                if (i == pastedInfo.pasteData.text.length - 1) {
                    itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx);
                    rst.push(itemObj);
                }
            } else if (i == pastedInfo.pasteData.text.length - 1) {
                itemObj[setting.header[propId].dataCode] = pastedInfo.pasteData.text.slice(preStrIdx);
                rst.push(itemObj);
            }
        }
        return rst;
    },
    shieldAllCells: function(sheet) {
        sheet.options.isProtected = true;
    }
}