public ActionResult ListFromIndex(string keyWord, int pageIndex = 1) { commonInfo.WirteLog("ListFromIndex开始时间"); int categoryId = 0; BookQueryData query = new BookQueryData(); query.CategoryIdOne = (TypeEnum)categoryId; query.KeyWordOneSimp = keyWord; query.KeyWordOneOrig = FontTypeConvert.VBConvertOrig(keyWord); commonInfo.WirteLog("ListFromIndex简繁转换"); int count = 0; List <TB_Book> bookList = _bookService.GetBookListByQueryData(query, out count, pageIndex, pageSize).ToList(); commonInfo.WirteLog("ListFromIndex书籍List"); List <BookViewModel> models = GetQueryList(bookList); commonInfo.WirteLog("ListFromIndex列表分页"); s_keyWord = keyWord; s_categoryId = 0; ArticleListModel articleModel = new ArticleListModel(); articleModel.CategoryId = 0; articleModel.KeyFan = FontTypeConvert.VBConvertOrig(keyWord); articleModel.KeyJian = FontTypeConvert.VBConvertSimp(keyWord); articleModel.KeyWord = keyWord; articleModel.BooViewModelList = models; articleModel.CurrentPageIndex = pageIndex; articleModel.Count = count; articleModel.PageSize = pageSize; articleModel.PageTotalCount = count % pageSize == 0 ? count / pageSize : (int)Math.Ceiling((double)(count / pageSize)) + 1; commonInfo.WirteLog("ListFromIndex列表结束"); return(View("List", articleModel)); }
public ActionResult List(string keyWord = "", int?pageIndex = 1, int?categoryId = 0) { commonInfo.WirteLog("List开始时间"); // var keyWord = Request.Form["title"]; categoryId = categoryId == null ? 0 : categoryId; //书的目录id if (categoryId != 0) { s_categoryId = Convert.ToInt32(categoryId); } if (categoryId == 0 && s_categoryId != 0 && !string.IsNullOrEmpty(keyWord)) { categoryId = s_categoryId; } s_categoryId = Convert.ToInt32(categoryId); pageIndex = (pageIndex == 0 || pageIndex == null) ? 1 : pageIndex; BookQueryData query = new BookQueryData(); query.CategoryIdOne = (TypeEnum)0; query.KeyWordOneSimp = keyWord; query.KeyWordOneOrig = FontTypeConvert.VBConvertOrig(keyWord); commonInfo.WirteLog("List简繁转换"); int count = 0; List <TB_Book> bookList = _bookService.GetBookListByQueryData(query, out count, Convert.ToInt32(pageIndex), pageSize, Convert.ToInt32(categoryId)).ToList(); commonInfo.WirteLog("List书籍List"); List <BookViewModel> models = GetQueryList(bookList); commonInfo.WirteLog("List列表分页"); s_keyWord = keyWord; s_categoryId = 0; ArticleListModel articleModel = new ArticleListModel(); articleModel.CategoryId = Convert.ToInt32(categoryId); articleModel.KeyFan = FontTypeConvert.VBConvertOrig(keyWord); articleModel.KeyJian = FontTypeConvert.VBConvertSimp(keyWord); articleModel.KeyWord = keyWord; articleModel.BooViewModelList = models; articleModel.Count = count; articleModel.PageSize = pageSize; articleModel.PageTotalCount = count % pageSize == 0 ? count / pageSize : (int)Math.Ceiling((double)(count / pageSize)) + 1; articleModel.CurrentPageIndex = pageIndex > articleModel.PageTotalCount ? 1 : Convert.ToInt32(pageIndex); return(View("List", articleModel)); }
public ActionResult MuchListTable(int pageIndex = 1) { commonInfo.WirteLog("MuchListTable开始"); #region 查询条件 ///0:全部 1:书名 2:责任者 3:出版者 4:朝代 5:其他名称 int categoryId = Convert.ToInt32(Request["categoryId1"]); string title = Request["title1"]; int categoryId2 = Convert.ToInt32(Request["categoryId2"]); string title2 = Request["title2"]; int searchType = Convert.ToInt32(Request["searchType"]); //1:与 2:或 #endregion commonInfo.WirteLog("MuchListTable查询条件结束"); BookQueryData query = new BookQueryData(); query.CategoryIdOne = (TypeEnum)categoryId; query.KeyWordOneSimp = FontTypeConvert.VBConvertSimp(title); query.KeyWordOneOrig = FontTypeConvert.VBConvertOrig(title); query.CategoryIdTwo = (TypeEnum)categoryId2; query.KeyWordTwoSimp = FontTypeConvert.VBConvertSimp(title2); query.KeyWordTwoOrig = FontTypeConvert.VBConvertOrig(title2); query.SearchType = searchType; int count = 0; commonInfo.WirteLog("MuchListTable简繁转换"); List <TB_Book> bookList = _bookService.GetBookListByQueryData(query, out count, Convert.ToInt32(pageIndex), pageSize).ToList(); commonInfo.WirteLog("MuchListTable书籍List"); List <BookViewModel> models = GetQueryList(bookList); MuchListTableModel listModel = new MuchListTableModel(); listModel.BooViewModelList = models; listModel.Count = count; listModel.CurrentPageIndex = pageIndex; listModel.KeyFan = FontTypeConvert.VBConvertOrig(title); listModel.KeyFan2 = FontTypeConvert.VBConvertOrig(title2); listModel.KeyJian = FontTypeConvert.VBConvertSimp(title); listModel.KeyJian2 = FontTypeConvert.VBConvertSimp(title2); listModel.KeyWord = title; listModel.KeyWord2 = title2; listModel.PageSize = pageSize; listModel.PageTotalCount = count % pageSize == 0 ? count / pageSize : (int)Math.Ceiling((double)(count / pageSize)) + 1; listModel.Query = categoryId + "," + title + "," + categoryId2 + "," + title2; listModel.SearchType = searchType; commonInfo.WirteLog("MuchListTable分页数据"); return(View(listModel)); }
public ActionResult MuchListTablePage(string keyWord1, string keyWord2, int categoryId1 = 0, int categoryId2 = 0, int searchType = 1, int pageIndex = 1) { BookQueryData query = new BookQueryData(); query.CategoryIdOne = (TypeEnum)categoryId1; query.KeyWordOneSimp = FontTypeConvert.VBConvertSimp(keyWord1); query.KeyWordOneOrig = FontTypeConvert.VBConvertOrig(keyWord1); query.CategoryIdTwo = (TypeEnum)categoryId2; query.KeyWordTwoSimp = FontTypeConvert.VBConvertSimp(keyWord2); query.KeyWordTwoOrig = FontTypeConvert.VBConvertOrig(keyWord2); query.SearchType = searchType; int count = 0; //IQueryable<TB_Book> bookList = _bookService.GetBookListByQueryData(query, out count, pageIndex, pageSize); List <TB_Book> bookList = _bookService.GetBookListByQueryData(query, out count, pageIndex, pageSize).ToList(); commonInfo.WirteLog("MuchListTablePage书籍List"); List <BookViewModel> models = GetQueryList(bookList); commonInfo.WirteLog("MuchListTablePage循环赋值"); MuchListTableModel listModel = new MuchListTableModel(); listModel.BooViewModelList = models; listModel.Count = count; listModel.CurrentPageIndex = pageIndex; listModel.KeyFan = FontTypeConvert.VBConvertOrig(keyWord1); listModel.KeyFan2 = FontTypeConvert.VBConvertOrig(keyWord2); listModel.KeyJian = FontTypeConvert.VBConvertSimp(keyWord1); listModel.KeyJian2 = FontTypeConvert.VBConvertSimp(keyWord2); listModel.KeyWord = keyWord1; listModel.KeyWord2 = keyWord2; listModel.PageSize = pageSize; listModel.PageTotalCount = count % pageSize == 0 ? count / pageSize : (int)Math.Ceiling((double)(count / pageSize)) + 1; listModel.Query = categoryId1 + "," + keyWord1 + "," + categoryId2 + "," + keyWord2; listModel.SearchType = searchType; commonInfo.WirteLog("MuchListTablePage返回页面"); return(View("MuchListTable", listModel)); }
public IQueryable <TB_Book> GetBookListByQueryData(BookQueryData queryData, out int count, int pageIndex = 0, int pageSize = 0, int categoryId = 0) { Common.LogFile.WriteLogNewInfo("Service查之前"); var bookList = _bookRep.Table.Where(p => p.IsDelete == 1); Common.LogFile.WriteLogNewInfo("Service查之后"); if (categoryId != 0 && categoryId != -1) { bookList = bookList.Where(p => p.CategoryId == categoryId); } Common.LogFile.WriteLogNewInfo("Service查目录"); if (!string.IsNullOrEmpty(queryData.KeyWordOneSimp) || !string.IsNullOrEmpty(queryData.KeyWordTwoSimp)) { bookList = GetBookByType(bookList, queryData.CategoryIdOne, queryData.KeyWordOneSimp, queryData.KeyWordOneOrig); } Common.LogFile.WriteLogNewInfo("Service查简繁1"); if (!string.IsNullOrEmpty(queryData.KeyWordTwoSimp)) { #region 与 if (queryData.SearchType == 1) { bookList = GetBookByType(bookList, queryData.CategoryIdTwo, queryData.KeyWordTwoSimp, queryData.KeyWordTwoOrig); count = bookList.Count(); bookList = bookList.OrderByDescending(p => p.CreateTime); if (pageIndex != 0 && pageSize != 0) { bookList = bookList.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize); } return(bookList); } #endregion #region 或 else if (queryData.SearchType == 2) { Common.LogFile.WriteLogAddInfo("Service的或开始"); var bookList2 = _bookRep.Table.Where(p => p.IsDelete == 1); bookList2 = GetBookByTypeOr(bookList2, queryData); Common.LogFile.WriteLogAddInfo("Service的得到"); //var newBookList = bookList.Union(bookList2); //bookList2.Distinct(new TB_BookCompareByBookUid()); count = bookList2.Count(); Common.LogFile.WriteLogAddInfo("Service获取去重数据"); bookList2 = bookList2.OrderByDescending(p => p.CreateTime); if (pageIndex != 0 && pageSize != 0) { bookList2 = bookList2.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize); } Common.LogFile.WriteLogAddInfo("Service返回"); return(bookList2); } count = bookList.Count(); bookList = bookList.OrderByDescending(p => p.CreateTime); if (pageIndex != 0 && pageSize != 0) { bookList = bookList.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize); } return(bookList); #endregion } count = bookList.Count(); bookList = bookList.OrderByDescending(p => p.CreateTime); if (pageIndex != 0 && pageSize != 0) { bookList = bookList.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize); } return(bookList); }
public IQueryable <TB_Book> GetBookByTypeOr(IQueryable <TB_Book> bookList, BookQueryData data) { string dataTwoSimp = data.KeyWordTwoSimp; string dataTwoOrig = data.KeyWordTwoOrig; string dataOneSimp = data.KeyWordOneSimp; string dataOneOrig = data.KeyWordOneOrig; switch (data.CategoryIdOne) { case TypeEnum.All: if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig)); } break; case TypeEnum.BookName: #region 查询 if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title.Contains(dataOneOrig) || tt.Title.Contains(dataOneSimp) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneOrig) || tt.Title.Contains(dataOneSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp)); } #endregion break; case TypeEnum.Auther: #region 查询 if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataOneOrig) || tt.Title.Contains(dataOneSimp) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Functionary.Contains(dataOneOrig) || tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Functionary.Contains(dataOneSimp) || tt.Functionary.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp)); } #endregion break; case TypeEnum.Publisher: bookList = bookList.Where(p => p.Publisher.Contains(dataOneOrig) || p.Publisher.Contains(dataOneSimp)); #region 查询 if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Publisher.Contains(dataOneSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Publisher.Contains(dataOneOrig) || tt.Publisher.Contains(dataOneSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Publisher.Contains(dataOneSimp) || tt.Publisher.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp)); } #endregion break; case TypeEnum.Dynasty: //bookList = bookList.Where(p => p.Dynasty.Contains(dataOneOrig) || p.Dynasty.Contains(dataOneSimp)); #region 查询 if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Dynasty.Contains(dataOneOrig) || tt.Dynasty.Contains(dataOneSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Dynasty.Contains(dataOneSimp) || tt.Dynasty.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp)); } #endregion break; case TypeEnum.OtherName: //bookList = bookList.Where(p => p.Title2.Contains(dataOneOrig) || p.Title2.Contains(dataOneSimp)); #region 查询 if (data.CategoryIdTwo == TypeEnum.All) { bookList = bookList.Where(tt => tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp)); } else if (data.CategoryIdTwo == TypeEnum.BookName) { bookList = bookList.Where(tt => tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title.Contains(dataTwoOrig) || tt.Title.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Auther) { bookList = bookList.Where(tt => tt.Title2.Contains(dataOneOrig) || tt.Title2.Contains(dataOneSimp) || tt.Functionary.Contains(dataTwoOrig) || tt.Functionary.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Publisher) { bookList = bookList.Where(tt => tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Publisher.Contains(dataTwoOrig) || tt.Publisher.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.Dynasty) { bookList = bookList.Where(tt => tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Dynasty.Contains(dataTwoOrig) || tt.Dynasty.Contains(dataTwoSimp)); } else if (data.CategoryIdTwo == TypeEnum.OtherName) { bookList = bookList.Where(tt => tt.Title2.Contains(dataOneSimp) || tt.Title2.Contains(dataOneOrig) || tt.Title2.Contains(dataTwoOrig) || tt.Title2.Contains(dataTwoSimp)); } #endregion break; default: break; } return(bookList); }