x_customer_detail.jsp
上传用户:zghglow
上传日期:2022-08-09
资源大小:27227k
文件大小:4k
源码类别:

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

开发平台:

JavaScript

  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. <HTML>
  8. <HEAD>
  9. <TITLE>+ + 翔鹭石化 + +</TITLE>
  10. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
  11. <link href="../style.css" rel="stylesheet" type="text/css">
  12. </HEAD>
  13. <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
  14. <%!String c_KUNNR;%>
  15. <%!String c_NAME1;%>
  16. <%!String c_STREET;
  17.    String c_TELF1;
  18.    String c_KNAME1;
  19.    String c_STREET1;
  20.    String c_PSTLZ;
  21.    Date c_ERDAT;
  22.    Time c_ERZET;
  23. %>
  24. <%
  25.  String c_id="";
  26.  String admin_username="";
  27.  String customer_name="";
  28.  c_id=request.getParameter("c_id");
  29.    sql = "select KUNNR,NAME1 from ZSD_KNA1 ";
  30.    sql = sql + " where c_id="+c_id;
  31.    rs=smt.executeQuery(sql);
  32. while(rs.next()){
  33. admin_username =rs.getString("KUNNR");
  34. customer_name   =rs.getString("NAME1");
  35. }
  36. // admin_username = (String)session.getAttribute("admin_username");
  37.  sql="SELECT KUNNR,NAME1,STREET,TELF1,KNAME1,STREET1,PSTLZ,ERDAT,ERZET FROM ZSD_KNA1 where KUNNR="+admin_username;
  38.  rs=smt.executeQuery(sql);
  39. while(rs.next()){
  40. c_KUNNR =rs.getString("KUNNR");
  41. c_NAME1      =rs.getString("NAME1");
  42. c_STREET =rs.getString("STREET");
  43. c_TELF1 = rs.getString("TELF1");
  44. c_KNAME1 = rs.getString("KNAME1");
  45. c_STREET1 = rs.getString("STREET1");
  46. c_PSTLZ = rs.getString("PSTLZ");
  47. c_ERDAT = rs.getDate("ERDAT");
  48. c_ERZET = rs.getTime("ERZET");
  49. }
  50. rs.close();
  51. rs.close();
  52. smt.close();
  53. conn.close();
  54. %>
  55. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  56.         <tr> 
  57.           <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
  58.         </tr>
  59.   <tr> 
  60.     <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
  61.     <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
  62.     <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
  63.   </tr>
  64.  
  65. </table>
  66. <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  67.   <tr> 
  68.     <td width="190" align="right" valign="top" bgcolor="f0f0f0">
  69. <!--子目录-->
  70. <%@include file="x_s2menu.jsp"%>
  71. <!--子目录-->
  72.  </td>
  73.     <td align="center" valign="top">
  74.         <table width="80%">
  75.   <tr>
  76.     <td >
  77.   <p align="center"><strong><font size="+2"><%=customer_name%></font></strong></p>
  78. </td>
  79.   </tr>
  80. </table>
  81.         <table width="80%">
  82.   <tr>
  83.     <td >
  84.   <p align="center"><strong><font size="3">基本信息</font></strong></p>
  85. </td>
  86.   </tr>
  87. </table>
  88.      <br>
  89.      <table width="85%" cellspacing="0" cellpadding="0">
  90.        <tr > 
  91.           <td><font color="#0033FF" size="+1"><strong>客户编号:</strong></font>
  92.  <font size="+1"><%=c_KUNNR%></font></td>
  93.        </tr>
  94.        <tr> 
  95.             <td><font color="#0033FF" size="+1"><strong>客户名称:</strong></font>
  96. <font size="+1"><%=c_NAME1%></font> </td>
  97.        </tr>
  98.        <tr> 
  99.          <td><font color="#0033FF" size="+1"><strong>客户地址:</strong></font>
  100. <font size="+1"><%=c_STREET%></font></td>
  101.         </tr>
  102.        <tr> 
  103.          <td><font color="#0033FF" size="+1"><strong>客户电话:</strong></font>
  104. <font size="+1"><%=c_TELF1%></font></td>
  105.         </tr>
  106.        <tr> 
  107.          <td><font color="#0033FF" size="+1"><strong>联 系 人:</strong></font>
  108. <font size="+1"><%=c_KNAME1%></font></td>
  109.         </tr>
  110.        <tr> 
  111.          <td><font color="#0033FF" size="+1"><strong>联系地址:</strong></font>
  112. <font size="+1"><%=c_STREET1%> </font></td>
  113.         </tr>
  114.        <tr> 
  115.          <td><font color="#0033FF" size="+1"><strong>邮政编码:</strong></font>
  116. <font size="+1"><%=c_PSTLZ%></font></td>
  117.         </tr>
  118.      </table>
  119.  <br><br><br>
  120.    <table width="85%" cellspacing="0" cellpadding="0">
  121.        <tr> 
  122.         <td><font color="#0033FF" size="+1"><strong>最后更新时间:</strong></font><font size="+1"><%=c_ERDAT%> <%=c_ERZET%></font></td>
  123.        </tr>    
  124.      </table>  
  125.  
  126.      </td>
  127.   </tr>
  128. </table>
  129. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
  130.   <tr> 
  131.     <td><img src="../images/spacer.gif" width="1" height="1"></td>
  132.   </tr>
  133. </table>
  134. <%@include file="../include/bottom02.jsp"%>
  135. </BODY>
  136. </HTML>