WebRoot/caigoujilu_list.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="util.Info"%>
<%@page import="dao.CommDAO"%>
<%@page import="util.PageManager"%>
<html>
  <head>
    <title>采购记录</title>
	<link rel="stylesheet" href="images/hsgcommon/common.css" type="text/css">
<link rel="stylesheet" href="images/hsgcommon/div.css" type="text/css">
	<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
  </head>


  <body >
  <p>已有采购记录列表：</p>
  <form name="form1" id="form1" method="post" action="">
   搜索:  采购单号：<input name="caigoudanhao" type="text" id="caigoudanhao" class="form-control2" />  商品编号：<input name="shangpinbianhao" type="text" id="shangpinbianhao" class="form-control2" />  商品名称：<input name="shangpinmingcheng" type="text" id="shangpinmingcheng" class="form-control2" />  类别：<input name="leibie" type="text" id="leibie" class="form-control2" />
   <input type="submit" name="Submit" value="查找" class="btn btn-info btn-small" /> <input type="button" name="Submit2" value="导出EXCEL" class="btn btn-info btn-small" onClick="javascript:location.href='caigoujilu_listxls.jsp';" />
</form>

<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="cccccc" >  
  <tr>
    <td width="35" height="30" align="center" bgcolor="cccccc">序号</td>
    <td bgcolor='#cccccc'>采购单号</td>
    <td bgcolor='#cccccc'>商品编号</td>
    <td bgcolor='#cccccc'>商品名称</td>
    <td bgcolor='#cccccc'>类别</td>
    <td bgcolor='#cccccc'>库存</td>
    <td bgcolor='#cccccc'>价格</td>
    <td bgcolor='#cccccc'>采购数量</td>
    <td bgcolor='#cccccc'>采购金额</td>
    <td bgcolor='#cccccc' width='90' align='center'>采购合同</td>
    <td bgcolor='#cccccc'>经办人</td>
    
    
	
    <td width="138" height="30" align="center" bgcolor="cccccc">添加时间</td>
    
    <td width="220" height="30" align="center" bgcolor="cccccc">操作</td>
  </tr>
  <% 
  	double caigoujinez=0;


  	 new CommDAO().delete(request,"caigoujilu"); 
    String url = "caigoujilu_list.jsp?1=1"; 
    String sql =  "select * from caigoujilu where 1=1";
	
if(request.getParameter("caigoudanhao")=="" ||request.getParameter("caigoudanhao")==null ){}else{sql=sql+" and caigoudanhao like '%"+request.getParameter("caigoudanhao")+"%'";}
if(request.getParameter("shangpinbianhao")=="" ||request.getParameter("shangpinbianhao")==null ){}else{sql=sql+" and shangpinbianhao like '%"+request.getParameter("shangpinbianhao")+"%'";}
if(request.getParameter("shangpinmingcheng")=="" ||request.getParameter("shangpinmingcheng")==null ){}else{sql=sql+" and shangpinmingcheng like '%"+request.getParameter("shangpinmingcheng")+"%'";}
if(request.getParameter("leibie")=="" ||request.getParameter("leibie")==null ){}else{sql=sql+" and leibie like '%"+request.getParameter("leibie")+"%'";}
    sql+=" order by id desc";
	ArrayList<HashMap> list = PageManager.getPages(url,15,sql, request); 
	int i=0;
	for(HashMap map:list){ 
	i++;
	
	caigoujinez=caigoujinez+Float.valueOf((String)map.get("caigoujine")).floatValue();