private void DeleteWorkplace(string sql)
{
ProductWorkplaceCollection oWorkplaceList = ProductWorkplace.LoadCollection(sql);
foreach (ProductWorkplace oWorkplace in oWorkplaceList)
{
oWorkplace.Delete();
}
}
/// <summary>
/// Gets the on hand qty.
/// </summary>
/// <param name="workplaceId">The workplace id.</param>
/// <param name="productId">The product id.</param>
/// <returns></returns>
private decimal GetOnHandQty(Guid workplaceId, Guid productId)
{
string query = "ProductId = '" + productId.ToString() + "' AND WorkplaceId = '" + workplaceId.ToString() + "'";
ProductWorkplace oPw = ProductWorkplace.LoadWhere(query);
if (oPw != null)
{
return(oPw.CDQTY);
}
else
{
return(0);
}
}
