啊鑫
3 天以前 ed05efdc17aab076146b134ebe105b6382f221d7
MES.Service/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -117,8 +117,9 @@
    public List<MesInvItemInCDetails> GetInvItemInCDetails(decimal? pid)
    {
        var result = Db.Queryable<MesInvItemInCDetails, MesItems, MesUnit>(
                (g, c, d) => new JoinQueryInfos(
        var result = Db
            .Queryable<MesInvItemInCDetails, MesItems, MesUnit>((g, c, d) =>
                new JoinQueryInfos(
                    JoinType.Left,
                    g.ItemNo == c.ItemNo && g.Company == c.Company &&
                    g.Factory == c.Factory, JoinType.Inner,
@@ -231,18 +232,17 @@
        if (invItemIns.Status == 1) throw new Exception("入库单已审核,不能重复推送");
        var materials = Db.Queryable<MesInvItemInCItems, MesItems, MesUnit,
            MesInvItemArnDetail>(
            (g, c, d, a) => new JoinQueryInfos(
                JoinType.Left,
                g.ItemNo == c.ItemNo && g.Company == c.Company &&
                g.Factory == c.Factory, JoinType.Inner,
                d.Id == Convert.ToDecimal(c.ItemUnit),
                JoinType.Inner,
                a.Ebeln == g.WorkNo && a.WorkLine == g.EbelnLineNo
                                    && g.CbillNo == a.CbillNo
            )
        ).Where((g, c, d, a) => g.BillNo == billNo).Select<Material>(
            (g, c, d, a) => new Material
                MesInvItemArnDetail>((g, c, d, a) => new JoinQueryInfos(
                    JoinType.Left,
                    g.ItemNo == c.ItemNo && g.Company == c.Company &&
                    g.Factory == c.Factory, JoinType.Inner,
                    d.Id == Convert.ToDecimal(c.ItemUnit),
                    JoinType.Inner,
                    a.Ebeln == g.WorkNo && a.WorkLine == g.EbelnLineNo
                                        && g.CbillNo == a.CbillNo
                )
            ).Where((g, c, d, a) => g.BillNo == billNo)
            .Select<Material>((g, c, d, a) => new Material
            {
                FstockId = g.DepotCode,
                FuintId = d.Fnumber,