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

[步骤]

[结果]

CODE:N1955462
Error:16_207_1_-2146232060
SQL:
                SELECT * FROM (
                    SELECT ROW_NUMBER() OVER (ORDER BY  AddTime DESC) AS [PageIndex] ,* FROM (SELECT ofpe.ID,ofpe.PackageID,op.MergerPackageNo,op.LogisticsOrderNo,op.TrackNumber,op.TransportID,ts.TransportName,ofpe.OldBillingWeight,ofpe.ActualBillingWeight,ofpe.OldFreight,
                                      ofpe.ActualFreight,ofpe.OrderRevenueFee,ofpe.OrderExpenditureFee,ofpe.GrossProfitMargin,ofpe.DealResult,ofpe.AddAdminName,ofpe.AddTime,ol.Currency,ofpe.ShippingFeeDealStatus,ofpe.Remarks,
                                      ofpe.PackageLength,ofpe.PackageWide,ofpe.PackageHeight,ofpe.LastUpdateAdminName,ofpe.LastUpdateTime FROM RB_OrderFreightAndProfitMargin_EstimateList ofpe WITH(nolock) INNER JOIN dbo.RB_Procurement_Order_Package op(NOLOCK) ON ofpe.PackageID=op.ID AND ofpe.CustomerID=op.CustomerID
                                             INNER JOIN RB_OrderInfo ol(NOLOCK) ON op.MergerPackageNo=ol.OrderCode AND op.CustomerID=ol.CustomerID
                                             INNER JOIN RB_OrderSource os(NOLOCK) ON ol.OrderSourceID=os.ID AND ol.CustomerID=os.CustomerID
                                             INNER JOIN dbo.RB_Transport ts(NOLOCK) ON op.TransportID=ts.ID AND op.CustomerID=ts.CustomerID
                                             LEFT JOIN RB_Admin rba WITH(NOLOCK) ON rba.CustomerID = os.CustomerID AND rba.ID = os.SaleAdminID
                                             LEFT JOIN RB_BusinessTeam bt WITH(NOLOCK)  ON bt.CustomerID = os.CustomerID AND bt.ID = rba.BusinessTeamID WHERE  ofpe.CustomerID=@CustomerID AND ofpe.AddTime>=@ImportTimeWithStart AND ofpe.AddTime<=@ImportTimeWithEnd) AS TempTable 
                ) AS  PagerTable
                WHERE PagerTable.[PageIndex] BETWEEN 1 AND 2 
PARAMS:@CustomerID = 666 ,@ImportTimeWithStart = 2021/7/1 18:55:31 ,@ImportTimeWithEnd = 2022/7/14 19:55:31 ,
MESSAGE:Invalid column name 'PackageLength'.
Invalid column name 'PackageWide'.
Invalid column name 'PackageHeight'.
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.DAL.DBOperator.Query(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtendV2.Generate.Order.RB_OrderFreightAndProfitMargin_EstimateListExtendV2.GetOrderFreightAndProfitMarginPagerList(CM_GetOrderFreightAndProfitMarginPagerParam parameters, Int32& recordCount, String& sqlQueryCriteria, List`1& sqlParameterArray)
   在 PandaBuy.ERP.Web.IrobotBox.Order.Order_Freight_ProfitMargin_List.BindData()
   在 PandaBuy.ERP.Web.IrobotBox.Order.Order_Freight_ProfitMargin_List.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.EventHandler.Invoke(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_order_order_freight_profitmargin_list_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)

[期望]