：点晴ERP-零代码开发自定义数据源-操作教程

点击进入

如下图：

点击增加类别

如下图：

填写名称，然后点击增加

如下图：

然后填写数据库sql语句，示例：select scm_deliver_goods_order.order_id as main_info, scm_deliver_goods_order.client_name as  remark1,scm_deliver_goods_order_list.product_code as remark2,scm_deliver_goods_order_list.product_name as remark3,scm_deliver_goods_order_list.product_spec as remark4,scm_client_order_contract_list.order_quantity as remark5,scm_deliver_goods_order_list.pre_quantity as remark6 from scm_deliver_goods_order_list  LEFT OUTER JOIN scm_deliver_goods_order on scm_deliver_goods_order_list.order_id=scm_deliver_goods_order.order_id LEFT OUTER JOIN scm_client_order_contract_list on scm_client_order_contract_list.id=scm_deliver_goods_order_list.contract_sub_id where scm_deliver_goods_order_list.orderstat <>4

然后提交

如下图：

然后绑定数据要填充的控件，点击然后在新开窗口选择

如下图：

勾上属性列名，可以修改查询出来的数据的标题，修改完后点击修改控钮保存

如下图：