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

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

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

开发平台：

JavaScript

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