背景介绍:
在无主外键关系的表中如果如果要关联就要用Join()和GroupJoin()方法了,我们先看Join()方法,代码如下:
static void Main(string[] args)
{
List<SW_XSDD> sw_xsdd = new List<SW_XSDD>()
{
new SW_XSDD { com_id = "SH01",vou_no = "100",corr_id = "A",corr_date = DateTime.Now},
new SW_XSDD { com_id = "SH02",vou_no = "200",corr_id = "B",corr_date = DateTime.Now.AddDays(1)},
new SW_XSDD { com_id = "SH03",vou_no = "300",corr_id = "C",corr_date = DateTime.Now.AddDays(2)}
};
List<SW_XSDD_C> sw_xsdd_c = new List<SW_XSDD_C>()
{
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_no = "101700001",number = 10,vou_line_no = 1},
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_no = "101700002",number = 11,vou_line_no = 2},
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_no = "101700003",number = 12,vou_line_no = 3},
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_no = "101700004",number = 13,vou_line_no = 4},
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_no = "101700005",number = 14,vou_line_no = 5},
new SW_XSDD_C { com_id = "SH01",vou_no = "100",item_