From 928254cf3dca71dbe2c1439c9f17bb0e2f6419fa Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期四, 08 十二月 2022 15:03:57 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/common/service/erp/ErpService.java |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/zy/common/service/erp/ErpService.java b/src/main/java/com/zy/common/service/erp/ErpService.java
index 92f979b..48f3328 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -32,7 +32,7 @@
      * 鑾峰彇GOODS琛�
      */
     public List<Goods> selectGoods(Integer state) {
-        String sql = "select * from Goods where 1=1 where state = '" + state + "'";
+        String sql = "select * from Goods where state = '" + state + "'";
         return erpSqlServer.select(sql, Goods.class);
     }
 
@@ -60,7 +60,7 @@
      * 鑾峰彇Voucher琛�
      */
     public List<Voucher> selectVoucher(Integer state) {
-        String sql = "select * from Voucher where 1=1 where state = '" + state + "'";
+        String sql = "select * from Voucher where state = '" + state + "'";
         return erpSqlServer.select(sql, Voucher.class);
     }
 
@@ -68,7 +68,7 @@
      * 鑾峰彇VoucherDetail琛�
      */
     public List<VoucherDetail> selectVoucherDetail(String VoucherID) {
-        String sql = "select * from VoucherDetail where 1=1 where VoucherID = '" + VoucherID + "'";
+        String sql = "select * from VoucherDetail where VoucherID = '" + VoucherID + "'";
         return erpSqlServer.select(sql, VoucherDetail.class);
     }
 

--
Gitblit v1.9.1