SqlString = "select distinct(substring(cast(instore.`Date` as char),1,7)) as dDate from instore;";
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
treeView1.Nodes.Add("-3", row["dDate"].ToString().Trim());
}private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
if (e.Node.Nodes.Count == 0)
{
if (e.Node.Name == "-3")
{
dataSet1.Clear();
SqlString = "select distinct(substring(cast(instore.`Date` as char),1,10)) as dDate from
instore order by instore.`Date` ASC;";
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
e.Node.Nodes.Add("-2", row["dDate"].ToString());
}
}
else if (e.Node.Name == "-2")
{
dataSet1.Clear();
SqlString = "select instore.InstoreKey,instore.InstoreID from instore "
+ "where instore.`Date`='" + e.Node.Text + "'"
+ "order by instore.InstoreID ASC;";
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
e.Node.Nodes.Add(row["instoreKey"].ToString(), row["InstoreID"].ToString());
} }
else if (e.Node.Name.Length > 0)
{
LoadData(e.Node.Name);
}
}
這是我的treeview的初始化。
比如今天新增一笔资料(w20090710001).现在在保存的时候要更新treeview.比如今天是20090710.则在treeview中要新增加一个节点2009-07-10.在该节点下新增该单号,并展开数据。
按删除的时候,不删除该单号。只是把 该单号的flag置为1.然后把它的样式:比如颜色变成红色,斜体等。。
请问怎么实现好呢!
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
treeView1.Nodes.Add("-3", row["dDate"].ToString().Trim());
}private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
if (e.Node.Nodes.Count == 0)
{
if (e.Node.Name == "-3")
{
dataSet1.Clear();
SqlString = "select distinct(substring(cast(instore.`Date` as char),1,10)) as dDate from
instore order by instore.`Date` ASC;";
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
e.Node.Nodes.Add("-2", row["dDate"].ToString());
}
}
else if (e.Node.Name == "-2")
{
dataSet1.Clear();
SqlString = "select instore.InstoreKey,instore.InstoreID from instore "
+ "where instore.`Date`='" + e.Node.Text + "'"
+ "order by instore.InstoreID ASC;";
dataSet1 = DBHelper.ExecuteDataSet(SqlString, "instore");
foreach (DataRow row in dataSet1.Tables["instore"].Rows)
{
e.Node.Nodes.Add(row["instoreKey"].ToString(), row["InstoreID"].ToString());
} }
else if (e.Node.Name.Length > 0)
{
LoadData(e.Node.Name);
}
}
這是我的treeview的初始化。
比如今天新增一笔资料(w20090710001).现在在保存的时候要更新treeview.比如今天是20090710.则在treeview中要新增加一个节点2009-07-10.在该节点下新增该单号,并展开数据。
按删除的时候,不删除该单号。只是把 该单号的flag置为1.然后把它的样式:比如颜色变成红色,斜体等。。
请问怎么实现好呢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货