递归删除层级记录

最新推荐文章于 2022-07-29 15:22:33 发布

andycode

最新推荐文章于 2022-07-29 15:22:33 发布

阅读量945

点赞数

分类专栏： C#应用文章标签： string null delete

本文链接：https://blog.youkuaiyun.com/andycode/article/details/6561624

版权

C#应用专栏收录该内容

32 篇文章

订阅专栏

PrimaryKey    UpLevelCompCode   UpLevelCompName   CurrentLevelCompCode    CurrentLevelCompName    CurrentLevel
1       0                             0                             NULL                                    NULL                        0
2                           0                             0                                 1                                      1                              1
3                           0                             0                                 2                                      2                              1
4                           1                             1                                 3                                      3                              2
5                           1                             1                                 4                                      4                              2
6                           3                             3                                 5                                      5                              3
7                           3                             3                                 6                                      6                              3

//递归删除层级记录
public static void Delete(string code,int level,string sign)
{
    if(level>0)
    {
    System.Data.DataSet ds = bll.SelectDepartLevelMaintainByFilter(" and "+sign+" = '"+code+"' and CurrentLevel="+level);
    if(ds!=null)
    {
        if(ds.Tables[0]!=null)
        {
            if(ds.Tables[0].Rows.Count>0)
            {
                foreach(System.Data.DataRow dr in ds.Tables[0].Rows)
                {
                    string _code = dr["CurrentLevelCompCode"].ToString().Trim();
                    int _level = Convert.ToInt32(dr["CurrentLevel"].ToString().Trim());
                    long _pk = Convert.ToInt64(dr["PrimaryKey"].ToString().Trim());
                    Delete(_code,_level+1,"UpLevelCompCode");
                    bll.DeleteDepartLevelMaintain(_pk);
                }
            }
        }
    }
   }
}
DepartLevelMaintainBLL bll = new DepartLevelMaintainBLL ();
System.Data.DataRow dr = bll.SelectDepartLevelMaintainByFilter(" and PrimaryKey = "+2).Tables[0].Rows[0];
string _code = dr["CurrentLevelCompCode"].ToString().Trim();
int _level = Convert.ToInt32(dr["CurrentLevel"].ToString().Trim());
TestMethod.Delete(_code,_level,"CurrentLevelCompCode");