list.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n        <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=";
echo $PAGE_COUNT;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style=\"cursor:hand\"></a>\r\n\r\n      到\r\n      <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\"  class=\"SmallInput\">\r\n      页\r\n      <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onClick=\"set_page('";
echo $urlstr;
echo "')\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n    </td>\r\n    <td align=\"right\">\r\n      ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页&nbsp;共&nbsp;";
echo $CUSTOMER_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"95%\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=PRODUCT_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">产品名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "PRODUCT_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PRODUCT_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n       <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=SERVICE_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">服务名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SERVICE_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SERVICE_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=PRICE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">销售单价&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "PRICE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PRICE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=AMT&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">数量&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "AMT" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "AMT" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=TOTAL_PRICE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">总价&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "TOTAL_PRICE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTAL_PRICE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=DATE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">日期&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "DATE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "DATE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">客户名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=SELLER&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">销售员&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SELLER" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SELLER" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\">备注</td>\r\n  </tr>\r\n\r\n";
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$CUSTOMER_COUNT;
	$PRODUCT_NAME1 = $ROW['PRODUCT_NAME'];
	$MEMO1 = $ROW['MEMO'];
	$SERVICE_NAME1 = $ROW['SERVICE_NAME'];
	$PRICE1 = $ROW['PRICE'];
	$AMT1 = $ROW['AMT'];
	$TOTAL_PRICE1 = $ROW['TOTAL_PRICE'];
	$CREAT_DATE = $ROW['DATE'];
	$SELLER1 = $ROW['SELLER'];
	$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
	$TYPE1 = $ROW['TYPE'];
	$HISTORY_ID1 = $ROW['HISTORY_ID'];
	if ( $CUSTOMER_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n       <td nowrap align=\"center\">";
	echo $PRODUCT_NAME1;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $SERVICE_NAME1;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $PRICE1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $AMT1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $TOTAL_PRICE1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CREAT_DATE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CUSTOMER_NAME1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $SELLER1;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $MEMO1;
	echo "</td>\r\n    </tr>\r\n\r\n";
}
echo "</table>\r\n<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php'\">\r\n</div>\r\n\r\n\r\n</body>\r\n</html>\r\n";
?>