<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="com.silence.market.*"%>
<%@include file="../common/public.jsp"%>
<html>
<head>
<title>商品信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script type="text/javascript" src="../js/validation.js"></script>
<link href="../css/book.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<script language="javascript">
function del_project()
{
if(find()>=1)
{
if(confirm("确实要删除选中项吗？"))
{
document.queryFrm.action="transaction_control.jsp?actiontype=del&id=ok";
document.queryFrm.submit();
}else{
return;
}
} else {
alert("只有选择至少一项，才能进行操作");
return;
}
}
//检查是否为任意数（实数）
function isNumeric(strNumber) {
var newPar=/^(- |\+)?\d+(\.\d+)?$/
return newPar.test(strNumber);
}
//检查是否为正数
function isUnsignedNumeric(strNumber) {
var newPar=/^\d+(\.\d+)?$/
return newPar.test(strNumber);
}
//检查是否为整数
function isInteger(strInteger) {
var newPar=/^(- |\+)?\d+$/
return newPar.test(strInteger);
}
//检查是否为正整数
function isUnsignedInteger(strInteger) {
var newPar=/^\d+$/
return newPar.test(strInteger);
}
</script>
<body leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/bid_title.jpg.jpg" width="1024" height="100"></td>
</tr>
</table>
<%
try {
request.setCharacterEncoding("GBK");
String sFileName = "transaction_list_page_display.jsp";
int intPerPageNum = request.getParameter("sPerPage")==null?10:Integer.parseInt(request.getParameter("sPerPage"));
int intPageNo = request.getParameter("sPageNo")==null?1:Integer.parseInt(request.getParameter("sPageNo"));
int nRows = 0;
int nPages = 0;
String sPageNo = String.valueOf(intPageNo);
String sPerPage = String.valueOf(intPerPageNum);
String strCondition = " 1 = 1 and s_status = '0' ";
//按查询条件查询
//类别
String conType = request.getParameter("con_type")==null?"":request.getParameter("con_type");
if(!conType.equals("")){
strCondition = strCondition + " and s_transaction_type = '" + conType + "' ";
}
//标题
String conTitle = request.getParameter("con_title")==null?"":request.getParameter("con_title");
if(!conTitle.equals("")){
strCondition = strCondition + " and s_transaction_title like '%" + conTitle + "%' ";
}
//发布人
String conArtID = request.getParameter("con_art_id")==null?"":request.getParameter("con_art_id");
if(!conArtID.equals("")){
strCondition = strCondition + " and s_art_id = '" + conArtID + "' ";
}
//产品目录
String conCatID = request.getParameter("con_cat_id")==null?"":request.getParameter("con_cat_id");
if(!conCatID.equals("")){
strCondition = strCondition + " and s_cat_id like '%" + conCatID + "%' ";
}
//日期
String conTimeIssue = request.getParameter("con_time_issue")==null?"":request.getParameter("con_time_issue");
if(!conTimeIssue.equals("")){
strCondition = strCondition + " and d_time_issue = '" + conTimeIssue + "' ";
}
//最低价格
int conPriceMin = request.getParameter("con_price_min")==null?0:Integer.parseInt(request.getParameter("con_price_min"));
if(conPriceMin!=0){
strCondition = strCondition + " and n_price_min >= " + conPriceMin + " ";
}
//最高价格
int conPriceMax = request.getParameter("con_price_max")==null?0:Integer.parseInt(request.getParameter("con_price_max"));
if(conPriceMax!=0){
strCondition = strCondition + " and n_price_max <= " + conPriceMax + " ";
}
//查询结果放在类对象里面
TransactionManager tempManager = new TransactionManager();
Transaction[] temps = tempManager.getAllTransaction("",strCondition," order by n_uid desc ", intPageNo, intPerPageNum);
nRows = tempManager.getRows();
nPages = (nRows - 1 + Integer.parseInt(sPerPage))/Integer.parseInt(sPerPage);
int pageCount = nPages;
Transaction temp = new Transaction();
%>
<form method="post" name="queryFrm" action=<%=sFileName%>>
<div id="Layer1" style="position:absolute; left:30px; top:100px; width:800px; height:94px; z-index:1">
<table border=0 cellpadding=0 cellspacing=1 align="left" width="800">
<tr>
<td colspan="7" height="32"><span class="clsNav"><img src="../images/messages2.gif" width="16" height="15">您当前的位置>>供求信息>>供求信息列表</span>
<hr noshade class="clsHLine"></td>
</tr>
<%
String strCondition1 = " 1=1 ";
TransactionCatManager tempManager1 = new TransactionCatManager();
TransactionCat[] temps1 = tempManager1.getAllTransactionCat("",strCondition1," order by s_cat_grade", 1, 500);
TransactionCat temp1 = new TransactionCat();
//查询条件
%>
<tr><td><table><tr>
<td>产品目录：
<select class="Comm" name="con_cat_id">
<option value="" >--</option>
<!--这里是一级产品目录-->
<%
String catid1="";
for(int i1=0;i1<temps1.length;i1++)
{
temp1=temps1[i1];
if(temp1.getCatGrade().equals("1"))
{
catid1=temp1.getCatID();
%>
<option value="<%=temp1.getCatID()%>" <%if(conCatID.equals(temp1.getCatID())){%>selected<%}%> >
<%=temp1.getCatName()%>
</option>
<!--这里是二级产品目录-->
<%String catid2="";
for(int i2=0;i2<temps1.length;i2++)
{
temp1=temps1[i2];
if(temp1.getCatGrade().equals("2")&&temp1.getCatParentID().equals(catid1))
{
catid2=temp1.getCatID();
%>
<option value="<%=temp1.getCatID()%>" <%if(conCatID.equals(temp1.getCatID())){%>selected<%}%> >
<%=temp1.getCatName()%>
</option>
<!--这里是三级产品目录-->
<%
String catDiscribetion3="";
for(int i3=0;i3<temps1.length;i3++)
{
temp1=temps1[i3];
if(temp1.getCatGrade().equals("3")&&temp1.getCatParentID().equals(catid2))
{
String s3CatID=temp1.getCatID();
%>
<option value="<%=s3CatID%>" <%if(conCatID.equals(s3CatID)){%>selected<%}%> >
<%=temp1.getCatName()%>
<%if(temp1.getCatDiscribetion()!=null){%>
(<%=temp1.getCatDiscribetion()%>)<%}%>
</option>
<%}
}
}
}
}
}%>
</select>
</td>
<td>标题
<input name="con_title" type="text" class="Comm" value="<%=conTitle%>" size="15" maxlength="50"></td>
<td>发布人
<input name="con_art_id" type="text" class="Comm" size="15" value="<%=conArtID%>" maxlength="50">
</input>
</td>
<td>日期:
<input name="con_time_issue" type="text" class="Comm" value="<%=conTimeIssue%>" size="15" maxlength="50">
</input>
</td>
<td>最低价:
<input name="con_price_min" type="text" class="Comm" size="15" value="<%=conPriceMin%>" maxlength="50">
</input>
</td>
<td>最高价:
<input name="con_price_max" onFocus="isNumeric(con_price_max.value)" type="text" class="Comm" size="15" value="<%=conPriceMax%>" maxlength="50">
</input>
<input name="con_type" type="hidden" value="<%=conType%>"></input>
</td>
<td>
<input type="submit" onClick="isNumeric(con_price_max.value)" name="Submit" value="查询" class="button1">
</td>
</tr>
</table>
</td>
</tr>
<tr></tr>
<tr>
<td><table width="800">
<tr align="center" class="clsMenu1">
<td width="30"><font size="3">编号</font></td>
<td width="97"><font size="3">相关图片</font></td>
<td width="454"><font size="3">供应商品信息/联系人</font></td>
<td width="40"><font size="3">价格(元)</font></td>
<td width="25"><font size="3">数量</font></td>
<td width="40"><font size="3">日期</font></td>
<td width="65"><font size="3">操作</font></td>
</tr>
</table></td>
<td></td>
</tr>
<%//////////////////////////////
for(int index=0;index<temps.length;index++){
temp=temps[index];
%>
<tr>
<td width="600">
<!--内部表111111111111111111111-->
<table align="left" width="800" border="0">
<tr>
<DIV class=offer13j>
<DIV class=offerbackground33j id=compareColor3>
<td width="30"><%=temp.getUid()%>
</td>
<td width="104"> <DIV class=comparecheck3j>
<a href="#"
target=_blank> <img src="../<%=sessionFilesPic%><%=temp.getPicSmall()%>" alt="" width="100" height="100"
style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px">
</a> </DIV></td>
<td width="12"> <DIV class=picture3j> <A class=m
onmousedown="aliclick(this,'?tracelog=po_listsell_1_3_j_3');addParam(this,'keywords','')"
href="http://detail.china.alibaba.com/buyer/offerdetail/34574566.html"
target=_blank> </A> </DIV></td>
<td width="416"> <DIV class=content3j>
<DIV class=info3j> <SPAN class=m> <A href="transaction_single.jsp?id=<%=temp.getUid()%>" target=_blank><%=temp.getTransactionTitle()%></A>
</SPAN> <NOBR><SPAN class=gray><%=FormatManager.getDateFormat10(temp.getTimeIssue())%></SPAN></NOBR><BR>
<SPAN class="gray s">
<%=temp.getTransactionText()%></SPAN><BR>
<A href="#" target=_blank>
<%if(temp.getManConnect()!=null){%>
联系人：<%=temp.getManConnect()%>
<%}%>
<%if(temp.getPhoneConnect()!=null){%>
手机：<%=temp.getPhoneConnect()%>
<%}%>
<%if(temp.getMobileConnect()!=null){%>
电话：<%=temp.getMobileConnect()%>
<%}%>
</A>
<DIV class=gray align=right>
<%if(temp.getAddressConnect()!=null){%>
[
<%=temp.getAddressConnect()%>
]
<%}%>
</DIV>
</DIV>
</DIV>
</td>
<td width="40"> <DIV class=myt3j style="LINE-HEIGHT: 150%">
<%=temp.getPriceMin()%>~<%=temp.getPriceMax()%> /公斤<BR>
</DIV></td>
<td width="25"> <DIV class=athena3j>
<SPAN><A onmousedown="return aliclick(this,'?tracelog=list_cxpd_tpbz')" title=点击查看该公司信用资料
href="#" target=_blank><IMG height=14 src="%CD%F8%D5%BE/scon_buyer_1_1.files/trust.gif" width=22 align=middle
border=0><BR>
<%=temp.getQtyIssue()%></A></SPAN></DIV>
<td width="30"><DIV class=hackbox><%=FormatManager.getDateFormat10(temp.getTimeIssue())%></DIV></td>
<td width="65"><a
href="javascript:f572628('34574566','jxnb440483','isOnline','','pm')"><img
src="%CD%F8%D5%BE/scon_buyer_1_1.files/list_mytlogo_online.gif" border=0></a><a
href="javascript:f572628('34574566','jxnb440483','isOnline','','pm')"><span
class=lh15><br>
跟我协商</span></a>
<br>
<a href="#" title="查看详细信息" onClick="window.open('transaction_single.jsp?id=<%=temp.getUid()%>','', 'toolbar=no, menubar=no,scrollbars=yes, resizable=yes')">[查看]</a>
</td>
</DIV>
</DIV>
</tr>
</table>
</td>
</tr>
<%
}%>
<tr>
<td width="600">
<!--内部表2222222222222222222222-->
<table align="left" width="800" border="0">
<tr>
<DIV class=offer13j>
<DIV class=offerbackground33j id=compareColor3>
<td><INPUT id=compareBox3
onclick=javascript:clickcompareBox(34574566,this); type=checkbox value=on
name=34574566></td>
<td> <DIV class=comparecheck3j>
<a href="#"
target=_blank> <img src="../<%=sessionFilesPic%><%=temp.getPicSmall()%>" alt="" width="100" height="100"
style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px">
</a> </DIV></td>
<td> <DIV class=picture3j> <A class=m
onmousedown="aliclick(this,'?tracelog=po_listsell_1_3_j_3');addParam(this,'keywords','')"
href="http://detail.china.alibaba.com/buyer/offerdetail/34574566.html"
target=_blank> </A> </DIV></td>
<td> <DIV class=content3j>
<DIV class=info3j>
<SPAN class=m> <A href="#" target=_blank><%=temp.getTransactionTitle()%></A> </SPAN>
<NOBR><SPAN class=gray><%=FormatManager.getDateFormat10(temp.getTimeIssue())%>2006-06-03 09:38:36</SPAN></NOBR><BR>
<SPAN class="gray s"><%=temp.getTransactionTitle()%>KD-1280型注塑机系参考了欧洲名牌后模板联体结构注塑机的设计理念，具有选材优良，结构先进、造型美观，操?...</SPAN><BR>
<A href="#" target=_blank><%=temp.getTransactionTitle()%>宁波市金星塑料机械有限公司</A>
<DIV class=gray align=right>[<%=temp.getTransactionTitle()%>浙江宁波市]</DIV>
</DIV>
</DIV></td>
<td> <DIV class=myt3j style="LINE-HEIGHT: 150%"> <A
href="javascript:f572628('34574566','jxnb440483','isOnline','','pm')"><IMG
src="%CD%F8%D5%BE/scon_buyer_1_1.files/list_mytlogo_online.gif" border=0><BR>
<SPAN
class=lh15>跟我洽谈</SPAN></A> </DIV></td>
<td> <DIV class=athena3j>
<SPAN><A onmousedown="return aliclick(this,'?tracelog=list_cxpd_tpbz')" title=点击查看该公司信用资料
href="#" target=_blank><IMG height=14 src="%CD%F8%D5%BE/scon_buyer_1_1.files/trust.gif" width=22 align=middle
border=0><BR>54</A></SPAN>
</DIV>
</td>
<td> <DIV class=address3j> <A
href="http://trust.alibaba.com.cn/credit/hkaq.shtml?tracelog=list_c01_dupai"
target=_blank><IMG alt=使用支付宝付款，交易更安全 src="%CD%F8%D5%BE/scon_buyer_1_1.files/logo_alipay.gif"
border=0></A> <BR>
<BR>
</DIV></td>
<td><DIV class=hackbox></DIV></td>
</DIV>
</DIV>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan=20 valign="top" class="clsBgColor1">
<%@include file="../common/page_deal.jsp"%>
</tr>
</table>
</div>
</form>
</body>
</html>
<%
} catch(Exception e){
String strErr = e.getMessage();
onError(request,response,strErr,"","window.close();");
e.printStackTrace();
}
%>