深圳智汇创想科技有限公司

[步骤]

[结果]

CODE:N1542535
Error:16_245_1_-2146232060
SQL:SELECT COUNT(1) FROM ( select DISTINCT
                                       pro.SKU AS SKU,
                                       pro.ImageUrl,
                                       arod.fnsku AS FNSKU,
                                       arod.sku AS MNSKU,
                                       arod.RequestedQuantity,
                                       arod.CancelledQuantity,
                                       arod.DisposedQuantity,
                                       arod.ShippedQuantity,
                                       arod.InProcessQuantity,
                                       arod.Disposition,
                                       rrd.ReceivedQty,
                                       pro.ProductNameCN,
                                       arod.CostDestroyed,
                                       arod.Remark,
                                       arod.DestroyedAdminName,
                                       arod.JobNo,
                                       arod.DestructionReason AS DestroyedReason,
                                       Isnull(( CASE  WHEN po.LastBuyPrice > 0 THEN po.LastBuyPrice
                                                ELSE po.LastSupplierPrice
                                                END ), 0) * (arod.DisposedQuantity + arod.ShippedQuantity) as TotalProcessedPurchasePrice,
                                       Isnull(( CASE  WHEN po.LastBuyPrice > 0 THEN po.LastBuyPrice
                                                ELSE po.LastSupplierPrice
                                                END ), 0) * (arod.RequestedQuantity) as TotalPurchasePrice,
                                       '' AS Carrier,
                                       '' TrackingNumber
                              from (
                                      SELECT
                                              MAX(ID) AS ID,
                                              CustomerID,
                                              OrderID,
                                              OrderSourceID,
                                              SKU,
                                              FnSKU,
                                              Disposition
                                      FROM RB_Amazon_Removal_Order_Detail (NOLOCK)
                                      WHERE CustomerID= @CustomerID AND OrderID = @OrderID AND OrderSourceID = @OrderSourceID
                                      group by CustomerID ,OrderID ,OrderSourceID ,sku,FnSKU, Disposition
                                     ) temp
                                   left join RB_Amazon_Removal_Order_Detail arod with (nolock)
                                          on arod.ID = temp.ID
                                   left join RB_Removeorder_ReceiveDetail rrd with (nolock)
                                          on arod.OrderID = rrd.OrderID
                                         and arod.OrderSourceID = rrd.OrderSourceID
                                         and arod.CustomerID = rrd.CustomerID
                                         and arod.Sku  = rrd.SellerSKU
                                         and arod.FnSKU = rrd.FNSKU
                                   left join RB_Amazon_Product_Base po ( NOLOCK )
                                          on po.CustomerID = arod.CustomerID
                                         and po.OrderSourceID = arod.OrderSourceID
                                         and po.OrderSourceSKU = arod.SKU
                                         and po.IsDelete=0
                                   left join RB_Product_OrderSourceSKU orsku with (nolock)
                                          on arod.sku = orsku.OrderSourceSKU
                                         and arod.OrderSourceID = orsku.OrderSourceID
                                         and arod.CustomerID = orsku.CustomerID
                                   left join RB_Product pro with (nolock)
                                          on orsku.SKU = pro.SKU
                                         and orsku.CustomerID = pro.CustomerID
                               where arod.CustomerID = @CustomerID
                                     and arod.OrderID = @OrderID  and arod.DestroyedAdminName in (select cast(item as int) from CharSplitForIn(@CreationAdminIDs,',')) ) AS PagerTable
PARAMS:@CustomerID = 1 ,@OrderID = 67220708G5 ,@OrderSourceID = 1000010 ,@CreationAdminIDs = 1565 ,
MESSAGE:在将 nvarchar 值 'admin_yang' 转换成数据类型 int 时失败。
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.TryHasMoreRows(Boolean& moreRows)
   在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   在 System.Data.SqlClient.SqlDataReader.Read()
   在 System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
   在 System.Data.SqlClient.SqlCommand.ExecuteScalar()
   在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, SqlParameter[] cmdParms)
   在 RB.DALExtendV2.RB_Amazon_Removal_Order_DetailExtendV2.GetPagerModelsToRemoveOrderDetail(CM_GetRemovalOrderCreateRecordSkuItemsParam para, Int32& recordCount, String RemovalOrderType, String snapshotDate)
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderDetail.BindData()
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderDetail.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.Web.UI.Control.OnLoad(EventArgs e)
   在 System.Web.UI.Control.LoadRecursive()
   在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest()
   在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_removeorder_removeorderdetail_aspx.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)
   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   在 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)

[期望]