2025/6/23 17:37:41 GetRecords：System.Exception: 列名 'id' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 829
   在 PDSys.Domain.Services.TrackInfoRepository.GetRecordsNoPage(TrackInfoQuery query) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 737 sql：
SELECT 
TOP 5000
lsc.ID,lsc.[TrackingNumber],lsc.[SendTime],lsc.[OrderID],lsc.[ForwarderByID],lsc.[ItemReceived],lsc.[ItemDispatched],lsc.[DepartfromAirport],lsc.[ArrivalfromAbroad],lsc.[CustomsClearance],lsc.[DestinationArrived],lsc.[LogisticsState],lsc.[Createon],lsc.[CreateBy],lsc.[LastUpdOn],lsc.[LastUpdBy], lsc.lastUpdateTime, lsc.lastEvent, DATEDIFF(DAY, lastUpdateTime, GETDATE()) NoUpdateTime, lsc.UploadState, lsc.TrackCodeMatchState, lsc.Remark,lsc.IsDF, lsc.[StopCategory],lsc.[StopReason],lsc.[TrackCode],lsc.PackageID,lsc.TrackService,lsc.LogisticsWorkOrderId,fpo .OrderType OrderTypeId,(CASE fpo.OrderType WHEN '1' then '补发订单' WHEN '2' THEN '返修订单'  WHEN '3' THEN '调拨订单'  WHEN '4' THEN '样品订单' ELSE '普通订单' END) OrderTypeStr,fpo.PARecordID AccountId, fpo .Itemtype PlatformName, fpo .InputUserId,fpo.StoreManager StoreManagerId, fpo .CCountry CountryId,fp .WarehouseId,dti.SupplierId,dti.SupplierName,dti.ProviderLogisticsWayId,dti.PStocker,dti.RStocker 
FROM LogisticsTrackInfo.dbo.[LogisticsStateChangeTime] lsc WITH(NOLOCK) 
LEFT JOIN ServiceCenter.dbo.LogisticsInES ld WITH(NOLOCK) on ld.LogisticsId = lsc.id
INNER JOIN SinadealTradeDB.dbo.tdCOMain fpo WITH(NOLOCK) on lsc.OrderID=fpo.PONO
INNER JOIN SinadealTradeDB.dbo.FMS_Package fp WITH(NOLOCK) on fpo .coid = fp.Coids and lsc.PackageID = fp.PackageID
LEFT JOIN LogisticsTrackInfo.dbo.DFPackageTrackInfo dti on dti .TrackingNumber = lsc .TrackingNumber AND dti.PackageID = 'CB'+lsc.PackageID
WHERE  ld.id is null  and sendtime>='2022-01-01'
2025/6/23 17:41:22 GetRecords：System.Exception: 列名 'id' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 829
   在 PDSys.Domain.Services.TrackInfoRepository.GetRecordsNoPage(TrackInfoQuery query) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 737 sql：
