public ExecutionResult GetPalletByProductType(string productType) { var exeResult = RouteDAO.GetPalletInfo(productType); if (exeResult.Status) { var ds = (DataSet)exeResult.Anything; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string palletSize = ds.Tables[0].Rows[0]["PALLET_SIZE"].ToString(); exeResult.Anything = palletSize; } } return(exeResult); }