《myapps使用总结》word版.docx

1代码管理控制（1）SelectLib函数库内容function getDocItemValueAsOpts(formName,valueFieldName,keyFieldName,isDefaultEmpey)var opts = createOptions();if(isDefaultEmpey) opts.add(全部,);var dql = $formname=+formName+;var process = getDocProcess(getApplication();var docs = queryByDQL(dql);for (var iter = docs.iterator(); iter.hasNext();) var doc = iter.next();opts.add(doc.getItemValueAsString(valueFieldName),doc.getItemValueAsString(keyFieldName); return opts;function getDocItemValueByKey(formName,keyFieldName,keyFieldValue,valueFieldName)var value = ;var dql = $formname=+formName+ and +keyFieldName+=+keyFieldValue+;var docs = queryByDQL(dql);for (var iter = docs.iterator(); iter.hasNext();) var doc = iter.next();value = doc.getItemValueAsString(valueFieldName);break;return value;function getDocItemValueAsOptsByKey(formName,keyFieldName,keyFieldValue,valueFieldName,valueFieldKey,isDefaultEmpey) var opts = createOptions();if(isDefaultEmpey) opts.add(全部,);var dql = $formname=+formName+ and +keyFieldName+=+keyFieldValue+;var docs = queryByDQL(dql);for (var iter = docs.iterator(); iter.hasNext();) var doc = iter.next();opts.add(doc.getItemValueAsString(valueFieldName),doc.getItemValueAsString(valueFieldKey);return opts;（2）被动态获取的表单省份key省份value城市key城市value上级省份所属省份#include SelectLib;var opts = getDocItemValueAsOpts($formname=省份,省份Key,省份Value,true);opts;（3）动态获取的表单A:main_sort(名称)刷新+手机#include SelectLib;var opts = getDocItemValueAsOpts($formname=省份,省份Key,省份Value,true);opts;B: sub_sort(名称)重计算+手机#include SelectLib;var shengfen= getItemValue(main_sort);var opts = getDocItemValueAsOptsByKey($formname=城市,上级省份,shengfen,城市key,城市value,false);opts;2隐藏某个操作按钮对某个身份可见1 获取角色idvar roleid= getRoleIdByName(销售总监); roleid;2只读或者隐藏脚本var user = getWebUser();/获取当前登陆用户信息var rolelist = user.getRoles();/获取角色列表var roles = ;var rtn = true;/遍历出所有角色名称for(var iter = rolelist.iterator();iter.hasNext();) var role = iter.next(); roles += role.getId();/*行政专员、行政部行政人员和行政部部长可修改*/if(roles.indexOf(11e0-6bc4-53705e7c-bfa7-b9919a52746f)=0 | roles.indexOf(11e0-777c-67c99915-bb46-b3225d75db85)=0 | roles.indexOf(11e0-777c-855dc5ab-bb46-b3225d75db85)=0)rtn=false;rtn;3判断字段不为空并且不重复（1）var value=getItemValueAsString(tname);var msg = +value+ 词条名称已经存在，请创建其它词条哦，亲。;checkFieldUnique(tname, value, msg);/检验词条是否已存在（2）调用函数库checkEmptyfunction checkEmpty(fieldName,desc) var doc = $CURRDOC.getCurrDoc();var value = doc.getItemValueAsString(fieldName);var retvar = ;if(value=null | value.trim().length()+retvar);return retvar;/add by taoyuan4只许文档的创建人修改此文档var rtn;var webUser = getWebUser(); /返回当前登录用户对象rtn = webUser.getName();var doc = $CURRDOC.getCurrDoc();var value = doc.getItemValueAsString(pname);if(value=null | value.trim().length()=0) value = getWebUser().getName();if(rtn.equals(value)false;else true;/将创建人与当前登录人对比5浏览文档的人 与创建的人不发生互换var rtn;var doc = $CURRDOC.getCurrDoc();var value = doc.getItemValueAsString(zuozhe);if(value=null | value.trim().length()0) for (var iter = depts.iterator();iter.hasNext();) var dept = iter.next(); depname += +dept.getId()+,;/获取部门名称 depname+=; var sql=select * from tlk_fm_add where item_bumen in (+depname+);/比较获取的部门名称是否相同sql;（2）部门选择框或者var opts=createOptions();var deptUnderList=getDepartmentByLevel(1);opts.add(,);for(var iter=deptUnderList.iterator();iter.hasNext();) var deptUnder=iter.next(); var deptName=deptUnder.getName(); opts.add(deptName, deptName);opts;7查询两个var sszlb = getItemValue(classification);var zlb = getItemValue(classification1);var b = select *from tlk_fm_add where item_classification like %+sszlb +%and item_classification1 like %+zlb+%;b;var user = getWebUser();/获取登录人var depts = user.getDepartments();/获取登录人的部门属性集合var depname = ;/设置部门名称为空if (depts!=null & depts.size()0) for (var iter = depts.iterator();iter.hasNext();) var dept = iter.next(); depname += +dept.getId()+,;/获取部门名称 depname+=; var sszlb = getItemValue(classification);var zlb = getItemValue(classification1);var b = select *from tlk_fm_add where item_classification like %+sszlb +%and item_classification1 like %+zlb+% and item_bumen in (+depname+)and statelabel = 发布;b;/addbytaoyuan8时间任务var dp = getDocProcess(11e1-2627-04f265b5-a7f1-394db9c69ce7);/11e1-2627-04f265b5-a7f1-394db9c69ce7当前表单所在的软件ID，通过在表单中添加isID获取var sql = SELECT * FROM tlk_fm_add WHERE (TO_DAYS(ITEM_ENDDATE) - TO_DAYS(now() 0)qidian;else0;var applicationId=getApplication();applicationId;9用户查询问题var user = getWebUser();/获取登录人var depts = user.getDepartments();/获取登录人的部门属性集合var depname = ;/设置部门名称为空if (depts!=null & depts.size()0) for (var iter = depts.iterator();iter.hasNext();) var dept = iter.next(); depname += +dept.getId()+,;/获取部门名称 depname+=; var sszlb = getItemValue(classification);var zlb = getItemValue(classification1);var b = select id,formid,domainid,item_name,ITEM_NUMBER,item_email, statelabel,item_classification,item_ask from tlk_fm_add where item_classification like %+sszlb +%and item_classification1 like %+zlb+% and item_bumen in (+depname+)and statelabel = 发布 and item_isSend = 0;var c = select id,formid,domainid,item_name,ITEM_NUMBER,item_email,statelabel,item_classification,item_ask from tlk_fm_useradd where item_classification like %+sszlb +%and item_classification1 like %+zlb+% and item_bumen in (+depname+)and statelabel = 发布 and item_isSend = 0;var sql ;sql = b+ UNION +c;sql;/addbytaoyuan10 issend脚本var qidian = getItemValue(isSend);if(qidian!=null & qidian.trim().length()0)var user = getWebUser();var date = getItemValue(endate);var rolelist = user.getRoles();var roles = ;var rtn = true;for(var iter = rolelist.iterator();iter.hasNext();) var role = iter.next(); roles += role.getId();if(roles.indexOf(11e1-2629-21f62776-a7f1-394db9c69ce7)=0) rtn=false;elsertn;if(rtn=true)date = getToday(); elsedate;if(diffDays(getToday(),getItemValueAsDate(enddate) 0) 0;else1;else0;11级联删除问题var docid = getParameterAsText(_selects);var b = select formid,domainid, item_classification from tlk_fm_add where item_classification like %+ docid +%;var c= select formid,domainid,i