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_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 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")); }
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 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); } } }
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 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 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(); }