日志抬头：6895c966-1a85-4810-bfdd-7460bf6e7832
业务单号：
记录时间：2026-03-16 00:15:03
日志内容：{"Code":"260316001503174","SqlText":"select   c.guid \r\nfrom Ord_Order_dtl c \r\nleft join Ord_OrderImport_dtl dtl on dtl.code='DS0025P37260314298' and dtl.barcode=c.barcode and dtl.pid=c.pid \r\nwhere c.code='DS0025P37260314298'  and dtl.BarCode_API='1765674128825'   \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='DS0025P37260314298') ","Message":"事务(进程 ID 121)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 121)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"290c01a3-94f5-4d13-9c95-d18414b8a1a0\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 121)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：d3acebed-2b92-46e7-9b88-c57fe7d194f1
业务单号：
记录时间：2026-03-16 17:05:31
日志内容：{"Code":"260316170531343","SqlText":"insert into Ord_DeliverOrder(Code ,CurrentProcessCode ,CurrentNodeCode ,CurrentCodeRule ,SourceProcessCode ,SourceCode ,Remark ,BillState ,zdUserCode ,FromShop ,SumjhQuantity ,SumjhAmount ,Address ,Recipients ,Mobile ,ToShop ,QHtype,BusinessDate,LastCode,Province,City,County,OrderState,Oldcode,FromCustomer,FromChannel,ToCustomer,ToChannel,SysIS,SysIS2,Town,ExpressCOM,ExpressNO,PayDateTime,LatestDeliveryTime)  \r\n            SELECT 'DSTH01D12260316248', 'D12', Ord_Order.SourceProcessCode, '', Ord_Order.SourceProcessCode, Ord_Order.SourceCode, Ord_Order.Remark, '05', Ord_Order.zdUserCode, 'DSTH01','1' ,'418.00' ,Ord_Order.Address , CASE Ord_Order.QHtype WHEN '2' THEN BD_Shop.Head ELSE Ord_Order.Recipients END Recipients ,CASE Ord_Order.QHtype WHEN '2' THEN BD_Shop.Mobile ELSE Ord_Order.Mobile END Mobile ,'DS0066' ,QHtype,BusinessDate,Ord_Order.code,Ord_Order.Province,Ord_Order.City,Ord_Order.County,'210' ,Ord_Order.Oldcode,'','000',Ord_Order.FromCustomer,Ord_Order.FromChannel,'0','0',Ord_Order.Town,isnull(Ord_Order.ExpressCOM,''),isnull(Ord_Order.ExpressNO,''),Ord_Order.PayDateTime,Ord_Order.LatestDeliveryTime\r\n\r\n                FROM Ord_Order  left join BD_Shop on Ord_Order.FromShop=BD_Shop.Code where Ord_Order.Code = 'DS0066P50260316040';\r\ninsert into Ord_DeliverOrder_dtl(Code,SourceCode,Goodscode,BarCode,jhQuantity,Quantity,Discount,Price,Amount,jhAmount,OrderState,refundQuantity,jhrefundQuantity,LastCode,Pid) select 'DSTH01D12260316248', SourceCode, Goodscode, BarCode, count(BarCode) jhQuantity,0, sum(Discount)/count(BarCode), sum(Price)/count(BarCode), 0,sum(jhAmount),'20',0,0,code,min(Pid) Pid FROM Ord_Order_dtl where code='DS0066P50260316040' and Guid in ('eda0a2c5-c52a-4834-89a1-a94abbb72005') GROUP BY Goodscode, BarCode,SourceCode,code ;update Ord_Order_dtl set OrderNum='DSTH01D12260316248',number=number+1,OrderState='20',toShop='DSTH01' where code='DS0066P50260316040' and Guid in ('eda0a2c5-c52a-4834-89a1-a94abbb72005');update Ord_Order set BillState='08',CurrentNodeCode=SourceProcessCode where code='DS0066P50260316040'; insert into Ord_DOrderLog(Code,SourceProcessCode,SourceCode,Remark,BillState,Guid,BarCode,FromShop,zdUserCode) select Code, 'D11', 'DSTH01D12260316248', '店铺分配成功', '99', Guid, BarCode, 'DSTH01','自动匹配' from Ord_Order_dtl  where  Guid in ('eda0a2c5-c52a-4834-89a1-a94abbb72005') INSERT INTO Ord_OrderStockOccupy(Code, CurrentProcessCode, CurrentNodeCode, SourceProcessCode, SourceCode, LastProcessCode, LastCode, LastNodeCode, Remark, BillState, Guid, BarCode, FromShop, ToShop, SumQuantity, OrderType) select a.code,b.CurrentProcessCode,b.CurrentNodeCode, SourceProcessCode,b.SourceCode,LastProcessCode,b.LastCode,LastNodeCode,Remark,BillState,a.Guid, a.BarCode, 'DSTH01',b.fromshop,1,'B2C' from Ord_Order_dtl a left join Ord_Order b on a.code = b.code where a.Guid in ('eda0a2c5-c52a-4834-89a1-a94abbb72005') declare @OrderStateAuditfp nvarchar(50);\r\n declare @Orderfpnumber int;\r\n set @Orderfpnumber=(select count (distinct ToShop) from Ord_Order_dtl where code='DS0066P50260316040' and ToShop<>'')\r\nif exists (select code from  Ord_Order_dtl where code='DS0066P50260316040' and OrderState='100')\r\nbegin\r\nset  @OrderStateAuditfp='100'\r\nend\r\n else\r\nbegin\r\nset  @OrderStateAuditfp=(select top 1 OrderState from Ord_Order_dtl where code='DS0066P50260316040' order by convert(int,OrderState) asc)\r\nend\r\n\r\n\r\nupdate Ord_Order set number=@Orderfpnumber,OrderState=@OrderStateAuditfp where code='DS0066P50260316040';","Message":"不能在具有唯一索引“IX_Ord_DeliverOrder_code”的对象“dbo.Ord_DeliverOrder”中插入重复键的行。重复键值为 (DSTH01D12260316248)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“IX_Ord_DeliverOrder_code”的对象“dbo.Ord_DeliverOrder”中插入重复键的行。重复键值为 (DSTH01D12260316248)。\",\"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\":\"54efe8fc-0f85-4255-94d6-0165423207e7\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_DeliverOrder_code”的对象“dbo.Ord_DeliverOrder”中插入重复键的行。重复键值为 (DSTH01D12260316248)。\\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}"}