随笔分类 - 一些常见的问题
摘要：1.String projectids=""; 2. if (StringHelper.isNotEmpty(gatheringinfo.getCol1()) && gatheringinfo.getCol1().length()>0){ projectids+=gatheringinfo.getC
阅读全文
摘要：SELECT STUFF( (SELECT ',' + id FROM assets where id in('4028e481467e27a4014683c552db1794','4028e481467e27a4014683c6ff7717d4') FOR XML PATH('')), 1, 1,
阅读全文
摘要：问题 解决方法 点击事件需要重新加载一下iframe
阅读全文
摘要：1.原本图 2.解决方法 select regexp_substr(a.numbers,'[^,]+',1,level) as numbers from (select distinct id,numbers from project where isdelete=0 and isactive=1
阅读全文
摘要：select * from docbase where isdelete=0update docbase set subject=STUFF(subject,23,4,'****') where isdelete=0 update docbase set subject=STUFF(subject,
阅读全文
摘要：update formlayoutfield set formula='''$currentuser$''=field001 or ((select orgid from humres where id=''$currentuser$'')=''402880ec5c99d3bd015c9a17bba
阅读全文
摘要：1.通过一个中间的jsp进行json查询传递 <%@ page import="java.util.Map" %> <%@ page import="java.util.ArrayList" %> <%@ page import="java.util.List" %> <%@ page import
阅读全文
摘要：可以使用 Set 集合来去重，然后再将集合中的元素转换为字符串。 String str = "a,b,c,c,d,e,e,f"; String[] arr = str.split(","); Set<String> set = new HashSet<String>(Arrays.asList(ar
阅读全文
摘要：1.布局全部弄好显示 2.给首布局添加明细有数据则显示的jq控制 $(function () { $("#oTable40282aa187314b1d0187318ac6a9000d").hide(); //部门负责人子议题审议没有历史隐藏 var firstblerows = $("#oTable
阅读全文
摘要：<script> function onSubmitPlus(issave) { var projectid=$("#field_40282aa18708cb1301871197556b011b").val(); var projectmgrdep=$("#field_40282aa18708cb1
阅读全文
摘要：//注册地址var province = SQL("select province from project where code='"+code+"' and isdelete=0 order by indate limit 1 ");$("#field_2c923daf70a540290170a
阅读全文
摘要：update project pp set extdatefield3=(select a.finisheddate from (select p.id,w.finisheddate from project p INNER JOIN pw_proposal pw on pw.projectid=p
阅读全文
摘要：<script> //javascript:location.href='/ServiceAction/com.velcro.workflow.workflow.servlet.WfViewAction?workflowid=e4e48163822a84e40182a5c82505186a&view
阅读全文
摘要：//为子表增加加行接口函数 function formServiceInteface_onAddRow(_formid,len){ if(typeof onAddRow == 'function'){ try{ onAddRow(_formid,len); }catch(e){ alert(e);
阅读全文
摘要：table{ width: 100%; } table td, table th { font-size: 14px; border: 1px solid #cad9ea; height: 45px; text-align: center; } .direct-search{ margin-top:
阅读全文
摘要：处理前 解决方法给table表格添加 font-size: 0;属性就可以解决了
阅读全文
摘要：<%! public String dou(double d) { DecimalFormat df = new DecimalFormat(); df.setMaximumFractionDigits(2);//这里是小数位 String format = df.format(d); String
阅读全文
摘要：<%@ page import="com.velcro.base.Globals" %> <%@page import="com.velcro.base.label.service.LabelService" %> <%@page import="com.velcro.kernel.base.IPa
阅读全文
摘要：1.通过在职位天数和职位等级，得出年总天数 1.jsp <tr> <th scope="col" width="1%">Formula</th> <th scope="col" width="1%">Service Year</th> <th width="12%">JobGrade</th> <t
阅读全文
