package weaver.interfaces.workflow.scm;
import org.apache.commons.httpclient.methods.PostMethod;
import org.apache.commons.lang.StringEscapeUtils;
import org.json.JSONArray;
import org.json.JSONObject;
import weaver.conn.RecordSet;
import weaver.general.BaseBean;
import weaver.general.Util;
import weaver.interfaces.workflow.action.Action;
import weaver.soa.workflow.request.RequestInfo;
import weaver.workflow.request.RequestManager;
import com.weavernorth.util.LogUtil;
import com.weavernorth.util.SignOrderUtil;
/*SCM&OA*/
public class ShippingApplication implements Action{ //必须实现的接口
private static final String targetURL = "其他系统调用地址";
//查询流程主表数据
private RecordSet mainRs = new RecordSet();//对象作用为传入SQL获取相关数据对象
//明细数据
private RecordSet mxRs = new RecordSet();
//更新数据
private RecordSet upRs = new RecordSet();
public String execute(RequestInfo request) {
//继承的方法
//流程表单名称
String tableName = "";
//流程id
String requestID = request.getRequestid();//获取具体表单唯一值requestid
String workflowid = request.getWorkflowid();//获取表单workflowid
int LastNodeid = request.getRequestManager().getLastNodeid();
int currentNodeid = request.getRequestManager().getNodeid();//获取具体审批节点nodeid
//查询流程表单名称
SignOrderUtil sou= new SignOrderUtil();
tableName=sou.getWFTableName(requestID);//获取表单名称 如:formtable_main_521
//查询流程主表数据
String mainInfosql="select * from " + tableName + " where requestid = "+requestID;
mainRs.executeSql(mainInfosql);
mainRs.next();//获取需要的sql返回值
LogUtil.doWriteLog("ShippingApplication==================start mainInfosql"+mainInfosql);
String result = "";
ScmToken scmtoken=new ScmToken();//本示例存在一个token认证,所以有多余代码
String token=scmtoken.GetToken();
try {
BaseBean bb = new BaseBean();//创建对象调用WEB-INF/prop下的配置文件properties
String url=bb.getPropValue("SCM", "url");
LogUtil.doWriteLog(url+"Sh