public static List <Business.MainTag> Load(int?parentId, int?level)
{
string key = "MainTags";
if (parentId.HasValue)
{
key += "p" + parentId.Value.ToString();
}
if (level.HasValue)
{
key += "l" + level.Value.ToString();
}
QuickCacheHandler cacheHandler = new QuickCacheHandler(key);
cacheHandler.AlternateCacheMinutes = 60;
cacheHandler.ItemPriority = System.Web.Caching.CacheItemPriority.BelowNormal;
List <Business.MainTag> list = cacheHandler.Get() as List <Business.MainTag>;
if (list != null)
{
return(list);
}
list = new List <Business.MainTag>();
SqlDataReader sqlReader = null;
try
{
sqlReader = GetReader(parentId, level);
if (sqlReader != null)
{
while (sqlReader.Read())
{
Business.MainTag item = new Business.MainTag();
FillObject(item, sqlReader);
list.Add(item);
}
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
cacheHandler.Insert(list);
return(list);
}
private static void FillObject(Business.MainTag item, SqlDataReader sqlReader)
{
item.Id = Convert.ToInt32(sqlReader["MAN_ID"]);
if (sqlReader["MAN_MAN_ID"] != DBNull.Value)
{
item.ParentId = Convert.ToInt32(sqlReader["MAN_MAN_ID"]);
}
item.Level = Convert.ToInt32(sqlReader["MAN_Level"]);
item.Order = Convert.ToInt32(sqlReader["MAN_Order"]);
item.Title = sqlReader["MAN_Title"].ToString();
item.TagWordId = sqlReader["TGW_ID"].ToString().ToGuid();
}
