2025/6/18 23:15:22 运费计算 sql_shipprice：SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:14:52'>=TakeEfficacyDate and '2025-06-18 23:14:52'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:14:52'>=TakeEfficacyDate))
错误信息：System.Exception: SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:14:52'>=TakeEfficacyDate and '2025-06-18 23:14:52'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:14:52'>=TakeEfficacyDate))执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString)
   在 Vayava.Erp.Dal.ShipVia.ShipViaNewService.GetShipPriceData(String calculationMethod, String countryId, String strWhere_shipprice) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\ShipVia\ShipViaNewService.cs:行号 1061
2025/6/18 23:15:55 运费计算 sql_shipprice：SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:15:25'>=TakeEfficacyDate and '2025-06-18 23:15:25'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:15:25'>=TakeEfficacyDate))
错误信息：System.Exception: SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:15:25'>=TakeEfficacyDate and '2025-06-18 23:15:25'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:15:25'>=TakeEfficacyDate))执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString)
   在 Vayava.Erp.Dal.ShipVia.ShipViaNewService.GetShipPriceData(String calculationMethod, String countryId, String strWhere_shipprice) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\ShipVia\ShipViaNewService.cs:行号 1061
2025/6/18 23:16:28 运费计算 sql_shipprice：SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:15:58'>=TakeEfficacyDate and '2025-06-18 23:15:58'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:15:58'>=TakeEfficacyDate))
错误信息：System.Exception: SELECT distinct p.ForwarderByID,p.CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate,p.[Zone],pat.StartPostcode,pat.EndPostCode 
FROM ServiceCenter..ShipPrice_Postcode p
join ServiceCenter..PostcodeAreaTable pat on pat.ForwarderByID=p.ForwarderByID and pat.[Zone]=p.[Zone] and pat.CountryId=p.CountryId
WHERE p.Valid = 1 AND p.CountryId=43 and p.ForwarderByID in ('Z+SELF','XYZG+FEDEXt','XYZG+FBA','XYZG+FEDEXE','XYZG+FedExoversize','CYUS+FEDEX','CYUS+FEDEXOS','XYZG+FEDEXQM','CYUS+FEDEXQM','XYZG+UPS') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-06-18 23:15:58'>=TakeEfficacyDate and '2025-06-18 23:15:58'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-06-18 23:15:58'>=TakeEfficacyDate))执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString)
   在 Vayava.Erp.Dal.ShipVia.ShipViaNewService.GetShipPriceData(String calculationMethod, String countryId, String strWhere_shipprice) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\ShipVia\ShipViaNewService.cs:行号 1061