我找到了一个Ajax搜索模板,我还有一个来自MSSQL的Javascript JSON变量。如何在这个Ajax搜索模板中添加Javascript中的JSON?Monteur是带有JSON数据的变量。
ajax:
$(document).ready(function () {
$.ajaxSetup({ cache: false });
$('#search').keyup(function () {
$('#result').html('');
$('#state').val('');
var searchField = $('#search').val();
var expression = new RegExp(searchField, "i");
$.getJSON('scripts/data.json', function (data) {
$.each(data, function (key, value) {
if (value.name.search(expression) != -1 || value.location.search(expression) != -1) {
$('#result').append('<li class="list-group-item link-class">' + value.name + ' | <span class="text-muted">' + value.location + '</span></li>');
}
});
});
});
$('#result').on('click', 'li', function () {
var click_text = $(this).text().split('|');
$('#search').val($.trim(click_text[0]));
$("#result").html('');
});
});
javascript:
SqlServer.executeQuery("SELECT PERSONALNUMMER, (NAME+' '+ VORNAME) AS NAME1 FROM OPENQUERY(SPHINX, 'select personalnummer, name, vorname from firma.personal where austrittsdatum is null') AS derivedtbl_1", function (event) {
Monteur = event;
}, function (error) {
alert("Error : " + JSON.stringify(error));
});