//public List<Pro_details_entity> Load_search_result(string _txt,int type,int _idcat)
//{
// List<Pro_details_entity> l = new List<Pro_details_entity>();
// var list = (from c in db.ESHOP_NEWS_CATs
// join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
// join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
// where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode(_txt)) || "" == _txt || "%%" == _txt || a.NEWS_CODE.Contains(_txt.Replace("%",string.Empty)))
// && a.NEWS_TYPE == type &&(_idcat!=0 ? (b.CAT_ID==_idcat||b.CAT_PARENT_PATH.Contains(_idcat.ToString())) : _idcat==0 )
// select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3,a.NEWS_PRICE1,a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE,a.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER);
// foreach (var i in list)
// {
// Pro_details_entity pro = new Pro_details_entity();
// pro.NEWS_ID = i.NEWS_ID;
// pro.NEWS_TITLE = i.NEWS_TITLE;
// pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
// pro.NEWS_DESC = i.NEWS_DESC;
// pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
// pro.NEWS_URL = i.NEWS_URL;
// pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
// pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
// pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
// pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
// pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
// pro.NEWS_FIELD3 = i.NEWS_FIELD3;
// pro.CAT_SEO_URL = "";
// l.Add(pro);
// }
// return l;
//}
public List <Pro_details_entity> Load_search_result(string _txt, int type, int _idcat)
{
List <Pro_details_entity> l = new List <Pro_details_entity>();
string[] arr = _txt.Split(' ');
for (int s = 0; s < arr.Length; s++)
{
if (s == 0)
{
var list = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
//where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode("%" + arr[s] + "%")))
where (SqlMethods.Like(db.fClearUnicode(a.NEWS_TITLE), ClearUnicode("%" + arr[s] + "%"))) &&
a.NEWS_TYPE == type && (_idcat != 0 ? (b.CAT_ID == _idcat || b.CAT_PARENT_PATH.Contains(_idcat.ToString())) : _idcat == 0)
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_PRICE2, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, a.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER);
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
pro.CAT_SEO_URL = "";
l.Add(pro);
}
}
else
{
var list = l.Where(n => n.NEWS_TITLE.ToLower().Contains(arr[s].ToLower())).ToList();
if (list != null && list.Count > 0)
{
l = list;
}
}
}
return(l);
}
public List <CategoryEntityComplete> searchComplete(string searchitem)
{
List <CategoryEntityComplete> l = new List <CategoryEntityComplete>();
var list = (from a in db.ESHOP_NEWs
join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID
where (db.fClearUnicode(a.NEWS_TITLE).Contains(ClearUnicode(searchitem))) &&
a.NEWS_TYPE == 1
select new
{
a.NEWS_TITLE,
a.NEWS_PUBLISHDATE,
b.ESHOP_CATEGORy.CAT_NAME
}).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.CAT_NAME).Take(10);
foreach (var i in list)
{
CategoryEntityComplete enti = new CategoryEntityComplete();
enti.catname = i.CAT_NAME;
enti.title = i.NEWS_TITLE;
l.Add(enti);
}
return(l);
}
