请求参数如下:
{
"list": [
{
"supplierCode": "M10143",
"sendPlaceCode": "A1"
},
{
"supplierCode": "M10155",
"sendPlaceCode": "A1"
}
],
"__menuName": ""
}
service层:
@Override
@PMethodHandle(runMethodName = "checkSupplierSendChange")
public EntityResult checkSupplierSendChangeQuery(Map<String, Object> paraMap) {
if (ObjectUtils.isEmpty(paraMap.get("list"))) throw new BusicenException("参数为空");
List<Map> list = JSON.parseArray(JSON.toJSONString((List<Map<String, Object>>) paraMap.get("list")), Map.class);
List<Map<String, String>> res = iTmDbSupplierSendPlaceMapperBase.checkSupplierSendChangeQuery(list);
return ResultHandler.operOk(res);
}
Dao层:
List<Map<String,String>> checkSupplierSendChangeQuery(@Param("list") List<Map> list);
Xml:
<select id="checkSupplierSendChangeQuery" resultType="java.util.Map">
select
distinct
SUPPLIER_CODE,
SEND_PLACE_CODE
from t_sc_tm_db_supplier_part
where
<foreach collection="list" item="map" open="(" close=")" separator="or">
SUPPLIER_CODE =#{map.supplierCode} and SEND_PLACE_CODE =#{map.sendPlaceCode}
</foreach>
</select>