"manager_detail":{
 // #region 开启扩展入库配置
      "saveSqlExtand": true,
      // #endregion 开启扩展入库配置
}
 "saveSqlExtand": {
    // #region 数据变更后执行的操作
    "bt-policy-item": {
      "sortId": 25,
      "connName": "ConnAct",
      "sqlUpdate": "update bt_policy_item,bt_policy set bt_policy_item.family_id=bt_policy.family_id,bt_policy_item.bd_tbr_uid=bt_policy.bd_tbr_uid,bt_policy_item.bd_bbr_uid=bt_policy.bd_bbr_uid where bt_policy.policy_id=@policyId and bt_policy_item.policy_id=bt_policy.policy_id"
    },
    "bt-policy-status": {
      "sortId": 30,
      "connName": "ConnAct",
      "sqlUpdate": "update bt_policy_status,bt_policy set bt_policy_status.family_id=bt_policy.family_id,bt_policy_status.bd_tbr_uid=bt_policy.bd_tbr_uid,bt_policy_status.bd_bbr_uid=bt_policy.bd_bbr_uid where bt_policy.policy_id=@policyId and bt_policy_status.policy_id=bt_policy.policy_id"
    }
    //  #endregion  数据变更后执行的操作
  },
"saveSqlExtand": {
    // #region 数据变更后执行的操作
    "activity-blacklist-ip": {
      "sortId": 5,
      "connName": "ConnAct",
      "sqlUpdate": "update activity_blacklist_ip set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
      // 必须自动,如果为空,不执行方法
      //"need": [
      //  {
      //    "field": "activityName",
      //    "value": ""
      //  },
      //  {
      //    "field": "activityId",
      //    "value": ""
      //  }
      //]
    },
    "activity-blacklist-user": {
      "sortId": 10,
      "connName": "ConnAct",
      "sqlUpdate": "update activity_blacklist_user set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
    },
    "activity-whitelist-ip": {
      "sortId": 15,
      "connName": "ConnAct",
      "sqlUpdate": "update activity_whitelist_ip set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
    },
    "activity-whitelist-user": {
      "sortId": 20,
      "connName": "ConnAct",
      "sqlUpdate": "update activity_whitelist_user set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId) where activity_id=@activityId"
    },
    "activity-config-content": {
      "sortId": 25,
      "connName": "ConnAct",
      "sqlUpdate": "update activity_config_content set activity_name=(select max(activity_name) from activity_config where activity_id=@activityId)  where activity_id=@activityId"
    }
    //  #endregion  数据变更后执行的操作
  },
文档更新时间: 2022-07-29 07:23   作者:admin