CompanyAffixMainList1.jsp
2.68 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<style type="text/css">
<!--
TABLE.ListStyle {
width:"100%" ;
BACKGROUND-COLOR: #b8c2c8 ;
BORDER-Spacing:1px;
}
.xTable_info{
margin-top:0px;
text-align:right;
font-size:9pt;
}
-->
</style>
<%
//要查找的列
String companyid = Util.null2String(request.getParameter("companyid"));
String userId = String.valueOf(user.getUID()); //当前用户Id
String moudel = Util.null2String(request.getParameter("moudel"));
//System.out.println(moudel);
String backfields = " t1.id,t1.searchname,t1.LASTUPDATETIME";
String fromSql = " CPCOMPANYAFFIXSEARCH t1 ";
String sqlwhere = " where t1.isdel='T' and t1.companyid= "+companyid +" and t1.userid="+userId+" and t1.whichmoudel='"+moudel+"'";
String sqlorderby = " t1.LASTUPDATETIME ";
String sqlsortway = " desc ";
StringBuffer tableString = new StringBuffer();
tableString .append(" <table instanceid=\"workflowRequestListTable\" tabletype=\"checkbox\" pagesize=\"5\" width=\"100%\" isfixed=\"true\" isnew= \"true\" _style= \"true\"> ");
tableString .append(" <checkboxpopedom popedompara=\"column:id\" showmethod=\"weaver.cpcompanyinfo.CompanyInfoTransMethod.getIsShowBox\" />");
tableString .append(" <sql backfields=\""+backfields+"\" sqlform=\""+fromSql+"\" sqlwhere=\""+sqlwhere+"\" sqlorderby=\""+sqlorderby+"\" sqlprimarykey=\"t1.id\" sqlsortway=\""+sqlsortway+"\" />");
tableString .append(" <head>");
if(moudel.equals("search")){
tableString.append(" <col text=\""+SystemEnv.getHtmlLabelName(30959,user.getLanguage())+"\" column=\"searchname\" orderkey=\"archivenum\" width=\"35%\" />");
}
if(moudel.equals("delivery")){
tableString.append(" <col text=\""+SystemEnv.getHtmlLabelName(30960,user.getLanguage())+"\" column=\"searchname\" orderkey=\"archivenum\" width=\"35%\" />");
}
tableString.append(" <col text=\""+SystemEnv.getHtmlLabelName(26805,user.getLanguage())+"\" column=\"LASTUPDATETIME\" align=\"center\" width=\"17%\" />");
tableString.append(" </head> </table>");
%>
<div style="padding:5px">
<wea:SplitPageTag tableString='<%=tableString.toString()%>' mode="run" isShowTopInfo="false" isShowBottomInfo="true"/>
</div>
<script type="text/javascript">
jQuery(document).ready(function(){
});
/*刷新自身页面*/
function reloadListContent(){
window.location.reload();
}
/*获得搜索策略 ID*/
function getrequestids(){
var requestids = _xtable_CheckedCheckboxId();
return requestids;
}
</script>