| | |
| | | public String text1 { get; set; } // 对象 |
| | | public String val1 { get; set; } // 值 |
| | | public String RawAccountId { get; set; } |
| | | public Boolean checkexact { get; set; } // 20230110 gzw 订单号精确查询用 |
| | | public AssetModifyBelongsChange__c ambc { get; set; } |
| | | public static List<SelectOption> textOpts { get; private set; } |
| | | //public static List<SelectOption> changeReasonOpts { get; private set; } |
| | |
| | | } |
| | | // 画面初始化 |
| | | public void init() { |
| | | checkexact = false; |
| | | |
| | | if (Id != null && Id != '' && statusEdit == '' && statusEdit == null) { |
| | | editAble = false; |
| | |
| | | } |
| | | String soql = 'select Id,name,SerialNumber,Asset_situation__c,Order_No__c,Account.Name,Status,Installation_Site__c,CurrentContract__c from Asset where AccountId = \'' + RawAccountId + '\''; |
| | | if (!String.isBlank(text1)) { |
| | | |
| | | if (text1 == 'Order_No__c' && checkexact) { |
| | | soql += ' AND (' + text1 + ' = \'' + String.escapeSingleQuotes(val1) + '\' )'; |
| | | }else{ |
| | | soql += ' AND (' + text1 + ' like \'%' + String.escapeSingleQuotes(val1.replaceAll('%', '\\%')) + '%\' )'; |
| | | } |
| | | } |
| | | soql += ' limit 1000'; |
| | | return soql; |
| | | } |