WEBWMS
/
loc.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}

	$sql = "SELECT * FROM loc";

	$result = mysql_query($sql,$dbc);
	$row_Rec = mysql_fetch_assoc($result);
	//echo $row_Rec['ID'];
	//ID	LOCID	LOCCODE	LOCTYPE	LOCATTR	REMARK
?>
<html>
<head>
<title>库位管理</title>
<script src="utils.js" type="text/javascript"></script>
<script src="loc.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: #FFFFFF;
}
.STYLE2 {
	background-color: #FFFFFF;
}
-->
</style>
</head>
<body>

<br/><p align="center"><b>库位信息管理<b><p></p><p>
	<div align="center">&nbsp;&nbsp;
		<button type="button" id="addNew">新增</button>&nbsp;&nbsp;
		<input name="researcht" type="text" id="researcht" value="请输入查找内容(可模糊查询)"/>&nbsp;&nbsp;
		<button type="button" id="researchb">查找</button>&nbsp;&nbsp;
		<br/><br/><br/>
		<div id="showArea" class='STYLE2' align="center"></div>
		<div id="alldate">
			<table border="1">
				<tr>
					<td>ID</td>
					<td>LOC-ID(库位编码)</td>
					<td>LOC-CODE(库位号)</td>
					<td>LOC-TYPE(库位类型)</td>
					<td>LOC-ATTR(库位属性)</td>
					<td>LOC-REMARK(库位备注)</td>
					<td align="center">&nbsp;&nbsp;操作&nbsp;&nbsp;</td>
				</tr>
				<?php do {?>
				<tr>
					<td><?php echo $row_Rec['ID']; ?></td>
					<td><?php echo $row_Rec['LOCID']; ?></td>
					<td><?php echo $row_Rec['LOCCODE']; ?></td>
					<td><?php echo $row_Rec['LOCTYPE']; ?></td>
					<td><?php echo $row_Rec['LOCATTR']; ?></td>
					<td><?php echo $row_Rec['REMARK']; ?></td>
					<td>
						<a href="#" id="<?php echo $row_Rec['ID']; ?>">Onhold</a>
						|
						<a href="#" id="<?php echo $row_Rec['ID']; ?>">FreeHod</a>
						|
						<a href="#" id="<?php echo $row_Rec['ID']; ?>">Modify</a>
						|
						<a href="#" id="<?php echo $row_Rec['ID']; ?>">Delete</a>
					</td>
				</tr>
				<?php } while($row_Rec=mysql_fetch_assoc($result));?>
			</table>
		</div>
	</div>
</body>
</html>