1. select * from tbl_errorlog where relatedid =''
  • 订单:使用tjh000
  • 套餐:使用groupid
  • 官方套餐:使用mealid
套餐

任务分组【新增】

  1. insert into TBL_HANDLELOG(BUSCODE, KEYID, HANDLETYPE, STATUS, MEMO,CREATEDATE)
  2. select 'MEALCHANGE', RWFZID,1,0,'任务分组【新增】',(select sysdate from dual) from HM_YW_TTRWFZ;

任务分组【更新】

  1. insert into TBL_HANDLELOG(BUSCODE, KEYID, HANDLETYPE, STATUS, MEMO,CREATEDATE)
  2. select 'MEALCHANGE', RWFZID,2,0,'任务分组【修改】',(select sysdate from dual) from HM_YW_TTRWFZ;
文档更新时间: 2023-04-23 17:24