function GetContactHelpdeskCase (ContactCaseId,ContactId)
{
var HelpdeskDefer = $.Deferred();
var db = GetDatabase();
db.transaction(function (tx) {
var statement;
var param;
if(ContactId==0){
if (ContactCaseId == null)
{
// all
statement = GetAllContactHelpdeskCaseSql;
param = [];
}
else
{
// filter by contact
statement = GetContactHelpdeskCaseSql;
param = [ContactCaseId];
}
}
else{
if (ContactCaseId == null)
{
// all
statement = GetAllContactHelpdeskCaseSql;
param = [];
}
else
{
// filter by contact
statement = GetContactHelpdeskCaseByContactIdSql;
param = [ContactId];
}
} tx.executeSql(statement, param, function (tx, results) {
if (results.rows.length <= 0)
{
HelpdeskDefer.resolve(null);
return;
} var list = new Array ();
for (var i = 0; i < results.rows.length; i++){
list[i] = results.rows.item(i);
}
HelpdeskDefer.resolve(list);
}, HelpdeskCaseErrorHandler);
}, HelpdeskCaseErrorHandler);
return HelpdeskDefer.promise();
}表示ContactId==0时没问题。有数据、不等于0的时候也能查出数据
但是在HelpdeskDefer.resolve(list);这一步貌似除了问题、err信息为undefined、为什么?PhoneGap行业数据jqm
{
var HelpdeskDefer = $.Deferred();
var db = GetDatabase();
db.transaction(function (tx) {
var statement;
var param;
if(ContactId==0){
if (ContactCaseId == null)
{
// all
statement = GetAllContactHelpdeskCaseSql;
param = [];
}
else
{
// filter by contact
statement = GetContactHelpdeskCaseSql;
param = [ContactCaseId];
}
}
else{
if (ContactCaseId == null)
{
// all
statement = GetAllContactHelpdeskCaseSql;
param = [];
}
else
{
// filter by contact
statement = GetContactHelpdeskCaseByContactIdSql;
param = [ContactId];
}
} tx.executeSql(statement, param, function (tx, results) {
if (results.rows.length <= 0)
{
HelpdeskDefer.resolve(null);
return;
} var list = new Array ();
for (var i = 0; i < results.rows.length; i++){
list[i] = results.rows.item(i);
}
HelpdeskDefer.resolve(list);
}, HelpdeskCaseErrorHandler);
}, HelpdeskCaseErrorHandler);
return HelpdeskDefer.promise();
}表示ContactId==0时没问题。有数据、不等于0的时候也能查出数据
但是在HelpdeskDefer.resolve(list);这一步貌似除了问题、err信息为undefined、为什么?PhoneGap行业数据jqm
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货