SELECT 
TOP 5000
lsc.ID,lsc.[TrackingNumber],lsc.[SendTime],lsc.[OrderID],lsc.[ForwarderByID],lsc.[ItemReceived],lsc.[ItemDispatched],lsc.[DepartfromAirport],lsc.[ArrivalfromAbroad],lsc.[CustomsClearance],lsc.[DestinationArrived],lsc.[LogisticsState],lsc.[Createon],lsc.[CreateBy],lsc.[LastUpdOn],lsc.[LastUpdBy], lsc.lastUpdateTime, lsc.lastEvent, DATEDIFF(DAY, lastUpdateTime, GETDATE()) NoUpdateTime, lsc.UploadState, lsc.TrackCodeMatchState, lsc.Remark,lsc.IsDF, lsc.[StopCategory],lsc.[StopReason],lsc.[TrackCode],lsc.PackageID,lsc.TrackService,lsc.LogisticsWorkOrderId,fpo .OrderType OrderTypeId,(CASE fpo.OrderType WHEN '1' then '补发订单' WHEN '2' THEN '返修订单'  WHEN '3' THEN '调拨订单'  WHEN '4' THEN '样品订单' ELSE '普通订单' END) OrderTypeStr,fpo.PARecordID AccountId, fpo .Itemtype PlatformName, fpo .InputUserId,fpo.StoreManager StoreManagerId, fpo .CCountry CountryId,fp .WarehouseId,dti.SupplierId,dti.SupplierName,dti.ProviderLogisticsWayId,dti.PStocker,dti.RStocker 
FROM LogisticsTrackInfo.dbo.[LogisticsStateChangeTime] lsc WITH(NOLOCK) 
LEFT JOIN ServiceCenter.dbo.LogisticsInES ld WITH(NOLOCK) on ld.LogisticsId = lsc.id
INNER JOIN SinadealTradeDB.dbo.tdCOMain fpo WITH(NOLOCK) on lsc.OrderID=fpo.PONO
INNER JOIN SinadealTradeDB.dbo.FMS_Package fp WITH(NOLOCK) on fpo .coid = fp.Coids and lsc.PackageID = fp.PackageID
LEFT JOIN LogisticsTrackInfo.dbo.DFPackageTrackInfo dti on dti .TrackingNumber = lsc .TrackingNumber AND dti.PackageID = 'CB'+lsc.PackageID
WHERE  ld.id is null  and sendtime>='2022-01-01'
2025/6/23 17:41:23 GetRecords：System.Exception: 列名 'id' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 829
   在 PDSys.Domain.Services.TrackInfoRepository.GetRecordsNoPage(TrackInfoQuery query) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 737 sql：
SELECT 
TOP 5000
lsc.ID,lsc.[TrackingNumber],lsc.[SendTime],lsc.[OrderID],lsc.[ForwarderByID],lsc.[ItemReceived],lsc.[ItemDispatched],lsc.[DepartfromAirport],lsc.[ArrivalfromAbroad],lsc.[CustomsClearance],lsc.[DestinationArrived],lsc.[LogisticsState],lsc.[Createon],lsc.[CreateBy],lsc.[LastUpdOn],lsc.[LastUpdBy], lsc.lastUpdateTime, lsc.lastEvent, DATEDIFF(DAY, lastUpdateTime, GETDATE()) NoUpdateTime, lsc.UploadState, lsc.TrackCodeMatchState, lsc.Remark,lsc.IsDF, lsc.[StopCategory],lsc.[StopReason],lsc.[TrackCode],lsc.PackageID,lsc.TrackService,lsc.LogisticsWorkOrderId,fpo .OrderType OrderTypeId,(CASE fpo.OrderType WHEN '1' then '补发订单' WHEN '2' THEN '返修订单'  WHEN '3' THEN '调拨订单'  WHEN '4' THEN '样品订单' ELSE '普通订单' END) OrderTypeStr,fpo.PARecordID AccountId, fpo .Itemtype PlatformName, fpo .InputUserId,fpo.StoreManager StoreManagerId, fpo .CCountry CountryId,fp .WarehouseId,dti.SupplierId,dti.SupplierName,dti.ProviderLogisticsWayId,dti.PStocker,dti.RStocker 
FROM LogisticsTrackInfo.dbo.[LogisticsStateChangeTime] lsc WITH(NOLOCK) 
LEFT JOIN ServiceCenter.dbo.LogisticsInES ld WITH(NOLOCK) on ld.LogisticsId = lsc.id
INNER JOIN SinadealTradeDB.dbo.tdCOMain fpo WITH(NOLOCK) on lsc.OrderID=fpo.PONO
INNER JOIN SinadealTradeDB.dbo.FMS_Package fp WITH(NOLOCK) on fpo .coid = fp.Coids and lsc.PackageID = fp.PackageID
LEFT JOIN LogisticsTrackInfo.dbo.DFPackageTrackInfo dti on dti .TrackingNumber = lsc .TrackingNumber AND dti.PackageID = 'CB'+lsc.PackageID
WHERE  ld.id is null  and sendtime>='2022-01-01'
2025/6/23 17:41:24 GetRecords：System.Exception: 列名 'id' 无效。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 829
   在 PDSys.Domain.Services.TrackInfoRepository.GetRecordsNoPage(TrackInfoQuery query) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 737 sql：
