⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 cg_query.jsp

📁 使用JSP+Servlet+Ajax的供应商管理系统(不包含数据库部分)
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>采购单查询</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	<link href="css/style.css" rel="stylesheet" type="text/css">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	
	<script type="text/javascript" src="dwr/interface/PomainDAO.js"></script>
	<script type="text/javascript" src="dwr/engine.js"></script>	
	<script type="text/javascript" src="dwr/util.js"></script>

	<script language="javascript" src="<%=basePath %>script/common.js"></script>
    <script language="javascript" type="text/javascript">
    var reVenderCode;
    //选择供应商名称
    function choiceName()
    {
     var returnValue = window.showModalDialog("<%=basePath %>servlet/VenderServlet?flog=select", null, "dialogHeight:400px; dialogWidth:600px; scroll:yes; help:no; status:no");
     $("name").value = returnValue[1];
     reVenderCode = returnValue[0];
    }
    //查询
    function query()
    {
      var pomain={};
      var poid=DWRUtil.getValue("poid");
      if(poid=="")
      {
        pomain.poid = -1;
      }else{
        pomain.poid = poid;
      }
      var createTime1 = DWRUtil.getValue("createTime1");
      var createTime2 = DWRUtil.getValue("createTime2");
      pomain.venderCode=reVenderCode;
      pomain.payType=$("payType").options[$("payType").selectedIndex].value;
      pomain.status=$("status").options[$("status").selectedIndex].value;
      PomainDAO.query(pomain,createTime1,createTime2,queryCallBack);
      clear();
    }
    
    function clear()
    {
      $("poid").value="";
      $("name").value="";
      $("createTime1").value="";
      $("createTime2").value="";
      $("payType").value=0;
      $("status").value=0;
      reVenderCode="";
    }
    
    function queryCallBack(data)
    {
       test(data);
    }
    
    function test(data)
    {
       var num = 1;
       DWRUtil.removeAllRows("headTbody");
	   DWRUtil.addRows("headTbody",data,[
	                                     function(){return  num++},
									     function(pomain){return pomain.poid},
									     function(pomain){return pomain.createTime},
									     function(pomain){return pomain.venderCode},
									     function(pomain){return pomain.account},
									     function(pomain){return pomain.tipFee},
									     function(pomain){return pomain.productTotal},
									     function(pomain){return pomain.poTotal},
									     function(pomain){return pomain.payType},
									     function(pomain){return pomain.prePayFee},
									     function(pomain){return getStatusText(pomain.status)},
									     function(){
									          var chakan = document.createElement( '<input type="button" value="查看明细" class="toolbar" onMouseOver="OMO()" onMouseOut="OMOU()" onClick="ck_detial(this.parentNode.parentNode)"/>');
									          return chakan;
									          },
									     ],{
										rowCreator:function(options) {
										var row = document.createElement("tr");
										return row;
										},
										cellCreator:function(options) {
										var td = document.createElement("td");
										return td;
										}
										}
							     );
    }
    
    function  getStatusText(i)
	{
		switch(i)
		{ 
		case 1:
			return "新增";break;
		case 2:
			return "已收货";break;
		case 3:
			return "已付款";break;
		case 4:
			return "已了结";break;
		case 5:
			return "已预付";break;
		}
	}
	//查看明细
	function ck_detial(row)
	{
	  $("detail").style.display = "block";
	    var poid = row.cells[1].innerHTML;
	   PomainDAO.ck_detial(poid,ck_detialCallBack);
	}
	
	function ck_detialCallBack(data)
	{
	   var num = 1;
       DWRUtil.removeAllRows("productDetailTable");
	   DWRUtil.addRows("productDetailTable",data,[
	                                     function(){return  num++},
									     function(poitem){return poitem.productCode},
									     function(poitem){return poitem.name},
									     function(poitem){return poitem.unitPrice},
									     function(poitem){return poitem.num},
									     function(poitem){return poitem.unitName},
									     function(poitem){return poitem.itemPrice},
										 ]
							     );
	}
	
	function closemx()
	{
	  $("detail").style.display = "none";
	}
    </script>

  </head>
  
  <body>
    <table width="100%"  border="0" cellpadding="0" cellspacing="0">
      <tr>
          <td nowrap class="title1" align="center"><strong>您的位置:采购管理--采购单查询</strong></td>
      </tr>
      <tr>
         <td width="100%" nowrap class="toolbar"></td>
      </tr>
   </table>
   <div align="center">
   <table id="addTable" width="100%"  border="0" align="center" class="a1">
      <tr align="justify">
         <td>采购单编号</td>
         <td><input type="text" value="" id="poid" name="poid" size="15" /></td>
         <td> 开始日期</td>
         <td><input type="text" id="createTime1" size="15" value="" readonly/><span class="requred_symbol">*</span>
        <a href="javascript:void(0)" onclick="gfPop.fPopCalendar(document.all.createTime1);return false;">
        <img name="popcal" align="absmiddle" src="images/selectDate.gif" width="15" height="12" border="0" alt=""></td>
         <td> 结束日期</td>
         <td><input type="text" id="createTime2" size="15" value="" readonly/><span class="requred_symbol">*</span>
        <a href="javascript:void(0)" onclick="gfPop.fPopCalendar(document.all.createTime2);return false;">
        <img name="popcal" align="absmiddle" src="images/selectDate.gif" width="15" height="12" border="0" alt=""></td>
     </tr>
     <tr align="justify">
     <td>供应商</td>
         <td><input type="text" id="name" size="15" readonly/>
             <span class="LL"><image src="images/selectDate.gif" onClick="choiceName()"></span></td>
        <td>付款方式</td>
        <td>
           <select id="payType" size="1">
               <option value="0" selected></option>
               <option value="1">货到付款</option>
               <option value="2">款到发货</option>
               <option value="3">预付款到发货</option>
           </select>
       </td>
       <td>处理状态</td>
       <td>
          <select id="status" size="1">
            <option value="0" selected></option>
            <option value="1">新增</option>
            <option value="2">已收货</option>
            <option value="3">已付款</option>
            <option value="4">已了结</option>
            <option value="5">已预付</option>
          </select>
       </td>
       
      </tr>
      <tr>
         <td class="title2"></td>
      </tr>
  </table>
      <input type="button" id="bc" value="查询" onclick="query()"/>
  <br>&nbsp;<br>
  <br>&nbsp;
  </div>
  <table width="100%"  border="0" align="center" cellspacing="1" id="mainTable">
  
  <tr>
    <td class="title1">序号</td>
    <td class="title1">采购单编号</td>
    <td class="title1">创建时间</td>
    <td class="title1">供应商名称</td>
    <td class="title1">创建用户</td>
    <td class="title1">附加费用</td>
    <td class="title1">采购产品总价</td>
    <td class="title1">采购单总价格</td>
    <td class="title1">付款方式</td>
    <td class="title1">最低预付款金额</td>
    <td class="title1">处理状态</td>
    <td class="title1">查看明细</td>
  </tr>
  <tbody id="headTbody" align="center">
  </tbody>
  </table>
  <br>&nbsp;<br>
  <br>&nbsp;
  <div id="detail" style="display:none" align="center">
  产品明细
  <table width="100%"  border="0" align="center" cellspacing="1" id="detailTable">
  <tr>
    <td class="toolbar"> 序号 </td>
    <td class="toolbar"> 产品编号 </td>
    <td class="toolbar"> 产品名称 </td>
    <td class="toolbar"> 产品数量单位 </td>
    <td class="toolbar"> 产品数量 </td>
    <td class="toolbar"> 产品单价 </td>
    <td class="toolbar"> 产品明细总价 </td>
  </tr>
  <tbody id="productDetailTable">
  </tbody>
</table>
<input type="button" value="确定" onclick="closemx()"/>
  </div>
  <iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="common/calendar/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; left:-500px; top:0px;"></iframe>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -