日志抬头：630abcf0-34f6-499c-9f27-709a8ac25f1c
业务单号：
记录时间：2026-04-14 14:06:11
日志内容：{"Code":"260414140611027","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 ('DS0025P05260414147','P05','P37','P37','DS0025P37260408137','D11','DS0025P37260408137','02','0','','API','DS0025','1','95.0000000000000','','DSTH02','95.0000000000000','1','','','','2','','','四川省成都市青白江区青白江区','260408-016483622500769','4','','','20014483736934','','000','','000')delete Ord_Refund_dtl2 where code='DS0025P05260414147'; insert into Ord_Refund_dtl2(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,Guid,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney,Oldcode) values ('DS0025P05260414147','DS0025P37260408137','DS0025P37260408137','YA25211L022','YA25211L022750130','1','19.00','95.00','95.0000000000000','137c0946-e28c-4e37-a5eb-3a846178d12c','95.00','95.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','D6F370AB-6ECC-415B-9FEF-E27B570E045D')delete Ord_Refund_dtl where code='DS0025P05260414147'; insert into Ord_Refund_dtl(Code,LastCode,SourceCode,Goodscode,BarCode,Quantity,Discount,Price,Amount,NowPrice,RealAmount,CashCoupon,BalanceMoney,CashbackMoney,IncomeMoney) values ('DS0025P05260414147','DS0025P37260408137','DS0025P37260408137','YA25211L022','YA25211L022750130','1','19.00','95.00','95.0000000000000','95.00','95.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000','0.0000000000000')","Message":"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (20014483736934)。\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”中插入重复键的行。重复键值为 (20014483736934)。\",\"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\":\"a83845fe-fff9-4115-9df6-f26abb6c11cd\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_Ord_Refund_PID”的对象“dbo.Ord_Refund”中插入重复键的行。重复键值为 (20014483736934)。\\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}"}
日志抬头：8b566fae-dab2-4eeb-ac0d-edbc652ed910
业务单号：
记录时间：2026-04-14 22:50:18
日志内容：{"Code":"260414225018214","SqlText":"\r\nINSERT INTO API_DRP_OrderRefund(orderstate,afterStatus,orderNo,code,OldCode,Platform,Platform2,FromShop,CreateDateTime,JsonXml,createTime,modifyTime,ExpressCom,ExpressNo,ordertype)\r\nvalues('CANCEL','SUCCESS','6925594689342569883','147442801486623852','147442801486623852','DouDian','DouDian','DS0094','2026/4/14 22:50:17','%7b%22interceptStatus%22%3anull%2c%22interceptInvestor%22%3anull%2c%22posCode%22%3a%221976949788639002624%22%2c%22refPlatform%22%3a%22DY%22%2c%22refType%22%3anull%2c%22openSellerNick%22%3anull%2c%22openBuyerNick%22%3anull%2c%22refAid%22%3a%22147442801486623852%22%2c%22refOid%22%3a%226925594689342569883%22%2c%22type%22%3a%22REFUND%22%2c%22orderStatus%22%3a%22CANCEL%22%2c%22refundPhase%22%3anull%2c%22totalFee%22%3anull%2c%22refundFee%22%3anull%2c%22logisticsCompany%22%3a%22%22%2c%22logisticsOrderNo%22%3a%22%22%2c%22createTime%22%3a%221776178210000%22%2c%22updateTime%22%3a%221776178217000%22%2c%22refundCreateTime%22%3a%221776178210000%22%2c%22refundUpdateTime%22%3a%221776178212000%22%2c%22reason%22%3a%22%e5%a4%9a%e6%8b%8d%2f%e9%94%99%e6%8b%8d%2f%e4%b8%8d%e6%83%b3%e8%a6%81%22%2c%22desc%22%3a%22%22%2c%22afterStatus%22%3a%22SUCCESS%22%2c%22statusCode%22%3a%2212%22%2c%22statusName%22%3a%22%e6%9c%aa%e5%8f%91%e8%b4%a7%e9%80%80%e6%ac%be%22%2c%22refundTime%22%3anull%2c%22lines%22%3a%5b%7b%22refAid%22%3a%22147442801486623852%22%2c%22refAlId%22%3a%22147442801486623852%22%2c%22refOid%22%3a%226925594689342569883%22%2c%22refOlId%22%3a%226925594689342569883%22%2c%22totalFee%22%3a59.84%2c%22refundFee%22%3a59.84%2c%22price%22%3a69.00%2c%22num%22%3a1%2c%22refSpuId%22%3a%223801080423392608504%22%2c%22refSkuId%22%3a%223638547441522946%22%2c%22outerId%22%3a%22YA25335Q008750130%22%2c%22title%22%3a%22%e5%b7%b4%e6%81%a9%e9%a3%8e%e9%ab%98%e8%85%b0%e4%b8%ad%e9%95%bf%e5%8d%8a%e8%ba%ab%e8%a3%99%e9%bb%91%e8%89%b2%e5%a4%8d%e5%8f%a4%e9%ab%98%e8%85%b0%e9%80%9a%e5%8b%a4%e7%ba%af%e8%89%b2%e5%8d%8a%e8%a3%99%e7%99%be%e6%90%adYA25335Q008%22%2c%22refBoughtSkuId%22%3a%223638547441522946%22%2c%22refundStatus%22%3a%22SUCCESS%22%2c%22type%22%3a0.0%7d%5d%7d','2026/4/14 22:50:10','2026/4/14 22:50:12','','','0');","Message":"不能在具有唯一索引“IX_API_DRP_OrderRefund_Code”的对象“dbo.API_DRP_OrderRefund”中插入重复键的行。重复键值为 (147442801486623852)。\r\n语句已终止。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":2601,\"State\":1,\"Class\":14,\"Server\":\"172.18.63.40,4001\",\"Message\":\"不能在具有唯一索引“IX_API_DRP_OrderRefund_Code”的对象“dbo.API_DRP_OrderRefund”中插入重复键的行。重复键值为 (147442801486623852)。\",\"Procedure\":\"\",\"LineNumber\":2},{\"Source\":\".Net SqlClient Data Provider\",\"Number\":3621,\"State\":0,\"Class\":0,\"Server\":\"172.18.63.40,4001\",\"Message\":\"语句已终止。\",\"Procedure\":\"\",\"LineNumber\":2}],\"ClientConnectionId\":\"89635656-a092-4e0e-8241-b685d41b3b4c\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"不能在具有唯一索引“IX_API_DRP_OrderRefund_Code”的对象“dbo.API_DRP_OrderRefund”中插入重复键的行。重复键值为 (147442801486623852)。\\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}"}