card_list.jsp
<%
/*
选项卡列表
*/
%>
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="check.jsp"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.DateFormat"%>
<%@ include file="top.jsp"%>
<script type="text/javascript">
function firm(s)
{//利用对话框返回的值(true 或者 false)
if(confirm("确定删除?"))
{//如果是true ,那么就把页面转向
location.href=s;
}
}
</script>
<%
String sql;
ResultSet rs;
int xuhao;
%>
<div class="W96">
<ul id="myTab" class="nav nav-tabs">
<li class="active"><a href="#cardlist" data-toggle="tab">选项卡列表</a></li>
<li><a href="#cardadd" data-toggle="tab">新增选项卡</a></li>
<a href="field_add.jsp" class="pull-right">新增字段</a>
<a href="field_list.jsp" class="pull-right">字段列表 </a>
</ul>
<div id="myTabContent" class="tab-content">
<div class="tab-pane fade in active" id="cardlist">
<table class="table table-striped table-hover" width="100%" border="0" cellspacing="0" cellpadding="0">
<thead class="TD_Title">
<tr>
<td>序号</td>
<td>显示位置</td>
<td>ID</td>
<td>显示否</td>
<td>系统类型</td>
<td>系统分类</td>
<td colspan="4">操作</td>
</tr>
</thead>
<tbody class="TD_List">
<%
sql="select * from crm_card order by InRow desc,id desc";
rs=stmt.executeQuery(sql);
xuhao=1;
while(rs.next()) {%>
<tr>
<td><%=xuhao%></td>
<td><%=rs.getString("InRow")%></td>
<td><%=rs.getString("id")%></td>
<td><%if(Integer.parseInt(rs.getString("isMenu"))==1){
%>显示<%
}else{
%>不显示<%}%></td>
<td><%=rs.getString("CardName")%></td>
<td><%=rs.getString("CardValue")%></td>
<td><a title="新增数据" class="iconfont icon-jia" href="data_add.jsp?id=<%=rs.getString("id")%>"></a></td>
<td><a title="查看数据" class="iconfont icon-liebiao" href="data_info.jsp?id=<%=rs.getString("id")%>"></a></td>
<td><a title="编辑" class="iconfont icon-bianji" href="card_edit.jsp?id=<%=rs.getString("id")%>"></a></td>
<td><a title="删除" class="iconfont icon-shanchu" href="#" onclick='firm("card_del.jsp?id=<%=rs.getString("id")%>")'></a></td>
</tr>
<%xuhao=xuhao+1;}%>
</tbody>
</table>
</div>
<div class="tab-pane fade" id="cardadd">
<form action="card_save.jsp?act=add" onsubmit="return validate_form(this)" method="post">
<table class="FormTable" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="TD_Left">选项卡名称:</td>
<td class="TD_Right"><input type="text" name="CardName" value="" placeholder="如:公司管理" required />
</td>
</tr>
<tr>
<td class="TD_Left">表名:</td>
<td class="TD_Right"><input type="text" name="CardValue" required /> 新建选项卡时对应会增加一个数据表,可输入英文、下划线、数字,以英文或下划线开头</td>
</tr>
<tr>
<td class="TD_Left">是否在左侧导航显示:</td>
<td class="TD_Right">
<select name="isMenu" id="isMenu">
<option selected="selected"value ="1">显示</option>
<option value ="0">不显示</option>
</select>
</td>
</tr>
<tr>
<td class="TD_Left"> </td>
<td class="TD_Right"><input type="submit" name="Submit" value="保存" /></td>
</tr>
</table>
</form>
</div>
</div>
</div>
<%rs.close();
stmt.close();
conn.close();
%>
<%@ include file="bottom.jsp"%>
- 文章导航