最近去新公司用X5 框架开发系统保存点代码

最新推荐文章于 2024-08-05 19:30:00 发布

ooopopdj

最新推荐文章于 2024-08-05 19:30:00 发布

阅读量672

点赞数

本文链接：https://blog.csdn.net/ooopopdj/article/details/41511215

版权

// 后台的一些代码

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.UnsupportedEncodingException;
import java.math.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;

import org.dom4j.*;

import com.justep.filesystem.FileSystem;
import com.justep.filesystem.FileSystemWrapper;
import com.justep.system.data.*;
import com.justep.system.process.ProcessUtils;

public class YT_ZZJG {

 public static String ygh(String orderID){
 //Map<String,Object> haha = new HashMap<String,Object>();
 //orderID 传过来的是主表ID
 //haha.put("YGH",orderID);
 System.out.print(orderID+"我是主表的ID22222");

 //之前是映射出错尽量用复制 本来是fZBID 我写成了 FZBID
 String ksql ="select a.sName from SA_OPPerson a where a.sLoginName = '"+orderID+"'";
 //Table table = KSQL.select(ksql, null, "/system/ontology", null);
 Table table =KSQL.select(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);

 //System.out.println("我走业务后台22222"+table.getProperties().put(Table.PROP_NAME_ROWID, "ygname"));
 //String ytname = table.iterator().next().getDecimal("").toString();
 //return ytname;
// String ytname =table.
 //用迭代器获取table对象中的某个值
 Iterator<Row> rows = table.iterator();
 Row rs = null;
 if (rows.hasNext()) {
 rs = rows.next();
 // System.out.println("客户姓名>>>>>>>>>:" + rs.getValue("sName"));
 }
 return (String)rs.getValue("sName");

 }

 public static void fzrgh(){

 }

 public static void shenhe(String orderID){
 System.out.print(orderID+"我是ID是什么");
 String ksql ="update YT_LHGS_LR a set a.fDQZT ='已审核', a.fSHRQ=:currentDate(), a.fSHR=:currentPersonName() ,a.fJBZT='未揭榜' where a ='"+orderID+"' ";
 //系统自带封装KSQL方法执行
 KSQL.executeUpdate(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);

 }
/返回多人员工
 public static String ygnumberActiocn(String ygnumber){

 System.out.println("我是什么"+ygnumber);
 ArrayList ygnumberList = new ArrayList();
 String yghaoma = "";
 if(ygnumber.indexOf(",")!=-1){
 String[] number = ygnumber.split(",");
 for(int i=0;i<number.length;i++){
 String ksql = "select a.fFZRXM from YT_ZZJG_WH a where a.fFZRGH ='"+number[i]+"'";
 Table table=KSQL.select(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);
 Iterator<Row> rows = table.iterator();
 Row rs = null;
 if (rows.hasNext()) {
 rs = rows.next();
 // System.out.println("客户姓名>>>>>>>>>:" + rs.getValue("sName"));
 }
 yghaoma+="'"+rs.getValue("fFZRGH")+"',";
 }
 }
 System.out.println("我到后台没有员工号"+yghaoma);

 String ksql = "select a.fFZRXM from YT_ZZJG_WH a where a.fFZRGH in ("+yghaoma+")";
 System.out.println("我到后台没有员工号"+ksql);
 Table table=KSQL.select(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);
 Iterator<Row> rows = table.iterator();
 Row rs = null;
 if (rows.hasNext()) {
 rs = rows.next();
 // System.out.println("客户姓名>>>>>>>>>:" + rs.getValue("sName"));
 }
 return (String)rs.getValue("fFZRXM");

 }
//完工确认
 public static void wangong(String orderID){

 String ksql ="update YT_LHGS_LR a set a.fWGZT ='已完工', a.fQRRQ=:currentDate(), a.fQRR=:currentPersonName() where a ='"+orderID+"' ";
 //系统自带封装KSQL方法执行
 KSQL.executeUpdate(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);

 }

 public static void quxiao(String orderID){
 String ksql ="update YT_LHGS_LR a set a.fWGZT ='未完工', a.fQRRQ=:currentDate(), a.fQRR=:currentPersonName() where a ='"+orderID+"' ";
 //系统自带封装KSQL方法执行
 KSQL.executeUpdate(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);
 }



 public static void jiebang(String orderID,String hjgs,String ygnumber){
 //System.out.println("我进到揭榜里"+orderID+"====="+ygnumber+"====="+hjgs);
 int hjgsnum = Integer.parseInt(hjgs);
 //!=-1 包含
 int renshunum =0;
 if(ygnumber.indexOf(",")!=-1){
 String[] yuangongnum = ygnumber.split(",");
 renshunum=yuangongnum.length;
 }else{
 renshunum=1;
 }
 int drgs = hjgsnum / renshunum ;
 //修改揭榜状态
 String ksql ="update YT_LHGS_LR a set a.fJBZT ='已揭榜', a.fWGZT ='未完工' ,a.fJBRQ=:currentDate(), a.fJBR=:currentPersonName(),a.fJBDRGS="+drgs+" where a ='"+orderID+"' ";
 //系统自带封装KSQL方法执行
 KSQL.executeUpdate(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);

 //return drgs;
 }

 public static String ygName(String orderID){
 // System.out.println("我是什么"+orderID);
 ArrayList ygnumberList = new ArrayList();
 String yghaoma = "";
 if(orderID.indexOf(",")!=-1){
 String[] number = orderID.split(",");
 for(int i=0;i<number.length;i++){
 yghaoma+="'"+number[i]+"',";
 }
 yghaoma=yghaoma.substring(0,yghaoma.length()-1);
 }else if(orderID.indexOf(",")==-1){
 yghaoma= "'"+orderID+"'";
 }
 //System.out.println("我到后台没有员工号"+yghaoma);
 String ygnamestring="";
 String ksql = "select a.fFZRXM from YT_ZZJG_WH a where a.fFZRGH in ("+yghaoma+")";
 // System.out.println("我到后台没有员工号"+ksql);
 Table table=KSQL.select(ksql, null, "/YT_LHGS/YT_ZZJG/data", null);
 Iterator<Row> rows = table.iterator();
 Row rs = null;
 //int i=0;
 while(rows.hasNext()) {
 rs = rows.next();
 // i++;
 // System.out.print("我循环了几次"+i);
 ygnamestring+=rs.getValue("fFZRXM")+",";
 }
 ygnamestring=ygnamestring.substring(0,ygnamestring.length()-1);
 return ygnamestring;
 }

 public static Object downloadFile(String fileName) throws UnsupportedEncodingException{
 System.out.println("我走到后台下载的业务模块");
 FileSystem fileSystem = FileSystemWrapper.instance();
 String real = fileSystem.getRealPath("/YT_LHGS/YT_ZZJG/");
 FileInputStream fis = null;
 String s = java.net.URLDecoder.decode(real + fileName, "UTF-8");
 File file = new File(s);
 if (file.getAbsolutePath().startsWith(file.getAbsolutePath())) {
 try {
 fis = new FileInputStream(file);
 // System.out.println("我走到后台下载的业务模块2222");
 } catch (FileNotFoundException e) {
 throw new RuntimeException("获取文件失败！", e);
 }
 } else
 throw new RuntimeException("获取文件失败，超出获取文件权限范围！");
 return fis;
 }
}