//[Obsolete("Use GetStockLot")]
static public DataTable GetLotDetails(string LotID)
{
Query q = new StoredProc("usp_GetLotDetails");
q.Parameters.AddWithValue("@LOTID", LotID);
return(q.ExecuteDataTable());
}
private void LoadData()
{
Query q = new StoredProc("usp_GetSalesShipmentProcessResults");
q.Parameters.AddWithValue("@sordernbr", soNbr);
DataSet ds = q.ExecuteDataSet();
expectedTable = ds.Tables[0];
expectedTable.TableName = "Expected";
processedTable = ds.Tables[1];
processedTable.TableName = "Processed";
FillTableList();
}
private void LoadData()
{
Query q = new StoredProc("usp_GetReceiptProcessResults");
q.Parameters.AddWithValue("@pordernbr", poNbr);
DataSet ds = q.ExecuteDataSet();
expectedTable = ds.Tables[0];
expectedTable.TableName = "Expected";
processedTable = ds.Tables[1];
processedTable.TableName = "Processed";
discrepantTable = ds.Tables[2];
discrepantTable.TableName = "Discrepancies";
FillTableList();
}