2025/11/25 14:00:00 运费计算 SQL_shipvia：select distinct sv.MaxLimitPrice,sv.Code,sv.CNDesc,sv.ENDesc,sv.itemTypeId,sv.ForwarderByID,sv.WeightFormula,sv.FuelRates,sv.CalculationFormula
,sv.RegisteredFee,sv.Discount,sv.TrackAddress,sv.IsTrack,sv.Descriptions,sv.SendFreightSide,sv.CusFreightSide,sv.MangoFlag,sv.IsPrompt,sv.CurrencyENDesc,sv.MaxLimitLengths
,sv.MaxLimitWidths,sv.MaxLimitHighs,sv.MaxLimitPerimeter,sv.MaxLimitGirth,sv.MaxLimitGrossWeight,sv.Declare_EName,sv.Declare_CName,sv.SignatureFee
from ServiceCenter..ShipVia sv
join ServiceCenter..ShipViaAndPlatform svp on svp.ForwarderByID = sv.ForwarderByID
where sv.iValid = '1' and CHARINDEX(',17,',','+sv.MangoFlag+',')>0 and svp.PlatFormId='125'

错误信息：System.Exception: select distinct sv.MaxLimitPrice,sv.Code,sv.CNDesc,sv.ENDesc,sv.itemTypeId,sv.ForwarderByID,sv.WeightFormula,sv.FuelRates,sv.CalculationFormula
,sv.RegisteredFee,sv.Discount,sv.TrackAddress,sv.IsTrack,sv.Descriptions,sv.SendFreightSide,sv.CusFreightSide,sv.MangoFlag,sv.IsPrompt,sv.CurrencyENDesc,sv.MaxLimitLengths
,sv.MaxLimitWidths,sv.MaxLimitHighs,sv.MaxLimitPerimeter,sv.MaxLimitGirth,sv.MaxLimitGrossWeight,sv.Declare_EName,sv.Declare_CName,sv.SignatureFee
from ServiceCenter..ShipVia sv
join ServiceCenter..ShipViaAndPlatform svp on svp.ForwarderByID = sv.ForwarderByID
where sv.iValid = '1' and CHARINDEX(',17,',','+sv.MangoFlag+',')>0 and svp.PlatFormId='125'
无法继续执行，因为会话处于终止状态。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString)
   在 Vayava.Erp.Dal.ShipVia.ShipViaNewService.GetShipViaListByWhere(String strWhere_shipvia) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\ShipVia\ShipViaNewService.cs:行号 1060