public void CreaTree(TreeView tree, int open)
{
string queryCat;
queryCat = "SELECT * FROM CatalogCategories WHERE ParentID = 0";
DataSet dsC = DatabaseConnection.CreateDataset(queryCat);
foreach (DataRow dr in dsC.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
string del = "0";
if (Convert.ToInt32(DatabaseConnection.SqlScalar("SELECT COUNT(*) FROM CATALOGCATEGORIES WHERE PARENTID=" + dr["Id"].ToString())) > 0)
{
del = "1";
}
else if (Convert.ToInt32(DatabaseConnection.SqlScalar("SELECT COUNT(*) FROM CATALOGPRODUCTS WHERE CATEGORY=" + dr["Id"].ToString())) > 0)
{
del = "1";
}
tv.Text = "<a href=\"javascript:copyData('" + dr["Id"].ToString() + "','" + dr["Description"].ToString() + "','" + dr["ParentID"].ToString() + "'," + del + ",'" + ((dr["EMAILOWNER"] != DBNull.Value)?dr["EMAILOWNER"].ToString():string.Empty) + "')\" style=\"color:black;text-decoration:none\">" + dr["Description"].ToString() + "</a>";
tv.NodeData = dr["Id"].ToString();
tv.Expanded = FillCategoryTree(Convert.ToInt32(dr["Id"]), tv, open); // Chiamata ricorsiva per fare le foglie
tree.Nodes.Add(tv);
}
tree.CssClass = "normal";
}
public void CreaTree(TreeView tree, int open)
{
string queryCat;
queryCat = "SELECT * FROM FILESCATEGORIES WHERE PARENTID = 0";
DataSet dsC = DatabaseConnection.CreateDataset(queryCat);
TreeNode tv1 = new TreeNode();
tv1.Text = "<a href=\"javascript:copyData('', '','CategoryTextSearch','CategoryIdSearch','Find')\" style=\"color:black;text-decoration:none\">" + Root.rm.GetString("Dsttxt21") + "</a>";
tree.Nodes.Add(tv1);
foreach (DataRow dr in dsC.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
tv.Text = "<a href=\"javascript:copyData('" + dr["Id"].ToString() + "', '" + dr["Description"].ToString() + "','CategoryTextSearch','CategoryIdSearch','Find')\" style=\"color:black;text-decoration:none\">" + dr["Description"].ToString() + "</a>";
tv.NodeData = dr["Id"].ToString();
tv.Expanded = FillCategoryTree(Convert.ToInt32(dr["Id"]), tv, open); // Chiamata ricorsiva per fare le foglie
tv.ImageUrl = "/webctrl_client/1_0/treeimages/folder.gif";
tv.ExpandedImageUrl = "/webctrl_client/1_0/treeimages/folderopen.gif";
tree.Nodes.Add(tv);
}
tree.CssClass = "normal";
}
private TreeView _treeview; // parent
#endregion Fields
#region Constructors
/// <summary>
/// Initializes a new instance of a TreeNode.
/// </summary>
public TreeNode()
: base()
{
_level = -1;
_treeview = null;
_strInheritedType = null;
_NodeTypeIndex = -1;
_bBound = false;
_Nodes = new TreeNodeCollection(this);
}
public void FillTree(Microsoft.Web.UI.WebControls.TreeView tvtemp, string strQueryType)
{
string strProvID = this.txtProviderID.Text.Trim();
string strProvName = this.txtProviderName.Text.Trim();
string strGoodsID = this.txtGoodsID.Text.Trim();
string strGoodsName = this.txtGoodsName.Text.Trim();
Hashtable htpara = new Hashtable();
htpara.Add("strProvID", strProvID);
htpara.Add("strProvName", strProvName);
htpara.Add("strGoodsID", strGoodsID);
htpara.Add("strGoodsName", strGoodsName);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
DataTable table = StoBusi.GetProviderStockFillTree(strQueryType, htpara);
tvtemp.Nodes.Clear();
if (strQueryType == "prov")
{
Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
node.ID = "0";
node.Text = "供应商";
node.Type = "prov";
node.ImageUrl = "../image/promotion.png";
tvtemp.Nodes.Add(node);
}
else
{
Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
node.ID = "0";
node.Text = "货品";
node.Type = "good";
node.ImageUrl = "../image/rss.png";
tvtemp.Nodes.Add(node);
DataTable dtPClass = (DataTable)Application["PClass"];
foreach (DataRow dr in dtPClass.Rows)
{
if (dr["vcCommSign"].ToString() == "Pack" || dr["vcCommSign"].ToString() == "Raw")
{
node = new Microsoft.Web.UI.WebControls.TreeNode();
node.ID = "0";
node.Text = dr["vcCommName"].ToString();
node.Type = "good";
node.ImageUrl = "../image/rss.png";
tvtemp.Nodes[0].Nodes.Add(node);
}
}
}
foreach (DataRow row in table.Rows)
{
if (strQueryType == "prov")
{
Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
node.ID = row["cnvcPrvdCode"].ToString();
node.Text = row["cnvcPrvdName"].ToString();
node.Type = "prov";
node.ImageUrl = "../image/next.png";
tvtemp.Nodes[0].Nodes.Add(node);
}
else
{
Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
node.ID = row["cnvcGoodsName"].ToString();
node.Text = row["cnvcGoodsName"].ToString();
node.Type = "good";
node.ImageUrl = "../image/next.png";
foreach (Microsoft.Web.UI.WebControls.TreeNode notmp in tvtemp.Nodes[0].Nodes)
{
if (notmp.Text == row["cnvcProductClassName"].ToString())
{
notmp.Nodes.Add(node);
break;
}
}
}
}
}
public void GenerateRegionTree(Microsoft.Web.UI.WebControls.TreeView tr_region)
{
tr_region.Nodes.Clear();
dictionary.GenerateTree(tr_region);
}
public void GenerateTree(Microsoft.Web.UI.WebControls.TreeView tr_region)
{
BusinessObjectCollection ParentCollection = new BusinessObjectCollection("Dictionary");
ParentCollection.SessionInstance = session;
BusinessFilter filter = new BusinessFilter("Dictionary");
filter.AddFilterItem("Parent", Level.Top, Operation.Equal, FilterType.NumberType, AndOr.AND);
filter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND);
// filter.AddFilterItem("Parent","0",Operation.Equal,FilterType.NumberType,AndOr.AND);
// if (type == DictionaryType.Region)
// {
// filter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else if (type == DictionaryType.Product)
// {
// filter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else
// {
// filter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
filter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
ParentCollection.AddFilter(filter);
DataTable parenttable = ParentCollection.GetDataTable();
for (int i = 0; i < parenttable.Rows.Count; i++)
{
Microsoft.Web.UI.WebControls.TreeNode node = new TreeNode();
node.NodeData = parenttable.Rows[i]["PKID"].ToString();
node.Text = parenttable.Rows[i]["Name"].ToString();
node.ID = parenttable.Rows[i]["path"].ToString();
tr_region.Nodes.Add(node);
BusinessObjectCollection childCollection = new BusinessObjectCollection("Dictionary");
childCollection.SessionInstance = session;
BusinessFilter subfilter = new BusinessFilter("Dictionary");
subfilter.AddFilterItem("Parent", parenttable.Rows[i]["PKID"].ToString(), Operation.Equal, FilterType.NumberType, AndOr.AND);
subfilter.AddFilterItem("Type", Convert.ToString((int)type), Operation.Equal, FilterType.NumberType, AndOr.AND);
// if (type == DictionaryType.Region)
// {
// subfilter.AddFilterItem("Type","1",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else if (type == DictionaryType.Product)
// {
// subfilter.AddFilterItem("Type","2",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
// else
// {
// subfilter.AddFilterItem("Type","3",Operation.Equal,FilterType.NumberType,AndOr.AND);
// }
subfilter.AddFilterItem("IsValid", "1", Operation.Equal, FilterType.NumberType, AndOr.AND);
childCollection.AddFilter(subfilter);
DataTable childtable = childCollection.GetDataTable();
GenerateElement(node, childtable);
}
}
public static string GetSelectedPath(Microsoft.Web.UI.WebControls.TreeView tv, string index)
{
Microsoft.Web.UI.WebControls.TreeNode node;
node = tv.GetNodeFromIndex(index);
return(node.ID);
}
