| | |
| | | soql += ' AND Status = \'使用中\''; |
| | | } |
| | | // fxk 2021/8/4 新加 Start |
| | | soql += ' and (Asset.CurrentContract_F__r.Status__c != \'契約\' or (Asset.CurrentContract_F__r.Status__c = \'契約\' and Asset.CurrentContract_F_asset__r.Check_object__c = false) or Asset.CurrentContract_F__c = null) '; |
| | | soql += ' and (Asset.CurrentContract_F__c = \'a0H100000156VLH\' OR Asset.CurrentContract_F__r.Status__c != \'契約\' or (Asset.CurrentContract_F__r.Status__c = \'契約\' and Asset.CurrentContract_F_asset__r.Check_object__c = false) or (Asset.CurrentContract_F__r.Status__c = \'契約\' and Asset.CurrentContract_F__r.Effective_Status__c = \'无效\') or Asset.CurrentContract_F__c = null) '; |
| | | // fxk 2021/8/4 新加 End |
| | | if (assetSerialNumberList.size() > 0) { |
| | | soql += ' AND SerialNumber not in ' + sqlTail; |