ConstructionCost/web/maintain/ration_repository/js/coe.js

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

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

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

        $("#btnAddRow").click(function(){
                coeList.addMainRow();
        });

        var libID = getQueryString("repository");
        var libName = storageUtil.getSessionCache("RationGrp","repositoryID_" + libID);
        if (libName) {
            var html = $("#rationname")[0].outerHTML;
            html = html.replace("XXX定额库", libName);
            $("#rationname")[0].outerHTML = html;
        };

        coeList.show();
    }
};

var coeList = {
    mainSpread: null,
    detailSpread: null,
    datas: [],
    libID: Number,
    tempID: -999999,       // 本地新增一条数据给的默认ID,用作标记，服务端返回新ID后替换该ID

    colDefMain: [
        {name: "ID", displayName: "编号", size: 100, hAlign: "center"},
        {name: "name", displayName: "名称", size: 280},
        {name: "content", displayName: "内容", size: 250}
    ],
    colDefContent: [
        {name: "coeType", displayName: "类型", size: 100, hAlign: "center"},
        {name: "gljID", displayName: "工料机ID", size: 100, hAlign: "center",formatter: "00000000"},
        {name: "operator", displayName: "操作符", size: 60, hAlign: "center"},
        {name: "amount", displayName: "数量", size: 80, hAlign: "right"}
    ],

    show: function (){
        var me = this;
        me.libID = getQueryString("repository");
        me.getDatas();
        me.mainSpread = sheetObj.create($('#mainSpread')[0], me.colDefMain, me.datas);
        me.detailSpread = sheetObj.create($('#contentSpread')[0], me.colDefContent, me.datas[0].coes);

        var coeType = new GC.Spread.Sheets.CellTypes.ComboBox();
        coeType.items(["单个","全部","人工类","材料类","机械类"]);
        me.detailSpread.getSheet(0).getRange(-1, 0, -1, 1).cellType(coeType);

        var operType = new GC.Spread.Sheets.CellTypes.ComboBox();
        operType.items(["+","-","*","/","="]);
        me.detailSpread.getSheet(0).getRange(-1, 2, -1, 1).cellType(operType);

        me.detailSpread.options.showVerticalScrollbar = false;

        me.mainSpread.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onMainEnterCell);
        me.mainSpread.getSheet(0).bind(GC.Spread.Sheets.Events.CellChanged, me.onMainCellChanged);
        me.mainSpread.getSheet(0).bind(GC.Spread.Sheets.Events.RowChanged, me.onMainRowChanged);

        me.detailSpread.getSheet(0).bind(GC.Spread.Sheets.Events.CellChanged, me.onDetailCellChanged);
    },

    addMainRow: function () {
        var me = this;
        var sheet = me.mainSpread.getSheet(0);
        var sels = sheet.getSelections();
        var row = sels[0].row;
        if (sels.length > 0) {
            sheet.addRows(row, 1);
        };
    },

    getDatas: function () {
        var me = this;

        $.ajax({
            type:"POST",
            url:"/rationRepository/api/getCoeList",
            data:{"libID": me.libID},
            dataType:"json",
            cache:false,
            async: false,
            timeout:20000,
            success: function (result) {
                if (result.data) {
                    me.datas = result.data;
                };
            },
            error: function (result) {
                alert('内部程序错误！');
            }
        })
    },

    getLibID: function(libName){
        var me = this;
        $.ajax({
            type:"POST",
            url:"/rationRepository/api/getLibIDByName",
            data:{"libName": libName},
            dataType:"json",
            cache:false,
            async: false,
            timeout:20000,
            success: function (result) {
                if (result.data) {
                    me.libID = result.data;
                }
            },
            error: function (result) {
                alert('内部程序错误！');
            }
        })
    },

    onMainEnterCell: function(sender, args) {
        var me = coeList;
        var row = args.sheet.getActiveRowIndex();
        me.detailSpread.suspendPaint();
        me.detailSpread.getSheet(0).setDataSource(me.datas[row].coes);
        me.detailSpread.resumePaint();
    },

    onMainCellChanged: function(sender, args) {
        alert('onMainCellChanged');
        var me = coeList;
        var row = args.sheet.getActiveRowIndex();
        var obj = me.datas[row];
        me.save([],[],[obj]);
    },

    onMainRowChanged: function (event, data) {
        var me = coeList;
        var row = data.row, count = data.count, propName = data.propertyName;
        if (row === undefined || count === undefined || propName === undefined) {
            return;
        };

        if (propName === "addRows") {
            var sheet = me.mainSpread.getSheet(0);
            var obj = {};
            obj.libID = me.libID;
            obj.ID = me.tempID;
            obj.name = "新建名称";
            obj.content = "新建内容";
            obj.coes = [{coeType:"全部", operator:"*"}];
            me.datas[row] = obj;

            me.detailSpread.suspendPaint();
            me.detailSpread.getSheet(0).setDataSource(me.datas[row].coes);
            me.detailSpread.resumePaint();

            me.save([obj],[],[]);
        }
        else if (propName === "deleteRows") {
            //me.save([],[obj],[]);
        };
    },

    onDetailCellChanged: function(sender, args) {
        //alert('onDetailCellChanged');
        var me = coeList;
        var row = args.sheet.getActiveRowIndex();
        var mainRow = me.mainSpread.getSheet(0).getActiveRowIndex();
        var curType = args.sheet.getValue(row,0);
        if (!(curType == '单个')){
            me.detailSpread.suspendEvent();
            args.sheet.setValue(row, 1, null);
            me.detailSpread.resumeEvent();
            //args.sheet.getCell(row, 1).backColor("red");
        }
        else{
            //args.sheet.getCell(row, 1).backColor("Blue");
        };
        var obj = me.datas[mainRow];
        me.save([],[],[obj]);
    },

    save: function(addArr, deleteArr, updateArr) {
        var me = coeList;
        //alert('触发了save');
        $.ajax({
            type:"POST",
            url:"api/saveCoeList",
            data: {"data": JSON.stringify({"addArr": addArr, "deleteArr": deleteArr, "updateArr": updateArr})},
            dataType:"json",
            cache:false,
            timeout:5000,
            success:function(result){
                if (result.error) {
                    alert(result.message);
                } else {
                    // 成功。更新从后台返回的新ID。
                    if (addArr.length > 0){
                        for (var i = 0; i < me.datas.length; i++) {
                            if (me.datas[i].ID == me.tempID){
                                me.datas[i].ID = result.data;
                                me.mainSpread.getSheet(0).repaint();
                                break;
                            }
                        }
                    };
                }
            },
            error:function(err){
                alert("内部程序错误！");
            }
        })
    }
};

pageObj.initPage();