示例#1
0
        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));
        }
示例#2
0
        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));
        }
示例#3
0
 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));
 }
示例#4
0
        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));
        }
示例#5
0
        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);
        }
示例#6
0
        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);
        }