| | |
|---|
| | | String msoql = makeSoqlinventory(); |
|---|
| | | initStandardController(msoql); |
|---|
| | | product2Selected = Database.query(msoql); |
|---|
| | | System.debug('product2Selected.size() = ' + product2Selected.size()); |
|---|
| | | //product2Selected = product2s(); |
|---|
| | | if (String.isBlank(arriveorder)) { |
|---|
| | | EditDelCommitBtnDisabled = true; |
|---|
| | |
|---|
| | | private String makeSoqlinventory(){ |
|---|
| | | String sqlTail = '(\''; |
|---|
| | | for(Integer i = 0 ; i< zaikuId.size();i++){ |
|---|
| | | if(zaikuId[i] != null){ //deloitte-zhj 2023-04-24 |
|---|
| | | if(i<zaikuId.size()-1){ |
|---|
| | | sqlTail += zaikuId[i]+'\',\''; |
|---|
| | | }else{ |
|---|
| | | sqlTail += zaikuId[i]; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | sqlTail += '\')'; |
|---|
| | | String msoql = 'SELECT Id, Name,Name__c,Intra_Trade_List_RMB__c,Asset_Model_No__c,Product2__r.Packing_list_manual__c,SFDA_Status__c,Product2__r.SFDA_Approbation_No__c,Product2__r.SFDA_Expiration_Date__c,Category3__c,Category4__c,Category5__c FROM Product2__c '; |
|---|
| | | //msoql += ' WHERE Estimation_Entry_Possibility__c = \'○\''; |
|---|
