コード例 #1
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //----Login filter
            if (!string.IsNullOrEmpty(txtSearchName.Text))
            {
                var sfilter = new CompareFieldFilter { Expression = txtSearchName.Text, ParamName = "@Name" };
                _paging.Fields["Name"].Filter = sfilter;
            }
            else
            {
                _paging.Fields["Name"].Filter = null;
            }

            //----Firstname filter
            if (!string.IsNullOrEmpty(txtSearchProducts_Count.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSearchProducts_Count.Text, ParamName = "@Products_Count" };
                _paging.Fields["Products_Count"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Products_Count"].Filter = null;
            }
            ViewState["Show"] = true;
            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #2
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //----Login filter
            if (!string.IsNullOrEmpty(txtSearchArtNo.Text))
            {
                var sfilter = new CompareFieldFilter { Expression = txtSearchArtNo.Text, ParamName = "@artNo" };
                _paging.Fields["ArtNo"].Filter = sfilter;
            }
            else
            {
                _paging.Fields["ArtNo"].Filter = null;
            }

            //----Firstname filter
            if (!string.IsNullOrEmpty(txtSearchName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSearchName.Text, ParamName = "@Name" };
                _paging.Fields["Name"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Name"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #3
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = _selectionFilter;
            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtGroupName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtGroupName.Text, ParamName = "@GroupName" };
                _paging.Fields["GroupName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["GroupName"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #4
0
ファイル: Regions.aspx.cs プロジェクト: AzarinSergey/learn
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
            {

                if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;

                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" };
                _paging.Fields["RegionName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RegionName"].Filter = null;
            }
            //--RegionCode filter
            if (!string.IsNullOrEmpty(txtRegNumber.Text))
            {
                var nfilter = new CompareFieldFilter
                    {
                        Expression = txtRegNumber.Text,
                        ParamName = "@RegionCode"
                    };
                _paging.Fields["RegionCode"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RegionCode"].Filter = null;
            }

            //---RegionSort filter
            if (!string.IsNullOrEmpty(txtRegSort.Text))
            {
                var nfilter = new CompareFieldFilter
                    {
                        Expression = txtRegSort.Text,
                        ParamName = "@RegionSort"
                    };
                _paging.Fields["RegionSort"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RegionSort"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #5
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                        //New InSetFieldFilter()
                        //_SelectionFilter.IncludeValues = True
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----UserName filter

            if (!string.IsNullOrEmpty(txtUserName.Text))
            {
                var userfilter = new CompareFieldFilter
                    {
                        ParamName = "@PriceRange",
                        Expression = txtUserName.Text
                    };
                _paging.Fields["PriceRange"].Filter = userfilter;
            }
            else
            {
                _paging.Fields["PriceRange"].Filter = null;
            }

            //----Text filter

            if (!string.IsNullOrEmpty(txtText.Text))
            {
                var textFilter = new CompareFieldFilter
                    {
                        ParamName = "@PercentDiscount",
                        Expression = txtText.Text
                    };
                _paging.Fields["PercentDiscount"].Filter = textFilter;
            }
            else
            {
                _paging.Fields["PercentDiscount"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
        }
コード例 #6
0
ファイル: Cities.aspx.cs プロジェクト: AzarinSergey/learn
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (string.Compare(ddSelect.SelectedIndex.ToString(), "0") != 0)
            {

                if (string.Compare(ddSelect.SelectedIndex.ToString(), "2") == 0)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null; //New InSetFieldFilter()
                        //_SelectionFilter.IncludeValues = True
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" };
                _paging.Fields["CityName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["CityName"].Filter = null;
            }

            //---RegionSort filter
            if (!string.IsNullOrEmpty(txtRegSort.Text))
            {
                var nfilter = new CompareFieldFilter
                    {
                        Expression = txtRegSort.Text,
                        ParamName = "@CitySort"
                    };
                _paging.Fields["CitySort"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["CitySort"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
        }
コード例 #7
0
ファイル: Taxes.aspx.cs プロジェクト: AzarinSergey/learn
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
            {

                if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" };
                _paging.Fields["Name"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Name"].Filter = null;
            }
            //----RegNumber filter
            if (!string.IsNullOrEmpty(txtRegNumber.Text))
            {
                var nfilter = new CompareFieldFilter
                    {
                        Expression = txtRegNumber.Text,
                        ParamName = "@RegNumber"
                    };
                _paging.Fields["RegNumber"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RegNumber"].Filter = null;
            }

            //----Country filter
            if (ddlCountryFilter.SelectedIndex != 0)
            {
                var nfilter = new CompareFieldFilter
                    {
                        Expression = ddlCountryFilter.SelectedItem.Text,
                        ParamName = "@Country"
                    };
                _paging.Fields["CountryName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["CountryName"].Filter = null;
            }

            //----Enabled filter
            if (ddlEnabled.SelectedIndex != 0)
            {

                var efilter = new EqualFieldFilter { ParamName = "@Enabled" };
                if (ddlEnabled.SelectedIndex == 1)
                {
                    efilter.Value = "1";
                }
                if (ddlEnabled.SelectedIndex == 2)
                {
                    efilter.Value = "0";
                }
                _paging.Fields["Enabled"].Filter = efilter;
            }
            else
            {
                _paging.Fields["Enabled"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #8
0
ファイル: Catalog.aspx.cs プロジェクト: AzarinSergey/learn
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                if (_selectionFilter != null)
                {
                    _paging.Fields["ID"].Filter = _selectionFilter;
                }
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Enabled filter
            if (ddlEnabled.SelectedIndex != 0)
            {
                var efilter = new EqualFieldFilter { ParamName = "@enabled" };
                if (ddlEnabled.SelectedIndex == 1)
                {
                    efilter.Value = "1";
                }
                if (ddlEnabled.SelectedIndex == 2)
                {
                    efilter.Value = "0";
                }
                _paging.Fields["Enabled"].Filter = efilter;
            }
            else
            {
                _paging.Fields["Enabled"].Filter = null;
            }

            //----Price filter

            var priceFilter = new RangeFieldFilter { ParamName = "@price" };

            int priceFrom;
            priceFilter.From = int.TryParse(txtPriceFrom.Text, out priceFrom) ? priceFrom : 0;

            int priceTo;
            priceFilter.To = int.TryParse(txtPriceTo.Text, out priceTo) ? priceTo : int.MaxValue;

            if (!string.IsNullOrEmpty(txtPriceFrom.Text) || !string.IsNullOrEmpty(txtPriceTo.Text))
            {
                _paging.Fields["Price"].Filter = priceFilter;
            }
            else
            {
                _paging.Fields["Price"].Filter = null;
            }

            //----Qty filter
            var qtyFilter = new RangeFieldFilter { ParamName = "@Amount" };
            int from;
            qtyFilter.From = int.TryParse(txtQtyFrom.Text, out from) ? from : int.MinValue;

            int to;
            qtyFilter.To = int.TryParse(txtQtyTo.Text, out to) ? to : int.MaxValue;

            if (!string.IsNullOrEmpty(txtQtyFrom.Text) || !string.IsNullOrEmpty(txtQtyTo.Text))
            {
                _paging.Fields["Amount"].Filter = qtyFilter;
            }
            else
            {
                _paging.Fields["Amount"].Filter = null;
            }

            //----SortOrder filter
            var soFilter = new RangeFieldFilter { ParamName = "@SortOrder" };

            try
            {
                soFilter.From = int.Parse(txtSortOrderFrom.Text);
            }
            catch (Exception)
            {
                soFilter.From = int.MinValue;
            }

            try
            {
                soFilter.To = int.Parse(txtSortOrderTo.Text);
            }
            catch (Exception)
            {
                soFilter.To = int.MaxValue;
            }

            if (ShowMethod == EShowMethod.Normal)
            {
                if (!string.IsNullOrEmpty(txtSortOrderFrom.Text) || !string.IsNullOrEmpty(txtSortOrderTo.Text))
                {
                    _paging.Fields["ProductCategories.SortOrder"].Filter = soFilter;
                }
                else
                {
                    _paging.Fields["ProductCategories.SortOrder"].Filter = null;
                }
            }

            //----Id filter
            if (!string.IsNullOrEmpty(txtArtNo.Text))
            {
                var sfilter = new CompareFieldFilter { Expression = txtArtNo.Text, ParamName = "@artno" };
                _paging.Fields["Product.ArtNo"].Filter = sfilter;

            }
            else
            {
                _paging.Fields["Product.ArtNo"].Filter = null;

            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtName.Text, ParamName = "@name" };
                _paging.Fields["Name"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Name"].Filter = null;
            }

            //---Photo filter
            if (ddPhoto.SelectedIndex != 0)
            {
                var phfilter = new NullFieldFilter();
                if (ddPhoto.SelectedIndex == 1)
                {
                    phfilter.Null = false;
                }
                if (ddPhoto.SelectedIndex == 2)
                {
                    phfilter.Null = true;
                }
                phfilter.ParamName = "@PhotoName";
                _paging.Fields["PhotoName"].Filter = phfilter;
            }
            else
            {
                _paging.Fields["PhotoName"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
            //lblFound.Text = _paging.TotalRowsCount.ToString();
            //pnlFilterCount.Visible = true;
            //pnlNormalCount.Visible = false;
        }
コード例 #9
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Firstname filter
            if (!string.IsNullOrEmpty(txtSearchFirstName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSearchFirstName.Text, ParamName = "@firstname" };
                _paging.Fields["Firstname"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Firstname"].Filter = null;
            }

            //----lastname filter
            if (!string.IsNullOrEmpty(txtSearchLastname.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSearchLastname.Text, ParamName = "@lastname" };
                _paging.Fields["Lastname"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Lastname"].Filter = null;
            }

            //----email filter
            if (!string.IsNullOrEmpty(txtSearchEmail.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSearchEmail.Text, ParamName = "@email" };
                _paging.Fields["Email"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Email"].Filter = null;
            }

            //----RegDate filter
            if (!string.IsNullOrEmpty(txtDateFrom.Text) || !string.IsNullOrEmpty(txtDateTo.Text))
            {
                var nfilter = new DateTimeRangeFieldFilter();
                try
                {
                    nfilter.From = DateTime.Parse(txtDateFrom.Text);
                }
                catch (Exception)
                {
                    nfilter.From = DateTime.Parse("01.01.1900");
                }

                try
                {
                    nfilter.To = DateTime.Parse(txtDateTo.Text);
                }
                catch (Exception)
                {
                    nfilter.To = DateTime.MaxValue;
                }
                nfilter.ParamName = "@RegistrationDateTime";
                _paging.Fields["RegistrationDateTime"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RegistrationDateTime"].Filter = null;
            }

            _paging.Fields["CustomerGroupId"].Filter = ddlCustomerGroup.SelectedValue != "0"
                                                           ? new EqualFieldFilter
                                                               {
                                                                   ParamName = "@CustomerGroupId",
                                                                   Value = ddlCustomerGroup.SelectedValue
                                                               }
                                                           : null;

            _paging.Fields["PriceType"].Filter = ddlPriceTypes.SelectedValue != "0"
                                                           ? new EqualFieldFilter
                                                               {
                                                                   ParamName = "@PriceType",
                                                                   Value = ddlPriceTypes.SelectedValue
                                                               }
                                                           : null;

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
        }
コード例 #10
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = _selectionFilter;
            }

            //----FirstName filter
            if (!string.IsNullOrEmpty(txtFirstName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtFirstName.Text, ParamName = "@FirstName" };
                _paging.Fields["FirstName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["FirstName"].Filter = null;
            }

            //----Login filter
            //if (!string.IsNullOrEmpty(txtLogin.Text))
            //{
            //    var nfilter = new CompareFieldFilter { Expression = txtLogin.Text, ParamName = "@Login" };
            //    _paging.Fields["Login"].Filter = nfilter;
            //}
            //else
            //{
            //    _paging.Fields["Login"].Filter = null;
            //}

            //---LastName
            if (!string.IsNullOrEmpty(txtLastName.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtLastName.Text, ParamName = "@LastName" };
                _paging.Fields["LastName"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["LastName"].Filter = null;
            }

            //---Email Filter
            if (!string.IsNullOrEmpty(txtEmail.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtEmail.Text, ParamName = "@Email" };
                _paging.Fields["Email"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["Email"].Filter = null;
            }

            //----Subscribed4News
            if (subscribed4News.SelectedIndex != 0)
            {
                var beforeFilter = new EqualFieldFilter { ParamName = "@Subscribed4News" };
                if (subscribed4News.SelectedIndex == 1)
                {
                    beforeFilter.Value = "1";
                }
                if (subscribed4News.SelectedIndex == 2)
                {
                    beforeFilter.Value = "0";
                }
                _paging.Fields["Subscribed4News"].Filter = beforeFilter;
            }
            else
            {
                _paging.Fields["Subscribed4News"].Filter = null;
            }

            var dfilter = new DateTimeRangeFieldFilter { ParamName = "@RegistrationDateTime" };
            if (!string.IsNullOrEmpty(txtDateFrom.Text))
            {
                DateTime? d = null;
                try
                {
                    d = DateTime.Parse(txtDateFrom.Text);
                }
                catch (Exception)
                {
                }
                if (d.HasValue)
                {
                    var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
                    dfilter.From = dt;
                }
            }

            if (!string.IsNullOrEmpty(txtDateTo.Text))
            {
                DateTime? d = null;
                try
                {
                    d = DateTime.Parse(txtDateTo.Text);
                }
                catch (Exception)
                {
                }
                if (d.HasValue)
                {
                    var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
                    dfilter.To = dt;
                }
            }

            if (dfilter.From.HasValue || dfilter.To.HasValue)
            {
                _paging.Fields["RegistrationDateTime"].Filter = dfilter;
            }
            else
            {
                _paging.Fields["RegistrationDateTime"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
        }
コード例 #11
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
            {

                if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null; //New InSetFieldFilter()
                        //_SelectionFilter.IncludeValues = True
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //----Id filter
            if (!string.IsNullOrEmpty(txtId.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtId.Text, ParamName = "@id" };
                _paging.Fields["ID"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = null;
            }

            //---RedirectFrom filter
            if (!string.IsNullOrEmpty(txtRedirectFrom.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtRedirectFrom.Text, ParamName = "@RedirectFrom" };
                _paging.Fields["RedirectFrom"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RedirectFrom"].Filter = null;
            }

            //---RedirectTo filter
            if (!string.IsNullOrEmpty(txtRedirectTo.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtRedirectTo.Text, ParamName = "@RedirectTo" };
                _paging.Fields["RedirectTo"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["RedirectTo"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
        }
コード例 #12
0
ファイル: Carousel.aspx.cs プロジェクト: AzarinSergey/learn
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = _selectionFilter;
            }

            //----Name filter
            if (!string.IsNullOrEmpty(txtUrlFilter.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtUrlFilter.Text, ParamName = "@URL" };
                _paging.Fields["URL"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["URL"].Filter = null;
            }

            //----CurrencyValue filter
            if (!string.IsNullOrEmpty(txtSortOrder.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtSortOrder.Text, ParamName = "@SortOrder" };
                _paging.Fields["SortOrder"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["SortOrder"].Filter = null;
            }

            if (ddlEnabled.SelectedIndex != 0)
            {
                var eFilter = new EqualFieldFilter { ParamName = "@Enabled" };
                if (ddlEnabled.SelectedIndex == 1)
                {
                    eFilter.Value = "1";
                }
                if (ddlEnabled.SelectedIndex == 2)
                {
                    eFilter.Value = "0";
                }
                _paging.Fields["Enabled"].Filter = eFilter;
            }
            else
            {
                _paging.Fields["Enabled"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
            _paging.CurrentPageIndex = 1;
        }
コード例 #13
0
        protected void btnFilter_Click(object sender, EventArgs e)
        {
            //-----Selection filter
            if (ddSelect.SelectedIndex != 0)
            {
                if (ddSelect.SelectedIndex == 2)
                {
                    if (_selectionFilter != null)
                    {
                        _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
                    }
                    else
                    {
                        _selectionFilter = null;
                    }
                }
                _paging.Fields["ID"].Filter = _selectionFilter;
            }
            else
            {
                _paging.Fields["ID"].Filter = _selectionFilter;
            }

            //----ActivateDate filter
            if (!string.IsNullOrEmpty(txtMessageText.Text))
            {
                var nfilter = new CompareFieldFilter { Expression = txtMessageText.Text, ParamName = "@MessageText" };
                _paging.Fields["MessageText"].Filter = nfilter;
            }
            else
            {
                _paging.Fields["MessageText"].Filter = null;
            }

            //---OrderDate filter
            var dfilter = new DateTimeRangeFieldFilter { ParamName = "@AddDate" };
            if (!string.IsNullOrEmpty(txtDateFrom.Text))
            {
                DateTime? d = null;
                try
                {
                    d = DateTime.Parse(txtDateFrom.Text);
                }
                catch (Exception)
                {
                }

                if (d.HasValue)
                {
                    var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
                    dfilter.From = dt;
                }
            }

            if (!string.IsNullOrEmpty(txtDateTo.Text))
            {
                DateTime? d = null;
                try
                {
                    d = DateTime.Parse(txtDateTo.Text);
                }
                catch (Exception)
                {
                }

                if (d.HasValue)
                {
                    var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
                    dfilter.To = dt;
                }
            }

            if (dfilter.From.HasValue || dfilter.To.HasValue)
            {
                _paging.Fields["AddDate"].Filter = dfilter;
            }
            else
            {
                _paging.Fields["AddDate"].Filter = null;
            }

            pageNumberer.CurrentPageIndex = 1;
        }