private void SearchResult() { try { string keyword = txtKeyword.Value; var AllList = (from g in DB.ESHOP_NEWS_COMMENTs where ("" == keyword || (g.COMMENT_NAME).Contains(keyword) || (g.COMMENT_EMAIL).Contains(keyword) || (g.COMMENT_CONTENT).Contains(keyword)) && g.NEWS_ID == m_news_id orderby g.COMMENT_PUBLISHDATE descending select g); var _vNewsComment = DB.GetTable <ESHOP_NEWS_COMMENT>().Where(a => a.NEWS_ID == m_news_id); foreach (var item in _vNewsComment) { item.COMMENT_CHECK = 1; DB.SubmitChanges(); } if (AllList.ToList().Count > 0) { Rplistcomment.DataSource = AllList; } Rplistcomment.DataBind(); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword = txtKeyword.Value; int _limit = 20; int _skip = 0; if (_page != 0) { _skip = _page * _limit - _limit; } var AllList = (from g in DB.ESHOP_NEWS_COMMENTs where ("" == keyword || g.COMMENT_NAME.Contains(keyword)) && g.COMMENT_FIELD3 == null orderby g.COMMENT_ID descending select g); if (AllList.ToList().Count > 0) { Rplistcomment.DataSource = AllList.Skip(_skip).Take(_limit); Rplistcomment.DataBind(); LitPage.Text = pagechange.changePage("page-comment.aspx", AllList.ToList().Count, _limit, _page); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }