来源功能务的日志信息)

 pull 拉取(其它表数据更新到本表)
 push 推送(本表数据推送到其它表)
 sync 同步(本表数据同步到其它服务接口)
 task 任务(执行特定的定时任务或周期事务)
 process 进度(事务的执行进度)
 log 日志(事务的日志信息)务的日志信息)

功能使用配置

        /// <summary>
        /// 来源功能 pull 拉取(其它表数据更新到本表)  push 推送(本表数据推送到其它表)  sync 同步(本表数据同步到其它服务接口)  task 任务(执行特定的定时任务或周期事务)
        /// </summary>
        public string FromExecAction { get; set; }


        /// <summary>
        /// 忽略替换的关键字  a.project_id=@projectId and
        /// </summary>
        public string FromIgnoreWord { get; set; }


        /// <summary>
        /// 执行一次  once:true  设置isOnleExecOnce=true  忽略:need:false  设置 need=[]
        /// </summary>
        public string FromIgnoreNeed { get; set; }

        /// <summary>
        /// 忽略的字段, projectId 逗号分割
        /// </summary>
        public string FromIgnoreField { get; set; }

 "saveSqlExtand": {
    "pm-project-info-update-ht-hk": {
      "fromExecAction":"push",
      "fromIgnoreWord":"a.project_id=@projectId and",
      "fromIgnoreNeed":"",
      "fromIgnoreField":"",
      "target":"项目订单/合同",
      "need": [
        {
          "field": "projectId",
          "value": ""
        }
      ],
      "sortId": 30,
      "sqlUpdate": "UPDATE pm_project_ht_hk_info a,pm_project_info b SET a.project_name =b.project_name,a.invoice_cycle =b.invoice_cycle,a.ht_status =b.ht_status where a.project_id=@projectId and a.project_id=b.project_id",
      "sqlInsert": null,
      "connName": "ConnPM"
    }
  },
文档更新时间: 2025-04-05 20:11   作者:admin