/// <summary> /// 是否存有子级 /// </summary> /// <param name="pgid">组PGID</param> /// <param name="incDisabled">是否包括禁用的</param> /// <param name="incUnVisible">是否包括不可见的</param> /// <returns></returns> public bool ExistsChildern(int pgid, bool incDisabled, bool incUnVisible) { GroupM g = new GroupM(); g.Where(g.P_PGID == pgid); if (incDisabled == false) { g.And(g.Is_Disabled != 1); } if (incUnVisible == false) { g.And(g.Is_Visibled == 1); } return(g.NoLock().Exists()); }
/// <summary> /// 是否存有组(@列=值) /// </summary> /// <param name="col">列</param> /// <param name="val">值</param> /// <returns></returns> public bool Exists(QColumn col, int val) { GroupM g = new GroupM(); g.Where(col == val); if (DEFINE_VALUE > 0) { g.And(g.R_PGID == DEFINE_VALUE); } return(g.NoLock().Exists()); }
/// <summary> /// 通过PG_Code获取PGID /// </summary> /// <param name="code">PG_Code</param> /// <returns>PGID</returns> public int CodeToPGID(string code) { GroupM g = new GroupM(); g.Where(g.PG_Code == code); if (DEFINE_VALUE > 0) { g.And(g.R_PGID == DEFINE_VALUE); } return(g.NoLock().SelectValue <int>(g.PGID, 0)); }
/// <summary> /// /// </summary> /// <param name="pgidS"></param> /// <returns></returns> protected List <T> DoGetGroups(params int[] pgidS) { GroupM g = new GroupM(); g.Where(g.Is_Visibled != 0); if (pgidS.Length > 0) { g.And(g.PGID.In(pgidS)); } return(g.Select <T>()); }
/// <summary> /// 获取所有组 /// </summary> /// <returns></returns> protected List <T> DoGetGroups() { GroupM g = new GroupM(); g.Where(g.Is_Visibled != 0); if (DEFINE_VALUE > 0) { g.And(g.R_PGID == DEFINE_VALUE); } return(g.NoLock() .OrderBy(g.Order_Index) .Select <T>()); }
/// <summary> /// /// </summary> /// <param name="disable"></param> /// <param name="pgids"></param> /// <returns></returns> protected bool DoDisableGroup(bool disable, params int[] pgids) { if (pgids == null || pgids.Length < 1) { throw new BCFException("参数异常:(pgids == null || pgids.Length < 1)"); } //------------------------------------- GroupM g = new GroupM(); g.Is_Disabled.Value = disable; g.Last_Update.Value = DateTime.Now; g.Where(g.PGID.In(pgids)); if (DEFINE_VALUE > 0) { g.And(g.R_PGID == DEFINE_VALUE); } //------------------------------------------------ return(g.Update()); }