/// <summary>
/// 自定义菜单
/// </summary>
public DataSet GetTypeTree(string TableName, string SqlWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,TCode,TName,TSmallPic,TLevel,ParentId,TOrder from Sys_Type ");
strSql.Append(" where 1=1 " + SqlWhere + "");
HoneyWell.Model.Sys_Type model = new HoneyWell.Model.Sys_Type();
DataSet ds = SqlHelper.Query(strSql.ToString(), SysConn.PublicConn);
if (ds != null)
{
return(ds);
}
else
{
return(null);
}
}
///// <summary>
///// 菜单分组
///// </summary>
//public DataSet GroupTypeTree(string TableName, string SqlWhere)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select ID,TName from Sys_Type ");
// strSql.Append(" where 1=1 " + SqlWhere + "");
// HoneyWell.Model.Sys_Type model = new HoneyWell.Model.Sys_Type();
// DataSet ds = SqlHelper.Query(strSql.ToString(), SysConn.PublicConn);
// if (ds != null)
// {
// return ds;
// }
// else
// {
// return null;
// }
//}
/// <summary>
/// 自定义菜单
/// </summary>
public DataSet GetTypeTree(string TableName, string SqlWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,AreaCode,AreaName,ParentAreaCode,AreaLevel,AreaOrder,KeyWord from Sys_Area");
strSql.Append(" where 1=1 " + SqlWhere + "");
HoneyWell.Model.Sys_Type model = new HoneyWell.Model.Sys_Type();
DataSet ds = SqlHelper.Query(strSql.ToString(), SysConn.PublicConn);
if (ds != null)
{
return(ds);
}
else
{
return(null);
}
}
