DateTime:2025-11-15 08:47:24 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 System.Dynamic.UpdateDelegates.UpdateAndExecute8[T0,T1,T2,T3,T4,T5,T6,T7,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5, T6 arg6, T7 arg7) 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 08:47:28 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 08:47:40 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 08:47:45 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 08:48:24 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 08:51:30 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 09:15:39 Message:SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2402' ORDER BY pa.Accounts执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfoCount(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 342 在 CallSite.Target(Closure , CallSite , YS_ItemMallManager , String , Object , Object , String , Boolean , Int32 , Int32 ) 在 System.Dynamic.UpdateDelegates.UpdateAndExecute8[T0,T1,T2,T3,T4,T5,T6,T7,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5, T6 arg6, T7 arg7) 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10639 DateTime:2025-11-15 09:15:39 Message:SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2194' ORDER BY pa.Accounts执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfoCount(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 342 在 CallSite.Target(Closure , CallSite , YS_ItemMallManager , String , Object , Object , String , Boolean , Int32 , Int32 ) 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10639 DateTime:2025-11-15 09:15:51 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2194') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 09:23:47 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2194') fms where fms.num between 1 and 30执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638 DateTime:2025-11-15 09:28:52 Message:SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2776' ORDER BY pa.Accounts执行超时已过期。完成操作之前已超时或服务器未响应。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfoCount(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 342 在 CallSite.Target(Closure , CallSite , YS_ItemMallManager , String , Object , Object , String , Boolean , Int32 , Int32 ) 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10639 DateTime:2025-11-15 10:30:04 Message:select * from (SELECT ROW_NUMBER() OVER(ORDER BY p.PlatformName) AS num,pa.PlatformId,p.PlatformName,p.APISyncFlag,pa.RecordId AccountId,pa.Accounts,pa.OpTime,pa.OpUser,pa.OpResult,a.[Status],a.SyncType,ys.IsAPIDocked,ys.IsAuthorizationExpire FROM ServiceCenter..PlatformAccounts pa INNER JOIN ServiceCenter..Platform p ON pa.PlatformId=p.RecordId and pa.TenantCode='HKZF' LEFT JOIN ServiceCenter..YS_ItemMall ys on ys.PARecordId=pa.RecordId LEFT JOIN (SELECT ROW_NUMBER() OVER(PARTITION BY PlatformAccountId ORDER BY CreateTime DESC) AS num,[Status],PlatformAccountId,SyncType FROM ServiceCenter..OrderSyncQueue WHERE CreateTime>=GETDATE()-7) a ON a.PlatformAccountId=pa.RecordId AND a.num=1 INNER join ServiceCenter..UserPrivilege as b on pa.RecordId=b.PARecordId WHERE pa.Valid=1 AND p.Valid=1 AND p.IsDocking=1 AND p.OrderSynchronization=2 and ys.IsAPIDocked=1 and ys.IsAuthorizationExpire=0 AND 1 IN (select * from SinadealTradeDB..dnt_split(p.DockingType,',')) AND b.UserId='2428') fms where fms.num between 1 and 30无法继续执行,因为会话处于终止状态。 UrlReferrer: Url: post: cookies: ip: header: Source:Vayava.Common StackTrace: 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435 在 Vayava.Erp.Dal.YS_ItemMallService.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ItemMallService.cs:行号 393 在 Vayava.Erp.Bll.YS_ItemMallManager.GetOrderDownloadAPIInfo(String TenantCode, Int32 PlatformID, Int32 AccountId, String InputUser, Boolean userPrivl, Int32 currentPage, Int32 pageSize) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ItemMallManager.cs:行号 328 在 Vayava.Erp.Controllers.Order.OrderController.SearchOrderedAccountsInfo() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\Vayava.Erp.Controllers\Order\OrderController.cs:行号 10638