- var user = getWebUser();
- var domain = getDomainid();
- var id1 = new Packages.cn.myapps.util.sequence.Sequence();
- var application = getApplication();
- var id=getItemValueAsString("教学大纲ID");
- var docid=getCurrentDocument().getId();
- var sql="select * from tlk_班级教学大纲管理 where id='"+docid+"'";
- var datas=queryByDSName("dt",sql);
- if(id!=null&&id!=""){
- if(datas!=null){
- for(var iterator = datas.iterator();iterator.hasNext();){
- var map1 = iterator.next();//取值
- var jiaoxueid= map1.get("ITEM_教学大纲ID");
- println("jiaoxueid==="+jiaoxueid);
- if(id!=jiaoxueid){
- println("不一样");
- var sql1="delete from [dbo].[TLK_班级教学计划子表] WHERE PARENT='"+docid+"'";
- deleteByDSName("dt",sql1);//先删除原有数据
- var sql="SELECT * FROM [dbo].[TLK_教学大纲子表] WHERE PARENT='"+id+"'";
- datas=queryByDSName("dt",sql);
- if(datas!=null){
- for(var iterator1 = datas.iterator();iterator1.hasNext();){
- var map1 = iterator1.next();//取值
- var num= map1.get("ITEM_课程号");
- var model= map1.get("ITEM_课程模块");
- var name= map1.get("ITEM_课程名称");
- var score= map1.get("ITEM_课程学分");
- var stylename= map1.get("ITEM_课程类型名称");
- var keshi= map1.get("ITEM_课时");
- var content= map1.get("ITEM_核心内容");
- var xingshi= map1.get("ITEM_上课形式");
- var fangshi= map1.get("ITEM_考核方式");
- var fuzeren= map1.get("ITEM_课程负责人");
- var mubiao= map1.get("ITEM_课程计划成果与目标");
- println("不一样name="+name);
- var process = getDocumentProcess();
- var formProcess = getFormProcess();
- var subform = formProcess.doView("11e3-8253-a1da4733-a7c9-c9086d031ad6");
- var budget = process.doNew(subform,getWebUser(),createParamsTable());
- budget.setId(id1.getSequence());
- budget.setFormname("班级教学计划子表");
- budget.setFormid("11e3-8253-a1da4733-a7c9-c9086d031ad6");
- budget.setIstmp(false);
- budget.setParent(docid);
- budget.setApplicationid(application);
- budget.setAuthor(user.getId());
- budget.setCreated(getToday());
- budget.setDomainid(domain);
- budget.addStringItem("课程号",num);
- budget.addStringItem("课程模块",model);
- budget.addStringItem("课程名称",name);
- budget.addStringItem("课程学分",score);
- budget.addStringItem("课程类型名称",stylename);
- budget.addStringItem("课时",keshi);
- budget.addStringItem("核心内容",content);
- budget.addStringItem("上课形式",xingshi);
- budget.addStringItem("考核方式",fangshi);
- budget.addStringItem("课程负责人",fuzeren);
- budget.addStringItem("课程计划成果与目标",mubiao);
- //budget.addStringItem("OJT编号",num);
- // budget.addDateItem("活动时间",time);
- process.doCreate(budget);
- }
- }
-
- }
- }
- }
- }
复制代码 |