泛微Ecology9-明细表数据重复提交验证

该代码功为:泛微E9表单明细表数据提交时,可以进行某列字段的重复校验,如有重复则弹窗拦截阻断。

 

<script>
jQuery(document).ready(function () {
    var checkCustomize = function () {
        var arr = new Array();
        var repeatAry = new Array();
        var detailLineNum = WfForm.getDetailAllRowIndexStr("detail_1");//获取明细表1的所有行标
        detailLineNum = detailLineNum.split(",");
        detailLineNum.map(function (i) {
            //浏览按钮字段取值方式
            var th = WfForm.getBrowserShowName("field7136_" + i); //field580516_是待判断是否重复的明细表字段id
            //单行文本字段取值方式
            // var th = WfForm.getFieldValue("field580515_" + i); 
            //选择框字段获取值方式
            // var th = WfForm.getSelectShowName("field7205_" + i)
            th && arr.push(th);
        })
        var arr = arr.sort();
        for (var i = 0; i < arr.length - 1; i++) {
            if (arr[i] == arr[i + 1]) {
                repeatAry.push(arr[i]);
            }
        }
        var array = [];
        for (var i = 0; i < repeatAry.length; i++) {
            if (array.indexOf(repeatAry[i]) == -1) {
                array.push(repeatAry[i])
            }
        }
        if (array.length != 0) {
            var arrayStr = array.join(",");
            WfForm.showConfirm("图号:<strong><font color='red'>" + arrayStr + "</font></strong>,存在重复值,请重新填写!", function () { });
            return false;
        }
        return true;
    }
    window.checkCustomize = checkCustomize;
    //绑定提交事件,点击提交按钮时触发明细表重复校验判断
    WfForm.registerCheckEvent(WfForm.OPER_SUBMIT, function (callback) {
        if (checkCustomize()) {
            callback();
        }
    });
});
</script>

 

阅读剩余
THE END