MiddlewareSyncDao_insertProject.sql 565 B

123456789101112131415161718192021222324252627282930313233343536
  1. INSERT INTO t_s_depart(
  2. id,
  3. dingdepartid,
  4. departname,
  5. dingIsSynchronization,
  6. description,
  7. org_Code,
  8. dept_Code,
  9. org_Type,
  10. mobile,
  11. fax,
  12. address,
  13. depart_Order,
  14. status,
  15. supervisor_Id,
  16. dept_Proj_Managerid,
  17. parentdepartid
  18. )
  19. VALUES (
  20. :project.id,
  21. :project.dingdepartid,
  22. :project.departname,
  23. :project.dingIsSynchronization,
  24. :project.description,
  25. :project.orgCode,
  26. :project.deptCode,
  27. :project.orgType,
  28. :project.mobile,
  29. :project.fax,
  30. :project.address,
  31. :project.departOrder,
  32. :project.status,
  33. :project.supervisorId,
  34. :project.deptProjManagerid,
  35. :project.parentdepartid
  36. );