WEBWMS
/
asntoso.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}
	$sql="SELECT * FROM  `asntoso_v` ";
	$result=mysql_query($sql,$dbc);

?>
<html>
<head>
<title>SKU进出列表</title>
<script src="utils.js" type="text/javascript"></script>
<script src="asntoso.js" type="text/javascript"></script>
<link rel="stylesheet" href="./themes/base/jquery.ui.all.css">
<script src="jquery-1.9.1.js"></script>
<script src="./ui/jquery.ui.core.js"></script>
<script src="./ui/jquery.ui.widget.js"></script>
<script src="./ui/jquery.ui.mouse.js"></script>
<script src="./ui/jquery.ui.draggable.js"></script>
<script src="./ui/jquery.ui.position.js"></script>
<script src="./ui/jquery.ui.resizable.js"></script>
<script src="./ui/jquery.ui.button.js"></script>
<script src="./ui/jquery.ui.dialog.js"></script>
<link rel="stylesheet" href="demos.css">
<style type="text/css">
<!--
body {
	#background-color: #00FFF1;
	background:url(yh3.gif);
}
table {
	border-collapse : collapse;
	background-color: #FFFFF0;
}
.STYLE2 {
	background-color: #FFFFFF;
}
table#border{
border-top:#000 1px solid;
border-left:#000 1px solid;
}
table#border td{
border-bottom:#000 1px solid;
border-right:#000 1px solid;
}
-->
</style>
</head>
<body align="center">
<br/><p align="center"><b>进出列表<b><p></p><p>
<!--ASNID	SKU	SKUCN	UOMNUM	rLOC	LOTID	QTY	VCODE	ALCID 配货ID号	SOID SO编号	aqty 配货数量	pLOC 库位-->
<p>
<table align="center" border="1" cellpadding="3" cellspacing="3">
<tr bgcolor="LightSteelBlue"><td>ASNID</td><td>SKU</td><td>SKUCN</td><td>UOMNUM</td><td>rLOC</td><td>LOTID</td><td>QTY</td><td>ASN_Detail_ID</td><td>ALCID</td><td>SOID</td><td>aqty</td><td>pLOC</td></tr>
<?php while($rec_Row=mysql_fetch_assoc($result)){?>
<tr>
<td><?php echo $rec_Row['ASNID']?></td>
<td><?php echo $rec_Row['SKU']?></td>
<td><?php echo $rec_Row['SKUCN']?></td>
<td><?php echo $rec_Row['UOMNUM']?></td>
<td><?php echo $rec_Row['rLOC']?></td>
<td><?php echo $rec_Row['LOTID']?></td>
<td><?php echo $rec_Row['QTY']?></td>
<td><?php echo $rec_Row['VCODE']?></td>
<td><?php echo $rec_Row['ALCID']?></td>
<td><?php echo $rec_Row['SOID']?></td>
<td><?php echo $rec_Row['aqty']?></td>
<td><?php echo $rec_Row['pLOC']?></td>
</tr>
<?php } ?>
</table>
</body>
</html>