经销商新增.sql 926 B

123456789101112131415161718192021222324252627282930
  1. insert into sa_agents(siteid, sa_agentsid, sys_enterpriseid, createby, createdate, changeuserid,
  2. changeby, changedate, agentnum, type, parentid,
  3. signdate, status, isservice,priceadjustment,entity,submitautocheck,presalesphonenumber,aftersalesphonenumber
  4. ,islimitaccessories,islimitorder,signingstate,delivery,salearea,paymans,regiontype)
  5. select $siteid$,
  6. $sa_agentsid$,
  7. $sys_enterpriseid$,
  8. $username$,
  9. now(),
  10. $changeuserid$,
  11. $username$,
  12. now(),
  13. $agentnum$,
  14. $type$,
  15. $parentid$,
  16. $signdate$,
  17. '0',
  18. $isservice$,
  19. $priceadjustment$,
  20. $entity$,
  21. $submitautocheck$,
  22. $presalesphonenumber$,
  23. $aftersalesphonenumber$,
  24. $islimitaccessories$,
  25. $islimitorder$,
  26. $signingstate$,
  27. $delivery$,
  28. $salearea$,
  29. $paymans$,
  30. $regiontype$