/// <summary>
/// 取得菜单数据
/// </summary>
/// <param name="where"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
public List<PlatformMenu> GetPlatformMenusList(string where, string orderBy)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from [dbo].[PlatformManager_Role]");
if (!string.IsNullOrEmpty(where))
sql.Append(" where " + where);
if (!string.IsNullOrEmpty(orderBy))
sql.Append(" order by " + orderBy);
List<PlatformMenu> list = new List<PlatformMenu>();
using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString()))
{
while (reader.Read())
{
PlatformMenu model = new PlatformMenu();
ConvertToModel(reader, model);
list.Add(model);
}
}
return list;
}
private void ConvertToModel(IDataReader reader, PlatformMenu model)
{
if (reader["Id"] != DBNull.Value)
model.Id = Convert.ToInt32(reader["Id"]);
if (reader["ParentId"] != DBNull.Value)
model.ParentId = Convert.ToInt32(reader["ParentId"]);
if (reader["MenuText"] != DBNull.Value)
model.MenuText = reader["MenuText"].ToString();
if (reader["IsFolder"] != DBNull.Value)
model.IsFolder = Convert.ToBoolean(reader["IsFolder"]);
if (reader["PagePath"] != DBNull.Value)
model.PagePath = reader["PagePath"].ToString();
if (reader["MenuPath"] != DBNull.Value)
model.MenuPath = reader["MenuPath"].ToString();
}