public List<Pro_details_entity> Load_listpro(int _Catid) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString())) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); 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_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now); pro.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; } catch (Exception) { throw; } }
public List<Pro_details_entity> load_ordenowHighlight(int limit) { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_ORDERs join b in db.ESHOP_ORDER_ITEMs on a.ORDER_ID equals b.ORDER_ID join c in db.ESHOP_NEWs on b.NEWS_ID equals c.NEWS_ID select new { a.ORDER_ID, c.NEWS_ID, c.NEWS_TITLE, c.NEWS_SEO_URL, c.NEWS_URL, c.NEWS_IMAGE3, c.NEWS_PRICE1, c.NEWS_PRICE2, c.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.ORDER_ID).Take(limit).ToList(); foreach (var i in list) { Pro_details_entity pro = new Pro_details_entity(); pro.NEWS_ID = i.NEWS_ID; pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2); pro.NEWS_IMAGE3 = i.NEWS_IMAGE3; pro.NEWS_FIELD3 = i.NEWS_FIELD3; pro.NEWS_SEO_URL = i.NEWS_SEO_URL; pro.NEWS_URL = i.NEWS_URL; pro.NEWS_TITLE = i.NEWS_TITLE; 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 test = ClearUnicode(_txt); 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.ToString(), ClearUnicode(_txt)) || SqlMethods.Like(a.NEWS_TITLE.ToString(), _txt)) && b.CAT_TYPE == type &&(b.CAT_ID==_idcat||b.CAT_PARENT_PATH.Contains(_idcat.ToString())) select new {a.NEWS_VIDEO_URL, a.NEWS_FIELD1, a.NEWS_FIELD2, a.NEWS_FIELD4, a.NEWS_FIELD5, 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_VIDEO_URL = i.NEWS_VIDEO_URL; 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_FIELD1 = i.NEWS_FIELD1; pro.NEWS_FIELD2 = i.NEWS_FIELD2; pro.NEWS_FIELD4 = i.NEWS_FIELD4; pro.NEWS_FIELD5 = i.NEWS_FIELD5; l.Add(pro); } return l; }
public List<Pro_details_entity> Load_search_resultM(string _txt, int type, int skip, int limit) { 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_TYPE == type 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, b.CAT_SEO_URL }).Distinct().OrderByDescending(n => n.NEWS_ID).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit); 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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; }
//Pro or news hien thi trang chu public List<Pro_details_entity> Loadindex(int type, int period, int limit) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_PERIOD == period && b.NEWS_TYPE == type select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3,b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER_PERIOD).Take(limit).ToList(); 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_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD); pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now); pro.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; } catch (Exception) { throw; } }
public List<Pro_details_entity> Load_Product_Cungloai(string _News_seo_url) { try { var s = (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 a.NEWS_SEO_URL == _News_seo_url select new { b.CAT_ID }).ToList(); List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (b.NEWS_SEO_URL != _News_seo_url) && (c.CAT_ID == s[0].CAT_ID || c.CAT_PARENT_PATH.Contains(s[0].CAT_ID.ToString())) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_PRICE3, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_SENDDATE, b.NEWS_CODE, c.CAT_SEO_URL, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4 }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); 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_PRICE3 = Utils.CDecDef(i.NEWS_PRICE3); pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now); //pro.NEWS_SENDDATE = Utils.CDateDef(i.NEWS_SENDDATE, DateTime.Now); pro.NEWS_CODE = i.NEWS_CODE; pro.CAT_SEO_URL = i.CAT_SEO_URL; //pro.NEWS_FIELD1 = i.NEWS_FIELD1; pro.NEWS_FIELD2 = i.NEWS_FIELD2; //pro.NEWS_FIELD3 = i.NEWS_FIELD3; //pro.NEWS_FIELD4 = i.NEWS_FIELD4; l.Add(pro); } return l; } catch (Exception) { throw; } }
public List<Pro_details_entity> Load_Product_Detail(string _News_seo_url) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (b.NEWS_SEO_URL==_News_seo_url) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_IMAGE2, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4, b.NEWS_COUNT, b.UNIT_ID1, b.UNIT_ID2, b.UNIT_ID3, c.CAT_SEO_URL, b.SHOP_ID }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); 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_IMAGE2 = i.NEWS_IMAGE2; 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_CODE = i.NEWS_CODE; pro.CAT_SEO_URL = i.CAT_SEO_URL; pro.NEWS_FIELD2 = i.NEWS_FIELD2; pro.NEWS_FIELD3 = i.NEWS_FIELD3; pro.NEWS_FIELD4 = i.NEWS_FIELD4; pro.NEWS_COUNT =Utils.CIntDef(i.NEWS_COUNT); pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1); pro.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2); pro.UNIT_ID3 = Utils.CIntDef(i.UNIT_ID3); pro.SHOP_ID = Utils.CIntDef(i.SHOP_ID); l.Add(pro); } return l; } catch (Exception) { throw; } }
public List<Pro_details_entity> loadProductByAll(int _catid, string _idbrand, int _pricetype, string _price, int _sortype) { List<decimal> lprice = new List<decimal>(); decimal pri1 = 0; decimal pri2 = 0; if (!String.IsNullOrEmpty(_price)) { string[] a = _price.Split(','); if (a.Length == 2) { pri1 = Utils.CDecDef(a[0]); pri2 = Utils.CDecDef(a[1]); } else pri1 = Utils.CDecDef(a[0]); } string[] _strbrand = _idbrand.Split(','); List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == _catid || c.CAT_PARENT_PATH.Contains(_catid.ToString())) && (_strbrand.Contains(b.UNIT_ID1.ToString()) || _idbrand == "") && (_pricetype == 3 ? b.NEWS_PRICE1 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE1 >= pri1 && b.NEWS_PRICE1 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE1 > pri1 : 0 == _pricetype))) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct(); 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.CAT_SEO_URL = i.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] + "%"))) && 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<Pro_details_entity> loadSosanh(string _newseo,int limit) { int _catid = 0; var getcatid = (from a in db.ESHOP_NEWs join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID where a.NEWS_SEO_URL==_newseo select new{b.CAT_ID}).ToList(); if (getcatid.Count > 0) _catid =Utils.CIntDef(getcatid[0].CAT_ID); if (_catid != 0) { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_SEO_URL != _newseo && c.CAT_ID==_catid select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, b.NEWS_FIELD4, b.NEWS_COUNT, b.UNIT_ID1, b.UNIT_ID2, b.UNIT_ID3, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Take(limit).ToList(); 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_CODE = i.NEWS_CODE; pro.CAT_SEO_URL = i.CAT_SEO_URL; pro.NEWS_FIELD2 = i.NEWS_FIELD2; pro.NEWS_FIELD3 = i.NEWS_FIELD3; pro.NEWS_FIELD4 = i.NEWS_FIELD4; pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT); pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1); pro.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2); pro.UNIT_ID3 = Utils.CIntDef(i.UNIT_ID3); l.Add(pro); } return l; } return new List<Pro_details_entity>(); }
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid, int per, int skip, int limit) { try { int id = Utils.CIntDef(catid); List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == id || c.CAT_PARENT_PATH.Contains(id.ToString())) & b.NEWS_FIELD1 == per.ToString() select new { b.NEWS_COUNT, b.NEWS_VIDEO_URL, b.NEWS_FIELD3, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_PRICE2, b.NEWS_PRICE1, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_PUBLISHDATE }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit).ToList(); foreach (var i in list) { Pro_details_entity pro = new Pro_details_entity(); pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL; pro.NEWS_ID = i.NEWS_ID; pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT); 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_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_FIELD1 = i.NEWS_FIELD1; pro.NEWS_FIELD2 = i.NEWS_FIELD2; pro.NEWS_FIELD3 = i.NEWS_FIELD3; l.Add(pro); } return l.AsQueryable(); } catch (Exception) { throw; } }
public List<Pro_details_entity> Load_listpro(int _Catid, int _idhangsx, int _pricetype, string _price, int _sortype) { try { List<decimal> lprice = new List<decimal>(); decimal pri1 = 0; decimal pri2 = 0; if (!String.IsNullOrEmpty(_price)) { string[] a = _price.Split(','); if (a.Length == 2) { pri1 = Utils.CDecDef(a[0]); pri2 = Utils.CDecDef(a[1]); } else pri1 = Utils.CDecDef(a[0]); } List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString())) select new {b.NEWS_VIDEO_URL, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_FIELD4, b.NEWS_FIELD5, b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct(); switch (_sortype) { case 1: list = list.OrderBy(n => n.NEWS_TITLE); break; case 2: list = list.OrderByDescending(n => n.NEWS_TITLE); break; case 3: list = list.OrderByDescending(n => n.NEWS_PRICE1); break; case 4: list = list.OrderBy(n => n.NEWS_PRICE1); break; case 5: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderByDescending(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break; case 6: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderBy(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break; default: list = list.OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER); break; } foreach (var i in list) { Pro_details_entity pro = new Pro_details_entity(); pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL; 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.NEWS_FIELD1 = i.NEWS_FIELD1; pro.NEWS_FIELD2 = i.NEWS_FIELD2; pro.NEWS_FIELD4 = i.NEWS_FIELD4; pro.NEWS_FIELD5 = i.NEWS_FIELD5; l.Add(pro); } return l; } catch (Exception) { throw; } }
//Load random public List<Pro_details_entity> loadPro_Random(string _new_seo,int limit) { List<int> lpos = new List<int>(); List<Pro_details_entity> l = new List<Pro_details_entity>(); Random rdom = new Random(); var getallList = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_SEO_URL!=_new_seo && b.NEWS_TYPE==1 select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_FIELD2, b.NEWS_FIELD3, c.CAT_SEO_URL }) .Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); if (getallList.Count > 0) { for (int i = 0; i < limit; i++) { int pos = rdom.Next(1, getallList.Count - 1); if (!lpos.Contains(pos)) { lpos.Add(pos); Pro_details_entity pro = new Pro_details_entity(); pro.NEWS_ID = getallList[pos].NEWS_ID; pro.NEWS_TITLE = getallList[pos].NEWS_TITLE; pro.NEWS_IMAGE3 = getallList[pos].NEWS_IMAGE3; pro.NEWS_DESC = getallList[pos].NEWS_DESC; pro.NEWS_SEO_URL = getallList[pos].NEWS_SEO_URL; pro.NEWS_URL = getallList[pos].NEWS_URL; pro.CAT_SEO_URL = getallList[pos].CAT_SEO_URL; pro.NEWS_ORDER = Utils.CIntDef(getallList[pos].NEWS_ORDER); pro.NEWS_ORDER_PERIOD = Utils.CIntDef(getallList[pos].NEWS_ORDER_PERIOD); pro.NEWS_PUBLISHDATE = Utils.CDateDef(getallList[pos].NEWS_PUBLISHDATE, DateTime.Now); pro.NEWS_PRICE1 = Utils.CDecDef(getallList[pos].NEWS_PRICE1); pro.NEWS_PRICE2 = Utils.CDecDef(getallList[pos].NEWS_PRICE2); l.Add(pro); } } } return l; }
public List<Pro_details_entity> loadProductByBrandId(int _idbrand) { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.UNIT_ID1 == _idbrand select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct(); 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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; }
public List<Pro_details_entity> Load_search_resultMore(string _txt, int type, int _idcat,int _skip,int _limit) { if (_txt.Contains("Từ khóa tìm kiếm")) _txt = ""; _txt = "%" + _txt + "%"; 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_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).Skip(_skip).Take(_limit); 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> LoadProductsHome(int _catid, int pos) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); if (pos == 3) { var list = ((from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == _catid || c.CAT_PARENT_PATH.Contains(_catid.ToString())) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).Distinct()); 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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } } return l.ToList(); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); return null; } }
public List<Pro_details_entity> Load_search_resultBrand(string _txt, int cat, int type, int _Brand, int _pricetype, string _price) { List<decimal> lprice = new List<decimal>(); decimal pri1 = 0; decimal pri2 = 0; if (!String.IsNullOrEmpty(_price)) { string[] a = _price.Split(','); if (a.Length == 2) { pri1 = Utils.CDecDef(a[0]); pri2 = Utils.CDecDef(a[1]); } else pri1 = Utils.CDecDef(a[0]); } 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) && (b.CAT_ID == cat || b.CAT_PARENT_PATH.Contains(cat.ToString()) || cat == 0) && a.NEWS_TYPE == type && (a.UNIT_ID3 == _Brand || 0 == _Brand) && (_pricetype == 3 ? a.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? a.NEWS_PRICE2 >= pri1 && a.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? a.NEWS_PRICE2 > pri1 : 0 == _pricetype))) 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, b.CAT_SEO_URL }).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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; }
//Load similar public List<Pro_details_entity> Load_Similar_Product(string News_Seo_Url) { try { List<Pro_details_entity> l=new List<Pro_details_entity>(); var _vCatID = from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_SEO_URL == News_Seo_Url select new { c.CAT_ID, c.CAT_PARENT_ID, b.NEWS_TYPE }; if (_vCatID.ToList().Count > 0) { var _vProduct = (from c in db.ESHOP_NEWS_CATs join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID where a.NEWS_TYPE == _vCatID.ToList()[0].NEWS_TYPE && (c.CAT_ID == _vCatID.ToList()[0].CAT_ID || c.CAT_ID == _vCatID.ToList()[0].CAT_PARENT_ID) && a.NEWS_SHOWINDETAIL == 1 && a.NEWS_SEO_URL != News_Seo_Url select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE,a.NEWS_PRICE1, c.ESHOP_CATEGORy.CAT_SEO_URL }); foreach (var i in _vProduct) { 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_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now); pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); pro.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } } return l; } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); return null; } }
public List<Pro_details_entity> getProinfo(int id) { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWs join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID where a.NEWS_ID == id select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_PRICE1, a.UNIT_ID1, a.UNIT_ID2, a.NEWS_FIELD2, a.NEWS_IMAGE3, b.ESHOP_CATEGORy.CAT_SEO_URL }).ToList(); foreach (var i in list) { Pro_details_entity enti = new Pro_details_entity(); enti.NEWS_ID = i.NEWS_ID; enti.NEWS_TITLE = i.NEWS_TITLE; enti.NEWS_DESC = i.NEWS_DESC; enti.NEWS_PRICE1 =Utils.CDecDef(i.NEWS_PRICE1); enti.NEWS_FIELD2 = i.NEWS_FIELD2; enti.NEWS_URL = i.NEWS_URL; enti.NEWS_SEO_URL = i.NEWS_SEO_URL; enti.CAT_SEO_URL = i.CAT_SEO_URL; enti.NEWS_IMAGE3 = i.NEWS_IMAGE3; enti.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1); enti.UNIT_ID2 = Utils.CIntDef(i.UNIT_ID2); l.Add(enti); } return l; }
//Getpro cookie public List<Pro_details_entity> Loadpro_cookie(int type, List<string> listnews_url) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_TYPE == type && listnews_url.Contains(b.NEWS_SEO_URL) select new { b.NEWS_ID, b.UNIT_ID1, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_CODE, b.NEWS_COUNT, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); 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_CODE = i.NEWS_CODE; pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT); pro.UNIT_ID1 = Utils.CIntDef(i.UNIT_ID1); pro.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; } catch (Exception) { throw; } }
public List<Pro_details_entity> loadproAjax(int _Catid, int skip, int limit) { bool checkhsx = checkHangsx(_Catid); List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (checkhsx==true ? b.UNIT_ID2==_Catid : c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString())) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit).ToList(); 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; l.Add(pro); } return l; }
//xuat xu public List<Pro_details_entity> loadProhangXuatxu(int _catid, int _pricetype, string _price, int _sortype) { List<decimal> lprice = new List<decimal>(); decimal pri1 = 0; decimal pri2 = 0; if (!String.IsNullOrEmpty(_price)) { string[] a = _price.Split(','); if (a.Length == 2) { pri1 = Utils.CDecDef(a[0]); pri2 = Utils.CDecDef(a[1]); } else pri1 = Utils.CDecDef(a[0]); } List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.UNIT_ID1 == _catid && (_pricetype == 3 ? b.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE2 >= pri1 && b.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE2 > pri1 : 0 == _pricetype))) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, b.NEWS_FIELD3 }).Distinct(); switch (_sortype) { case 1: list = list.OrderBy(n => n.NEWS_TITLE); break; case 2: list = list.OrderByDescending(n => n.NEWS_TITLE); break; case 3: list = list.OrderByDescending(n => n.NEWS_PRICE1); break; case 4: list = list.OrderBy(n => n.NEWS_PRICE1); break; case 5: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderByDescending(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break; case 6: list = list.Where(n => n.NEWS_PRICE2 != 0).OrderBy(n => 100 - (n.NEWS_PRICE2 * 100 / n.NEWS_PRICE1)); break; default: list = list.OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER); break; } 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; l.Add(pro); } return l; }
public List<Pro_details_entity> Load_listproHasBrand(int _Catid, int _Brand, int _pricetype, string _price) { try { List<decimal> lprice = new List<decimal>(); decimal pri1 = 0; decimal pri2 = 0; if (!String.IsNullOrEmpty(_price)) { string[] a = _price.Split(','); if (a.Length == 2) { pri1 = Utils.CDecDef(a[0]); pri2 = Utils.CDecDef(a[1]); } else pri1 = Utils.CDecDef(a[0]); } List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where (c.CAT_ID == _Catid || c.CAT_PARENT_PATH.Contains(_Catid.ToString())) && (b.UNIT_ID3 == _Brand || 0 == _Brand) && (_pricetype == 3 ? b.NEWS_PRICE2 < pri1 : (_pricetype == 1 ? b.NEWS_PRICE2 >= pri1 && b.NEWS_PRICE2 <= pri2 : (_pricetype == 2 ? b.NEWS_PRICE2 > pri1 : 0 == _pricetype))) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).ToList(); 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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; } catch (Exception) { throw; } }
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid, int period, int limit) { try { int id = Utils.CIntDef(catid); List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where b.NEWS_PERIOD == period && (c.CAT_ID == id || c.CAT_PARENT_PATH.Contains(id.ToString())) select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER_PERIOD).Take(limit).ToList(); 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_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD); pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now); pro.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l.AsQueryable(); } catch (Exception) { throw; } }
public List<Pro_details_entity> Load_listproGoiY(int limit) { try { List<Pro_details_entity> l = new List<Pro_details_entity>(); var list = (from a in db.ESHOP_NEWS_CATs join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID where c.CAT_TYPE == 1 select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_PRICE1, b.NEWS_PRICE2, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderBy(x => Guid.NewGuid()).Take(limit).ToList(); 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.CAT_SEO_URL = i.CAT_SEO_URL; l.Add(pro); } return l; } catch (Exception) { throw; } }