2025/11/6 15:24:30 GetRefundOrderData sql：SELECT r.*,pa.Accounts AccountName,p.PlatformName,pa.PersonInCharge,pac.PaymentPlatformId,pac.PaymentLoginId ReceivingAccount
FROM SinadealTradeDB..RefundOrder r
left join ServiceCenter..PlatformAccounts pa on pa.RecordId=r.AccountId
left join ServiceCenter..Platform p on p.RecordId=pa.PlatformId
left join ServiceCenter..StorePaymentAccountConfiguration pac on pac.AccountId=r.AccountId and pac.PayMethod=r.OrderPayMethod and pac.[Status]=1
where pa.TenantCode='HKZF' AND CHARINDEX(''123717718_102224-A',r.PONo)>0 AND r.Status='0'
order by r.ApplicationTime DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;
报错：System.Exception: SELECT r.*,pa.Accounts AccountName,p.PlatformName,pa.PersonInCharge,pac.PaymentPlatformId,pac.PaymentLoginId ReceivingAccount
FROM SinadealTradeDB..RefundOrder r
left join ServiceCenter..PlatformAccounts pa on pa.RecordId=r.AccountId
left join ServiceCenter..Platform p on p.RecordId=pa.PlatformId
left join ServiceCenter..StorePaymentAccountConfiguration pac on pac.AccountId=r.AccountId and pac.PayMethod=r.OrderPayMethod and pac.[Status]=1
where pa.TenantCode='HKZF' AND CHARINDEX(''123717718_102224-A',r.PONo)>0 AND r.Status='0'
order by r.ApplicationTime DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;“123717718”附近有语法错误。
字符串 '
order by r.ApplicationTime DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;' 后的引号不完整。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435
   在 PDSys.Domain.Services.RefundRepository.<GetRefundOrderData>d__11.MoveNext() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\RefundRepository.cs:行号 111