f_get_itemid.srf 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. $PBExportHeader$f_get_itemid.srf
  2. global type f_get_itemid from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_get_itemid (long arg_dfttype, ref long arg_itemid, ref string arg_msg)
  6. end prototypes
  7. global function integer f_get_itemid (long arg_dfttype, ref long arg_itemid, ref string arg_msg);Long rslt = 1
  8. Long ll_itemid
  9. SELECT itemid INTO :ll_itemid
  10. FROM u_itemdef
  11. Where dfttype = :arg_dfttype;
  12. IF sqlca.SQLCode <> 0 THEN
  13. IF arg_dfttype = 1 THEN
  14. arg_msg = '查询默认销售收款项目资料失败'
  15. ELSEIF arg_dfttype = 2 THEN
  16. arg_msg = '查询默认采购外协付款项目资料失败'
  17. ELSEIF arg_dfttype = 3 THEN
  18. arg_msg = '查询默认销售优惠项目资料失败'
  19. ELSEIF arg_dfttype = 4 THEN
  20. arg_msg = '查询默认销售退货项目资料失败'
  21. ELSEIF arg_dfttype = 5 THEN
  22. arg_msg = '查询默认采购外协退货项目资料失败'
  23. ELSEIF arg_dfttype = 6 THEN
  24. arg_msg = '查询默认销售税金项目资料失败'
  25. ELSEIF arg_dfttype = 7 THEN
  26. arg_msg = '查询默认采购税金项目资料失败'
  27. ELSEIF arg_dfttype = 8 THEN
  28. arg_msg = '查询默认采购优惠项目资料失败'
  29. ELSE
  30. arg_msg = '查询收入支出项目资料失败,类型:'+string(arg_dfttype)
  31. END IF
  32. rslt = 0
  33. arg_itemid = 0
  34. goto ext
  35. END IF
  36. arg_itemid = ll_itemid
  37. ext:
  38. RETURN rslt
  39. end function