f_outware_sale_audit.srf 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. $PBExportHeader$f_outware_sale_audit.srf
  2. global type f_outware_sale_audit from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_outware_sale_audit (ref string arg_msg, ref long arg_cnt, ref long arg_failcnt)
  6. end prototypes
  7. global function integer f_outware_sale_audit (ref string arg_msg, ref long arg_cnt, ref long arg_failcnt);uo_outware_sale uo_ware
  8. uo_ware = Create uo_outware_sale
  9. uo_ware.commit_transaction = sqlca
  10. datastore ds_outware
  11. ds_outware = Create datastore
  12. ds_outware.DataObject = 'ds_outware_sale_noaudit_pda'
  13. ds_outware.SetTransObject(sqlca)
  14. ds_outware.Retrieve()
  15. Long ll_i
  16. String ls_outwarecode
  17. Long ll_scid,ll_outwareid
  18. String ls_msg
  19. Long ll_fail,ll_suc
  20. FOR ll_i = 1 To ds_outware.RowCount()
  21. ll_scid = ds_outware.Object.scid[ll_i]
  22. ll_outwareid = ds_outware.Object.outwareid[ll_i]
  23. ls_outwarecode = ds_outware.Object.outwarecode[ll_i]
  24. IF uo_ware.getinfo(ll_scid,ll_outwareid,ls_msg) = 0 THEN
  25. ROLLBACK;
  26. arg_msg = arg_msg + ls_outwarecode + ' 审核失败,'+ls_msg + '~r~n'
  27. ll_fail++
  28. CONTINUE
  29. END IF
  30. IF uo_ware.auditing(True,ls_msg) = 0 THEN
  31. ROLLBACK;
  32. arg_msg = arg_msg + ls_outwarecode + ' 审核失败,'+ls_msg + '~r~n'
  33. ll_fail++
  34. CONTINUE
  35. END IF
  36. ll_suc++
  37. NEXT
  38. arg_cnt = ll_suc
  39. arg_failcnt = ll_fail
  40. Destroy uo_ware
  41. Destroy ds_outware
  42. RETURN 1
  43. end function