<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	//echo "abc";
	if(isset($_GET['id'])&& isset($_GET['show'])){
		$id=$_GET['id'];
		$sql= "SELECT * FROM `sod` WHERE `ID`=$id ";
		//echo $sql;
		$result=mysql_query($sql,$dbc);
		$totalRow = mysql_num_rows($result);
		if($totalRow>0){
			$table1='<table border="1" cellpadding="1" cellspacing="2" width="1024">';
			$table1=$table1.'
			<tr>
				<td>nID</td>
				<td>ID</td>
				<td>SOID</td>
				<td>ITEMNO</td>
				<td>SKU</td>
				<td>SKUCN</td>
				<td>SKUEN</td>
				<td>VEDCODE</td>
				<td>UOMNUM</td>
				<td>ALLOCQTY</td>
				<td>UNITPRICE</td>
				<td>TOTALPRICE</td>
				<td>NETWEIGHT</td>
				<td>TOTALNW</td>
				<td>REMARK1</td>
				<td>REMARK2</td>
			</tr>
			';
			//
			while($row_Rec=mysql_fetch_assoc($result)){
				$table1=$table1.'
				<tr>
					<td>'.$row_Rec['nID'].'</td>
					<td>'.$row_Rec['ID'].'</td>
					<td>'.$row_Rec['SOID'].'</td>
					<td>'.$row_Rec['ITEMNO'].'</td>
					<td>'.$row_Rec['SKU'].'</td>
					<td>'.$row_Rec['SKUCN'].'</td>
					<td>'.$row_Rec['SKUEN'].'</td>
					<td>'.$row_Rec['VEDCODE'].'</td>
					<td>'.$row_Rec['UOMNUM'].'</td>
					<td>'.$row_Rec['ALLOCQTY'].'</td>
					<td>'.$row_Rec['UNITPRICE'].'</td>
					<td>'.$row_Rec['TOTALPRICE'].'</td>
					<td>'.$row_Rec['NETWEIGHT'].'</td>
					<td>'.$row_Rec['TOTALNW'].'</td>
					<td>'.$row_Rec['REMARK1'].'</td>
					<td>'.$row_Rec['REMARK2'].'</td>
				</tr>';
				//echo $table1;
			}		
			$table1=$table1.'</table>';		
			//echo $table1;
			$obj->result=1;
			$obj->status=1;
			$obj->table=$table1;
			$obj->reasons="load Detail complete";
			echo json_encode($obj);	
		}else{
			$obj->result=0;
			$obj->status=0;
			$obj->reasons="No Detail Info";
			echo json_encode($obj);
		}
		return;
	}
/*nID	ID	SOID SO编号	ITEMNO 子行号	SKU 商品编码	SKUCN 商品中文名	SKUEN 商品英文名	VEDCODE 供应商代码	UOMNUM 需求数量	ALLOCQTY 配货数量	UNITPRICE 单价	TOTALPRICE 总价格	NETWEIGHT 净重	TOTALNW 总净重	REMARK1 备注1	REMARK2 备注2
*/
?>