internal List <S_TreeInfoViewModel> GetListByRoleId(int roleID)
{
List <S_TreeInfoViewModel> resultList = new List <S_TreeInfoViewModel>();
StringBuilder cmdText = new StringBuilder();
if (roleID == -1)
{
cmdText.AppendFormat("SELECT * FROM S_TreeInfo WHERE ISNULL(TreeUrl,'')!='' ORDER BY TreeSort ASC", roleID);
}
else
{
cmdText.AppendFormat("SELECT * FROM S_TreeInfo WHERE TreeID IN ( SELECT TreeID FROM S_TreeRole WHERE RoleID={0} ) ORDER BY TreeSort ASC", roleID);
}
DataSet data = db.Query(cmdText.ToString());
if (data != null && data.Tables[0].Rows.Count > 0)
{
DataRowCollection rows = data.Tables[0].Rows;
foreach (DataRow row in rows)
{
S_TreeInfoViewModel tree = new S_TreeInfoViewModel();
tree.TreeId = Convert.IsDBNull(row["TreeId"]) ? 0 : Convert.ToInt32(row["TreeId"]);
tree.TreeName = Convert.IsDBNull(row["TreeName"]) ? "" : Convert.ToString(row["TreeName"]);
tree.ParentID = Convert.IsDBNull(row["ParentID"]) ? 0 : Convert.ToInt32(row["ParentID"]);
tree.TreeSort = Convert.IsDBNull(row["TreeSort"]) ? 0 : Convert.ToInt32(row["TreeSort"]);
tree.TreeUrl = Convert.IsDBNull(row["TreeUrl"]) ? "" : Convert.ToString(row["TreeUrl"]);
tree.TreeNote = Convert.IsDBNull(row["TreeNote"]) ? "" : Convert.ToString(row["TreeNote"]);
tree.TreeCode = Convert.IsDBNull(row["TreeCode"]) ? "" : Convert.ToString(row["TreeCode"]);
tree.TreePageCode = Convert.IsDBNull(row["TreePageCode"]) ? "" : Convert.ToString(row["TreePageCode"]);
tree.TreeDesc = Convert.IsDBNull(row["TreeDesc"]) ? "" : Convert.ToString(row["TreeDesc"]);
resultList.Add(tree);
}
}
return(resultList);
}
/// <summary>
/// 获取所有菜单
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public List <S_TreeInfoViewModel> GetTreeList()
{
var resultList = new List <S_TreeInfoViewModel>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select t.TreeID,t.TreeName,t.ParentID,t.TreeSort from S_TreeInfo t WHERE ISNULL(T.TreeUrl,'')!='' ORDER BY t.TreeSort");
var ds = db.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var model = new S_TreeInfoViewModel();
var row = ds.Tables[0].Rows[i];
if (row["TreeID"] != null && row["TreeID"].ToString() != "")
{
model.TreeId = int.Parse(row["TreeID"].ToString());
}
if (row["TreeName"] != null)
{
model.TreeName = row["TreeName"].ToString();
}
if (row["ParentID"] != null)
{
model.ParentID = Convert.ToInt32(row["ParentID"]);
}
if (row["TreeSort"] != null && row["TreeSort"].ToString() != "")
{
model.TreeSort = Convert.ToDecimal(row["TreeSort"].ToString());
}
resultList.Add(model);
}
}
else
{
return(null);
}
return(resultList);
}