Easyui 行编辑 只选择年月

Easyui DataGrid行编辑只选择年月
原版地址：https://my.oschina.net/zdway/blog/4930780

$("#dgEquipProData").datagrid({
            url: '后台取数据的地址',
            queryParams:equipProQuery ,
            columns: [[
                {
                    field: 'MonthDate', title: '月份', width: 150, align: 'center', formatter: function (value, row, index) {
                        var monthDate = myformatter(new Date(row.MonthDate));
                        return monthDate;
                    }, editor: { type: 'datebox', options: { required: true } }
                },
                { field: 'CostAmount', title: '当月维保费', width: 150, align: 'right', editor: { type: 'numberbox', options: { required: true, precision: 2 } } },
                { field: 'GrandCostAmount', title: '累计维保费', width: 150, align: 'right' },
                { field: 'PaymentAmount', title: '当月支付(元)', width: 150, align: 'right', editor: { type: 'numberbox', options: { required: true, precision: 2 } } },
                { field: 'GrandPaymentAmount', title: '累计支付(元)', align: 'right', width:150 },
            ]],
            onClickRow: onClickRow,//编辑行
            onEndEdit: onEndEdit,//一定要有个结束编辑
            pagination:false,//去掉分页
        });

selectMonthDate方法

function selectMonthDate(datagridId, dataEditIndex)
{
    //将视图改为年月
    var ndEditor = $('#' + datagridId).datagrid('getEditor', { index: dataEditIndex, field: "MonthDate" });
    if (ndEditor)
    {
        var MonthDateStr = ndEditor.oldHtml;
        $(ndEditor.target).datebox({
            //显示日趋选择对象后再触发弹出月份层的事件，初始化时没有生成月份层
            onShowPanel: function () {
                //触发click事件弹出月份层
                span.trigger('click');
                if (!tds)
                    //延时触发获取月份对象，因为上面的事件触发和对象生成有时间间隔
                    setTimeout(function () {
                        tds = p.find('div.calendar-menu-month-inner td');
                        tds.click(function (e) {
                            //禁止冒泡执行easyui给月份绑定的事件
                            e.stopPropagation();
                            //得到年份
                            var year = /\d{4}/.exec(span.html())[0],
                                //月份
                                //之前是这样的month = parseInt($(this).attr('abbr'), 10) + 1;
                                month = parseInt($(this).attr('abbr'), 10);
                            //隐藏日期对象
                            $(ndEditor.target).datebox('hidePanel').datebox('setValue', year + '-' + month);
                        });
                    }, 0);
            },
            //配置parser，返回选择的日期
            parser: function (s) {
                if (!s) return new Date();
                var arr = s.split('-');
                return new Date(parseInt(arr[0], 10), parseInt(arr[1], 10) - 1, 1);
            },
            //配置formatter，只返回年月 之前是这样的d.getFullYear() + '-' +(d.getMonth());
            formatter: function (d) {
                var currentMonth = (d.getMonth() + 1);
                var currentMonthStr = currentMonth < 10 ? ('0' + currentMonth) : (currentMonth + '');
                return d.getFullYear() + '-' + currentMonthStr;
            }
        });

        //日期选择对象
        var p = $(ndEditor.target).datebox('panel'),
            //日期选择对象中月份
            tds = false,
            //显示月份层的触发控件
            span = p.find('span.calendar-text');
        var old_time = new Date(MonthDateStr);
        if (isVaildDate(old_time)) {
        //这个地方赋值，是为了防止本来有值，然后鼠标移到行编辑上，会自动清掉原来的值
            $(ndEditor.target).datebox("setValue", myformatter(old_time));
        }
    }
}
//判断日期是否有效
function isVaildDate(date) {
    return date instanceof Date && !isNaN(date.getTime());
}

行编辑

