结业成绩录入
__LgZds5MVHW3o08T7UcX
__LgZds5MVHW3o08T7UcX
16
2048
1536
rollback
1620630779257
结业成绩表
0
560
107
142
34
impGrade
1620630779257
1620630779257
false
false
560;107;560;107
1620631044408
1620631052992
身份证
0
504
234
142
34
idCardNo
true
(function(){
var idCardNo = getItemValueAsString(@quot;idCardNo@quot;);
println(@quot;身份证号：@quot;+idCardNo);
var sclassid = @quot;@quot;; //定义数据库查询到的班级id
var sidCardNo = @quot;@quot;; //定义数据库查询到的学员的身份证号
var hclassid = new Packages.cn.myapps.common.util.cache.MemoryCacheUtil.getFromPrivateSpace(@quot;classId@quot;, getWebUser());
/**获取导入的总成绩以及其他成绩 **/
var writtenScore1=getItemValueAsInt(@quot;graduationTheoryScore@quot;); //数字类型
var writtenScore2=getItemValueAsInt(@quot;graduationOperationScore@quot;);//数字类型
var sumScore=writtenScore1+writtenScore2
println(@quot;sumScore----@gt;@quot;+sumScore)
var testState=@quot;@quot;
println(@quot;hclassid----@gt;@quot;+hclassid)
var examInfoDoc = findDocument(hclassid); //班级id
var qualifiedGTheoryResult = examInfoDoc.findItem(@quot;qualifiedGTheoryResult@quot;).getValue(); //合格结业理论考试成绩
var qualifiedGOperationResult= examInfoDoc.findItem(@quot;qualifiedGOperationResult@quot;).getValue();//合格结业实操考试成绩
var sumScorequal=parseDouble(qualifiedGTheoryResult)+parseDouble(qualifiedGOperationResult)
if(sumScore@gt;=sumScorequal){//都有，按照总分计算
testState=1 //及格
}else if(0@lt;sumScore@amp;@amp;sumScore@lt;sumScorequal){
testState=2 //不及格
}else{
testState=0 //未考试
}
println(@quot;sumScorequal----@gt;@quot;+sumScorequal)
println(@quot;testState----@gt;@quot;+testState)
var sql = @quot;SELECT ITEM_CLASSID,ID,ITEM_IDCARDNO from tlk_level_class_student where ITEM_IDCARDNO = '@quot;+idCardNo+@quot;'@quot;;
var datas = queryByDSName(@quot;tms@quot;,sql);
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
sclassid = map1.get(@quot;ITEM_CLASSID@quot;);
sidCardNo = map1.get(@quot;ITEM_IDCARDNO@quot;);
ID=map1.get(@quot;ID@quot;);
println(@quot;学生ID@quot;+ID)
println(@quot;数据库班级id：@quot;+sclassid);
println(@quot;数据库身份证号：@quot;+sidCardNo);
}
}
if (!sclassid.equals(hclassid)){
return @quot;身份证号为：@quot;+sidCardNo+@quot;的学员非本班级学员！@quot;;
}else{
println(@quot;开始更新@quot;)
//使用doupdate
/* var process = getDocumentProcess();
var examInfoDoc=findDocument(ID);
examInfoDoc.findItem(@quot;graduationTestResults@quot;).setValue(testState);
examInfoDoc.findItem(@quot;sumScore@quot;).setValue(sumScore);
println(@quot;examInfoDoc@quot;+examInfoDoc)
process.doUpdate(examInfoDoc);
*/
var updatesql=@quot;update tlk_level_class_student set item_graduationTheoryScore='@quot;+writtenScore1+@quot;',item_graduationOperationScore='@quot;+writtenScore2+@quot;', item_graduationTestResults='@quot;+testState+@quot;',ITEM_SUMSCORE = '@quot;+sumScore+@quot;' where ITEM_IDCARDNO = '@quot;+idCardNo+@quot;'@quot;;
updateByDSName(@quot;tms@quot;,updatesql);
println(@quot;更新结束@quot;)
}
})
1620630779257
1620631052992
false
false
579;196;560;107
1620631088824
1620631098416
结业理论成绩
0
613
232
142
34
graduationTheoryScore
false
1620631137088
结业实操成绩
0
744
229
142
34
graduationOperationScore
false
1620630779257
1620631098416
false
false
737;209;560;107
1620631168000
1620630779257
1620631137088
false
false
943;175;560;107
1620631170192
]]>
/uploads/exceltemplate/结业成绩录入.xlsx