/// <summary>
/// 通过传入的栏目编号找出并返回当前栏目编号及其所有子栏目编号
/// </summary>
/// <param name="bp_code"></param>
public DataSet FindAllChildAndSelfCode(string bp_code)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT BP_CODE FROM F_T_PUB_BASICPERM WHERE ");
strSql.Append("PARENT_ID IN (SELECT BP_CODE FROM F_T_PUB_BASICPERM WHERE ");
strSql.Append("PARENT_ID =@BP_CODE) UNION SELECT BP_CODE FROM F_T_PUB_BASICPERM WHERE PARENT_ID =@BP_CODE");
SqlParameterCollection OParmList = SqlHelper.GetSqlParmCollection();
SqlHelper.AddParam("BP_CODE", SqlDbType.NVarChar, bp_code, OParmList);
return SqlHelper.ExecuteDataSetByParm(strSql.ToString(), OParmList);
}
catch (Exception ex)
{
throw ex;
}
}