From 52f362a9efd067ba31e24b30754681aabe8f991e Mon Sep 17 00:00:00 2001
From: fuyu <fuyu@prec-tech.com>
Date: 星期一, 06 三月 2023 13:28:09 +0800
Subject: [PATCH] 备份进口单证

---
 force-app/main/default/aura/AttachmentDisplay/AttachmentDisplay.cmp                                    |  549 +++++------
 force-app/main/default/classes/NewQuoteIraiController.cls                                              |  210 ++++
 force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImport.cmp      |   19 
 force-app/main/default/aura/eSignHomePage/eSignHomePage.cmp                                            |    6 
 force-app/main/default/pages/NewQuoteIrai.page                                                         |   75 +
 force-app/main/default/classes/AttachmentDisplayControllerTest.cls                                     |  379 ++++++++
 force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayHelper.js                               |   29 
 force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js |    7 
 force-app/main/default/classes/AttachmentDisplayController.cls-meta.xml                                |    5 
 force-app/main/default/classes/AttachmentDisplayController.cls                                         |  800 +++++++++++-----
 force-app/main/default/classes/DealerPersonnelControllerTest.cls                                       |   11 
 force-app/main/default/aura/eSignHomePage/eSignHomePageHelper.js                                       |   51 
 force-app/main/default/classes/DealerPersonnelController.cls                                           |  608 +++++++++++-
 force-app/main/default/aura/eSignHomePage/eSignHomePageController.js                                   |    5 
 force-app/main/default/classes/AttachmentDisplayControllerTest.cls-meta.xml                            |    5 
 force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayController.js                           |    8 
 force-app/main/default/classes/NewQuoteIraiControllerTest.cls                                          |    5 
 17 files changed, 2,079 insertions(+), 693 deletions(-)

diff --git a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplay.cmp b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplay.cmp
index c21f55e..3f26d9a 100644
--- a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplay.cmp
+++ b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplay.cmp
@@ -1,316 +1,239 @@
 <aura:component implements="flexipage:availableForAllPageTypes,forceCommunity:availableForAllPageTypes,lightning:isUrlAddressable" access="global" controller="AttachmentDisplayController">
-    <aura:attribute name="DNId" type="String"
-                    description="鐢ㄦ潵浠庣埗瀵硅薄鎺ユ敹浼犻�掕繃鏉ョ殑绛炬敹鍗昳d"
-                    default=""/>
-    <aura:handler name="init" action="{!c.doInit}" value="{!this}"
-                    description="鍒濆鍖栨柟娉�"/>
-    <aura:attribute name="currentData" type="Object[]" description="鏄庣粏椤靛綋鍓嶆樉绀虹殑鏄庣粏鐨勪俊鎭�" />
-    <div>
-        <lightning:spinner aura:id="mySpinner" alternativeText='璇风瓑寰�' size="large"  class="slds-spinner_container"/>
-    </div>
-    <div id="allDivs" >
-        <div id="ins" style=" width:1150px;margin-right: 4px; ">
-            <!-- 鏄剧ず鍦ㄦ槑缁嗛〉鐨勫綋鍓嶆槑缁嗙殑琛ㄦ牸 -->
-            <div id="inTables">
-                <!-- <lightning:card> -->
-                <aura:set attribute="title">
-                    杩涘彛鍗曡瘉鏄庣粏
-                </aura:set>
-                <table class="slds-table slds-table_cell-buffer slds-table_bordered slds-hint-parent slds-no-row-hover " style="border-collapse: collapse;border-color:#D7D7D7;" border="1px " >
-                    <thead>
-                        <tr class="slds-line-height_reset slds-text-title_caps">
-                            <!-- 绗竴鍒� 浜у搧鏄庣粏 -->
-                            <!-- <th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" scope="row">
-                                <span class="slds-grid slds-grid_align-spread" style="width: 120px;text-align: left;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="浜у搧鏄庣粏" class="slds-truncate" style="padding-bottom: 3px;">浜у搧鏄庣粏</span>
-                                    </div>
-                                </span>
-                            </th> -->
-                            <th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" scope="row" style="width: 146px;position:static">
-                                <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="浜у搧鏄庣粏" class="slds-truncate" style="padding-bottom: 3px;">浜у搧鏄庣粏</span>
-                                    </div>
-                                </span>
-                            </th>
-                            <!-- 绗簩鍒� 鏈鸿韩缂栫爜 -->
-                            <th class="slds-is-resizable" tabindex="-1" data-label="鏈鸿韩缂栫爜" scope="row" style="width: 240px;height: 35px;">
-                                <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="鏈鸿韩缂栫爜" class="slds-truncate" style="padding-bottom: 3px;">鏈鸿韩缂栫爜</span>
-                                    </div>
-                                </span>
-                            </th>
-                             <!-- 绗笁鍒� 绠$悊缂栫爜 -->
-                             <th class="slds-is-resizable" tabindex="-1" data-label="绠$悊缂栫爜" scope="row" style="width: 240px;height: 35px;">
-                                <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="绠$悊缂栫爜" class="slds-truncate" style="padding-bottom: 3px;">绠$悊缂栫爜</span>
-                                    </div>
-                                </span>
-                            </th>
-                            <!-- 绗洓鍒� 棰勮閾炬帴 -->
-                            <!-- <th class="slds-is-resizable" tabindex="-1" data-label="棰勮閾炬帴" scope="row" style="width: 249px;height: 35px;">
-                                <span class="slds-grid slds-grid_align-spread" style="text-align: center;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="棰勮閾炬帴" class="slds-truncate" style="padding-bottom: 3px;">棰勮閾炬帴</span>
-                                    </div>
-                                </span>
-                            </th> -->
-                            <!-- 绗簲鍒� 鎶ュ叧鍗曚笅杞介摼鎺� -->
-                            <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" scope="row" style="width: 249px;">
-                                <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="鎶ュ叧鍗曚笅杞介摼鎺�" class="slds-truncate" style="padding-bottom: 3px;">鎶ュ叧鍗曚笅杞介摼鎺�</span>
-                                    </div>
-                                </span>
-                            </th>
-                            <!-- 绗叚鍒� 鍟嗘璇佷笅杞介摼鎺� -->
-                            <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" scope="row" style="width: 249px;">
-                                <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                    <div class="slds-truncate">
-                                        <span title="鍟嗘璇佷笅杞介摼鎺�" class="slds-truncate" style="padding-bottom: 3px;">鍟嗘璇佷笅杞介摼鎺�</span>
-                                    </div>
-                                </span>
-                            </th>
-                        </tr>
-                    </thead>
-                    <aura:if isTrue="{!v.currentData.length > 0}">
-                        <tbody>
-                            <aura:iteration items="{!v.currentData}" var="curr" >
-                                <tr class="slds-hint-parent">
-                                    <!-- 琛岄」鐩� 绗竴鍒�  浜у搧鏄庣粏-->
-                                    <!-- <th class="slds-is-resizable" tabindex="-1" data-label="DN鍗曞彿" >
-                                        <span class="slds-grid slds-grid_align-spread" style="width: 140px;height:18px;text-align: left;display:block;border: bottom 1px;">
-                                            <lightning:formattedText value="{!curr.Name}" style="padding-bottom: 3px;"/>
-                                        </span>
-                                    </th> -->
-                                    <th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" style="width: 146px;height:36px;position:static">
-                                        <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                            <div class="slds-truncate">
-                                                <lightning:formattedText value="{!curr.ProductName}" style="padding-bottom: 3px;"/>
-                                            </div>
-                                        </span>
-                                    </th>
-                                    <!-- 琛岄」鐩� 绗簩鍒�  鏈鸿韩缂栫爜-->
-                                    <th class="slds-is-resizable" tabindex="-1" data-label="鏈鸿韩缂栫爜" style="width: 240px;height: 35px;">
-                                        <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                            <div class="slds-truncate">
-                                                <lightning:formattedText value="{!curr.FrameNo}" style="padding-bottom: 3px;"/>
-                                            </div>
-                                        </span>
-                                    </th>
-                                    <!-- 琛岄」鐩� 绗笁鍒�  绠$悊缂栫爜-->
-                                    <th class="slds-is-resizable" tabindex="-1" data-label="绠$悊缂栫爜" style="width: 240px;height: 35px;">
-                                        <span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
-                                            <div class="slds-truncate">
-                                                <lightning:formattedText value="{!curr.Name}" style="padding-bottom: 3px;"/>
-                                            </div>
-                                        </span>
-                                    </th>
-                                    <!-- 琛岄」鐩� 绗洓鍒�  棰勮閾炬帴-->
-                                    <!-- <aura:if isTrue="{!IF(curr.count ==null,false,true)}">
-                                        <th class="slds-is-resizable" tabindex="-1" data-label="棰勮閾炬帴" style="width: 240px;height: 35px;" rowspan="{!curr.count}">
-                                            <span class="slds-grid slds-grid_align-spread" style="text-align: center;display:block;">
-                                                <div class="slds-truncate"> -->
-                                                    <!-- <lightning:formattedText value="{!curr.Name}" style="padding-bottom: 3px;"/> -->
-                                                    <!-- <a href="{!curr.code}">棰勮</a>
-                                                </div>
-                                            </span>
-                                        </th>
-                                    </aura:if> -->
-                                    <!-- 琛岄」鐩� 绗簲鍒�  鎶ュ叧鍗曚笅杞介摼鎺�-->
-                                    <aura:if isTrue="{!IF(curr.code =='鍥藉唴閲囪喘',false,true)}">
-                                        <aura:if isTrue="{!IF(curr.count ==null,false,true)}">
-                                            <!-- <aura:if isTrue="{!IF(curr.code !='鏃�' ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate"> -->
-                                                            <!-- <lightning:formattedText value="{!curr.code}" style="padding-bottom: 3px;"/> rowspan="{!curr.count}"-->
-                                                            <!-- <a href="{!curr.codeyu}">棰勮</a>
-                                                            &nbsp;&nbsp;&nbsp;
-                                                            <a href="{!curr.code}">涓嬭浇</a>
-                                                        </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if>
-                                            <aura:if isTrue="{!IF(curr.code =='鏃�' ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate"> -->
-                                                            <!-- <a href="{!curr.code}">{!curr.code}</a> -->
-                                                        <!-- </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if> -->
-                                            <aura:if isTrue="{!IF(curr.code =='涓嶅嚭璇�' ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate">
-                                                            <lightning:formattedText value="{!curr.code}" style="padding-bottom: 3px;"/>
-                                                        </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if>
-                                            <aura:if isTrue="{!IF(curr.code !='涓嶅嚭璇�' ,true,false)}">
-                                                <aura:if isTrue="{!IF(AND(curr.code =='',curr.codeyu ==''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <lightning:formattedText value="{!curr.code}" style="padding-bottom: 3px;"/>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.code =='',curr.codeyu !=''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">棰勮</a>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.code !='',curr.codeyu ==''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.awsKey}&amp;name={!curr.fileName}" target="_blank">涓嬭浇</a> -->
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">涓嬭浇</a>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.code !='',curr.codeyu !=''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.awsKey}&amp;name={!curr.fileName}" target="_blank">棰勮</a>  |  <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.awsKey}&amp;name={!curr.fileName}" target="_blank">涓嬭浇</a> -->
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">棰勮</a>  |  <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">涓嬭浇</a> 
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                            </aura:if>
-                                        </aura:if>
-                                    </aura:if>
-                                    <aura:if isTrue="{!IF(curr.code =='鍥藉唴閲囪喘',true,false)}">
-                                        <th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
-                                            <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                <div class="slds-truncate">
-                                                    鍥藉唴閲囪喘
-                                                </div>
-                                            </span>
-                                        </th>
-                                    </aura:if>
-                                    <!-- 琛岄」鐩� 绗叚鍒�  鍟嗘璇佷笅杞介摼鎺�-->
-                                    <aura:if isTrue="{!IF(curr.sj_code =='鍥藉唴閲囪喘',false,true)}">
-                                        <aura:if isTrue="{!IF(curr.count ==null,false,true)}">
-                                            <!-- <aura:if isTrue="{!IF(AND(curr.sj_code !='涓嶅嚭璇�',curr.sj_code !='') ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate"> -->
-                                                            <!-- <lightning:formattedText value="{!curr.code}" style="padding-bottom: 3px;"/> -->
-                                                            <!-- <a href="{!curr.sj_codeyu}">棰勮</a>
-                                                            &nbsp;&nbsp;&nbsp;
-                                                            <a href="{!curr.sj_code}">涓嬭浇</a>
-                                                        </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if> -->
-                                            <!-- <aura:if isTrue="{!IF(curr.sj_code =='涓嶅嚭璇�' ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate">
-                                                            <lightning:formattedText value="{!curr.sj_code}" style="padding-bottom: 3px;"/> -->
-                                                            <!-- <a href="{!curr.code}">涓嬭浇</a> -->
-                                                        <!-- </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if>
-                                            <aura:if isTrue="{!IF(AND(curr.sj_code !='涓嶅嚭璇�',curr.sj_code =='') ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate">
-                                                        </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if>-->
-                                        
-                                            <aura:if isTrue="{!IF(curr.sj_code =='涓嶅嚭璇�' ,true,false)}">
-                                                <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                    <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                        <div class="slds-truncate">
-                                                            <lightning:formattedText value="{!curr.sj_code}" style="padding-bottom: 3px;"/>
-                                                        </div>
-                                                    </span>
-                                                </th>
-                                            </aura:if>
-                                            <aura:if isTrue="{!IF(curr.sj_code !='涓嶅嚭璇�' ,true,false)}">
-                                                <aura:if isTrue="{!IF(AND(curr.sj_code =='',curr.sj_codeyu ==''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <lightning:formattedText value="{!curr.sj_code}" style="padding-bottom: 3px;"/>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.sj_code =='',curr.sj_codeyu !=''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">棰勮</a> -->
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">棰勮</a>
+	<aura:attribute name="DNId" type="String"
+					description="鐢ㄦ潵浠庣埗瀵硅薄鎺ユ敹浼犻�掕繃鏉ョ殑绛炬敹鍗昳d"
+					default=""/>
+	<aura:handler name="init" action="{!c.doInit}" value="{!this}"
+					description="鍒濆鍖栨柟娉�"/>
+	<aura:attribute name="currentData" type="Object[]" description="鏄庣粏椤靛綋鍓嶆樉绀虹殑鏄庣粏鐨勪俊鎭�" />
+	<div>
+		<lightning:spinner aura:id="mySpinner" alternativeText='璇风瓑寰�' size="large"  class="slds-spinner_container"/>
+	</div>
+	<div id="allDivs" >
+		<div id="ins" style=" width:1000px;margin-right: 4px; ">
+			<!-- 鏄剧ず鍦ㄦ槑缁嗛〉鐨勫綋鍓嶆槑缁嗙殑琛ㄦ牸 -->
+			<div id="inTables">
+				<!-- <lightning:card> -->
+				<aura:set attribute="title">
+					杩涘彛鍗曡瘉鏄庣粏
+				</aura:set>
+                <label style="float: left;font-size:20px">杩涘彛鍗曡瘉鏄庣粏</label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+				<lightning:button variant="neutral" label="杩斿洖" title="Cancel" onclick="{! c.rebackDNListPage }" />
+				<table class="slds-table slds-table_cell-buffer slds-table_bordered slds-hint-parent slds-no-row-hover " style="border-collapse: collapse;border-color:#D7D7D7;" border="1px " >
+					<thead>
+						<tr class="slds-line-height_reset slds-text-title_caps">
+							<!-- 绗竴鍒� 浜у搧鏄庣粏 -->
+							<!-- <th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" scope="row">
+								<span class="slds-grid slds-grid_align-spread" style="width: 120px;text-align: left;display:block;">
+									<div class="slds-truncate">
+										<span title="浜у搧鏄庣粏" class="slds-truncate" style="padding-bottom: 3px;">浜у搧鏄庣粏</span>
+									</div>
+								</span>
+							</th> -->
+							<th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" scope="row" style="width: 146px;position:static">
+								<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+									<div class="slds-truncate">
+										<span title="浜у搧鏄庣粏" class="slds-truncate" style="padding-bottom: 3px;">浜у搧鏄庣粏</span>
+									</div>
+								</span>
+							</th>
+							<!-- 绗簩鍒� 鏈鸿韩缂栫爜 -->
+							<th class="slds-is-resizable" tabindex="-1" data-label="鏈鸿韩缂栫爜" scope="row" style="width: 240px;height: 35px;">
+								<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+									<div class="slds-truncate">
+										<span title="鏈鸿韩缂栫爜" class="slds-truncate" style="padding-bottom: 3px;">鏈鸿韩缂栫爜</span>
+									</div>
+								</span>
+							</th>
+							 <!-- 绗笁鍒� 绠$悊缂栫爜 -->
+							 <th class="slds-is-resizable" tabindex="-1" data-label="绠$悊缂栫爜" scope="row" style="width: 240px;height: 35px;">
+								<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+									<div class="slds-truncate">
+										<span title="绠$悊缂栫爜" class="slds-truncate" style="padding-bottom: 3px;">绠$悊缂栫爜</span>
+									</div>
+								</span>
+							</th>
+							<!-- 绗洓鍒� 棰勮閾炬帴 -->
+							<!-- <th class="slds-is-resizable" tabindex="-1" data-label="棰勮閾炬帴" scope="row" style="width: 249px;height: 35px;">
+								<span class="slds-grid slds-grid_align-spread" style="text-align: center;display:block;">
+									<div class="slds-truncate">
+										<span title="棰勮閾炬帴" class="slds-truncate" style="padding-bottom: 3px;">棰勮閾炬帴</span>
+									</div>
+								</span>
+							</th> -->
+							<!-- 绗簲鍒� 鎶ュ叧鍗曚笅杞介摼鎺� -->
+							<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" scope="row" style="width: 249px;">
+								<span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
+									<div class="slds-truncate">
+										<span title="鎶ュ叧鍗曚笅杞介摼鎺�" class="slds-truncate" style="padding-bottom: 3px;">鎶ュ叧鍗曚笅杞介摼鎺�</span>
+									</div>
+								</span>
+							</th>
+							<!-- 绗叚鍒� 鍟嗘璇佷笅杞介摼鎺� -->
+							<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" scope="row" style="width: 249px;">
+								<span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
+									<div class="slds-truncate">
+										<span title="鍟嗘璇佷笅杞介摼鎺�" class="slds-truncate" style="padding-bottom: 3px;">鍟嗘璇佷笅杞介摼鎺�</span>
+									</div>
+								</span>
+							</th>
+						</tr>
+					</thead>
+					<aura:if isTrue="{!v.currentData.length > 0}">
+						<tbody>
+							<aura:iteration items="{!v.currentData}" var="curr" >
+								<tr class="slds-hint-parent">
+									<!-- 琛岄」鐩� 绗竴鍒�  浜у搧鏄庣粏-->
+									<!-- <th class="slds-is-resizable" tabindex="-1" data-label="DN鍗曞彿" >
+										<span class="slds-grid slds-grid_align-spread" style="width: 140px;height:18px;text-align: left;display:block;border: bottom 1px;">
+											<lightning:formattedText value="{!curr.Name}" style="padding-bottom: 3px;"/>
+										</span>
+									</th> -->
+									<th class="slds-is-resizable" tabindex="-1" data-label="浜у搧鏄庣粏" style="width: 146px;height:36px;position:static">
+										<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+											<div class="slds-truncate">
+												<lightning:formattedText value="{!curr.ProductName}" style="padding-bottom: 3px;"/>
+											</div>
+										</span>
+									</th>
+									<!-- 琛岄」鐩� 绗簩鍒�  鏈鸿韩缂栫爜-->
+									<th class="slds-is-resizable" tabindex="-1" data-label="鏈鸿韩缂栫爜" style="width: 240px;height: 35px;">
+										<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+											<div class="slds-truncate">
+												<lightning:formattedText value="{!curr.FrameNo}" style="padding-bottom: 3px;"/>
+											</div>
+										</span>
+									</th>
+									<!-- 琛岄」鐩� 绗笁鍒�  绠$悊缂栫爜-->
+									<th class="slds-is-resizable" tabindex="-1" data-label="绠$悊缂栫爜" style="width: 240px;height: 35px;">
+										<span class="slds-grid slds-grid_align-spread" style="text-align: left;display:block;">
+											<div class="slds-truncate">
+												<lightning:formattedText value="{!curr.Name}" style="padding-bottom: 3px;"/>
+											</div>
+										</span>
+									</th>
+									<!-- 琛岄」鐩� 绗洓鍒�  棰勮閾炬帴-->
+									<!-- <aura:if isTrue="{!IF(curr.count ==null,false,true)}">
+										<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">  
+										</th>
+									</aura:if> -->
+									<aura:if isTrue="{!IF(curr.count ==null,false,true)}">		
+										<aura:if isTrue="{!IF(AND(curr.code !='',curr.codeyu !='',curr.codeyu.length > 25,curr.code.length > 25),false,true)}">
+											<!-- 鍙湁棰勮 -->
+											<aura:if isTrue="{!IF(AND(curr.codeyu !='',curr.codeyu.length > 25,curr.code ==''),true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															<a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">棰勮</a>  
+														</div>
+													</span>
+												</th>
+											</aura:if>
+											<!-- 鍙湁涓嬭浇 -->
+											<aura:if isTrue="{!IF(AND(curr.code !='',curr.code.length > 25,curr.codeyu ==''),true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															 <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">涓嬭浇</a> 
+														</div>
+													</span>
+												</th>
+											</aura:if>
+											<!-- 鍏朵粬鎯呭喌鏄剧ず鑷繁  -->
+											<aura:if isTrue="{!IF(AND(AND(curr.codeyu !='',curr.codeyu.length > 25,curr.code =='') == false , AND(curr.code !='',curr.code.length > 25,curr.codeyu =='')== false) ,true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															<lightning:formattedText value="{!curr.code}" style="padding-bottom: 3px;"/>
+														</div>
+													</span>
+												</th>
+											</aura:if>
+										</aura:if>
+										<!-- 棰勮鍜屼笅杞介兘鏈� -->
+										<aura:if isTrue="{!IF(AND(curr.code !='',curr.codeyu !='',curr.codeyu.length > 25,curr.code.length > 25),true,false)}">
+											<th class="slds-is-resizable" tabindex="-1" data-label="鎶ュ叧鍗�" style="width: 249px;" rowspan="{!curr.count}">
+												<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+													<div class="slds-truncate">
+														<!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.awsKey}&amp;name={!curr.fileName}" target="_blank">棰勮</a>  |  <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.awsKey}&amp;name={!curr.fileName}" target="_blank">涓嬭浇</a> -->
+														<a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">棰勮</a>  |  <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.awsKey + '&amp;name=' + curr.fileName}" target="_blank">涓嬭浇</a> 
+													</div>
+												</span>
+											</th>
+										</aura:if>
+									</aura:if>
+									<!-- 琛岄」鐩� 绗叚鍒�  鍟嗘璇佷笅杞介摼鎺�-->
+									<aura:if isTrue="{!IF(curr.count_sj ==null,false,true)}">
+										<aura:if isTrue="{!IF(AND(curr.sj_code !='',curr.sj_codeyu !='',curr.sj_code.length > 25,curr.sj_codeyu.length > 25),false,true)}">
+											<!-- 鍙湁棰勮 -->
+											<aura:if isTrue="{!IF(AND(curr.sj_codeyu !='',curr.sj_codeyu.length > 25,curr.sj_code ==''),true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count_sj}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															<!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">棰勮</a> -->
+															<a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">棰勮</a>
 
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.sj_code !='',curr.sj_codeyu ==''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">涓嬭浇</a> -->
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">涓嬭浇</a>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                                <aura:if isTrue="{!IF(AND(curr.sj_code !='',curr.sj_codeyu !=''),true,false)}">
-                                                    <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                                        <span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
-                                                            <div class="slds-truncate">
-                                                                <!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">棰勮</a>  |  <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">涓嬭浇</a> -->
-                                                                <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">棰勮</a>  |  <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">涓嬭浇</a>
-                                                            </div>
-                                                        </span>
-                                                    </th>
-                                                </aura:if>
-                                            </aura:if>
-                                        </aura:if> 
-                                    </aura:if>
-                                    <aura:if isTrue="{!IF(curr.sj_code =='鍥藉唴閲囪喘',true,false)}">
-                                        <th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count}">
-                                            <span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
-                                                <div class="slds-truncate">
-                                                    鍥藉唴閲囪喘
-                                                </div>
-                                            </span>
-                                        </th>
-                                    </aura:if>
-                                </tr>
-                            </aura:iteration>
-                        </tbody>
-                    </aura:if>
-                </table>
-                <aura:if isTrue="{!empty(v.currentData)}">
-                <div class="slds-align_absolute-center">
-                    No records found
-                </div>
-            </aura:if>
-            </div>
-        </div>
-    </div>
+														</div>
+													</span>
+												</th>
+											</aura:if>
+											<!-- 鍙湁涓嬭浇 -->
+											<aura:if isTrue="{!IF(AND(curr.sj_code !='',curr.sj_code.length > 25,curr.sj_codeyu ==''),true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count_sj}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															<!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">涓嬭浇</a> -->
+															<a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">涓嬭浇</a>
+														</div>
+													</span>
+												</th>
+											</aura:if>
+											<!-- 鍏朵粬鎯呭喌鏄剧ず鑷繁 -->
+											<aura:if isTrue="{!IF(AND(AND(curr.sj_codeyu !='',curr.sj_codeyu.length > 25,curr.sj_code =='')== false,AND(curr.sj_code !='',curr.sj_code.length > 25,curr.sj_codeyu =='') == false),true,false)}">
+												<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count_sj}">
+													<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+														<div class="slds-truncate">
+															<lightning:formattedText value="{!curr.sj_code}" style="padding-bottom: 3px;"/>
+														</div>
+													</span>
+												</th>
+											</aura:if>
+										</aura:if>
+										<!-- 棰勮鍜屼笅杞介兘鏈� -->
+										<aura:if isTrue="{!IF(AND(curr.sj_code !='',curr.sj_codeyu !='',curr.sj_code.length > 25,curr.sj_codeyu.length > 25),true,false)}">
+											<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" rowspan="{!curr.count_sj}">
+												<span class="slds-grid slds-grid_align-spread" style="width:240px;text-align: center;display:block;">
+													<div class="slds-truncate">
+														<!-- <a href="/eSignSystem/apex/FilePreviewDownVF?type=preview&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">棰勮</a>  |  <a href="/eSignSystem/apex/FilePreviewDownVF?type=download&amp;key={!curr.sj_awsKey}&amp;name={!curr.sj_fileName}" target="_blank">涓嬭浇</a> -->
+														<a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=preview&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">棰勮</a>  |  <a href="{!curr.iseSignSystem + '/apex/FilePreviewDownVF?type=download&amp;key=' + curr.sj_awsKey + '&amp;name=' + curr.sj_fileName}" target="_blank">涓嬭浇</a>
+													</div>
+												</span>
+											</th>
+										</aura:if>
+									</aura:if>	
+									<!-- </aura:if> -->
+									<!-- 2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start -->
+									<!-- </aura:if>
+									<aura:if isTrue="{!IF(curr.sj_code =='鍥藉唴閲囪喘',true,false)}">
+										<th class="slds-is-resizable" tabindex="-1" data-label="鍟嗘璇�" style="width: 249px;" >
+											<span class="slds-grid slds-grid_align-spread" style="width: 240px;text-align: center;display:block;">
+												<div class="slds-truncate">
+													鍥藉唴閲囪喘鍝�
+												</div>
+											</span>
+										</th>
+									</aura:if> -->
+									<!-- 2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end -->
+								</tr>
+							</aura:iteration>
+						</tbody>
+					</aura:if>
+				</table>
+				<aura:if isTrue="{!empty(v.currentData)}">
+				<div class="slds-align_absolute-center">
+					No records found
+				</div>
+			</aura:if>
+			</div>
+		</div>
+	</div>
 </aura:component>
