void GetList() { #region Condition, orderby string condition = ""; if (igid != "") { condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, ""); } else { condition = GroupsTSql.GetGroupsByVgapp(app); } condition = DataExtension.AndConditon( condition, GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgenable("1"), ItemsTSql.GetItemsByIienable("1"), ItemsTSql.GetItemsByViapp(app)); if (key.Length > 0) { condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(key, ItemsColumns.VititleColumn, ItemsColumns.VikeyColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn)); } string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc "; try { rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang)); } catch { } #endregion DataTable dt = GroupsItems.GetAllData("", "*", condition, orderby); if (dt.Rows.Count > 0) { string link = ""; for (int i = 0; i < dt.Rows.Count; i++) { link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower(); if (i == 0) { ltrList.Text += @" <div class='itemM fade-up'> <div class='itemM__content'> <h2 class='itemM__ttl'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</h2> <p class='txtBase'> " + dt.Rows[i][ItemsColumns.VicontentColumn] + @" </p> </div> <div class='itemM__img img'> <div class='img__crop'> " + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "", false) + @" </div> </div> </div>"; } else if (i == 1) { ltrList.Text += @" <h2 class='ttl-comp03 ttl-comp03--md fade-up active'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</h2> <div class='box-tab'> <div class='img-left'> <img src='/img/seminor/img-left.jpg' alt=''> </div> " + GetOtherImages(dt.Rows[i][ItemsColumns.IidColumn].ToString()) + @" <div class='img-right'> <img src='/img/seminor/img-right.jpg' alt=''> </div> </div> "; } else { ltrList.Text += @" <div class='picture-restaurant'> <h2 class='ttl-comp03 ttl-comp03--md fade-up active'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</h2> <div class='list-picture'> " + GetOtherImages2(dt.Rows[i][ItemsColumns.IidColumn].ToString()) + @" </div> </div>"; } } } }
string GetList() { string s = ""; string condition = GroupsTSql.GetGroupsByVgapp(app); if (igid != "") { condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, ""); } condition = DataExtension.AndConditon(condition, GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgenable("1"), ItemsTSql.GetItemsByIienable("1"), ItemsTSql.GetItemsByViapp(app)); if (iid != "") { condition += " and ITEMS.IID<> " + iid + " "; } string fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn, ItemsColumns.IitotalviewColumn, ItemsColumns.VISEOLINKSEARCHColumn, ItemsColumns.DicreatedateColumn, ItemsColumns.ViImage, ItemsColumns.VidescColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn, ItemsColumns.ViurlColumn, ItemsColumns.VISEOMETAPARAMSColumn); string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc "; try { rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang)); } catch { } DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(rows.ToString(), fields, condition, orderby); if (dt.Rows.Count > 0) { string link = ""; string price = "", salePrice = ""; string time = ""; for (int i = 0; i < dt.Rows.Count; i++) { link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower(); price = dt.Rows[i][ItemsColumns.FipriceColumn].ToString(); salePrice = dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString(); if (price == "0" || price == "") { price = ""; salePrice = LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ"); } else if (salePrice == "0" || salePrice == "") { salePrice = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ"); price = ""; } else { price = NumberExtension.FormatNumber(price) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ"); salePrice = NumberExtension.FormatNumber(salePrice) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ"); } time = LayThoiGianTour(dt.Rows[i][ItemsColumns.ViurlColumn].ToString()); s += @" <div class='blog'> <div class='item item-post'> <div class='item-img'> <a href='" + link + @"' class='imgc'> " + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViImage].ToString(), dt.Rows[0][ItemsColumns.ViTitle].ToString(), "", true, false, "") + @" </a> <div class='item-date'> <div> <i class='fa fa-calendar' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Time") + @": " + time + @"</span> </div> <div> <i class='fa fa-plane' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Departure") + @": " + dt.Rows[i][ItemsColumns.VISEOMETAPARAMSColumn] + @"</span> </div> </div> </div> <div class='item-body'> <h3> <a href='" + link + @"' class='title item-title' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a> </h3> <div class='item-price'> <span class='real'>" + salePrice + @"</span> <span class='throught'>" + price + @"</span> </div> <a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i> </a> </div> </div> </div>"; } } return(s); }
string GetList() { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(TatThanhJsc.TourModul.CodeApplications.Tour), GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgenable("1"), ItemsTSql.GetItemsByIienable("1")); if (diemden.Length > 0) { condition += " AND VIAUTHOR = '" + diemden + "' "; ltrDiemDen.Text = LanguageItemExtension.GetnLanguageItemTitleByName("tới địa điểm ") + "<strong>" + LayDiemDen(diemden) + "</strong>"; } if (thoigian.Length > 0) { condition += " AND VIURL = '" + thoigian + "' "; ltrThoiGian.Text = LanguageItemExtension.GetnLanguageItemTitleByName("với thời lượng ") + "<strong>" + LayThoiGianTour(thoigian) + "</strong>"; } string orderby = ItemsColumns.DicreatedateColumn + " desc "; DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby); ltrTotalResult.Text = NumberExtension.FormatNumber(ds.Tables[1].Rows[0]["TotalRows"].ToString()); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; DataTable dtPager = ds.Tables[1]; if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0) { string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "?go=search&diemden=" + diemden + "&thoigian=" + thoigian, "hientai", "trangkhac", "dau", "cuoi", "truoc", "sau"); if (split.Length > 0) { int totalPage = 0; try { double totalrow = double.Parse(dtPager.Rows[0]["TotalRows"].ToString()); totalPage = (int)(totalrow / rows); if (totalPage < (totalrow / rows)) { totalPage++; } } catch { } ltrPagging.Text = split; } else { if (dt.Rows.Count < 1) { ltrPagging.Text = ""; } else { ltrPagging.Text = ""; } } } else { ltrPagging.Text = ""; } if (dt.Rows.Count > 0) { string link = ""; string price = "", salePrice = ""; string time = ""; for (int i = 0; i < dt.Rows.Count; i++) { link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower(); price = dt.Rows[i][ItemsColumns.FipriceColumn].ToString() == "0" ? "" : NumberExtension.FormatNumber(dt.Rows[i][ItemsColumns.FipriceColumn].ToString()) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ"); salePrice = dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString() == "0" ? LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ") : NumberExtension.FormatNumber(dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString()) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ"); time = LayThoiGianTour(dt.Rows[i][ItemsColumns.ViurlColumn].ToString()); s += @" <div class='col'> <div class='item item-post'> <div class='item-img'> <a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='imgc'> " + ImagesExtension.GetImage(TatThanhJsc.TourModul.FolderPic.Tour, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @" </a> <div class='item-date'> <div> <i class='fa fa-calendar' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Time") + @": " + time + @"</span> </div> <div> <i class='fa fa-plane' aria-hidden='true'></i><span>" + LanguageItemExtension.GetnLanguageItemTitleByName("Departure") + @": " + dt.Rows[i][ItemsColumns.VISEOMETAPARAMSColumn] + @"</span> </div> </div> </div> <div class='item-body'> <h3> <a href='" + link + @"' class='title item-title' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a> </h3> <div class='item-price'> <span class='real'>" + salePrice + @"</span> <span class='throught'>" + price + @"</span> </div> <a href='" + link + @"' class='link item-link' title='" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @"'>" + LanguageItemExtension.GetnLanguageItemTitleByName("More") + @" <i class='fa fa-angle-right' aria-hidden='true'></i> </a> </div> </div> </div>"; } } } return(s); }
private void LoadList() { lbListItem.Items.Clear(); DataTable dt = new DataTable(); if (ddlCateSource.SelectedValue.Length > 0) { condition = DataExtension.AndConditon( GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSource.SelectedValue, ItemsTSql.GetItemsByIienable("1"), ddlWebSource.SelectedValue), ItemsTSql.GetItemsByViapp(ddlModulSource.SelectedValue) ); dt = GroupsItems.GetAllData("", "*", condition, ItemsColumns.VititleColumn, ddlWebSource.SelectedValue); } for (int i = 0; i < dt.Rows.Count; i++) { lbListItem.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString())); } }