Linq_根据条件查询两个表，并将返回不同类型的结果合并

最新推荐文章于 2022-08-25 09:18:23 发布

Martin_Yelvin

最新推荐文章于 2022-08-25 09:18:23 发布

阅读量2.5k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/qq_36279445/article/details/80063645

版权

C# 专栏收录该内容

99 篇文章 3 订阅

订阅专栏

var deliveryOrderDetail = from d in _context.DeliveryOrderDetails
                                          where d.DeliveryOrder_ID == deliveryId
                                          select d;
                var deliveryNotRelevantOrderDetail = from dond in _context.DeliveryOrderNotRelevantDetails
                                          where dond.DeliveryOrder_ID == deliveryId
                                          select dond;
                //  两个表类型不一样。 我转换一下
                List<DeliveryOrderDetail> detail = new List<DeliveryOrderDetail>();
                foreach(var d in deliveryNotRelevantOrderDetail) {
                    detail.Add(new DeliveryOrderDetail {
                        DeliveryOrderDetail_ID = d.DeliveryOrderNotRelevantDetail_ID,
                        SAP_Description = d.SAP_Description,
                        SAP_Material_ID = d.SAP_Material_ID,
                        SAP_UOM = d.SAP_UOM,
                        OrderQty = d.OrderQty,
                        Reason = d.Reason,
                        Item = d.Item,
                        PickOperator = d.PickOperator
                    });
                }

                var oDetail = deliveryOrderDetail.Union(detail);