protected void gvOrders_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "CustomDescription") { List <string> exsistingNewValues = new List <string>(); List <FilterValue> newValues = new List <FilterValue>(); foreach (FilterValue value in e.Values) { string description = value.Value; string[] items = description.Split(';'); foreach (string item in items) { if (!exsistingNewValues.Contains(item)) { exsistingNewValues.Add(item); FilterValue newValue = new FilterValue(); newValue.DisplayText = item.Substring(1, item.Length - 2); newValue.Query = String.Format("Contains([{0}], '{1}')", e.Column.FieldName, item); newValues.Add(newValue); } } } e.Values.Clear(); e.Values.AddRange(newValues); } }
protected virtual void PrepareTotalFilterItemsType(ASPxGridViewHeaderFilterEventArgs e, string _field) { int count = e.Values.Count; ArrayList list = new ArrayList(); if (count >= 3) { for (int i = 3; i < count; i++) { list.Add(e.Values[i].Value); } } e.Values.Clear(); if (e.Column.Settings.HeaderFilterMode == HeaderFilterMode.List) { e.AddShowAll(); } for (int i = 0; i < list.Count; i++) { if (Utils.CStrDef(list[i]) == "0") { e.AddValue("Chưa nhập tên", Utils.CStrDef(list[i]), string.Format("[{0}] == {1}", _field, list[i])); } else { e.AddValue(GetType(list[i]), Utils.CStrDef(list[i]), string.Format("[{0}] == {1}", _field, list[i])); } } list.Clear(); }
protected void ASPxGridView1_project_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "USER_ID") { PrepareTotalFilterItemsNV(e, "USER_ID"); } }
protected void grid_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName != "CategoryNameNull") { return; } e.Values.Insert(0, FilterValue.CreateShowBlanksValue(e.Column, "Blanks")); e.Values.Insert(1, FilterValue.CreateShowNonBlanksValue(e.Column, "Non Blanks")); }
protected void gvNetworkUtil_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "Persen1") { PreparePersen1FilterItems(e); } if (e.Column.FieldName == "Persen2") { PreparePersen2FilterItems(e); } }
//处理表头否控制字段的过滤 protected void ASPxGridView1_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (object.Equals(e.Column, ASPxGridView1.Columns["EVENT_FLAG"])) { e.Values.Clear(); e.AddShowAll(); e.AddValue("Yes", "1"); e.AddValue("No", "0"); return; } }
protected void ASPxGridView1_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName != "Month") { return; } e.Values.Clear(); for (int i = 1; i <= 12; i++) { e.AddValue(NumberMonthConverter.GetTitleOfMonth(i), i.ToString()); } }
protected void GridView_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "ProductName") { e.Values.Clear(); // Adding custom values from unsafe data source // Safe approach - Display Text is encoded e.AddValue(HttpUtility.HtmlEncode("<b>T</b>est <img src=1 onerror=alert('XSS') />"), "1"); // Unsafe approach - Display Text is not encoded //e.AddValue("<b>T</b>est <img src=1 onerror=alert('XSS') />", "1"); } }
protected virtual void PreparePersen2FilterItems(ASPxGridViewHeaderFilterEventArgs e) { e.Values.Clear(); if (e.Column.Settings.HeaderFilterMode == HeaderFilterMode.List) { e.AddShowAll(); } e.AddValue(string.Format("< 60%"), "", string.Format("[Persen2] < 60")); e.AddValue(string.Format(">= 60%"), "", string.Format("[Persen2] >= 60")); e.AddValue(string.Format(">= 70%"), "", string.Format("[Persen2] >= 70")); e.AddValue(string.Format(">= 80%"), "", string.Format("[Persen2] >= 80")); e.AddValue(string.Format(">= 90%"), "", string.Format("[Persen2] >= 90")); }
public virtual void PrepareListResponsaveis(ASPxGridViewHeaderFilterEventArgs e) { e.Values.Clear(); FirebirdSql.Data.FirebirdClient.FbConnection conn = AcessoDados.AcessoDados.getConn(); FirebirdSql.Data.FirebirdClient.FbCommand comando = new FirebirdSql.Data.FirebirdClient.FbCommand("Select * from sci_usuarios where usu_idundfuncional is not null", conn); conn.Open(); FirebirdSql.Data.FirebirdClient.FbDataReader dr = comando.ExecuteReader(); while (dr.Read()) { e.AddValue(dr["usu_nome"].ToString(), dr["usu_nome"].ToString()); } conn.Close(); }
public virtual void PrepareListCentroCusto(ASPxGridViewHeaderFilterEventArgs e) { e.Values.Clear(); FirebirdSql.Data.FirebirdClient.FbConnection conn = AcessoDados.AcessoDados.getConn(); FirebirdSql.Data.FirebirdClient.FbCommand comando = new FirebirdSql.Data.FirebirdClient.FbCommand("Select cennome from centrocusto", conn); conn.Open(); FirebirdSql.Data.FirebirdClient.FbDataReader dr = comando.ExecuteReader(); while (dr.Read()) { e.AddValue(dr["cennome"].ToString(), dr["cennome"].ToString()); } conn.Close(); }
protected void GridViewMalwareHeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { e.Values.Clear(); if (e.Column.FieldName == "Class") { foreach (var cls in MlwrManager.GetMlwrClassList()) { e.AddValue(cls, cls); } } if (e.Column.FieldName == "Name") { foreach (var cls in MlwrManager.GetMlwrNameList()) { e.AddValue(cls, cls); } } if (e.Column.FieldName == "Path") { foreach (var cls in MlwrManager.GetMlwrPathList()) { e.AddValue(cls, cls); } } if (e.Column.FieldName == "Loaded") { foreach (var cls in MlwrManager.GetMlwrLoadedList()) { e.AddValue(cls, cls); } } }
protected virtual void PrepareTotalFilterItemsQLT(ASPxGridViewHeaderFilterEventArgs e) { int count = e.Values.Count; ArrayList list = new ArrayList(); if (count >= 3) { for (int i = 3; i < count; i++) { list.Add(e.Values[i].Value); } } e.Values.Clear(); if (e.Column.Settings.HeaderFilterMode == HeaderFilterMode.List) e.AddShowAll(); for (int i = 0; i < list.Count; i++) { if (Utils.CStrDef(list[i]) == "0") e.AddValue("Chưa nhập tên", Utils.CStrDef(list[i]), string.Format("[QL_THUE_DIST] == {0}", list[i])); else e.AddValue(getPropertyName(list[i]), Utils.CStrDef(list[i]), string.Format("[QL_THUE_DIST] == {0}", list[i])); } list.Clear(); }
protected void ASPxGridView1_project_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { }
protected void ASPxGridView1_project_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "NV_KD") PrepareTotalFilterItems(e, "NV_KD"); if (e.Column.FieldName == "NV_GN") PrepareTotalFilterItems(e, "NV_GN"); if (e.Column.FieldName == "NV_KT") PrepareTotalFilterItems(e, "NV_KT"); if (e.Column.FieldName == "QL_THUE_DIST") PrepareTotalFilterItemsQLT(e); }
protected void ASPxGridView1_project_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { }
protected virtual void PrepareTotalFilterItemsNV(ASPxGridViewHeaderFilterEventArgs e, string _field) { int count = e.Values.Count; ArrayList list = new ArrayList(); if (count >= 3) { for (int i = 3; i < count; i++) { list.Add(e.Values[i].Value); } } e.Values.Clear(); if (e.Column.Settings.HeaderFilterMode == HeaderFilterMode.List) e.AddShowAll(); for (int i = 0; i < list.Count; i++) { if (Utils.CStrDef(list[i]) == "0") e.AddValue("Chưa nhập tên", Utils.CStrDef(list[i]), string.Format("[{0}] == {1}", _field, list[i])); else e.AddValue(GetUser(list[i]), Utils.CStrDef(list[i]), string.Format("[{0}] == {1}", _field, list[i])); } list.Clear(); }
protected void ASPxGridView1_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "RESPONSAVEL") PrepareListResponsaveis(e); if (e.Column.FieldName == "CENNOME") PrepareListCentroCusto(e); }
protected void ASPxGridView1_project_HeaderFilterFillItems(object sender, ASPxGridViewHeaderFilterEventArgs e) { if (e.Column.FieldName == "USER_ID") PrepareTotalFilterItemsNV(e, "USER_ID"); }