SELECT 
TOP 5000
lsc.ID,lsc.[TrackingNumber],lsc.[SendTime],lsc.[OrderID],lsc.[ForwarderByID],lsc.[ItemReceived],lsc.[ItemDispatched],lsc.[DepartfromAirport],lsc.[ArrivalfromAbroad],lsc.[CustomsClearance],lsc.[DestinationArrived],lsc.[LogisticsState],lsc.[Createon],lsc.[CreateBy],lsc.[LastUpdOn],lsc.[LastUpdBy], lsc.lastUpdateTime, lsc.lastEvent, DATEDIFF(DAY, lastUpdateTime, GETDATE()) NoUpdateTime, lsc.UploadState, lsc.TrackCodeMatchState, lsc.Remark,lsc.IsDF, lsc.[StopCategory],lsc.[StopReason],lsc.[TrackCode],lsc.PackageID,lsc.TrackService,lsc.LogisticsWorkOrderId,fpo .OrderType OrderTypeId,(CASE fpo.OrderType WHEN '1' then '补发订单' WHEN '2' THEN '返修订单'  WHEN '3' THEN '调拨订单'  WHEN '4' THEN '样品订单' ELSE '普通订单' END) OrderTypeStr,fpo.PARecordID AccountId, fpo .Itemtype PlatformName, fpo .InputUserId,fpo.StoreManager StoreManagerId, fpo .CCountry CountryId,fp .WarehouseId,dti.SupplierId,dti.SupplierName,dti.ProviderLogisticsWayId,dti.PStocker,dti.RStocker 
FROM LogisticsTrackInfo.dbo.[LogisticsStateChangeTime] lsc WITH(NOLOCK) 
LEFT JOIN ServiceCenter.dbo.LogisticsInES ld WITH(NOLOCK) on ld.LogisticsId = lsc.id
INNER JOIN SinadealTradeDB.dbo.tdCOMain fpo WITH(NOLOCK) on lsc.OrderID=fpo.PONO
INNER JOIN SinadealTradeDB.dbo.FMS_Package fp WITH(NOLOCK) on fpo .coid = fp.Coids and lsc.PackageID = fp.PackageID
LEFT JOIN LogisticsTrackInfo.dbo.DFPackageTrackInfo dti on dti .TrackingNumber = lsc .TrackingNumber AND dti.PackageID = 'CB'+lsc.PackageID
WHERE  ld.id is null  and sendtime>='2022-01-01'
2025/6/23 18:30:00 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:00 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:00 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:00 InitTrackInfoViewModel：System.Exception: 无法继续执行，因为会话处于终止状态。
当前命令发生了严重错误。应放弃任何可能产生的结果。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:00 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:01 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 18:30:01 InitTrackInfoViewModel：System.Exception: 在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.FMS_PackageDetailService.GetList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\FMS\FMS_PackageDetailService.cs:行号 397
   在 Vayava.Erp.Bll.FMS_PackageDetailManager.GetModelList(String strWhere) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\FMS\FMS_PackageDetailManager.cs:行号 129
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1007 
2025/6/23 22:11:37 InitTrackInfoViewModel：System.NullReferenceException: 未将对象引用设置到对象的实例。
   在 PDSys.Domain.Services.TrackInfoRepository.InitTrackInfoViewModel(DataRow dataRow, List`1 accounts, List`1 users, List`1 PStockers, List`1 RStockers) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\TrackInfoRepository.cs:行号 1019