| | |
|---|
| | | c.ItemNo == t.ItemNo && c.Company == t.Company && |
|---|
| | | c.Factory == t.Factory, |
|---|
| | | JoinType.Left, |
|---|
| | | t.Fpurchaseunitid == u.Id && t.Factory == u.Factory && |
|---|
| | | t.Fpurchaseunitid == u.Id.ToString() && t.Factory == u.Factory && |
|---|
| | | t.Company == u.Company |
|---|
| | | }) |
|---|
| | | .Where((c, t, u) => c.Mid == query.id) |
|---|
| | |
|---|
| | | JoinType.Inner, |
|---|
| | | a.ItemNo == c.ItemNo && a.Company == c.Company && |
|---|
| | | a.Factory == c.Factory, |
|---|
| | | JoinType.Inner, c.Fpurchaseunitid == t.Id, |
|---|
| | | JoinType.Inner, c.Fpurchaseunitid == t.Id.ToString(), |
|---|
| | | JoinType.Inner, z.ReleaseNo == a.ReleaseNo |
|---|
| | | }) |
|---|
| | | .Where((a, d, b, c, t, z) => a.FngHandle == "退货" && |
|---|