\ No newline at end of file
diff --git a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayController.js b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayController.js
index b185cde..3a90f06 100644
--- a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayController.js
+++ b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayController.js
@@ -4,6 +4,12 @@
     },
     doInit : function(cmp, event, helper) {
         // 璁剧疆鏄庣粏椤佃〃鏍肩殑鏋勯��
+        console.log('hello zhj');
         helper.getFrameNumManage(cmp);
-    }
+    },
+    //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+    rebackDNListPage: function(cmp, event, helper) {
+        helper.rebackDNListPage(cmp);
+    },
+    //20230302 杩涘彛鍗曡瘉鏀归�� fy end
 })
\ No newline at end of file
diff --git a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayHelper.js b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayHelper.js
index b2819b6..27846d1 100644
--- a/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayHelper.js
+++ b/force-app/main/default/aura/AttachmentDisplay/AttachmentDisplayHelper.js
@@ -1,10 +1,19 @@
+/*
+ * @Author: Thhto 997058689@qq.com
+ * @Date: 2022-11-04 14:53:06
+ * @LastEditors: Thhto 997058689@qq.com
+ * @LastEditTime: 2023-03-02 17:50:25
+ * @FilePath: \ceshihuanj\force-app\main\default\aura\AttachmentDisplay\AttachmentDisplayHelper.js
+ * @Description: 杩欐槸榛樿璁剧疆,璇疯缃甡customMade`, 鎵撳紑koroFileHeader鏌ョ湅閰嶇疆 杩涜璁剧疆: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
+ */
 ({
     // 鑾峰彇鏁版嵁
     getFrameNumManage : function(cmp) {
         debugger
         // this.showSpinner(cmp);
         var action = cmp.get("c.getFrameNumManage");
-        var DNId = cmp.get('v.DNId').toString();
+        // var DNId = cmp.get('v.DNId').toString();
+        var DNId = this.getQueryVariable('DNId');
         action.setParams({
             'DNId' : DNId,
         });
@@ -30,4 +39,22 @@
         var spinner = cmp.find("mySpinner");
         $A.util.addClass(spinner, "slds-hide");
     },
+    getQueryVariable: function(variable) { //id瀛楃涓�
+        var query = window.location.search.substring(1);
+        var vars = query.split("&");
+        for (var i = 0; i < vars.length; i++) {
+            var pair = vars[i].split("=");
+            if (pair[0] == variable) {
+                return pair[1];
+            }
+        }
+        return (false);
+    },
+    //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+    rebackDNListPage: function(variable) { //id瀛楃涓�
+        debugger
+        var AgencyIDM = this.getQueryVariable('AgencyIDM');
+        window.open('/eSignSystem/s/EsignDataEntry?AgencyID='+AgencyIDM+'&pinit=true', '_self');
+    },
+    //20230302 杩涘彛鍗曡瘉鏀归�� fy end
 })
