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