/***************************
* Get JSON by SQL
*
* var tableName = "meta_guest_info";
* var fields = " DISTINCT META_TWO_CABIN_SERVICES_TICKET_LINK_ID as mainPKid";
* var where = "and (META_MEMBERSHIP_CARD_TYPE = '"+categoryID+"' OR META_JIESUANDANHAO = '"+jiesuandanhao+"')";
* var param = "operFlag=getQueryDataJSON&tableName="+tableName+"&fields="+fields+"&where="+where;
**************************/
function getJSONBySQL(param){
param = encodeURI(param);
var recordAry = null;
$.ajax({
type:'post',
url:'/customize/control/DBSevices?'+param,
async:false, // 异步同步设置
dataType:'json', // 返回数据类型
contentType: "application/x-www-form-urlencoded; charset=utf-8",
success:function(returnValue){
// Set search return data array
recordAry = eval(returnValue); // 放回值转换
},
error:function(XMLHttpRequest, textStatus, errorThrown){
var errorInfo = "status:"+XMLHttpRequest.status;
errorInfo+= ",readyState:"+XMLHttpRequest.readyState;
Ext.Msg.alert("提示","槽糕!请求服务器端发生异常,请重新进行当前操作!{getJSONBySQL>error![errorInfo=<span style='color:red'>"+errorInfo+",<br>"+param+"</span>]}");
}
})
return recordAry;
}
转载于:https://my.oschina.net/moks/blog/208780