f_check_if_oaflow_caudit.srf 915 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. $PBExportHeader$f_check_if_oaflow_caudit.srf
  2. global type f_check_if_oaflow_caudit from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_check_if_oaflow_caudit (long arg_scid, long arg_billid, long arg_powerid, ref string arg_msg)
  6. end prototypes
  7. global function integer f_check_if_oaflow_caudit (long arg_scid, long arg_billid, long arg_powerid, ref string arg_msg);Long RSLT = 1
  8. Long CNT
  9. Long ls_doc_status
  10. SELECT COUNT(*)
  11. INTO :CNT
  12. FROM oa_doc
  13. WHERE dtype = 1
  14. AND powerid = :arg_powerid
  15. AND SCID = :ARG_SCID
  16. AND BILLID = :ARG_BILLID
  17. AND docflag = 1
  18. and rowid > 2 USING SQLCA;
  19. IF SQLCA.SQLCode <> 0 THEN
  20. RSLT = 0
  21. ARG_MSG = '查询操作失败:OA审批公文:'+SQLCA.SQLErrText
  22. GOTO ext
  23. END IF
  24. IF CNT = 0 THEN
  25. RSLT = 1
  26. ELSE
  27. RSLT = 0
  28. ARG_MSG = '该单据正处于待OA流程审批中,不能删改、审核、撤审'
  29. GOTO ext
  30. END IF
  31. ext:
  32. RETURN RSLT
  33. end function