private void ListBoxTagGroup_SelectedIndexChanged(object sender, EventArgs e)
{
listBoxTag.Items.Clear();
if (ListBoxTagGroup.SelectedItem == null)
{
return;
}
string tagGroupName = ListBoxTagGroup.SelectedItem.ToString();
int group_id = cap_map_tag_group[tagGroupName].id;
string sqlcmd = string.Format("SELECT * FROM edu.tag_def where is_valid = 1 and group_id ={0} ;", group_id);
var tags = globalDB.ExeQuery(sqlcmd, false);
while (tags.Read())
{
Db_struct.Tag_def tag = new Db_struct.Tag_def();
tag.id = Convert.ToInt32(tags.GetString(0));
tag.caption = tags.GetString(1);
if (!cap_map_tag.ContainsKey(tag.caption))
{
cap_map_tag.Add(tag.caption, tag);
}
listBoxTag.Items.Add(tag.caption);
// ListBoxTagGroup.
}
}
private static void ReadTagList()
{
string sqlcmd = string.Format("SELECT * FROM edu.tag_def where is_valid = 1;");
var tags = globalDB.ExeQuery(sqlcmd, false);
while (tags.Read())
{
Db_struct.Tag_def tag = new Db_struct.Tag_def();
tag.id = Convert.ToInt32(tags.GetString(0));
tag.caption = tags.GetString(1);
tag_list.Add(tag);
// ListBoxTagGroup.
}
}
