From d5f837a50f9874e4d08d786bfaeaed23dc7fe745 Mon Sep 17 00:00:00 2001
From: 陈力 <chenli@lotaai.com>
Date: 星期三, 14 六月 2023 15:32:44 +0800
Subject: [PATCH] 存餐、取餐、管理员取出
---
app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 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..904058d 100644
--- a/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java
+++ b/app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java
@@ -37,6 +37,21 @@
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 +240,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