void GetService(string order) { if (!igid.Equals("")) { ddlCateSearch.SelectedValue = igid; condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ""); } else { condition = DataExtension.AndConditon( "VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); } condition += " AND IIENABLE <> '2' "; if (tbKeySearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn); } if (tbTitleSearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn); } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.Service, TypePage.Item, ddlCateSearch.SelectedValue, key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void GetPhotoAlbum(string order) { DdlListShowItem.SelectedValue = NumberShowItem; if (!igid.Equals("")) { ddl_group_ontab.SelectedValue = igid; conditionItems = GroupsItemsTSql.GetItemsInGroupCondition(ddl_group_ontab.SelectedValue, ""); } else { conditionItems = DataExtension.AndConditon( "VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); } conditionItems = DataExtension.AndConditon(conditionItems, ItemsTSql.GetItemsByViapp(app)); conditionItems += " AND IIENABLE = '2' "; if (txt_key.Text.Length > 0 && !txt_key.Text.Equals(strdisplay)) { SearchCondition = " AND " + SearchTSql.GetSearchMathedCondition(txt_key.Text, ItemsColumns.VititleColumn); } if (txt_key.Text.Equals(strdisplay)) { txt_key.Text = ""; } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, NumberShowItem, conditionItems + SearchCondition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(NumberShowItem), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.PhotoAlbum, TypePage.RecycleItem, ddl_group_ontab.SelectedValue, txt_key.Text, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void GetNews(string order) { DdlListShowItem.SelectedValue = NumberShowItem; condition = DataExtension.AndConditon( "VIAPP = 'QLDDDV'", ItemsTSql.GetByLang(language)); condition += " AND IIENABLE <> '2' "; if (tbKeySearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.ViauthorColumn); } if (tbTitleSearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn); } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(NumberShowItem), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.Service, "QuanLyDonDatDichVu", "", key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void GetNew(string order) { if (!igid.Equals("")) { ddlCateSearch.SelectedValue = igid; condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app)); } else { condition = DataExtension.AndConditon( "VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); } #region Hiển thị bài đã duyệt theo trạng thái phân quyền string userRole = CookieExtension.GetCookies("RolesUser"); condition += " AND VIURL = '" + userId + "' "; if (HorizaMenuConfig.ShowDuyetTin2) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap1, userRole)) { #region Với tài khoản cấp 1 (phóng viên, biên tập viên) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap1 + "' "; #endregion } else if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole)) { #region Với tài khoản cấp 2 (tổng biên tập) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' "; #endregion } } else if (HorizaMenuConfig.ShowDuyetTin1) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole)) { #region Với tài khoản cấp 1 (phóng viên, biên tập viên) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' "; #endregion } } #endregion if (tbKeySearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn); } if (tbTitleSearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn); } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), LinkAdmin.UrlAdmin(app, "QuanLyBaiVietChoPheDuyet", ddlCateSearch.SelectedValue, key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void GetCustomerReviews(string order) { DdlListShowItem.SelectedValue = NumberShowItem; if (!igid.Equals("")) { ddl_group_ontab.SelectedValue = igid; conditionItems = GroupsItemsTSql.GetItemsInGroupCondition(ddl_group_ontab.SelectedValue, ItemsTSql.GetItemsByViapp(app)); } else { conditionItems = DataExtension.AndConditon( "VGAPP = '" + appcate + "'", GroupsTSql.GetGroupsByVglang(language), ItemsTSql.GetItemsByViapp(app), ItemsTSql.GetItemsByVilang(language)); } conditionItems = DataExtension.AndConditon(conditionItems, ItemsTSql.GetItemsByViapp(app)); #region Lọc với tính năng duyệt tin if (CustomerReviewsConfig.KeyDuyetTin) { pnStatus.Visible = false; keyHide = "dn"; string userId = CookieExtension.GetCookies("userId"); if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2) { conditionItems += " AND VIURL = '" + userId + "' "; } } #endregion conditionItems += " AND IIENABLE = '2' "; if (txt_key.Text.Length > 0 && !txt_key.Text.Equals(strdisplay)) { SearchCondition = " AND " + SearchTSql.GetSearchMathedCondition(txt_key.Text, ItemsColumns.VititleColumn); } if (txt_key.Text.Equals(strdisplay)) { txt_key.Text = ""; } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, NumberShowItem, conditionItems + SearchCondition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(NumberShowItem), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.CustomerReviews, TypePage.RecycleItem, ddl_group_ontab.SelectedValue, txt_key.Text, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
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 DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; DataTable dtPager = ds.Tables[1]; #region Lấy ra danh sách bài viết if (dt.Rows.Count > 0) { string link = ""; string bigPost = "", smallPost = ""; string price = "", salePrice = ""; int point = 2; 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Đ"); } if (i < point) { bigPost += @" <div class='blog'> <div class='item item-row'> <div class='item-img'> <a href='" + link + @"' class='imgc'> " + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @" </a> </div> <div class='item-body'> <h3> <a href='" + link + @"' class='title item-title fSize-20'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a> </h3> <div class='item-text'> " + StringExtension.LayChuoi(dt.Rows[i][ItemsColumns.VicontentColumn].ToString(), "", 1) + @" </div> <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>"; } else { smallPost += @" <div class='col-12 col-sm-12 col-md-6 col-lg-6 col-xl-3'> <div class='item item-post'> <div class='item-img'> <a href='" + link + @"' class='imgc'> " + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @" </a> </div> <div class='item-body'> <h3> <a href='" + link + @"' class='title item-title'>" + 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>"; } ltrList.Text = @" <div class='sublist sublist-1'> <div class='sublist-body'> <div class='slick-slider' data-slick='{'slidesToShow': 1, 'slidesToScroll': 1, 'autoplay': true, 'dots': false, 'arrows':true}'> " + bigPost + @" </div> </div> </div> <div class='sublist sublist-2'> <div class='sublist-body'> <div class='row'> " + smallPost + @" </div> </div> </div>"; } } #endregion #region Xuất ra phân trang if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0) { string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "", "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 { } ltrPaging.Text += PagingExtension02.XuLyPhanTrang(split, dtPager.Rows[0]["TotalRows"].ToString(), (title != "" ? title : go), LanguageItemExtension.GetnLanguageItemTitleByName("Đầu"), LanguageItemExtension.GetnLanguageItemTitleByName("Cuối"), LanguageItemExtension.GetnLanguageItemTitleByName("Trước"), LanguageItemExtension.GetnLanguageItemTitleByName("Sau")); } else { if (dt.Rows.Count < 1) { ltrList.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>"; } } } else { ltrList.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>"; } #endregion } }
void GetItems(string order) { if (!igid.Equals("")) { ddlCateSearch.SelectedValue = igid; condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app)); } else { condition = DataExtension.AndConditon( "VGAPP = '" + appCate + "'", GroupsTSql.GetGroupsByVglang(language), ItemsTSql.GetItemsByViapp(app), ItemsTSql.GetItemsByVilang(language)); } #region Điều chỉnh bộ lọc với tính năng duyệt tin if (AboutUsConfig.KeyDuyetTin) { if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2) { string userId = CookieExtension.GetCookies("UserId"); condition += " AND IIENABLE = '0' "; condition += " AND VIURL = '" + userId + "' "; } } else { condition += " AND IIENABLE <> '2' AND IGENABLE <> '2' "; } #endregion if (tbKeySearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn); } if (tbTitleSearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn); } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.AboutUs, TypePage.Item, ddlCateSearch.SelectedValue, key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void GetList() { #region Condition, orderby string condition = ""; if (igid != "") { condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, ""); } else { condition = GroupsTSql.GetGroupsByIgid(igidFirst); } 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 DataSet ds = GroupsItems.GetAllDataPagging(p, rows.ToString(), condition, orderby); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; DataTable dtPager = ds.Tables[1]; #region Lấy ra danh sách bài viết if (dt.Rows.Count > 0) { string link = ""; string price = "", salePrice = ""; string time = ""; int point = 2; 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()); if (i < point) { ltrList1.Text += @" <div class='item item-post item-big'> <div class='item-img'> <a href='" + link + @"' class='imgc' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'> " + ImagesExtension.GetImage(pic, 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> <p class='item-text'>" + dt.Rows[i][ItemsColumns.VidescColumn].ToString() + @"</p> <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>"; } else { ltrList2.Text += @" <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(pic, 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>"; } } } #endregion #region Xuất ra phân trang if (dtPager.Rows.Count > 0 && dt.Rows.Count > 0) { string split = PagingExtension.SpilitPages(int.Parse(dtPager.Rows[0]["TotalRows"].ToString()), rows, int.Parse(p), "", "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 { } ltrPaging.Text += PagingExtension02.XuLyPhanTrang(split, dtPager.Rows[0]["TotalRows"].ToString(), (title != "" ? title : go), LanguageItemExtension.GetnLanguageItemTitleByName("Trang đầu"), LanguageItemExtension.GetnLanguageItemTitleByName("Trang cuối"), LanguageItemExtension.GetnLanguageItemTitleByName("Trước"), LanguageItemExtension.GetnLanguageItemTitleByName("Sau")); } else { if (dt.Rows.Count < 1) { ltrNoResult.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>"; pnInfo.Visible = false; } } } else { ltrNoResult.Text += "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName(noResultText) + "</div>"; pnInfo.Visible = false; } #endregion } }
void GetNew(string order) { if (!modul.Equals("")) { condition = DataExtension.AndConditon( "VGAPP = '" + modul + "'", GroupsTSql.GetGroupsByVglang(language)); } else { condition = DataExtension.AndConditon( DataExtension.OrConditon( GroupsTSql.GetGroupsByVgapp(TatThanhJsc.AboutUsModul.CodeApplications.AboutUs), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.AdvertisingModul.CodeApplications.Advertising), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ProductModul.CodeApplications.Product), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.DealModul.CodeApplications.Deal), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.FileLibraryModul.CodeApplications.FileLibrary), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ServiceModul.CodeApplications.Service), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.NewsModul.CodeApplications.News), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.PhotoAlbumModul.CodeApplications.PhotoAlbum), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.VideoModul.CodeApplications.Video), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.QAModul.CodeApplications.QA), GroupsTSql.GetGroupsByVgapp(TatThanhJsc.CustomerReviewsModul.CodeApplications.CustomerReviews) ), GroupsTSql.GetGroupsByVglang(language)); } #region Hiển thị bài đã duyệt theo trạng thái phân quyền string userRole = CookieExtension.GetCookies("RolesUser"); if (HorizaMenuConfig.ShowDuyetTin2) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole)) { #region Với tài khoản cấp 2 (trưởng ban biên tập) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' "; #endregion } else if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap3, userRole)) { #region Với tài khoản cấp 3 (tổng biên tập) condition += " AND IIENABLE = '1' "; #endregion } } else if (HorizaMenuConfig.ShowDuyetTin1) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap3, userRole)) { #region Với tài khoản cấp 3 (tổng biên tập) condition += " AND IIENABLE = '1' "; #endregion } } #endregion if (!title.Equals("")) { condition += " AND " + SearchTSql.GetSearchMathedCondition(title, ItemsColumns.VititleColumn); } if (!DateFrom.Equals("")) { DateTime dFrom = DateTime.ParseExact(DateFrom, "dd/MM/yyyy", null); condition += " AND DICREATEDATE >= '" + dFrom.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } if (!DateTo.Equals("")) { DateTime dTo = DateTime.ParseExact(DateTo, "dd/MM/yyyy", null).AddDays(1); condition += " AND DICREATEDATE < '" + dTo.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } if (!user.Equals("")) { condition += " AND " + SearchTSql.GetSearchMathedCondition(user, ItemsColumns.ViUrl); } condition += " AND VISEOMETACANONICAL <> '' "; if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = "modul=" + modul + "&user="******"&title=" + title + "&DateFrom=" + DateFrom + "&DateTo=" + DateTo + "&NumberShowItem=" + NumberShowItem; string linkSearch = UrlExtension.WebisteUrl + "/admin.aspx?uc=DuyetTin&suc=BaiVietDaDuyet&" + key; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), linkSearch, "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
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); }