开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
c_customer_order_list.jsp
资源名称：shihua.rar　[点击查看]
上传用户：zghglow
上传日期：2022-08-09
资源大小：27227k
文件大小：9k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

JavaScript

c_customer_order_list.jsp：源码内容
  1. <%@ page contentType="text/html;charset=gb2312"%> 
  2. <%@include file="../include/checkadmin.jsp"%>
  3. <%@page import="java.sql.*"%>
  4. <%@include file="../include/db_conn.jsp"%>
  5. <%@include file="../include/const.jsp"%>
  6. <%@include file="../include/isNotInteger.jsp"%>
  7. <%!String keyword;%>
  8. <%!String keyword2;%>
  9. <%
  10. keyword=request.getParameter("keyword");
  11. if(keyword==null){
  12. keyword="";
  13. }else{
  14. keyword=getGBString(keyword);
  15. }
  16. keyword2=request.getParameter("keyword2");
  17. if(keyword2==null){
  18. keyword2="";
  19. }else{
  20. keyword2=getGBString(keyword2);
  21. }
  23. String admin_username;
  24.  String customer_name="";
  25.  //获取客户名称
  26.  admin_username = (String)session.getAttribute("admin_username");
  27.  sql="SELECT NAME1 FROM ZSD_KNA1 where KUNNR="+admin_username;
  28.  //out.print(sql);
  29.   rs=smt.executeQuery(sql);
  30. while(rs.next()){
  31. customer_name =rs.getString("NAME1");
  32. }
  34. %>
  37. <HTML>
  38. <HEAD>
  39. <TITLE>+ + 翔鹭石化 + +</TITLE>
  40. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
  41. <link href="../style.css" rel="stylesheet" type="text/css">
  42. </HEAD>
  43. <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
  44. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  45.         <tr> 
  46.           <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
  47.         </tr>
  49.   <tr> 
  50.     <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
  51.     <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
  52.     <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
  53.   </tr>
  54.  
  55. </table>
  57. <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  58.   <tr> 
  59.     <td>&nbsp;</td>
  60.     <td align="right" valign="top" bgcolor="f0f0f0">
  61. <!--子目录-->
  62. <%@include file="s2menu.jsp"%>
  63. <!--子目录-->
  64.       <table width="100%" cellspacing="0" cellpadding="0" >
  65.         <tr> 
  66.           <td><img src="../images/in1left.gif" width="165" height="100">
  67.         </tr>
  68.       </table>
  69.   </td>      
  70.     <td align="center" valign="top">
  71.         <table width="80%">
  72.   <tr>
  73.     <td >
  74.   <p align="center"><strong><font size="+2"><%=customer_name%></font></strong></p>
  75. </td>
  76.   </tr>
  77.   <tr>
  78.     <td >
  79.   <p align="center"><strong><font size="3">订单欠交信息</font></strong></p>
  80. </td>
  81.   </tr>
  82.   <form name="frm_search" action="c_customer_order_list.jsp" method="post">
  83.     <tr> 
  84.       <td align="left" bgcolor="#ffffff" height=20>请输入查询条件:&nbsp;&nbsp;&nbsp;年月&nbsp;<input type="text" size="5" name="keyword">&nbsp;&nbsp;&nbsp;订单号&nbsp;<input type="text" size="15" name="keyword2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="s1" value="搜 索" style="width:60px;height:22px;"></td>
  85.     </tr>
  86.   </form>   
  87. </table>
  89.        <!--新闻列表-->
  90.        <%
  91.                 String column_id="3";
  92. String column_title;
  94. int intPageSize; //一页显示的记录数
  95. int intRowCount; //记录总数
  96. int intPageCount; //总页数
  97. int intPage; //待显示页码
  98. String strPage;
  99. int i;
  100. //版本控制
  102. intPageSize = 8; //设置一页显示的记录数
  103. strPage = request.getParameter("page"); //取得待显示页码
  104. if(isNotInteger(strPage)){//表明在QueryString中没有page这一个参数，此时显示第一页数据
  105. intPage = 1;
  106. }
  107. else{//将字符串转换成整型
  108. intPage = java.lang.Integer.parseInt(strPage);
  109. if(intPage<1) intPage = 1;
  110. }
  112. sql = "select YEARMONTH,c_id,VBELN,POSNR,ERDAT1,KWMENG,MENGE,zzsl,qjsl,ERDAT,ERZET,ARKTX,KUNNR from V_ZSD_ORDER ";
  113. sql = sql + " where (kunnr='"+admin_username+"')and(me_ver='cn') order by YEARMONTH DESC";
  114.                    if((keyword.length()!=0)&&(keyword2.length()!=0))
  115.  {
  116.      sql = "select YEARMONTH,c_id,VBELN,POSNR,ERDAT1,KWMENG,MENGE,zzsl,qjsl,ERDAT,ERZET,ARKTX,KUNNR from V_ZSD_ORDER ";
  117.         sql = sql + " where (YEARMONTH like '%"+keyword+"%')and(VBELN like '%"+keyword2+"%')and(kunnr='"+admin_username+"')and(me_ver='cn') order by YEARMONTH DESC ";
  118.                      }
  119.                    if((keyword.length()!=0)&&(keyword2.length()==0))
  120.  {
  121.   sql = "select YEARMONTH,c_id,VBELN,POSNR,ERDAT1,KWMENG,MENGE,zzsl,qjsl,ERDAT,ERZET,ARKTX,KUNNR from V_ZSD_ORDER ";
  122.        sql = sql + " where (YEARMONTH like '%"+keyword+"%')and(kunnr='"+admin_username+"')and(me_ver='cn') order by YEARMONTH DESC ";
  123.                      }
  124.                    if((keyword.length()==0)&&(keyword2.length()!=0))
  125.  {
  126.   sql = "select YEARMONTH,c_id,VBELN,POSNR,ERDAT1,KWMENG,MENGE,zzsl,qjsl,ERDAT,ERZET,ARKTX,KUNNR from V_ZSD_ORDER ";
  127.        sql = sql + " where (VBELN like '%"+keyword2+"%')and(kunnr='"+admin_username+"')and(me_ver='cn') order by YEARMONTH DESC ";
  128.                      }  
  129.      rs=smt.executeQuery(sql);
  130. rs.last();
  131. intRowCount = rs.getRow(); //获取记录总数
  132. intPageCount = (intRowCount+intPageSize-1) / intPageSize; //记算总页数
  133. if(intPage>intPageCount) intPage = intPageCount; //调整待显示的页码
  134. %>
  135.        <table border="1" cellpadding="2" cellspacing="0" class="p9" bordercolor="#cccccc" bordercolordark="#FFFFFF" bordercolorlight="#cccccc" width="100%">
  136.          <tr> 
  137.    <td width="40" height="25" align="center"><strong><font color="#0000FF">年月</font></strong></td>
  138.    <td width="60" align="center"><strong><font color="#0000FF">订单号码</font></strong></td>
  139.    <td width="15" align="center"><strong><font color="#0000FF">编<br>号</font></strong></td>
  140.    <td width="60" align="center"><strong><font color="#0000FF">出货时间</font></strong></td>
  141.    <td width="60" align="center"><strong><font color="#0000FF">订单量<br>(TON)</font></strong></td>
  142.    <td width="60" align="center"><strong><font color="#0000FF">出货量<br>(TON)</font></strong></td>
  143.    <td width="40" align="center"><strong><font color="#0000FF">终止<br>交货量</font></strong></td>
  144.    <td width="50" align="center"><strong><font color="#0000FF">欠交量<br>(TON)</font></strong></td>
  145.    <td width="80" align="center"><strong><font color="#0000FF">商品名称</font></strong></td>
  146.    <td width="80" align="center"><strong><font color="#0000FF">最后更新<br>时间</font></strong></td>
  147.          </tr>               
  148.  <%
  149. if(intPageCount>0){
  150. //将记录指针定位到待显示页的第一条记录上
  151. rs.absolute((intPage-1) * intPageSize + 1);
  152. //显示数据
  153. i = 0;
  154. while(i<intPageSize && !rs.isAfterLast()){
  155. %>        
  156.          <tr> 
  157.    <td height="25" align="center"><%=rs.getString("YEARMONTH")%></td>
  158. <!--   <td align="center" ><a href="c_customer_order_detail.jsp?c_id=<%=rs.getInt("c_id")%>" target="_blank">
  159.            <font color="#0033FF"><%=rs.getString("VBELN").trim()%></font>
  160.            </a></td> -->
  161.    <td ><font color="#ff6600"><%=rs.getString("VBELN").trim()%></font></td>    
  162.    <td align="center" ><%=rs.getInt("POSNR")%></td>
  163.    <td align="center" ><%=rs.getDate("ERDAT1")%></td>    
  164.    <td ><%=rs.getString("KWMENG").trim()%></td>
  165.    <td ><%=rs.getString("MENGE").trim()%></td>
  166.    <td><%=rs.getString("zzsl").trim()%></td>
  167.    <td align="center"><font color="#ff6600"><%=rs.getString("qjsl")%></font></td>
  168.    <td align="center"><%=rs.getString("ARKTX")%></td>
  169.    <td width="80" align="center"><%=rs.getDate("ERDAT")%> <%=rs.getTime("ERZET")%></td>
  170.          </tr>
  171.          <%
  172. rs.next();
  173. i++;
  174. }
  175. }
  176. rs.close();
  177. %>
  178. <!--新闻列表-->
  179.       </table>
  180.       <br>
  181.       <table width="100%" cellspacing="0" cellpadding="0">
  182.         <tr> 
  183.           <td align="right">
  185. <div align="center"> <strong>分页显示:</strong> <FONT color=red>第<%=intPage%>页 
  186.                           共<%=intPageCount%>页 | 总<%=intRowCount%>条</FONT> 
  187.                           <%@include file="../include/showpage.jsp"%>
  188.                           &nbsp;&nbsp; 转到第
  189.                           <input type="text" name="goto_page1" value=<%=intPage%> class=box1 size=3 maxlength=3>
  190.                           页 
  191.                           <input style="height:19;WIDTH: 42px;" class="s02" hideFocus type="button" value="Go" name="cmd_goto" onclick="javascript:viewPage(document.all.goto_page1.value);">
  192.                         </div>
  193.                         </span> <form action="c_customer_order_list.jsp" method=post name="frm_page">
  194.                           <input type="hidden" name="page">
  195.                           <input type="hidden" name="column_id" value=<%=column_id%>>
  196.                           <input type="hidden" name="keyword" value=<%=keyword%>>
  197.   <input type="hidden" name="keyword2" value=<%=keyword2%>>
  198.                         </form>
  200. </td>
  201.         </tr>
  202.       </table></td>
  203.   </tr>
  204. </table>
  205. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
  206.   <tr> 
  207.     <td><img src="../images/spacer.gif" width="1" height="1"></td>
  208.   </tr>
  209. </table>
  210. <%@include file="../include/bottom02.jsp"%>
  211. </BODY>
  212. </HTML>