/// <summary>
/// 获取栏目当前位置
/// </summary>
/// <param name="CID">栏目ID，多个ID用,号隔开</param>
public DataTable GetThisPlace(string CID)
{
SqlLoading sl = new SqlLoading();
sl.AddSqlWhere("CID", CID, OperateSign.In);
return(dal.GetThisPlace(sl));
}
/// <summary>
/// 获取模块顶级栏目
/// </summary>
/// <param name="count">返回记录总数</param>
/// <returns>模块对象泛型集合</returns>
public List <Modules> GetTopnav(out int count)
{
SqlLoading sl = new SqlLoading();
sl.AddSqlWhere("ParentID", "'M0'");
sl.AddSqlWhere("IsEnable", 1, JoinSign.And);
return(dal.GetList(sl, out count));
}
/// <summary>
/// 获取模块子栏目
/// </summary>
/// <param name="count">返回记录总数</param>
/// <returns>模块对象泛型集合</returns>
public List <Modules> GetSubnav(out int count)
{
SqlLoading sl = new SqlLoading();
sl.AddSqlWhere("ModuleDepth", 1, OperateSign.GreatThan);
sl.AddSqlWhere("IsEnable", 1, JoinSign.And);
return(dal.GetList(sl, out count));
}
/// <summary>
/// 根据父ID获取模块子栏目
/// </summary>
/// <param name="parentID">父模块ID</param>
/// <param name="moduleDepth">模块深度</param>
/// <param name="count">返回记录总数</param>
/// <returns>模块对象泛型集合</returns>
public List <Modules> GetSubnavByParentID(string parentID, int moduleDepth, out int count)
{
SqlLoading sl = new SqlLoading();
sl.AddSqlWhere("ModuleDepth", moduleDepth);
sl.AddSqlWhere("IsEnable", 1, JoinSign.And);
sl.AddSqlWhere("parentID", string.Format("'{0}'", parentID), JoinSign.And);
return(dal.GetList(sl, out count));
}
/// <summary>
/// 根据查询条件获取模块泛型数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="count">返回记录总数</param>
/// <returns>模块对象泛型集合</returns>
public List <Modules> GetList(SqlLoading sl, out int count)
{
string strSql = string.Format("SELECT ID,ModuleID,ParentID,ModuleName,EName,ModuleDepth,ModuleURL,Target,Description,CreateTime,IsQuickMenu,IsSystem,IsEnable,OrderID FROM {0}Modules{1} ORDER BY OrderID", tablePrefix, sl.GetSqlWhereString());
using (SqlDataReader dr = dbHelper.ExecuteReader(CommandType.Text, strSql, null))
{
List <Modules> lst = GetList(dr, out count);
return(lst);
}
}
/// <summary>
/// 获取栏目当前位置
/// </summary>
/// <param name="CID">栏目ID，多个ID用,号隔开</param>
public DataTable GetThisPlace(SqlLoading sl)
{
string strSql = string.Format("SELECT CID,ClassName,ClassEName FROM {0}Arc_Class", tablePrefix);
strSql += sl.GetSqlWhereString();
DataSet ds = dbHelper.ExecuteQuery(CommandType.Text, strSql);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
