2025/11/27 9:30:01 运费计算 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=40 and p.ForwarderByID in ('Z+SELF','TM+KC','HS+DPD-BIG','Z+FSELF','HS003+HSGLSNXQJ','HS006+FEDEX','HS006+FEDEXFREIGHT','HS006+FEDEXNXQJ','HS006+FEDEXNXJD','HS006+FEDEXFREIGHTNXJD','HS006+PLFEDEX','HS006+PLFEDEXKP','HS+EUDPDNXQJ','HS+EUDPDNXJD','HS+DPD','SZ039+HSUPSNXJD','SZ039+HSUPSNXQJ','HS003+HSGLSEUNX','SZ039+HSUPSDJ','HS+DPDNXJD','HS+DPDNXQJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 09:30:01'>=TakeEfficacyDate and '2025-11-27 09:30:01'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 09:30:01'>=TakeEfficacyDate)) and '78200'>=UPPER(StartPostcode) and '78200'<=UPPER(EndPostCode)
错误信息：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=40 and p.ForwarderByID in ('Z+SELF','TM+KC','HS+DPD-BIG','Z+FSELF','HS003+HSGLSNXQJ','HS006+FEDEX','HS006+FEDEXFREIGHT','HS006+FEDEXNXQJ','HS006+FEDEXNXJD','HS006+FEDEXFREIGHTNXJD','HS006+PLFEDEX','HS006+PLFEDEXKP','HS+EUDPDNXQJ','HS+EUDPDNXJD','HS+DPD','SZ039+HSUPSNXJD','SZ039+HSUPSNXQJ','HS003+HSGLSEUNX','SZ039+HSUPSDJ','HS+DPDNXJD','HS+DPDNXQJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 09:30:01'>=TakeEfficacyDate and '2025-11-27 09:30:01'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 09:30:01'>=TakeEfficacyDate)) and '78200'>=UPPER(StartPostcode) and '78200'<=UPPER(EndPostCode)无法继续执行，因为会话处于终止状态。
当前命令发生了严重错误。应放弃任何可能产生的结果。
   在 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:行号 1097
2025/11/27 9:30:01 运费计算 sql_shipprice：SELECT distinct ForwarderByID,CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate 
FROM ServiceCenter..ShipPrice p
WHERE Valid = 1 AND CountryId=40 and p.ForwarderByID in ('Z+SELF','TM+KC','HS+DPD-BIG','Z+FSELF','HS003+HSGLSNXQJ','HS006+FEDEX','HS006+FEDEXFREIGHT','HS006+FEDEXNXQJ','HS006+FEDEXNXJD','HS006+FEDEXFREIGHTNXJD','HS006+PLFEDEX','HS006+PLFEDEXKP','HS+EUDPDNXQJ','HS+EUDPDNXJD','HS+DPD','SZ039+HSUPSNXJD','SZ039+HSUPSNXQJ','HS003+HSGLSEUNX','SZ039+HSUPSDJ','HS+DPDNXJD','HS+DPDNXQJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 09:30:01'>=TakeEfficacyDate and '2025-11-27 09:30:01'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 09:30:01'>=TakeEfficacyDate))
错误信息：System.Exception: SELECT distinct ForwarderByID,CountryId,PriceMethod,StartWeight,EndWeight,LoseEfficacyDate,TakeEfficacyDate 
FROM ServiceCenter..ShipPrice p
WHERE Valid = 1 AND CountryId=40 and p.ForwarderByID in ('Z+SELF','TM+KC','HS+DPD-BIG','Z+FSELF','HS003+HSGLSNXQJ','HS006+FEDEX','HS006+FEDEXFREIGHT','HS006+FEDEXNXQJ','HS006+FEDEXNXJD','HS006+FEDEXFREIGHTNXJD','HS006+PLFEDEX','HS006+PLFEDEXKP','HS+EUDPDNXQJ','HS+EUDPDNXJD','HS+DPD','SZ039+HSUPSNXJD','SZ039+HSUPSNXQJ','HS003+HSGLSEUNX','SZ039+HSUPSDJ','HS+DPDNXJD','HS+DPDNXQJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 09:30:01'>=TakeEfficacyDate and '2025-11-27 09:30:01'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 09:30:01'>=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:行号 1097
2025/11/27 10:00:00 运费计算 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','DF+DFH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 10:00:00'>=TakeEfficacyDate and '2025-11-27 10:00:00'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 10:00:00'>=TakeEfficacyDate)) and '064'>=UPPER(StartPostcode) and '064'<=UPPER(EndPostCode)
错误信息：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','DF+DFH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-11-27 10:00:00'>=TakeEfficacyDate and '2025-11-27 10:00:00'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-11-27 10:00:00'>=TakeEfficacyDate)) and '064'>=UPPER(StartPostcode) and '064'<=UPPER(EndPostCode)无法继续执行，因为会话处于终止状态。
当前命令发生了严重错误。应放弃任何可能产生的结果。
   在 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:行号 1097