/**
* 查询所有
*
* @param
*/
public List<AssetManagementModel> queryAll() {
return GreenDaoManager.getInstance().getAssetManagementModelDao().loadAll();
}
/**
* 根据Name精确查询
*
* @param
*/
public List<AssetManagementModel> queryByName(String Name) {
return GreenDaoManager.getInstance().getAssetManagementModelDao()
.queryBuilder()
.where(AssetManagementModelDao.Properties.Asset_name.eq(Name))
.list();
}
/**
* 根据输入内容likeassetName 模糊查询 复合条件的name 和code两个字段
*
* @param
*/
public List<AssetManagementModel> queryLikeNameOrId(String likeassetName) {
return GreenDaoManager.getInstance().getAssetManagementModelDao()
.queryBuilder()
.whereOr(AssetManagementModelDao.Properties.Asset_code .like(likeassetName+"%"),AssetManagementModelDao.Properties.Asset_name .like(likeassetName+"%"))
.list();
}
public class GreenDaoManager {
private final String TAG = "GreenDaoManager";
private final String DB_NAME = "asset.db" ;
private DaoMaster mDaoMaster;
private DaoSession mDaoSession;
private static GreenDaoManager mInstance; //单例
private GreenDaoManager() {
if (mInstance == null) {
MigrationHelper.DEBUG = true; //如果你想查看日志信息,请将DEBUG设置为true
MySQLiteOpenHelper daoHelper = new MySQLiteOpenHelper(App.getInstance(), DB_NAME, null);
SQLiteDatabase database = daoHelper.getWritableDatabase();
mDaoMaster = new DaoMaster(database);
mDaoSession = mDaoMaster.newSession();
}
}
public static GreenDaoManager getInstance() {
if (mInstance == null) {
synchronized (GreenDaoManager.class) {//保证异步处理安全操作
if (mInstance == null) {
mInstance = new GreenDaoManager();
}
}
}
return mInstance;
}
public DaoMaster getMaster() {
return mDaoMaster;
}
public DaoSession getSession() {
return mDaoSession;
}
public DaoSession getNewSession() {
mDaoSession = mDaoMaster.newSession();
return mDaoSession;
}
public AssetManagementModelDao getAssetManagementModelDao(){
return mDaoSession.getAssetManagementModelDao();
}
public AssetHomeModelDao getAssetHomeModelDao(){
return mDaoSession.getAssetHomeModelDao();
}
}