public class QueuePageByAssetIdController extends CreateRelationListPagingCtrlBase{
    private Id asId;

    private String wher;        // and 4つ条件

    private Map<Id, String> queueConmentMap;

    //public Asset aset {get;private set;}
    public Rental_Apply_Equipment_Set_Detail__c raesd {get;private set;}

    public String modelNo {get;private set;}
    public Boolean isNotShow {get;private set;}
    public Integer inptNum {get; set;}
    public Integer inptNumStr {get; set;}
    public Boolean inputUpDownFlag {get; set;}

    public override Boolean getIsNeedRunSearch() {
        return false;
    }

    /* 選択されたデータ取得用Soql　Fromから*/
    public override String getSelectedDataSql() {
        // オブジェクトAPI名
        selectedDataSql = ' From Rental_Apply_Equipment_Set_Detail__c';
        selectedDataSql += ' where Queue_Number__c > 0 AND Fixture_Model_No_text__c = \'' + modelNo + '\'';
        selectedDataSql += ' AND Cancel_Select__c = false ' + wher;
        selectedDataSql += ' order by Queue_Number__c ASC nulls last';
        // 20220107 ljh update start
        /*Profile profileObj = [SELECT Id, Name FROM Profile WHERE Id =: UserInfo.getProfileId() LIMIT 1];
        // 只有系统管理员，页面上 排队No，排队时间，负责人 字段是显示可编辑状态
        if (profileObj == null || (profileObj != null && !profileObj.Name.contains('系统管理员'))) {
            myComponentController.columnRightRW.put('Queue_Number__c', 'r');
            myComponentController.columnRightRW.put('Queue_Day__c', 'r');
            myComponentController.columnRightRW.put('Queue_User__c', 'r');
        }*/
        // 20220107 ljh update end
        myComponentController.columnRightRW.put('Allow_Adjust_Queue_Flag__c', 'r');
        myComponentController.columnRightRW.put('jumpReason__c', 'r');
        return selectedDataSql;
    }

    public override String getOriginObjName() {
        // オブジェクトAPI名
        originObjName = 'Rental_Apply_Equipment_Set_Detail__c';
        return originObjName;
    }

    public override String getOriginObjColumns() {
        // 項目セット
        // 20211104 ljh 排队 start
        // originObjColumns =  'Id, Asset__c';
        originObjColumns =  'Id';
        // 20211104 ljh 排队 end
        return originObjColumns;
    }

    public override Integer getSearchNumMax() {
        //各ページに制御あれば、最大件数を指定する
        searchNumMax = Integer.valueOf(Label.Product_Select_Limit);
        return searchNumMax;
    }

    public override String getObjName() {
        // オブジェクトAPI名
        objName = 'Rental_Apply_Equipment_Set_Detail__c';
        return objName;
    }

    // ページコントローラに検索処理は、WhereSoql作成のみ、パラメータとして、コンポーネントに渡される
    public override String getSqlWhereStr() {
        sqlWhereStr = '';

        return sqlWhereStr;
    }

    public override String getColumnRightFieldSetName() {
        // 右の項目セット
        columnRightFieldSetName = 'QueueByAssetId';
        return columnRightFieldSetName;
    }

    public override String getColumnLeftFieldSetName() {
        // 左の項目セット
        columnLeftFieldSetName = '';
        return columnLeftFieldSetName;
    }

    public override List<String> getColumnFieldList() {
        // strColumus 里加 field
        return new String[]{'Is_Body_F__c', 'Rental_Apply__c'};
    }
    // 画面里直接可以输入的項目 List
    public override List<String> getWritableColumnFieldList() {
        return new List<String>{'Queue_Conment__c'};
    }

    public override String getRecordTypeId() {
        //ページレイアウトを収得するのレコードタイプ
        recordTypeId = '';
        return recordTypeId;
    }

    // getObjName 连 getOriginObjName 的 FK
    public override String getFKColumnField() {
        return null;
    }

