<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<activity id="__pVXNEnmEC2uTpw4CrM2">
  <name>导入鉴定成绩</name>
  <parentId>__wsCSThaOyU4jP2sEFXD</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <type>27</type>
  <onActionForm></onActionForm>
  <onActionView></onActionView>
  <colorType>default</colorType>
  <beforeActionScript><![CDATA[]]></beforeActionScript>
  <afterActionScript><![CDATA[(function(){
var sql = "select a.ITEM_IDCARDNO,a.ITEM_GRADUATIONTESTRESULTS,b.ITEM_IDENTIFICATIONTESTRESULTS from tlk_level_class_student a left join tlk_scores b on a.ITEM_IDCARDNO=b.ITEM_IDCARDNO where b.item_identificationTheoryScore <> '' and b.item_identificationOperationScore <> ''";
  println("sql------------------------"+sql);
var datas = queryByDSName("tms",sql);
if(datas!=null){
   for(var iterator = datas.iterator();iterator.hasNext();){
       var map1 = iterator.next();//取值
       var idcardno = map1.get("item_idcardno");
     println("idcardno---------------------"+idcardno);
       var GRADUATIONTESTRESULTS = map1.get("item_GRADUATIONTESTRESULTS");
     println("GRADUATIONTESTRESULTS----------------"+GRADUATIONTESTRESULTS);
     var IDENTIFICATIONTESTRESULTS = map1.get("item_IDENTIFICATIONTESTRESULTS");
     println("IDENTIFICATIONTESTRESULTS-----------------"+IDENTIFICATIONTESTRESULTS);
       if(GRADUATIONTESTRESULTS!="1" || IDENTIFICATIONTESTRESULTS!="1"){
         var sql1="update tlk_grade_registration set item_applystatus='2' where item_idcardno = '"+idcardno+"'";
         println("sql1-----------------"+sql1);
             updateByDSName("tms",sql1);
       }else{
         var sql1="update tlk_grade_registration set item_applystatus='1' where item_idcardno = '"+idcardno+"'";
             updateByDSName("tms",sql1);
         println("sql1-----------------"+sql1);
       }
    }
}
})()]]></afterActionScript>
  <hiddenScript><![CDATA[]]></hiddenScript>
  <readonlyScript><![CDATA[]]></readonlyScript>
  <editMode>0</editMode>
  <fileNameScript><![CDATA[]]></fileNameScript>
  <orderno>2</orderno>
  <parentView>__wsCSThaOyU4jP2sEFXD</parentView>
  <impmappingconfigid>__PquNtPf6KGABNQXTg55</impmappingconfigid>
  <jumpType>0</jumpType>
  <expSub>false</expSub>
  <icon></icon>
  <disableFlowNode>false</disableFlowNode>
  <changeFlowOperator>false</changeFlowOperator>
  <changeFlowCc>false</changeFlowCc>
  <multiLanguageLabel></multiLanguageLabel>
  <dispatcherMode>0</dispatcherMode>
  <dispatcherUrl><![CDATA[]]></dispatcherUrl>
  <dispatcherParams><![CDATA[[{"paramKey":"","paramValue":""}]]]></dispatcherParams>
  <jumpMode>0</jumpMode>
  <jumpActOpenType>0</jumpActOpenType>
  <withOld>false</withOld>
  <actionType>0</actionType>
  <actionSelection>0</actionSelection>
  <workFlowType>0</workFlowType>
  <contextMenu>true</contextMenu>
  <showInToolbar>true</showInToolbar>
  <label><![CDATA[]]></label>
</activity>