set_major_sys_scope.clmt 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <templet>
  2. <version>1.0</version>
  3. <procedure _name="target">
  4. <parameters>
  5. <parameter>
  6. <name>codes</name>
  7. <description>范围列表,[{code:'SE',type:'major'},{code:'SELT',type:'sys'}]</description>
  8. <type>32</type>
  9. <format></format>
  10. </parameter>
  11. </parameters>
  12. <actions>
  13. <operation_set>
  14. <name>action</name>
  15. <description>设置系统和专业的交付范围</description>
  16. <operations>
  17. <sql_operation>
  18. <name>clear</name>
  19. <dataSource>poc</dataSource>
  20. <sql>delete from `main_scope` where type='major' or type='sys'</sql>
  21. </sql_operation>
  22. <table_operation>
  23. <name>save</name>
  24. <dataSource>poc</dataSource>
  25. <mode>1</mode>
  26. <table>main_scope</table>
  27. <fields>
  28. <field_data>
  29. <field>type</field>
  30. <data>=bind(codes)</data>
  31. </field_data>
  32. <field_data>
  33. <field>code</field>
  34. <data>=bind(codes)</data>
  35. </field_data>
  36. </fields>
  37. </table_operation>
  38. </operations>
  39. </operation_set>
  40. </actions>
  41. </procedure>
  42. <comments>
  43. <next_id>1</next_id>
  44. <list>
  45. <comment>
  46. <id>0</id>
  47. <items>
  48. <comment_item>
  49. <content>设置系统和专业的范围</content>
  50. <update_time>2021-6-10 18:4</update_time>
  51. </comment_item>
  52. </items>
  53. </comment>
  54. </list>
  55. </comments>
  56. <comment_id>0</comment_id>
  57. </templet>