001.sql 996 B

12345678910111213141516171819
  1. delete from pub_msgtemp where typecode = 'DJSK';
  2. go
  3. insert into pub_msgtemp(pk_templet,dr,langcode,messagetitle,pk_org,pk_outtemplet,tempcode,tempdscrpt,tempname,textcontent,ts,typecode,attachdoctype,attachtype,attdeftype,pk_temptype) values('0001ZZZZb036c54d6ed7',0,'simpchn','@&m submitter.user_name@提交的网银登记单待审批','GLOBLE00000000000000',null,'DJSKT','网银登记单审批信息','~','<div class="divtext">
  4. <span class="labeltext">财务组织:<span class="normaltext">@&m pk_org.name@</span></span>
  5. </div>
  6. <div class="divtext">
  7. <span class="labeltext">单据编号:<span class="normaltext">@&m billno@</span></span>
  8. </div>','2021-11-03 17:33:36','DJSK',0,0,'~','0001ZZZZc4c175700939');
  9. go
  10. delete from pub_msgtemp_type where tempcode = 'WF_zjcmp_cd';
  11. go
  12. insert into pub_msgtemp_type(pk_temptype,dr,innercode,metaid,name,parentpk,tempcode,ts,comp) values('0001ZZZZbcae3edb0a7f',0,'DTUQC98Y','~','~','1004Z010000000005ALB','WF_zjcmp_cd','2021-11-03 17:33:36',null);
  13. go