public static TypeClass GetRootType(int id)
{
TypeClass parent = GetType(id);
int parentId = parent.ParentId;
while (parentId > 0)
{
parent = GetType(parentId);
parentId = parent.ParentId;
}
return(parent);
}
public static TypeClass GetType(int id)
{
string sql = "select * from T_Type where ID = " + id.ToString();
DataTable ti = OleDAL.GetRecords(sql);
if (ti != null && ti.Rows.Count > 0)
{
TypeClass type = new TypeClass(id, ti.Rows[0]["TypeName"].ToString(), ti.Rows[0]["Description"].ToString(), (int)ti.Rows[0]["ParentID"]);
return(type);
}
return(null);
}
public static List <TypeClass> GetSubTypes(int parentID)
{
string sql = "select * from T_Type where ParentID=" + parentID.ToString();
DataTable types = OleDAL.GetRecords(sql);
List <TypeClass> ts = new List <TypeClass>();
for (int i = 0; i < types.Rows.Count; i++)
{
TypeClass tc = new TypeClass((int)types.Rows[i]["ID"], types.Rows[i]["TypeName"].ToString(), types.Rows[i]["Description"].ToString(), (int)types.Rows[i]["ParentID"]);
ts.Add(tc);
}
return(ts);
}
public static string GetTypeNameOfInfo(int infoID)
{
List <string> typeArray = new List <string>();
TypeClass type = GetType(GetInfo(infoID).TypeId);
typeArray.Add(type.TypeName);
int parentId = type.ParentId;
while (parentId > 0)
{
TypeClass parent = GetType(parentId);
typeArray.Add(parent.TypeName);
parentId = parent.ParentId;
}
typeArray.Reverse();
return(string.Join(".", typeArray.ToArray()));
}
private static string GetAllParentIds(int typeId)
{
string typeIdStr = "";
TypeClass type = GetType(typeId);
int parentId = type.ParentId;
while (parentId > 0)
{
TypeClass parent = GetType(parentId);
if (typeIdStr == "")
{
typeIdStr += parent.Id;
}
else
{
typeIdStr += "," + parent.Id;
}
parentId = parent.ParentId;
}
return(typeIdStr);
}
public static List <TypeClass> GetTypes(string where)
{
string sql = "select * from T_Type";
if (!string.IsNullOrEmpty(where))
{
where = where.Trim().ToLower();
if (where.StartsWith("and "))
{
where = where.Substring(4);
}
sql += " where (1=1) and " + where;
}
DataTable types = OleDAL.GetRecords(sql);
List <TypeClass> ts = new List <TypeClass>();
for (int i = 0; i < types.Rows.Count; i++)
{
TypeClass tc = new TypeClass((int)types.Rows[i]["ID"], types.Rows[i]["TypeName"].ToString(), types.Rows[i]["Description"].ToString(), (int)types.Rows[i]["ParentID"]);
ts.Add(tc);
}
return(ts);
}
public TypeNode(List <TypeClass> types)
: base()
{
this.type = null;
this.types = types;
}
public TypeNode(TypeClass type)
: base(type.Id.ToString())
{
this.type = type;
}
