日志抬头：b3f0785d-41d1-4aa9-94e6-9c4e1a0a189f
业务单号：
记录时间：2026-03-23 13:30:46
日志内容：{"Code":"260323133046605","SqlText":"insert into Ord_Refund(Code,CurrentProcessCode,CurrentNodeCode,SourceProcessCode,SourceCode,LastProcessCode,LastCode,LastNodeCode,BillState,Remark,zdUserCode,FromShop,SumQuantity,SumAmount,Vip,ToShop,RealAmount,RefundType,ExpressCOM,ExpressNO,Remark2,afterSaleType,Recipients,Mobile,Address,Oldcode,Initiator,SerialNum,transaction_id,Pid,FromCustomer,FromChannel,ToCustomer,ToChannel) values ('DS0001P05260323033','P05','P35','P35','DS0001P35260321011','D11','DS0001P35260321011','02','0','','API','DS0001','1','64.0000000000000','','','64.0000000000000','0','','','','2','','','浙江省温州市瓯海区梧田街道','4502188262065181027','4','','','380892674083543158','','000','','')delete Ord_Refund_dtl2 where code='DS0001P05260323033'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0001P05260323033','DS0001P35260321011','DS0001P35260321011','YA25221Z003','YA25221Z003710125','1','18.90','64.00','64.0000000000000','400523f6-16d1-4aac-9e52-9d0676cb72a5','64.00','64.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','8900FBAD-5A53-48DC-8EF6-4E2B04045FD3')delete Ord_Refund_dtl where code='DS0001P05260323033'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0001P05260323033','DS0001P35260321011','DS0001P35260321011','YA25221Z003','YA25221Z003710125','1','18.90','64.00','64.0000000000000','64.00','64.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (380892674083543158)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (380892674083543158)。\",\"Procedure\":\"\",\"LineNumber\":1},{\"Source\":\".Net SqlClient Data Provider\",\"Number\":3621,\"State\":0,\"Class\":0,\"Server\":\"172.18.63.40,4001\",\"Message\":\"语句已终止。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"26fe9221-bfe7-460b-9282-8e894ab56d61\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (380892674083543158)。\\r\\n语句已终止。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"2601\",\"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}"}
日志抬头：c426ac4e-634d-415c-b6fa-66d4f3f3b708
业务单号：
记录时间：2026-03-23 23:45:43
日志内容：{"Code":"260323234543704","SqlText":"select   c.guid \r\nfrom Ord_Order_dtl c \r\nleft join Ord_OrderImport_dtl dtl on dtl.code='DS0025P37260311345' and dtl.barcode=c.barcode and dtl.pid=c.pid \r\nwhere c.code='DS0025P37260311345'  and dtl.BarCode_API='1737951668616'   \r\nand c.guid not in (select b.guid from  Ord_Refund a left join Ord_Refund_dtl2 b on a.code=b.code where a.BillState!='95'  and a.SourceCode='DS0025P37260311345') ","Message":"事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"682ae3da-6233-4f89-a0f0-3ca27f0e796f\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 70)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)\\r\\n   在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)\\r\\n   在 System.Data.SqlClient.SqlDataReader.Read()\\r\\n   在 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)\\r\\n   在 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)\\r\\n   在 System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)\\r\\n   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\\r\\n   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\\r\\n   在 QianHui.Infrastructure.SqlServerHelper.QuaryDataSet(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}"}
日志抬头：d3e9b4d5-7416-49be-9f46-3d705661d185
业务单号：
记录时间：2026-03-23 23:45:43
日志内容：{"Code":"260323234543956","SqlText":"insert into Ord_Refund(Code,CurrentProcessCode,CurrentNodeCode,SourceProcessCode,SourceCode,LastProcessCode,LastCode,LastNodeCode,BillState,Remark,zdUserCode,FromShop,SumQuantity,SumAmount,Vip,ToShop,RealAmount,RefundType,ExpressCOM,ExpressNO,Remark2,afterSaleType,Recipients,Mobile,Address,Oldcode,Initiator,SerialNum,transaction_id,Pid,FromCustomer,FromChannel,ToCustomer,ToChannel) values ('DS0094P05260323073','P05','P36','P36','DS0094P36260310037','D11','DS0094P36260310037','02','0','','API','DS0094','1','59.0000000000000','','DSTH02','59.0000000000000','1','','','','2','','','贵州省遵义市杉王街道习水县','6924778274267037000','4','','','147410966312114347','','000','','000')delete Ord_Refund_dtl2 where code='DS0094P05260323073'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0094P05260323073','DS0094P36260310037','DS0094P36260310037','RL25438W001','RL25438W001710125','1','10.80','59.00','59.0000000000000','76ccc593-8188-45cf-93e9-fbc2f21f8296','59.00','59.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','692B9340-BB8B-4FC0-8E89-79BD464E5164')delete Ord_Refund_dtl where code='DS0094P05260323073'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0094P05260323073','DS0094P36260310037','DS0094P36260310037','RL25438W001','RL25438W001710125','1','10.80','59.00','59.0000000000000','59.00','59.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260323073)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260323073)。\",\"Procedure\":\"\",\"LineNumber\":1},{\"Source\":\".Net SqlClient Data Provider\",\"Number\":3621,\"State\":0,\"Class\":0,\"Server\":\"172.18.63.40,4001\",\"Message\":\"语句已终止。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"682ae3da-6233-4f89-a0f0-3ca27f0e796f\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_WY”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (DS0094P05260323073)。\\r\\n语句已终止。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"2601\",\"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}"}