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; }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MenuManager_TopMenu)); Int32.TryParse(Request["menuid"], out _menuId); _needReloadTree = SQLDataHelper.GetBoolean(ViewState["updateTree"]); hlEditCategory.Visible = _menuId > 0; lblSeparator.Visible = _menuId > 0; hlDeleteCategory.Visible = _menuId > 0; if (!string.IsNullOrWhiteSpace(Request["type"])) Enum.TryParse(Request["type"], true, out _menuType); var menuitem = new AdvMenuItem(); switch (_menuType) { case MenuService.EMenuType.Top: menuitem = MenuService.GetMenuItemById(_menuId, _menuType); lblHead.Text = menuitem == null ? Resource.Admin_MenuManager_TopMenu : string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName); lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderTop; Page.Title = menuitem == null ? Resource.Admin_MenuManager_TopMenu : string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName); break; case MenuService.EMenuType.Bottom: menuitem = MenuService.GetMenuItemById(_menuId, _menuType); lblHead.Text = menuitem == null ? Resource.Admin_MenuManager_BottomMenu : string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName); lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderBottom; Page.Title = menuitem == null ? Resource.Admin_MenuManager_BottomMenu : string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName); break; } btnAdd.OnClientClick = "open_window('m_Menu.aspx?MenuID=" + _menuId + "&mode=create&type=" + _menuType + "', 750, 640);return false;"; hlEditCategory.NavigateUrl = "javascript:open_window(\'m_Menu.aspx?MenuID=" + _menuId + "&mode=edit&type=" + _menuType + "\', 750, 640)"; ConfirmButtonExtenderCategory.ConfirmText = string.Format(Resource.Admin_MasterPageAdminCatalog_MenuConfirmation, menuitem != null ? menuitem.MenuItemName : string.Empty); if (!IsPostBack) { switch (_menuType) { case MenuService.EMenuType.Top: _paging = new SqlPaging { TableName = "[CMS].[MainMenu]", ItemsPerPage = 10 }; break; case MenuService.EMenuType.Bottom: _paging = new SqlPaging { TableName = "[CMS].[BottomMenu]", ItemsPerPage = 10 }; break; } _paging.AddFieldsRange(new List<Field> { new Field { Name = "MenuItemID as ID", IsDistinct = true }, new Field {Name = "MenuItemParentID" }, new Field {Name = "MenuItemName"}, new Field {Name = "Enabled"}, new Field {Name = "Blank"}, new Field {Name = "SortOrder",Sorting = SortDirection.Ascending} }); if (_menuId != 0) { var filter = new EqualFieldFilter { ParamName = "@MenuItemParentID", Value = _menuId.ToString() }; _paging.Fields["MenuItemParentID"].Filter = filter; } else { var filter = new NullFieldFilter { ParamName = "@MenuItemParentID", Null = true }; _paging.Fields["MenuItemParentID"].Filter = filter; } grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; } else { _paging = (SqlPaging)(ViewState["Paging"]); _paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); if (_paging == null) { throw (new Exception("Paging lost")); } string strIds = Request.Form["SelectedIds"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); string[] arrids = strIds.Split(' '); _selectionFilter = new InSetFieldFilter(); if (arrids.Contains("-1")) { _selectionFilter.IncludeValues = false; _inverseSelection = true; } else { _selectionFilter.IncludeValues = true; } _selectionFilter.Values = arrids.Where(id => id != "-1").ToArray(); } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_StaticPage_lblSubMain)); int.TryParse(Request["parentid"], out _parentPageId); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[CMS].[StaticPage]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List<Field> { new Field {Name = "StaticPageID as ID",IsDistinct = true}, new Field {Name = "PageName"}, new Field {Name = "Enabled"}, new Field {Name = "ParentID"}, new Field {Name = "SortOrder",Sorting = SortDirection.Ascending}, new Field {Name = "ModifyDate"} }); if (_parentPageId != 0) { var ef = new EqualFieldFilter() { ParamName = "@ParentID", Value = _parentPageId.ToString(CultureInfo.InvariantCulture) }; _paging.Fields["ParentID"].Filter = ef; } else { var nf = new NullFieldFilter() { ParamName = "@ParentID", Null = true }; _paging.Fields["ParentID"].Filter = nf; } grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; } else { _paging = (SqlPaging)(ViewState["Paging"]); _paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); if (_paging == null) { throw (new Exception("Paging lost")); } string strIds = Request.Form["SelectedIds"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); var arrids = strIds.Split(' '); _selectionFilter = new InSetFieldFilter(); if (arrids.Contains("-1")) { _selectionFilter.IncludeValues = false; _inverseSelection = true; } else { _selectionFilter.IncludeValues = true; } _selectionFilter.Values = arrids.Where(id => id != "-1").ToArray(); } } }