|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
应该当流程结束的时候执行 sql 但是没进去。请问老师我哪里弄错了?请指导一下谢谢
import java.util.HashMap;
import com.justep.system.data.DatabaseProduct;
import com.justep.system.data.SQL;
import com.justep.system.process.ProcessUtils;
public class YeWHTJSProcess {
public static void yeWHTJSProcessBeforeFinish() {
String key = ProcessUtils.getProcessData1();
String sql = "update tYeWHT SET tYeWHT.tfSHenJJE= tHeTSJ.tfSHenJJE FROM tYeWHT join tHeTSJ ON tYeWHT.fID =THeTSJ.tfYeWHTID where THeTSJ.fID='"+key+"'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(DatabaseProduct.MSSQL.name(),sql);
SQL.executeUpdate(sqlMap, null, "/ICT/HeTGL/data");
String sqlj = "update tYeWHT set tYeWHT.fBizStateName = '编辑完成' where tYeWHT.fID='"+key+"'";
sqlMap.put(DatabaseProduct.MSSQL.name(),sqlj);
SQL.executeUpdate(sqlMap, null, "/ICT/HeTGL/data");
}
public static void yeWHTJSProcessAfterAbort() {
String key = ProcessUtils.getProcessData1();
String sql = "delete tHeTJS where tHeTJS.fID='"+key+"'";
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(DatabaseProduct.MSSQL.name(),sql);
SQL.executeUpdate(sqlMap, null, "/ICT/HeTGL/data");
}
}
|
|