protected void rgPrivGroup_SortCommand(object sender, GridSortCommandEventArgs e) { if (OnPrivGroupCommand != null) { OnPrivGroupCommand("sort"); } }
protected void SalesForecastSummariesRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { e.Canceled = true; GridSortExpression expression = new GridSortExpression(); expression.FieldName = e.SortExpression; if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions.Count == 0 || SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].FieldName != e.SortExpression) { expression.SortOrder = GridSortOrder.Descending; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Descending) { expression.SortOrder = GridSortOrder.Ascending; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending) { expression.SortOrder = GridSortOrder.None; } else if (SalesForecastSummariesRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.None) { expression.SortOrder = GridSortOrder.Descending; } SalesForecastSummariesRadGrid.MasterTableView.SortExpressions.AddSortExpression(expression); SalesForecastSummariesRadGrid.MasterTableView.Rebind(); }
/// <summary> /// Esegue il sort di una colonna nella griglia. /// Reperisco dalla griglia il nome della colonna da ordinare. /// Creo l'espressione Lambda corretta e la inserisco nel finder e poi lo persisto nella sessione. /// </summary> /// <typeparam name="T"></typeparam> /// <typeparam name="THeader"></typeparam> /// <param name="e"></param> public void FinderSorting <T, THeader>(GridSortCommandEventArgs e) { // TODO: verificare gli ordinamenti sui campi dell'entità Header. In questo momento l'ordinamento funziona solo se il campo è settato sull'entità padre IFinder <T, THeader> finderToExecute = Finder as IFinder <T, THeader>; finderToExecute.SortExpressionsClear(); SortDirection sortOrder; if (e.NewSortOrder == GridSortOrder.None && e.OldSortOrder == GridSortOrder.Descending) { sortOrder = SortDirection.Descending; } else { sortOrder = e.NewSortOrder == GridSortOrder.Ascending ? SortDirection.Ascending : SortDirection.Descending; } string parameterName = e.SortExpression; ParameterExpression param = Expression.Parameter(typeof(T), "x"); Expression <Func <T, object> > expr = Expression.Lambda <Func <T, object> >(Expression.Convert(Expression.Property(param, parameterName), typeof(object)), param); finderToExecute.SortExpressions.Add(new SortExpression <T>() { Expression = expr, Direction = sortOrder }); Finder = finderToExecute; PersistFinder(); }
protected void Grid_Sort(object sender, GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); switch (e.OldSortOrder) { case GridSortOrder.None: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Ascending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = RadGrid1.MasterTableView.AllowNaturalSort ? GridSortOrder.None : GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Descending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; } e.Canceled = true; RadGrid1.Rebind(); }
protected void QuoteLogRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { e.Canceled = true; GridSortExpression expression = new GridSortExpression(); expression.FieldName = e.SortExpression; if (QuoteLogRadGrid.MasterTableView.SortExpressions.Count == 0 || QuoteLogRadGrid.MasterTableView.SortExpressions[0].FieldName != e.SortExpression) { expression.SortOrder = GridSortOrder.Descending; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Descending) { expression.SortOrder = GridSortOrder.Ascending; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending) { expression.SortOrder = GridSortOrder.None; } else if (QuoteLogRadGrid.MasterTableView.SortExpressions[0].SortOrder == GridSortOrder.None) { expression.SortOrder = GridSortOrder.Descending; } QuoteLogRadGrid.MasterTableView.SortExpressions.AddSortExpression(expression); string filter = FilterComboBox.SelectedValue; string filterValue; filterValue = (RadioButtonList1.SelectedValue == "0") ? lblSalesTitle.Text : lblVolumesTitle.Text; QuoteLogRadGrid.DataSource = PopulateQuoteLogGrid(filter, filterValue); QuoteLogRadGrid.DataBind(); }
protected void rgTaskList_SortCommand(object sender, GridSortCommandEventArgs e) { if (OnTaskListCommand != null) { OnTaskListCommand("sort"); } }
protected void radGridEntry_SortCommand(object Sender, GridSortCommandEventArgs e) { //if (e.CommandArgument == "Country") //This Line Made ALL sorting functions of the title/labels are NOT working { BindGrid(true, e.CommandArgument.ToString(), e.NewSortOrder, true); } }
protected void rgdInvoices_SortCommand(object sender, GridSortCommandEventArgs e) { //Apply custom sorting var sortExpr = new GridSortExpression(); switch (e.OldSortOrder) { case GridSortOrder.None: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Ascending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = rgdInvoices.MasterTableView.AllowNaturalSort ? GridSortOrder.None : GridSortOrder.Descending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; case GridSortOrder.Descending: sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); break; } e.Canceled = true; rgdInvoices.Rebind(); }
protected void grdProducts_SortCommand(object source, GridSortCommandEventArgs e) { // The RadGrid has a bug in it's sorting display on the header // we'll just do the sorting manually // if we are in the master products grid if (e.Item.OwnerTableView.Name.EqualsIgnoreCase("Master")) { e.Canceled = true; this.SortColumn = e.SortExpression; switch (this.SortColumnDirection) { case GridSortOrder.Ascending: this.SortColumnDirection = GridSortOrder.Descending; break; case GridSortOrder.None: case GridSortOrder.Descending: this.SortColumnDirection = GridSortOrder.Ascending; break; } BindData(false); } else // we're in the variant detail tables { } }
protected void rgNotifyAction_SortCommand(object sender, GridSortCommandEventArgs e) { if (OnNotifyActionCommand != null) { OnNotifyActionCommand("sort"); } }
protected void radGridEntry_SortCommand(object Sender, GridSortCommandEventArgs e) { if (e.CommandArgument == "Country") { BindGrid(true, e.CommandArgument.ToString(), e.NewSortOrder, true); } }
protected void RadGridItems_SortCommand(object sender, GridSortCommandEventArgs e) { this.ReBindGrid(); ViewState["IsPopulateSubItemModel"] = false; ViewState["IsPopulateItemModel"] = false; }
protected void RadGridItemAttribute_SortCommand(object sender, GridSortCommandEventArgs e) { this.ReBindGrid(); ViewState["IsSubAttribute"] = (!this.IsPostBack); ViewState["IsPageValied"] = true; }
protected void rgRegionalApproverAction_SortCommand(object sender, GridSortCommandEventArgs e) { if (OnRegionalApproverActionCommand != null) { OnRegionalApproverActionCommand("sort"); } }
protected void gvUserActivity_SortCommand(object sender, GridSortCommandEventArgs e) { if (e.SortExpression.Length > 0) { PageIndex = 0; SortOrder = e.NewSortOrder; SortField = e.SortExpression; } }
protected void ContactsRadGrid_SortCommand(object source, GridSortCommandEventArgs e) { RememberSelected(); sortExpression = new GridSortExpression(); sortExpression.FieldName = e.SortExpression; sortExpression.SortOrder = e.NewSortOrder; RaiseBubbleEvent(this, new CommandEventArgs("LoadContacts", null)); }
protected void GridView1_SortCommand(object sender, GridSortCommandEventArgs e) { if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); } }
protected void rg3_SortCommand(object source, GridSortCommandEventArgs e) { try { rg3.Rebind(); } catch (Exception ex) { ErrorManager(ex, new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name); } }
protected void gvAutoProctorInbox_SortCommand(object sender, GridSortCommandEventArgs e) { //if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) //{ // GridSortExpression sortExpr = new GridSortExpression(); // sortExpr.FieldName = e.SortExpression; // sortExpr.SortOrder = GridSortOrder.Ascending; // e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); //} }
protected void rg1_SortCommand(object source, GridSortCommandEventArgs e) { try { rg1.Rebind(); } catch (Exception ex) { throw ex; } }
protected void AttbtsgrdView_SortCommand(object sender, GridSortCommandEventArgs e) { LoadGrid(); LoadGrid2(); LoadGrid3(); LoadGrid4(); LoadGrid5(); LoadGrid6(); LoadGrid7(); LoadGrid8(); }
protected void dgControlPromocion_SortCommand(object source, GridSortCommandEventArgs e) { try { dgControlPromocion.Rebind(); } catch (Exception) { throw; } }
protected void RgvManageUser_SortCommand(object sender, GridSortCommandEventArgs e) { /*if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression)) * { * GridSortExpression sortExpr = new GridSortExpression(); * sortExpr.FieldName = e.SortExpression; * sortExpr.SortOrder = GridSortOrder.Ascending; * e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); * }*/ this.RgvManageUser.MasterTableView.AllowNaturalSort = true; this.RgvManageUser.MasterTableView.Rebind(); }
protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e) { DataSet ds = generateArrayIndex(); DataTable dt = new DataTable(); dt = ds.Tables[0]; dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns[0] }; dt.Merge(ds.Tables[1]); RadGrid1.DataSource = dt; RadGrid1.Rebind(); updatePanelDashboardGrid.Update(); }
protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e) { foreach (GridItem item in RadGrid1.MasterTableView.Items) { if (item is GridEditableItem) { GridEditableItem editableItem = item as GridDataItem; editableItem.Edit = true; } } RadGrid1.Rebind(); }
protected void RadGrid1_SortCommand(object source, GridSortCommandEventArgs e) { ErrorManager(); try { this.RadGrid1.Rebind(); } catch (Exception ex) { ErrorManager(ex, "RadGrid1_SortCommand"); } }
protected void gvPricingPlans_SortCommand(object sender, GridSortCommandEventArgs e) { if (e.SortExpression.Length > 0) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = e.NewSortOrder; gvPricingPlans.MasterTableView.SortExpressions.Clear(); gvPricingPlans.MasterTableView.SortExpressions.AddSortExpression(sortExpr); e.Canceled = true; gvPricingPlans.Rebind(); } }
protected void gridReport_SortCommand(object sender, GridSortCommandEventArgs e) { string orderByClause = GetOrderByClause(e.SortExpression, e.NewSortOrder.ToString()); ReportData reportData = new ReportData(UserSession.LoginUser); reportData.LoadReportData(_reportID, UserSession.LoginUser.UserID); if (!reportData.IsEmpty) { using (SqlConnection connection = new SqlConnection(GetReportConnectionString())) { reportData[0].OrderByClause = orderByClause; reportData[0].Collection.Save(); } } }
/// <summary> /// Sort order action (grid) /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void grdRecentSolution_SortCommand(object source, GridSortCommandEventArgs e) { string orderByFormat = string.Empty; switch (e.NewSortOrder) { case GridSortOrder.Ascending: orderByFormat = "ORDER BY {0} ASC"; break; case GridSortOrder.Descending: orderByFormat = "ORDER BY {0} DESC"; break; } e.Item.OwnerTableView.Rebind(); }
protected void RGGoodsDemand_SortCommand(object source, GridSortCommandEventArgs e) { SortField = e.SortExpression; if (e.NewSortOrder == GridSortOrder.Ascending) { SortStyle = "desc"; SortUser = string.Format("{0} {1} {2}", SortField, "", SortStyle); RGGoodsDemand.MasterTableView.SortExpressions.AddSortExpression(SortUser); } if (e.OldSortOrder == GridSortOrder.Descending) { SortStyle = "asc"; SortUser = string.Format("{0} {1} {2}", SortField, "", SortStyle); RGGoodsDemand.MasterTableView.SortExpressions.AddSortExpression(SortUser); } }
/// <summary> /// Gotta have it for sort to work ??? wierd. /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void grdAssessmentAdmin_SortCommand(object source, GridSortCommandEventArgs e) { }
private void GetCompanyGridDataSource(GridSortCommandEventArgs sortEventArgs) { int pageNumber = CompanyGrid.CurrentPageIndex + 1; string sortExpress = string.Empty; string sortExpressInvert = string.Empty; foreach (GridSortExpression item in CompanyGrid.MasterTableView.SortExpressions) { GridSortOrder newSortOrder = item.SortOrder; if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression) { newSortOrder = sortEventArgs.NewSortOrder; } if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (newSortOrder == GridSortOrder.Ascending) { sortExpress += item.FieldName + " ASC"; sortExpressInvert += item.FieldName + " DESC"; } else if (newSortOrder == GridSortOrder.Descending) { sortExpress += item.FieldName + " DESC"; sortExpressInvert += item.FieldName + " ASC"; } } if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression)) { if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending) { sortExpress += sortEventArgs.SortExpression + " ASC"; sortExpressInvert += sortEventArgs.SortExpression + " DESC"; } else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending) { sortExpress += sortEventArgs.SortExpression + " DESC"; sortExpressInvert += sortEventArgs.SortExpression + " ASC"; } } if (!string.IsNullOrEmpty(sortExpress)) { if (sortExpress.Contains("CompanyName")) { sortExpress = sortExpress.Replace("CompanyName", "SocNom"); sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom"); } if (sortExpress.Contains("City")) { sortExpress = sortExpress.Replace("City", "Commune"); sortExpressInvert = sortExpressInvert.Replace("City", "Commune"); } if (sortExpress.Contains("StatusLabel")) { sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel"); sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel"); } if (sortExpress.Contains("Responsible")) { sortExpress = sortExpress.Replace("Responsible", "Responsable"); sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable"); } if (sortExpress.Contains("CreatedDate")) { sortExpress = sortExpress.Replace("CreatedDate", "DateCreation"); sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation"); } } else { sortExpress = "SocNom ASC"; sortExpressInvert = "SocNom DESC"; } CompanyRepository companyRepo = new CompanyRepository(); List<Company> companyList = new List<Company>(); /*if (!string.IsNullOrEmpty(Request.QueryString["type"])) //search by type { switch (Request.QueryString["type"]) { case "all": CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies(); companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "client": CompanyGrid.VirtualItemCount = companyRepo.CountCustomerCompanies(); companyList = companyRepo.GetCustomerCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "prospect": CompanyGrid.VirtualItemCount = companyRepo.CountPropectCompanies(); companyList = companyRepo.GetPropectCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "inactive": CompanyGrid.VirtualItemCount = companyRepo.CountInactiveCompanies(); companyList = companyRepo.GetInactiveCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert); break; default: CompanyGrid.VirtualItemCount = companyRepo.CountAllCompanies(); companyList = companyRepo.GetAllCompanies(pageSize, pageNumber, sortExpress, sortExpressInvert); break; } } else*/ //if ((!string.IsNullOrEmpty(Request.QueryString["cname"]))) // search by name //{ if (!string.IsNullOrEmpty(Request.QueryString["ctype"])) { switch(Request.QueryString["ctype"]) { case "all": CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]); companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "client": CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "1"); companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"],"1", pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "prospect": CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "2"); companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "2", pageSize, pageNumber, sortExpress, sortExpressInvert); break; case "inactive": CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByNameAndType(Request.QueryString["cname"], "0"); companyList = companyRepo.FindByNameAndType(Request.QueryString["cname"], "0", pageSize, pageNumber, sortExpress, sortExpressInvert); break; } } else { //CompanyGrid.VirtualItemCount = companyRepo.CountSearchCompaniesByName(Request.QueryString["cname"]); //companyList = companyRepo.FindByName(Request.QueryString["cname"], pageSize, pageNumber, sortExpress, sortExpressInvert); companyList = companyRepo.GetTopCompany(pageSize); } //} //else //view a number of recent company //{ // companyList = companyRepo.GetTopCompany(pageSize); //} CompanyGrid.DataSource = companyList; }
protected void OnSortCommandInProduction(object source, GridSortCommandEventArgs e) { ApplicationContext.SaveGridSettings("Staff Production", e); }
protected void OnSort(object sender, GridSortCommandEventArgs args) { dgPolicies.Sort = args.SortExpression; }
protected void radGridResults_SortCommand(object sender, GridSortCommandEventArgs e) { string sortDirection = "asc"; if (e.NewSortOrder == GridSortOrder.Descending) { sortDirection = "desc"; } ReferenceSearchCriteria referenceSearchCriteria = this.GetSelectedCriteria(this.Master.CurrentCriteria()); PopulateGridWithCMSData(referenceSearchCriteria, e.SortExpression + " " + sortDirection); }
protected void OnSortCommand(object sender, GridSortCommandEventArgs e) { this.SearchStudents("Grid"); }
protected void OnSortCommand(object sender, GridSortCommandEventArgs e) { BindDataToGrid(); }
private void BindCompanyGrid(GridSortCommandEventArgs sortEventArgs) { if (!string.IsNullOrEmpty(txtName.Text)) { int pageSize = 10; int pageNumber = gridCompany.CurrentPageIndex + 1; string sortExpress = string.Empty; string sortExpressInvert = string.Empty; foreach (GridSortExpression item in gridCompany.MasterTableView.SortExpressions) { GridSortOrder newSortOrder = item.SortOrder; if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression) { newSortOrder = sortEventArgs.NewSortOrder; } if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (newSortOrder == GridSortOrder.Ascending) { sortExpress += item.FieldName + " ASC"; sortExpressInvert += item.FieldName + " DESC"; } else if (newSortOrder == GridSortOrder.Descending) { sortExpress += item.FieldName + " DESC"; sortExpressInvert += item.FieldName + " ASC"; } } if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression)) { if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending) { sortExpress += sortEventArgs.SortExpression + " ASC"; sortExpressInvert += sortEventArgs.SortExpression + " DESC"; } else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending) { sortExpress += sortEventArgs.SortExpression + " DESC"; sortExpressInvert += sortEventArgs.SortExpression + " ASC"; } } if (!string.IsNullOrEmpty(sortExpress)) { if (sortExpress.Contains("CompanyName")) { sortExpress = sortExpress.Replace("CompanyName", "SocNom"); sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom"); } if (sortExpress.Contains("City")) { sortExpress = sortExpress.Replace("City", "Commune"); sortExpressInvert = sortExpressInvert.Replace("City", "Commune"); } if (sortExpress.Contains("StatusLabel")) { sortExpress = sortExpress.Replace("StatusLabel", "StatusLabel"); sortExpressInvert = sortExpressInvert.Replace("StatusLabel", "StatusLabel"); } if (sortExpress.Contains("Responsible")) { sortExpress = sortExpress.Replace("Responsible", "Responsable"); sortExpressInvert = sortExpressInvert.Replace("Responsible", "Responsable"); } if (sortExpress.Contains("CreatedDate")) { sortExpress = sortExpress.Replace("CreatedDate", "DateCreation"); sortExpressInvert = sortExpressInvert.Replace("CreatedDate", "DateCreation"); } } else { sortExpress = "SocNom ASC"; sortExpressInvert = "SocNom DESC"; } CompanyRepository companyRepo = new CompanyRepository(); gridCompany.VirtualItemCount = companyRepo.CountSearchCompaniesByName(txtName.Text); gridCompany.DataSource = companyRepo.FindByName(txtName.Text, pageSize, pageNumber, sortExpress, sortExpressInvert); } else { IList<Company> comList = new List<Company>(); gridCompany.DataSource = comList; } }
protected void OnGridCompanySortCommand(object source, GridSortCommandEventArgs e) { BindCompanyGrid(e); }
protected void OnSort(object sender, GridSortCommandEventArgs args) { dgDisciplineLevels.Sort = args.SortExpression; }
protected void OnSort(object sender, GridSortCommandEventArgs args) { dgCompetencyAreas.Sort = args.SortExpression; }
protected void OnGridRoomResultSortCommand(object source, GridSortCommandEventArgs e) { GetGridRoomResultDataSource(e); }
protected void rg_OnSortCommand(object sender, GridSortCommandEventArgs e) { RadGrid rg = sender as RadGrid; if (rg != null) { Int32 i; for (i = 0; i < _grids.Length; i++) { if (rg.ID == _grids[i].ID) { BindDataToGrid(LevelData.Tables[i + 1], _grids[i]); break; } } } }
protected void OnRadActionGridSortCommand(object source, GridSortCommandEventArgs e) { BindGridData(e); }
protected void grdTeklifler_SortCommand(object source, GridSortCommandEventArgs e) { }
protected void grdCalculatedDates3_SortCommand(object sender, GridSortCommandEventArgs e) { }
protected void grdIstek_SortCommand(object source, GridSortCommandEventArgs e) { }
protected void grdLoans_SortCommand(object sender, GridSortCommandEventArgs e) { // GridTableView tableView = e.Item.OwnerTableView; GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; if (strLoanSort == "ASC") { sortExpr.SortOrder = GridSortOrder.Descending; strLoanSort = "DESC"; } else { sortExpr.SortOrder = GridSortOrder.Ascending; strLoanSort = "ASC"; } // sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); //sortExpr.SortOrder = GridSortOrder.Ascending; }
protected void OnSortCommand(object sender, GridSortCommandEventArgs e) { if (SourceCriteriaExists()) { radGridResults.DataSource = SearchResourcesWithCriteria(false); radGridResults.DataBind(); } }
protected void grdQuotesAndTrades_SortCommand(object sender, GridSortCommandEventArgs e) { GridSortExpression sortExpr = new GridSortExpression(); sortExpr.FieldName = e.SortExpression; sortExpr.SortOrder = GridSortOrder.Ascending; e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr); }
void Grid_SortCommand(object sender, GridSortCommandEventArgs e) { this.StoreSelection(); DataTable Dt = null; string Sort = e.SortExpression + " " + (e.NewSortOrder == GridSortOrder.Ascending ? "" : "Desc"); /* if (this.mProperties.IsRequery) { Dt = this.mBase.List(this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1); } else { Dt = this.mDataSource; if (this.mState.Qc != null) { try { Dt.DefaultView.RowFilter = this.mState.Qc.GetQueryCondition_String(); } catch { } } else { Dt.DefaultView.RowFilter = ""; } } */ switch (this.mProperties.SourceType) { case eSourceType.Base: { Dt = this.mBase.List(this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1); break; } case eSourceType.DataTable: { Dt = this.mDataSource; if (this.mState.Qc != null) { try { Dt.DefaultView.RowFilter = this.mState.Qc.GetQueryCondition_String(); } catch { } } else { Dt.DefaultView.RowFilter = ""; } break; } case eSourceType.Table: { Dt = new Base().pDa.List(this.mTableName, this.mState.Qc, Sort, this.Grid.PageSize, this.Grid.CurrentPageIndex + 1); break; } } Methods_Web.ClearHTMLTags(Dt); this.Grid.DataSource = Dt; this.Grid.Rebind(); List<string> List_Sort = new List<string>(); List_Sort.Add(Sort); this.SaveGridState(this.Grid.PageSize, this.Grid.CurrentPageIndex, List_Sort); }
protected void OnSortCommand(object sender, GridSortCommandEventArgs e) { BindPerformanceGrid(); }
protected void OnSortCommandRequests(object source, GridSortCommandEventArgs e) { ApplicationContext.SaveGridSettings("Staff Requests", e); }
protected void OnCommentSortCommand(object sender, GridSortCommandEventArgs e) { BindCommentGrid(); }
public void SaveGridSettings(string sName, GridSortCommandEventArgs e) { // We're only saving the sorting on the master table, not child 'detail' tables if (e.Item.OwnerTableView.Name != "Detail") { var oIAUserSettingsGrid = DataAccess.IAUserSettingsGrids.SingleOrDefault(row => row.MPUserID == MemberProtect.CurrentUser.UserID && row.Name == sName); if (oIAUserSettingsGrid == null) { oIAUserSettingsGrid = new IAUserSettingsGrid(); DataAccess.IAUserSettingsGrids.InsertOnSubmit(oIAUserSettingsGrid); oIAUserSettingsGrid.MPUserID = MemberProtect.CurrentUser.UserID; oIAUserSettingsGrid.Name = sName; oIAUserSettingsGrid.Filters = string.Empty; } oIAUserSettingsGrid.SortExpression = e.SortExpression; if (e.NewSortOrder == GridSortOrder.Ascending) { oIAUserSettingsGrid.SortExpression += " ASC"; } else if (e.NewSortOrder == GridSortOrder.Descending) { oIAUserSettingsGrid.SortExpression += " DESC"; } DataAccess.SubmitChanges(); } }
private void GetGridRoomResultDataSource(GridSortCommandEventArgs sortEventArgs) { int pageNumber = gridRoomResult.CurrentPageIndex + 1; string sortExpress = string.Empty; string sortExpressInvert = string.Empty; foreach (GridSortExpression item in gridRoomResult.MasterTableView.SortExpressions) { GridSortOrder newSortOrder = item.SortOrder; if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression) { newSortOrder = sortEventArgs.NewSortOrder; } if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (newSortOrder == GridSortOrder.Ascending) { sortExpress += item.FieldName + " ASC"; sortExpressInvert += item.FieldName + " DESC"; } else if (newSortOrder == GridSortOrder.Descending) { sortExpress += item.FieldName + " DESC"; sortExpressInvert += item.FieldName + " ASC"; } } if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression)) { if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending) { sortExpress += sortEventArgs.SortExpression + " ASC"; sortExpressInvert += sortEventArgs.SortExpression + " DESC"; } else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending) { sortExpress += sortEventArgs.SortExpression + " DESC"; sortExpressInvert += sortEventArgs.SortExpression + " ASC"; } } if (string.IsNullOrEmpty(sortExpress)) { sortExpress = "DateCreated DESC"; sortExpressInvert = "DateCreated ASC"; } int cityId = Convert.ToInt32(cbbCity.SelectedValue); int? districtId = Convert.ToInt32(cbbDistrict.SelectedValue); if (districtId <= 0) { districtId = null; } int? realestateTypeId = Convert.ToInt32(cbbRealestateType.SelectedValue); if (realestateTypeId <= 0) { realestateTypeId = null; } decimal? priceFrom = null; if (txtPriceFrom.Value.HasValue) { priceFrom = Convert.ToDecimal(txtPriceFrom.Value); } decimal? priceTo = null; if (txtPriceTo.Value.HasValue) { priceTo = Convert.ToDecimal(txtPriceTo.Value); } DateTime? dateFrom = null; if (datDateFrom.SelectedDate.HasValue) { dateFrom = datDateFrom.SelectedDate.Value; } DateTime? dateTo = null; if (datDateTo.SelectedDate.HasValue) { dateTo = datDateTo.SelectedDate.Value; dateTo = dateTo.Value.AddDays(1).AddSeconds(-1); } decimal? meterFrom = null; if (txtMeterSquareFrom.Value.HasValue) { meterFrom = Convert.ToDecimal(txtMeterSquareFrom.Value); } decimal? meterTo = null; if (txtMeterSquareTo.Value.HasValue) { meterTo = Convert.ToDecimal(txtMeterSquareTo.Value); } int gender = radMale.Checked ? 1 : 0; gridRoomResult.VirtualItemCount = Business.BusinessMethods.CountPost((int)PostTypes.House, null, realestateTypeId, 232, cityId, districtId, null, null, null, gender, priceFrom, priceTo, dateFrom, dateTo, meterFrom, meterTo, UtilityHelper.FormatKeywords(txtKeywords.Text), false); List<Post> searchResults = Business.BusinessMethods.SearchPostPaging((int)PostTypes.House, null, realestateTypeId, 232, cityId, districtId, null, null, null, gender, priceFrom, priceTo, dateFrom, dateTo, meterFrom, meterTo, UtilityHelper.FormatKeywords(txtKeywords.Text), false, gridRoomResult.PageSize, pageNumber, sortExpress, sortExpressInvert); gridRoomResult.DataSource = searchResults; //Build Meta Description for Google Search Engine : StringBuilder builder = new StringBuilder(); foreach (Post post in searchResults) { builder.Append(post.Address + " giá : " + post.PriceString + ". \n"); } this.Page.MetaDescription = builder.ToString(); }
private void dgEquipmentOrdered_SortCommand(object sender, GridSortCommandEventArgs e) { dgEquipmentOrdered.Sort = e.SortExpression; }
protected void RadGrid1_SortCommand(object source, GridSortCommandEventArgs e) { fillGrids(2); }
protected void rdgvFairmadanGelenIstekler_SortCommand(object source, GridSortCommandEventArgs e) { int Yil = 0; int IstekNo = 0; if (txtFilterYil.Text.Trim() != string.Empty) { Yil = int.Parse(txtFilterYil.Text.Trim()); } else { Yil = 0; } if (txtFilterIstekNo.Text.Trim() != string.Empty) { IstekNo = int.Parse(txtFilterIstekNo.Text.Trim()); } else { IstekNo = 0; } GridBagla(int.Parse(Session["IstekleriGosterilecekFirmaId"].ToString()), Yil, IstekNo); }
private void BindGridData(GridSortCommandEventArgs sortEventArgs) { if (SessionManager.CurrentUser == null) return; int pageSize = 15; int pageNumber = gridActions.CurrentPageIndex + 1; string sortExpress = string.Empty; string sortExpressInvert = string.Empty; foreach (GridSortExpression item in gridActions.MasterTableView.SortExpressions) { GridSortOrder newSortOrder = item.SortOrder; if (sortEventArgs != null && item.FieldName == sortEventArgs.SortExpression) { newSortOrder = sortEventArgs.NewSortOrder; } if (!string.IsNullOrEmpty(sortExpress) && newSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (newSortOrder == GridSortOrder.Ascending) { sortExpress += item.FieldName + " ASC"; sortExpressInvert += item.FieldName + " DESC"; } else if (newSortOrder == GridSortOrder.Descending) { sortExpress += item.FieldName + " DESC"; sortExpressInvert += item.FieldName + " ASC"; } } if (sortEventArgs != null && !sortExpress.Contains(sortEventArgs.SortExpression)) { if (!string.IsNullOrEmpty(sortExpress) && sortEventArgs.NewSortOrder != GridSortOrder.None) { sortExpress += ", "; sortExpressInvert += ", "; } if (sortEventArgs.NewSortOrder == GridSortOrder.Ascending) { sortExpress += sortEventArgs.SortExpression + " ASC"; sortExpressInvert += sortEventArgs.SortExpression + " DESC"; } else if (sortEventArgs.NewSortOrder == GridSortOrder.Descending) { sortExpress += sortEventArgs.SortExpression + " DESC"; sortExpressInvert += sortEventArgs.SortExpression + " ASC"; } } if (!string.IsNullOrEmpty(sortExpress)) { if (sortExpress.Contains("Hour")) { sortExpress = sortExpress.Replace("Hour", "Heure"); sortExpressInvert = sortExpressInvert.Replace("Hour", "Heure"); } if (sortExpress.Contains("CandidateFullName")) { sortExpress = sortExpress.Replace("CandidateFullName", "CanLastName"); sortExpressInvert = sortExpressInvert.Replace("CandidateFullName", "CanLastName"); } if (sortExpress.Contains("CompanyName")) { sortExpress = sortExpress.Replace("CompanyName", "SocNom"); sortExpressInvert = sortExpressInvert.Replace("CompanyName", "SocNom"); } } else { sortExpress = "ActionId DESC"; sortExpressInvert = "ActionId ASC"; } string type = "MyActiveThisWeek"; if (!string.IsNullOrEmpty(Request.QueryString["type"])) { type = Request.QueryString["type"]; } ActionSearchCriteria criteria = new ActionSearchCriteria(); switch (type) { case "MyActiveThisWeek": DateTime dateFrom = Common.GetBeginDayOfWeek(DateTime.Today); criteria.DateFrom = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0); criteria.Active = "Yes"; criteria.Responsible = SessionManager.CurrentUser.UserID; break; case "MyActive": criteria.Active = "Yes"; criteria.Responsible = SessionManager.CurrentUser.UserID; break; case "MyInactive": criteria.Active = "No"; criteria.Responsible = SessionManager.CurrentUser.UserID; break; case "MyAllActions": criteria.Responsible = SessionManager.CurrentUser.UserID; break; case "AllActive": criteria.Active = "Yes"; break; case "AllInactive": criteria.Active = "No"; break; case "AllActions": break; case "search": if (!string.IsNullOrEmpty(Request.QueryString["active"])) criteria.Active = Request.QueryString["active"]; if (!string.IsNullOrEmpty(Request.QueryString["dateFrom"])) criteria.DateFrom = DateTime.ParseExact(Request.QueryString["dateFrom"], "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat); if (!string.IsNullOrEmpty(Request.QueryString["dateTo"])) criteria.DateTo = DateTime.ParseExact(Request.QueryString["dateTo"], "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat); if (!string.IsNullOrEmpty(Request.QueryString["candidate"])) criteria.CanName = Request.QueryString["candidate"]; if (!string.IsNullOrEmpty(Request.QueryString["company"])) criteria.ComName = Request.QueryString["company"]; if (!string.IsNullOrEmpty(Request.QueryString["typeAction"])) criteria.TypeActionID = int.Parse(Request.QueryString["typeAction"]); if (!string.IsNullOrEmpty(Request.QueryString["description"])) criteria.Description = Request.QueryString["description"]; if (!string.IsNullOrEmpty(Request.QueryString["responsible"])) criteria.Responsible = Request.QueryString["responsible"]; break; } ActionRepository repo = new ActionRepository(); gridActions.VirtualItemCount = repo.CountActions(criteria, pageSize, pageNumber, sortExpress, sortExpressInvert); IList<Neos.Data.Action> list = repo.SearchActions(criteria, pageSize, pageNumber, sortExpress, sortExpressInvert); gridActions.DataSource = list; }