泛微OA流程节点附加操作-自定义接口动作

最新推荐文章于 2024-05-13 16:04:25 发布

reneeyau

最新推荐文章于 2024-05-13 16:04:25 发布

阅读量3.8k

点赞数 1

分类专栏：泛微文章标签： java

本文链接：https://blog.csdn.net/reneeyau/article/details/127422979

版权

泛微专栏收录该内容

4 篇文章 8 订阅

订阅专栏

需求：申请人提交流程后，检查明细表填写的发票号是否已存在，如已存在，则更新相应表单字段

1、源代码EInvoiceCheck.java

package weaver.interfaces.workflow.action;

import weaver.conn.RecordSet;
import weaver.general.BaseBean;
import weaver.general.Util;
import weaver.interfaces.workflow.action.Action;
import weaver.soa.workflow.request.RequestInfo;


public class EInvoiceCheck extends BaseBean implements Action {

    public String execute(RequestInfo request) {
        try {
            String requestid = Util.null2String(request.getRequestid());//流程请求ID

            String mid="";
            String Invoice = "";

            RecordSet rs = new RecordSet();
            RecordSet brs = new RecordSet();
            RecordSet urs = new RecordSet();
            String sql = "select d.id,d.Invoice from formtable_main_115 m join formtable_main_115_dt2 d on m.id=d.mainid and m.requestid=" + requestid;
            rs.execute(sql);
            while (rs.next()) {
                mid = Util.null2String(rs.getString("id"));
                Invoice = Util.null2String(rs.getString("Invoice")).trim();

                brs.execute("select * from uf_InvoiceInfo where InvoiceNo='"+Invoice+"'");
                if (brs.next()) {
                    String usql = "update formtable_main_115_dt2 set ispay=0 where id='"+mid+"'";
                    urs.execute(usql);//写具体业务逻辑
                    writeLog("流程附加操作:" + usql);//写入日志
                }
            }
        } catch (Exception e) {
            // TODO: handle exception
            request.getRequestManager().setMessagecontent(e.getMessage());
            writeLog("节点附加操作异常，请联系系统管理员");
            return "0";
        }
        return SUCCESS;
    }

}