Tag PO Number") <> AssetsAll.Field(Of String)("PONumber") _
Or TwoDHist.Field(Of String)("Old Tag Maintenance Vendor") <> AssetsAll.Field(Of String)("MaintenanceVendor") _
Or TwoDHist.Field(Of String)("Old Tag Manufacturer Part Number") <> AssetsAll.Field(Of String)("ManufacturerPartNumber") _
Or TwoDHist.Field(Of String)("Old Tag Model") <> AssetsAll.Field(Of String)("Model") _
Or TwoDHist.Field(Of DateTime?)("Old Tag Lease End Date").ToString <> AssetsAll.Field(Of String)("LeaseEndDate") _
Or TwoDHist.Field(Of DateTime?)("Old Tag Maintenance End Date").ToString <> AssetsAll.Field(Of String)("MaintenanceEndDate") _
Order By AssetsAll.Field(Of String)("BidSegment"), AssetsAll.Field(Of String)("Country"), _
AssetsAll.Field(Of String)("RSN"), AssetsAll.Field(Of String)("Floor"), AssetsAll.Field(Of String)("Room") _
Select New With _
{ _
.SerialNumber = AssetsAll.Field(Of String)("SerialNumber") _
, .OldTagSerialNumber = TwoDHist.Field(Of String)("Old Tag Serial Number") _
, .BarCode = AssetsAll.Field(Of String)("BarCode") _
, .AssetTag = AssetsAll.Field(Of String)("AssetTag") _
, .OldTagAssetTag = AssetsAll.Field(Of String)("AssetTag") _
, .MaintenanceVendor = AssetsAll.Field(Of String)("MaintenanceVendor") _
, .OldTagMaintenanceVendor = TwoDHist.Field(Of String)("Old Tag Maintenance Vendor") _
, .LeaseEndDate = AssetsAll.Field(Of String)("LeaseEndDate").ToString _
, .OldTagLeaseEndDate = TwoDHist.Field(Of DateTime?)("Old Tag Lease End Date").ToString _
, .PONumber = AssetsAll.Field(Of String)("PONumber") _
, .OldTagPONumber = TwoDHist.Field(Of String)("Old Tag PO Number") _
, .ManufacturerPartNumber = AssetsAll.Field(Of String)("ManufacturerPartNumber") _
, .OldTagManufacturerPartNumber = TwoDHist.Field(Of String)("Old Tag Manufacturer Part Number") _
, .MaintenanceEndDate = AssetsAll.Field(Of String)("MaintenanceEndDate").ToString _
, .OldTagMaintenanceEndDate = TwoDHist.Field(Of DateTime?)("Old Tag Maintenance End Date").ToString _
, .Manufacturer = TwoDHist.Field(Of String)("Manufacturer") _
, .Make = AssetsAll.Field(Of String)("Make") _
, .Model = AssetsAll.Field(Of String)("Model") _
, .OldTagModel = TwoDHist.Field(Of String)("Old Tag Model") _
, .BidSegment = AssetsAll.Field(Of String)("BidSegment") _
, .OldTagBidSegment = TwoDHist.Field(Of String)("Old Tag Bid Segment") _
, .HostName = AssetsAll.Field(Of String)("HostName") _
, .InstallDate = AssetsAll.Field(Of String)("InstallDate").ToString _
, .Floor = AssetsAll.Field(Of String)("Floor") _
, .Room = AssetsAll.Field(Of String)("Room") _
, .RSN = AssetsAll.Field(Of String)("RSN") _
, .BuildingName = AssetsAll.Field(Of String)("BuildingName") _
, .Country = AssetsAll.Field(Of String)("Country") _
, .ProductType = AssetsAll.Field(Of String)("ProductType") _
, .TwoDTagLastPrintDate = TwoDHist.Field(Of DateTime?)("2D Tag Last Print Date").ToString _
, .FileOrigin = AssetsAll.Field(Of String)("FileOrigin") _
, .AssetID = AssetsAll.Field(Of String)("AssetID") _
, .ClientCode = AssetsAll.Field(Of String)("ClientCode") _
}
RecordReturn = CustomLINQtoDataSetMethods.CopyToDataTable(RetagginReport)
----------------------------------------------------------------------------------------------------------------------------------------------------
上面是以前一个项目里面处理的一个报表功能，就是这种场景的应用，每次查询后面都转换了一次，转换成DataTable，这个不是必须的，但调试时更 |