/** 得到缓存的记录总数 */ public String LocalNowTemp(String pdnum, String userid) { dbHelper = ClientDBHelper.getInstance(context); String count = ""; Cursor cursor = dbHelper.fetchDataAll( "select count(*) from YMPMP where pdnum='" + pdnum + "' and whodo='" + userid + "'"); if (cursor != null) { if (cursor.moveToFirst()) { count = cursor.getString(0); } } cursor.close(); dbHelper.close(); return count; }
/** * 根据用户id和盘点时间返回盘点编号 * * @param userid * @return */ public String pdnum(String userid) { dbHelper = ClientDBHelper.getInstance(context); String pdnum = ""; if (userid != null) { String pdtime = getDateByFormat(); Cursor cursor = dbHelper.fetchDataAll( "select pdnum from ympmp where whodo='" + userid + "' and pdtime='" + pdtime + "'"); if (cursor != null) { if (cursor.moveToFirst()) { pdnum = cursor.getString(0); } } cursor.close(); dbHelper.close(); } return pdnum; }