| | |
| | | |
| | | //只有明细表才需要执行,其他的都只是输出{} |
| | | private String setToolAddForNew(TreeGridDTO dto) { |
| | | if (dto.postStatusAddNew) return "<%=bdMap.toString()%>"; |
| | | if (dto.postStatusAddNew) return "panMain[panIndex].buttonInfoByGrid"; |
| | | switch (dto.winType) { |
| | | case 9: |
| | | case 15: |
| | |
| | | if (dto.conNum == 0) |
| | | return "{}"; |
| | | else |
| | | return "<%=bdMap.toString()%>"; |
| | | return "panMain[panIndex].buttonInfoByGrid"; |
| | | case 18: |
| | | case 38: |
| | | case 19: |
| | |
| | | } |
| | | } |
| | | } |
| | | //try { |
| | | this.getTableName(dto.formID, dto.winType + "|" + dto.conNum, dto);// 增加类型 |
| | | if (dto.table == null) throw new ApplicationException(dto.formID + "--未设置明细表,请在9802设置后重新生成!"); |
| | | if (dto.winType == 1 && ("".equals(dto.table) || dto.table == null)) { |
| | | throw new ApplicationException(dto.formID + ",类型:" + dto.winType + "--未设置主表,请在9801设置后重新生成!"); |
| | | } |
| | | // if (dto.isTable) { |
| | | this.getFirstField(dto); |
| | | // } |
| | | this.getFirstField(dto); |
| | | if (dto.conNum >= 2) |
| | | if (dto.tempGridHeight != 0) dto.gridHeight = dto.tempGridHeight; |
| | | |
| | | gridConfig(root, dto); |
| | | createCoumtHeader(dto); |
| | | //} catch (Exception e) { |
| | | // e.printStackTrace(); |
| | | //} |
| | | } |
| | | |
| | | private synchronized void fillColumnNumTree(int num, TreeGridDTO dto) {//根据最大行值填充列 |
| | |
| | | if (dto.conNum == 1) isDetail = true; |
| | | break; |
| | | } |
| | | return isDetail ? (id.toLowerCase() + "HtmlPostfix=\"<span style='color:white;'> *</span>\"") : " "; |
| | | return isDetail ? (id.toLowerCase() + "HtmlPostfix=\"<span style='color:white;'> *</span>\" ") : " "; |
| | | } |
| | | |
| | | /** |
| | |
| | | StringBuilder id = new StringBuilder(); |
| | | StringBuilder value = new StringBuilder(); |
| | | if (type != 30 && type != 32) { |
| | | if(dto.isSuppressBlankLineForDropDown==0) { |
| | | //只有为0才需要增加空白列 |
| | | id.append("| "); |
| | | value.append("| "); |
| | | } |
| | | if(dto.isSuppressBlankLineForDropDown==0) { |
| | | //只有为0才需要增加空白列 |
| | | id.append("| "); |
| | | value.append("| "); |
| | | } |
| | | } |
| | | try { |
| | | if (sql != null && sql != "" && sql.length() > 0) {//有sql参数 |
| | |
| | | */ |
| | | private String getEnumMenu(TreeGridDTO dto,SqlRowSet rst,String colName){ |
| | | String menu="{Items:[";//{Value:''},{Value:'-',Text:'-'},{Value:'+',Text:'+'} |
| | | StringJoiner joiner=new StringJoiner(","); |
| | | if(dto.isSuppressBlankLineForDropDown==0){ |
| | | //有留白列 |
| | | joiner.add("{Value:'',Text:''}"); |
| | | } |
| | | while (rst.next()) { |
| | | if(colName==null) |
| | | joiner.add("{Value:'"+rst.getString(1)+"',Text:'"+rst.getString(2)+"'}"); |
| | | else |
| | | joiner.add("{Value:'"+rst.getString(colName)+"',Text:'"+rst.getString("dictvalue")+"'}"); |
| | | StringJoiner joiner=new StringJoiner(","); |
| | | if(dto.isSuppressBlankLineForDropDown==0){ |
| | | //有留白列 |
| | | joiner.add("{Value:'',Text:''}"); |
| | | } |
| | | while (rst.next()) { |
| | | if(colName==null) |
| | | joiner.add("{Value:'"+rst.getString(1)+"',Text:'"+rst.getString(2)+"'}"); |
| | | else |
| | | joiner.add("{Value:'"+rst.getString(colName)+"',Text:'"+rst.getString("dictvalue")+"'}"); |
| | | |
| | | } |
| | | rst.beforeFirst(); |
| | | return menu+=joiner.toString()+"]}"; |
| | | } |
| | | rst.beforeFirst(); |
| | | return menu+=joiner.toString()+"]}"; |
| | | } |
| | | private synchronized String setJsName(TreeGridDTO dto) { |
| | | |
| | | return "grid_" + dto.formID +(dto.hasControlLayout?("_"+dto.userCode):"")+ "_" + dto.winType + ".xml"; |
| | | } |
| | | private synchronized String setFileName(TreeGridDTO dto) { |
| | | |
| | | return dto.formID +(dto.hasControlLayout?("_"+dto.userCode):"") + "_grid.jsp"; |
| | | //由于8类型的二三表共用一个页面,且用2表的功能号作为文件名称,所以这里需要特殊处理 |
| | | int formid= dto.formID; |
| | | if(dto.winType==15&&dto.conNum!=0){ |
| | | formid=dto.minID; |
| | | } |
| | | return formid +(dto.hasControlLayout?("_"+dto.userCode):"") + "_grid.jsp"; |
| | | } |
| | | /** |
| | | * 生成页面时需要检查的关键字段名,避免生成格线有问题 |
| | |
| | | boolean uppercase = GridUtils.prossRowSetDataType_Boolean(map, "uppercase");//大写 |
| | | String ValueExp = GridUtils.prossRowSetDataType_String(map, "showFieldValueExpression");//权限控制是否显示该值 |
| | | String editStatus = GridUtils.prossRowSetDataType_String(map, "editStatus");//权限控制是否显示该值 |
| | | if(org.apache.commons.lang3.StringUtils.isNotBlank(editStatus)){ |
| | | if(editStatus.contains("'")){ |
| | | throw new ApplicationException(id+"-editStatus参数值["+editStatus+"】不能存在单引号"); |
| | | } |
| | | } |
| | | boolean oneRec = GridUtils.prossRowSetDataType_Boolean(map, "return_one_record");//是否返回到单记录 |
| | | boolean onlyOne = GridUtils.prossRowSetDataType_Boolean(map, "onlyOne");//只返回单条记录 |
| | | String sqlScript = this.replaceBlank(GridUtils.prossRowSetDataType_String(map, "SqlScript"));// 控件sql |
| | |
| | | } |
| | | } |
| | | |
| | | if (dto.order == 1 && "".equalsIgnoreCase(dto.orderFiled)) {//排序字段 |
| | | if (dto.order == 1) {//排序字段 |
| | | String sybmol=""; |
| | | if(org.apache.commons.lang3.StringUtils.isNotBlank(dto.orderFiled)){ |
| | | sybmol=","; |
| | | } |
| | | if (id.equalsIgnoreCase("doccode")) { |
| | | dto.orderFiled = id + " desc"; |
| | | dto.orderFiled += sybmol+id + " desc"; |
| | | } |
| | | if (id.equalsIgnoreCase("docdate")) { |
| | | dto.orderFiled = dto.orderFiled.length() == 0 ? id + " desc" : "," + id + " desc"; |
| | | dto.orderFiled += sybmol + id + " desc"; |
| | | } |
| | | } else if (dto.order == 2 && "".equalsIgnoreCase(dto.orderFiled)) { |
| | | if (id.equalsIgnoreCase("docitem")) |
| | |
| | | |
| | | } |
| | | //while(dto.gfields.next()); |
| | | if ("".equalsIgnoreCase(dto.orderFiled)) dto.orderFiled = firstID + " desc"; |
| | | if ("".equalsIgnoreCase(dto.primeKey)) dto.orderFiled = firstID + " desc"; |
| | | dto.expr = valExp.length() > 0 ? valExp.substring(0, valExp.length() - 1) : ""; |
| | | dto.cspr = cssExp.length() > 0 ? cssExp.substring(0, cssExp.length() - 1) : ""; |
| | | dto.tipspr = tipsExp.length() > 0 ? tipsExp.substring(0, tipsExp.length() - 1) : ""; |
| | |
| | | } else if (dto.order == 2 && dto.index2 != null && !dto.index2.isEmpty()) {//明细表 |
| | | temp = setSqlOrderBy(dto.index2, " asc"); |
| | | } else { |
| | | if (dto.field.isEmpty()) |
| | | if (!dto.orderFiled.isEmpty()) { |
| | | temp = dto.orderFiled; |
| | | else { |
| | | //处理8类型第三表的排序不是默认的docitm的情况,也就是9801定义有排序 |
| | | if (dto.winType == 15 && dto.order == 2 && org.apache.commons.lang3.StringUtils.isNotBlank(dto.index1)) { |
| | | temp = setSqlOrderBy(dto.index1, " asc"); |
| | | } else { |
| | | temp = setSqlOrderBy(dto.field, dto.order == 1 ? " desc" : " asc"); |
| | | } else { |
| | | if (dto.field.isEmpty()) { |
| | | temp = dto.orderFiled; |
| | | }else { |
| | | //处理8类型第三表的排序不是默认的docitm的情况,也就是9801定义有排序 |
| | | if (dto.winType == 15 && dto.order == 2 && dto.conNum == 2 && org.apache.commons.lang3.StringUtils.isNotBlank(dto.index1)) { |
| | | temp = setSqlOrderBy(dto.index1, " asc"); |
| | | } else { |
| | | temp = setSqlOrderBy(dto.field, dto.order == 1 ? " desc" : " asc"); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | if (dto.muilGrid && i == 0) jsp.append(str).append("\n"); //先保存好模板,以便生成多表时候用 |
| | | dto.conNum = i; |
| | | dto.order = setOrderName(dto); |
| | | dto.orderFiled="";//还原到初始状态 |
| | | this.print(root, dto); |
| | | String strJs = FileUtil.readFile(tempPath + (((dto.gantt && dto.order == 2) || (dto.gantt && dto.winType == 18)) ? "/grid_Gantt.js" : "/grid.js"));//页面js |
| | | String[] ver = dto.verNo.split("/"); |
| | |
| | | .replaceAll("@lang", ver[ver.length - 1])//语言 |
| | | .replaceAll("@foot2", this.replaceBlank(dto.foot2)) |
| | | .replaceAll("@_ycaddnew_@", this.setToolAddForNew(dto))//当前用户是否存在OA审核按钮,其中有为1的则格线需要显示增行按钮 |
| | | .replaceAll("@_isCustomLayout_@", dto.hasControlLayout?(true+""):(false+""))//当前用户是否存在OA审核按钮,其中有为1的则格线需要显示增行按钮 |
| | | //.replaceAll("@_attachment_server_@", domain==null?"":domain)//附件服务器地址 |
| | | .replaceAll("@picFild", this.replaceBlank("&picFild=" + dto.picFild)) |
| | | .replaceAll("@TBCols", "&tbCols=" + EncodeUtil.base64Encode(this.replaceBlank(dto.totalCols)))//统计列 |
| | |
| | | .replaceAll("@layout", this.setJsName(dto))//js文件名称 |
| | | .replaceAll("@hasGrid", hasGrid)//js文件名称 |
| | | .replaceAll("@isTree", (dto.mainCol == null || "".equalsIgnoreCase(dto.mainCol)) ? "" : "&isTree=1") |
| | | .replaceAll("@winType", dto.winType + "@p@" + i)//表的顺序 0表示读取主表 1表示读取从表 |
| | | .replaceAll("@winType", dto.winType + "@p@" + (dto.winType==19?1:i))//表的顺序 0表示读取主表 1表示读取从表,19类型特定为1 |
| | | .replaceAll("@id", dto.formID + "")//功能号 |
| | | .replaceAll("@DealAfterDocSave", ddsave)//保存时执行 |
| | | .replaceAll("@CancelProc", "&cancelProc=" + this.replaceBlank(EncodeUtil.base64Encode(dto.cancelProc)) + "&cancelisSave=" + dto.cancelisSave + "&isExchangeDataWithHost=" + dto.isExchangeDataWithHost)//取消确认 |