    //public override
    public override void setViewList(List<sObject> queryList) {
        queueConmentMap = new Map<Id, String>();
        viewList = new List<WrapperInfo>();
        for (Integer i = 0; i < selectedData.size(); i++) {
            Rental_Apply_Equipment_Set_Detail__c raesd = (Rental_Apply_Equipment_Set_Detail__c) selectedData[i];
            if (raesd.Is_Body_F__c == false) {
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'借出备品配套一览明细:' + raesd.Id + ' 不是主体不能排队'));
            }
            WrapperInfo w = new WrapperInfo(raesd, myComponentController);
            w.orderNo = raesd.Queue_Number__c.intValue();
            w.lineNo = i;
            if (w.orderNo != i + 1) {
                w.orderNo = w.lineno + 1;
                w.changeFlg = '1';
            }
            viewList.add(w);
            queueConmentMap.put(raesd.Id, raesd.Queue_Conment__c);
        }
    }

    public void saveQueue(){
        Savepoint sp = Database.setSavepoint();
        Boolean isCheckedFlag = false;
        try {
            for (WrapperInfo w : viewList) {
                Rental_Apply_Equipment_Set_Detail__c rae = (Rental_Apply_Equipment_Set_Detail__c) w.sobj;
                if (w.check) {
                    isCheckedFlag = true;
                    if (rae.Is_Body_F__c == false) {
                        inptNumStr = null;
                        throw new ControllerUtil.myException('借出备品配套一览明细:' + rae.Id + ' 不是主体不能排队');
                    }

                    // 没有调整队列，只更改排队备注的情况
                    if (!inputUpDownFlag && (inptNum == 0 || inptNum == null)) {
                        List<Rental_Apply_Equipment_Set_Detail__c> raesdObjList = new List<Rental_Apply_Equipment_Set_Detail__c>();
                        Rental_Apply_Equipment_Set_Detail__c raesdObj = new Rental_Apply_Equipment_Set_Detail__c();
                        raesdObj.Id = rae.Id;
                        raesdObj.Queue_Conment__c = rae.Queue_Conment__c;
                        raesdObj.Queue_User__c = UserInfo.getUserId();
                        raesdObjList.add(raesdObj);
                        FixtureUtil.withoutUpdate(raesdObjList);
                    } else {
                        // 调整队列的情况
                        if (!rae.Allow_Adjust_Queue_Flag__c) {
                            inptNumStr = null;
                            throw new ControllerUtil.myException('备品总窗口未申请插队，无法调整顺序，请确认。');
                        }

                        if (inputUpDownFlag && inptNum == 0) {
                            throw new ControllerUtil.myException('错误的【指定排队NO.】：0');
                        } else {
                            Rental_Apply_Equipment_Set_Detail__c raesd = [
                                    SELECT Id, Allow_Adjust_Queue_Flag__c, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c
                                    FROM Rental_Apply_Equipment_Set_Detail__c
                                    WHERE Id =: rae.Id
                                      AND Is_Body__c = true
                                      AND Cancel_Select__c = false];

                            if (raesd == null) {
                                inptNumStr = null;
                                throw new ControllerUtil.myException('调整的一览明细不存在。');
                            }

                            if (inputUpDownFlag && raesd.Queue_Number__c <= inptNum) {
                                throw new ControllerUtil.myException('请使用【指定排队NO.】来向上调整排队No。');
                            }
                            saveQueue(rae, inptNum, inputUpDownFlag, false);
                        }
                    }
                }
            }

            inptNumStr = null;
            inputUpDownFlag = false;
            inptNum = null;

            myComponentController.getSelectedDataInfo();
            getSqlWhereStr();
            myComponentController.searchAndPaging();

            if (isCheckedFlag) {
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO,'保存成功'));
            } else {
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO,'请勾选需要操作的数据'));
            }
        } catch (Exception e) {
            Database.rollback(sp);
            inputUpDownFlag = false;
            inptNum = null;
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,e.getmessage()));
        }
    }

    public QueuePageByAssetIdController(){
        // 20211104 ljh 排队 start
        // this.asId = ApexPages.currentPage().getParameters().get('asId');
        // this.parentId = asId;
        this.parentId = ApexPages.currentPage().getParameters().get('parentId');
        if (ApexPages.currentPage().getParameters().get('isNotShow') == 'true') {
            this.isNotShow = true;
        } else {
            this.isNotShow = false;
        }

        // 20211104 ljh 排队 end
    }

    public void init() {
        isNeedSearchFirst = false;
        getSqlWhereStr();

        this.wher = '';
        List<Rental_Apply_Equipment_Set_Detail__c> raesdObjs = [
                    SELECT Id, Rental_Apply_Equipment_Set__c, Asset__c,Salesdepartment_before__c,
                           Product_category_text__c,Equipment_Type_text__c,
                           Internal_asset_location_before__c,Fixture_Model_No__c,Fixture_Model_No_F__c
                     FROM Rental_Apply_Equipment_Set_Detail__c
                    WHERE Rental_Apply_Equipment_Set__c = :parentId
                      and Is_Body__c = true
                      and Cancel_Select__c = false];
        if (raesdObjs.isEmpty()) {
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'备品一览明细不存在。'));
            return;
        }
        raesd = raesdObjs[0];
        this.modelNo = raesd.Fixture_Model_No__c;
        if (String.isNotBlank(raesd.Salesdepartment_before__c)) {
            wher += ' AND Salesdepartment_before__c = \'' + raesd.Salesdepartment_before__c + '\'';
        }
        if (String.isNotBlank(raesd.Product_category_text__c)) {
            wher += ' AND Product_category_text__c = \'' + raesd.Product_category_text__c + '\'';
        }
        if (String.isNotBlank(raesd.Equipment_Type_text__c)) {
            wher += ' AND Equipment_Type_text__c = \'' + raesd.Equipment_Type_text__c + '\'';
        }
        if (String.isNotBlank(raesd.Internal_asset_location_before__c)) {
            wher += ' AND Internal_asset_location_before__c = \'' + raesd.Internal_asset_location_before__c + '\'';
        }
    }

    /**
     * 申请单置顶
     * */
    public void upRentalApply() {
        Savepoint sp = Database.setSavepoint();
        Boolean isCheckedFlag = false;
        try {
            for (WrapperInfo w : viewList) {
                Rental_Apply_Equipment_Set_Detail__c rae = (Rental_Apply_Equipment_Set_Detail__c) w.sobj;
                if (w.check) {
                    isCheckedFlag = true;
                    if (!rae.Allow_Adjust_Queue_Flag__c) {
                        inptNumStr = null;
                        throw new ControllerUtil.myException('备品总窗口未申请插队，无法调整顺序，请确认。');
                    }

                    // 只置顶申请单中已排队，且非暂定分配的一览明细
                    List<Rental_Apply_Equipment_Set_Detail__c> raesdObjs = [
                        SELECT Id, Allow_Adjust_Queue_Flag__c, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c, Name
                        FROM Rental_Apply_Equipment_Set_Detail__c
                        WHERE Rental_Apply__c =: rae.Rental_Apply__c
                          AND Is_Body__c = true
                          AND Cancel_Select__c = false
                          AND Queue_Number__c > 0];
                    // 校验申请单中已排队的其余一览明细的状态
                    for(Rental_Apply_Equipment_Set_Detail__c raesd : raesdObjs){           
                        if (!raesd.Allow_Adjust_Queue_Flag__c) {
                            inptNumStr = null;
                            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,'一览明细:' + raesd.Name + ' 型号:' + raesd.Fixture_Model_No__c + ' 备品总窗口未申请插队，无法调整顺序，请确认。'));
                            return;
                        }

                        //申请单置顶
                        saveQueue(raesd, 1, true, false);
                    }
                }
            }

            inptNumStr = null;
            inputUpDownFlag = false;
            inptNum = null;

            myComponentController.getSelectedDataInfo();
            getSqlWhereStr();
            myComponentController.searchAndPaging();

            if (isCheckedFlag) {
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO,'申请单置顶成功'));
            } else {
                ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO,'请勾选需要操作的数据'));
            }
        } catch (Exception e) {
            Database.rollback(sp);
            inputUpDownFlag = false;
            inptNum = null;
            ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR,e.getmessage()));
        }
    }

    /**
     * 调整排队的队列顺序
     * @param raesdObj 需要调整的对象
     * @param num 调整到的排队No
     * @param upDownFlag 向上或者向下调整标识 true:向上; false:向下
     * @param isSkip 是否跳过调整顺序校验 true:跳过校验; false:校验
     */
    public void saveQueue(Rental_Apply_Equipment_Set_Detail__c raesdObj, Integer num, Boolean upDownFlag, Boolean isSkip) {
        List<Rental_Apply_Equipment_Set_Detail__c> raes = new List<Rental_Apply_Equipment_Set_Detail__c>();
        Rental_Apply_Equipment_Set_Detail__c raesd = [
                SELECT Id, Allow_Adjust_Queue_Flag__c, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c
                FROM Rental_Apply_Equipment_Set_Detail__c
                WHERE Id =: raesdObj.Id
                  AND Is_Body__c = true
                  AND Cancel_Select__c = false
                FOR UPDATE];
        if (raesd == null) {
            inptNumStr = null;
            throw new ControllerUtil.myException('调整的一览明细不存在。');
        }

        if (!raesd.Allow_Adjust_Queue_Flag__c && !isSkip) {
            inptNumStr = null;
            throw new ControllerUtil.myException('一览明细:' + raesd.Name + ' 型号:' + raesd.Fixture_Model_No__c + ' 备品总窗口未申请插队，无法调整顺序，请确认。');
        }
        if (upDownFlag && raesd.Queue_Number__c == num) {
            return;
        }
        
        List<Rental_Apply_Equipment_Set_Detail__c> raesdList = [
                SELECT Id, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c
                FROM Rental_Apply_Equipment_Set_Detail__c
                WHERE Queue_Number__c > 0
                  AND Cancel_Select__c = false
                  AND ExternalKey__c =: raesd.ExternalKey__c
                ORDER BY Queue_Number__c ASC nulls last];

        // 先调整队列顺序，后再调整序列顺序
        // upDownFlag true:向上调整、置顶  false:置底
        // 需要按照页面段的检索条件，取出队列一览，来做调整队列时的比较
        Integer orderNo = 1;
        for (Rental_Apply_Equipment_Set_Detail__c rae : raesdList) {
            // 向上调整、置顶
            if (upDownFlag) {
                if (orderNo >= num && orderNo < raesd.Queue_Number__c) {
                    rae.Queue_Number__c = orderNo + 1;
                    rae.Queue_User__c = UserInfo.getUserId();
                    raes.add(rae);
                }
            } else {
                // 置底
                if (orderNo > raesd.Queue_Number__c) {
                    rae.Queue_Number__c = orderNo - 1;
                    rae.Queue_User__c = UserInfo.getUserId();
                    raes.add(rae);
                }
            }
            orderNo++;
        }

        if (upDownFlag) {
            // 置顶或者向上，需要传调整Num
            raesdObj.Queue_Number__c = num;
        } else {
            // 置底直接用队列的size
            raesdObj.Queue_Number__c = raesdList.size();
        }
        
        // 插队Flag
        raesdObj.Asset__c = null;
        raesdObj.IsAdjust__c = true;
        raesdObj.Queue_User__c = UserInfo.getUserId();
        raes.add(raesdObj);
        // 更新队列信息
        FixtureUtil.withoutUpdate(raes);

        // 更新序列信息，先确认是单一序列还是混合序列，混合序列顺序不做调整
        List<Rental_Apply_Sequence__c> rasList = [
                SELECT Id, Series_No__c, ExternalKey__c, Apply_Set_Detail_ExternalKey__c
                FROM Rental_Apply_Sequence__c 
                WHERE Apply_Set_Detail__c =: raesd.Id
                  AND Invalid_Flag__c = false];

        Map<String, Integer> externalKeyMap = new Map<String, Integer>();
        for (Rental_Apply_Sequence__c ras : rasList) {
            externalKeyMap.put(ras.ExternalKey__c, 1);
        }

        // 先检索出混合序列，从更新序列中排除
        List<Rental_Apply_Sequence__c> rasList1 = [
                SELECT ExternalKey__c
                FROM Rental_Apply_Sequence__c 
                WHERE Invalid_Flag__c = false
                  AND ExternalKey__c IN: externalKeyMap.keySet()
                  AND Apply_Set_Detail_ExternalKey__c !=: raesd.ExternalKey__c
                ORDER BY ExternalKey__c];

        for (Rental_Apply_Sequence__c ras : rasList1) {
            if (externalKeyMap.containsKey(ras.ExternalKey__c)) {
                externalKeyMap.remove(ras.ExternalKey__c);
            }
        }

        // 检索出单一序列，更新单一序列
        List<Rental_Apply_Sequence__c> rasList2 = [
                SELECT Id, Series_No__c, Apply_Set_Detail__r.Queue_Number__c
                FROM Rental_Apply_Sequence__c 
                WHERE Invalid_Flag__c = false
                  AND ExternalKey__c IN: externalKeyMap.keySet()
                  AND Series_Unequal_Queue_Flag__c = true
                ORDER BY ExternalKey__c];

        for (Rental_Apply_Sequence__c ras : rasList2) {
            ras.Series_No__c = ras.Apply_Set_Detail__r.Queue_Number__c;
        }
        // 更新单一序列信息
        FixtureUtil.withoutUpdate(rasList2);
    }

    /**
     * 调整队列 + 申请单置顶，并没有比以前改进多少，还难维护，所以注释掉
     * */
    /*public void saveQueue(List<Rental_Apply_Equipment_Set_Detail__c> raesdObjs, Integer num, Boolean upDownFlag) {
        Map<Id, Rental_Apply_Equipment_Set_Detail__c> raesdMap = new Map<Id, Rental_Apply_Equipment_Set_Detail__c>([
                SELECT Id, Allow_Adjust_Queue_Flag__c, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c, Rental_Apply__c
                FROM Rental_Apply_Equipment_Set_Detail__c
                WHERE Id IN: raesdObjs
                  AND Is_Body__c = true
                  AND Cancel_Select__c = false
                ORDER BY ExternalKey__c, Queue_Number__c ASC nulls last]);

        String rentalApplyId = null;
        // 同一申请单中相同型号的设备排同样队列的情况下，需要按照ExternalKey来Map
        Map<String, List<Rental_Apply_Equipment_Set_Detail__c>> externalMap = new Map<String, List<Rental_Apply_Equipment_Set_Detail__c>>();
        for (Rental_Apply_Equipment_Set_Detail__c raesdObj : raesdObjs) {
            if (!raesdMap.containsKey(raesdObj.Id)) {
                throw new ControllerUtil.myException('调整的一览明细不存在。');
            } else {
                Rental_Apply_Equipment_Set_Detail__c raesdTemp = raesdMap.get(raesdObj.Id);
                rentalApplyId = raesdTemp.Rental_Apply__c;
                if (!raesdTemp.Allow_Adjust_Queue_Flag__c) {
                    throw new ControllerUtil.myException('备品总窗口未申请插队，无法调整顺序，请确认。');
                }
                if (upDownFlag && raesdTemp.Queue_Number__c <= num) {
                    throw new ControllerUtil.myException('请使用【指定排队NO.】来向上调整排队No。');
                }

                if (!externalMap.containskey(raesdTemp.ExternalKey__c)) {
                    List<Rental_Apply_Equipment_Set_Detail__c> tempList = new List<Rental_Apply_Equipment_Set_Detail__c>();
                    tempList.add(raesdTemp);
                    externalMap.put(raesdTemp.ExternalKey__c, tempList);
                } else {
                    List<Rental_Apply_Equipment_Set_Detail__c> tempList = externalMap.get(raesdTemp.ExternalKey__c);
                    tempList.add(raesdTemp);
                    externalMap.put(raesdTemp.ExternalKey__c, tempList);
                }
            }
        }

        List<Rental_Apply_Equipment_Set_Detail__c> raesUpdList = new List<Rental_Apply_Equipment_Set_Detail__c>();
        if (!externalMap.keySet().isEmpty()) {
            List<Rental_Apply_Equipment_Set_Detail__c> raesdList = [
                    SELECT Id, Fixture_Model_No__c, ExternalKey__c, Queue_Number__c, Rental_Apply__c
                    FROM Rental_Apply_Equipment_Set_Detail__c
                    WHERE Queue_Number__c > 0
                      AND Cancel_Select__c = false
                      AND ExternalKey__c IN: externalMap.keySet()
                    ORDER BY ExternalKey__c, Queue_Number__c ASC nulls last];

            // 先调整队列顺序，后再调整序列顺序
            // upDownFlag true:向上调整、置顶  false:置底
            // 需要按照页面段的检索条件，取出队列一览，来做调整队列时的比较
            if (raesdObjs.size() == 1) {
                Rental_Apply_Equipment_Set_Detail__c raesd = raesdMap.get(raesdObjs[0].Id);
                // 区分申请单置顶 和 别的操作
                Integer orderNo = 1;
                for (Rental_Apply_Equipment_Set_Detail__c rae : raesdList) {
                    // 向上调整、置顶
                    if (upDownFlag) {
                        if (orderNo >= num && orderNo < raesd.Queue_Number__c) {
                            rae.Queue_Number__c = orderNo + 1;
                            rae.Queue_User__c = UserInfo.getUserId();
                            raesUpdList.add(rae);
                        }
                    } else {
                        // 置底
                        if (orderNo > raesd.Queue_Number__c) {
                            rae.Queue_Number__c = orderNo - 1;
                            rae.Queue_User__c = UserInfo.getUserId();
                            raesUpdList.add(rae);
                        }
                    }
                    orderNo++;
                }

                if (upDownFlag) {
                    // 置顶或者向上，需要传调整Num
                    raesdObjs[0].Queue_Number__c = num;
                } else {
                    // 置底直接用队列的size
                    raesdObjs[0].Queue_Number__c = raesdList.size();
                }
                
                // 插队Flag
                raesdObjs[0].IsAdjust__c = true;
                raesdObjs[0].Queue_User__c = UserInfo.getUserId();
                raesUpdList.add(raesdObjs[0]);

            } else {
                // 申请单置顶
                Integer orderNo = 1;
                Integer endNo = 0;
                String externalKeyTemp = null;
                for (Rental_Apply_Equipment_Set_Detail__c rae : raesdList) {
                    if (rae.ExternalKey__c != externalKeyTemp) {
                        externalKeyTemp = rae.ExternalKey__c;
                        orderNo = externalMap.get(externalKeyTemp).size();
                        endNo = (Integer)externalMap.get(externalKeyTemp)[orderNo-1].Queue_Number__c;
                    }

                    if (rae.Rental_Apply__c != rentalApplyId) {
                        // 向上调整、置顶
                        if (upDownFlag) {
                            if (rae.Queue_Number__c >= num && rae.Queue_Number__c < endNo) {
                                rae.Queue_Number__c = orderNo + 1;
                                rae.Queue_User__c = UserInfo.getUserId();
                                raesUpdList.add(rae);
                            }
                        }
                    }

                    orderNo++;
                }

                if (upDownFlag) {
                    for (String external : externalMap.keySet()) {
                        List<Rental_Apply_Equipment_Set_Detail__c> tempList = new List<Rental_Apply_Equipment_Set_Detail__c>();
                        tempList = externalMap.get(external);
                        orderNo = 1;
                        for (Rental_Apply_Equipment_Set_Detail__c raesTemp : tempList) {
                            // 置顶
                            raesTemp.Queue_Number__c = orderNo;
                            // 插队Flag
                            raesTemp.IsAdjust__c = true;
                            raesTemp.Queue_User__c = UserInfo.getUserId();
                            raesUpdList.add(raesTemp);
                            orderNo++;
                        }
                    }
                }
            }
        }

        if (!raesUpdList.isEmpty()) {
            if(raesUpdList.size() > 9000){
                throw new ControllerUtil.myException('当前数据量过大，请到进行单条数据操作');
            }
            // 更新队列信息
            FixtureUtil.withoutUpdate(raesUpdList);
        }
        
        // 更新序列信息，先确认是单一序列还是混合序列，混合序列顺序不做调整
        List<Rental_Apply_Sequence__c> rasList = [
                SELECT Id, Series_No__c, ExternalKey__c, Apply_Set_Detail_ExternalKey__c
                FROM Rental_Apply_Sequence__c 
                WHERE Apply_Set_Detail__c IN: raesdObjs
                  AND Invalid_Flag__c = false];

        Map<String, Integer> externalKeyMap = new Map<String, Integer>();
        for (Rental_Apply_Sequence__c ras : rasList) {
            externalKeyMap.put(ras.ExternalKey__c, 1);
        }

        // 先检索出混合序列，从更新序列中排除
        List<Rental_Apply_Sequence__c> rasList1 = [
                SELECT ExternalKey__c
                FROM Rental_Apply_Sequence__c 
                WHERE Invalid_Flag__c = false
                  AND ExternalKey__c IN: externalKeyMap.keySet()
                  AND Apply_Set_Detail_ExternalKey__c !=: raesd.ExternalKey__c
                ORDER BY ExternalKey__c];

        for (Rental_Apply_Sequence__c ras : rasList1) {
            if (externalKeyMap.containsKey(ras.ExternalKey__c)) {
                externalKeyMap.remove(ras.ExternalKey__c);
            }
        }

        // 检索出单一序列，更新单一序列
        List<Rental_Apply_Sequence__c> rasList2 = [
                SELECT Id, Series_No__c, Apply_Set_Detail__r.Queue_Number__c
                FROM Rental_Apply_Sequence__c 
                WHERE Invalid_Flag__c = false
                  AND ExternalKey__c IN: externalKeyMap.keySet()
                  AND Series_Unequal_Queue_Flag__c = true
                ORDER BY ExternalKey__c];

        for (Rental_Apply_Sequence__c ras : rasList2) {
            ras.Series_No__c = ras.Apply_Set_Detail__r.Queue_Number__c;
        }

        if (!rasList2.isEmpty()) {
            if(raesUpdList.size() + rasList2.size() > 9000){
                throw new ControllerUtil.myException('当前数据量过大，请到进行单条数据操作');
            }
            // 更新单一序列信息
            FixtureUtil.withoutUpdate(rasList2);
        }
    }*/
}