|
楼主 |
发表于 2022-9-24 12:10:19
|
显示全部楼层
本帖最后由 win3394393 于 2022-9-24 12:11 编辑
//新业务股权投资统计导出
public static Table XYWGQTZExport(String fQC,String fXMMC,String fBALX,String fTZZRDW,String ognID){
String sqlcity = "SELECT fLXQTDW,fXMBH,fXMMC,fBALX,fXMLX,fSSZT,fXMSJTX,fQMCYRY,fXMDZJHTZE,fXMDZZJLYHJ,fXMDZZJLYZYZJ,fXMDZZJLYDK,fXMDZZJLYXMHK,fXMDZZJLYQTZJ,fNDTZEYS,fNDTZHKYS,fBYWCTZE,fZNCLJWCTZE,fZXMKSLJWCTZE," +
"fZNCLJDTZE,fZXMKSLJDTZE,fSNMSYFTZK,fBQMSYFTZK,fZNCLJZJLYHJ,fZNCLJZJLYSNMJYZJ,fZNCLJZJLYZYZJ,fZNCLJZJLYDK,fZNCLJZJLYXMHK,fZNCLJZJLYQTZJ,fZXMKSLJZJLYHJ,fZXMKSLJZJLYZYZJ,fZXMKSLJZJLYDK,fZXMKSLJZJLYXMHK," +
"fZXMKSLJZJLYQTZJ,fDKHTE,fDKBNFKE,fDKZXMKSLJFKE,fDKBNYHBFXE,fDKBNYHBFXEBJ,fDKZNCLJYHBFXE,fDKZNCLJYHBFXEBJ,fDKZHTQSYHBFXE,fDKZHTQSYHBFXEBJ,fDKZNCLJHBFXE,fDKZNCLJHBFXEBJ,fDKZHTQSHBFXE,fDKZHTQSHBFXEBJ," +
"fBNSXHKE,fZXMKSLJSXHK,fXMSXSHLRBNLJSXSHJLR,fXMSXSHLRZXMKSLJSXSHJLR,fQMYJXYSHJLR,fQMYJXYCBJLRL,fQMYJXYNZYZJCWNBSYL,fBZ FROM (SELECT * FROM zjtz_xxywtzxmydtjb ORDER BY version DESC) a LEFT JOIN " +
"zjtz_ydtjb b ON b.fID = a.fTJBID WHERE b.fTJQC = '"+fQC+"' and fXMMC like '%"+fXMMC+"%' and fBALX like '%"+fBALX+"%' and fLXQTDW like '%"+fTZZRDW+"%' and fLXQTDWFID like '%"+ognID+"%' GROUP BY fTJBID ";
System.out.println(sqlcity);
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.MYSQL.name(), sqlcity);
return SQL.select(sqlMap, null, "/im/rd/data");
} |
|