- String sql = " INSERT INTO BO_APPROVEINFO_VER "
- + " ( BO_APPROVEINFO_VER_ID,"
- + " VER_APPID,"
- + " APPID,"
- + " FX_APPROVERESULT,"
- + " FX_ROLENAME,"
- + " FX_APPROVEDATE,"
- + " FX_APPROVEPERSON,"
- + " FX_APPROVEIDEA,"
- + " FX_ROLEAPPROVEORDER,"
- + " FX_WORKNAME,"
- + " FX_TRATAG,"
- + " BO_APPROVEINFO_ID,"
- + " CUR_TASKID,"
- + " NEXT_TASKID,"
- + " FX_APPROVEPERSONID,"
- + " PARENT_APPID )"
- + " (SELECT SYS_GUID(),"
- + " NULL VER_APPID,"
- + " APPID,"
- + " A.FX_APPROVERESULT,"
- + " A.FX_ROLENAME,"
- + " A.FX_APPROVEDATE,"
- + " A.FX_APPROVEPERSON,"
- + " A.FX_APPROVEIDEA,"
- + " A.FX_ROLEAPPROVEORDER,"
- + " A.FX_WORKNAME,"
- + " A.FX_TRATAG,"
- + " A.BO_APPROVEINFO_ID,"
- + " A.CUR_TASKID,"
- + " A.NEXT_TASKID,"
- + " A.FX_APPROVEPERSONID,"
- + " A.PARENT_APPID "
- + " FROM (SELECT *"
- + " FROM BO_APPROVEINFO T"
- + " WHERE "
- + " T.APPID = '" + investPlanId //取该年度投资Id的所有审批信息
- + "' ) A)";
本文转自danni505 51CTO博客,原文链接:http://blog.51cto.com/danni505/404150,如需转载请自行联系原作者