/// <summary> /// 根据单位ID 获取单位下部门集合 /// </summary> /// <param name="dwid">单位id</param> /// <returns>部门集合</returns> private static DataTable GetBmNodeBydw(string dwid) { var bll = new EDRS.BLL.XT_ZZJG_BMBM(request); var sbwhere = new StringBuilder(); var objectValues = new object[1]; sbwhere.Append(" and FBMBM is null and SFSC = 'N' "); sbwhere.Append(" and DWBM=:DWBM "); objectValues[0] = dwid; var ds = bll.GetList(sbwhere.ToString(), objectValues); return(ds.Tables.Count > 0 ? ds.Tables[0] : new DataTable()); }
/// <summary> /// 根据部门父ID获取部门下子部门 /// </summary> /// <param name="parentid">父部门ID</param> /// <returns>子部门集合</returns> private static DataTable GetBmNodeBybmParentid(string parentid) { var bll = new EDRS.BLL.XT_ZZJG_BMBM(request); var sbwhere = new StringBuilder(); var objectValues = new object[1]; if (!string.IsNullOrWhiteSpace(parentid)) { sbwhere.Append(" and FBMBM=:FBMBM "); objectValues[0] = parentid; } sbwhere.Append(" and FBMBM is null and SFSC = 'N' "); var ds = bll.GetList(sbwhere.ToString(), objectValues); return(ds.Tables.Count > 0 ? ds.Tables[0] : new DataTable()); return(null); }