From f4a6d4f0996238f9c85e4986deffe69a1c8256e6 Mon Sep 17 00:00:00 2001
From: lmw <125975490@qq.com>
Date: 星期三, 04 九月 2024 20:47:58 +0800
Subject: [PATCH] 员工流程
---
app/src/main/java/com/lotaai/canguiayw/sqllitedb/SqlliteDbManage.java | 180 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 171 insertions(+), 9 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 8f9d076..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,7 @@
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;
@@ -22,7 +22,7 @@
}
private DaoSession getDaoSession() {
- DaoSession daoSession = ActivityLifecycleApplcation.getInstance().getDaoSession();
+ DaoSession daoSession = App.getInstance().getDaoSession();
return daoSession;
}
@@ -36,6 +36,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);
+ }
+ }
+ }
+
/**
* 添加订单明细信息信息
*
@@ -43,6 +58,19 @@
*/
public void insertOrUpdateOrderDetailInfo(OrderDetail model) {
DaoSession daoSession = getDaoSession();
+ List<OrderDetail> details = selectOrtderDetails(model.getOrderNo());
+ if(details!=null && details.size()>0){
+ for (int i =0; i < details.size(); i++){
+ OrderDetail d = details.get(i);
+ if (d.getItemName().trim().equals(model.getItemName())){
+ model.setId(d.getId());
+ break;
+ }
+ if (d.getItemName().trim().equals("")){
+ daoSession.delete(d);
+ }
+ }
+ }
daoSession.insertOrReplace(model);
}
@@ -54,19 +82,52 @@
* @return
*/
public List<Order> selectOrtdersByState(int state) {
- LogUtils.i("selectOrtdersByState:" + state);
DaoSession daoSession = getDaoSession();
QueryBuilder<Order> qb = daoSession.queryBuilder(Order.class);
-// QueryBuilder<Order> queryBuilder
-// = qb.where(OrderDao.Properties.State.eq(state)).orderAsc(OrderDao.Properties.OrderNo);
-
QueryBuilder<Order> queryBuilder
- = qb.where(OrderDao.Properties.OrderNo.like("GB%")).orderAsc(OrderDao.Properties.OrderNo);
+ = qb.where(OrderDao.Properties.State.eq(state)).orderAsc(OrderDao.Properties.TakeCode);
+
List<Order> ordersList = queryBuilder.list();
if (ordersList == null || ordersList.size() == 0) {
return null;
}
return ordersList;
+ }
+
+ /**
+ * 根据查询订单信息
+ *
+ * @return
+ */
+ public List<Order> selectOrtdersInGui() {
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<Order> qb = daoSession.queryBuilder(Order.class);
+ QueryBuilder<Order> queryBuilder
+ = qb.where(OrderDao.Properties.State.in(0,1)).orderAsc(OrderDao.Properties.TakeCode);
+
+ List<Order> ordersList = queryBuilder.list();
+ if (ordersList == null || ordersList.size() == 0) {
+ return null;
+ }
+ return ordersList;
+ }
+
+ /**
+ * 根据取餐码查询订单信息
+ *
+ * @param takeCode 取餐码
+ * @return
+ */
+ public Order selectOrtderByTakeCode(String takeCode) {
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<Order> qb = daoSession.queryBuilder(Order.class);
+ QueryBuilder<Order> queryBuilder
+ = qb.where(OrderDao.Properties.TakeCode.eq(takeCode)).orderAsc(OrderDao.Properties.OrderNo);
+ List<Order> ordersList = queryBuilder.list();
+ if (ordersList == null || ordersList.size() == 0) {
+ return null;
+ }
+ return ordersList.get(0);
}
/**
@@ -88,6 +149,24 @@
}
/**
+ * 根据订单号查询订单信息
+ *
+ * @param xuhao
+ * @return
+ */
+ public Order selectOrtderByXuhao(String xuhao) {
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<Order> qb = daoSession.queryBuilder(Order.class);
+ QueryBuilder<Order> queryBuilder
+ = qb.where(OrderDao.Properties.XuHao.eq(xuhao)).orderAsc(OrderDao.Properties.OrderNo);
+ List<Order> ordersList = queryBuilder.list();
+ if (ordersList == null || ordersList.size() == 0) {
+ return null;
+ }
+ return ordersList.get(0);
+ }
+
+ /**
* 根据订单号查询订单明细信息
*
* @param orderNo
@@ -97,7 +176,7 @@
DaoSession daoSession = getDaoSession();
QueryBuilder<OrderDetail> qb = daoSession.queryBuilder(OrderDetail.class);
QueryBuilder<OrderDetail> queryBuilder
- = qb.where(OrderDetailDao.Properties.OrderNo.eq(orderNo)).orderAsc(OrderDao.Properties.OrderNo);
+ = qb.where(OrderDetailDao.Properties.OrderNo.eq(orderNo)).orderAsc(OrderDetailDao.Properties.OrderNo);
List<OrderDetail> orderDetailList = queryBuilder.list();
if (orderDetailList == null || orderDetailList.size() == 0) {
return null;
@@ -119,4 +198,87 @@
}
}
+ //新增格子
+ public void addGrid(GridModel model){
+ DaoSession daoSession = getDaoSession();
+ daoSession.insertOrReplace(model);
+ }
+
+ /**
+ * 根据柜子号和格子号查询
+ * @param gui
+ * @param gridNo
+ * @return
+ */
+ public GridModel selectGridByNo(int gui,int gridNo){
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<GridModel> qb = daoSession.queryBuilder(GridModel.class);
+ QueryBuilder<GridModel> queryBuilder
+ = qb.where(GridModelDao.Properties.GuiHao.eq(gui),GridModelDao.Properties.GridNo.eq(gridNo)).orderAsc(GridModelDao.Properties.Id);
+ List<GridModel> gridModels = queryBuilder.list();
+ if (gridModels == null || gridModels.size() == 0) {
+ return null;
+ }
+ return gridModels.get(0);
+ }
+
+ /**
+ * 根据柜子号查询
+ * @param gui
+ * @return
+ */
+ public List<GridModel> selectGridByGui(int gui){
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<GridModel> qb = daoSession.queryBuilder(GridModel.class);
+ QueryBuilder<GridModel> queryBuilder
+ = qb.where(GridModelDao.Properties.GuiHao.eq(gui)).orderAsc(GridModelDao.Properties.Id);
+ List<GridModel> gridModels = queryBuilder.list();
+ if (gridModels == null || gridModels.size() == 0) {
+ return null;
+ }
+ 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);
+ QueryBuilder<GridModel> queryBuilder
+ = qb.where(GridModelDao.Properties.State.eq(0)).orderAsc(GridModelDao.Properties.GuiHao);
+ List<GridModel> gridModels = queryBuilder.list();
+ if (gridModels == null || gridModels.size() == 0) {
+ return null;
+ }
+ return gridModels.get(0);
+ }
+
+ public GridModel selectGridByGridNoStr(String str){
+ CrontrolGridModel mode = new CrontrolGridModel();
+ mode.ChangeGrid(str);
+ DaoSession daoSession = getDaoSession();
+ QueryBuilder<GridModel> qb = daoSession.queryBuilder(GridModel.class);
+ QueryBuilder<GridModel> queryBuilder
+ = qb.where(GridModelDao.Properties.GuiHao.eq(mode.getGuiNo()),GridModelDao.Properties.GridNo.eq(mode.getGridNo())).orderAsc(GridModelDao.Properties.GuiHao);
+ List<GridModel> gridModels = queryBuilder.list();
+ if (gridModels == null || gridModels.size() == 0) {
+ return null;
+ }
+ return gridModels.get(0);
+ }
}
--
Gitblit v1.7.1