From 425675051e544cf29b2132615cfbf7a93dc5e51f Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 六月 2022 15:50:59 +0800
Subject: [PATCH] fix(dm): MySQL=》DMSQL
---
src/cn/ksource/web/facade/fileManage/DocFacadeImpl.java | 63 +++++++++++++++----------------
1 files changed, 30 insertions(+), 33 deletions(-)
diff --git a/src/cn/ksource/web/facade/fileManage/DocFacadeImpl.java b/src/cn/ksource/web/facade/fileManage/DocFacadeImpl.java
index 4013ced..8495826 100644
--- a/src/cn/ksource/web/facade/fileManage/DocFacadeImpl.java
+++ b/src/cn/ksource/web/facade/fileManage/DocFacadeImpl.java
@@ -1,16 +1,5 @@
package cn.ksource.web.facade.fileManage;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-
-import javax.servlet.http.HttpServletRequest;
-
-import org.apache.commons.lang.StringUtils;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
@@ -19,14 +8,22 @@
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.TreeNode;
import cn.ksource.web.Constants;
-import cn.ksource.web.service.file.FileService;
+import org.apache.commons.lang.StringUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
@Service("docFacade")
@SuppressWarnings("unchecked")
public class DocFacadeImpl implements DocFacade {
- @Autowired
+ @Autowired
BaseDao baseDao;
-
+
@Override
public List queryMyfileList(HttpServletRequest request) {
StringBuilder sql=new StringBuilder("SELECT ID,FOLDER_NAME AS NAME,FOLDER_PATH AS PATH,0 AS FILE_SIZE,0 AS FILE_FORMAT,ORDERNUM,P_ID,CREATE_TIME,1 AS FILE_TYPE FROM GG_FOLDERS A" +
@@ -49,15 +46,15 @@
@Override
public int queryfileCount(Map<String,String> params) {
- StringBuilder sql=new StringBuilder("SELECT COUNT(C.ID) FROM(SELECT ID,FOLDER_NAME AS NAME FROM GG_FOLDERS A WHERE 1=1");
+ StringBuilder sql=new StringBuilder("SELECT COUNT(C.ID) FROM(SELECT ID FROM GG_FOLDERS A WHERE 1=1");
String pId=params.get("pId");
if(StringUtil.isEmpty(pId)){
sql.append(" AND A.P_ID IS NULL");
}else{
sql.append(" AND A.P_ID=:pId");
}
- sql.append(" UNION SELECT ID,FILE_NAME AS NAME FROM GG_FILES B WHERE B.DEL_FLAG=1 AND B.AUDIT_STATE="+Constants.FILE_STATE_SHTG);
-
+ sql.append(" UNION SELECT ID FROM GG_FILES B WHERE B.DEL_FLAG=1 AND B.AUDIT_STATE="+Constants.FILE_STATE_SHTG);
+
if(StringUtil.isEmpty(pId)){
sql.append(" AND(B.FOLDER_ID IS NULL OR B.FOLDER_ID = '0' )");
}else{
@@ -74,8 +71,8 @@
@Override
public PageInfo queryfileData(PageInfo pageInfo, Map<String,String> params) {
- StringBuilder sql=new StringBuilder("SELECT * FROM (SELECT ID,FOLDER_NAME AS NAME,FOLDER_PATH AS PATH,0 AS FILE_SIZE,0 AS FILE_FORMAT,ORDERNUM,P_ID,CREATE_TIME,1 AS FILE_TYPE,TYPE,0 AS BUSINESSTYPE,0 AS ORDER_CODE,0 AS FLOWID,0 AS BUSINESS_ID FROM GG_FOLDERS A WHERE 1=1");
-
+ StringBuilder sql=new StringBuilder("SELECT * FROM (SELECT ID,FOLDER_NAME AS NAME,FOLDER_PATH AS PATH,'0' AS FILE_SIZE,'0' AS FILE_FORMAT,ORDERNUM,P_ID,CREATE_TIME,1 AS FILE_TYPE,TYPE,0 AS BUSINESSTYPE,'0' AS ORDER_CODE,'0' AS FLOWID,'0' AS BUSINESS_ID FROM GG_FOLDERS A WHERE 1=1");
+
String pId=params.get("pId");
if(StringUtil.isEmpty(pId)){
sql.append(" AND A.P_ID IS NULL");
@@ -103,7 +100,7 @@
}else {
sql.append(" ORDER BY C.TYPE ASC,C.FILE_TYPE ");
}
-
+
}
else if(!StringUtil.isEmpty(orderType)&&"2".equals(orderType)){
if("1".equals(orderWay)){
@@ -111,7 +108,7 @@
}else {
sql.append(" ORDER BY CAST(C.FILE_SIZE as SIGNED) ");
}
-
+
}
else if(!StringUtil.isEmpty(orderType)&&"3".equals(orderType)){
if("1".equals(orderWay)){
@@ -119,12 +116,12 @@
}else {
sql.append(" ORDER BY C.CREATE_TIME ");
}
-
+
}
else{
sql.append(" ORDER BY C.TYPE ASC,C.FILE_TYPE,C.FILE_FORMAT,C.CREATE_TIME DESC");
}
-
+
PageInfo info=baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
List<Map> list= info.getDatas();
for(Map map :list){
@@ -187,7 +184,7 @@
sqlBuilder.append("UPDATE GG_FILES SET FILE_NAME =:newName WHERE ID=:id");
}
baseDao.execute(sqlBuilder.toString(), params);
-
+
}
@Override
@@ -214,7 +211,7 @@
paramMap.put("pid", pid);
}
sql.append(" ORDER BY CREATE_TIME");
-
+
List<Map> categoryList = baseDao.queryForList(sql.toString(), paramMap);
for (Map map : categoryList) {
TreeNode yjTree = new TreeNode(map.get("ID").toString(),map.get("FOLDER_NAME").toString());
@@ -255,7 +252,7 @@
paramMap.put("businessId", businessId);
paramMap.put("createTime", DateUtil.getCurrentDate14());
baseDao.execute(saveSql, paramMap);
-
+
}
@Override
@@ -279,8 +276,8 @@
break;
}
}
-
-
+
+
return list;
}
@@ -317,7 +314,7 @@
}else {
sqlBuilder.append(" ORDER BY A.ORDERNUM ");
}
-
+
}
else if(!StringUtil.isEmpty(orderType)&&"2".equals(orderType)){
if("1".equals(orderWay)){
@@ -325,7 +322,7 @@
}else {
sqlBuilder.append(" ORDER BY CAST(A.FILE_SIZE as SIGNED) ");
}
-
+
}
else if(!StringUtil.isEmpty(orderType)&&"3".equals(orderType)){
if("1".equals(orderWay)){
@@ -333,7 +330,7 @@
}else {
sqlBuilder.append(" ORDER BY A.CREATE_TIME ");
}
-
+
}
else{
sqlBuilder.append(" ORDER BY A.CREATE_TIME DESC");
@@ -420,7 +417,7 @@
map.put("FOLDER_NAME", f_name);
}
}
-
+
return map;
}
@@ -503,6 +500,6 @@
public void docheckFile(Map<String, String> params) {
String sql="UPDATE GG_FILES SET AUDIT_STATE=:flag WHERE ID=:id";
baseDao.execute(sql, params);
-
+
}
}
--
Gitblit v1.9.1