今天学习获取数据
在摩尔云平台找到要修改的主视图,然后点击操作功能,点击新增,直接输入名字获取数据,然后,显示顺序15,显示是,点击确定,然后就是自定义类上面输入创建的类名,点击源码,进去后将代码复制到eclipse,去创建一个类,在复制,然后就是去修改代码,
package com.more.test.testmodule;import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;import com.more.fw.core.base.core.action.ModelAction;
import com.more.fw.core.common.method.CommMethod;
import com.more.fw.core.common.method.Constants;
import com.more.fw.core.common.method.StringUtils;
import com.more.fw.core.dbo.model.service.ModelService;
import com.more.fw.core.dbo.model.service.impl.base.FuncService;
import com.more.mes.common.CommonMethod;
import com.more.mes.common.model.QueryParamModel;/*** 要根据对应的视图模型/基础信息:视图公用类的名称来替换继承类FuncService**/
public class GetShareResultInfo implements FuncService {private Log log = LogFactory.getLog(this.getClass());@Overridepublic String exeFunc(ModelAction modelAction, ModelService modelService) {HttpServletRequest request = modelAction.getRequest();modelAction.setFormId("80e7dbef360c407d8c7c81dbf6cbed37");String formId = "80e7dbef360c407d8c7c81dbf6cbed37";String dataAuth = String.valueOf(modelAction.getRequest().getSession().getAttribute("mcDataAuth"));String subSortCol = request.getParameter("subSortCol");String subSortColOrder = request.getParameter("SORT_DOC_NO");//String isFirstLoad = request.getParameter("isFirstLoad");// 判断是否是首次加载Map<String, String> map = new HashMap<String, String>();String sqlWhere = "";String searchSql = "";String orderBy = "";String statusSqlWhere = "";List<Map> dataList = new ArrayList<>();String sql = "select T1.CREATE_USER,T1.DEPT_ID,T1.ID,T1.CREATE_TIME,T1.EDIT_USER,T1.EDIT_TIME,T1.DATA_AUTH,T1.DATA_AUTH AS DATA_AUTH_ID,T1.DOC_NO,T1.ITEM_NAME,T1.ITEM_CODE,T1.ITEM_SPEC,T1.PLAN_QTY,T1.MEMO from T_WMS_TABLE_TEST T1" + " WHERE 1 = 1" + " AND T1.DATA_AUTH = :DATA_AUTH ";List<QueryParamModel> list = CommonMethod.getQueryParam(request);for (QueryParamModel queryParamModel : list) {String value = queryParamModel.getValue();String keyName = queryParamModel.getName();if (queryParamModel.getName().equals("ITEM_NAME") && StringUtils.isNotBlank(value)) {searchSql += " AND T1.ITEM_NAME" + queryParamModel.getQueryValue();} else if (queryParamModel.getName().equals("ITEM_CODE") && StringUtils.isNotBlank(value)) {searchSql += " AND T1.ITEM_CODE" + queryParamModel.getQueryValue();} else {if (StringUtils.isNotBlank(value)) {searchSql += " AND T1." + queryParamModel.getName() + queryParamModel.getQueryValue();}}}map.put("DATA_AUTH", dataAuth);// 表单配置默认排序orderBy = StringUtils.isNotBlank(CommonMethod.getSortString(modelAction.getFormId(), "T1"))? " ORDER BY " + CommonMethod.getSortString(modelAction.getFormId(), "T1"): "";// 点击排序if (StringUtils.isNotBlank(subSortCol)) {orderBy = " ORDER BY T1." + subSortCol + (subSortColOrder.equals("2") ? " desc" : " asc");}dataList = modelService.listSql(sql + sqlWhere + searchSql, modelAction.getPage(), map, orderBy, null);modelAction.getAjaxDataMap(modelAction.getFormId(), modelAction.getPage(), dataList);return modelAction.outJson(CommMethod.bean2Json(modelAction.getViewAjaxMap()),Constants.CHARACTER_ENCODING_UTF_8);}
}
下面的代码是获取数据的固定代码 ,除了String sql 那串代码,他是需要你要查询的表,用sql语句写查询语句找到对应的数据,dataAuth是组织机构,利用map的键值对方法去使用
HttpServletRequest request = modelAction.getRequest();modelAction.setFormId("80e7dbef360c407d8c7c81dbf6cbed37");String formId = "80e7dbef360c407d8c7c81dbf6cbed37";String dataAuth = String.valueOf(modelAction.getRequest().getSession().getAttribute("mcDataAuth"));String subSortCol = request.getParameter("subSortCol");String subSortColOrder = request.getParameter("SORT_DOC_NO");//String isFirstLoad = request.getParameter("isFirstLoad");// 判断是否是首次加载
Map<String, String> map = new HashMap<String, String>();String sqlWhere = "";String searchSql = "";String orderBy = "";String statusSqlWhere = "";
List<Map> dataList = new ArrayList<>();String sql = "select T1.CREATE_USER,T1.DEPT_ID,T1.ID,T1.CREATE_TIME,T1.EDIT_USER,T1.EDIT_TIME,T1.DATA_AUTH,T1.DATA_AUTH AS DATA_AUTH_ID,T1.DOC_NO,T1.ITEM_NAME,T1.ITEM_CODE,T1.ITEM_SPEC,T1.PLAN_QTY,T1.MEMO from T_WMS_TABLE_TEST T1" + " WHERE 1 = 1" + " AND T1.DATA_AUTH = :DATA_AUTH ";
下面的也是固定方法
package com.more.test.testmodule;import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;import com.more.fw.core.base.core.action.ModelAction;
import com.more.fw.core.common.method.CommMethod;
import com.more.fw.core.common.method.Constants;
import com.more.fw.core.common.method.StringUtils;
import com.more.fw.core.dbo.model.service.ModelService;
import com.more.fw.core.dbo.model.service.impl.base.FuncService;
import com.more.mes.common.CommonMethod;
import com.more.mes.common.model.QueryParamModel;/*** 要根据对应的视图模型/基础信息:视图公用类的名称来替换继承类FuncService**/
public class GetShareResultInfo implements FuncService {private Log log = LogFactory.getLog(this.getClass());@Overridepublic String exeFunc(ModelAction modelAction, ModelService modelService) {HttpServletRequest request = modelAction.getRequest();modelAction.setFormId("80e7dbef360c407d8c7c81dbf6cbed37");String formId = "80e7dbef360c407d8c7c81dbf6cbed37";String dataAuth = String.valueOf(modelAction.getRequest().getSession().getAttribute("mcDataAuth"));String subSortCol = request.getParameter("subSortCol");String subSortColOrder = request.getParameter("SORT_DOC_NO");//String isFirstLoad = request.getParameter("isFirstLoad");// 判断是否是首次加载Map<String, String> map = new HashMap<String, String>();String sqlWhere = "";String searchSql = "";String orderBy = "";String statusSqlWhere = "";List<Map> dataList = new ArrayList<>();String sql = "select T1.CREATE_USER,T1.DEPT_ID,T1.ID,T1.CREATE_TIME,T1.EDIT_USER,T1.EDIT_TIME,T1.DATA_AUTH,T1.DATA_AUTH AS DATA_AUTH_ID,T1.DOC_NO,T1.ITEM_NAME,T1.ITEM_CODE,T1.ITEM_SPEC,T1.PLAN_QTY,T1.MEMO from T_WMS_TABLE_TEST T1" + " WHERE 1 = 1" + " AND T1.DATA_AUTH = :DATA_AUTH ";List<QueryParamModel> list = CommonMethod.getQueryParam(request);for (QueryParamModel queryParamModel : list) {String value = queryParamModel.getValue();String keyName = queryParamModel.getName();if (queryParamModel.getName().equals("ITEM_NAME") && StringUtils.isNotBlank(value)) {searchSql += " AND T1.ITEM_NAME" + queryParamModel.getQueryValue();} else if (queryParamModel.getName().equals("ITEM_CODE") && StringUtils.isNotBlank(value)) {searchSql += " AND T1.ITEM_CODE" + queryParamModel.getQueryValue();} else {if (StringUtils.isNotBlank(value)) {searchSql += " AND T1." + queryParamModel.getName() + queryParamModel.getQueryValue();}}}map.put("DATA_AUTH", dataAuth);// 表单配置默认排序orderBy = StringUtils.isNotBlank(CommonMethod.getSortString(modelAction.getFormId(), "T1"))? " ORDER BY " + CommonMethod.getSortString(modelAction.getFormId(), "T1"): "";// 点击排序if (StringUtils.isNotBlank(subSortCol)) {orderBy = " ORDER BY T1." + subSortCol + (subSortColOrder.equals("2") ? " desc" : " asc");}dataList = modelService.listSql(sql + sqlWhere + searchSql, modelAction.getPage(), map, orderBy, null);modelAction.getAjaxDataMap(modelAction.getFormId(), modelAction.getPage(), dataList);return modelAction.outJson(CommMethod.bean2Json(modelAction.getViewAjaxMap()),Constants.CHARACTER_ENCODING_UTF_8);}
}
然后就是前端页面,
<%-- 平台公用头文件 --%>
<%@ page language="java" errorPage="/plf/error.jsp" pageEncoding="UTF-8" contentType="text/html;charset=UTF-8" deferredSyntaxAllowedAsLiteral="true" %>
<%@page import="com.more.fw.core.dbo.model.dao.PaginationImpl"%>
<%@ include file="/plf/common/pub_tag.jsp"%>
<%@page import="com.more.fw.core.staticresource.PlfStaticRes"%>
<%-- 异步查询列表,页面加载前 --%>
<jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="beforePageLoad" />
</jsp:include>
<head><title><dict:lang value="测试操作" /></title><%-- 平台公用meta --%><%@ include file="/plf/common/pub_meta.jsp"%><%-- 平台公用head,包括公用IMG、CSS、JS资源文件 --%><jsp:include page="/plf/common/fp/pub_head_fp.jsp"><jsp:param name="popDivWinFp" value="1" /><jsp:param name="datePicker" value="1" /><jsp:param name="chosen" value="1" /><jsp:param name="msData" value="1" /><jsp:param name="scroll" value="1" /><jsp:param name="jqueryprint" value="1" /><jsp:param name="queryViewType" value="1" /></jsp:include><jsp:include page="/plf/common/pub_dom.jsp"><jsp:param name="needValidate" value="1" /></jsp:include><%-- 业务模型公用JS页面 --%><%@ include file="/plf/page/common/buss/bussCommJs.jsp"%><%-- 公用列表JS页面 --%><%@ include file="/plf/page/common/buss/listCommJs.jsp"%><bu:header formId ="80e7dbef360c407d8c7c81dbf6cbed37"/><%-- 在head里面要插入平台的代码 --%><jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="inHead" /></jsp:include><%-- 产品静态资源 --%><style>div.customized-rmenu-container {position:absolute;visibility:hidden;top:0;text-align: center;padding: 2px;min-width: 80px;z-index: 100000;}div.customized-rmenu-container dl{top:0;padding: 0;border: 1px solid #d2d2d2;background-color: #fff;border-radius: 2px;box-shadow: 0 2px 4px rgba(0,0,0,.12);box-sizing: border-box;}div.customized-rmenu-container dl dd{padding: 0px 6px;cursor: pointer;line-height: 30px;}div.customized-rmenu-container dl dd:hover{background-color:#ccc;color:white;}div.customized-rmenu-container dl hr{margin:0px;background-color: #ccc;height: 1px;border: none;}</style>
</head>
<body>
<div id="rMenu" class="customized-rmenu-container"></div>
<div id="childTableRMenu" class="customized-rmenu-container"><dl><dd onclick="showChildTableCustomizedColumns()"><dict:lang value='调整列' /></dd></dl>
</div>
<div class="content-in"><div class="dlist"><div class="hd query-hd"><bu:func2 viewId="be2de936cc174f569c1c3b8393f5aa0f" /></div><div class="bd query-bd"><div class="search-box"><form id="searchForm" name="searchForm" action="${path}buss/bussModel.ms" method="post"><%-- 视图页面数据查询区域 --%><jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="searchForm" /></jsp:include><div class="query-condition"><bu:newsearch deal_mark="1" viewId="be2de936cc174f569c1c3b8393f5aa0f" /></div></form><a href="javascript:void(0);" class="more"></a></div><form id="listForm" name="listForm" action="${path}buss/bussModel.ms?<s:property value='%{@com.more.fw.core.common.method.ConstantsMc@FUNC_CODE}' />=<s:property value='%{FUNC_CODE}' />" method="post"><%-- 视图页面数据表格区域 --%><jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="listForm" /></jsp:include><%-- 视图页面表格区域平台默认的数据项 --%><input type="hidden" name="formPage80e7dbef360c407d8c7c81dbf6cbed37" id="formPage80e7dbef360c407d8c7c81dbf6cbed37" value="${formPage80e7dbef360c407d8c7c81dbf6cbed37}"/><input type="hidden" name="formId" id="formId1" value='80e7dbef360c407d8c7c81dbf6cbed37'/><input type="hidden" id="subRelColIds" name="subRelColIds" value='null'/><input type="hidden" id="subFormIds" name="subFormIds" value='null'/><div class="panel-ajax datagrid datagrid-div1" id="80e7dbef360c407d8c7c81dbf6cbed37"><div class="datagrid-div2 datagrid-div6 datagrid-view-ajax" id="datagrid-view-ajax80e7dbef360c407d8c7c81dbf6cbed37" style=""><div class="datagrid-header"><div class="datagrid-header-inner" id="datagrid-header-inner80e7dbef360c407d8c7c81dbf6cbed37"><bu:table cssClass="datagrid-htable fixedTable datagrid-div6 datagrid-htable-kz" id="datagrid-htable80e7dbef360c407d8c7c81dbf6cbed37"><s:set name="_$type" value="'view'" /><tbody class="isParentsTitle"><bu:tr cssClass="datagrid-header-row datagrid-title-ajax" id="datagrid-title-ajax"><td class="datagrid-cell" name="noprintset_SEQ" style="width:30px; text-align:center;" ><bu:thSeq formId="80e7dbef360c407d8c7c81dbf6cbed37" i18n="1"/></td><td class="datagrid-cell no-print" style="width:30px; text-align:center"><span><input type="checkbox" id="selectAll_80e7dbef360c407d8c7c81dbf6cbed37" onclick="_selectAjaxTableAllData(this,'80e7dbef360c407d8c7c81dbf6cbed37')" style="cursor: pointer;"title="全选"/></span></td><td name="noprintset_DOC_NO" class="datagrid-cell"><bu:uitn colNo="DOC_NO" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td><td name="noprintset_ITEM_NAME" class="datagrid-cell"><bu:uitn colNo="ITEM_NAME" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td><td name="noprintset_ITEM_CODE" class="datagrid-cell"><bu:uitn colNo="ITEM_CODE" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td><td name="noprintset_ITEM_SPEC" class="datagrid-cell"><bu:uitn colNo="ITEM_SPEC" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td><td name="noprintset_PLAN_QTY" class="datagrid-cell"><bu:uitn colNo="PLAN_QTY" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td><td name="noprintset_MEMO" class="datagrid-cell"><bu:uitn colNo="MEMO" formId="80e7dbef360c407d8c7c81dbf6cbed37" /></td></bu:tr></tbody></bu:table></div></div><div class="datagrid-body datagrid-div3 datagrid-body-ajax" id="tableDiv80e7dbef360c407d8c7c81dbf6cbed37" onscroll="ajaxTableScroll(this,'80e7dbef360c407d8c7c81dbf6cbed37')"><table class="datagrid-btable fixedTable dblClick" id="datagrid-btable-ajax80e7dbef360c407d8c7c81dbf6cbed37"><tbody id="tbody_80e7dbef360c407d8c7c81dbf6cbed37" class="isParents"></tbody></table></div></div></div><div id="printset_div" style="background-color: white;margin-top: 50px;display:none;"><div class="hd" style="background-color: #f6f5f7;height: 35px;"><div class="optn" style="top:45px;right:30px;"><button type="button" onclick="printset_17('80e7dbef360c407d8c7c81dbf6cbed37','1');"><dict:lang value="打印" /></button></div></div><div style="height: 390px;overflow:auto;border-top: 1px solid #eaeaea;"><table id="printset_tab" class="basic-table" style="text-align: center;margin-top:10px;"><tr><td style="width: 100px;text-align: right;"><dict:lang value="列字段" /></td><td style="padding-left: 5px;"><dict:lang value="是否打印" /></td><td style="padding-left: 5px;"><dict:lang value="打印列宽" /></td></tr><tr><td style="width: 100px;text-align: right;"><span><dict:lang value="序号" /></span></td><td style="padding-left: 5px;"><input type="checkbox" name="SEQ" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="SEQ" value="30" title_name="序号" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>单据号</span></td><td style="padding-left: 5px;"><input type="checkbox" name="DOC_NO" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="DOC_NO" value="" title_name="单据号" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>物料名称</span></td><td style="padding-left: 5px;"><input type="checkbox" name="ITEM_NAME" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="ITEM_NAME" value="" title_name="物料名称" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>物料料号</span></td><td style="padding-left: 5px;"><input type="checkbox" name="ITEM_CODE" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="ITEM_CODE" value="" title_name="物料料号" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>物料规格</span></td><td style="padding-left: 5px;"><input type="checkbox" name="ITEM_SPEC" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="ITEM_SPEC" value="" title_name="物料规格" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>计划数量</span></td><td style="padding-left: 5px;"><input type="checkbox" name="PLAN_QTY" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="PLAN_QTY" value="" title_name="计划数量" />px</td></tr><tr><td style="width: 100px;text-align: right;"><span>备注</span></td><td style="padding-left: 5px;"><input type="checkbox" name="MEMO" value="1" checked="checked" /></td><td style="padding-left: 5px;"><input type="text" name="MEMO" value="" title_name="备注" />px</td></tr></table></div></div><c:if test="${formPage80e7dbef360c407d8c7c81dbf6cbed37==1}"><div class="center" data-type="80e7dbef360c407d8c7c81dbf6cbed37" ><s:include value="/plf/page/fp/paginationPopMultAx.jsp?listDataFn=listAjaxTable&formId=80e7dbef360c407d8c7c81dbf6cbed37&showLoading=0" /></div></c:if><input type="hidden" name="tableCount" id="tableCount" value='1' /></form></div></div>
</div><bu:submit viewId="be2de936cc174f569c1c3b8393f5aa0f" />
<%-- 平台预留在JS加载前执行的代码片段 --%>
<jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="beforeJsLoad" />
</jsp:include>
<bu:script viewId="be2de936cc174f569c1c3b8393f5aa0f" />
<%-- 主列表JS,如查询方法 --%>
<jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="jsLoading" />
</jsp:include>
<%-- 生成异步表格 --%>
<script>/*更新表头信息、打印信息并查询列表数据*formId:表单id*isAbandonedSearch:是否禁止查询数据,不传则默认查询*callbackFunc:表头、打印信息页面重组完成回调函数*/function updateColumnsData(formId,isAbandonedSearch,callbackFunc){mcUpdateColumnsData(formId,isAbandonedSearch,callbackFunc);}<%--生成异步表格-自定义显示列--%>/*生成异步表格-自定义显示列*ms:后台接口返回的数据*formId:表单id*tableColumnsData:列数据对象 {leftList:左侧固定列数据, showList:主/右侧列数据}*callbackFunc:数据页面重组完成回调函数*/function createTable2(ms,formId,tableColumnsData,callbackFunc){mcCreateTable2(ms,formId,tableColumnsData,callbackFunc);}<%--生成异步表格--%>function createTableModel(ms,formId){var arrHtml = [];var arrLeftHtml = [];var uiTxt = ms.uiTxt(formId)==null?[]:ms.uiTxt(formId);var trClass = ms.trClass(formId);var trStyle = ms.trStyle(formId);var trEvent = ms.trEvent(formId);var colNo = $("#relColVals").val();if(formId=='80e7dbef360c407d8c7c81dbf6cbed37'){<%--FM-T_WMS_PRODUCTION_TEST--%>$.each(uiTxt,function(i,v){var backgroudColor = (i+1)%2 == 0 ? "tr-hover" : "";arrHtml.push("<tr class='datagrid-row "+backgroudColor+" "+trClass+"' id='"+v.ID+"' abbr='"+v.ID+"' style='cursor: pointer;"+trStyle+"' "+trEvent+">");arrHtml.push("<input type='hidden' name='ID' value='"+v.ID+"' />");arrHtml.push("<input type='hidden' id='DATA_AUTH_ID_"+v.ID+"' value='"+v.DATA_AUTH_ID+"' />");getRelColVal(arrHtml,v,colNo);arrHtml.push("<td class='datagrid-cell' name='noprintset_SEQ' style='width:30px;text-align:center;' ><span class='_noedit'>"+v._SEQ+"</span></td>");arrHtml.push("<td class='datagrid-cell no-print' style='width:30px;text-align:center;' ><span class='_noedit'>");arrHtml.push("<input type='checkbox' name='"+formId+"$ID' value='"+v.ID+"' class='isSubmit _selectdata' style='cursor: pointer;margin:0'>");arrHtml.push("</td>");arrHtml.push("<td colno='DOC_NO' name='noprintset_DOC_NO' class='datagrid-cell "+ms.tdClass(formId, 'DOC_NO')+"' style='"+ms.tdStyle(formId, 'DOC_NO')+"' "+ms.tdEvent(formId, 'DOC_NO')+">")arrHtml.push("<span colno='DOC_NO' class='"+ms.uiClass(formId, 'DOC_NO')+"' style='"+ms.uiStyle(formId, 'DOC_NO')+"' "+ms.uiEvent(formId, 'DOC_NO')+" title='"+ms.titleAttr(formId,'DOC_NO','IS_TITLE_ATTR',v)+"' >"+v['DOC_NO']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_NAME' name='noprintset_ITEM_NAME' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_NAME')+"' style='"+ms.tdStyle(formId, 'ITEM_NAME')+"' "+ms.tdEvent(formId, 'ITEM_NAME')+">")arrHtml.push("<span colno='ITEM_NAME' class='"+ms.uiClass(formId, 'ITEM_NAME')+"' style='"+ms.uiStyle(formId, 'ITEM_NAME')+"' "+ms.uiEvent(formId, 'ITEM_NAME')+" title='"+ms.titleAttr(formId,'ITEM_NAME','IS_TITLE_ATTR',v)+"' >"+v['ITEM_NAME']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_CODE' name='noprintset_ITEM_CODE' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_CODE')+"' style='"+ms.tdStyle(formId, 'ITEM_CODE')+"' "+ms.tdEvent(formId, 'ITEM_CODE')+">")arrHtml.push("<span colno='ITEM_CODE' class='"+ms.uiClass(formId, 'ITEM_CODE')+"' style='"+ms.uiStyle(formId, 'ITEM_CODE')+"' "+ms.uiEvent(formId, 'ITEM_CODE')+" title='"+ms.titleAttr(formId,'ITEM_CODE','IS_TITLE_ATTR',v)+"' >"+v['ITEM_CODE']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_SPEC' name='noprintset_ITEM_SPEC' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_SPEC')+"' style='"+ms.tdStyle(formId, 'ITEM_SPEC')+"' "+ms.tdEvent(formId, 'ITEM_SPEC')+">")arrHtml.push("<span colno='ITEM_SPEC' class='"+ms.uiClass(formId, 'ITEM_SPEC')+"' style='"+ms.uiStyle(formId, 'ITEM_SPEC')+"' "+ms.uiEvent(formId, 'ITEM_SPEC')+" title='"+ms.titleAttr(formId,'ITEM_SPEC','IS_TITLE_ATTR',v)+"' >"+v['ITEM_SPEC']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='PLAN_QTY' name='noprintset_PLAN_QTY' class='datagrid-cell "+ms.tdClass(formId, 'PLAN_QTY')+"' style='"+ms.tdStyle(formId, 'PLAN_QTY')+"' "+ms.tdEvent(formId, 'PLAN_QTY')+">")arrHtml.push("<span colno='PLAN_QTY' class='"+ms.uiClass(formId, 'PLAN_QTY')+"' style='"+ms.uiStyle(formId, 'PLAN_QTY')+"' "+ms.uiEvent(formId, 'PLAN_QTY')+" title='"+ms.titleAttr(formId,'PLAN_QTY','IS_TITLE_ATTR',v)+"' >"+v['PLAN_QTY']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='MEMO' name='noprintset_MEMO' class='datagrid-cell "+ms.tdClass(formId, 'MEMO')+"' style='"+ms.tdStyle(formId, 'MEMO')+"' "+ms.tdEvent(formId, 'MEMO')+">")arrHtml.push("<span colno='MEMO' class='"+ms.uiClass(formId, 'MEMO')+"' style='"+ms.uiStyle(formId, 'MEMO')+"' "+ms.uiEvent(formId, 'MEMO')+" title='"+ms.titleAttr(formId,'MEMO','IS_TITLE_ATTR',v)+"' >"+v['MEMO']+"</span>")arrHtml.push("</td>");arrHtml.push("</tr>")});if($("#leftTableDiv"+formId).length>0){$("#left-tbody_"+formId).html(arrLeftHtml.join(""));}setCrossWiseScroll(formId,arrHtml);$("#tbody_"+formId).html(arrHtml.join(""));}setNumColWidth(formId);clearAllSelect();setTableWidth(formId);setScroll(formId);}
</script><script><%--生成异步表格--%>function createTableModel_print(ms,formId){var arrHtml = [];var arrLeftHtml = [];var uiTxt = ms.uiTxt(formId)==null?[]:ms.uiTxt(formId);var trClass = ms.trClass(formId);var trStyle = ms.trStyle(formId);var trEvent = ms.trEvent(formId);var colNo = $("#relColVals").val();if(formId=='80e7dbef360c407d8c7c81dbf6cbed37'){<%--FM-T_WMS_PRODUCTION_TEST--%>$.each(uiTxt,function(i,v){var backgroudColor = (i+1)%2 == 0 ? "tr-hover" : "";arrHtml.push("<tr class='datagrid-row "+backgroudColor+" "+trClass+"' id='"+v.ID+"' abbr='"+v.ID+"' style='cursor: pointer;"+trStyle+"' "+trEvent+">");arrHtml.push("<input type='hidden' name='ID' value='"+v.ID+"' />");getRelColVal(arrHtml,v,colNo);arrHtml.push("<td class='datagrid-cell' name='noprintset_SEQ' style='width:30px;text-align:center;' ><span class='_noedit'>"+v._SEQ+"</span></td>");arrHtml.push("<td colno='DOC_NO' name='noprintset_DOC_NO' class='datagrid-cell "+ms.tdClass(formId, 'DOC_NO')+"' style='"+ms.tdStyle(formId, 'DOC_NO')+"' "+ms.tdEvent(formId, 'DOC_NO')+">")arrHtml.push("<span colno='DOC_NO' class='"+ms.uiClass(formId, 'DOC_NO')+"' style='"+ms.uiStyle(formId, 'DOC_NO')+"' "+ms.uiEvent(formId, 'DOC_NO')+" title='"+ms.titleAttr(formId,'DOC_NO','IS_TITLE_ATTR',v)+"' >"+v['DOC_NO']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_NAME' name='noprintset_ITEM_NAME' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_NAME')+"' style='"+ms.tdStyle(formId, 'ITEM_NAME')+"' "+ms.tdEvent(formId, 'ITEM_NAME')+">")arrHtml.push("<span colno='ITEM_NAME' class='"+ms.uiClass(formId, 'ITEM_NAME')+"' style='"+ms.uiStyle(formId, 'ITEM_NAME')+"' "+ms.uiEvent(formId, 'ITEM_NAME')+" title='"+ms.titleAttr(formId,'ITEM_NAME','IS_TITLE_ATTR',v)+"' >"+v['ITEM_NAME']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_CODE' name='noprintset_ITEM_CODE' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_CODE')+"' style='"+ms.tdStyle(formId, 'ITEM_CODE')+"' "+ms.tdEvent(formId, 'ITEM_CODE')+">")arrHtml.push("<span colno='ITEM_CODE' class='"+ms.uiClass(formId, 'ITEM_CODE')+"' style='"+ms.uiStyle(formId, 'ITEM_CODE')+"' "+ms.uiEvent(formId, 'ITEM_CODE')+" title='"+ms.titleAttr(formId,'ITEM_CODE','IS_TITLE_ATTR',v)+"' >"+v['ITEM_CODE']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='ITEM_SPEC' name='noprintset_ITEM_SPEC' class='datagrid-cell "+ms.tdClass(formId, 'ITEM_SPEC')+"' style='"+ms.tdStyle(formId, 'ITEM_SPEC')+"' "+ms.tdEvent(formId, 'ITEM_SPEC')+">")arrHtml.push("<span colno='ITEM_SPEC' class='"+ms.uiClass(formId, 'ITEM_SPEC')+"' style='"+ms.uiStyle(formId, 'ITEM_SPEC')+"' "+ms.uiEvent(formId, 'ITEM_SPEC')+" title='"+ms.titleAttr(formId,'ITEM_SPEC','IS_TITLE_ATTR',v)+"' >"+v['ITEM_SPEC']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='PLAN_QTY' name='noprintset_PLAN_QTY' class='datagrid-cell "+ms.tdClass(formId, 'PLAN_QTY')+"' style='"+ms.tdStyle(formId, 'PLAN_QTY')+"' "+ms.tdEvent(formId, 'PLAN_QTY')+">")arrHtml.push("<span colno='PLAN_QTY' class='"+ms.uiClass(formId, 'PLAN_QTY')+"' style='"+ms.uiStyle(formId, 'PLAN_QTY')+"' "+ms.uiEvent(formId, 'PLAN_QTY')+" title='"+ms.titleAttr(formId,'PLAN_QTY','IS_TITLE_ATTR',v)+"' >"+v['PLAN_QTY']+"</span>")arrHtml.push("</td>");arrHtml.push("<td colno='MEMO' name='noprintset_MEMO' class='datagrid-cell "+ms.tdClass(formId, 'MEMO')+"' style='"+ms.tdStyle(formId, 'MEMO')+"' "+ms.tdEvent(formId, 'MEMO')+">")arrHtml.push("<span colno='MEMO' class='"+ms.uiClass(formId, 'MEMO')+"' style='"+ms.uiStyle(formId, 'MEMO')+"' "+ms.uiEvent(formId, 'MEMO')+" title='"+ms.titleAttr(formId,'MEMO','IS_TITLE_ATTR',v)+"' >"+v['MEMO']+"</span>")arrHtml.push("</td>");arrHtml.push("</tr>")});if($("#leftTableDiv"+formId).length>0){$("#left-tbody_"+formId).html(arrLeftHtml.join(""));}setCrossWiseScroll(formId,arrHtml);$("#tbody_print_"+formId).html(arrHtml.join(""));}setNumColWidth(formId);clearAllSelect();setTableWidth(formId);setScroll(formId);}//2024-01-09 PZJ 添加 重写获取主表数据 var sortNum=0;var currentcolnum;// 点击排序function _sortData(thisObj,colnum){currentcolnum=colnum;_sortIcon(thisObj,colnum,sortNum);var mainId=$(thisObj).parents(".main").attr("id");if(mainId=="main"){listAjaxTable("80e7dbef360c407d8c7c81dbf6cbed37");currentcolnum="";}}function listAjaxTable(paginationImpl){util.showLoading("处理中...");$("#tbody_80e7dbef360c407d8c7c81dbf6cbed37").empty();var dataAuth = $("#DATA_AUTH").val();var url = "${path}buss/bussModel_exeFunc.ms?funcMId=7153b19d1ae4406fac15432d18aacc73";var searchParams = _getSearchParams();var isFirstLoad = firstLoadThisPage(paginationImpl);var currentPage = isFirstLoad? 1 : _GLO_FORM_PAGE_MAP[paginationImpl].currentPage;var pageRecord = isFirstLoad? 100 : _GLO_FORM_PAGE_MAP[paginationImpl].pageRecord;// ypy 2022.4.17 点击排序var subSortColOrder= $("#SORT_"+currentcolnum).val();$.ajax({type:"post",dataType:"json",url:url+"&"+searchParams,data:{"dataAuth":dataAuth,"page.currentPage":_GLO_FORM_PAGE_MAP[paginationImpl].currentPage,"page.pageRecord": pageRecord,"ITEM_NAME": currentcolnum,"isFirstLoad": isFirstLoad,"subSortColOrder": subSortColOrder},success:function(data){util.closeLoading();if(null==data){return;}var ms = new MSdata(data);var page = ms.page("80e7dbef360c407d8c7c81dbf6cbed37");createTableModel(ms,"80e7dbef360c407d8c7c81dbf6cbed37");pageFun(page,"80e7dbef360c407d8c7c81dbf6cbed37");},error:function(msg){util.closeLoading();_TOOL_PRO.showAjaxErrorMsg(msg);}})}function _getSearchParams() {let searchParams = $("#searchForm").serialize()+"&"+$("#searchFormTop").serialize().replace(/searchParaList/g,'searchTopParaList');return searchParams;}//初始化function init(){$("select[name='searchParaList[5]._PAGE_SEARCH_VALUE']").val("N");listAjaxTable('80e7dbef360c407d8c7c81dbf6cbed37');}//搜索function query(){listAjaxTable('80e7dbef360c407d8c7c81dbf6cbed37');}
</script>
<%-- 平台异步分页相关JS方法 --%>
<script type="text/javascript" src="${path}plf/page/fp/js/paginationMultAx.js?_mc_res_version=<%=PlfStaticRes.PaginationMultAx_JS %>"></script>
<%-- 表单结束区域 --%>
<%@ include file="/plf/common/fp/pub_dom_fp.jsp"%>
</body>
<%-- 平台公用的底部代码区域 --%>
<%@ include file="/plf/common/pub_end.jsp"%>
<%-- 页面结束 --%>
<jsp:include page="/plf/page/mesdemo/commCode/commCode.jsp"><jsp:param name="modelName" value="VIEW_TYPE_30" /><jsp:param name="location" value="pageOver" />
</jsp:include>
记得添加一下前端代码,