private void getList() { this.ManageTexts = new List <ManageText>(); var trans = db.TextLists.ToList(); foreach (var item in trans) { ManageText temp = new ManageText { TextID = item.TextID, TextTitle = item.TextTitle, CategoryName = item.CategoryName, Date = item.TextChangeDate.ToString(), Hot = item.Hot }; ManageTexts.Add(temp); } }
public ManageTextsList GetManageTexts(GridPager gp, string TextTitle) //获取文章列表数据 { List <ManageText> manageTexts = new List <ManageText>(); //var totalpage = repository.GetTextsAll().Count(); var trans = new List <BlogText>(); if (!string.IsNullOrEmpty(TextTitle)) { trans = repository.searchblogByTitle(TextTitle); switch (gp.sort) //使用switch,考虑到可扩展成其他类型的排序 { case "Hot": if (gp.order == "desc") //在一个case中判断是正序还是倒序 { trans = repository.searchblogByTitle(TextTitle).OrderByDescending(m => m.Hot).ToList(); } else { trans = repository.searchblogByTitle(TextTitle).OrderBy(m => m.Hot).ToList(); } break; default: //默认情况,当sort为空 trans = repository.searchblogByTitle(TextTitle); break; } } else { switch (gp.sort) //使用switch,考虑到可扩展成其他类型的排序 { case "Hot": if (gp.order == "desc") //在一个case中判断是正序还是倒序 { trans = repository.GetTextsAll().OrderByDescending(m => m.Hot).ToList(); } else { trans = repository.GetTextsAll().OrderBy(m => m.Hot).ToList(); } break; default: //默认情况,当sort为空 trans = repository.GetTextsAll(); break; } } //var trans = repository.GetTextsAll(); for (int i = (gp.page - 1) * gp.rows; i < gp.page * gp.rows; i++) //foreach (var item in trans) { if (i >= trans.Count()) { break; } if (trans[i].CategoryName == string.Empty) { trans[i].CategoryName = "未分类"; } ManageText temp = new ManageText { TextID = trans[i].TextID, TextTitle = trans[i].TextTitle, CategoryName = trans[i].CategoryName, TextChangeDate = trans[i].TextChangeDate.ToString(), Hot = trans[i].Hot }; manageTexts.Add(temp); } ManageTextsList tempList = new ManageTextsList { TextNumber = trans.Count(), TempTextsLists = manageTexts }; return(tempList); }