深圳智汇创想科技有限公司

[步骤]

   在 RB.DALExtend.Generate.RB_SysPaypalAccountExtend.GetAccountByOrderSourceID(GetAccountByOrderSourceIDParameters param)
   在 Biz.Ebay.EbayOrderDownload.ExecuteTask(ParallelPlatformListInfo parameters, String& msg)

SELECT paypal.OrderSourceID,
       account.PaypalAccount,
       account.APIUsername,
       account.APIPassword,
       account.APISignature,
       paypal.EbayReceiptEmail
FROM   RB_Ebay_AddItem_PayPal paypal
       LEFT JOIN RB_SysPaypalAccount account
         ON paypal.CustomerID = account.CustomerId
            AND paypal.PayPal = account.PaypalAccount
WHERE  paypal.CustomerID = 1
       AND paypal.OrderSourceID = 19598
       AND Isnull(account.PaypalAccount, '') <> ''
       AND Isnull(account.APIUsername, '') <> ''
       AND Isnull(account.APIPassword, '') <> ''
       AND Isnull(account.APISignature, '') <> ''
       AND paypal.IsActive = 1
       AND account.Environment = 'live'

[结果]

[期望]

补充nolock 减少阻塞