transaction_list_page_display.jsp
<%@ 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="????????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="????????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="?????????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();
}
%>