private void BindProducts()
        {
            this.LoadParameters();
            ProductQuery entity = new ProductQuery();

            entity.PageSize    = this.pager.PageSize;
            entity.PageIndex   = this.pager.PageIndex;
            entity.ProductCode = this.txtProductCode.Text;
            entity.Keywords    = this.txtProductName.Text;
            entity.BrandId     = this.dropBrandCategories.SelectedValue;
            entity.CategoryId  = this.ddlCategories.SelectedValue;
            if (entity.CategoryId.HasValue)
            {
                entity.MaiCategoryPath = CategoryBrowser.GetCategory(entity.CategoryId.Value).Path;
            }
            entity.SortOrder = SortAction.Desc;
            entity.SortBy    = "DisplaySequence";
            Globals.EntityCoding(entity, true);
            DbQueryResult batchBuyProducts = CommentsHelper.GetBatchBuyProducts(entity);

            this.batchbuys.DataSource = batchBuyProducts.Data;
            this.batchbuys.DataBind();
            this.pager.TotalRecords = batchBuyProducts.TotalRecords;
        }