日志抬头：0f11dc35-b680-4358-b2e3-7fc228c662f2
业务单号：
记录时间：2026-02-23 08:22:31
日志内容：{"Code":"2602230822313","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 103)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 103)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"f89a4888-5839-4974-9644-95a1d7ee64fd\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 103)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"1205\",\"HelpLink.BaseHelpUrl\":\"http://go.microsoft.com/fwlink\",\"HelpLink.LinkId\":\"20476\"},\"InnerException\":null,\"HelpURL\":null,\"StackTraceString\":\"   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\\r\\n   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\\r\\n   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\\r\\n   在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\\r\\n   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\\r\\n   在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.Execute(String sql, SqlTransaction sqlTran, CommandType cmdType, SqlParameter[] sqlParms)\",\"RemoteStackTraceString\":null,\"RemoteStackIndex\":0,\"ExceptionMethod\":\"8\\nOnError\\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\\nSystem.Data.SqlClient.SqlConnection\\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])\",\"HResult\":-2146232060,\"Source\":\".Net SqlClient Data Provider\",\"WatsonBuckets\":null}"}