开始时间: 17:47:55
错误代码: N1747551
sql类型: SELECT
sql: [17:47:55] -------------------------------------------------------------
CODE:N1747551
Error:16_208_0_-2146232060
SQL:SELECT COUNT(1) FROM ( SELECT RB_Product_Supplier.[ID] ,
RB_Product_Supplier.[CustomerID] ,
RB_Product_Supplier.[SupplierName] ,
RB_Product_Supplier.[Responsible] ,
RB_Product_Supplier.[LegalPerson] ,
RB_Product_Supplier.[Address] ,
RB_Product_Supplier.[Telephone] ,
RB_Product_Supplier.[QQ] ,
RB_Product_Supplier.[Msn] ,
RB_Product_Supplier.[WangWang] ,
RB_Product_Supplier.[LinkName] ,
RB_Product_Supplier.[Phone] ,
RB_Product_Supplier.[Email] ,
RB_Product_Supplier.[Remark] ,
RB_Product_Supplier.[QualityQuestionReturn] ,
RB_Product_Supplier.[HomeUrl] ,
RB_Product_Supplier.[SupplierGrade] ,
RB_Product_Supplier.[TotalBuyNum] ,
RB_Product_Supplier.[TotalBuyPrice] ,
RB_Product_Supplier.[ScrapNum] ,
RB_Product_Supplier.[ReturnsNum] ,
RB_Product_Supplier.[AdminID] ,
RB_Product_Supplier.[AdminName] ,
RB_Product_Supplier.[DevelopAdminID] ,
RB_Product_Supplier.[DevelopAdminName] ,
RB_Product_Supplier.[AssignTime] ,
RB_Product_Supplier.[ProcurementLocationID] ,
RB_Product_Supplier.[BuyerID] ,
RB_Product_Supplier.[BuyerName] ,
RB_Product_Supplier.[LastImportTime] ,
RB_Product_Supplier.[UpdateAdminID] ,
RB_Product_Supplier.[UpdateAdminName] ,
RB_Product_Supplier.[IsLoginSupply] ,
RB_Product_Supplier.[LoginSupplyType] ,
RB_Product_Supplier.[SupplierAccount] ,
RB_Product_Supplier.[SupplierPassword] ,
RB_Product_Supplier.[SupplierType] ,
RB_Product_Supplier.[TheWareHouseID] ,
RB_Product_Supplier.[ManagerPhone] ,
RB_Product_Supplier.[DepositBank] ,
RB_Product_Supplier.[BankAddress] ,
RB_Product_Supplier.[BankAccount] ,
RB_Product_Supplier.[AccountName] ,
RB_Product_Supplier.[BillType] ,
RB_Product_Supplier.[PaymentDay] ,
RB_Product_Supplier.[PostCode] ,
RB_Product_Supplier.[ImageUrl] ,
RB_Product_Supplier.[WeChat] ,
RB_Product_Supplier.[AuditStuats] ,
RB_Product_Supplier.[AuditUserId] ,
RB_Product_Supplier.[AuditNoReason] ,
RB_Product_Supplier.[AuditUName] ,
RB_Product_Supplier.[PaymentType] ,
RB_Product_Supplier.[IsFBABarCode] ,
RB_Product_Supplier.[SelfHelpUploadNewProducts] ,
RB_Product_Supplier.[DeliveryList] ,
RB_Product_Supplier.[IndependentProductPackaging] ,
RB_Product_Supplier.[SupportReturnedGoods] ,
RB_Product_Supplier.[IsBilling] ,
RB_Product_Supplier.[Qualification] ,
RB_Product_Supplier.[QualificationBillingType] ,
RB_Product_Supplier.[BillingProvinceID] ,
RB_Product_Supplier.[BillingCityID] ,
RB_Product_Supplier.[TaxPoint] ,
RB_Product_Supplier.[SettlementMethod] ,
RB_Product_Supplier.[PaymentDayNew] ,
RB_Product_Supplier.[AliPayDate] ,
RB_Product_Supplier.[PaymentDayStartDate] ,
RB_Product_Supplier.[AliPaymentType] ,
RB_Product_Supplier.[PaymentProofImagesPath] ,
RB_Product_Supplier.[Fax] ,
RB_Product_Supplier.[ProcPayType] ,
RB_Product_Supplier.[NetFromType] ,
RB_Product_Supplier.[ShipProvince] ,
RB_Product_Supplier.[ShipCity] ,
RB_Product_Supplier.[IsSupplierStockup] ,
RB_Product_Supplier.AddTime ,
RB_Product_Supplier.AuditTime ,
RB_Product_Supplier.UpdateTime ,
RB_Product_Supplier.SettlementCurrency,
RB_Product_Supplier.VatRate,
RB_Product_Supplier.TaxRegistrationNumber,
RB_Product_Supplier.MainCategoryName,
RB_Product_Supplier.IsBlackList,
RB_Product_Supplier.IfEnabled,
RB_Product_Supplier.SupplierClassification,
isnull(RB_Product_Supplier.TwoAuditStatus,0) TwoAuditStatus,
RB_WareHouse.WareHouseName AS WareHouseName ,
ShipProvinceName = ( SELECT TOP 1
ProvinceName
FROM dbo.E_China_Province
WHERE ProvinceID = RB_Product_Supplier.ShipProvince
) ,
ShipCityName = ( SELECT TOP 1
CityName
FROM dbo.E_China_City
WHERE CityID = RB_Product_Supplier.ShipCity
) ,
CASE WHEN RB_Product_Supplier.ProcPayType = 1 THEN '现金付款'
WHEN RB_Product_Supplier.ProcPayType = 2 THEN '网络在线付款'
WHEN RB_Product_Supplier.ProcPayType = 3 THEN '转帐付款'
ELSE '未知类型'
END AS PaymentDayCn ,
E_Website.Domain AS Domain ,
DefaultBankAccountName =(SELECT TOP 1
BankAccountName
FROM RB_Supplier_BankAccount (NOLOCK)
WHERE IsDefault = 1
AND CustomerId = RB_Product_Supplier.CustomerID
AND SupplierId = RB_Product_Supplier.ID),
RB_Product_Supplier_ProcurementLocation.ProcurementLocationName AS ProcurementLocationName,
RB_Supplier_Contact.Name AS DefaultLinkName,
RB_Supplier_Contact.WangWang AS DefaultWangWang,
RB_Supplier_Contact.QQ AS DefaultQQ,
RB_Supplier_Contact.MobilePhone AS DefaultMobilePhoneQ,
RB_Supplier_Contact.Email AS DefaultEmail,
Grading =(SELECT TOP 1 Grading FROM RB_Supplier_AssessmentRecord WHERE SupplierId =RB_Product_Supplier.ID AND CustomerID=RB_Product_Supplier.CustomerID ORDER BY AddTime DESC),
RB_Product_Supplier.SetBlackRemark,
ISNULL(RB_Product_SupplierDataStatistics.SkuTotal, 0) AS SkuTotal ,
ISNULL(RB_Product_SupplierDataStatistics.DefaultSKUTotal, 0) AS DefaultSKUTotal ,
ISNULL(RB_Product_SupplierDataStatistics.PurchaseTotal, 0) AS PurchaseTotal ,
ISNULL(RB_Product_SupplierDataStatistics.PurchaseTotalAmount, 0.00) AS PurchaseTotalAmount ,
ISNULL(RB_Product_SupplierDataStatistics.LastOneMonthsPurchaseTotal, 0) AS LastOneMonthsPurchaseTotal ,
ISNULL(RB_Product_SupplierDataStatistics.LastOneMonthsPurchaseTotalAmount,
0.00) AS LastOneMonthsPurchaseTotalAmount ,
ISNULL(RB_Product_SupplierDataStatistics.LastTwoMonthsPurchaseTotal, 0) AS LastTwoMonthsPurchaseTotal ,
ISNULL(RB_Product_SupplierDataStatistics.LastTwoMonthsPurchaseTotalAmount,
0.00) AS LastTwoMonthsPurchaseTotalAmount ,
ISNULL(RB_Product_SupplierDataStatistics.HistoricalProcurementBadRate,
0.00) AS HistoricalProcurementBadRate ,
ISNULL(RB_Product_SupplierDataStatistics.PurchaseReturnOnTimeRate,
0.00) AS PurchaseReturnOnTimeRate ,
ISNULL(RB_Product_SupplierDataStatistics.PurchaseAverageReturnDays, 0) AS PurchaseAverageReturnDays ,
ISNULL(RB_Product_SupplierDataStatistics.SkuDiscontinuationRate, 0.00) AS SkuDiscontinuationRate ,
ISNULL(RB_Product_SupplierDataStatistics.SkuBurstingTotal, 0) AS SkuBurstingTotal ,
ISNULL(RB_Product_SupplierDataStatistics.SkuOnTheShelfNoShutdownTotal,
0) AS SkuOnTheShelfNoShutdownTotal ,
ISNULL(RB_Product_SupplierDataStatistics.LastOneMonthsSkuOnTheShelfTotal,
0) AS LastOneMonthsSkuOnTheShelfTotal ,
ISNULL(RB_Product_SupplierDataStatistics.SkuSluggishTotal, 0) AS SkuSluggishTotal ,
ISNULL(RB_Product_SupplierDataStatistics.SkuSluggishTotalAmount, 0.00) AS SkuSluggishTotalAmount
FROM RB_Product_Supplier WITH ( NOLOCK )
LEFT JOIN RB_Product_Supplier_ProcurementLocation WITH ( NOLOCK ) ON RB_Product_Supplier_ProcurementLocation.ID = RB_Product_Supplier.ProcurementLocationID
LEFT JOIN E_Website WITH ( NOLOCK ) ON E_Website.CustomerID = RB_Product_Supplier.CustomerID
LEFT JOIN RB_WareHouse WITH ( NOLOCK ) ON RB_Product_Supplier.TheWareHouseID = RB_WareHouse.ID
LEFT JOIN RB_Supplier_Contact WITH (NOLOCK) ON RB_Product_Supplier.CustomerID = RB_Supplier_Contact.CustomerID AND RB_Product_Supplier.ID= dbo.RB_Supplier_Contact.ProductSupplierId AND RB_Supplier_Contact.IsDefault=1
LEFT JOIN RB_Product_SupplierDataStatistics (NOLOCK) ON RB_Product_Supplier.CustomerID = RB_Product_SupplierDataStatistics.CustomerID AND RB_Product_SupplierDataStatistics.SupplierId = RB_Product_Supplier.ID
WHERE 1 = 1 and RB_Product_Supplier.IsDeleted=0 AND RB_Product_Supplier.CustomerID =1 and RB_Product_Supplier.SupplierName in(SELECT SupplierName FROM #RB_Product_Supplier_SupplierName_Temp) ) AS PagerTable
PARAMS:
MESSAGE:Invalid object name '#RB_Product_Supplier_SupplierName_Temp'.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.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.DALExtend.RB_Product_SupplierExtend.GetPagerListForNew(CM_GetProductSupplierListParam parameters, Int32& recordCount, Int32 currentUserId, Boolean isShowPurchaseSupplier, Boolean isShowDevelopSupplier)
在 PandaBuy.ERP.Web.IrobotBox.Supplier.SupplierList.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_supplier_supplierlist_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)
http://pm.zhcxkj.com/zentao/bug-view-35741.html
重复BUG