2025/6/27 16:45:21 QueryInvoiceList:System.Exception: select * from (
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
WHERE 1=1 and ii.InvoiceType in (0,1)
union all
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
left join SinadealTradeDB..InvoiceRedinkEntry re on re.RedinkOffsetInvoiceNo=ii.InvoiceNo
WHERE 1=1 and ii.InvoiceType =2 and (re.ReissueInvoiceNo is null or re.ReissueInvoiceNo='')
) a where 1=1
ORDER BY CreateTime DESC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.VATService.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\VATService.cs:行号 1135
   在 Vayava.Erp.Bll.VATManager.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\Order\VATManager.cs:行号 181
   在 PDSys.Controllers.VATController.QueryInvoiceList() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\VATController.cs:行号 94
2025/6/27 16:45:43 QueryInvoiceList:System.Exception: select * from (
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
WHERE 1=1 and ii.InvoiceType in (0,1)
union all
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
left join SinadealTradeDB..InvoiceRedinkEntry re on re.RedinkOffsetInvoiceNo=ii.InvoiceNo
WHERE 1=1 and ii.InvoiceType =2 and (re.ReissueInvoiceNo is null or re.ReissueInvoiceNo='')
) a where 1=1
ORDER BY CreateTime DESC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.VATService.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\VATService.cs:行号 1135
   在 Vayava.Erp.Bll.VATManager.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\Order\VATManager.cs:行号 181
   在 PDSys.Controllers.VATController.QueryInvoiceList() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\VATController.cs:行号 94
2025/6/27 16:45:48 QueryInvoiceList:System.Exception: select * from (
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
WHERE 1=1 and ii.InvoiceType in (0,1)
union all
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
left join SinadealTradeDB..InvoiceRedinkEntry re on re.RedinkOffsetInvoiceNo=ii.InvoiceNo
WHERE 1=1 and ii.InvoiceType =2 and (re.ReissueInvoiceNo is null or re.ReissueInvoiceNo='')
) a where 1=1
ORDER BY CreateTime DESC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.VATService.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\VATService.cs:行号 1135
   在 Vayava.Erp.Bll.VATManager.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\Order\VATManager.cs:行号 181
   在 PDSys.Controllers.VATController.QueryInvoiceList() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\VATController.cs:行号 94
2025/6/27 16:45:50 QueryInvoiceList:System.Exception: select * from (
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
WHERE 1=1 and ii.InvoiceType in (0,1)
union all
SELECT ii.*,vd.Valid,pa.accounts,pa.PlatformId
,(select top 1 sr.ShipDate from SinadealTradeDB..FMS_PackageShipRecord sr
inner join SinadealTradeDB..FMS_Package s on s.PackageID=sr.PackageID
where s.ponos=ii.PONo order by sr.CreateDate desc) ShipDate
FROM SinadealTradeDB..InvoiceInfo ii
left join SinadealTradeDB..InvoiceVATIDInfo vd on vd.VatNumber=ii.BuyerVATID
left join servicecenter..platformaccounts pa on pa.RecordId=ii.AccountId
left join SinadealTradeDB..InvoiceRedinkEntry re on re.RedinkOffsetInvoiceNo=ii.InvoiceNo
WHERE 1=1 and ii.InvoiceType =2 and (re.ReissueInvoiceNo is null or re.ReissueInvoiceNo='')
) a where 1=1
ORDER BY CreateTime DESC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.VATService.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Order\VATService.cs:行号 1135
   在 Vayava.Erp.Bll.VATManager.GetInvoiceList(InvoiceQuery query, Boolean platPrivl, String userId) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\Order\VATManager.cs:行号 181
   在 PDSys.Controllers.VATController.QueryInvoiceList() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\VATController.cs:行号 94