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);
}
}
