kpt_xdmy/dm/r.sql

select sqlstr from apisql where sqlname='getStockPastureList';
select params from apisql where sqlname='getStockPastureList';
select sqlstr from apisql where sqlname='getBigStockLaidList';
select params from apisql where sqlname='getBigStockLaidList';
select sqlstr from apisql where sqlname='getBigPartuseList';
select params from apisql where sqlname='getBigPartuseList';

select ps.* from part_repertory ps join pasture p  ON ps.pastureId = p.id  where  p.name='新乐牧场';
select ps.* from part_repertory ps  join   warehouse w on ps.locationId = w.id join pasture p on w.pastureId = p.id where p.name='新乐牧场';


select bpl.* from bigpartlaid bpl  JOIN pasture p ON p.id = bpl.pastureId where p.name='新乐牧场';
select bp.* from partlaid bp join bigpartlaid bpl on  bp.bigid =bpl.id JOIN pasture p ON p.id = bpl.pastureId where p.name='新乐牧场';

select  bpu.* from   bigpartuse bpu  JOIN pasture p ON p.id = bpu.pastureId where p.name='新乐牧场';
select  pu.*  from partuse pu   join  bigpartuse bpu on pu.bigid =bpu.id JOIN pasture p ON p.id = bpu.pastureId where p.name='新乐牧场';