| | |
| | | private bool isRk(int? gid) |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2>( |
| | | (a, b, c) => new JoinQueryInfos( |
| | | return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,MesInvItemStocks>( |
| | | (a, b, c,d) => new JoinQueryInfos( |
| | | JoinType.Inner, a.BillNo == b.BillNo, |
| | | JoinType.Inner, b.Id == c.ItemInId |
| | | JoinType.Inner, b.Id == c.ItemInId, |
| | | JoinType.Inner,c.ItemBarcode == d.ItemBarcode |
| | | )) |
| | | .Where((a, b, c) => a.Id == gid) |
| | | .Where((a, b, c,d) => a.Id == gid) |
| | | .Count() > 0; |
| | | } |
| | | } |