/// <summary>
/// 获取菜单树
/// </summary>
/// <returns></returns>
public List <Tree> GetMenuTree()
{
List <Tree> Menus = new List <Tree>();
TbSysSubSystemDefine tb = new TbSysSubSystemDefine();
List <TbSysSubSystemDefine> list = tb.FetchAll();
foreach (var item in list)
{
Tree head = new Tree()
{
Level = 0, Name = item.SubSystemName, Code = ""
};
Menus.Add(head);
TbSysMenu child = new TbSysMenu();
List <Tree> level2 = child.FindNext(item.SubSystemId);
head.Childs = level2;
foreach (var item2 in head.Childs)
{
item2.Childs = GetChildren(item2);
}
}
return(Menus);
}
/// <summary>
/// 以主键为参数删除一条数据
/// </summary>
static public void DeleteBy(string subSystemId)
{
TbSysSubSystemDefine tbl;
tbl = new TbSysSubSystemDefine();
tbl.SubSystemId = subSystemId;
tbl.Delete();
}
/// <summary>
/// 以主键为参数获取数据，并创建类的实例
/// </summary>
/// <returns>类的实例</returns>
static public TbSysSubSystemDefine CreateBy(string subSystemId)
{
TbSysSubSystemDefine tbl;
bool hasData;
tbl = new TbSysSubSystemDefine();
hasData = tbl.FetchBy(subSystemId);
if (!hasData)
{
return(null);
}
else
{
return(tbl);
}
}
public List <TbSysSubSystemDefine> FetchAll()
{
List <TbSysSubSystemDefine> list = new List <TbSysSubSystemDefine>();
string sSQL = "select * from sbt_sys_sub_system_define";
//======= 2. 运行SQL语句 ========
DataSet dataSet = DataHelper.GetInstance("CenterCord").ExecuteDataSet(sSQL);
//======= 3. 读取记录 ========
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
TbSysSubSystemDefine tb = new TbSysSubSystemDefine();
tb.AssignByDataRow(dataSet.Tables[0].Rows[i]);
list.Add(tb);
}
return(list);
}
