📄 common_form_table.jsp
字号:
<%@ include file="../../include/configuration.jsp"%>
<%@ include file="../../include/authorizemanager.jsp"%>
<%@ page import="com.vere.form.item.*"%>
<%@ page import="com.vere.form.bean.*"%>
<%@ page contentType="text/html; charset=gb2312" %>
<%
ParameterUtils.setCharacterEncoding(request);
String status=ParameterUtils.getString(request,"status");
String form_table_id=ParameterUtils.getString(request,"form_table_id");
SessionFactory sessionFactory=(SessionFactory)session.getAttribute("sessionFactory");
if(!form_table_id.equals(""))
{
sessionFactory.setForm_table_id(form_table_id);
}
//删除全部选择的
if(status.equals("removeSelect"))
{
String ids=ParameterUtils.getString(request,"ids");
Form_tableBean bean=new Form_tableBean();
String[] idArray=ids.split(",");
bean.removeData(sessionFactory.getForm_table_id(),idArray);
}
int pageNo=ParameterUtils.getInt(request,"page");
if(pageNo<=0)
{
pageNo=1;
}
Form_dictionaryBean form_dictionaryBean=new Form_dictionaryBean();
Form_tableBean form_tableBean=new Form_tableBean();
Form_columnBean form_columnBean=new Form_columnBean();
List queryList=form_columnBean.findD_Column(sessionFactory.getForm_table_id());
for(int i=0;i<queryList.size();i++)
{
Form_columnItem form_columnItem=(Form_columnItem)queryList.get(i);
if(form_columnItem.getIs_query().equals("1"))
{
form_columnItem.setField_value(ParameterUtils.getString(request,form_columnItem.getField_english_name()));
}
}
List list=form_columnBean.findD_Table(sessionFactory.getForm_table_id(),pageNo,pageSize,queryList);
int totalRecord=form_columnBean.getTotalRecord();
int page_num=(int)Math.ceil((double)totalRecord/pageSize);
ArrayList listColumn=(ArrayList)list.get(0);//列
ArrayList tablesList=(ArrayList)list.get(1);//表
%>
<html>
<head>
<title><%=titleName%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../../js/check.js"></script>
<link href="../../css/date.css" rel="stylesheet" type="text/css">
<script src="../../js/ShowDate.js"></script>
<script language="javascript">
init();
</script>
</head>
<body>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" class="firsttable">
<tr>
<td align="center" valign="top">
<table class="centertable">
<tr>
<td>
</td>
</tr>
<tr>
<td align="center" valign="top">
<table class="containContentsTable">
<tr>
<td align="left" colspan=2 >
<%
for(int i=0;i<listColumn.size();i++)
{
Form_columnItem form_columnItem=(Form_columnItem)listColumn.get(i);
if(form_columnItem.getIs_query().equals("1"))
{
boolean b=false;
if(form_columnItem.getCom_type().trim().toLowerCase().equals("dropdownlist")||form_columnItem.getCom_type().trim().toLowerCase().equals("radio"))
{
out.print(form_columnItem.getField_chinese_name()+":<select name='"+form_columnItem.getField_english_name()+"' id='"+form_columnItem.getField_english_name()+"' >");
out.print("<option value=''></option>");
//固定字典取值
if(form_columnItem.getGet_value_type().equals("1"))
{
List form_dictionaryList=form_dictionaryBean.findByCode(form_columnItem.getFix_value());
for(int k=0;k<form_dictionaryList.size();k++)
{
Form_dictionaryItem form_dictionaryItem=(Form_dictionaryItem)form_dictionaryList.get(k);
if(ParameterUtils.getString(request,form_columnItem.getField_english_name()).equals(form_dictionaryItem.getCode_name()))
out.println("<option selected value='"+form_dictionaryItem.getCode_name()+"'>"+form_dictionaryItem.getCode_name()+"</option>");
else
out.println("<option value='"+form_dictionaryItem.getCode_name()+"'>"+form_dictionaryItem.getCode_name()+"</option>");
}
}
//关联表取值
if(form_columnItem.getGet_value_type().equals("2"))
{
List valueList=form_tableBean.findByTable(form_columnItem.getFix_table(),form_columnItem.getFix_column_value());
for(int k=0;k<valueList.size();k++)
{
String fieldvalue=valueList.get(k).toString();
if(ParameterUtils.getString(request,form_columnItem.getField_english_name()).equals(fieldvalue))
out.println("<option selected value='"+fieldvalue+"'>"+fieldvalue+"</option>");
else
out.println("<option value='"+fieldvalue+"'>"+fieldvalue+"</option>");
}
}
out.print("</select>");
b=true;
}
if(form_columnItem.getCom_type().trim().toLowerCase().equals("calendar"))
{
out.print(form_columnItem.getField_chinese_name()+":<input name='"+form_columnItem.getField_english_name()+"' id='"+form_columnItem.getField_english_name()+"' type='text' size='10' value='"+ParameterUtils.getString(request,form_columnItem.getField_english_name())+"'><a href='javascript:' onClick=\"show_cele_date("+form_columnItem.getField_english_name()+",'','',"+form_columnItem.getField_english_name()+")\"><img src='../../icon/cal.gif' width='24' height='19' border=0></a>");
b=true;
}
if(!b)
{
out.print(form_columnItem.getField_chinese_name()+":<input name='"+form_columnItem.getField_english_name()+"' type='text' id='"+form_columnItem.getField_english_name()+"' value='"+ParameterUtils.getString(request,form_columnItem.getField_english_name())+"'>");
}
}
}
%>
</td>
</tr>
<tr>
<td colspan="2" align='center'><input type="button" class="button" value="添加" onClick="javascript:add()">
<input type="button" class="button" value="删除" onClick="javascript:removeSelect()">
<input type="button" class="button" value="修改" onClick="javascript:edit()">
<input type="button" class="button" value="查询" onClick="javascript:query()">
<input type="button" class="button" value="导出/打印" onClick="javascript:exportExcel()"></td>
</tr>
<tr>
<td colspan="2">
<%
out.println("<table class='contentsTable' border='0' cellpadding='0' cellspacing='1'>");
out.println("<tr class='tr1' align=center ><td width=5% ></td>");
for(int i=0;i<listColumn.size();i++)
{
Form_columnItem item=(Form_columnItem)listColumn.get(i);
out.println("<td >"+item.getField_chinese_name()+"</td>");
}
out.println("</tr>");
for(int i=0;i<tablesList.size();i++)
{
ArrayList rowList=(ArrayList)tablesList.get(i);//行
out.println("<tr class='tr2'>");
for(int j=0;j<rowList.size();j++)
{
if(j==0)
{
out.print("<td align='center'><input type='checkbox' name=checkvalue value='"+rowList.get(j)+"'></td>");
}
else
{
Form_columnItem item=(Form_columnItem)listColumn.get(j-1);//j-1 多了id字段
out.print("<td align='"+item.getDirect_type()+"'>"+rowList.get(j)+"</td>");
}
}
out.println("</tr>");
}
out.println("</table>");
%>
</td>
</tr>
<tr>
<td><input name="cboAll" type="checkbox" id="cboAll" value="checkbox" onClick="checkBoxAll()">
全选 </td>
<td align="right" class="pagelink" >共 <%=totalRecord%> 条, 共 <%=page_num%> 页, 第 <%=pageNo%> 页 <a href="javascript:first()">第一页</a> <a href="javascript:next()">下一页</a> <a href="javascript:pre()">上一页</a> <a href="javascript:last()" >最后一页</a>
<select name="position" id="position" onChange="goposition()">
<option value=""></option>
<%
for(int i=1;i<=page_num;i++)
{
out.println("<option ");
if(pageNo==i){out.println("selected");}
out.println(" value="+i+">");
out.println(i);
out.println("</option>");
}
%>
</select></td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="status" value="">
<input type="hidden" name="page" value=<%=pageNo%>>
<input type="hidden" name="totalpage" value=<%=page_num%>>
<input type="hidden" name="id" value="">
<input type="hidden" name="ids" value="">
</form>
</body>
</html>
<script language="JavaScript" >
function checkBoxAll()//全选
{
var form = form1;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
form.elements[i].checked = form.cboAll.checked;
}
}
}
function edit()
{
var form=form1;
var j=0;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.id.value=form.elements[i].value;
j++;
}
}
}
if(form.id.value=="")
{
alert("请选择要修改的一条记录");
return;
}
if(j>1)
{
alert("一次只能修改修改一条记录");
return;
}
form.action="common_form_tableedit.jsp?id="+form.id.value;
form.submit();
}
function look()
{
var form=form1;
var j=0;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.id.value=form.elements[i].value;
j++;
}
}
}
if(form.id.value=="")
{
alert("请选择要浏览的一条记录");
return;
}
if(j>1)
{
alert("一次只能浏览一条记录");
return;
}
location="common_form_tablelook.jsp?id="+form.id.value;
}
function remove(id)
{
if(confirm("是否要删除选择的记录")==true)
{
var form=form1;
form.id.value=id;
form.status.value="remove";
form.submit();
}
}
function exportExcel()
{
location="common_form_table_find.jsp?op=excel";
}
function removeSelect()
{
var form=form1;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.ids.value+=form.elements[i].value+",";
}
}
}
if(form.ids.value=="")
{
alert("请选择要删除的记录");
return;
}
if(confirm("是否要删除选择的记录")==false)
return;
form.status.value="removeSelect";
form.submit();
}
function add()
{
location="common_form_tableadd.jsp";
}
function query()
{
var form=form1;
form.submit();
}
function first()
{
var form=form1;
if(eval(form.page.value)==1)
return;
form.page.value=1;
form.submit();
}
function next()
{
var form=form1;
if(eval(form.page.value)>=eval(form.totalpage.value))
return;
form.page.value=eval(form.page.value)+1;
form.submit();
}
function last()
{
var form=form1;
if(eval(form.page.value)>=eval(form.totalpage.value))
return;
form.page.value=eval(form.totalpage.value);
form.submit();
}
function pre()
{
var form=form1;
if(form.page.value<=1)
return;
form.page.value=eval(form.page.value)-1;
form.submit();
}
function goposition()
{
var form=form1;
form.page.value=form.position.value;
form.submit();
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -