/** 得到缓存的记录总数 */
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;
}
/** 插入缓存 */
public boolean InsertLocal(String pdnum, String trkno, String amact, String userid) {
boolean result = false;
dbHelper = ClientDBHelper.getInstance(context);
String pdtime = getDateByFormat();
ContentValues cv = new ContentValues();
cv.put("trkno", trkno);
cv.put("pdnum", pdnum);
cv.put("amcat", amact);
cv.put("pdtime", pdtime);
cv.put("whodo", userid);
if (dbHelper.doInsert(cv, trkno) != -1) {
result = true;
}
dbHelper.close();
return result;
}
/**
* 根据用户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;
}
