jsonArray比较 返回

WarehouseInventory warehouseInventory = _sqlSugarClient.Queryable<WarehouseInventory>()

    .Where(wi => !wi.delFlag && wi.fwId == fwId && wi.itemType == fwType && wi.wmId == wmId && wi.cabinetNumber.Equals(cabinetNumber) &&

    wi.materialSpecification == materialSpecification && SqlFunc.JsonArrayAny(wi.materialSpecificationValue, materialSpecificationParms))

    .OrderByDescending(wi => wi.id)

    .First();

SELECT

`id`,

`fw_id`,

`item_type`,

`inventory_quantity`,

`unit_id`,

`wm_id`,

`cabinet_number`,

`serial_number`,

`material_specification`,

`material_specification_value`,

`remark`,

`del_flag`,

`create_by`,

`create_time`,

`update_by`,

`update_time` 

FROM

`pss_warehouse_inventory` 

WHERE

((((((

NOT ( `del_flag` = 1 ) 

AND ( `fw_id` = 43 )) 

AND ( `item_type` = 6 )) 

AND ( `wm_id` = 67 )) 

AND ( `cabinet_number` = N 'gh4545' ) 

) 

AND ( `material_specification` = 27 )) 

AND JSON_CONTAINS( `material_specification_value`, '"System.Collections.Generic.List`1[xjzc_models.Entity.Dto.PurchaseSaleStock.MaterialSpecification.MaterialSpecificationParms]"' )) 

ORDER BY

`id` DESC 

LIMIT 0,

1