【泛微OA】节点前后action注册DML，如何书写DML语句

1、执行存储过程
执行存储过程不需要添加外部主表
EXEC p_CaculateOvertimeHours_new ‘{?tbkssj}’,‘{?tbjssj}’

2、执行sql语句insert
主表：INSERT INTO TRecords (EMPLOYEE_ID,Card_No,datetime_record,timerecordMachine_id,computeStatus,inOut,verifymode,date_add)
VALUES((SELECT Employee_ID FROM TEmployees WHERE openid=‘{?ygbh}’),‘’,‘{?sjdkriq}’+’ ‘+ ‘{?sjdksj}’,‘000’,0,3,1,’{?sjdkriq}‘+’ '+ ‘{?sjdksj}’)

明细表：insert into ITAssetsTableNew (No,UserName,UserId,Kind,Type,Memory,CPU,CreationTime,Status,AssetArea,Remark)
values ( ‘{?d.wpbh}’,‘张三’,‘1288’,‘{?d.wplx}’,‘{?d.wpxh}’, ‘{?d.gt}’,‘{?d.nc}’,‘{?d.cjsj}’,‘{?d.zt}’,‘{?d.zcqy}’,‘{?d.bz}’)

3、执行sql语句update
主表：update hrmresource set email=‘{?Email}’,seclevel={?SECLevel} where id={?ToPeople}

明细表：update ITAssetsTableNew set CreationTime=‘{?d.cjsj}’,Status=‘{?d.zt}’,AssetArea=‘{?d.zcqy}’ ,Remark=‘{?d.bz}’ where No=‘{?d.wpbh}’