ConstructionCost/web/rationLibEditor/js/repositoryGLJ.js

/**
 * Created by Tony on 2017/5/5.
 */

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

var pageOprObj = {
    rationLibName : null,
    initPage : function(container) {
        var me = this, rationLibName = getQueryString("repository");//获取定额库参数
        if (rationLibName) {
            var html = $("#rationname")[0].outerHTML;
            html = html.replace("XXX定额库", rationLibName);
            $("#rationname")[0].outerHTML = html;
            me.rationLibName = rationLibName;
            repositoryGljObj.getGljTree(rationLibName, function(repId){
                repositoryGljObj.buildSheet(container);
                repositoryGljObj.getGljItems(repId);
            });
        }
    }
}
repositoryGljObj = {
    treeObj : null,
    workBook: null,
    gljAllTypeId: -1,
    gljCurTypeId: -1,
    currentRepositoryId: -1,
    gljList: [],
    setting: {
        header:[
            {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
            {headerName:"名称",headerWidth:400,dataCode:"name", dataType: "String", hAlign: "left", vAlign: "center"},
            {headerName:"规格",headerWidth:120,dataCode:"specs", dataType: "String", hAlign: "left", vAlign: "center"},
            {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
            {headerName:"基价单价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
            {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "Number", hAlign: "center", vAlign: "center"}
        ],
        view:{
            comboBox:[
                {row:-1,col:3,rowCount:-1,colCount:1}
            ],
            lockedCells:[
            ]
        }
    },
    getGljTree: function(rationLibName, callback) {
        var me = this;
        $.ajax({
            type:"POST",
            url:"api/getGljTree",
            data:{"rationLibName": rationLibName},
            dataType:"json",
            cache:false,
            timeout:20000,
            success:function(result,textStatus,status){
                if(status.status == 200) {
                    me.createTree(result.data);
                    //me.gljAllTypeId
                    if (result.data && result.data.length > 0) {
                        for (var i = 0; i < result.data.length; i++) {
                            if (result.data[i].Name === "全部") {
                                me.gljAllTypeId = result.data[i].ID;
                                me.gljCurTypeId = me.gljAllTypeId;
                                break;
                            }
                        }
                        if (callback) {
                            var repId = -1;
                            repId = result.data[0].repositoryId;
                            callback(repId);
                        }
                    }
                }
            },
            error:function(err){
                alert(err.responseJSON.error);
            }
        })
    },
    createTree : function(sourceData){
        var me = repositoryGljObj, treeArr = tree_Data_Helper.buildTreeNodeDirectly(sourceData);
        me.treeObj = $.fn.zTree.init($("#repositoryTree"), setting, treeArr);
        me.treeObj.expandAll(true);
    },
    getGljItems: function(repId) {
        var me = this;
        me.currentRepositoryId = repId;
        $.ajax({
            type:"POST",
            url:"api/getGljItems",
            data:{"repositoryId": repId},
            dataType:"json",
            cache:false,
            timeout:5000,
            success:function(result){
                if(result.success) {
                    me.gljList = result.data;
                    me.showGljItems(result.data, me.gljCurTypeId);
                }
            },
            error:function(err){
                alert(err.responseJSON.error);
            }
        })
    },
    showGljItems: function(data, type) {
        var me = repositoryGljObj;
        if (me.workBook) {
            var cacheSection = [];
            for (var i = 0; i < data.length; i++) {
                if (type == me.gljAllTypeId || type == data[i].gljType) {
                    cacheSection.push(data[i]);
                }
            }
            cacheSection.sort(function(g1, g2) {
                var rst = 0;
                if (g1.code > g2.code) rst = 1
                else if (g1.code < g2.code) rst = -1;
                return rst;
            })
            sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
            sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, cacheSection);
        }
    },
    buildSheet: function(container) {
        var me = repositoryGljObj;
        me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
        //var instance = new GC.Spread.Common.CultureInfo();
        //var value; // Type: Object
        //value = instance.NumberFormat;
        //console.log(value);
        me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
        me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
        //me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, function (sender, args) {
        //    console.log("Start cell editing.");
        //});
        me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, function (sender, args) {
            console.log("Finish cell editing.");
            //if (args.col == 0) {
            //    args.sheet.suspendPaint();
            //    args.sheet.suspendEvent();
            //    args.sheet.setValue(args.row, args.col, args.editingText, GC.Spread.Sheets.SheetArea.viewport);
            //    args.sheet.resumeEvent();
            //    args.sheet.resumePaint();
            //}
        });
    },
    onClipboardPasting: function(sender, args) {
        var me = repositoryGljObj;
        if (args.cellRange.colCount != me.setting.header.length) {
            args.cancel = true;
        }
    },
    onClipboardPasted: function(e, info) {
        var me = repositoryGljObj;
        var updateArr = [], addArr = [];
        var items = sheetCommonObj.analyzePasteData(me.setting, info);
        var hasCacheItem = false;
        for (var i = 0; i < items.length; i++) {
            for (var j = 0; j < me.gljList.length; j++) {
                if (me.gljList[j][me.setting.header[0].dataCode] == items[i][me.setting.header[0].dataCode]) {
                    hasCacheItem = true;
                    items[i]["ID"] = me.gljList[j]["ID"];
                    break;
                }
            }
            if (!hasCacheItem) {
                addArr.push(items[i]);
            } else {
                updateArr.push(items[i]);
            }
        }
        if (updateArr.length > 0 || addArr.length > 0) {
            $.ajax({
                type:"POST",
                url:"api/mixUpdateGljItems",
                data:{"repositoryId": me.currentRepositoryId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr)},
                dataType:"json",
                cache:false,
                timeout:5000,
                success:function(result){
                    if (result.err) {
                        alert(err);
                        me.getRationItems(me.currentRepositoryId);
                    } else {
                        if (addArr.length > 0) {
                            me.gljList = me.gljList.concat(addArr);
                        }
                        for (var i = 0; i < updateArr.length; i++) {
                            for (var j = 0; j < me.gljList.length; j++) {
                                if (me.gljList[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
                                    me.gljList[j] = updateArr[i];
                                }
                            }
                        }
                        me.showGljItems(me.gljList, me.gljAllTypeId);
                    }
                },
                error:function(){
                }
            })
        }
    },
    onClick: function(event,treeId,treeNode) {
        var me = repositoryGljObj,
            gljTypeId = treeNode.ID;
        repositoryGljObj.gljCurTypeId = treeNode.ID;
        repositoryGljObj.showGljItems(repositoryGljObj.gljList, gljTypeId);
    }
}