SM341700 填写操作工和班组输入码sql语句判定是否有回车换行；result函数 function参数必须要3个event, item, formatted

SM341700 填写操作工和班组输入码sql语句判定是否有回车换行；

sql = sql.replace(/[\n\r]/g, '');

后面的result函数 function参数必须要3个event, item, formatted

.result(function (event, item, formatted) 

/*SM341700 填写操作工和班组*/
$().ready(function () {
    var sql = "select YG.ID as CZGID,YGMC as CZG,zymxid as CZGBC,ZYMX.ZYMC as CZGBCMC from sm_zdb_yg_tb ";
    sql = sql + " YG, SM_JC_ZYMX_TB ZYMX where YG.ZYMXID = ZYMX.ID and zt in (1, 2) and YGMC like '%{0}%'";
    sql = sql.replace(/[\n\r]/g, '');
    autoCompleteRYMC(sql);
    function autoCompleteRYMC(sql) {
        $("td[colname='CZG']").find("input").autocomplete("SQLWREXT.ashx", {
            max: 8, width: 600, autoFill: false, cacheLength: 1, matchSubset: false, /*不启用缓存*/
            matchCase: false, /*不区分大小写*/
            extraParams: {
                StrSql: function () {
                    return sql;
                }
            },
            dataType: "json",
            parse: function (data) {
                return $.map(data, function (row) {
                    return {
                        data: row,
                        value: row.CZG,
                        result: row.CZG
                    };
                }); //给后台交互的数据进行处理
            },
            formatItem: function (item) {
                return item.CZG + "( CZGBCMC:" + item.CZGBCMC + "; CZGID:" + item.CZGID + ";CZGBC:" + item.CZGBC + ")";
            }
        }).result(function (event, item, formatted) {
            log(item.CZGID + "|CZGBC" + item.CZGBC +"|CZGBCMC"+ item.CZGBCMC);
            $(this).parent().siblings("td[colname='CZGID']").children("input[type='text']").val(item.CZGID).trigger("change");
            $(this).parent().siblings("td[colname='CZGBC']").children("input[type='text']").val(item.CZGBC).trigger("change");
            $(this).parent().siblings("td[colname='CZGBCMC']").text(item.CZGBCMC);
        }); /*autocomplete;;*/
    }
});