x_customer_detail.jsp
资源名称:shihua.rar [点击查看]
上传用户:zghglow
上传日期:2022-08-09
资源大小:27227k
文件大小:4k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
JavaScript
- <%@ page contentType="text/html;charset=gb2312"%>
- <%@include file="../include/checkadmin.jsp"%>
- <%@page import="java.sql.*"%>
- <%@include file="../include/db_conn.jsp"%>
- <%@include file="../include/const.jsp"%>
- <%@include file="../include/isNotInteger.jsp"%>
- <HTML>
- <HEAD>
- <TITLE>+ + 翔鹭石化 + +</TITLE>
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
- <link href="../style.css" rel="stylesheet" type="text/css">
- </HEAD>
- <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
- <%!String c_KUNNR;%>
- <%!String c_NAME1;%>
- <%!String c_STREET;
- String c_TELF1;
- String c_KNAME1;
- String c_STREET1;
- String c_PSTLZ;
- Date c_ERDAT;
- Time c_ERZET;
- %>
- <%
- String c_id="";
- String admin_username="";
- String customer_name="";
- c_id=request.getParameter("c_id");
- sql = "select KUNNR,NAME1 from ZSD_KNA1 ";
- sql = sql + " where c_id="+c_id;
- rs=smt.executeQuery(sql);
- while(rs.next()){
- admin_username =rs.getString("KUNNR");
- customer_name =rs.getString("NAME1");
- }
- // admin_username = (String)session.getAttribute("admin_username");
- sql="SELECT KUNNR,NAME1,STREET,TELF1,KNAME1,STREET1,PSTLZ,ERDAT,ERZET FROM ZSD_KNA1 where KUNNR="+admin_username;
- rs=smt.executeQuery(sql);
- while(rs.next()){
- c_KUNNR =rs.getString("KUNNR");
- c_NAME1 =rs.getString("NAME1");
- c_STREET =rs.getString("STREET");
- c_TELF1 = rs.getString("TELF1");
- c_KNAME1 = rs.getString("KNAME1");
- c_STREET1 = rs.getString("STREET1");
- c_PSTLZ = rs.getString("PSTLZ");
- c_ERDAT = rs.getDate("ERDAT");
- c_ERZET = rs.getTime("ERZET");
- }
- rs.close();
- rs.close();
- smt.close();
- conn.close();
- %>
- <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
- <tr>
- <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
- </tr>
- <tr>
- <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
- <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
- <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
- </tr>
- </table>
- <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
- <tr>
- <td width="190" align="right" valign="top" bgcolor="f0f0f0">
- <!--子目录-->
- <%@include file="x_s2menu.jsp"%>
- <!--子目录-->
- </td>
- <td align="center" valign="top">
- <table width="80%">
- <tr>
- <td >
- <p align="center"><strong><font size="+2"><%=customer_name%></font></strong></p>
- </td>
- </tr>
- </table>
- <table width="80%">
- <tr>
- <td >
- <p align="center"><strong><font size="3">基本信息</font></strong></p>
- </td>
- </tr>
- </table>
- <br>
- <table width="85%" cellspacing="0" cellpadding="0">
- <tr >
- <td><font color="#0033FF" size="+1"><strong>客户编号:</strong></font>
- <font size="+1"><%=c_KUNNR%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>客户名称:</strong></font>
- <font size="+1"><%=c_NAME1%></font> </td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>客户地址:</strong></font>
- <font size="+1"><%=c_STREET%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>客户电话:</strong></font>
- <font size="+1"><%=c_TELF1%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>联 系 人:</strong></font>
- <font size="+1"><%=c_KNAME1%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>联系地址:</strong></font>
- <font size="+1"><%=c_STREET1%> </font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1"><strong>邮政编码:</strong></font>
- <font size="+1"><%=c_PSTLZ%></font></td>
- </tr>
- </table>
- <br><br><br>
- <table width="85%" cellspacing="0" cellpadding="0">
- <tr>
- <td><font color="#0033FF" size="+1"><strong>最后更新时间:</strong></font><font size="+1"><%=c_ERDAT%> <%=c_ERZET%></font></td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
- <tr>
- <td><img src="../images/spacer.gif" width="1" height="1"></td>
- </tr>
- </table>
- <%@include file="../include/bottom02.jsp"%>
- </BODY>
- </HTML>