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

[步骤]

[期望]

CODE:O0952041
Error:15_102_1_-2146232060
SQL:SELECT OS.ID,
                               Cast(OS.OrderSourceType AS NVARCHAR(100)) AS 订单渠道类型,
                               OS.OrderSourceName                        AS 订单来源渠道名称,
                               OS.RealShopName                           AS 真实店铺名称,
                               EC.Country_cn                             AS 所在国家,
                               CASE
                                 WHEN Isnull(OS.VATNumber, '') = '' THEN ''
                                 ELSE Isnull(OS.VATNumber, '') + '&'
                               END + Cast(CASE
                                            WHEN Isnull(OS.VATRate, '') = '' THEN '0.00'
                                            ELSE Round(OS.VATRate, 2)
                                          END AS NVARCHAR(100)) + '%'    AS VAT税号VAT税率,
                               CASE         
                                   WHEN Isnull(CPM.Name, '') = '' THEN ''
                                 ELSE Isnull(CPM.Name, '') + '-'
                               END + Isnull(CPM.CorporateNameCN, '')     AS 清关人,
                               CASE
                                 WHEN Isnull(BT.BusinessTeamName, '') = '' THEN Isnull(RBA.UserName, '')
                                 ELSE Isnull(BT.BusinessTeamName, '') + ':' + Isnull(RBA.UserName, '')
                               END                                       AS 业务员负责人,
                               ''                                        AS 业务员,
                               CASE
                                 WHEN Isnull(OS.ServiceAdminName, '') = '' THEN ''
                                      ELSE
                                   CASE
                                     WHEN Isnull(dp.DepartmentName, '') = '' THEN ''
                                     ELSE Isnull(dp.DepartmentName, '') + '-'
                                   END
                               END + Isnull(OS.ServiceAdminName, '')     AS 客服小组客服,
                               CASE
                                 WHEN OS.WareHouseAccountType = 1 THEN '按来源渠道'
                                 WHEN OS.WareHouseAccountType = 2 THEN '按渠道sku'
                                 ELSE ''
                               END                                       AS 责任库存核算方式,
                               CASE
                                 WHEN Isnull(API.IsActive, 0) = 0 THEN ''
                                 ELSE '已授权'
                               END                                       AS 订单授权状态,
                               '' AS '渠道系统状态-修改前',
                               '' AS '渠道系统状态-修改后',
                               '' AS '修改时间',
                               CASE OS.SourceStatus
                                 WHEN 0 THEN '正常'
                                 WHEN 1 THEN '申诉中'
                                 WHEN 2 THEN '暂停'
                                 WHEN 3 THEN '注销'
                                 ELSE '' END '当前渠道系统状态'
                                 

                        FROM   RB_OrderSource OS WITH(nolock)
                             LEFT JOIN E_Country EC
                                 ON EC.Shorthand = OS.OrderSourceCountry
                               LEFT JOIN RB_Admin RBA
                                 ON RBA.CustomerID = OS.CustomerID
                                    AND RBA.ID = OS.SaleAdminID
                               LEFT JOIN RB_BusinessTeam BT
                                 ON BT.CustomerID = OS.CustomerID
                                    AND BT.ID = RBA.BusinessTeamID
                               LEFT JOIN RB_Admin RBAS
                                 ON RBAS.CustomerID = OS.CustomerID
                                    AND RBAS.ID = OS.ServiceAdminID
                               LEFT JOIN RB_Department dp
                                 ON dp.CustomerID = RBAS.CustomerID
                                    AND dp.ID = RBAS.DepartmentID
                               LEFT JOIN RB_OrderSource_EbayAmazonAPI API
                                 ON API.CustomerID = OS.CustomerID
                                       AND API.OrderSourceID = OS.ID
                               LEFT JOIN RB_OrderSource_EmailSet EMAIL
                                 ON EMAIL.CustomerID = OS.CustomerID
                                    AND EMAIL.OrderSourceID = OS.ID
                               LEFT JOIN RB_OrderSource_ReturnAddress ADS
                                 ON ADS.CustomerID = OS.CustomerID
                                    AND ADS.OrderSourceID = OS.ID
                               LEFT JOIN RB_WareHouse HOUSE
                                 ON HOUSE.CustomerID = OS.CustomerID
                                    AND HOUSE.ID = OS.DefaultWareHouseID
                               LEFT JOIN RB_CustomsPeopleManage CPM
                                 ON CPM.CustomerID = OS.CustomerID
                                    AND CPM.ID = OS.CustomsPeopleManageID
                               LEFT JOIN RB_Amazon_AdvertisementAuthorization ADA
                                 ON ADA.CustomerID = OS.CustomerID
                                    AND ADA.OrderSourceID = OS.ID
                                           LEFT JOIN RB_OrderSource_API AS EabyAPI
                                 ON EabyAPI.CustomerID = OS.CustomerID
                                    AND EabyAPI.OrderSourceID = OS.ID
                                
                        WHERE  OS.CustomerID = 1 AND ISNULL(OS.IsDelete,0)=0  AND OS.ID IN(SELECT LogTableID FROM RB_OrderSource_Log(nolock) WHERE LogTablename='RB_OrderSource' (Remark like '%状态的值由%' OR Remark LIKE '%批量设置渠道系统状态%')
                                                           AND CustomerID=OS.CustomerID AND AddTime<='2022-08-15 00:00:00'  AND AddTime<='2022-08-22 23:59:59')  ORDER BY ID DESC
MESSAGE:“(”附近有语法错误。
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)
   在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command)
   在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command)
   在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)   在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException  , String  )
   在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)
   在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task)
   在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task)
   在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)
   在 RB.Utility.TaskSmartManager`1.<>c__DisplayClass17_0.<TaskExecute>b__0()
   在 System.Threading.Tasks.Task.InnerInvoke()
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)
   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
   在 System.Threading.Tasks.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()
   在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()