f_synchronize.srf 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. $PBExportHeader$f_synchronize.srf
  2. global type f_synchronize from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_synchronize (ref transaction arg_transaction, ref string arg_msg)
  6. end prototypes
  7. global function integer f_synchronize (ref transaction arg_transaction, ref string arg_msg);//f_synchronize
  8. datetime dtm_ntserver
  9. date dat_ntserver
  10. time tim_ntserver
  11. s_SYSTEMTIME lpSystemTime
  12. int int_rtn
  13. //取得服务器时间
  14. //如果是Sql Server数据库
  15. select top 1 getdate() into :dtm_ntserver from sysusers using arg_transaction;
  16. //如果是Oracle数据库
  17. //select sysdate into :dtm_ntserver from dual;
  18. //st_2.text=string(dtm_ntserver,'yyyy-mm-dd hh:mm:ss')
  19. dat_ntserver=date(dtm_ntserver)
  20. tim_ntserver=time(dtm_ntserver)
  21. lpSystemTime.wYear=year(dat_ntserver)
  22. lpSystemTime.wMonth=month(dat_ntserver)
  23. lpSystemTime.wDay=day(dat_ntserver)
  24. lpSystemTime.wHour=hour(tim_ntserver)
  25. lpSystemTime.wMinute=Minute(tim_ntserver)
  26. lpSystemTime.wSecond=Second(tim_ntserver)
  27. //int_rtn=SetLocalTime(lpSystemTime)
  28. //if int_rtn=0 then
  29. // arg_msg='往服务器时间同步设置失败!'
  30. // return 0
  31. //else
  32. return 1
  33. //end if
  34. end function