package com.customcode.wl.action;
import weaver.conn.RecordSetDataSource;
import weaver.interfaces.workflow.action.Action;
import weaver.soa.workflow.request.RequestInfo;
/**
* User: yyb
* Date: 2017-12-12
* oa数据获取,插入物流系统
*/
public class insertWliu implements Action{
public String execute(RequestInfo request) {
RecordSetDataSource rsds = new RecordSetDataSource("WL");//读起EHR数据源
String requestid = request.getRequestid();//请求id
rsds.executeProc( "wl_PutToScdd" , procpara , "WL") ;//wl_PutToScdd 存储名称,procpara存储输入参数,Motic 为数据源名称
String result="1" ;//用于判断是否成功 0失败 1成功
return result;// 0失败 1成功
}
}
注意点:
<!--
创建存储,如下示例输入人员的编号workcode和设定安全级别,来更新该编号人员的状态status=1(为正式)和安全级别
注意点:系统调用的存储要带两个输出参数 @flag integer output,@msg varchar(80) output
CREATE PROCEDURE [dbo].[PD_UpdateStatusAndSeclevel]
(@workcode varchar(100),
@seclevel int,
@flag integer output,
@msg varchar(80) output)
AS
update hrmresource set status=1,seclevel=@seclevel where workcode=@workcode
DECLARE @return_value int,
@flag int,
@msg varchar(80)
EXEC @return_value = [dbo].[PD_UpdateStatusAndSeclevel]
@workcode = N'123',
@seclevel = 10,
@flag = @flag OUTPUT,
@msg = @msg OUTPUT
print '@workcode='+@workcode --打印调试
-->