\ No newline at end of file
diff --git a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImport.cmp b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImport.cmp
index fa5fcff..fd092dc 100644
--- a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImport.cmp
+++ b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImport.cmp
@@ -1,3 +1,11 @@
+<!--
+ * @Author: Thhto 997058689@qq.com
+ * @Date: 2022-07-08 10:47:25
+ * @LastEditors: Thhto 997058689@qq.com
+ * @LastEditTime: 2023-02-03 15:25:46
+ * @FilePath: \ceshihuanj\force-app\main\default\aura\DealerPersonnelInformationImport\DealerPersonnelInformationImport.cmp
+ * @Description: 杩欐槸榛樿璁剧疆,璇疯缃甡customMade`, 鎵撳紑koroFileHeader鏌ョ湅閰嶇疆 杩涜璁剧疆: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
+-->
 <aura:component controller="DealerPersonnelController"
 implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,force:lightningQuickAction,forceCommunity:availableForAllPageTypes"
 access="global">
@@ -28,7 +36,7 @@
     </aura:renderIf>
 <!-- 鎵归噺娣诲姞鍛ㄦ姤 start-->
 <div class="slds-modal slds-fade-in-open slds-hide" aura:id="errorDiv" style="z-index: 10001">
-    <ui:inputText aura:id="articleURL" />
+    <!-- <ui:inputText aura:id="articleURL" /> -->
     <div class="demo-only" style="height: 8rem;">
         <div class="slds-notify_container slds-is-relative">
             <div class="slds-notify slds-notify_toast slds-theme_error" role="status">
@@ -37,7 +45,10 @@
                         class="slds-notify__content slds-m-left_small slds-align_absolute-center slds-m-left_xx-large">
                         <lightning:icon alternativeText="error" iconName="utility:error" size="small"
                             class="buttonColor slds-m-right_small" />
-                        <h2 class="slds-text-heading_small ">{!v.errorMessage}</h2>
+                        <!-- DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start -->
+                        <!-- <h2 class="slds-text-heading_small ">{!v.errorMessage}</h2> -->
+                        <pre class="slds-text-heading_small ">{!v.errorMessage}</pre>
+                        <!-- DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end -->
                     </div>
                 </div>
             </div>
@@ -45,7 +56,7 @@
     </div>
 </div>
 <div class="slds-modal slds-fade-in-open slds-hide" aura:id="successDiv01">
-    <ui:inputText aura:id="articleURL" />
+    <!-- <ui:inputText aura:id="articleURL" /> -->
     <div class="demo-only" style="height: 8rem;">
         <div class="slds-notify_container slds-is-relative">
             <div class="slds-notify slds-notify_toast slds-theme_success" role="alert">
@@ -76,7 +87,7 @@
             <aura:set attribute="else">
                 <ui:outputRichText class="uiOutputRichText slds-m--around-large" value="{!v.TableContent}" />
                 <div class="slds-p-around--large slds-align--absolute-center">
-                    <lightning:button label="淇濆瓨" variant="brand" onclick="{!c.processFileContent}" />
+                    <lightning:button aura:id="save_con" label="淇濆瓨" variant="brand" onclick="{!c.processFileContent}" disabled="false" />
                     <lightning:button label="鍙栨秷" variant="brand" onclick="{!c.cancel}" />
                 </div>
 
diff --git a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
index b538b04..3048485 100644
--- a/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
+++ b/force-app/main/default/aura/DealerPersonnelInformationImport/DealerPersonnelInformationImportHelper.js
@@ -1,5 +1,6 @@
 ({
     readFile: function (component, helper, file) {
+        debugger
         if (!file) return;
         if (!file.name.match(/\.(csv||CSV)$/)) {
             return alert('only support csv files');
@@ -78,6 +79,7 @@
         reader.readAsDataURL(file);
     },
     saveRecords: function (component, event, helper) {
+        debugger
         component.set('v.login', true);
         var action = component.get("c.processData");
         var fieldsList = ['Name', 'Phone', 'AccountNumber']; //Please write your code dynamic fields
@@ -91,6 +93,7 @@
             if (state === "SUCCESS") {
                 var res = response.getReturnValue();
                 var res1 = '';
+                debugger;
                 if (res != 'success') {
                     var ress = res.split('=');
                     console.log(ress);
@@ -102,12 +105,14 @@
                     component.set('v.errorMessage', res1 + "璇蜂慨鏀瑰悗閲嶆柊涓婁紶");
                     this.showErrorToast(component);
                     component.set('v.login', false);
+                    component.find('save_con').set('v.disabled', true); 
                 } else {
                     // this.success('瀵煎叆鎴愬姛');
                     component.set('v.successMessage', '瀵煎叆鎴愬姛');
                     this.showSuccessToast01(component);
                     component.set("v.showMain", true);
                     component.set('v.login', false);
+                    component.find('save_con').set('v.disabled', false); 
                 }
             }
             else if (state === "INCOMPLETE") {
@@ -145,7 +150,7 @@
         window.setTimeout($A.getCallback(function () {
             $A.util.addClass(component.find('errorDiv'), 'slds-hide');
         }),
-            4000
+            7000
         );
     },
     success : function(message) {
diff --git a/force-app/main/default/aura/eSignHomePage/eSignHomePage.cmp b/force-app/main/default/aura/eSignHomePage/eSignHomePage.cmp
index 0520695..2f8fe30 100644
--- a/force-app/main/default/aura/eSignHomePage/eSignHomePage.cmp
+++ b/force-app/main/default/aura/eSignHomePage/eSignHomePage.cmp
@@ -82,6 +82,9 @@
     <!-- 鏍¢獙code -->
     <aura:attribute name="code" type="string" default="" />
     <aura:attribute name="decodeCode" type="string" default="" />
+    <!-- 20230302 杩涘彛鍗曡瘉鏀归�� fy start -->
+    <aura:attribute name="AgencyIDM" type="string" default="" />
+    <!-- 20230302 杩涘彛鍗曡瘉鏀归�� fy end -->
 
 
     <aura:attribute name="isLastPage" type="Boolean" default="false" description="鏄惁鏈�鍚庝竴椤碉紝濡傛灉鏄渶鍚庝竴椤碉紝閭d箞琛ㄦ牸鍒嗛〉鐨勪笅涓�椤典笉鍙敤" />
@@ -436,13 +439,12 @@
                             <!-- 琛岄」鐩� 绗洓鍒�  杩涘彛鍗曡瘉鏄庣粏   fy--> 
                             <!-- 杩涘彛鍗曡瘉 fy start  -->
                             <th class="slds-is-resizable" tabindex="-1" data-label="杩涘彛鍗曡瘉鏄庣粏" scope="row">
-
                                 <span class="slds-grid slds-grid_align-spread" style="text-align: center;display:block;">
                                             <div class="slds-truncate">
                                                     <!-- <lightning:formattedText value="{!curr.AttachmentName}" /> -->
                                                     <!-- <a href="https://sfpi-mebg-test.olympuschina.com:8081/stg/api/file/preview?key=20220419/8cf583ab71c94eee96da7bbfcc1b376b.html">闄勪欢鍚�1</a> -->
                                                     <button tabindex="-1" class="slds-button ReturnButton" style="width: 40px;" name="{!curr.Id}" onclick="{!c.showAttachmentDisplay}">鏌ョ湅</button>
-                                                    <!-- <a onclick="{!c.showAttachmentDisplay}">鏌ョ湅</a> -->
+                                                    <!-- <a href="{!'/eSignSystem/s/AttachmentDisplay?DNId='+ curr.Id}" target="_blank">鏌ョ湅</a> -->
                                                     <!-- <a href="https://ocsm stagefull.sandbox.file.force.com/servlet/servlet.FileDownload?file=00P1000001QkhvQ">{!curr.AttachmentName}</a> -->
                                             </div>
                                         </span>
diff --git a/force-app/main/default/aura/eSignHomePage/eSignHomePageController.js b/force-app/main/default/aura/eSignHomePage/eSignHomePageController.js
index 7fc829b..8b5559f 100644
--- a/force-app/main/default/aura/eSignHomePage/eSignHomePageController.js
+++ b/force-app/main/default/aura/eSignHomePage/eSignHomePageController.js
@@ -84,10 +84,11 @@
     },
     // 杩涘彛鍗曡瘉 fy start
     showAttachmentDisplay: function(cmp, event, helper) {
-        helper.showAttachmentDisplay(cmp, event);
+        // helper.showAttachmentDisplay(cmp, event);
+        helper.showAttachmentDisplay2(cmp, event);
     },
     rebackDNListPage: function(cmp, event, helper) {
         helper.rebackDNListPage(cmp, event);
-    }
+    },
     // 杩涘彛鍗曡瘉 fy end
 })
\ No newline at end of file
diff --git a/force-app/main/default/aura/eSignHomePage/eSignHomePageHelper.js b/force-app/main/default/aura/eSignHomePage/eSignHomePageHelper.js
index 0ed8a50..70891b5 100644
--- a/force-app/main/default/aura/eSignHomePage/eSignHomePageHelper.js
+++ b/force-app/main/default/aura/eSignHomePage/eSignHomePageHelper.js
@@ -1,6 +1,6 @@
 ({
     init: function(cmp, event) {
-
+        debugger
         // 鍒涘缓Base64瀵硅薄
         var Base64 = {
             _keyStr: "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",
@@ -84,9 +84,13 @@
         };
 
         //鍒ゆ柇url鏄惁鏈夊弬鏁�
+        debugger
         var flag = this.getURLISTrueParameter();
         //鍙傛暟瀵硅薄map
-        var paramValue = this.getURLParameterValue();
+        //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+        // var paramValue = this.getURLParameterValue();
+        var paramValue = this.getURLParameterValue(cmp);
+        //20230302 杩涘彛鍗曡瘉鏀归�� fy end
         //鍙傛暟瀵硅薄map鐨勯暱搴�
         var length = Object.keys(paramValue).length;
 
@@ -222,11 +226,25 @@
 
             //瑙g爜鍚庣殑绠$悊缂栫爜
             cmp.set("v.decodeCode", code.replace(reg, "$2"));
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy start
             //闅愯棌妫�绱㈤〉
-            cmp.set("v.DNNameInput", true);
+            // cmp.set("v.DNNameInput", true);
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy start
             //鏄剧ず棣栭〉
             cmp.set('v.buttonGroup', false);
-
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+            if(paramValue.pinit=='true'){
+                cmp.set("v.DNNameInput", false);
+                cmp.set("v.code", code.replace(reg, "$2"));
+                cmp.set('v.allWidth', document.documentElement.clientWidth - 40);
+                cmp.set('v.floatWidth', document.documentElement.clientWidth * 0.85);
+                cmp.set('v.floatWidth1', document.documentElement.clientWidth);
+                console.log('floatWidth:' + document.documentElement.clientWidth * 0.85);
+                this.getAccountHandler(cmp);
+            }else{
+                cmp.set("v.DNNameInput", true);
+            }
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy end
 
         }
         //鍒ゆ柇DNName鏄惁涓虹┖ 涓嶄负绌哄垯闅愯棌妫�绱㈤〉
@@ -1029,14 +1047,21 @@
         // add slds-hide class from mySpinner
         var spinner = cmp.find("mySpinner");
         $A.util.addClass(spinner, "slds-hide");
-    },
-    getURLParameterValue: function() {
+    }, //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+    getURLParameterValue: function(cmp) {
+    // getURLParameterValue: function() {
+       //20230302 杩涘彛鍗曡瘉鏀归�� fy end
 
-        var querystring = location.search.substr(1);
+        var querystring = window.location.search.substr(1);
         var paramValue = {};
         querystring.split("&").forEach(function(part) {
             var param = part.split("=");
             paramValue[param[0]] = decodeURIComponent(param[1]);
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+            if(param[0]=='AgencyID'){
+                cmp.set("v.AgencyIDM", param[1]);
+            }
+            //20230302 杩涘彛鍗曡瘉鏀归�� fy end
         });
 
         //console.log('paramValue-' + paramValue);
@@ -1044,7 +1069,7 @@
     },
     getURLISTrueParameter: function() {
 
-        var url = location.search;
+        var url = window.location.search;
         var flag;
         if (url.indexOf("?") != -1) {
             flag = true;
@@ -1445,7 +1470,15 @@
         debugger
         cmp.set('v.AttachmentDisplayflag', false);
         cmp.set('v.DNListPage', true);
-    }
+    },
+    showAttachmentDisplay2: function(cmp, event) {
+        debugger
+        var DNId = event.target.name;
+        //20230302 杩涘彛鍗曡瘉鏀归�� fy start
+        var AgencyIDM = cmp.get('v.AgencyIDM');
+        window.open('/eSignSystem/s/AttachmentDisplay?DNId=' + DNId+'&AgencyIDM='+AgencyIDM, '_blank');
+        //20230302 杩涘彛鍗曡瘉鏀归�� fy end
+    },
     // 杩涘彛鍗曡瘉 fy end
 
 })
\ No newline at end of file
diff --git a/force-app/main/default/classes/AttachmentDisplayController.cls b/force-app/main/default/classes/AttachmentDisplayController.cls
index 8b36c5c..2dc1e57 100644
--- a/force-app/main/default/classes/AttachmentDisplayController.cls
+++ b/force-app/main/default/classes/AttachmentDisplayController.cls
@@ -14,15 +14,34 @@
         System.debug('DNId'+DNId);
         List<testInit> newinitList = new List<testInit>();
         List<testInit> initList = new List<testInit>();
-        List<FrameNumManage__c> FnmList =[SELECT Id, Name ,ManagementCode__c,InspectionCard__c
-        , ApplyList__c ,InspectionCard_Select__c ,InspectionCard_Select__r.ViewLink__c
-        ,InspectionCard_Select__r.DownloadLink__c, ApplyList_Select__c
-        ,ApplyList_Select__r.DownloadLink__c,ApplyList_Select__r.ViewLink__c,  Num__c 
-        , SerialNumber__c,Material__c , MaterialDepict__c
-        ,ApplyList_Select__r.AWS_File_Key__c,ApplyList_Select__r.FileName__c
-        ,InspectionCard_Select__r.AWS_File_Key__c,InspectionCard_Select__r.FileName__c
+        List<FrameNumManage__c> FnmList =[SELECT Id, Name 
+        ,ManagementCode__c
+        ,InspectionCard__c
+        ,ApplyList__c 
+        ,InspectionCard_Select__c 
+        ,InspectionCard_Select__r.ViewLink__c
+        ,InspectionCard_Select__r.DownloadLink__c
+        ,ApplyList_Select__c
+        ,ApplyList_Select__r.DownloadLink__c
+        ,ApplyList_Select__r.ViewLink__c
+        ,Num__c 
+        ,SerialNumber__c
+        ,Material__c 
+        ,MaterialDepict__c
+        ,ApplyList_Select__r.AWS_File_Key__c
+        ,ApplyList_Select__r.FileName__c
+        ,InspectionCard_Select__r.AWS_File_Key__c
+        ,InspectionCard_Select__r.FileName__c
         ,HomeBuy__c
-         from FrameNumManage__c where signInForm__c =:DNId order by ApplyList__c desc,SerialNumber__c desc];
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+        ,ApplyList_NoHave__c
+        ,InspectionCard_NoHave__c  
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+        from FrameNumManage__c where signInForm__c =:DNId 
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+       //  order by ApplyList__c desc,InspectionCard__c desc,SerialNumber__c desc];
+       order by ApplyList_NoHave__c desc,InspectionCard_NoHave__c desc ,SerialNumber__c desc];
+       //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
         set<String> FileStrSet = new set<String>();
         List<FileAddress__c> FileList = new List<FileAddress__c>();
         Map<String,String> FileStrMap = new Map<String,String>();
@@ -39,14 +58,18 @@
         // }
         List<FrameNumManage__c> FnmListhomebuy = new List<FrameNumManage__c>();
         List<FrameNumManage__c> notFnmListhomebuy = new List<FrameNumManage__c>();
-        for(FrameNumManage__c fr : FnmList){
-            if(fr.HomeBuy__c){
-                FnmListhomebuy.add(fr);
-            }else{
-                notFnmListhomebuy.add(fr);
-            }
-        }
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+        // for(FrameNumManage__c fr : FnmList){
+        //     if(fr.HomeBuy__c){
+        //         FnmListhomebuy.add(fr);
+        //     }else{
+        //         notFnmListhomebuy.add(fr);
+        //     }
+        // }
+        notFnmListhomebuy = FnmList;
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
         Integer n = 0; // 鍒濆鍖栧悎骞惰鏁�
+        Integer n_sj = 0; // 鍒濆鍖栧悎骞惰鏁帮紙鍟嗘璇侊級 2023-01-10 fy add
         for (Integer i=0;i<notFnmListhomebuy.size() ;i++ ) {
             testInit init = new testInit();
             if (i==0) {
@@ -61,40 +84,78 @@
                 // }else{
                 // 	init.code = '鏃�';
                 // } 
-                if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
-                	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
-                		init.code = '涓嶅嚭璇�';
-                	}else{
-                		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
-                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
-		                	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
-		                }else{
-		                	init.codeyu = '';
-		                }
-                		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
-                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
-		                	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
-		                }else{
-		                	init.code = '';
-		                }
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__c)) {
+                    // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+                        init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+                    }else{
+                        init.codeyu = '';
+                    }
+                    // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+                        init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+                    }else{
+                        init.code = '';
+                    }
+                    //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+                        init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+                    }else{
+                        init.awsKey = '';
+                    }
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+                        init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+                    }else{
+                        init.fileName = '';
+                    }
+                    //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                }else {
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_NoHave__c)) {
+                        init.code = notFnmListhomebuy[i].ApplyList_NoHave__c;
+                    }else{
+                        init.code = '';
+                    }
+                    init.codeyu = '';
+                    init.awsKey = '';       // zhj 2022-12-08 
+                    init.fileName = '';     // zhj 2022-12-08
+                } 
+                // if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
+                // 	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
+                // 		init.code = '涓嶅嚭璇�';
+                // 	}else{
+                // 		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+		        //         	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+		        //         }else{
+		        //         	init.codeyu = '';
+		        //         }
+                // 		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+		        //         	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+		        //         }else{
+		        //         	init.code = '';
+		        //         }
 
-                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
-		                	init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
-		                }else{
-		                	init.awsKey = '';
-		                }
-                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
-		                	init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
-		                }else{
-		                	init.fileName = '';
-		                }
-                	}
-                }else{
-                	init.code = '';
-                	init.codeyu = '';
-                    init.awsKey = '';
-                    init.fileName = '';
-                }
+                //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+		        //         	init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+		        //         }else{
+		        //         	init.awsKey = '';
+		        //         }
+                //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+		        //         	init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+		        //         }else{
+		        //         	init.fileName = '';
+		        //         }
+                // 	}
+                // }else{
+                // 	init.code = '';
+                // 	init.codeyu = '';
+                //     init.awsKey = '';
+                //     init.fileName = '';
+                // }
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                
                 // //2022-12-05 fy add 鎶ュ叧鍗曞垽鏂�
                 // //if (String.isNotBlank(FnmList[i].InspectionCard_Select__r.DownloadLink__c)) {
                 // if (notFnmListhomebuy[i].InspectionCard__c =='涓嶅嚭璇�') {
@@ -105,60 +166,114 @@
                 // 	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
                 //     init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
                 // } //2022-12-05 fy add 鍟嗘璇佸垽鏂�
-                if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
-                	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
-                		init.sj_code = '涓嶅嚭璇�';
-                	}else{
-                		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
-                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
-		                	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
-		                }else{
-		                	init.sj_codeyu = '';
-		                }
-                		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
-                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
-		                	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
-		                }else{
-		                	init.sj_code = '';
-		                }
-                        //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
-                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
-		                	init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
-		                }else{
-		                	init.sj_awsKey = '';
-		                }
-                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
-		                	init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
-		                }else{
-		                	init.sj_fileName = '';
-		                }
-                        //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
-                	}
-                }else{
-                	init.sj_code = '';
-                	init.sj_codeyu = '';
-                    init.sj_awsKey = '';       // zhj 2022-12-19 
-                    init.sj_fileName = '';     // zhj 2022-12-19
-                }
-                //2022-12-26 fy add 鏀归�� end
-                
+                 //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                 if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__c)) {
+                    // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+                        init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+                    }else{
+                        init.sj_codeyu = '';
+                    }
+                    // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+                        init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+                    }else{
+                        init.sj_code = '';
+                    }
+                    //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+                        init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+                    }else{
+                        init.sj_awsKey = '';
+                    }
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+                        init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+                    }else{
+                        init.sj_fileName = '';
+                    }
+                    //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                }else {
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_NoHave__c)) {
+                        init.sj_code = notFnmListhomebuy[i].InspectionCard_NoHave__c;
+                    }else{
+                        init.sj_code = '';
+                    }
+                    init.sj_codeyu = '';
+                    init.sj_awsKey = '';       // zhj 2022-12-08 
+                    init.sj_fileName = '';     // zhj 2022-12-08
+                } 
+                // if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
+                // 	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
+                // 		init.sj_code = '涓嶅嚭璇�';
+                // 	}else{
+                // 		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
+                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+		        //         	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+		        //         }else{
+		        //         	init.sj_codeyu = '';
+		        //         }
+                // 		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
+                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+		        //         	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+		        //         }else{
+		        //         	init.sj_code = '';
+		        //         }
+                //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
+                //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+		        //         	init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+		        //         }else{
+		        //         	init.sj_awsKey = '';
+		        //         }
+                //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+		        //         	init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+		        //         }else{
+		        //         	init.sj_fileName = '';
+		        //         }
+                //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
+                // 	}
+                // }else{
+                // 	init.sj_code = '';
+                // 	init.sj_codeyu = '';
+                //     init.sj_awsKey = '';       // zhj 2022-12-19 
+                //     init.sj_fileName = '';     // zhj 2022-12-19
+                // }
+                // //2022-12-26 fy add 鏀归�� end
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+
                 // init.code = FileStrMap.get(FnmList[i].ApplyList__c);
                 init.Num = notFnmListhomebuy[i].Num__c;
                 init.Id = notFnmListhomebuy[i].Id;
                 init.FrameNo = notFnmListhomebuy[i].SerialNumber__c;
                 n = n+1;
+                n_sj = n_sj+1; // 2023-01-10   fy   add
                 if (i != notFnmListhomebuy.size()-1) {
                     // 鍒ゆ柇绗竴涓笌绗簩涓槸鍚︿竴鏍凤紝涓嶄竴鏍疯祴鍊�1
-                    if (notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c) {
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    // if (notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c) {
+                    if (notFnmListhomebuy[i].ApplyList_NoHave__c != notFnmListhomebuy[i+1].ApplyList_NoHave__c) {
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
                         init.count = n;
                     }
+                    // 2023-01-10 fy  add start
+                    // 鍒ゆ柇绗竴涓笌涓嬩竴涓槸鍚︿竴鏍凤紝涓嶄竴鏍疯祴鍊�1鈥斺�斿晢妫�璇�
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    // if (notFnmListhomebuy[i].InspectionCard__c != notFnmListhomebuy[i+1].InspectionCard__c) {
+                    if (notFnmListhomebuy[i].InspectionCard_NoHave__c != notFnmListhomebuy[i+1].InspectionCard_NoHave__c) {
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                        init.count_sj = n_sj;
+                    }
+                    // 2023-01-10 fy  add end
                 }else if(notFnmListhomebuy.size() == 1){
                     init.count = 1;
+                    init.count_sj = 1; // 2023-01-10   fy   add   濡傛灉鍙湁涓�鏉�  璧嬪�煎悎骞惰鏁�
                 }
             System.debug('init1===='+init);
             }else {
                 // 鍒ゆ柇涓庡墠涓�涓紪鐮佹槸涓�鑷�
-                if (notFnmListhomebuy[i].ApplyList__c == notFnmListhomebuy[i-1].ApplyList__c) {
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                // if (notFnmListhomebuy[i].ApplyList__c == notFnmListhomebuy[i-1].ApplyList__c) {
+                if (notFnmListhomebuy[i].ApplyList_NoHave__c == notFnmListhomebuy[i-1].ApplyList_NoHave__c) {
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
                     init.Name = notFnmListhomebuy[i].ManagementCode__c;
                     init.ProductName = notFnmListhomebuy[i].Material__c + '-' + notFnmListhomebuy[i].MaterialDepict__c;
 
@@ -170,41 +285,80 @@
 	                // }else{
 	                // 	init.code = '鏃�';
 	                // } //2022-12-05 fy add 鎶ュ叧鍗曞垽鏂�
-                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
-	                	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
-	                		init.code = '涓嶅嚭璇�';
-	                	}else{
-	                		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
-			                	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
-			                }else{
-			                	init.codeyu = '';
-			                }
-	                		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
-			                	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
-			                }else{
-			                	init.code = '';
-			                }
-                            //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
-                            if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
-                                init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
-                            }else{
-                                init.awsKey = '';
-                            }
-                            if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
-                                init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
-                            }else{
-                                init.fileName = '';
-                            }
-                            //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__c)) {
+                        // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+                            init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+                        }else{
+                            init.codeyu = '';
                         }
-	                }else{
-	                	init.code = '';
-	                	init.codeyu = '';
+                        // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+                            init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+                        }else{
+                            init.code = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+                            init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+                        }else{
+                            init.awsKey = '';
+                        }
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+                            init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+                        }else{
+                            init.fileName = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    }else {
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_NoHave__c)) {
+                            init.code = notFnmListhomebuy[i].ApplyList_NoHave__c;
+                        }else{
+                            init.code = '';
+                        }
+                        init.codeyu = '';
                         init.awsKey = '';       // zhj 2022-12-08 
                         init.fileName = '';     // zhj 2022-12-08
-	                }
+                    } 
+
+                    // if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
+	                // 	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
+	                // 		init.code = '涓嶅嚭璇�';
+	                // 	}else{
+	                // 		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+			        //         	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+			        //         }else{
+			        //         	init.codeyu = '';
+			        //         }
+	                // 		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+			        //         	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+			        //         }else{
+			        //         	init.code = '';
+			        //         }
+                    //         //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+                    //             init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+                    //         }else{
+                    //             init.awsKey = '';
+                    //         }
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+                    //             init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+                    //         }else{
+                    //             init.fileName = '';
+                    //         }
+                    //         //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    //     }
+	                // }else{
+	                // 	init.code = '';
+	                // 	init.codeyu = '';
+                    //     init.awsKey = '';       // zhj 2022-12-08 
+                    //     init.fileName = '';     // zhj 2022-12-08
+	                // }
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+
                     //if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
                     // if (notFnmListhomebuy[i].InspectionCard__c =='涓嶅嚭璇�') {
                     //     init.sj_code = '涓嶅嚭璇�';
@@ -216,43 +370,81 @@
                     // }
                     // //2022-12-05 fy add 鍟嗘璇佸垽鏂�
 
-                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
-	                	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
-	                		init.sj_code = '涓嶅嚭璇�';
-	                	}else{
-	                		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
-			                	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
-			                }else{
-			                	init.sj_codeyu = '';
-			                }
-	                		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
-			                	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
-			                }else{
-			                	init.sj_code = '';
-			                }
-                            //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
-                            if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
-                                init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
-                            }else{
-                                init.sj_awsKey = '';
-                            }
-                            if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
-                                init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
-                            }else{
-                                init.sj_fileName = '';
-                            }
-                            //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
-	                	}
-	                }else{
-	                	init.sj_code = '';
-	                	init.sj_codeyu = '';
-                        init.sj_awsKey = '';       // zhj 2022-12-19 
-                        init.sj_fileName = '';     // zhj 2022-12-19
-	                }
-                    //2022-12-26 fy add 鏀归�� end
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__c)) {
+                        // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+                            init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+                        }else{
+                            init.sj_codeyu = '';
+                        }
+                        // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+                            init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+                        }else{
+                            init.sj_code = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+                            init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+                        }else{
+                            init.sj_awsKey = '';
+                        }
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+                            init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+                        }else{
+                            init.sj_fileName = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    }else {
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_NoHave__c)) {
+                            init.sj_code = notFnmListhomebuy[i].InspectionCard_NoHave__c;
+                        }else{
+                            init.sj_code = '';
+                        }
+                        init.sj_codeyu = '';
+                        init.sj_awsKey = '';       // zhj 2022-12-08 
+                        init.sj_fileName = '';     // zhj 2022-12-08
+                    } 
 
+                    // if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
+	                // 	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
+	                // 		init.sj_code = '涓嶅嚭璇�';
+	                // 	}else{
+	                // 		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+			        //         	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+			        //         }else{
+			        //         	init.sj_codeyu = '';
+			        //         }
+	                // 		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+			        //         	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+			        //         }else{
+			        //         	init.sj_code = '';
+			        //         }
+                    //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+                    //             init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+                    //         }else{
+                    //             init.sj_awsKey = '';
+                    //         }
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+                    //             init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+                    //         }else{
+                    //             init.sj_fileName = '';
+                    //         }
+                    //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
+	                // 	}
+	                // }else{
+	                // 	init.sj_code = '';
+	                // 	init.sj_codeyu = '';
+                    //     init.sj_awsKey = '';       // zhj 2022-12-19 
+                    //     init.sj_fileName = '';     // zhj 2022-12-19
+	                // }
+                    // //2022-12-26 fy add 鏀归�� end
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                    
                     // init.code = FileStrMap.get(notFnmListhomebuy[i].ApplyList__c);
                     init.Num = notFnmListhomebuy[i].Num__c;
                     init.Id = notFnmListhomebuy[i].Id;
@@ -261,7 +453,10 @@
                     // 鍒ゆ柇鏄笉鏄渶鍚庝竴涓�
                     if (i != notFnmListhomebuy.size()-1) {
                         // 涓嶆槸鏈�鍚庝竴涓紝鍒ゆ柇涓庝笅涓�涓紪鐮佷竴鑷翠笉涓�鑷达紝涓嶄竴鑷寸洿鎺ヨ祴鍊�
-                        if (notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c) {
+                         //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                        // if (notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c) {
+                        if (notFnmListhomebuy[i].ApplyList_NoHave__c != notFnmListhomebuy[i+1].ApplyList_NoHave__c) {
+                        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
                             init.count = n;
                         }
                     }
@@ -284,41 +479,80 @@
 	                // }else{
 	                // 	init.code = '鏃�';
 	                // } //2022-12-05 fy add 鎶ュ叧鍗曞垽鏂�
-                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
-	                	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
-	                		init.code = '涓嶅嚭璇�';
-	                	}else{
-	                		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
-			                	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
-			                }else{
-			                	init.codeyu = '';
-			                }
-	                		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
-			                	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
-			                }else{
-			                	init.code = '';
-			                }
-                            //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
-                            if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
-                                init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
-                            }else{
-                                init.awsKey = '';
-                            }
-                            if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
-                                init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
-                            }else{
-                                init.fileName = '';
-                            }
-                            //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
-	                	}
-	                }else{
-	                	init.code = '';
-	                	init.codeyu = '';
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__c)) {
+                        // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+                            init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+                        }else{
+                            init.codeyu = '';
+                        }
+                        // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+                            init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+                        }else{
+                            init.code = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+                            init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+                        }else{
+                            init.awsKey = '';
+                        }
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+                            init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+                        }else{
+                            init.fileName = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    }else {
+                        if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_NoHave__c)){
+                            init.code = notFnmListhomebuy[i].ApplyList_NoHave__c;
+                        }else{
+                            init.code = '';
+                        }
+                        init.codeyu = '';
                         init.awsKey = '';       // zhj 2022-12-08 
                         init.fileName = '';     // zhj 2022-12-08
-	                }
+                    } 
+
+                    // if (String.isNotBlank(notFnmListhomebuy[i].ApplyList__c)) {
+	                // 	if (notFnmListhomebuy[i].ApplyList__c.equals('涓嶅嚭璇�')) {
+	                // 		init.code = '涓嶅嚭璇�';
+	                // 	}else{
+	                // 		// 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c)) {
+			        //         	init.codeyu = notFnmListhomebuy[i].ApplyList_Select__r.ViewLink__c;
+			        //         }else{
+			        //         	init.codeyu = '';
+			        //         }
+	                // 		// 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c)) {
+			        //         	init.code = notFnmListhomebuy[i].ApplyList_Select__r.DownloadLink__c;
+			        //         }else{
+			        //         	init.code = '';
+			        //         }
+                    //         //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c)) {
+                    //             init.awsKey = notFnmListhomebuy[i].ApplyList_Select__r.AWS_File_Key__c;
+                    //         }else{
+                    //             init.awsKey = '';
+                    //         }
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].ApplyList_Select__r.FileName__c)) {
+                    //             init.fileName = notFnmListhomebuy[i].ApplyList_Select__r.FileName__c;
+                    //         }else{
+                    //             init.fileName = '';
+                    //         }
+                    //         //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+	                // 	}
+	                // }else{
+	                // 	init.code = '';
+	                // 	init.codeyu = '';
+                    //     init.awsKey = '';       // zhj 2022-12-08 
+                    //     init.fileName = '';     // zhj 2022-12-08
+	                // }
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                    
                     //if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
                     // if (notFnmListhomebuy[i].InspectionCard__c =='涓嶅嚭璇�') {
                     //     init.sj_code = '涓嶅嚭璇�';
@@ -329,53 +563,129 @@
                     //     init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
                     // }
                     //2022-12-05 fy add 鍟嗘璇佸垽鏂�
-                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
-	                	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
-	                		init.sj_code = '涓嶅嚭璇�';
-	                	}else{
-	                		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
-			                	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
-			                }else{
-			                	init.sj_codeyu = '';
-			                }
-	                		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
-	                		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
-			                	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
-			                }else{
-			                	init.sj_code = '';
-			                }
-                            //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
-                            if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
-                                init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
-                            }else{
-                                init.sj_awsKey = '';
-                            }
-                            if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
-                                init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
-                            }else{
-                                init.sj_fileName = '';
-                            }
-                            //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
-	                	}
-	                }else{
-	                	init.sj_code = '';
-	                	init.sj_codeyu = '';
-                        init.sj_awsKey = '';       // zhj 2022-12-19 
-                        init.sj_fileName = '';     // zhj 2022-12-19
-	                }
-                    //2022-12-26 fy add 鏀归�� end
+
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__c)) {
+                        // 鎶ュ叧鍗曢瑙堥摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+                            init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+                        }else{
+                            init.sj_codeyu = '';
+                        }
+                        // 鎶ュ叧鍗曚笅杞介摼鎺ュ垽鏂�
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+                            init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+                        }else{
+                            init.sj_code = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 start
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+                            init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+                        }else{
+                            init.sj_awsKey = '';
+                        }
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+                            init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+                        }else{
+                            init.sj_fileName = '';
+                        }
+                        //鎶ュ叧鍗昦wkey,filename鍒ゆ柇 zhj 2022-12-08 end
+                    }else {
+                        if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_NoHave__c)) {
+                            init.sj_code = notFnmListhomebuy[i].InspectionCard_NoHave__c;
+                        }else{
+                            init.sj_code = '';
+                        }
+                        init.sj_codeyu = '';
+                        init.sj_awsKey = '';       // zhj 2022-12-08 
+                        init.sj_fileName = '';     // zhj 2022-12-08
+                    } 
+
+                    // if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard__c)) {
+	                // 	if (notFnmListhomebuy[i].InspectionCard__c.equals('涓嶅嚭璇�')) {
+	                // 		init.sj_code = '涓嶅嚭璇�';
+	                // 	}else{
+	                // 		// 鍟嗘璇侀瑙堥摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c)) {
+			        //         	init.sj_codeyu = notFnmListhomebuy[i].InspectionCard_Select__r.ViewLink__c;
+			        //         }else{
+			        //         	init.sj_codeyu = '';
+			        //         }
+	                // 		// 鍟嗘璇佷笅杞介摼鎺ュ垽鏂�
+	                // 		if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c)) {
+			        //         	init.sj_code = notFnmListhomebuy[i].InspectionCard_Select__r.DownloadLink__c;
+			        //         }else{
+			        //         	init.sj_code = '';
+			        //         }
+                    //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 start
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c)) {
+                    //             init.sj_awsKey = notFnmListhomebuy[i].InspectionCard_Select__r.AWS_File_Key__c;
+                    //         }else{
+                    //             init.sj_awsKey = '';
+                    //         }
+                    //         if (String.isNotBlank(notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c)) {
+                    //             init.sj_fileName = notFnmListhomebuy[i].InspectionCard_Select__r.FileName__c;
+                    //         }else{
+                    //             init.sj_fileName = '';
+                    //         }
+                    //         //鍟嗘璇乤wkey,filename鍒ゆ柇 zhj 2022-12-19 end
+	                // 	}
+	                // }else{
+	                // 	init.sj_code = '';
+	                // 	init.sj_codeyu = '';
+                    //     init.sj_awsKey = '';       // zhj 2022-12-19 
+                    //     init.sj_fileName = '';     // zhj 2022-12-19
+	                // }
+                    // //2022-12-26 fy add 鏀归�� end
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
 
                     // init.code = FileStrMap.get(notFnmListhomebuy[i].ApplyList__c);
                     init.Num = notFnmListhomebuy[i].Num__c;
                     init.Id = notFnmListhomebuy[i].Id;
                     init.FrameNo = notFnmListhomebuy[i].SerialNumber__c;
                     n = n+1;
-                    if((i<notFnmListhomebuy.size()-1 && notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c)||(i == notFnmListhomebuy.size()-1)){
+
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                    // if((i<notFnmListhomebuy.size()-1 && notFnmListhomebuy[i].ApplyList__c != notFnmListhomebuy[i+1].ApplyList__c)||(i == notFnmListhomebuy.size()-1)){
+                    if((i<notFnmListhomebuy.size()-1 && notFnmListhomebuy[i].ApplyList_NoHave__c != notFnmListhomebuy[i+1].ApplyList_NoHave__c)||(i == notFnmListhomebuy.size()-1)){
+                    //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+
                       init.count =n;
                     }
                 System.debug('init3===='+init);
                 }
+                // 2023-01-10   fy   add   start   鍟嗘璇佹帓搴忓悎骞�
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                // if (notFnmListhomebuy[i].InspectionCard__c == notFnmListhomebuy[i-1].InspectionCard__c) {
+                if (notFnmListhomebuy[i].InspectionCard_NoHave__c == notFnmListhomebuy[i-1].InspectionCard_NoHave__c) {
+                //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                    n_sj = n_sj+1;
+                    if (i != notFnmListhomebuy.size()-1) {
+                        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                        // if (notFnmListhomebuy[i].InspectionCard__c != notFnmListhomebuy[i+1].InspectionCard__c) {
+                        if (notFnmListhomebuy[i].InspectionCard_NoHave__c != notFnmListhomebuy[i+1].InspectionCard_NoHave__c) {
+                        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                            init.count_sj = n_sj;
+                        }
+                    }else{
+                        init.count_sj = n_sj;
+                    }
+
+                }else{
+                    n_sj = 0;
+                    n_sj = n_sj+1;
+                    if (i == notFnmListhomebuy.size()-1) {
+                        init.count_sj = n_sj;
+                    }else{
+                        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+                        // if (notFnmListhomebuy[i].InspectionCard__c != notFnmListhomebuy[i+1].InspectionCard__c) {
+                            if (notFnmListhomebuy[i].InspectionCard_NoHave__c != notFnmListhomebuy[i+1].InspectionCard_NoHave__c) {
+                        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
+                            init.count_sj = n_sj;
+                        }
+                    }
+                }
+                // 2023-01-10   fy   add   end   鍟嗘璇佹帓搴忓悎骞�
             }
             //zhj 濡傛灉鏄痚SignSystem闇�瑕佸姞涓婅繖涓墠缂�閾炬帴  2023-01-04 start
             if(bool){
@@ -386,19 +696,21 @@
             //zhj 濡傛灉鏄痚SignSystem闇�瑕佸姞涓婅繖涓墠缂�閾炬帴  2023-01-04 end
             initList.add(init);
         }
-        List<testInit> newinitListhomebuy = new List<testInit>();
-        for(FrameNumManage__c fr : FnmListhomebuy){
-            testInit init = new testInit();
-            init.Name=fr.ManagementCode__c;
-            init.ProductName=fr.Material__c + '-' + fr.MaterialDepict__c;
-            init.FrameNo=fr.SerialNumber__c;
-            init.code='鍥藉唴閲囪喘';
-            init.sj_code='鍥藉唴閲囪喘';
-            init.Num=fr.Num__c;
-            init.Id=fr.Id;
-            init.count=1;
-            newinitListhomebuy.add(init);
-        }
+         //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+        // List<testInit> newinitListhomebuy = new List<testInit>();
+        // for(FrameNumManage__c fr : FnmListhomebuy){
+        //     testInit init = new testInit();
+        //     init.Name=fr.ManagementCode__c;
+        //     init.ProductName=fr.Material__c + '-' + fr.MaterialDepict__c;
+        //     init.FrameNo=fr.SerialNumber__c;
+        //     init.code='鍥藉唴閲囪喘';
+        //     init.sj_code='鍥藉唴閲囪喘';
+        //     init.Num=fr.Num__c;
+        //     init.Id=fr.Id;
+        //     init.count=1;
+        //     newinitListhomebuy.add(init);
+        // }
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
         // 鍊掑簭鏄剧ず
         for (Integer i = initList.size()-1; i>=0 ; i--) {
             testInit init = new testInit();
@@ -406,11 +718,13 @@
             newinitList.add(init);
         }
          // newinitList.addAll(newinitListhomebuy);
-         newinitListhomebuy.addAll(newinitList);
-         newinitList=newinitListhomebuy;
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 start
+        //  newinitListhomebuy.addAll(newinitList);
+        //  newinitList=newinitListhomebuy;
+        //2023 0208 fy add   鎶ュ叧鍗曞晢妫�璇佹柊闇�姹傦紝閲嶆柊鍒ゆ柇 end
         System.debug('newinitList'+newinitList);
         System.debug('FnmList'+FnmList);
-        System.debug('newinitListhomebuy'+newinitListhomebuy);
+        // System.debug('newinitListhomebuy'+newinitListhomebuy);
         return newinitList;
 
     }
@@ -439,6 +753,8 @@
         @AuraEnabled
         public Integer count;
         @AuraEnabled
+        public Integer count_sj;//2023-01-10 fy add 鍟嗘璇佸崟鐙悎骞�
+        @AuraEnabled
         public String awsKey;
         @AuraEnabled          
         public String fileName;
diff --git a/force-app/main/default/classes/AttachmentDisplayController.cls-meta.xml b/force-app/main/default/classes/AttachmentDisplayController.cls-meta.xml
new file mode 100644
index 0000000..4b0bc9f
--- /dev/null
+++ b/force-app/main/default/classes/AttachmentDisplayController.cls-meta.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<ApexClass xmlns="http://soap.sforce.com/2006/04/metadata">
+    <apiVersion>55.0</apiVersion>
+    <status>Active</status>
+</ApexClass>
diff --git a/force-app/main/default/classes/AttachmentDisplayControllerTest.cls b/force-app/main/default/classes/AttachmentDisplayControllerTest.cls
new file mode 100644
index 0000000..f484432
--- /dev/null
+++ b/force-app/main/default/classes/AttachmentDisplayControllerTest.cls
@@ -0,0 +1,379 @@
+@isTest 
+public class AttachmentDisplayControllerTest {
+    static testMethod void TestInit01(){
+        List<RecordType> rectCo = [select Id from RecordType where IsActive = true and SobjectType = 'Account' and Name = '鐥呴櫌'];
+        if (rectCo.size() == 0) {
+            return;
+        }
+        List<RecordType> rectSct = [select Id from RecordType where IsActive = true and SobjectType = 'Account' and Name = '鎴︾暐绉戝鍒嗛 鍛煎惛绉�'];
+        if (rectSct.size() == 0) {
+            return;
+        }
+        List<RecordType> rectDpt = [select Id, Name from RecordType where IsActive = true and SobjectType = 'Account' and Name IN ('瑷虹檪绉� 娑堝寲绉�', '瑷虹檪绉� 鍛煎惛绉�') order by Name desc];
+        if (rectDpt.size() == 0) {
+            return;
+        }
+         List<RecordType> rectAs = [select Id, Name from RecordType where IsActive = true and SobjectType = 'Asset' and Name = '澶囧搧'];
+        if (rectAs.size() == 0) {
+            return;
+        }
+
+     
+        // insert hospital
+        Account company1 = new Account();
+        company1.RecordTypeId = rectCo[0].Id;
+        company1.Name = '鐥呴櫌銉嗐偣銉�1';
+        company1.OCM_man_province_txt__c = '姹熻タ';
+        company1.AgentCode_Ext__c = '888888';
+        List<Account> hps = new Account[]{company1};
+        insert hps;
+          
+        List<Account> dc1s = [Select Id, Name, Department_Class_Label__c, Sys_Dept_Name_Change_Chk__c from Account where Parent.Id = :company1.Id order by Department_Class_Label__c];
+        
+        Account depart1 = new Account();
+        depart1.RecordTypeId = rectDpt[0].Id;
+        depart1.Name         = '*';
+        depart1.Department_Name__c  = '瑷虹檪绉�1';
+        depart1.ParentId            = dc1s[0].Id;
+        depart1.Department_Class__c = dc1s[0].Id;
+        depart1.Hospital__c         = company1.Id;
+        depart1.OCM_man_province_txt__c = '姹熻タ';
+        // depart1.AgentCode_Ext__c = '888888';
+        
+        insert new Account[] {depart1};
+
+        List<Product2> prdList = new List<Product2>();
+        Product2 prd1 = new Product2();
+        prd1.ProductCode_Ext__c     = 'HistoryPrd1';
+        prd1.ProductCode            = 'HistoryPrd1';
+        prd1.Repair_Product_Code__c = 'HistoryPrd1_RP';
+        prd1.Name                   = 'HistoryPrd1';
+        prd1.Manual_Entry__c        = false;
+        prd1.Extend_new_product_gurantee__c = true;
+        prd1.Extend_Gurantee_Start__c = Date.today().addDays(-60);
+        prd1.Extend_Gurantee_End__c = Date.today().addDays(60);
+        prd1.HomeBuy__c=true;
+        prdList.add(prd1);
+        insert prdList;
+    
+        Asset ast = new Asset();
+
+        ast.RecordTypeId = rectAs[0].Id;
+        ast.SerialNumber = 'abcdefg';
+        ast.Name = '娴嬭瘯璧勪骇1';
+        ast.AccountId              = depart1.Id;
+        ast.Department_Class__c    = dc1s[0].Id;
+        ast.Hospital__c            = company1.Id;
+        ast.Product2Id             = prd1.Id;
+        ast.Guarantee_period_for_products__c = Date.today();
+        ast.InstallDate                      = Date.today();
+        ast.Manage_type__c = '涓綋绠$悊';
+        ast.FirstApproveDate_old__c = Date.today().addDays(-30);
+
+        Oly_TriggerHandler.bypass('AssetHandler');
+
+        insert ast;
+        
+        Asset ast1 = [select RecordTypeID__c from Asset where Id =: ast.Id];
+        
+        String RecordTypeID = ast1.RecordTypeID__c;
+           
+        System.assertEquals(RecordTypeID , ast.RecordTypeId);
+
+        RecordType rectOpp = [select id from RecordType where IsActive = true and SobjectType = 'Opportunity' and DeveloperName = 'Opportunity' ];
+        Opportunity opp = new Opportunity(
+               Name='testOpp1',
+               StageName='寮曞悎',
+               CloseDate=Date.today(),
+               AccountId=depart1.Id,
+               Sales_Root__c = '璨╁2搴�',
+               Competitor__c ='A',
+               Click_Close_Date__c = null,
+               RecordType = rectOpp
+        );
+        insert opp;
+
+        //娉ㄦ畫
+        Statu_Achievements__c Sac = new Statu_Achievements__c(
+            name = 'zhucan_one',
+            Opportunity__c = opp.id,
+            DeliveryDate__c = Date.today(),
+            ContractNO__c = 'ContractNO1',
+            ContractAmount__c = 1000
+        );
+        insert Sac;
+
+
+
+        //鏂板缓鐢靛瓙绛炬敹鍗�
+    	eSignForm__c eSignForm = new eSignForm__c();
+    	eSignForm.Statu_Achievements__c = Sac.Id;
+    	eSignForm.Name = '::娴嬭瘯鐢靛瓙绛炬敹鍗�';
+    	eSignForm.DNName__c = '65210306';
+
+    	insert eSignForm;
+
+        eSignForm__c eSignForm1 = new eSignForm__c();
+    	eSignForm1.Statu_Achievements__c = Sac.Id;
+    	eSignForm1.Name = '::娴嬭瘯鐢靛瓙绛炬敹鍗�2';
+    	eSignForm1.DNName__c = '65210307';
+
+    	insert eSignForm1;
+
+        eSignFormEntry__c eSignFormEntry1 = new eSignFormEntry__c();
+        eSignFormEntry1.Name = '::鐢靛瓙绛炬敹鍗曞綍鍏ヨ〃1';
+        eSignFormEntry1.eSignForm__c = eSignForm.Id;
+        eSignFormEntry1.entryType__c = '缁忛攢鍟嗘敹璐�';
+        
+        insert eSignFormEntry1;
+
+    	eSignFormEntry__c eSignFormEntry2 = new eSignFormEntry__c();
+    	eSignFormEntry2.Name = '::鐢靛瓙绛炬敹鍗曞綍鍏ヨ〃2';
+    	eSignFormEntry2.eSignForm__c = eSignForm.Id;
+    	eSignFormEntry2.entryType__c = '缁忛攢鍟嗘敹璐�';
+        eSignFormEntry2.IsSubmit__c = true;
+        eSignFormEntry2.IsHPSubmit__c = true;
+    	// eSignFormEntry2.createdDate = Date.today().addDays(-2);
+    	insert eSignFormEntry2;
+
+        eSignFormEntry__c eSignFormEntry3 = new eSignFormEntry__c();
+    	eSignFormEntry3.Name = '::鐢靛瓙绛炬敹鍗曞綍鍏ヨ〃3';
+    	eSignFormEntry3.eSignForm__c = eSignForm1.Id;
+    	eSignFormEntry3.entryType__c = '缁忛攢鍟嗘敹璐�';
+        eSignFormEntry3.IsSubmit__c = true;
+        eSignFormEntry3.IsHPSubmit__c = true;
+    	insert eSignFormEntry3;
+
+
+        //鏂板缓鐢靛瓙绛炬敹鍗曟槑缁�
+        eSignFormLineItem__c eSignFormLineItem = new eSignFormLineItem__c();
+        eSignFormLineItem.Name = '::鐢靛瓙绛炬敹鍗曟槑缁�';
+        eSignFormLineItem.eSignForm__c = eSignForm.Id;
+
+        insert eSignFormLineItem;
+
+        eSignFormLineItem__c eSignFormLineItem1 = new eSignFormLineItem__c();
+        eSignFormLineItem1.Name = '::鐢靛瓙绛炬敹鍗曟槑缁�';
+        eSignFormLineItem1.eSignForm__c = eSignForm1.Id;
+
+        insert eSignFormLineItem1;
+
+        //鏂板缓鐢靛瓙绛炬敹鍗曟槑缁嗗綍鍏ヨ〃
+
+        eSignFormLineItemEntry__c eSignFormLineItemEntry1 = new eSignFormLineItemEntry__c();
+        eSignFormLineItemEntry1.Name = '::鐢靛瓙绛炬敹鍗曟槑缁嗗綍鍏�1';
+        eSignFormLineItemEntry1.eSignFormEntry__c =eSignFormEntry1.Id;
+        eSignFormLineItemEntry1.eSignFormLineItem__c = eSignFormLineItem.Id;
+
+        insert eSignFormLineItemEntry1;
+
+        eSignFormLineItemEntry__c eSignFormLineItemEntry2 = new eSignFormLineItemEntry__c();
+        eSignFormLineItemEntry2.Name = '::鐢靛瓙绛炬敹鍗曟槑缁嗗綍鍏�2';
+        eSignFormLineItemEntry2.eSignFormEntry__c =eSignFormEntry2.Id;
+        eSignFormLineItemEntry2.eSignFormLineItem__c = eSignFormLineItem.Id;
+
+
+        insert eSignFormLineItemEntry2;
+
+        FileAddress__c FileName1 = new FileAddress__c();
+        FileName1.FileName__c = 'ceshiyi1';
+        FileName1.ViewLink__c = 'ceshiyi1';
+        insert FileName1;
+
+        FileAddress__c FileName2 = new FileAddress__c();
+        FileName2.FileName__c = 'ceshiyi2';
+        FileName2.ViewLink__c = 'ceshiyi2';
+        insert FileName2;
+
+        FrameNumManage__c FrameNumManage1 = new FrameNumManage__c();
+        FrameNumManage1.Name = '娴嬭瘯1';
+        FrameNumManage1.ManagementCode__c ='KVZFI';
+        FrameNumManage1.ApplyList__c = 'ceshiyi1';
+        FrameNumManage1.Num__c = 2;
+        FrameNumManage1.SerialNumber__c = '22R';
+        FrameNumManage1.Material__c = 'wuliaoceshi';
+        FrameNumManage1.MaterialDepict__c = 'wuliaomiaoshu';
+        FrameNumManage1.signInForm__c = eSignForm.Id;
+        FrameNumManage1.InspectionCard_Select__c =FileName2.Id;
+
+        insert FrameNumManage1;
+
+        FrameNumManage__c FrameNumManage2 = new FrameNumManage__c();
+        FrameNumManage2.Name = '娴嬭瘯2';
+        FrameNumManage2.ManagementCode__c ='KVZFI2';
+        FrameNumManage2.ApplyList__c = 'ceshiyi2';
+        FrameNumManage2.Num__c = 2;
+        FrameNumManage2.SerialNumber__c = '22R';
+        FrameNumManage2.Material__c = 'wuliaoceshi';
+        FrameNumManage2.MaterialDepict__c = 'wuliaomiaoshu';
+        FrameNumManage2.signInForm__c = eSignForm.Id;
+        FrameNumManage2.InspectionCard_Select__c =FileName2.Id;
+        FrameNumManage2.ApplyList_Select__c =FileName2.Id;
+
+        insert FrameNumManage2;
+        FrameNumManage__c FrameNumManage3 = new FrameNumManage__c();
+        FrameNumManage3.Name = '娴嬭瘯3';
+        FrameNumManage3.ManagementCode__c ='KVZFI3';
+        FrameNumManage3.ApplyList__c = 'ceshiyi2';
+        FrameNumManage3.Num__c = 2;
+        FrameNumManage3.SerialNumber__c = '22R';
+        FrameNumManage3.Material__c = 'wuliaoceshi3';
+        FrameNumManage3.MaterialDepict__c = 'wuliaomiaoshu3';
+        FrameNumManage3.signInForm__c = eSignForm.Id;
+        FrameNumManage3.InspectionCard_Select__c =FileName1.Id;
+        FrameNumManage3.ApplyList_Select__c =FileName1.Id;
+
+        insert FrameNumManage3;
+        FrameNumManage__c FrameNumManage4 = new FrameNumManage__c();
+        FrameNumManage4.Name = '娴嬭瘯4';
+        FrameNumManage4.ManagementCode__c ='KVZFI4';
+        FrameNumManage4.ApplyList__c = 'ceshiyi4';
+        FrameNumManage4.Num__c = 2;
+        FrameNumManage4.SerialNumber__c = '22R';
+        FrameNumManage4.Material__c = 'wuliaoceshi4';
+        FrameNumManage4.MaterialDepict__c = 'wuliaomiaoshu4';
+        FrameNumManage4.signInForm__c = eSignForm.Id;
+        FrameNumManage4.Asset__c = ast.Id;
+        FrameNumManage4.ApplyList_Select__c =FileName1.Id;
+
+        insert FrameNumManage4;
+
+        FrameNumManage__c FrameNumManage5 = new FrameNumManage__c();
+        FrameNumManage5.Name = '娴嬭瘯5';
+        FrameNumManage5.ManagementCode__c ='KVZFI5';
+        FrameNumManage5.ApplyList__c = 'ceshiyi5';
+        FrameNumManage5.Num__c = 2;
+        FrameNumManage5.SerialNumber__c = '22R';
+        FrameNumManage5.Material__c = 'wuliaoceshi5';
+        FrameNumManage5.MaterialDepict__c = 'wuliaomiaoshu5';
+        FrameNumManage5.InspectionCard__c = '涓嶅嚭璇�';
+        FrameNumManage5.signInForm__c = eSignForm.Id;
+        FrameNumManage5.ApplyList_Select__c =FileName1.Id;
+
+        insert FrameNumManage5;
+
+        FrameNumManage__c FrameNumManage6 = new FrameNumManage__c();
+        FrameNumManage6.Name = '娴嬭瘯6';
+        FrameNumManage6.ManagementCode__c ='KVZFI6';
+        FrameNumManage6.ApplyList__c = 'ceshiyi6';
+        FrameNumManage6.Num__c = 2;
+        FrameNumManage6.SerialNumber__c = '22R';
+        FrameNumManage6.Material__c = 'wuliaoceshi6';
+        FrameNumManage6.MaterialDepict__c = 'wuliaomiaoshu6';
+        FrameNumManage6.InspectionCard__c = 'ceshiyi2';
+        FrameNumManage6.signInForm__c = eSignForm.Id;
+        FrameNumManage6.ApplyList_Select__c =FileName1.Id;
+
+        insert FrameNumManage6;
+
+        FrameNumManage__c FrameNumManage7 = new FrameNumManage__c();
+        FrameNumManage7.Name = '娴嬭瘯7';
+        FrameNumManage7.ManagementCode__c ='KVZFI7';
+        FrameNumManage7.ApplyList__c = 'ceshiyi6';
+        FrameNumManage7.Num__c = 2;
+        FrameNumManage7.SerialNumber__c = '22R';
+        FrameNumManage7.Material__c = 'wuliaoceshi6';
+        FrameNumManage7.MaterialDepict__c = 'wuliaomiaoshu6';
+        FrameNumManage7.InspectionCard__c = 'ceshiyi2';
+        FrameNumManage7.signInForm__c = eSignForm.Id;
+
+        insert FrameNumManage7;
+
+        FrameNumManage__c FrameNumManage8 = new FrameNumManage__c();
+        FrameNumManage8.Name = '娴嬭瘯8';
+        FrameNumManage8.ManagementCode__c ='KVZFI8';
+        FrameNumManage8.ApplyList__c = 'ceshiyi8';
+        FrameNumManage8.Num__c = 2;
+        FrameNumManage8.SerialNumber__c = '22R';
+        FrameNumManage8.Material__c = 'wuliaoceshi5';
+        FrameNumManage8.MaterialDepict__c = 'wuliaomiaoshu5';
+        FrameNumManage8.InspectionCard__c = 'ceshiyi1';
+        FrameNumManage8.signInForm__c = eSignForm.Id;
+        FrameNumManage8.ApplyList_Select__c =FileName1.Id;
+        FrameNumManage8.InspectionCard_Select__c =FileName2.Id;
+
+        insert FrameNumManage8;
+
+        FrameNumManage__c FrameNumManage9 = new FrameNumManage__c();
+        FrameNumManage9.Name = '娴嬭瘯9';
+        FrameNumManage9.ManagementCode__c ='KVZFI9';
+        FrameNumManage9.ApplyList__c = '';
+        FrameNumManage9.Num__c = 2;
+        FrameNumManage9.SerialNumber__c = '22R';
+        FrameNumManage9.Material__c = 'wuliaoceshi9';
+        FrameNumManage9.MaterialDepict__c = 'wuliaomiaoshu9';
+        FrameNumManage9.InspectionCard__c = '';
+        FrameNumManage9.signInForm__c = eSignForm1.Id;
+        FrameNumManage9.ApplyList_Select__c =FileName1.Id;
+        FrameNumManage9.InspectionCard_Select__c =FileName2.Id;
+
+        insert FrameNumManage9;
+        FrameNumManage__c FrameNumManage10 = new FrameNumManage__c();
+        FrameNumManage10.Name = '娴嬭瘯10';
+        FrameNumManage10.ManagementCode__c ='KVZFI10';
+        FrameNumManage10.ApplyList__c = '';
+        FrameNumManage10.Num__c = 2;
+        FrameNumManage10.SerialNumber__c = '22R';
+        FrameNumManage10.Material__c = 'wuliaoceshi10';
+        FrameNumManage10.MaterialDepict__c = 'wuliaomiaoshu10';
+        FrameNumManage10.InspectionCard__c = '';
+        FrameNumManage10.signInForm__c = eSignForm1.Id;
+        FrameNumManage10.ApplyList_Select__c =FileName1.Id;
+        FrameNumManage10.InspectionCard_Select__c =FileName2.Id;
+
+        insert FrameNumManage10;
+
+        FrameNumManage__c FrameNumManage11 = new FrameNumManage__c();
+        FrameNumManage11.Name = '娴嬭瘯11';
+        FrameNumManage11.ManagementCode__c ='KVZFI11';
+        FrameNumManage11.ApplyList__c = null;
+        FrameNumManage11.Num__c = 2;
+        FrameNumManage11.SerialNumber__c = '22R';
+        FrameNumManage11.Material__c = 'wuliaoceshi11';
+        FrameNumManage11.MaterialDepict__c = 'wuliaomiaoshu11';
+        FrameNumManage11.InspectionCard__c = '';
+        FrameNumManage11.signInForm__c = eSignForm1.Id;
+        FrameNumManage11.ApplyList_Select__c =FileName1.Id;
+        FrameNumManage11.InspectionCard_Select__c =FileName2.Id;
+
+        insert FrameNumManage11;
+
+    	// create ContentVersions
+        list<ContentVersion> cvList = new list<ContentVersion>();
+        cvList.add( new ContentVersion(Title = 'test1',PathOnClient = 'Test1.txt',VersionData = Blob.valueOf('test data 1'), IsMajorVersion = true) );
+        cvList.add( new ContentVersion(Title = 'test2',PathOnClient = 'Test2.txt',VersionData = Blob.valueOf('test data 2'), IsMajorVersion = true) );
+        cvList.add( new ContentVersion(Title = 'test3',PathOnClient = 'Test3.txt',VersionData = Blob.valueOf('test data 3'), IsMajorVersion = true) );
+        insert cvList;
+
+        Test.startTest();
+        // retrieve Ids for ContentDocuments created on insert of ContentVersions
+        list<Id> cdIdList = new list<Id>();
+        for (ContentDocument cd : [SELECT Id, LatestPublishedVersionId
+                                   FROM ContentDocument
+                                   WHERE (LatestPublishedVersionId = :cvList[0].Id 
+                                          OR LatestPublishedVersionId = :cvList[1].Id
+                                          OR LatestPublishedVersionId = :cvList[2].Id)
+                                   ORDER BY Title]) {
+            cdIdList.add(cd.Id);
+        }
+        system.assertEquals(3, cdIdList.size());
+
+
+        // create ContentDocumentLink links. 2 for TestAcct (1) and 1 for TestAcct (2)
+        list<ContentDocumentLink> cdlList = new list<ContentDocumentLink>();
+        cdlList.add(new ContentDocumentLink(ContentDocumentId=cdIdList[0], LinkedEntityId=eSignFormEntry1.Id, ShareType='V'));
+      
+        insert cdlList; 
+        string aid = String.valueOf(depart1.Id);
+        eSignHomePageController.getDNSignUpStatus('65210306');
+        eSignHomePageController.eSignWrapperList esceshi = eSignHomePageController.getDNSignUpLists(aid,'Agency');
+        eSignHomePageController.getAccount('888888');
+        AttachmentDisplayController.getFrameNumManage(eSignForm.Id);
+
+        eSignHomePageController.getDNSignUpStatus('65210307');
+        eSignHomePageController.eSignWrapperList esceshi1 = eSignHomePageController.getDNSignUpLists(aid,'Agency');
+        eSignHomePageController.getAccount('888888');
+        AttachmentDisplayController.getFrameNumManage(eSignForm1.Id);
+        Test.stopTest();
+    }
+}
\ No newline at end of file
diff --git a/force-app/main/default/classes/AttachmentDisplayControllerTest.cls-meta.xml b/force-app/main/default/classes/AttachmentDisplayControllerTest.cls-meta.xml
new file mode 100644
index 0000000..4b0bc9f
--- /dev/null
+++ b/force-app/main/default/classes/AttachmentDisplayControllerTest.cls-meta.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<ApexClass xmlns="http://soap.sforce.com/2006/04/metadata">
+    <apiVersion>55.0</apiVersion>
+    <status>Active</status>
+</ApexClass>
diff --git a/force-app/main/default/classes/DealerPersonnelController.cls b/force-app/main/default/classes/DealerPersonnelController.cls
index 41ed30f..a964ef7 100644
--- a/force-app/main/default/classes/DealerPersonnelController.cls
+++ b/force-app/main/default/classes/DealerPersonnelController.cls
@@ -1,4 +1,4 @@
-public with sharing class DealerPersonnelController {
+public without sharing class DealerPersonnelController {
     public DealerPersonnelController() {
 
     }
@@ -6,124 +6,523 @@
     public static String processData(String fileData,String sobjectName,List<String> fields) {
         system.debug('fileData===============>'+fileData);
         String errorMage = '';
-        try {
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+        // Savepoint sp = Database.setSavepoint();
+        // try {
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
             if(fileData != null){
                 String[] fileLines = new String[]{};
                 fileLines = fileData.split('\n');
                 system.debug('fileLines===================>'+fileLines);
                 // 缁忛攢鍟嗙鐞嗙紪鐮�
                 List<String> managementCodeList = new List<String>();  
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                // 瀹㈡埛鍚�
+                List<String> CustomerNameList = new List<String>(); 
+                //浜哄憳绠$悊缂栫爜
+                List<String> CManageCodeList = new List<String>(); 
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
                 // 瀵煎叆鐨勬暟鎹�
                 List<List<String>> inputList = new List<List<String>>();
                 for (Integer i = 1,j = fileLines.size(); i < j; i++) {
                     List<String> inputValues = new List<String>();
-                    inputValues = fileLines[i].split(',');
-                    System.debug('inputValues=============>'+inputValues);
-                    if(inputValues != null){
-                        if(inputValues[0] == '' || inputValues[0]== null){
-                            errorMage += 'errorMage: 绗�' + i + '琛�,濮撳悕涓嶈兘涓虹┖!';
-                            errorMage += '=';
-                        } 
-                        if(inputValues[1] == '' || inputValues[1] ==null){
-                            errorMage += 'errorMage: 绗�' + i + '琛�,鎵嬫満涓嶈兘涓虹┖!';
-                            errorMage += '=';
+                    if(fileLines[i].replace(',','').trim()!=''){
+                        inputValues = fileLines[i].split(',',-1);
+                        System.debug('inputValues=============>'+inputValues);
+                        System.debug('fileLines[i]=============>'+fileLines[i]);
+                        if(inputValues != null){
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                            // if(inputValues[0] == '' || inputValues[0]== null){
+                            //     errorMage += 'errorMage: 绗�' + i + '琛�,濮撳悕涓嶈兘涓虹┖!';
+                            //     errorMage += '=';
+                            // }
+                            // // if(inputValues[1] == '' || inputValues[1] ==null){
+                            // //     errorMage += 'errorMage: 绗�' + i + '琛�,鎵嬫満涓嶈兘涓虹┖!';
+                            // //     errorMage += '=';
+                            // // }
+                            // // boolean mobileNumberFlag = mobileNumberVerification(inputValues[1]);
+                            // // if(mobileNumberFlag == false){
+                            // //     errorMage += 'errorMage: 浣犵殑鎵嬫満鍙风爜涓嶅お姝g‘,璇锋鏌ユ偍鐨勬墜鏈烘槸鍚︽纭�!';
+                            // //     errorMage += '=';
+                            // // }
+                            // // if(inputValues[2] == '' || inputValues[2] == null){
+                            // //     errorMage += 'errorMage: 绗�' + i + '琛�,閭涓嶈兘涓虹┖!';
+                            // //     errorMage += '=';
+                            // // }
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                            // if(inputValues[2] != '' && inputValues[2] != null){
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                            //     boolean mailboxFlag = mailboxVerification(inputValues[2]);
+                            //     if(mailboxFlag == false){
+                            //         errorMage += 'errorMage:绗�' + i + '琛�, 浣犵殑閭涓嶅お姝g‘,璇锋鏌ユ偍鐨勯偖绠辨牸寮�!';
+                            //         errorMage += '=';
+                            //     }
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                            // }
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                            // if(inputValues[3] == '' || inputValues[3] == null){
+                            //     errorMage += 'errorMage: 绗�' + i + '琛�,缁忛攢鍟嗙鐞嗙紪鐮佷笉鑳戒负绌�!';
+                            //     errorMage += '=';
+                            // }
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                            // if(inputValues[4] == '' || inputValues[4] == null){
+                            //     errorMage += 'errorMage: 绗�' + i + '琛�,瀹㈡埛鍚嶄笉鑳戒负绌�!';
+                            //     errorMage += '=';
+                            // }
+                            // if(inputValues[5] == '' || inputValues[5] == null){
+                            //     errorMage += 'errorMage: 绗�' + i + '琛�,缁忛攢鍟嗙敤鎴蜂笉鑳戒负绌�!';
+                            //     errorMage += '=';
+                            // }
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                            //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                            inputValues[3]=inputValues[3].leftpad(10,'0');
+                            System.debug('娴嬭瘯鍘婚浂1 '+inputValues[3].replace(' ','').length());
+                            
+                            managementCodeList.add(inputValues[3]);
+                            //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                            CustomerNameList.add(inputValues[4]);
+                            CManageCodeList.add(inputValues[6]);
+                            //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                            inputList.add(inputValues);
+                            
+                            //瀵煎叆鐨勬暟鎹�
+                            // System.debug('inputValues[0]===============>'+ inputValues[0]);
+                            // System.debug('inputValues[1]===============>'+ inputValues[1]);
+                            // System.debug('inputValues[2]===============>'+ inputValues[2]);
+                            // System.debug('inputValues[3]===============>'+ inputValues[3]);
+                            // //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                            // System.debug('inputValues[4]===============>'+ inputValues[4]);
+                            // System.debug('inputValues[5]===============>'+ inputValues[5]);
+                            // System.debug('inputValues[6]===============>'+ inputValues[6]);
+                            // System.debug('inputValues[7]===============>'+ inputValues[7]);
+                            // System.debug('inputValues[8]===============>'+ inputValues[8]);
+                            // System.debug('inputValues[9]===============>'+ inputValues[9]);
+                            // System.debug('inputValues[10]===============>'+ inputValues[10]);
+                            // System.debug('inputValues[11]===============>'+ inputValues[11]);
+                            // System.debug('inputValues[12]===============>'+ inputValues[12]);
+                            // System.debug('inputValues[13]===============>'+ inputValues[13]);
+                            // System.debug('inputValues[14]===============>'+ inputValues[14]);
+                            // System.debug('inputValues[15]===============>'+ inputValues[15]);
+                            // System.debug('inputValues[16]===============>'+ inputValues[16]);
+                            //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                            
                         }
-                        boolean mobileNumberFlag = mobileNumberVerification(inputValues[1]);
-                        if(mobileNumberFlag == false){
-                            errorMage += 'errorMage: 浣犵殑鎵嬫満鍙风爜涓嶅お姝g‘,璇锋鏌ユ偍鐨勬墜鏈烘槸鍚︽纭�!';
-                            errorMage += '=';
-                        }
-                        if(inputValues[2] == '' || inputValues[2] == null){
-                            errorMage += 'errorMage: 绗�' + i + '琛�,閭涓嶈兘涓虹┖!';
-                            errorMage += '=';
-                        }
-                        boolean mailboxFlag = mailboxVerification(inputValues[2]);
-                        if(mailboxFlag == false){
-                            errorMage += 'errorMage: 浣犵殑閭涓嶅お姝g‘,璇锋鏌ユ偍鐨勯偖绠辨牸寮�!';
-                            errorMage += '=';
-                        }
-                        if(inputValues[3] == '' || inputValues[3] == null){
-                            errorMage += 'errorMage: 绗�' + i + '琛�,缁忛攢鍟嗙鐞嗙紪鐮佷笉鑳戒负绌�!';
-                            errorMage += '=';
-                        }
-                        
-                        managementCodeList.add(inputValues[3]);
-                        inputList.add(inputValues);
-                        //瀵煎叆鐨勬暟鎹�
-                        System.debug('inputValues[0]===============>'+ inputValues[0]);
-                        System.debug('inputValues[1]===============>'+ inputValues[1]);
-                        System.debug('inputValues[2]===============>'+ inputValues[2]);
-                        System.debug('inputValues[3]===============>'+ inputValues[3]);
                     }
                 }
                 Map<String,Account> accountIdMap = new Map<String,Account>();
-                List<Account> accountList = [select id, Name,Management_Code__c from Account where Management_Code__c in: managementCodeList];
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                Map<String,Contact> contactIdMap = new Map<String,Contact>();
+                Map<Id,String> ManagementCodeMap = new Map<Id,String>();
+                List<Id> AccountIdList =new  List<Id>();
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                System.debug('managementCodeList===============>'+ managementCodeList);
+                System.debug('CustomerNameList===============>'+ CustomerNameList);
+                List<Account> accountList = [select id, Name,Management_Code__c from Account where Management_Code__c in: managementCodeList and Name in:CustomerNameList];
+                System.debug('iaccountList===============>'+ accountList);
                 for(Account ac : accountList){ 
                     accountIdMap.put(ac.Management_Code__c,ac);
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    AccountIdList.add(ac.Id);
+                    ManagementCodeMap.put(ac.Id,ac.Management_Code__c);
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
                 }
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                //鏌ヨ瀹㈡埛浜哄憳鏄惁鏈夋暟鎹�
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                // Map<String,Contact> contactIdMapName = new Map<String,Contact>();
+                List<Contact> contactList = [select id, CManageCode__c,AccountId from Contact where AccountId in: AccountIdList and CManageCode__c in:CManageCodeList ];
+                // List<Contact> contactList = [select id, CManageCode__c,AccountId,Name from Contact where AccountId in: AccountIdList ];
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                for(Contact cc : contactList){ 
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                    // String namekey = cc.Name.replace(' ', '');
+                    // String contactKey2=ManagementCodeMap.get(cc.AccountId)+'_'+namekey;
+                    // contactIdMapName.put(contactKey2,cc);
+                    String contactKey=ManagementCodeMap.get(cc.AccountId)+'_'+cc.CManageCode__c;
+                    contactIdMap.put(contactKey,cc);
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                }
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                // System.debug('contactIdMapName++'+contactIdMapName);
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                List<Contact> cnupdateList = new List<Contact>();
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
                 List<Contact> cnList = new List<Contact>();
                 Integer lineNumber = 1;
                 for(List<String> lineList :inputList){
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    Boolean errorflag1 = false;
+                    String errorMageHang = '';
+                    if(lineList[0] == '' || lineList[0]== null){
+                        errorMageHang += ',濮撳悕涓嶈兘涓虹┖!';
+                        errorflag1 = true;
+                    }
+                    if(lineList[2] != '' && lineList[2] != null){
+                        boolean mailboxFlag = mailboxVerification(lineList[2]);
+                        if(mailboxFlag == false){
+                            errorMageHang += ', 浣犵殑閭涓嶅お姝g‘,璇锋鏌ユ偍鐨勯偖绠辨牸寮�!';
+                            errorflag1 = true;
+                        }
+                    }
+                    if(lineList[3] == '' || lineList[3] == null){
+                        errorMageHang += ',缁忛攢鍟嗙鐞嗙紪鐮佷笉鑳戒负绌�!';
+                        errorflag1 = true;
+                    }
+                    if(lineList[4] == '' || lineList[4] == null){
+                        errorMageHang += ',瀹㈡埛鍚嶄笉鑳戒负绌�!';
+                        errorflag1 = true;
+                    }
+                    if(lineList[5] == '' || lineList[5] == null){
+                        errorMageHang += ',缁忛攢鍟嗙敤鎴蜂笉鑳戒负绌�!';
+                        errorflag1 = true;
+                    }
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                     Contact con = new Contact();
                     //鏆傛椂瀵煎叆鐨勬槸缁忛攢鍟嗙敤鎴凤紝鎵�浠ヨ褰曠被鍨嬪彧鏈夌粡閿�鍟嗭紝鏆傛椂鍐欐锛涘悗鏈熷鏋滄湁鍙樺姩鍐嶆洿鏀�
                     con.RecordTypeId = '01210000000QfWiAAK';
-                    if(lineList[0] != null && lineList[0] != ''){
-                        con.LastName  = lineList[0];
-                    }else{
-                        errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,濮撴皬'+lineList[0]+'涓嶅瓨鍦�';
-                        errorMage += '=';
-                    }   
-                    if(lineList[1] != null && lineList[1] != ''){
-                        if(mobileNumberVerification(lineList[1])){
-                            con.MobilePhone = lineList[1];
+                    if(!contactIdMap.containsKey(lineList[3]+'_'+lineList[6])){
+                        if(lineList[0] != null && lineList[0] != ''){
+                            con.LastName  = lineList[0];
                         }else{
-                            errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鎵嬫満'+lineList[1]+'涓嶆纭�!';
-                            errorMage += '=';
-                        }
-                    }else{
-                        errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鎵嬫満'+lineList[1]+'涓嶅瓨鍦�';
-                        errorMage += '=';
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                            // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,濮撴皬'+lineList[0]+'涓嶅瓨鍦�';
+                            // errorMage += '=';
+                            errorMageHang += ',濮撴皬 '+lineList[0]+' 涓嶅瓨鍦�';
+                            errorflag1 = true;
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                        }   
                     }
+                    if(lineList[1] != null && lineList[1] != ''){
+                        // if(mobileNumberVerification(lineList[1])){
+                            con.MobilePhone = lineList[1];
+                        // }else{
+                        //     errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鎵嬫満'+lineList[1]+'涓嶆纭�!';
+                        //     errorMage += '=';
+                        // }
+                    }
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    // else{
+                    //     errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鎵嬫満'+lineList[1]+'涓嶅瓨鍦�';
+                    //     errorMage += '=';
+                    // }
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
                     if(lineList[2] != null && lineList[2] != ''){
                         if(mailboxVerification(lineList[2])){
                             con.Email = lineList[2];
                         }else{
-                            errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鐢靛瓙閭欢'+lineList[2]+'涓嶆纭�!';
-                            errorMage += '=';
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                            // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鐢靛瓙閭欢'+lineList[2]+'涓嶆纭�!';
+                            // errorMage += '=';
+                            errorMageHang += ',鐢靛瓙閭欢 '+lineList[2]+' 涓嶆纭�!';
+                            errorflag1 = true;
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                         }
-                    }else{
-                        errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鐢靛瓙閭欢'+lineList[2]+'涓嶅瓨鍦�';
-                        errorMage += '=';
                     }
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    // else{
+                    //     errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鐢靛瓙閭欢'+lineList[2]+'涓嶅瓨鍦�';
+                    //     errorMage += '=';
+                    // }
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
                     if(accountIdMap.containsKey(lineList[3])){
                         con.AccountId = accountIdMap.get(lineList[3]).id;
                     }else{
-                        errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,缁忛攢鍟嗙紪鐮�'+lineList[3]+'涓嶅瓨鍦�';
-                        errorMage += '=';
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,缁忛攢鍟嗙紪鐮�'+lineList[3]+'鎴栬�呭鎴峰悕涓嶅瓨鍦�';
+                        // errorMage += '=';
+                        errorMageHang += ',缁忛攢鍟嗙紪鐮� '+lineList[3]+' 鎴栬�呭鎴峰悕涓嶅瓨鍦�';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                     }
                     //鏆傚畾鍒涘缓鐩存帴涓� true
-                    con.Agency_User__c =  true; 
+                    // con.Agency_User__c =  true; 
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    if(lineList[5] != null && lineList[5] != ''){
+                        if(lineList[5]=='true'||lineList[5]=='TRUE'){
+                            con.Agency_User__c=true;
+                        }else{
+                            con.Agency_User__c=false;
+                        }
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,缁忛攢鍟嗙敤鎴�'+lineList[0]+'涓嶅瓨鍦�';
+                        // errorMage += '=';
+                        errorMageHang += ',缁忛攢鍟嗙敤鎴� '+lineList[0]+' 涓嶅瓨鍦�';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }  
+                     //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    //缁忛攢鍟嗕笓鍛樼被鍨�
+                    if(VerificationOLYAssistantType(lineList[7])){
+                        con.OLY_Assistant_Type__c  = lineList[7];
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,缁忛攢鍟嗕笓鍛樼被鍨�'+lineList[7]+'涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',缁忛攢鍟嗕笓鍛樼被鍨� '+lineList[7]+' 涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    } 
+                    //鍏ヨ亴骞翠唤
+                    if(VerificationDateType(lineList[8])){
+                        con.InductionYear__c  = ConversionDateType(lineList[8]);
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,鍏ヨ亴骞翠唤'+lineList[8]+'鏍煎紡涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',鍏ヨ亴骞翠唤 '+lineList[8]+' 鏍煎紡涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }
+                    //GIR璁よ瘉绾у埆
+                    if(VerifyCertificationLevel(lineList[9])){
+                        con.GIR_CertificationLevel__c  = lineList[9];
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,GIR璁よ瘉绾у埆'+lineList[9]+'涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',GIR璁よ瘉绾у埆 '+lineList[9]+' 涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    } 
+                    //GIR璁よ瘉鏃堕棿
+                    if(VerificationDateType(lineList[10])){
+                        con.GIR_CertificationTime__c  = ConversionDateType(lineList[10]);
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,GIR璁よ瘉鏃堕棿'+lineList[10]+'鏍煎紡涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',GIR璁よ瘉鏃堕棿 '+lineList[10]+' 鏍煎紡涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }
+                    //SP璁よ瘉绾у埆
+                    if(VerifyCertificationLevel(lineList[11])){
+                        con.SP_CertificationLevel__c  = lineList[11];
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,SP璁よ瘉绾у埆'+lineList[11]+'涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',SP璁よ瘉绾у埆 '+lineList[11]+' 涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    } 
+                    //SP璁よ瘉鏃堕棿
+                    if(VerificationDateType(lineList[12])){
+                        con.SP_CertificationTime__c  = ConversionDateType(lineList[12]);
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,SP璁よ瘉鏃堕棿'+lineList[12]+'鏍煎紡涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',SP璁よ瘉鏃堕棿 '+lineList[12]+' 鏍煎紡涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }
+                    //ET璁よ瘉绾у埆
+                    if(VerifyCertificationLevel(lineList[13])){
+                        con.ET_CertificationLevel__c  = lineList[13];
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,ET璁よ瘉绾у埆'+lineList[13]+'涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',ET璁よ瘉绾у埆 '+lineList[13]+' 涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    } 
+                    //ET璁よ瘉鏃堕棿
+                    if(VerificationDateType(lineList[14])){
+                        con.ET_CertificationTime__c  = ConversionDateType(lineList[14]);
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,ET璁よ瘉鏃堕棿'+lineList[14]+'鏍煎紡涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang += ',ET璁よ瘉鏃堕棿 '+lineList[14]+' 鏍煎紡涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }
+                    //ENG璁よ瘉绾у埆
+                    if(VerifyCertificationLevel(lineList[15])){
+                        con.ENG_CertificationLevel__c  = lineList[15];
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,ENG璁よ瘉绾у埆'+lineList[15]+'涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang +=',ENG璁よ瘉绾у埆 '+lineList[15]+' 涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    } 
+                    //ENG璁よ瘉鏃堕棿
+                    if(VerificationDateType(lineList[16])){
+                        con.ENG_CertificationTime__c  = ConversionDateType(lineList[16]);
+                    }else{
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                        // errorMage += 'error: 绗�'+ lineNumber +'琛屾暟鎹�,ENG璁よ瘉鏃堕棿'+lineList[16]+'鏍煎紡涓嶆纭�!';
+                        // errorMage += '=';
+                        errorMageHang +=',ENG璁よ瘉鏃堕棿 '+lineList[16]+' 鏍煎紡涓嶆纭�!';
+                        errorflag1 = true;
+                        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    }
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    // lineNumber++;
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                    System.debug('001+'+lineList[3]+'_'+lineList[6]);
+                    System.debug('002+'+contactIdMap.get(lineList[3]+'_'+lineList[6]));
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                    // System.debug('003+'+lineList[3]+'_'+lineList[0]);
+                    // System.debug('004+'+contactIdMapName.get(lineList[3]+'_'+lineList[0]));
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    if(errorflag1){
+                        errorMage += 'error: 绗�' + lineNumber + '琛� 锛�'+lineList[0]+'锛� 鐨勬暟鎹�'+errorMageHang;
+                        errorMage += '=';
+                    }else{
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                        if(contactIdMap.containsKey(lineList[3]+'_'+lineList[6])){
+                            con.Id=contactIdMap.get(lineList[3]+'_'+lineList[6]).Id;
+                            cnupdateList.add(con);
+                        }else {
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start 0228
+                            // if(!contactIdMapName.containsKey(lineList[3]+'_'+lineList[0])){
+                            //     cnList.add(con);
+                            // }
+                            cnList.add(con);
+                            //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                        }
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    }
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
+                    // cnList.add(con);
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
                     lineNumber++;
-                    cnList.add(con);
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                 }
-                if(errorMage != ''){
-                    system.debug('errorMage==========>'+errorMage);
-                    return errorMage;
-                }
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                // if(errorMage != ''){
+                //     system.debug('errorMage==========>'+errorMage);
+                //     return errorMage;
+                // }
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                
                 // 鏂板鍛ㄦ姤鏄庣粏
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                List<String> errorChongfuList = new List<String>();
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                 if(cnList.size() > 0 ){
-                    insertContact(cnList);
+                    System.debug('003+'+cnList);
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    // insertContact(cnList);
+                    Database.SaveResult[] InsertShare = Database.insert(cnList, false);
+                    for(Database.SaveResult insertresult :InsertShare){
+                        if (!insertresult.isSuccess()) {
+                            String errerContactiD='';
+                            String errer = String.valueOf(insertresult.getErrors()[0]);
+                            if(errer.contains('UniqueNumber__c 涓庤褰曞�奸噸澶�')){
+                                List<String> errerList = errer.split('UniqueNumber__c 涓庤褰曞�奸噸澶�');
+                                if(errerList.size()>1){
+                                    errerContactiD=errerList[1].substring(errerList[1].indexOf('ID 涓�:')+5,errerList[1].indexOf(';getStatusCode')).replace(' ','');
+                                    errorChongfuList.add(errerContactiD);
+                                }
+                            }else{
+                                errorMage += errer;
+                            }
+                        }
+                    }
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
                 }
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+                // 鏇存柊鍛ㄦ姤鏄庣粏
+                if(cnupdateList.size() > 0 ){
+                    System.debug('004+'+cnupdateList);
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                    // updateContact(cnupdateList);
+                    Database.SaveResult[] UpdateShare = Database.update(cnupdateList, false);
+                    for(Database.SaveResult updateresult :UpdateShare){
+                        if (!updateresult.isSuccess()) {
+                            String errerContactiD='';
+                            String errer = String.valueOf(updateresult.getErrors()[0]);
+                            if(errer.contains('UniqueNumber__c 涓庤褰曞�奸噸澶�')){
+                                List<String> errerList = errer.split('UniqueNumber__c 涓庤褰曞�奸噸澶�');
+                                if(errerList.size()>1){
+                                    errerContactiD=errerList[1].substring(errerList[1].indexOf('ID 涓�:')+5,errerList[1].indexOf(';getStatusCode')).replace(' ','');
+                                    errorChongfuList.add(errerContactiD);
+                                }
+                            }else{
+                                errorMage += errer;
+                            }
+                        }
+                    }
+                    //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                }
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+                List<Contact> repeatContact=[select Id,Name from Contact where Id = :errorChongfuList];
+                if(repeatContact.size()>0){
+                    for(Contact repeatContactitem :repeatContact){
+                        String errerContactName='';
+                        String errerContactID='';
+                        errerContactName = repeatContactitem.Name;
+                        errerContactID = repeatContactitem.Id;
+                        errorMage +='error: 鏁版嵁涓瓨鍦ㄤ笌绯荤粺鐜版湁鐢ㄦ埛 '+errerContactName+'锛圛d涓猴細'+errerContactiD+'锛夐噸澶嶇殑鐢佃瘽鍙风爜';
+                    }
+                }else if(errorChongfuList.size()>0){
+                    errorMage +='error: 鏁版嵁涓瓨鍦ㄩ噸澶嶇殑鐢佃瘽鍙风爜';
+                }
+                //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+                //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+            }
+            if(errorMage != ''){
+                system.debug('errorMage==========>'+errorMage);
+                return errorMage;
             }
             return 'success';
-        } catch (Exception e) {
-            System.debug('exception'+e);
-            return 'exception'+e; 
-        }
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+            // String errer=String.valueOf(e);
+            // String errerContactiD='';
+            // String errerContactName='';
+            // if(errer.contains('UniqueNumber__c 涓庤褰曞�奸噸澶�')){
+            //     List<String> errerList = errer.split('UniqueNumber__c 涓庤褰曞�奸噸澶�');
+            //     if(errerList.size()>1){
+            //         errerContactiD=errerList[1].substring(errerList[1].indexOf('ID 涓�:')+5,errerList[1].indexOf(': []')).replace(' ','');
+            //         List<Contact> repeatContact=[select Name from Contact where Id = :errerContactiD];
+            //         if(repeatContact.size()>0){
+            //             errerContactName=repeatContact[0].Name;
+            //             return 'error: 鏁版嵁涓瓨鍦ㄤ笌绯荤粺鐜版湁鐢ㄦ埛 '+errerContactName+'锛圛d涓猴細'+errerContactiD+'锛夐噸澶嶇殑鐢佃瘽鍙风爜';
+            //         }else{
+            //             return 'error: 鏁版嵁涓瓨鍦ㄩ噸澶嶇殑鐢佃瘽鍙风爜';
+            //         }
+            //     }
+            // }
+            // return e.getLineNumber()+'exception'+e;
+
+        // } catch (Exception e) {
+        //     Database.rollback(sp);
+        //     System.debug('exception++++++++++++++++++'+e.getLineNumber()+e);
+        //     String errer=String.valueOf(e);
+        //     String errerContactiD='';
+        //     String errerContactName='';
+        //     if(errer.contains('UniqueNumber__c 涓庤褰曞�奸噸澶�')){
+        //         List<String> errerList = errer.split('UniqueNumber__c 涓庤褰曞�奸噸澶�');
+        //         if(errerList.size()>1){
+        //             errerContactiD=errerList[1].substring(errerList[1].indexOf('ID 涓�:')+5,errerList[1].indexOf(': []')).replace(' ','');
+        //             List<Contact> repeatContact=[select Name from Contact where Id = :errerContactiD];
+        //             if(repeatContact.size()>0){
+        //                 errerContactName=repeatContact[0].Name;
+        //                 return 'error: 鏁版嵁涓瓨鍦ㄤ笌绯荤粺鐜版湁鐢ㄦ埛 '+errerContactName+'锛圛d涓猴細'+errerContactiD+'锛夐噸澶嶇殑鐢佃瘽鍙风爜';
+        //             }else{
+        //                 return 'error: 鏁版嵁涓瓨鍦ㄩ噸澶嶇殑鐢佃瘽鍙风爜';
+        //             }
+        //         }
+        //     }
+        //     return e.getLineNumber()+'exception'+e;
+        // }
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
     }
       // 鐢靛瓙閭欢鐨勯獙璇�
     public static boolean mailboxVerification(String mailbox){
-        String  check =  '^([a-z0-9A-Z]+[-|\\.]?)+[a-z0-9A-Z]@([a-z0-9A-Z]+(-[a-z0-9A-Z]+)?\\.)+[a-zA-Z]{2,}$';  
+        String  check =  '^([a-z0-9A-Z]+[_-|\\.]?)+[a-z0-9A-Z]@([a-z0-9A-Z]+(-[a-z0-9A-Z]+)?\\.)+[a-zA-Z]{2,}$';  
         Pattern regex = Pattern.compile(check);  
         Matcher matcher = regex.matcher(mailbox);  
         if (matcher.matches()){
@@ -132,18 +531,61 @@
         return false;
     }
       // 鎵嬫満鍙风殑楠岃瘉
-    public static boolean mobileNumberVerification(String phoneNumber){
-        String check = '^((17[0-9])|(14[0-9])|(13[0-9])|(15[^4,\\D])|(18[0,5-9]))\\d{8}$'; 
-        Pattern regex = Pattern.compile(check); 
-        Matcher matcher = regex.matcher(phoneNumber); 
-        if(matcher.matches()){
-            return true;
-        } 
-        return false;
-    }
+    // public static boolean mobileNumberVerification(String phoneNumber){
+    //     String check = '^((17[0-9])|(14[0-9])|(13[0-9])|(15[^4,\\D])|(18[0,5-9]))\\d{8}$'; 
+    //     Pattern regex = Pattern.compile(check); 
+    //     Matcher matcher = regex.matcher(phoneNumber); 
+    //     if(matcher.matches()){
+    //         return true;
+    //     } 
+    //     return false;
+    // }
     //鏂板瀹㈡埛浜哄憳锛�
     public static void insertContact(List<Contact> data) {
         insert data;
     }
-
+   // SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy start
+    //鏍¢獙璁よ瘉绾у埆锛�
+    public static boolean VerifyCertificationLevel(String data) {
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� start
+        // if(data=='A'||data=='B'||data==''){
+        if(data=='A绾�'||data=='A绾ф湭閫氳繃'||data=='A绾ф湭閫氳繃锛堝け鏁堬級'||data=='A绾�(澶辨晥)'||data=='B绾�'||data=='B绾�(澶辨晥)'||data=='B绾ф湭閫氳繃'||data=='鍒濈骇'||data=='鍒濈骇鏈�氳繃'||data=='鏈璇�'||data==''){
+        //DB202301262139 SFDC缁忛攢鍟嗕汉鍛樺鍏ュ姛鑳芥敼杩� end
+            return true;
+        }
+        return false;
+    }
+    //鏍¢獙鏃ユ湡绫诲瀷
+    public static Boolean VerificationDateType(String data) {
+        List<String> date1str;
+        List<String> date2str;
+        if(data==''){
+            return true;
+        }
+        date1str=data.split('/');
+        date2str=data.split('-');
+        if(date1str.size()>1||date2str.size()>1){
+            return true;
+        }
+        return false;
+    }
+    //杞崲鏃ユ湡绫诲瀷锛�
+    public static Date ConversionDateType(String data) {
+        if(data==''){
+            return null;
+        }
+        return Date.valueOf(data.replace('/','-'));
+    }
+    //鏍¢獙缁忛攢鍟嗕笓鍛樼被鍨嬶紱
+    public static Boolean VerificationOLYAssistantType(String data) {
+        if(data=='GR涓撳憳'||data=='SP涓撳憳'||data=='GRSP涓撳憳'||data=='ET涓撳憳'||data=='TB涓撳憳'||data=='濂ヨ緣鍩哄眰涓撳憳'||data=='鍟嗗姟鍔╃悊'||data=='*****'||data==''){
+            return true;
+        }
+        return false;
+    }
+    //鏇存柊瀹㈡埛浜哄憳锛�
+    public static void updateContact(List<Contact> data){
+        update data;
+    }
+    //SWAG-CEW85A 銆愬鎵樸�戞秷鑰楀搧&DAMS绯荤粺缁忛攢鍟嗕汉鍛樼鐞嗏�斺�斾俊鎭畬鍠勶紱fy end
 }
\ No newline at end of file
diff --git a/force-app/main/default/classes/DealerPersonnelControllerTest.cls b/force-app/main/default/classes/DealerPersonnelControllerTest.cls
index 70a8641..e4c04c4 100644
--- a/force-app/main/default/classes/DealerPersonnelControllerTest.cls
+++ b/force-app/main/default/classes/DealerPersonnelControllerTest.cls
@@ -8,15 +8,20 @@
             insert account1;
         }
         @isTest public static void selectProductCcategoryTest() {
-            testInit();
             Test.startTest();
-            String reports = DealerPersonnelController.processData('"濮撳悕,鎵嬫満,鐢靛瓙閭欢,缁忛攢鍟嗙紪鐮�,瀹㈡埛鍚峔r\n灏忕帇,18801332211,123@qq.com,737011,鍚ǔ璧锋\r\n','',null);
+            testInit();
+            String reports = DealerPersonnelController.processData('"濮撳悕,鎵嬫満,鐢靛瓙閭欢,缁忛攢鍟嗙紪鐮�,瀹㈡埛鍚�,缁忛攢鍟嗙敤鎴�,浜哄憳绠$悊缂栫爜,缁忛攢鍟嗕笓鍛樼被鍨�,鍏ヨ亴骞翠唤,GIR璁よ瘉绾у埆,GIR璁よ瘉鏃堕棿,SP璁よ瘉绾у埆,SP璁よ瘉鏃堕棿,ET璁よ瘉绾у埆,ET璁よ瘉鏃堕棿,ENG璁よ瘉绾у埆,ENG璁よ瘉鏃堕棿\r\n灏忕帇,18801332211,123@qq.com,737011,鍚ǔ璧锋,TRUE,C000125941,SP涓撳憳,2021/1/7,A,2022/1/7,A,2019/1/7,A,2021/2/7,B,2020/1/7\r\n','',null);
+            String reports2 = DealerPersonnelController.processData('"濮撳悕,鎵嬫満,鐢靛瓙閭欢,缁忛攢鍟嗙紪鐮�,瀹㈡埛鍚�,缁忛攢鍟嗙敤鎴�,浜哄憳绠$悊缂栫爜,缁忛攢鍟嗕笓鍛樼被鍨�,鍏ヨ亴骞翠唤,GIR璁よ瘉绾у埆,GIR璁よ瘉鏃堕棿,SP璁よ瘉绾у埆,SP璁よ瘉鏃堕棿,ET璁よ瘉绾у埆,ET璁よ瘉鏃堕棿,ENG璁よ瘉绾у埆,ENG璁よ瘉鏃堕棿\r\n灏忕帇,18801332211,123@qq.com,737011,test1鍖婚櫌,TRUE,,SP涓撳憳,2021/1/7,A绾�,2022/1/7,A绾�,2019/1/7,A绾�,2021/2/7,B绾�,2020/1/7\r\n','',null);
+            List<Contact> data = new List<Contact>();
+            DealerPersonnelController.updateContact(data);
+            Boolean a= DealerPersonnelController.VerificationDateType('');
+            Date b = DealerPersonnelController.ConversionDateType('');
             Test.stopTest();
         }
         @isTest public static void selectProductCcategoryTest01() {
             testInit();
             Test.startTest();
-            String reports = DealerPersonnelController.processData('"濮撳悕,鎵嬫満,鐢靛瓙閭欢,缁忛攢鍟嗙紪鐮�,瀹㈡埛鍚峔r\n,,,,\r\n','',null);
+            String reports = DealerPersonnelController.processData('"濮撳悕,鎵嬫満,鐢靛瓙閭欢,缁忛攢鍟嗙紪鐮�,瀹㈡埛鍚�,缁忛攢鍟嗙敤鎴�,浜哄憳绠$悊缂栫爜,缁忛攢鍟嗕笓鍛樼被鍨�,鍏ヨ亴骞翠唤,GIR璁よ瘉绾у埆,GIR璁よ瘉鏃堕棿,SP璁よ瘉绾у埆,SP璁よ瘉鏃堕棿,ET璁よ瘉绾у埆,ET璁よ瘉鏃堕棿,ENG璁よ瘉绾у埆,ENG璁よ瘉鏃堕棿\r\n,,123,,,,,123,123,123,123,123,13,12,123,132,13\r\n','',null);
             Test.stopTest();
         }
 }
\ No newline at end of file
diff --git a/force-app/main/default/classes/NewQuoteIraiController.cls b/force-app/main/default/classes/NewQuoteIraiController.cls
index aad5885..f892eb4 100644
--- a/force-app/main/default/classes/NewQuoteIraiController.cls
+++ b/force-app/main/default/classes/NewQuoteIraiController.cls
@@ -310,6 +310,15 @@
                 } else {
                     // 宸茬粡瀛樺湪鎶ヤ环
                     if (String.isNotBlank(oppquoid)) {
+                        //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy start
+                        Quote quo2 = new Quote();
+                        List<Quote> quote =  [select Id,Agency1__c,Agency2__c From Quote Where Id =:oppquoid];
+                        if(quote.size()>0){
+                            quo2=quote[0];
+                        }
+                        quo.Agency1_entrust__c = quo2.Agency1__c;
+                        quo.Agency2_entrust__c = quo2.Agency2__c;
+                        //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy end
                         // 鎶ヤ环鍟嗗搧鍙栧緱
                         // CHAN-BHNBX6 2019/11/20 START//fy lastbuy 20220310 PricebookEntry.Product2.LastbuyProductFLG__c
                         List<QuoteLineItem> qlis = [select id,PricebookEntry.Product2Id,PricebookEntry.Product2.LastbuyProductFLG__c,Quantity__c,CurrencyIsoCode,GuaranteePeriod__c from QuoteLineItem where QuoteId = :oppquoid];
@@ -426,13 +435,15 @@
                 [ SELECT Id,Name,Cancel_Decide__c,Agency_Hospital_Link__c,CreatedDate, PriceRefreshDate__c,Quote_Print_Date__c,Agency1_entrust__c,cancelMultiyearInsurance__c,
                         Quote_Date__c,QuoteToName__c,Quote_Expiration_Date__c,Quote_Comment__c,Tender_information__c,Noteplus__c,Lead__c,Opportunity__c,
                         TOTAL__c,Discount__c,Pricing__c,Preferential_Trading_Price__c,Contract__c,LastIraiUser__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,
+                        Agency2_entrust__c,//DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy
                         Print_HP_Name__c,Account__c,IraiUser__c,IraiSubject__c,CurrencyIsoCode,IraiName__c,QuoteIrai_Status__c,QuoteProportion__c,Note__c,IraiComment__c
+                        , urgent__c  //20230104 lt DB202212427301
                         FROM QuoteIrai__c Where Id =:quoId];
             // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/11 End
             // CHAN-BHNBX6 2019/11/20 START
-            List<QuoteIraiLineItem__c> items = //lastbuy  2022/3/10 fy start LastbuyProductFLG__c //SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 start Is_DangerousChemicals__c
+            List<QuoteIraiLineItem__c> items = //lastbuy  2022/3/10 fy start LastbuyProductFLG__c //SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 start Is_DangerousChemicals__c,CanNotCancelledGurantee__c
                 [Select Id,Asset_Model_No__c,SFDA_Status__c,Name__c,BSS_Category__c,QuoteIrai__r.Quote_Print_Date__c,
-                    Qty_Unit__c,Quantity__c,Product2__r.SFDA_Status__c,ProductCode__c,ListPrice__c,Product2__r.LastbuyProductFLG__c,Product2__r.Is_DangerousChemicals__c,
+                    Qty_Unit__c,Quantity__c,Product2__r.SFDA_Status__c,ProductCode__c,ListPrice__c,Product2__r.LastbuyProductFLG__c,Product2__r.Is_DangerousChemicals__c,CanNotCancelledGurantee__c,
                     Product2__r.Sales_Possibility__c,Product2__r.Name,Product2__c,ServicePrice__c,NoDiscountTotal__c,GuaranteePeriod__c
                     From QuoteIraiLineItem__c where QuoteIrai__c = :quoId Order by Item_Order__c, Id];
             // CHAN-BHNBX6 2019/11/20 END
@@ -1021,6 +1032,7 @@
                 }
             }
         }
+        // System.debug('---lt123---descriptions---'+descriptions);
         if (descriptions.size() <= 0) {
             errorflg = true;
             errorMessage = '娌℃湁瑕佸鎵樼殑浜у搧銆�';
@@ -1038,25 +1050,52 @@
             }
             
             String description = '';
+            //20230116 fy start
+            String descriptionsendEmailp = '';
+            String descriptionsendEmailbody = '';
+            //20230116 fy end
             Integer i = 1;
             for (String d : descriptions) {
                 if (i == 1) {
                     description += d;
+                    //20230116 fy start
+                    descriptionsendEmailp += d;
+                    //20230116 fy end
                 } else {
                     description += '\r\n' + d;
+                    //20230116 fy start
+                    descriptionsendEmailp += '\r\n' + d;
+                    //20230116 fy end
                 }
                 i += 1;
             }
+            // System.debug('---lt123---description---'+description);
             //obsap 鏂板缁忛攢鍟�1瀛楁 fy start
             if (!String.isBlank(quo.Agency1_entrust__c)) {
                 Account  quoteAeName = [select Id,Name from Account where Id =:quo.Agency1_entrust__c];
                 description += '\r\n' + '绗竴缁忛攢鍟嗗悕绉�' + '锛�' + quoteAeName.Name;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + '绗竴缁忛攢鍟嗗悕绉�' + '锛�' + quoteAeName.Name;
+                //20230116 fy end
             }
+            //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy start
+            if (!String.isBlank(quo.Agency2_entrust__c)) {
+                Account  quoteAeName2 = [select Id,Name from Account where Id =:quo.Agency2_entrust__c];
+                description += '\r\n' + '绗簩缁忛攢鍟嗗悕绉�' + '锛�' + quoteAeName2.Name;
+                descriptionsendEmailbody += '\r\n' + '绗簩缁忛攢鍟嗗悕绉�' + '锛�' + quoteAeName2.Name;
+            }
+            //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy end
             if (quo.QuoteProportion__c!=null) {
                 description += '\r\n' + '鎶ヤ环姣斾緥' + '锛�' + quo.QuoteProportion__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + '鎶ヤ环姣斾緥' + '锛�' + quo.QuoteProportion__c;
+                //20230116 fy end
             }
             if (!String.isBlank(quo.IraiComment__c)) {
                 description += '\r\n' + '鎶ヤ环澶囨敞' + '锛�' + quo.IraiComment__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + '鎶ヤ环澶囨敞' + '锛�' + quo.IraiComment__c;
+                //20230116 fy end
             }
             //obsap 鏂板缁忛攢鍟�1瀛楁 fy end
             //XLIU-CFE8M7 銆愬鎵樸�戙�怭-OBSAP銆戞姤浠峰鎵樹换鍔℃敼鍠� fy start
@@ -1072,22 +1111,43 @@
                 description += '\r\n' + node;
                 //XLIU-CFE8M7 銆愬鎵樸�戙�怭-OBSAP銆戞姤浠峰鎵樹换鍔℃敼鍠� fy end
                 // description += '\r\n' + quo.Note__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + node;
+                //20230116 fy end
             }
             if (!String.isBlank(quo.Account__c)) {
                 description += '\r\n' + Account.sObjectType.getDescribe().getLabel() + '锛�' + baseUrl + '/' + quo.Account__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + Account.sObjectType.getDescribe().getLabel() + '锛�' + baseUrl + '/' + quo.Account__c;
+                //20230116 fy end
             }
             // 缁忛攢鍟嗚浠锋姤浠峰鎵� 2020-02-28 update by vivek start
             if (!String.isBlank(quo.Agency_Hospital_Link__c)) {
                 description += '\r\n' + Agency_Hospital_Link__c.sObjectType.getDescribe().getLabel() + '锛�' + baseUrl + '/' + quo.Agency_Hospital_Link__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + Agency_Hospital_Link__c.sObjectType.getDescribe().getLabel() + '锛�' + baseUrl + '/' + quo.Agency_Hospital_Link__c;
+                //20230116 fy end
             }
             // 缁忛攢鍟嗚浠锋姤浠峰鎵� 2020-02-28 update by vivek end
             //obsap 鏂板缁忛攢鍟�1瀛楁 fy start
             if (!String.isBlank(quo.Agency1_entrust__c)) {
                 description += '\r\n' + '绗竴缁忛攢鍟�' + '锛�' + baseUrl + '/' + quo.Agency1_entrust__c;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + '绗竴缁忛攢鍟�' + '锛�' + baseUrl + '/' + quo.Agency1_entrust__c;
+                //20230116 fy end
             }
+            //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy start
+            if (!String.isBlank(quo.Agency2_entrust__c)) {
+                description += '\r\n' + '绗簩缁忛攢鍟�' + '锛�' + baseUrl + '/' + quo.Agency2_entrust__c;
+                descriptionsendEmailbody += '\r\n' + '绗簩缁忛攢鍟�' + '锛�' + baseUrl + '/' + quo.Agency2_entrust__c;
+            }
+            //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy end
             //SWAG-CKDATG銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start
             if (!String.isBlank(tenderid)&&!description.contains('鎷涙爣椤圭洰') ) {
                 description += '\r\n' + '鎷涙爣椤圭洰' + '锛�' + baseUrl + '/' + tenderid;
+                //20230116 fy start
+                descriptionsendEmailbody += '\r\n' + '鎷涙爣椤圭洰' + '锛�' + baseUrl + '/' + tenderid;
+                //20230116 fy end
             }
             //SWAG-CKDATG銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end
             //obsap 鏂板缁忛攢鍟�1瀛楁 fy end
@@ -1131,7 +1191,21 @@
             Task[] tasks = [select Id,Subject,OwnerId,Description,ActivityDate,QuoteIraiId__c
                             from Task
                             where QuoteIraiId__c = :quoId and OwnerId in :irai_userids];
-            String todoSubject = '鎶ヤ环濮旀墭锛�' + quo.IraiSubject__c;
+            //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start      
+            List<String>  HeadquartersArray= quo.Headquarters__c.split('\\.');
+            String Headquarters = '';
+            if(HeadquartersArray.size()>0){
+                Headquarters = HeadquartersArray.size()>=2 ? HeadquartersArray[1]:HeadquartersArray[0];
+            }
+            // String todoSubject = '鎶ヤ环濮旀墭锛�' + quo.IraiSubject__c;
+            String todoSubject = Headquarters+'鎶ヤ环濮旀墭锛�' + quo.IraiSubject__c;
+            //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
+            // 20230104 lt DB202212427301 start
+            if(quo.Urgent__c){
+                todoSubject = '銆愮揣鎬ャ��' + todoSubject;
+            }
+            
+            // 20230104 lt DB202212427301 end
             if (!String.isBlank(quo.IraiName__c)) {
                 todoSubject += '锛� ' + quo.IraiName__c;
             }
@@ -1175,20 +1249,29 @@
             //     taskid = task.Id;
             // }
             List<String> new_task_users = new List<String>();
+            //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start
+            List<String> taskIdL = new List<String>();
+            //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
             if (tasks.size() > 0) {
                 List<String> task_users = new List<String>();
                 for (Task task : tasks) {
                     task_users.add(task.OwnerId);
-
+                    //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start
+                    taskIdL.add(task.Id);
+                    //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
                     task.Subject = todoSubject;
                     task.Description = description;
                     task.ActivityDate = Date.today();
                 }
-                Database.DMLOptions dmlo = new Database.DMLOptions();
-                dmlo.EmailHeader.triggerUserEmail = true;
-                Database.update(tasks, dmlo);
-                // update tasks;
-
+                //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start
+                // Database.DMLOptions dmlo = new Database.DMLOptions();
+                // dmlo.EmailHeader.triggerUserEmail = true;
+                // Database.update(tasks, dmlo);
+                update tasks;
+                if(taskIdL.size()>0){
+                    sendEmail(todoSubject,descriptionsendEmailp,descriptionsendEmailbody,taskIdL[0],Headquarters);
+                }
+                //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
                 for (String uid : irai_userids) {
                     if (!task_users.contains(uid)) {
                         new_task_users.add(uid);
@@ -1207,14 +1290,22 @@
                     new_task.Description = description;
                     new_task.ActivityDate = Date.today();
                     new_task.QuoteIraiId__c = quoId;
+                    // 20230109 lt DB202212427301 start
+                    if(quo.Urgent__c){
+                        new_task.Priority = '楂�';
+                    }
+                    // 20230109 lt DB202212427301 start
 
                     new_tasks.add(new_task);
                 }
                 system.debug('new_tasks++'+new_tasks);
-                Database.DMLOptions dmlo = new Database.DMLOptions();
-                dmlo.EmailHeader.triggerUserEmail = true;
-                Database.insert(new_tasks, dmlo);
-                // insert new_tasks;
+                //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start
+                // Database.DMLOptions dmlo = new Database.DMLOptions();
+                // dmlo.EmailHeader.triggerUserEmail = true;
+                // Database.insert(new_tasks, dmlo);
+                insert new_tasks;
+                sendEmail(todoSubject,descriptionsendEmailp,descriptionsendEmailbody,new_tasks[0].Id,Headquarters);
+                //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
             }
             // obsap 濮旀墭浜烘寜鍏叡灏忕粍鍖哄垎锛屾绱㈡暟閲忓鍔� 2022-05-09 ssm end
             
@@ -1222,20 +1313,27 @@
             quo.LastIraiUser__c = u.Name;
             QuoteIrai__c qi = new QuoteIrai__c(Id = quoId);
             qi.LastIraiUser__c = quo.LastIraiUser__c;
+            qi.Urgent__c = quo.Urgent__c;     //20230104 lt DB202212427301 shart
             //鎶ヤ环濮旀墭鐘舵�佹洿鏂�  宸茬粡濮旀墭
             qi.QuoteIrai_Status__c = '宸茬粡濮旀墭';
+            //DB202211607582 fy 銆愭姤浠峰鎵樸�戞姤浠峰鎵橀〉闈㈤渶姹� start
+            qi.EntrustmentDate__c = Date.today();
+            //DB202211607582 fy 銆愭姤浠峰鎵樸�戞姤浠峰鎵橀〉闈㈤渶姹� end
             update qi;
+
             if(String.isNotBlank(quoId)){
                 // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/11 Start
             //XLIU-CFE8M7 銆愬鎵樸�戙�怭-OBSAP銆戞姤浠峰鎵樹换鍔℃敼鍠� fy  Noteplus__c
             //SWAG-CF589P銆愬鎵樸�戙�怭:OBSAP銆戞姤浠峰鎵樼浉鍏虫柊闇�姹傝瘎浼� fy Lead__c,Opportunity__c,
                 quo =[ SELECT Id,Name,Cancel_Decide__c,CreatedDate, PriceRefreshDate__c,Quote_Print_Date__c,//obsap 鏂板缁忛攢鍟�1瀛楁 fy satrt Agency1_entrust__c,SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start cancelMultiyearInsurance__c,
                         Quote_Date__c,QuoteToName__c,Quote_Expiration_Date__c,Quote_Comment__c,Tender_information__c,Agency1_entrust__c,Noteplus__c,Lead__c,Opportunity__c,cancelMultiyearInsurance__c,
-                        TOTAL__c,Discount__c,Pricing__c,Preferential_Trading_Price__c,Contract__c,LastIraiUser__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,
+                        TOTAL__c,Discount__c,Pricing__c,Preferential_Trading_Price__c,Contract__c,LastIraiUser__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,Agency2_entrust__c,//DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy
                         Print_HP_Name__c,Account__c,Agency_Hospital_Link__c,IraiUser__c,IraiSubject__c,CurrencyIsoCode,IraiName__c,QuoteIrai_Status__c,QuoteProportion__c,Note__c,IraiComment__c
+                        , urgent__c  //20230104 lt DB202212427301
                         FROM QuoteIrai__c Where Id =:quoId];
                 // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/11 End
             }
+
             // 鎷涙姇鏍囨姤浠峰鎵� 2020-06-21 update by gzw start
             if (!String.isBlank(quo.Tender_information__c)) {
                 Tender_information__c tender = new Tender_information__c(Id = quo.Tender_information__c);
@@ -1252,6 +1350,16 @@
             if(String.isNotBlank(leadid)){
                 lea.Id = leadid;
                 lea.OfferToEntrust__c = 1;
+                //20230227 lt DB202302251962 start
+                List<Lead> leadlist = [select Id,Firsttime_Quote_Irai__c from Lead where Id = :leadid];
+                System.debug('lt123鏃ユ湡1'+ leadlist[0].Firsttime_Quote_Irai__c);
+                System.debug('lt123鏃ユ湡2'+ lea.Firsttime_Quote_Irai__c);
+                if(leadlist.size() > 0){
+                    if(leadlist[0].Firsttime_Quote_Irai__c == null){
+                        lea.Firsttime_Quote_Irai__c = Date.today();
+                    }
+                }
+                //20230227 lt DB202302251962 end
                 update lea;
             }
             //XLIU-CHY4KW 20220907 lt end  
@@ -1593,8 +1701,9 @@
             //XLIU-CFE8M7 銆愬鎵樸�戙�怭-OBSAP銆戞姤浠峰鎵樹换鍔℃敼鍠� fy  Noteplus__c
             //SWAG-CF589P銆愬鎵樸�戙�怭:OBSAP銆戞姤浠峰鎵樼浉鍏虫柊闇�姹傝瘎浼� fy Lead__c,Opportunity__c,
             qs = [select Id,Account__c,Agency_Hospital_Link__c,Name,IraiUser__c,IraiSubject__c,Tender_information__c,Agency1_entrust__c,Noteplus__c,Lead__c,Opportunity__c,cancelMultiyearInsurance__c,
-                Preferential_Trading_Price__c,Discount__c,Pricing__c,Unit_Price__c,Offer_Amount__c,TOTAL__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,
+                Preferential_Trading_Price__c,Discount__c,Pricing__c,Unit_Price__c,Offer_Amount__c,TOTAL__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,Agency2_entrust__c,//DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy
                 Contract__c,Print_HP_Name__c,Quote_Expiration_Date__c,Quote_Comment__c,IraiName__c,QuoteIrai_Status__c,QuoteProportion__c,Note__c,IraiComment__c
+                , urgent__c  //20230104 lt DB202212427301
                 From QuoteIrai__c Where Id =:quoId];
             // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/11 End
             if (qs.size()>0){
@@ -1621,6 +1730,9 @@
         //obsap 鏂板缁忛攢鍟�1瀛楁 fy staty
         q.Agency1_entrust__c = quo.Agency1_entrust__c;
         //obsap 鏂板缁忛攢鍟�1瀛楁 fy staty
+        //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy start
+        q.Agency2_entrust__c = quo.Agency2_entrust__c;
+        //DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy end
         // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start
         q.cancelMultiyearInsurance__c = quo.cancelMultiyearInsurance__c;
         // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end
@@ -1642,6 +1754,7 @@
         q.Quote_Expiration_Date__c = quo.Quote_Expiration_Date__c;
         q.Quote_Comment__c = quo.Quote_Comment__c;
         q.LastIraiUser__c = quo.LastIraiUser__c;
+        q.Urgent__c = quo.Urgent__c;   //20230104 lt DB202212427301 shart
         system.debug('鏍囧噯浠锋牸2锛�'+qb.Estimation_List_Price);
         // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/10 Start 
          q.Estimation_List_Price__c = qb.Estimation_List_Price;
@@ -1660,9 +1773,10 @@
         //XLIU-CFE8M7 銆愬鎵樸�戙�怭-OBSAP銆戞姤浠峰鎵樹换鍔℃敼鍠� fy  Noteplus__c
         //SWAG-CF589P銆愬鎵樸�戙�怭:OBSAP銆戞姤浠峰鎵樼浉鍏虫柊闇�姹傝瘎浼� fy Lead__c,Opportunity__c,
         quo =[ SELECT Id,Name,Cancel_Decide__c,CreatedDate, PriceRefreshDate__c,Quote_Print_Date__c,//obsap 鏂板缁忛攢鍟�1瀛楁 fy satrt Agency1_entrust__c,SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start cancelMultiyearInsurance__c,
-                    Quote_Date__c,QuoteToName__c,Quote_Expiration_Date__c,Quote_Comment__c,Tender_information__c,Agency1_entrust__c,Noteplus__c,Lead__c,Opportunity__c,cancelMultiyearInsurance__c,
-                    TOTAL__c,Discount__c,Pricing__c,Preferential_Trading_Price__c,Contract__c,LastIraiUser__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,
+                    Quote_Date__c,QuoteToName__c,Quote_Expiration_Date__c,Quote_Comment__c,Tender_information__c,Agency1_entrust__c,Noteplus__c,Lead__c,Opportunity__c,cancelMultiyearInsurance__c,Headquarters__c,//DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy Headquarters__c
+                    TOTAL__c,Discount__c,Pricing__c,Preferential_Trading_Price__c,Contract__c,LastIraiUser__c,MultiYearWarrantyTotalPrice__c,QuoteTotal_Page__c,Estimation_List_Price__c,Agency2_entrust__c,//DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy
                     Print_HP_Name__c,Account__c,Agency_Hospital_Link__c,IraiUser__c,IraiSubject__c,CurrencyIsoCode,IraiName__c,QuoteIrai_Status__c,QuoteProportion__c,Note__c,IraiComment__c
+                    , urgent__c  //20230104 lt DB202212427301
                     FROM QuoteIrai__c Where Id =:q.Id];
 
 system.debug('鈼嬧棆鈼嬧棆鈼婼ave1鈼嬧棆鈼嬧棆鈼�');
@@ -1869,6 +1983,61 @@
     return str;
   }
   //SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 end
+  //DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy start
+  private static void sendEmail(String title , String bodyTextp , String bodyTextbody,String TaskId,String Headquarters) {
+    system.debug('bodyText++'+bodyTextp+bodyTextbody);
+    bodyTextbody = bodyTextbody.replaceFirst('\r\n', '');
+    List<Task> TaskList = [select Id,Request_staff__c,ActivityDate,Priority from Task where Id =:TaskId];
+    Task Taskobj = TaskList[0];
+    //20230116 fy start
+    String bodyTextbu ='鏂板缓浠诲姟';
+    bodyTextbu += '\r\n\r\n'+'鍒帮細OBSAP鎴愬憳';
+    if(String.isNotBlank(Headquarters)){
+        Headquarters='('+Headquarters+')';
+    }
+    bodyTextbu += '\r\n'+Taskobj.Request_staff__c +Headquarters+' 宸插垎閰嶇粰鎮ㄤ互涓嬫柊寤轰换鍔★細';
+    bodyTextbu += '\r\n'+'涓婚: '+title;
+    bodyTextbu += '\r\n'+'缁撴潫鏈熼檺: '+Taskobj.ActivityDate;
+    bodyTextbu += '\r\n'+'浼樺厛绾�: '+Taskobj.Priority;
+    bodyTextbu += '\r\n' +'璇勮锛�<pre>'+bodyTextp+'</pre>';
+    bodyTextbu += bodyTextbody;
+    bodyTextbu += '\r\n\r\n' +'鏈夊叧鏇村璇︾粏淇℃伅锛岃鍗曞嚮浠ヤ笅閾炬帴锛�'+'\r\n\r\n'+'https://ocsm.my.salesforce.com/'+Taskobj.Id;
+    bodyTextbu = bodyTextbu.replace('\r\n', '<br/>');
+    bodyTextbu = bodyTextbu.replaceFirst('<br/>', '');
+    System.debug('bodyTextbu+++'+bodyTextbu);
+    //20230116 fy end
+    Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
+    List<String> toAddresses = new List<String>();
+    toAddresses.add(System.Label.OBSAP_Group_Mail);
+    // toAddresses.add('fuyu@prec-tech.com');
+    //鏀朵欢浜哄湴鍧�
+    mail.setToAddresses(toAddresses);
+    String Detection = System.Label.OBSAP_QuoteIrai_Mail_Detection;
+    if(!Detection.equals('invalid') && String.isNotBlank(Detection)){
+        String[] toccAddresses = System.Label.OBSAP_QuoteIrai_Mail_Detection.split(',');
+        //鎶勯�佷汉鍦板潃
+        mail.setCcAddresses(toccAddresses);
+    }
+    //閭欢涓婚
+    mail.setSubject(title);
+    //鍐呭鐨勭紪鐮�
+    mail.setCharset('UTF-8');
+    //閭欢鍐呭
+    mail.setHtmlBody(bodyTextbu);
+    //浣跨敤鐢靛瓙閭欢妯℃澘璁剧疆瀵硅薄id
+    // mail.setTargetObjectId(TaskId);
+    //璁剧疆鐢靛瓙閭欢妯℃澘id
+    // EmailTemplate temp =  [
+    //     SELECT Id, Name, Subject, HtmlValue, Body, BrandTemplateId
+    //     FROM EmailTemplate
+    //     WHERE DeveloperName = 'Task_To_Queue'
+    //     LIMIT 1
+    // ];
+    // mail.setTemplateId(temp.Id);
+    //鍙戦�侀偖浠�
+    Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
+}
+//DB202301106714 銆愭姤浠峰鎵樻敼鍠勩�慜BSAP閫氱煡閭欢鍙戦�侀偖绠变慨鏀� fy end
 
     // CHAN-BJQ4VZ 绮剧悽鎶�鏈� 2019/12/11 Start
     public class QuoteBean {
@@ -1898,6 +2067,10 @@
         public Decimal NoDiscount_Page { get; set; }
         public Decimal NoDiscountTotal_Page { get; set; }
         // CHAN-BHNBX6 2019/11/20 END
+        
+        // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start
+        public String CanNotCancelledGurantee { get; set; }
+        // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end
 
         // TODO 銇汇倱銇ㄣ亞銇亜銈夈仾銇勩�佷娇銇嗐仺銇撱倣銇儹銈搞儍銈倰淇銇椼仾銇戙倢銇般亜銇戙仾銇勩�佸墛闄ゃ仚銈嬨倛銇嗐伀銇椼仧銇勩仹銇欍��
         public QELine(Integer i) {
@@ -1943,6 +2116,9 @@
             }
             
             // CHAN-BHNBX6 2019/11/20 END
+            // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start
+            this.CanNotCancelledGurantee = qli.CanNotCancelledGurantee__c?'true':'false';
+            // SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end
         }
         
         // TODO Subtotal__c銆佷互鍓嶃伄銉偢銉冦偗銈掔⒑瑾�
diff --git a/force-app/main/default/classes/NewQuoteIraiControllerTest.cls b/force-app/main/default/classes/NewQuoteIraiControllerTest.cls
index 6f804fe..6a66978 100644
--- a/force-app/main/default/classes/NewQuoteIraiControllerTest.cls
+++ b/force-app/main/default/classes/NewQuoteIraiControllerTest.cls
@@ -226,6 +226,7 @@
         controller.quo.IraiComment__c = '銉嗐偣銉�03';
         controller.quo.QuoteProportion__c = 10;
         controller.quo.IraiUser__c = user.Id;
+        controller.quo.cancelMultiyearInsurance__c = '涓嶈';
         
         controller.activities[0].lineNo = 0;
         controller.activities[0].Asset_Model = '00107';
@@ -1340,6 +1341,7 @@
         // System.assertEquals(null, controller.activities[0].Asset_Model);
         
         controller.quo.IraiSubject__c = '銉嗐偣銉�05';
+        controller.quo.cancelMultiyearInsurance__c = '涓嶈';
         
         controller.excel_text = '00103\t10';
         controller.excelImport();
@@ -1418,7 +1420,7 @@
         // CHAN-BHNBX6 2019/11/25 END
         
         controller.quoteIrai();
-
+        System.test.startTest();
         QuoteIrai__c[] irais2 = [select Id, Note__c,Name, IraiUser__c, IraiSubject__c, CurrencyIsoCode from QuoteIrai__c where IraiSubject__c = '銉嗐偣銉�05'];
         QuoteIraiLineItem__c[] items2 = [select Id, Asset_Model_No__c, SFDA_Status__c, Name__c,Quantity__c, ListPrice__c, ProductCode__c,Product2__c,ServicePrice__c,GuaranteePeriod__c from QuoteIraiLineItem__c where QuoteIrai__c = :irais2[0].Id order by Item_Order__c];
         
@@ -1519,6 +1521,7 @@
         // System.assertEquals(true, controller.errorflg);
         // System.assertEquals('鍋滄', controller.activities[0].pageObject.SFDA_Status__c);
         // System.assertEquals('00103:杞鎺ュご123', controller.activities[0].pageObject.Name__c);
+        System.test.stopTest();     
     }
     
     //鍏朵粬鍗曚綋鍑芥暟
diff --git a/force-app/main/default/pages/NewQuoteIrai.page b/force-app/main/default/pages/NewQuoteIrai.page
index b55d6d4..f538e97 100644
--- a/force-app/main/default/pages/NewQuoteIrai.page
+++ b/force-app/main/default/pages/NewQuoteIrai.page
@@ -1,4 +1,4 @@
-<apex:page controller="NewQuoteIraiController" sidebar="false" action="{!init}" id="Page" >
+<apex:page controller="NewQuoteIraiController" sidebar="false" action="{!init}" id="Page" lightningStylesheets="true">
     <apex:stylesheet value="{!URLFOR($Resource.jquerysuggestcss)}"/>
     <apex:stylesheet value="{!URLFOR($Resource.blockUIcss)}"/>
     <apex:includeScript value="{!URLFOR($Resource.jquery183minjs)}"/>
@@ -126,10 +126,14 @@
                         alert('璇烽�夋嫨瀵瑰簲鐨勮惀涓氬姪鐞�.');
                         unblockUI();              
                     }
-                    else if (window.confirm('纭畾瑕佸鎵樿浜哄憳鍚楋紵\n' + mail)) {
-                        QuoteIrai();
-                    } else {
-                        unblockUI();
+                    // 20230104 lt DB202212427301 start  娉ㄩ噴
+                    // else if (window.confirm('纭畾瑕佸鎵樿浜哄憳鍚楋紵\n' + mail)) {
+                        // QuoteIrai();
+                    // } 
+                    // 20230104 lt DB202212427301 end
+                    else {
+                        QuoteIrai();   // 20230104 lt DB202212427301 end
+                        // unblockUI(); // 20230104 lt DB202212427301 end
                     }
                 } else {
                     alert('璇烽�夋嫨濮旀墭浜哄憳.');
@@ -340,9 +344,16 @@
                         <td style="text-align:center;width:20px;"><apex:selectList value="{!quo.IraiUser__c}" size="1" style="width:120px" id="IraiUser" onchange="ObsapUsersChange()"><apex:selectOptions value="{!ObsapUsers}" id="obsapUsersList"/></apex:selectList></td>
                         </apex:variable>
 
+                        <!-- 20230104 lt DB202212427301 start-->
+                        <!-- <th style="text-align:right;width:80px;">{!$ObjectType.QuoteIrai__c.fields.LastIraiUser__c.Label}</th>
+                        <td style="text-align:center;width:70px;"><apex:outputField id="LastIraiUser" value="{!quo.LastIraiUser__c}"/></td> -->
+                        <!-- 20230104 lt DB202212427301 end-->
 
-                        <th style="text-align:right;width:80px;">{!$ObjectType.QuoteIrai__c.fields.LastIraiUser__c.Label}</th>
-                        <td style="text-align:center;width:70px;"><apex:outputField id="LastIraiUser" value="{!quo.LastIraiUser__c}"/></td>
+                        <!-- 20230104 lt DB202212427301 start-->
+                        <th style="text-align:right;width:190px;">绱ф�ワ細</th>
+                        <td style="text-align:center;width:10px;"><apex:inputField id="Urgent" value="{!quo.Urgent__c}"/></td>
+                        <!-- 20230104 lt DB202212427301 end-->
+
                         <!-- 2020/02/18  绮剧悽鎶�鏈�  闊╅儴闀挎彁鍑哄厛闅愯棌 娌″繀瑕�  Start-->
                         <!-- <th style="text-align:right;width:70px;">鎬昏</th>
                         <td style="text-align:right;width:80px;">
@@ -359,14 +370,14 @@
                 </tr>
                 <tr>
                     <td style="text-align:right;width:50px;"></td>
-                    <th style="text-align:right;width:50px;" rowspan="2">
+                    <th style="text-align:right;width:50px;" rowspan="3">
                        {!$ObjectType.QuoteIrai__c.fields.MultiYearWarrantyTotalPrice__c.Label}
                    :&nbsp;</th>
                    <!-- <td style="width:470px;"> -->
                        <!--obsap 鏂板缁忛攢鍟�1瀛楁 fy start-->
-                   <td style="width:10px;" rowspan="2">
+                   <td style="width:100px;" rowspan="3">
                        <!--obsap 鏂板缁忛攢鍟�1瀛楁 fy end-->
-                       <apex:outputtext id="MultiYearWarrantyTotalPrice_out" value="{0, number, ###,##0.00}" 
+                       <apex:outputtext style="width: :100px" id="MultiYearWarrantyTotalPrice_out" value="{0, number, ###,##0.00}" 
                        >
                        <!--obsap 鏂板缁忛攢鍟�1瀛楁 fy start-->
                        <!-- style="text-align:right;width:180px;"> -->
@@ -405,11 +416,24 @@
                 <th style="width:100px;text-align:right;">{!$Label.Sales_Name1}</th>
                 <td colspan="2" style="width:260px;text-align:right;"><apex:inputField style="width:230px;" id="SalesName1"  value="{!quo.Agency1_entrust__c}"   onChange=""/></td>
                 <!-- SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy start -->
-                <th style="width:100px;text-align:right;">鍙栨秷澶氬勾淇�</th>
-                <td colspan="2" style="text-align:left;"><apex:inputField id="cancelMultiyearInsurance"  value="{!quo.cancelMultiyearInsurance__c}"   /></td>
+                <th style="width:100px;text-align:right;">澶氬勾淇�</th>
+                <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy start -->
+                <td colspan="2" style="text-align:left;"><apex:inputField id="cancelMultiyearInsurance"  value="{!quo.cancelMultiyearInsurance__c}"  onChange="cancelMultiyearInsurancechange()"/></td><!-- onChange="cancelMultiyearInsurancechange()"-->
+                <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy end -->
                 <!-- SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end -->
                 </tr>
                 <!--obsap 鏂板缁忛攢鍟�1瀛楁 fy end-->
+                <!--DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy start-->
+               <tr>
+                <td ></td>
+                <td ></td>
+                <td ></td>
+                <th style="width:100px;text-align:right;">{!$Label.Sales_Name2}</th>
+                <td colspan="2" style="width:260px;text-align:right;"><apex:inputField style="width:230px;" id="SalesName2"  value="{!quo.Agency2_entrust__c}"   onChange=""/></td>
+                <th style="width:100px;text-align:right;"></th>
+                <td colspan="2" style="text-align:left;"></td>
+               </tr>
+                <!--DB202302464682銆愭姤浠峰鎵樸�戞姤浠峰鎵樻敼鍠�224 fy end-->
                 <tr>
                     <td>&nbsp;</td>
                 </tr>
@@ -454,6 +478,9 @@
                     <!-- 浜у搧缂栧彿-->
                     <apex:column style="text-align:center;width:150px;">
                         <apex:inputText id="Assert" style="width:120px;" value="{!s.Asset_Model}" onclick="searchProduct('{!s.lineNo}',this.value)" />
+                        <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy start -->
+                        <apex:inputHidden id="CanNotCancelledGurantee__c" value="{!s.CanNotCancelledGurantee}" />
+                        <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy start -->
                     </apex:column>
                     <!-- NMPA鐘舵�� -->
                     <apex:column style="width:100px;text-align:center;">
@@ -518,12 +545,30 @@
                         <apex:outputPanel layout="none" rendered="{!!$ObjectType.QuoteIraiLineItem__c.fields.ServicePrice__c.accessible}" >
                             <span style="width:80px;text-align:right;" id="Page:mainForm:block:lists:{!s.lineNo}:NoDiscountTotalText">{!IF(s.PageObject.Product2__c == null, ' ', 0.00)}</span>
                             <script type="text/javascript">
+                            debugger
                                 j$(escapeVfId('Page:mainForm:block:lists:'+ {!s.lineNo} + ':NoDiscountTotal')).val(toNum(0));
                             </script>
                         </apex:outputPanel>
                         
                         
                     </apex:column>
+                    <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy start -->
+                    <!-- <apex:column style="width:100px;text-align:right;">
+                        <apex:outputPanel layout="none" rendered="{!IF(quo.cancelMultiyearInsurance__c =='瑕�' ||(quo.cancelMultiyearInsurance__c =='涓嶈' && s.CanNotCancelledGurantee == 'true' ),true,false)}" >
+                            <apex:outputText style="width:80px;" id="NoDiscountTotalText" value="{0, number, ###,##0.00}">
+                                <apex:param value="{!s.NoDiscountTotal_Page}" />
+                            </apex:outputText>
+                        </apex:outputPanel>
+                        <apex:inputHidden id="NoDiscountTotal" value="{!s.NoDiscountTotal_Page}"/>
+                        <apex:inputHidden id="NoDiscount" value="{!s.NoDiscount_Page}"/>
+                        <apex:outputPanel layout="none" rendered="{!IF(quo.cancelMultiyearInsurance__c =='涓嶈'&& s.CanNotCancelledGurantee == 'false'  ,true,false)}" >
+                            <span style="width:80px;text-align:right;" id="Page:mainForm:block:lists:{!s.lineNo}:NoDiscountTotalText">{!IF(s.PageObject.Product2__c == null, ' ', 0.00)}</span>
+                            <script type="text/javascript">
+                                j$(escapeVfId('Page:mainForm:block:lists:'+ {!s.lineNo} + ':NoDiscountTotal')).val(toNum(0));
+                            </script>
+                        </apex:outputPanel>
+                    </apex:column> -->
+                    <!-- DB202212304166 銆愮揣鎬�-鎶ヤ环濮旀墭涓庤喘涔版剰鍚戙�戣灏嗘渶鍚庢搷浣滅殑鎶ヤ环濮旀墭鐘舵�佹斁鍒拌喘涔版剰鍚戜腑 fy end -->
                     <!-- CHAN-BHNBX6  NodisCount 灏忚  2019/11/20 END -->
                 </apex:pageBlockTable>
             </div>
@@ -542,10 +587,12 @@
                                 <td style="width:100px;" align="right"><apex:commandButton id="QuoteIraiBtn" action="{!checkIraiUser}" reRender="IraiUserId,message1" onclick="blockme();" oncomplete="iraiJs();return false;" value="鍙戦�佸鎵橀偖浠�" style="width:90px;" disabled="{!Save_button}"/></td>
                                 <!-- SWAG-CKDATG 銆愬鎵樸�戙�怬BSAP-鎶ヤ环濮旀墭銆戞姤浠峰鎵橀」鐩敼鍠�1 fy end -->
                                 <td style="width:100px;" align="right"><apex:commandButton action="{!checkIraiUser}" reRender="IraiUserId,hiddenQuoid,message1" onclick="blockme();" oncomplete="save2btn();return false;" value="{!$Label.Save_Button}" style="width:90px;" disabled="{!Save_button}" /></td>
-                                <td style="width:100px;" align="right"><apex:commandButton onclick="oppReflection2btn();return false;" rerender="hiddenQuoid" value="{!$Label.Opp_Button}" style="width:90px;" disabled="{!Save_button}"/></td>
+                                <!-- 20230109 lt DB202212427301 start  娉ㄩ噴 -->
+                                <!-- <td style="width:100px;" align="right"><apex:commandButton onclick="oppReflection2btn();return false;" rerender="hiddenQuoid" value="{!$Label.Opp_Button}" style="width:90px;" disabled="{!Save_button}"/></td>
                                 <td style="width:100px;" align="right"><apex:commandButton action="{!Back}" rerender="hiddenQuoid" value="涓嶄繚瀛橈紙杩斿洖锛�" style="width:90px;"/></td>
                                 <td style="width:100px;" align="right"><apex:commandButton value="浜у搧璇曠敤璇勪环OPD" style="width:95px;" onclick="openpdf('OPD');return false;" disabled="{!pdf_button}"/></td>
-                                <td style="width:100px;" align="right"><apex:commandButton value="浜у搧璇曠敤璇勪环SIS" style="width:95px;" onclick="openpdf('SIS');return false;" disabled="{!pdf_button}"/></td>
+                                <td style="width:100px;" align="right"><apex:commandButton value="浜у搧璇曠敤璇勪环SIS" style="width:95px;" onclick="openpdf('SIS');return false;" disabled="{!pdf_button}"/></td> -->
+                                <!-- 20230109 lt DB202212427301 end  娉ㄩ噴 -->
                             </tr>
                         </table>
                     </td>

--
Gitblit v1.9.1