Ejemplo n.º 1
0
        /// <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());
        }
Ejemplo n.º 2
0
        /// <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);
        }