<?php
	
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	
	$id=' ';
	
	//if(isset($_POST['id']) && isset($_POST['delsure'])){\
	if(isset($_GET['id']) && isset($_GET['delsure'])){
		//echo 'del id id';
		//$id = $_POST['id'];
		//echo $_GET['delsure'];
		
		$id = $_GET['id'];
		
		$sql="SELECT nID, ID FROM asnd WHERE nID =$id";
		//echo $sql;
		$result1 = mysql_query($sql,$dbc);
		$row_Rec1 = mysql_fetch_assoc($result1);
		$id2 = $row_Rec1['ID'];
		//echo '<br>';
		//echo $id2;
		$sql="DELETE FROM webwms.asnd WHERE asnd.nID = $id";
		//echo '<br>';
		//echo $sql;
		mysql_query($sql,$dbc);		
		
		
		
		//echo '';
		
		$sql = "SELECT nID,	ID,	ASNID, ITEMNO,	SKU, SKUCN,	SKUEN, VEDCODE,	UOM, UOMNUM, ";
		$sql = $sql."FDUNIT, TWEIGHT, UNITWEIGHT, SKUN,CUSTMITEM,COO,UNITPRICE,TPRICE,LOC FROM asnd WHERE ID=$id2 ";
		
		$result = mysql_query($sql,$dbc);
		$row_Rec = mysql_fetch_assoc($result);
		
		$strHtml = "";
		$strHtml = $strHtml."<table border='1'>";
		$strHtml = $strHtml."<tr>";
		$strHtml = $strHtml."<td>nID</td>";
		$strHtml = $strHtml."<td>ID</td>";
		$strHtml = $strHtml."<td>ASNID</td>";
		$strHtml = $strHtml."<td>ITEMNO</td>";
		$strHtml = $strHtml."<td>SKU</td>";
		$strHtml = $strHtml."<td>SKUCN</td>";
		$strHtml = $strHtml."<td>SKUEN</td>";
		$strHtml = $strHtml."<td>VEDCODE</td>";
		$strHtml = $strHtml."<td>UOM</td>";
		$strHtml = $strHtml."<td>UOMNUM</td>";
		$strHtml = $strHtml."<td>FDUNIT</td>";
		$strHtml = $strHtml."<td>TWEIGHT</td>";
		$strHtml = $strHtml."<td>UNITWEIGHT</td>";
		$strHtml = $strHtml."<td>SKUN</td>"; 
		$strHtml = $strHtml."<td>CUSTMITEM</td>"; 
		$strHtml = $strHtml."<td>COO</td>"; 
		$strHtml = $strHtml."<td>UNITPRICE</td>"; 
		$strHtml = $strHtml."<td>TPRICE</td>"; 
		$strHtml = $strHtml."<td>LOC</td>"; 
		$strHtml = $strHtml."<td>操作</td>"; 
		$strHtml = $strHtml."</tr>";
		do{
			$strHtml = $strHtml."<tr>";
			$strHtml = $strHtml."<td>".$row_Rec['nID']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['ID']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['ASNID']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['ITEMNO']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['SKU']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['SKUCN']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['SKUEN']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['VEDCODE']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['UOM']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['UOMNUM']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['FDUNIT']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['TWEIGHT']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['UNITWEIGHT']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['SKUN']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['CUSTMITEM']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['COO']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['UNITPRICE']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['TPRICE']."</td>";
			$strHtml = $strHtml."<td>".$row_Rec['LOC']."</td>";
			$strHtml = $strHtml."<td>";
			$strHtml = $strHtml."<a href=\"#\" id=\"".$row_Rec['nID']."\" id2=\"".$row_Rec['ID']."\" >DEL</a>";
			$strHtml = $strHtml."&nbsp;&nbsp;|&nbsp;&nbsp;";
			$strHtml = $strHtml."<a href=\"#\" id=\"".$row_Rec['nID']."\">MODIFY</a>";
			$strHtml = $strHtml."</td>";
			$strHtml = $strHtml."</tr>";
		} while($row_Rec = mysql_fetch_assoc($result));
		$strHtml = $strHtml."</table>";
		
		echo $strHtml;
		mysql_close($dbc);
		return;
	}
	
	if(isset($_GET['id'])){
		$id = $_GET['id'];
		
		echo 'ID为：'.$id.'<br>';
		echo '你确认要删除这条收货明细吗?<br>';
		echo 'Do you sure to Delete this ASN detail?<br>';
		//echo '<form action="delasn.php" method="POST">';
		echo '<input name="id" type="hidden" id="id" value="'.$id.'"/>';
		echo '<input name="delsure" type="hidden" id="delsure" value="ture" />';
		echo '<input type="submit" name="Submit" value="(是的)YES DO IT" onclick="javascript:updataDetail('.$id.');" />';
		//echo '</form>';
		
	}
?>