取消
__Xq3r3eKoddb3a49Mrrg
__LgZds5MVHW3o08T7UcX
__Xq3r3eKoddb3a49Mrrg
COLUMN_TYPE_OPERATE
false
01
41111
false
false
false
ASC
"+sql);
var datart = findBySQL(sql);
// var classStatus=datart.getItemValueAsString("CLASSSTATUS");
if("1".equals(classStatus)){
/* var sqls="select * from tlk_level_class_student where ITEM_CLASSID='"+docId+"'";
println("sqls====="+sqls);
var datass = queryByDSName("tms",sqls);
if(datass!=null){
for(var iterators = datass.iterator();iterators.hasNext();){
var map2 = iterators.next();//取值
var idcardno = map2.get("ITEM_IDCARDNO");
println("idcardno====="+idcardno);
var sqlsa="SELECT * from tlk_grade_registration where ITEM_IDCARDNO='"+idcardno+"'";
println("sqls====="+sqlsa);
var datassa = queryByDSName("tms",sqlsa);
if(datassa!=null){
for(var iteratorsa = datassa.iterator();iteratorsa.hasNext();){
var map2a = iteratorsa.next();//取值
var learnId = map2a.get("ITEM_learnId");
var name = map2a.get("ITEM_name");
var trainName = map2a.get("ITEM_trainName");
println("learnId====="+learnId);
}}
var sqlsb="select * from t_user where FIELD12='"+idcardno+"'and DOMAINID='"+learnId+"'";
println("sqlsb====="+sqlsb);
var datassb = queryByDSName("obpm2",sqlsb);
if(datassb!=null){
for(var iteratorsb = datassb.iterator();iteratorsb.hasNext();){
var map2b = iteratorsb.next();//取值
var ids = map2b.get("ID");
println("ids====="+ids);}}
var content = "";
var texts ="";
texts += "" + name + "，您参与的由" ;
texts += "" + trainName + "举办的等级实操培训已取消，班级名称" ;
texts += "" + className + "，请等待培训学校重新安排，有任何问题可直接咨询所属保安公司或培训学校。" ;
var appAvatar = "https://bcxin-saas-prod.obs.cn-north-1.myhuaweicloud.com:443/upload%2F2021-11-01%2F1635755240828768236.png";
var title = "";
var titleImg = "";
var actionName = "";
var actionUrl = "";
content += "appName=" + appName + "&&;" ; //应用名称
content += "appId=" + appId + "&&;" ; //应用id
content += "appAvatar=" + appAvatar + "&&;" ; //应用图标
content += "title=" + title + "&&;" ; //标题
content += "titleImg=" + titleImg + "&&;" ; //标题图标
content += "actionName=" + actionName + "&&;" ; //操作名称
content += "actionUrl=" + actionUrl + "&&;" ; //操作链接
content += "content=" + texts + "";
println("usid====>"+usid);
println("ids=====>"+ids);
println("subject"+subject);
sendMessage(usid,ids,subject,content);
}
}*/
var deletesql ="delete from tlk_level_class_student where ITEM_CLASSID='"+docId+"'";
deleteByDSName(sysfunction.DS_TMS,deletesql);
var updatesql="update tlk_grade_card_class_management set ITEM_CLASSSTATUS='5' where ID='"+docId+"'";
updateByDSName(sysfunction.DS_TMS,updatesql);
//println("value=---------"+docId);
}else{
return createAlert("无法取消");
}
})()]]>
true
00
__ApOFiTWdSoVEmTPouiH
simple
1
false
1
zh_CN
rgba(0, 0, 0, 1)
12
rgba(255, 255, 255, 0)
false
04
取消
true
false
true
false
__KYetdoxbuPpKmvkVqyw
01
false
false
false
00
false
false