本帖最后由 six 于 2017-6-12 10:22 编辑
println("开开试试进来了");
var sub = getCurrentDocument(); //获取当前文档
var process = new Packages.cn.myapps.core.dynaform.document.ejb.DocumentProcessBean(getApplication());
var params = new Packages.cn.myapps.base.action.ParamsTable();
var user = getWebUser();
var doc = new Packages.cn.myapps.core.dynaform.document.ejb.Document(); //实例化销售单文档对象
var today = getCurDate("yyyy-MM-dd HH:mm:ss");
var day = parseDate(today,"yyyy-MM-dd HH:mm:ss");
//插入>>>>>>
var sql = "SELECT * FROM tlk_常规事项设定 where ITEM_常规事项类型 = '11e7-4b33-e241fc98-bc73-19bd9752c0ba'";
//println("我要拿的我的数据sql"+sql_sprkmx);
var applicationid="11e6-a696-c2cf4f58-9194-b7ed36aa4047";
var domainid="11e1-81e2-37f74759-9124-47aada6b7467";
var process = getDocProcess(applicationid);
var datas_kc=process.queryBySQL(sql,domainid).datas;
if(datas_kc!=null && datas_kc.size()>0)
{
for(var iter_kc = datas_kc.iterator();iter_kc.hasNext();)
{
var docxj_kc = iter_kc.next();
if(docxj_kc!=null)
{
println("开开试试进来了插入");
doc.setFormid('11e7-3cfd-c28f685f-8572-9b59b1f71410');
doc.setFormname('资源管理软件/目标管理系统/目标管理系统模块/日目标');
doc.setAuthor(user.getId());
doc.setIstmp(false);
doc.setApplicationid(getApplication());
doc.setDomainid(user.getDomainid());
var uuidd = new Packages.cn.myapps.util.sequence.Sequence();
var uuid = uuidd.getSequence();
doc.setId(uuid);
doc.addStringItem("目标来源",'常规事项');
doc.addStringItem("日目标",docxj_kc.getItemValueAsString("常规事项名称"));
doc.addStringItem("目标类型",'11e7-404f-728c9812-aaac-418e3d9e5dd2');
doc.addStringItem("日目标状态",'进行中');
doc.addDateItem("计划时间",day);
//println("本单出库主表单"+uuid);
process.doCreate(doc);
}
}
}
println("开开试试进来了结束");
|