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

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

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

开发平台：

JavaScript

x_customer_yf_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. <%
  9.  String c01="";
  10.  int i01;
  11.  i01 = 0;
  12.  
  13. keyword=request.getParameter("keyword");
  14. if(keyword==null){
  15. keyword="";
  16. }else{
  17. keyword=getGBString(keyword);
  18. }
  20.  String c_id="";
  21.  String admin_username="";
  22.  String customer_name="";
  23.  c_id=request.getParameter("c_id");
  25.    sql = "select KUNNR,NAME1 from ZSD_KNA1 ";
  26.    sql = sql + " where c_id="+c_id;
  27.    rs=smt.executeQuery(sql);
  28. while(rs.next()){
  29. admin_username =rs.getString("KUNNR");
  30. customer_name   =rs.getString("NAME1");
  31. }
  33. %>
  36. <HTML>
  37. <HEAD>
  38. <TITLE>+ + 翔鹭石化 + +</TITLE>
  39. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
  40. <link href="../style.css" rel="stylesheet" type="text/css">
  41. </HEAD>
  42. <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
  43. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  44.         <tr> 
  45.           <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
  46.         </tr>
  48.   <tr> 
  49.     <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
  50.     <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
  51.     <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
  52.   </tr>
  53.  
  54. </table>
  56. <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  57.   <tr> 
  58.     <td>&nbsp;</td>
  59.     <td align="right" valign="top" bgcolor="f0f0f0">
  60. <!--子目录-->
  61. <%@include file="x_s2menu.jsp"%>
  62. <!--子目录-->
  63.       <table width="100%" cellspacing="0" cellpadding="0" >
  64.         <tr> 
  65.           <td><img src="../images/in1left.gif" width="165" height="100">
  66.         </tr>
  67.       </table>
  68.   </td>      
  69.     <td align="center" valign="top">
  70.         <table width="80%">
  71.   <tr>
  72.     <td >
  73.   <p align="center"><strong><font size="+2"><%=customer_name%></font></strong></p>
  74. </td>
  75.   </tr>
  76.   <tr>
  77.     <td >
  78.   <p align="center"><strong><font size="3">承运商运费</font></strong></p>
  79. </td>
  80.   </tr>
  81.   <form name="frm_search" action="x_customer_yf_list.jsp" method="post">
  82.     <tr> 
  83.       <td align="left" bgcolor="#ffffff" height=20>请输入查询年度：<input type="text" name="keyword">　<input type="submit" name="s1" value="搜 索" style="width:60px;height:22px;"></td>
  84.     </tr>
  85. <input type="hidden" name="c_id" value=<%=c_id%>>
  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 = 12; //设置一页显示的记录数
  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. }
  111. sql = "select c_id,KUNNR,ZYEAR,ZMONTH,FKIMG,KBETR,NETWR,ERDAT,ERZET from ZSD_YF ";
  112. sql = sql + " where (kunnr='"+admin_username+"')and(me_ver='cn') order by ZYEAR DESC,ZMONTH DESC ";
  113.                    if(keyword.length()!=0)
  114.  {
  115.                     sql = "select c_id,KUNNR,ZYEAR,ZMONTH,FKIMG,KBETR,NETWR,ERDAT,ERZET from ZSD_YF ";
  116.        sql = sql + " where (ZYEAR like '%"+keyword+"%')and(kunnr='"+admin_username+"')and(me_ver='cn') order by ZYEAR DESC,ZMONTH DESC ";
  117.                      }
  119.      rs=smt.executeQuery(sql);
  120. rs.last();
  121. intRowCount = rs.getRow(); //获取记录总数
  122. intPageCount = (intRowCount+intPageSize-1) / intPageSize; //记算总页数
  123. if(intPage>intPageCount) intPage = intPageCount; //调整待显示的页码
  124. %>
  125.        <table border="1" cellpadding="2" cellspacing="0" class="p9" bordercolor="#cccccc" bordercolordark="#FFFFFF" bordercolorlight="#cccccc" width="95%">
  126.          <tr> 
  127.    <td height="25" width="55" align="center"><strong><font color="#0000FF">客户编号</font></strong></td>
  128.    <td width="28" align="center"><strong><font color="#0000FF">年度</font></strong></td>
  129.    <td width="28" align="center"><strong><font color="#0000FF">月份</font></strong></td>
  130.    <td width="90" align="center"><strong><font color="#0000FF">销售数量(TON)</font></strong></td>
  131.    <td width="90" align="center"><strong><font color="#0000FF">运费单价(RMB)</font></strong></td>
  132.    <td width="90" align="center"><strong><font color="#0000FF">运费总额(RMB)</font></strong></td>
  133.    <td width="115" align="center"><strong><font color="#0000FF">最后更新时间</font></strong></td>
  134.          </tr>               
  135.  <%
  136. if(intPageCount>0){
  137. //将记录指针定位到待显示页的第一条记录上
  138. rs.absolute((intPage-1) * intPageSize + 1);
  139. //显示数据
  140. i = 0;
  141. while(i<intPageSize && !rs.isAfterLast()){
  142. %>        
  143.          <tr> 
  144.    <td height="25" width="55"  align="center"><%=rs.getString("KUNNR")%></td>
  145.    <td align="center"><%=rs.getString("ZYEAR")%></td>
  146.    <td align="center"><%=rs.getString("ZMONTH")%></td>
  147.    <td align="center"><%=rs.getString("FKIMG")%></td>
  148.    <td align="center">
  149.    <%
  150.    c01=rs.getString("KBETR");
  151.    i01=rs.getInt("KBETR");
  152.    %>
  153.    <% if(i01==0){%>
  154.    --
  155.    <%}
  156.    else {
  157.    %>
  158.    <%=c01%>
  159.    <% }%></td>
  160.    <td align="center"><font color="#ff6600">
  161.    <% if(i01==0){%>
  162.    --
  163.    <%}
  164.    else {
  165.    %>
  166.    <%=rs.getString("NETWR")%>%
  167.    <% }%>
  168.    </font></td>
  169.    <td width="115" 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="x_customer_yf_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="c_id" value=<%=c_id%>>
  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>