| 123456789101112131415161718192021222324252627282930 |
- insert into sa_agents(siteid, sa_agentsid, sys_enterpriseid, createby, createdate, changeuserid,
- changeby, changedate, agentnum, type, parentid,
- signdate, status, isservice,priceadjustment,entity,submitautocheck,presalesphonenumber,aftersalesphonenumber
- ,islimitaccessories,islimitorder,signingstate,delivery,salearea,paymans,regiontype)
- select $siteid$,
- $sa_agentsid$,
- $sys_enterpriseid$,
- $username$,
- now(),
- $changeuserid$,
- $username$,
- now(),
- $agentnum$,
- $type$,
- $parentid$,
- $signdate$,
- '0',
- $isservice$,
- $priceadjustment$,
- $entity$,
- $submitautocheck$,
- $presalesphonenumber$,
- $aftersalesphonenumber$,
- $islimitaccessories$,
- $islimitorder$,
- $signingstate$,
- $delivery$,
- $salearea$,
- $paymans$,
- $regiontype$
|