public ArrayList<Object> getOrderInvoiceHeaders(String query) {
OutOrderOrInvoiceHeaderDO headerDO = null;
ArrayList<Object> arrayList = null;
try {
arrayList = new ArrayList<Object>();
headerDO = new OutOrderOrInvoiceHeaderDO();
Global.dbObj.openDataBase();
Cursor cursor = Global.dbObj.execQuery(query);
if (cursor != null) {
while (cursor.moveToNext()) {
headerDO.docNumber = (String.valueOf(cursor
.getString(cursor.getColumnIndex("DocNumber"))));
headerDO.customerNumber = (String.valueOf(cursor
.getInt(cursor.getColumnIndex("CustomerNumber"))));
headerDO.grossSales = (String.valueOf(cursor.getInt(cursor
.getColumnIndex("GrossSales"))));
headerDO.totalTaxes = (String.valueOf(cursor.getInt(cursor
.getColumnIndex("TotalTaxes"))));
headerDO.netAmount = (String.valueOf(cursor.getInt(cursor
.getColumnIndex("NetAmount"))));
headerDO.routeNumber = (String.valueOf(cursor
.getString(cursor.getColumnIndex("RouteNumber"))));
headerDO.employeeNumber = (String
.valueOf(cursor.getString(cursor
.getColumnIndex("EmployeeNumber"))));
}
}
cursor.close();
System.out.println(arrayList.size());
} catch (Exception e) {
e.printStackTrace();
} finally {
Global.dbObj.close();
}
return arrayList;
}