From a3bc6aa4fa3bad787c9fc366d6904f60265eec3b Mon Sep 17 00:00:00 2001 From: lmw <125975490@qq.com> Date: 星期三, 04 九月 2024 15:44:14 +0800 Subject: [PATCH] 登录、用户取餐 --- app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java | 37 ++++++++++++++++++++++++++++++++++--- 1 files changed, 34 insertions(+), 3 deletions(-) diff --git a/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java b/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java index bb414a6..92c387d 100644 --- a/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java +++ b/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java @@ -1,7 +1,6 @@ package com.lotaai.canguiayw.sqllitedb; -import com.blankj.utilcode.util.LogUtils; -import com.lotaai.canguiayw.application.ActivityLifecycleApplcation; +import com.lotaai.canguiayw.application.App; import com.lotaai.canguiayw.device.service.CrontrolGridModel; import org.greenrobot.greendao.query.QueryBuilder; @@ -23,7 +22,7 @@ } private DaoSession getDaoSession() { - DaoSession daoSession = ActivityLifecycleApplcation.getInstance().getDaoSession(); + DaoSession daoSession = App.getInstance().getDaoSession(); return daoSession; } @@ -35,6 +34,21 @@ public void insertOrderInfo(Order model) { DaoSession daoSession = getDaoSession(); daoSession.insertOrReplace(model); + } + + public void deleteFromOrderByGridNo(String gridNo){ + DaoSession daoSession = getDaoSession(); + QueryBuilder<Order> qb = daoSession.queryBuilder(Order.class); + QueryBuilder<Order> queryBuilder + = qb.where(OrderDao.Properties.GridNo.eq(gridNo)).orderAsc(OrderDao.Properties.TakeCode); + + List<Order> ordersList = queryBuilder.list(); + if (ordersList!=null && ordersList.size()>0){ + for (int i = 0; i < ordersList.size(); i++){ + Order order = ordersList.get(i); + daoSession.delete(order); + } + } } /** @@ -225,6 +239,23 @@ return gridModels; } + public void updateGridByStr(String gridNo,int state){ + CrontrolGridModel model = new CrontrolGridModel(); + model.ChangeGrid(gridNo); + DaoSession daoSession = getDaoSession(); + QueryBuilder<GridModel> qb = daoSession.queryBuilder(GridModel.class); + QueryBuilder<GridModel> queryBuilder + = qb.where(GridModelDao.Properties.GridNo.eq(model.getGridNo()),GridModelDao.Properties.GuiHao.eq(model.getGuiNo())).orderAsc(GridModelDao.Properties.GuiHao); + List<GridModel> gridModels = queryBuilder.list(); + if (gridModels != null || gridModels.size() > 0) { + for (int i = 0; i < gridModels.size();i++){ + GridModel mm = gridModels.get(i); + mm.setState(state); + daoSession.update(mm); + } + } + } + public GridModel selectFreeGrid(){ DaoSession daoSession = getDaoSession(); QueryBuilder<GridModel> qb = daoSession.queryBuilder(GridModel.class); -- Gitblit v1.7.1