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);
        }