05:10:22] -------------------------------------------------------------
CODE:N0510221
Error:15_102_1_-2146232060
SQL:SELECT tf.ID AS ShipFeeID,
tf.CustomerID,
tf.AreaID,
tf.TransportID,
tf.ShipFeeType,
tf.BeginWeight,
tf.BeginPrice,
tf.AddWeight,
tf.AddPrice,
tf.MaxWeight,
tf.VolumeWeightPrice,
tf.FeeDiscount,
tf.Currency,
tf.IsVolumeWeight,
tf.FuelFee,
tf.FuelFeeRate,
tf.OtherFee,
tf.Factor,
tf.VolumeWeightRatio,
tf.MaxSingleSize,
tst.RegisteredFee,
tst.HandleFee,
tst.Discount,
tst.TransportDaysFrom,
tst.TransportDaysTo,
tst.Memo,
t.TransportName,
t.TransferType,
t.IsRegistered,
tst.TransprotSupplierID AS TransprotSupplierID,
tf.BillingWeightType,
tf.CustomFormulaBillingWeight,
tf.MaxSingleSize,
tf.IsThanVolumeWeightRate,
tf.IsThanPackageMaxSize,
tf.IsThanProductSize,
tf.IsThanMaxWeight,
tf.IsThanMaxCustomWeight,
tf.MaxProductSize,
tf.MaxPackageWeight,
tf.MaxCustomWeight
FROM RB_Transport_Fee tf WITH(nolock)
INNER JOIN RB_Transport t WITH(nolock)
ON t.CustomerID = tf.CustomerID
AND t.ID = tf.TransportID
AND t.DefaultSupplierID = tf.SupplierID
LEFT JOIN RB_Transport_SupplierTransport as tst(nolock)
ON tf.SupplierID=tst.TransprotSupplierID
AND tf.TransportID=tst.TransportID
AND tf.CustomerID=tst.CustomerID
WHERE t.CustomerID IN()
AND t.IsActive = 1
AND t.DefaultSupplierID > 0
PARAMS:
MESSAGE:Incorrect syntax near ')'.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtendV2.Generate.RB_Transport_FeeExtendV2.GetDefaultSupplierTransportFeeList(CM_GetTransportFeeRuleListParam param, Boolean isShowMemo, Boolean isUseWriteDB)
在 Biz.Irobotbox.Delivery.TransportShipFee.TransportRuleFee.CalcRuleFeeList(List`1 feeParams, Boolean isShowMemo, Boolean isUseCache)
在 RB.WebApi.ApiCode.API_Methods.GetShipFees(ShipFeeRequest request)
在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 RB.WebApi.ApiCode.API_Entrance.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
-------------------------------------------------------------
任务描述
