Error:16_4104_1_-2146232060
SQL:
SELECT vtb.OrderSourceSKUID
FROM RB_Amazon_Product_Base vtb ( NOLOCK )
LEFT JOIN RB_StockClearDetailed scd ( NOLOCK ) ON ( vtb.OrderSourceSKUID = scd.ListId
AND vtb.CustomerID = scd.CustomerID AND vtb.IsDelete=0
AND ( clearType = 1
OR clearType = 3
)
)
LEFT JOIN ( SELECT SUM(GoodNum) AS Inventory ,
WareHouseID ,
SKU ,
CustomerID
FROM RB_WareHouse_Product (NOLOCK)
GROUP BY WareHouseID ,
SKU ,
CustomerID
) AS tbWHN ON ( vtb.WID = tbWHN.WareHouseID
AND vtb.SKU = tbWHN.SKU
AND vtb.CustomerID = tbWHN.CustomerID
)
LEFT JOIN RB_OrderSource b ON vtb.CustomerID = b.CustomerID
AND vtb.OrderSourceID = b.ID
LEFT JOIN RB_Product p ( NOLOCK ) ON p.CustomerID = vtb.CustomerID
AND vtb.SKU = p.SKU
LEFT JOIN RB_WareHouse wh ( NOLOCK ) ON wh.CustomerID = p.CustomerID
AND wh.ID = p.DefaultLocalWarehouse
LEFT JOIN RB_Product_SupplierPrice psb ( NOLOCK ) ON p.CustomerID = psb.CustomerID
AND p.SKU = psb.SKU
AND psb.IsDefault = 1
LEFT JOIN RB_Product_Supplier c ( NOLOCK ) ON psb.CustomerID = c.CustomerID
AND psb.SupplierID = c.ID
LEFT JOIN RB_WareHouse swh ( NOLOCK ) ON swh.CustomerID = c.CustomerID
AND swh.ID = c.TheWareHouseID
LEFT JOIN dbo.RB_Admin ON vtb.CustomerID = dbo.RB_Admin.CustomerID
AND b.SaleAdminID = dbo.RB_Admin.ID
AND dbo.RB_Admin.IsActive = 1
AND dbo.RB_Admin.IsLock = 0
LEFT JOIN RB_Product_Admin pa ( NOLOCK ) ON vtb.CustomerID = pa.CustomerID
AND vtb.SKU = pa.SKU
LEFT JOIN RB_WareHouse_Product wp ( NOLOCK ) ON wp.CustomerID = vtb.CustomerID
AND wp.ID = WPID
LEFT JOIN RB_SalesSactorHolidays sh ( NOLOCK ) ON sh.CustomerID = vtb.CustomerID
AND sh.ID = vtb.HolidaysID
LEFT JOIN RB_Customer_Setting setting ( NOLOCK ) ON setting.CustomerID = vtb.CustomerID
LEFT OUTER JOIN RB_BusinessTeam BT WITH ( NOLOCK ) ON vtb.CustomerID = BT.CustomerID
AND BT.ID = RB_Admin.BusinessTeamID WHERE vtb.CustomerID = @CustomerID AND vtb.IsDelete=0 AND vtb.CustomerID=1 AND vtb.IsDelete=0 and vtb.BusinessAdminID in(3343) and isnull(vtb.IsOffShelf,0) in (1,4,5,2,0) and vtb.OrderSourceSKUID>0 AND vtb.OrderSourceID in(13846,13845,9199,13844,15931,15443,15442,15441,14646,14551,13848,13847,16969,15440,15439,15438,15437,15436,17359,17363,-1) AND tbColdHot.ID IS NULL
PARAMS:@CustomerID = 1 ,@UserID = 7493 ,@FolderID = 0 ,
MESSAGE:The multi-part identifier "tbColdHot.ID" could not be bound.
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.DALExtend.RB_Amazon_Product_BaseExtend.GetConditionIdList(Int32 customerId, String sql, Int32 folderID, Int32 adminID)
在 PandaBuy.ERP.Web.ASHX.IrobotBox.BeiKuCommon.SetSaleCondition(Int32 sid, String sname, String sql, Int32 folderID, Int32 adminID)
在 PandaBuy.ERP.Web.ASHX.IrobotBox.BeiKuCommon.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)
又出现了。