我正在寻找一个更新查询,它将每个条目更新一次:SET parent = (SELECT id WHERE hierarchy.id>hierarchy_1.id AND hierarchy_1.level=hierarchy.level-1)
有没有人能帮我拿到每个条目对应的家长, hierarchy</
new List<string>() { "1", "1.1", "1.2", "2", "2.1", "2.1.1", "2.1.2" };public class Hierarchy{ public int ParentID { get; set; }
public IList<Hierarchy<