var editIndex = undefined;
    function onClickRow(index) {
        if (editIndex != index) {
            if (endEditing()) {
                $('#dgEquipProData').datagrid('selectRow', index)
                        .datagrid('beginEdit', index);
                editIndex = index;
                selectMonthDate("dgEquipProData", editIndex);
            } else {
                $('#dgEquipProData').datagrid('selectRow', editIndex);
            }
        }
    }
    function endEditing() {
        if (editIndex == undefined) { return true }
        if ($('#dgEquipProData').datagrid('validateRow', editIndex)) {
        //这个地方可以加验证，比如我这个地方验证日期不能重复，如果没有验证，直接endEdit,editIndex=undifined,返回true即可。
            var ed = $('#dgEquipProData').datagrid('getEditor', {
                index: editIndex,
                field: 'MonthDate'
            });
            var MonthDateStr = $(ed.target).datebox('getText');
            var curDate = new Date(MonthDateStr);
            var curYear = 0;
            var curMonth = 0;
            //虽然curDate必定不为空，但是个人习惯加一层验证保护
            if (isVaildDate(curDate)) {
                curYear = curDate.getFullYear();
                curMonth = curDate.getMonth() + 1;
            } else { return false; }
            var allRows = $('#dgEquipProData').datagrid('getRows');
            allRows[editIndex].MonthDate = "" + curDate;
            var filters = allRows.filter((item, index, arr) => {
                var itemDate = new Date(item.MonthDate);
                var itemYear = itemDate.getFullYear();
                var itemMonth = itemDate.getMonth() + 1;
                return itemYear == curYear && itemMonth == curMonth;
            });
            if (filters.length > 1) {
                //验证月份是否重复
                $.messager.alert('提示', '月份重复!');
                return false;
            } else {
                $('#dgEquipProData').datagrid('endEdit', editIndex);
                editIndex = undefined;
                return true;
            }
        } else {
            $.messager.alert('提示', '请填写必填项！');
            return false;
        }
    }
    function onEndEdit(index, row) {
    var ed = $(this).datagrid('getEditor', {
            index: index,
            field: 'MonthDate'
        });
        row.MonthDate = $(ed.target).datebox('getText');
        //以下这段代码纯粹是我自己的业务需要，我需要计算累计等等，如果不用计算，到这儿就可以直接结束。
        var allRows = $('#dgEquipProData').datagrid('getRows');
        allRows = allRows.filter((item, index, arr) => {
            return item.Status != -1;
        });
        //找到当前月份之前的费用，计算累计
        var curDate = new Date(row.MonthDate);
        var curMonth = curDate.getMonth() + 1;
        var curYear = curDate.getFullYear();
        row.GrandCostAmount = row.CostAmount;
        for (var i = 0; i < allRows.length; i++) {
            var preIndex = $('#dgEquipProData').datagrid('getRowIndex', allRows[i]);
            var preRow = $('#dgEquipProData').datagrid('getRows')[preIndex];
            var GrandCostAmount = 0;
            var GrandPaymentAmount = 0;
            var preDate = new Date(preRow.MonthDate);
            var preRows = allRows.filter((item, index, arr) => {
                var itemDate = new Date(item.MonthDate);
                return itemDate.getTime() <= preDate.getTime();
            });
            for (var j = 0; j < preRows.length; j++) {
                var preCostAmount = parseFloat(preRows[j].CostAmount);
                preCostAmount = isNaN(preCostAmount) ? 0 : preCostAmount;
                GrandCostAmount = GrandCostAmount + preCostAmount;

                var prePaymentAmount = parseFloat(preRows[j].PaymentAmount);
                prePaymentAmount = isNaN(prePaymentAmount) ? 0 : prePaymentAmount;
                GrandPaymentAmount = GrandPaymentAmount + prePaymentAmount;
            }
            preRow.GrandCostAmount = GrandCostAmount;
            preRow.GrandPaymentAmount = GrandPaymentAmount;
            $('#dgEquipProData').datagrid('refreshRow', preIndex);
        }
    }

插入行
//指定行插入
$('#dgEquipProData').datagrid('insertRow', {
                            index: editIndex,
                            row: {
                                MonthDate: insertRowMonthDate,
                                CostAmount: null,
                                GrandCostAmount: null,
                                PaymentAmount: null,
                                GrandPaymentAmount: null,
                                RestBudgetAmount: null,
                                Status:0,
                            }
                        });
//最后一行插入                        
$('#dgEquipProData').datagrid('appendRow',
                           {
                               MonthDate: insertRowMonthDate,
                               CostAmount: null,
                               GrandCostAmount: null,
                               PaymentAmount: null,
                               GrandPaymentAmount: null,
                               RestBudgetAmount: null,
                               Status: 0,
                           });

//删除行
 $('#dgEquipProData').datagrid('cancelEdit', editIndex)
                          .datagrid('deleteRow', editIndex);
 //获取编辑的行                        
 $('#dgEquipProData').datagrid('getChanges');
//撤销行编辑     
 $('#dgEquipProData').datagrid('rejectChanges');
//保存编辑
 $('#dgEquipProData').datagrid('acceptChanges');