/// <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());
}