From b5c5eb130ca0848124f9d136af4be142ad5aac07 Mon Sep 17 00:00:00 2001 From: binxie <137736985@qq.com> Date: 星期一, 26 六月 2023 14:42:02 +0800 Subject: [PATCH] backup0626 --- force-app/main/default/classes/LexSearchHospitalController.cls | 21 +++++++++++---------- 1 files changed, 11 insertions(+), 10 deletions(-) diff --git a/force-app/main/default/classes/LexSearchHospitalController.cls b/force-app/main/default/classes/LexSearchHospitalController.cls index 912d15c..147544e 100644 --- a/force-app/main/default/classes/LexSearchHospitalController.cls +++ b/force-app/main/default/classes/LexSearchHospitalController.cls @@ -1,15 +1,16 @@ public without sharing class LexSearchHospitalController { + @AuraEnabled - public static Results init() { + public static Results init(){ Results results = new Results(); try { - User useracc = [SELECT accountid, UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId()]; + User useracc = [SELECT accountid,UserPro_Type__c FROM user WHERE id = :UserInfo.getUserId() ]; String accountId = Useracc.accountid; String soql = 'SELECT id,Name,State_Master__c,State_Master__r.Name,Address__c FROM Account'; - soql += ' where id in (SELECT Hospital__c FROM hospitalprice__c WHERE account__c = :accountId) '; + soql += ' where id in (SELECT Hospital__c FROM hospitalprice__c WHERE account__c = :accountId) ' ; soql += ' order by Name desc limit 100'; results.attList = Database.query(soql); - results.result = 'Success'; + results.result = 'Success'; } catch (Exception e) { results.result = 'Fail'; results.errorMsg = e.getLineNumber() + '---' + e.getMessage(); @@ -18,7 +19,7 @@ } @AuraEnabled - public static Results searchHospital(String searchName, String accountId) { + public static Results searchHospital(String searchName, String accountId){ Results results = new Results(); try { results.attList = Database.query(makeSoql(searchName, accountId)); @@ -30,16 +31,16 @@ return results; } - private static String makeSoql(String searchName, String accountId) { + private static String makeSoql(String searchName,String accountId){ String soql = 'SELECT id,Name,State_Master__c,State_Master__r.Name,Address__c FROM Account'; - soql += ' where id in (SELECT Hospital__c FROM hospitalprice__c WHERE account__c = :accountId) '; - if (String.isNotBlank(searchName)) { - soql += ' AND Name like \'%' + searchName + '%\''; + soql += ' where id in (SELECT Hospital__c FROM hospitalprice__c WHERE account__c = :accountId) ' ; + if(String.isNotBlank(searchName)){ + soql += ' AND Name like \'%' + searchName+ '%\''; } soql += ' order by Name desc limit 100'; return soql; } - + public class Results { @AuraEnabled public String result; -- Gitblit v1.9.1