格式化代码

啊鑫

2 天以前 ed05efdc17aab076146b134ebe105b6382f221d7

 MES.Service/service/Warehouse/MesInvItemOutsManager.cs

@@ -68,11 +68,12 @@
    private List<MesInvItemOutItems> getProductionItemsList(
        WarehouseQuery query)
    {
        return Db.Queryable<MesInvItemOutItems, MesItems, MesDepTaskInfo>(
                (c, s, f) => new JoinQueryInfos(
                    JoinType.Inner, c.ItemNo == s.ItemNo,
                    JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo
                ))
        return Db
            .Queryable<MesInvItemOutItems, MesItems,
                MesDepTaskInfo>((c, s, f) => new JoinQueryInfos(
                JoinType.Inner, c.ItemNo == s.ItemNo,
                JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo
            ))
            .Where((c, s, f) => c.ItemOutId == query.id)
            .OrderBy(c => c.Id)
            .Select((c, s, f) => new MesInvItemOutItems
@@ -97,8 +98,8 @@
        WarehouseQuery query)
    {
        return Db
            .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>(
                (b, c, d) => new JoinQueryInfos(
            .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>((b, c, d) =>
                new JoinQueryInfos(
                    JoinType.Left,
                    b.ItemNo == c.ItemNo && b.Company == c.Company &&
                    b.Factory == c.Factory,
@@ -403,8 +404,8 @@
        foreach (var j in itemOutItems)
        {
            // 校验子表对应采购订单的供应商编码
            var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>(
                    (roh, supp) => new JoinQueryInfos(
            var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>((roh, supp) =>
                    new JoinQueryInfos(
                        JoinType.Left,
                        roh.Supplier == supp.Id.ToString()
                    ))
@@ -534,17 +535,16 @@
    public List<MesInvItemOutCDetails> GetScanBarcode(WarehouseQuery query)
    {
        return Db.Queryable<MesInvItemOutCDetails, MesInvItemBarcodes, MesItems,
                MesDepots>(
                (b, bar, c, d) => new
                    JoinQueryInfos(
                        JoinType.Left, b.ItemBarcode == bar.ItemBarcode,
                        JoinType.Left, b.ItemNo == c.ItemNo &&
                                       b.Company == c.Company &&
                                       b.Factory == c.Factory,
                        JoinType.Left, b.DepotCode == d.DepotCode &&
                                       b.Company == d.Company &&
                                       b.Factory == d.Factory
                    ))
                MesDepots>((b, bar, c, d) => new
                JoinQueryInfos(
                    JoinType.Left, b.ItemBarcode == bar.ItemBarcode,
                    JoinType.Left, b.ItemNo == c.ItemNo &&
                                   b.Company == c.Company &&
                                   b.Factory == c.Factory,
                    JoinType.Left, b.DepotCode == d.DepotCode &&
                                   b.Company == d.Company &&
                                   b.Factory == d.Factory
                ))
            .Where((b, bar, c, d) => b.ItemOutId == query.id)
            .Select((b, bar, c, d) => new MesInvItemOutCDetails
            {
@@ -880,11 +880,11 @@

        if (womcaa == null) throw new Exception("任务单号不存在");

        var Departmentcode = Db.Queryable<SysDepartment, MesInvItemOuts>(
                (a, b) =>
                    new JoinQueryInfos(JoinType.Left,
                        a.Departmentname == b.OutPart
                    )).Where((a, b) =>
        var Departmentcode = Db
            .Queryable<SysDepartment, MesInvItemOuts>((a, b) =>
                new JoinQueryInfos(JoinType.Left,
                    a.Departmentname == b.OutPart
                )).Where((a, b) =>
                b.OutPart == mesInvItemOuts.OutPart &&
                b.ItemOutNo == queryBillNo).Select(a => a.Departmentcode)
            .First();
@@ -896,14 +896,14 @@
        if (mesInvItemOuts.Status == 1) throw new Exception("领料单已审核，不能重复推送");

        var C_OUT_ITEMS = Db
            .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>(
                (c, b, d, e, f) =>
                    new JoinQueryInfos(
                        JoinType.Left, b.Id == c.ItemDabid,
                        JoinType.Left, d.Id == b.Pid,
                        JoinType.Left, e.Caa001 == d.Daa021,
                        JoinType.Left, f.Eid == e.Erpid
                    ))
            .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>((c,
                    b, d, e, f) =>
                new JoinQueryInfos(
                    JoinType.Left, b.Id == c.ItemDabid,
                    JoinType.Left, d.Id == b.Pid,
                    JoinType.Left, e.Caa001 == d.Daa021,
                    JoinType.Left, f.Eid == e.Erpid
                ))
            .Where((c, b, d, e, f) => c.ItemOutId == mesInvItemOuts.Id)
            .Select((c, b, d, e, f) => new
            {
@@ -936,8 +936,8 @@
            {
                FMaterialId = item.ItemNo,
                FUnitID = C_ITEM_UNIT,
                FAppQty =  qty,
                FActualQty =  qty,
                FAppQty = qty,
                FActualQty = qty,
                FStockId = item.DepotCode,
                FPPBomEntryId = erpid,
                F_UNW_Text_xsddh = xsddh,