From 981107bb993776ed20dfa2173948b8eae6ae989b Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期日, 13 七月 2025 13:52:59 +0800
Subject: [PATCH] 版本升级

---
 src/main/java/com/product/mobile/app/service/AppAdminService.java |   11 ++++++++---
 1 files changed, 8 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/product/mobile/app/service/AppAdminService.java b/src/main/java/com/product/mobile/app/service/AppAdminService.java
index 74c3a46..1f004e1 100644
--- a/src/main/java/com/product/mobile/app/service/AppAdminService.java
+++ b/src/main/java/com/product/mobile/app/service/AppAdminService.java
@@ -29,9 +29,14 @@
      * @throws BaseException
      */
     public FieldSetEntity checkVersion(String version) throws BaseException{
-    	String filter="version>?";
-    	DataTableEntity dt =baseDao.listTable(MobileCoreConst.TABLE_APP_MANAGER, filter, new String[] {version},"version");
-    	
+    	String s[]=version.split("\\.");
+    	String sql="select * from (\r\n"
+    			+ "SELECT *,\r\n"
+    			+ "SUBSTRING_INDEX(version,'.', 1) a,\r\n"
+    			+ "SUBSTRING_INDEX(SUBSTRING_INDEX(version,'.', 2),'.', -1) b,\r\n"
+    			+ "SUBSTRING_INDEX(version,'.', -1) c\r\n"
+    			+ "FROM product_sys_app_version ) b where a>? or b>? or c>? order by a desc ,b desc ,c desc";
+    	DataTableEntity dt =baseDao.listTable(sql, s);		    	
     	FieldSetEntity fs=new FieldSetEntity();
     	fs.setTableName(MobileCoreConst.TABLE_APP_MANAGER);
     	if(DataTableEntity.isEmpty(dt)) {

--
Gitblit v1.9.2