private void SearchResult()
{
try
{
int _limit = 20;
int _skip = 0;
string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value);
int _catid = Utils.CIntDef(ddlCategory.SelectedValue);
if (_catid != 0 || !String.IsNullOrEmpty(keyword))
{
_limit = 200;
}
if (_page != 0)
{
_skip = _page * _limit - _limit;
}
var AllList = (from g in DB.ESHOP_NEWs
join a in DB.ESHOP_NEWS_CATs on g.NEWS_ID equals a.NEWS_ID into t2_join
from d in t2_join.DefaultIfEmpty()
where ("" == keyword || SqlMethods.Like(g.NEWS_KEYWORD_ASCII, "%" + keyword + "%") || g.NEWS_CODE.Contains(keyword)) &&
(_gtype != 1 ? (getCatid().Contains(d.ESHOP_CATEGORy.CAT_ID.ToString()) || getCatid().Contains(d.ESHOP_CATEGORy.CAT_PARENT_ID.ToString())) : true) &&
(_type == 1 ? g.NEWS_TYPE == 1 : g.NEWS_TYPE != 1) &&
((d.ESHOP_CATEGORy.CAT_ID == _catid || d.ESHOP_CATEGORy.CAT_PARENT_PATH.Contains(_catid.ToString())) || 0 == _catid)
orderby g.NEWS_ID descending
select g).GroupBy(n => n.NEWS_ID).Select(n => new
{
NEWS_ID = n.First().NEWS_ID,
NEWS_TITLE = n.First().NEWS_TITLE,
NEWS_TYPE = n.First().NEWS_TYPE,
NEWS_SHOWTYPE = n.First().NEWS_SHOWTYPE,
NEWS_ORDER = n.First().NEWS_ORDER,
NEWS_PUBLISHDATE = n.First().NEWS_PUBLISHDATE,
}).OrderByDescending(n => n.NEWS_ID).ToList();
RpItemList.DataSource = AllList.Skip(_skip).Take(_limit);
RpItemList.DataBind();
LitPage.Text = pagechange.changePageNews("news_list.aspx", AllList.Count, _limit, _page, _type);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
private void SearchResult()
{
try
{
int _limit = 20;
int _skip = 0;
string keyword = CpanelUtils.ClearUnicode(txtKeyword.Value);
int _catid = Utils.CIntDef(ddlCategory.SelectedValue);
if (_catid != 0 || !String.IsNullOrEmpty(keyword))
{
_limit = 200;
}
if (_page != 0)
{
_skip = _page * _limit - _limit;
}
var AllList = (from g in DB.ESHOP_NEWs
join a in DB.ESHOP_NEWS_CATs on g.NEWS_ID equals a.NEWS_ID
join d in DB.ESHOP_CATEGORies on a.CAT_ID equals d.CAT_ID
where ("" == keyword || (DB.fClearUnicode(g.NEWS_TITLE)).Contains(keyword) || g.NEWS_CODE.Contains(keyword)) &&
(g.NEWS_TYPE == 1) && g.UNIT_ID2 > 0 &&
((d.CAT_ID == _catid || d.CAT_PARENT_PATH.Contains(_catid.ToString())) || 0 == _catid)
orderby g.UNIT_ID2 descending
select g).GroupBy(n => n.NEWS_ID).Select(n => new
{
UNIT_ID2 = n.First().UNIT_ID2,
NEWS_ID = n.First().NEWS_ID,
NEWS_TITLE = n.First().NEWS_TITLE,
NEWS_TYPE = n.First().NEWS_TYPE,
NEWS_SHOWTYPE = n.First().NEWS_SHOWTYPE,
NEWS_ORDER = n.First().NEWS_ORDER,
NEWS_PUBLISHDATE = n.First().NEWS_PUBLISHDATE,
}).OrderByDescending(n => n.NEWS_ID).ToList();
RpItemList.DataSource = AllList.Skip(_skip).Take(_limit);
RpItemList.DataBind();
LitPage.Text = pagechange.changePageNews(AllList.Count, _limit, "xulylinkdie.aspx", _page, _type, 10);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}