From 54fe125d1165783cc5bc401124fccf203dfe5814 Mon Sep 17 00:00:00 2001
From: 严智鑫 <test>
Date: 星期五, 22 十二月 2023 16:29:20 +0800
Subject: [PATCH] 每周更新

---
 河北望美项目/MES_11/src/main/webapp/WEB-INF/views/mes/data/diaozhuang_mangage.jsp |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git "a/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/webapp/WEB-INF/views/mes/data/diaozhuang_mangage.jsp" "b/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/webapp/WEB-INF/views/mes/data/diaozhuang_mangage.jsp"
index df9eb28..56cbefc 100644
--- "a/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/webapp/WEB-INF/views/mes/data/diaozhuang_mangage.jsp"
+++ "b/\346\262\263\345\214\227\346\234\233\347\276\216\351\241\271\347\233\256/MES_11/src/main/webapp/WEB-INF/views/mes/data/diaozhuang_mangage.jsp"
@@ -55,7 +55,7 @@
 					//qSQL = "update gmms_drop_frame_4 set rank = ?,sign=1  where Id = ?";
 					qSQL = "update gmms_drop_frame_5 as dr left join gmms_drop_frame_5 as dr2 on dr.id="+Id+" and dr2.id="+liaoJiaId
 							+" set dr.rank=dr2.rank,dr.sign=0,dr2.sign=10"
-							+" where dr.id="+Id+" and dr2.id="+liaoJiaId+" and dr.rank is null";
+							+" where dr.id="+Id+" and dr2.id="+liaoJiaId+" and dr.rank is null and dr.sign=0 and dr2.sign=0";
 					sn.createSql(qSQL);
 					int s = sn.update();					
 					out.print(s);

--
Gitblit v1.8.0