批量保存和列表配置

{
  "diffTableNo": 0,
  "isRESTful": true,
  "base": {
    "connName": "ConnBo",
    "isRearEnd": true,
    "isFrontEnd": true
  },
  "responseField": {
    "save": {
      "auth": true,
      "where": " ",
      "saveSql": {
        //and object_type=@objectType
        "insert": "insert into bo_popedom_field(menu_id,field,object_id,object_type,popedom,field_value) values(@menuId,@field,@objectId,@objectType,@popedom,@fieldValue)",
        "update": "update bo_popedom_field set popedom=@popedom,field_value=@fieldValue where menu_id=@menuId and field=@field and object_id=@objectId and object_type=@objectType "
      }
    },
    // popedom 1、读写；2、只读；3、只写；4、隐藏；5、列表只读；6、编辑只读；7、新增只读。
    "obj": {
      "auth": true,
      "dataFromType": "Database",
      "show": "menu_id,field,object_id,object_type,popedom,field_value",
      "bridgeColumn": "menu_id,field,object_id,object_type,popedom,field_value",
      "original": "",
      "isList": true,
      "selectSql": {
        "list": "select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id=@objectId and object_type=@objectType and menu_id=@menuId and popedom>0"
      }
    },
    // popedom 1 读写; 2、只读；3、只写、4、不可见、5、列表只读、6、编辑只读
    // 关联对象类型，1=角色权限，2=用户增加特殊权限，3=用户减少的特殊权限，4=单位权限，与bo_sys_enum中的sign_id=4的ENUM_VALUE值关联
    "user": {
      "auth": true,
      "dataFromType": "Database",
      "show": "menu_id,field,object_id,object_type,popedom,field_value",
      "bridgeColumn": "menu_id,field,object_id,object_type,popedom,field_value",
      "original": "",
      "isList": true,
      "selectSql": {
        "list": "select * from ( select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id=@objectId and (object_type=2) and popedom>0 and menu_id=@menuId  union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select role_id from bo_user_role where user_id=@objectId) and object_type=1 and popedom>0 and menu_id=@menuId union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select dep_id from bo_user_dep where user_id=@objectId) and object_type=4 and popedom>0 and menu_id=@menuId union select menu_id,field,object_id,object_type,popedom,field_value from bo_popedom_field where object_id in (select job_id from bo_user_job where user_id=@objectId) and object_type=5 and popedom>0 and menu_id=@menuId) t where field not in (select field from bo_popedom_field where object_id=@objectId and object_type=3) "
      }
    },
    "my": {
      "auth": true,
      "dataFromType": "Database",
      "show": "field,field_value,popedom",
      "original": "",
      "isList": true,
      "selectSql": {
        "list": "select field,field_value value,popedom  from ( select field,field_value,popedom from bo_popedom_field where object_id=@_userId and (object_type=2) and popedom>0 and menu_id=@menuId  union select field,field_value,popedom from bo_popedom_field where object_id in (select role_id from bo_user_role where user_id=@_userId) and object_type=1 and popedom>0 and menu_id=@menuId union select field,field_value,popedom from bo_popedom_field where object_id in (select dep_id from bo_user_dep where user_id=@_userId) and object_type=4 and popedom>0 and menu_id=@menuId union select field,field_value,popedom from bo_popedom_field where object_id in (select job_id from bo_user_job where user_id=@_userId) and object_type=5 and popedom>0 and menu_id=@menuId) t where field not in (select field from bo_popedom_field where object_id=@_userId and object_type=3) "
      }
    }
  },
  "tables": [
    {
      "id": 1,
      "name": "bo_popedom_field",
      "isPrimary": true,
      "primaryColumn": [
        {
          "isIdentity": false,
          "tableId": 1,
          "colName": "menu_id",
          "field": "menuId"
        },
        {
          "isIdentity": false,
          "tableId": 1,
          "colName": "field",
          "field": "field"
        },
        {
          "isIdentity": false,
          "tableId": 1,
          "colName": "object_id",
          "field": "objectId"
        },
        {
          "isIdentity": false,
          "tableId": 1,
          "colName": "object_type",
          "field": "objectType"
        }
      ],
      "type": "Table"
    }
  ],
  "saveSqlPrimary": {
    "isBat": false,
    "isSaveReturnObj": false,
    "tableName": "bo_popedom_field",
    "primaryColumn": [
      {
        "isIdentity": false,
        "tableId": 1,
        "colName": "menu_id",
        "field": "menuId"
      },
      {
        "isIdentity": false,
        "tableId": 1,
        "colName": "field",
        "field": "field"
      },
      {
        "isIdentity": false,
        "tableId": 1,
        "colName": "object_id",
        "field": "objectId"
      },
      {
        "isIdentity": false,
        "tableId": 1,
        "colName": "object_type",
        "field": "objectType"
      }
    ]
  }
}