【控制】请求详情页面执行Sql语句

设置前效果

配置文件

1、\RG3.Web.Host.PaaS\Config\Mapper\basis\msg\mapper_bs-msg-notice_sql__responsefield.json

 "my_detail": {
      //#region child 1对多/chilobject1对1
      "showExtand": "null reader",
      //reader
      "bridgeColumnExtand": "",
      "fieldChild": {
        "reader": {
          "moduleKey": "bs-msg-notice-site",
          "responseField": "showmy",
          "showMethod": "childobject"
        }
      },
      //#endregion child 1对多/chilobject1对1
      "extend": "basis_detail",
      "auth": true,
      // #region 开启扩展入库配置
      "saveSqlExtand": true,
      // #endregion 开启扩展入库配置
      // #region 移除多余字段
      "bridgeColumnRemoves": "audit_opinion",
      // #endregion 移除多余字段
      //#region 请求详情前执行入库更新数据
      "eventDetailB": [
        {
          // 其它地方使用  _eventRsite
          "name": "site",
          "connName": "ConnMsg",
          "enabled": false,
          // 把状态更新为已读
          "updates": [
            "update bs_msg_notice_site set status=1 where  user_id=@_userId and notice_id=@noticeId"
          ],
          "inserts": [
            "insert into bs_msg_notice_site (msg_id,user_id,user_show_name,notice_id,status,open_id,create_time) values (@_primaryIdV,@_userId,@_userPushName,@noticeId,1,'site',@_currentDate)"
          ]
        }
      ]
      //#endregion 请求详情前执行入库更新数据
    },

推送并令配置生效（build-mapper-used）

http://localhost:5775/auth/main-content

推送并令配置生效（build-bridge-used）

http://localhost:5775/auth/main-content

设置后效果