110,538
社区成员
发帖
与我相关
我的任务
分享
var query = (from record in dt
join packageDetail in db.T_Products_PackageDetail.DefaultIfEmpty() on record.F_PackageBarcode equals packageDetail.F_PackageBarcode
into joinPackageDetail
from packageDetail in joinPackageDetail.DefaultIfEmpty()
join package in db.T_Products_Package on packageDetail.F_PackageID equals package.F_ID
into joinPackage
from package in joinPackage.DefaultIfEmpty()
join archive in db.T_Products_Archive on package.F_ArchiveID equals archive.F_ID
into joinArchive
from archive in joinArchive.DefaultIfEmpty()
select new
{
F_PackageBarcode = (record == null ? "" : record.F_PackageBarcode),
F_ProductName = (archive == null ? "" : archive.F_Name), //产品名称
});
foreach (var row in query)
{
if (row == null || string.IsNullOrEmpty(row.F_ProductName))
{
sbError.AppendLine(string.Format("包裹条形码{0}在系统找不到对应商品", row.F_PackageBarcode.ToString()));
}
else
{
}
}