/// <summary>
        /// 連動下拉單查詢交易品項
        /// </summary>
        /// <param name="MaterialCategoriesId"></param>
        /// <returns></returns>
        public Task <ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > > GetBussinessItemsListWithMaterialCategoriesAsync(Guid MaterialCategoriesId)
        {
            //, Guid TranscationCategoriesId, Guid TicketPeriodId
            try
            {
                ManufacturersBussinessItemsRepository repo = RepositoryHelper.GetManufacturersBussinessItemsRepository();
                database = repo.UnitOfWork;

                var matchedresult = repo
                                    .Where(w => w.MaterialCategoriesId == MaterialCategoriesId)
                                    .Distinct()
                                    .ToList();

                return(Task.FromResult(ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > .CreateResultEntity(
                                           new Collection <ManufacturersBussinessItems>(matchedresult))));
            }
            catch (Exception ex)
            {
                return(Task.FromResult(ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > .CreateErrorResultEntity(ex)));
            }
        }