递归实例
来源:互联网 发布:编个写歌的软件下载 编辑:程序博客网 时间:2024/06/05 08:32
private ArrayList SecInfoOption(int id)//声明方法
{
ArrayList list = new ArrayList();
SqlParameter sp_Father_ID = new SqlParameter("@PurViewFatherID", SqlDbType.Int, 4);
sp_Father_ID.Value = id;
using (DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.StoredProcedure, "P_PurView_GetAllRoot", "cPur", new SqlParameter[] { sp_Father_ID }))
{
string tempid = "0";
DataTable dt = ds.Tables["cPur"];
for (int i = 0; i < dt.Rows.Count; i++)
{
tempid = dt.Rows[i]["PurViewID"].ToString();
if (tempid == "13" || tempid == "15" || tempid == "20")
{
continue;
}
m_pv tree = new m_pv();
tree.PurViewID = Convert.ToInt32(dt.Rows[i]["PurViewID"].ToString());
tree.PurViewFatherID = Convert.ToInt32(dt.Rows[i]["PurViewFatherID"].ToString());
if (i == (dt.Rows.Count - 1))
{
tree.Name = this.strLine + "└" + dt.Rows[i]["Name"].ToString();
}
else
{
tree.Name = this.strLine + "├" + dt.Rows[i]["Name"].ToString();
}
tree.LinkAddress = dt.Rows[i]["LinkAddress"].ToString();
list.Add(tree);
this.strLine = this.strLine + " ";
ArrayList lsd = this.SecInfoOption(Convert.ToInt32(dt.Rows[i]["PurViewID"].ToString()));
foreach (m_pv tp in lsd)
{
m_pv tempP = new m_pv();
tempP.PurViewID = tp.PurViewID;
tempP.PurViewFatherID = tp.PurViewFatherID;
tempP.Name = tp.Name;
tempP.RoleID = tp.RoleID;
tempP.LinkAddress = tp.LinkAddress;
tempP.CityID = tp.CityID;
list.Add(tempP);
}
this.strLine = this.strLine.Substring(0, this.strLine.Length - 2);
}
dt.Dispose();
ds.Dispose();
}
return list;
}
{
ArrayList list = new ArrayList();
SqlParameter sp_Father_ID = new SqlParameter("@PurViewFatherID", SqlDbType.Int, 4);
sp_Father_ID.Value = id;
using (DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.MainConnectionString, CommandType.StoredProcedure, "P_PurView_GetAllRoot", "cPur", new SqlParameter[] { sp_Father_ID }))
{
string tempid = "0";
DataTable dt = ds.Tables["cPur"];
for (int i = 0; i < dt.Rows.Count; i++)
{
tempid = dt.Rows[i]["PurViewID"].ToString();
if (tempid == "13" || tempid == "15" || tempid == "20")
{
continue;
}
m_pv tree = new m_pv();
tree.PurViewID = Convert.ToInt32(dt.Rows[i]["PurViewID"].ToString());
tree.PurViewFatherID = Convert.ToInt32(dt.Rows[i]["PurViewFatherID"].ToString());
if (i == (dt.Rows.Count - 1))
{
tree.Name = this.strLine + "└" + dt.Rows[i]["Name"].ToString();
}
else
{
tree.Name = this.strLine + "├" + dt.Rows[i]["Name"].ToString();
}
tree.LinkAddress = dt.Rows[i]["LinkAddress"].ToString();
list.Add(tree);
this.strLine = this.strLine + " ";
ArrayList lsd = this.SecInfoOption(Convert.ToInt32(dt.Rows[i]["PurViewID"].ToString()));
foreach (m_pv tp in lsd)
{
m_pv tempP = new m_pv();
tempP.PurViewID = tp.PurViewID;
tempP.PurViewFatherID = tp.PurViewFatherID;
tempP.Name = tp.Name;
tempP.RoleID = tp.RoleID;
tempP.LinkAddress = tp.LinkAddress;
tempP.CityID = tp.CityID;
list.Add(tempP);
}
this.strLine = this.strLine.Substring(0, this.strLine.Length - 2);
}
dt.Dispose();
ds.Dispose();
}
return list;
}
- 递归实例
- 递归实例
- 递归实例
- CTE 递归应用实例
- java递归实例
- 递归简单实例
- abap 递归 问题实例
- 递归的简单实例
- 递归的两个实例
- 递归的一个实例
- 递归调用实例
- TinyXML 递归遍历实例
- shell 递归调用实例
- 实例解析递归
- C#递归实例介绍
- makefile递归调用实例
- 递归算法经典实例
- java递归简单实例
- 下拉垂直导航菜单功能实现
- 同事的QCON会议记录分享
- 解决PowerDesigner 16 Generate Datebase For Sql2005 找不到sysproperties表的问题
- java多线程总结三:sleep()、join()、interrupt()示例
- iPhone开发过程中检测多次Release问题
- 递归实例
- Extract
- 表单验证功能实现
- 新建arcgis api for android 项目失败
- zigbee协议与开发-ZStack协议栈结构的初步解析
- Android 使用JSON进行网络数据交换
- Bada学习-(六)应用生命周期管理
- Java事件处理机制- 事件监听器的四种实现方式
- SqlServer安全机制