Exemplo n.º 1
0
    void LoadDetail()
    {
        DataTable dt = (DataTable)Session["dataByTitle"];

        if (dt.Rows.Count > 0)
        {
            UpdateTotalView(dt.Rows[0][ItemsColumns.IidColumn].ToString());

            ltrTitle.Text = dt.Rows[0][ItemsColumns.VititleColumn].ToString();
            ltrDate.Text  = ((DateTime)dt.Rows[0][ItemsColumns.DiupdateColumn]).ToString(LanguageItemExtension.GetnLanguageItemTitleByName("dd/MM/yyyy - HH:mm tt"));
            ltrViews.Text = NumberExtension.FormatNumber(((int)dt.Rows[0][ItemsColumns.IitotalviewColumn] + 1).ToString()) + " " + LanguageItemExtension.GetnLanguageItemTitleByName("lượt xem");

            ltContent.Text = dt.Rows[0][ItemsColumns.VicontentColumn].ToString();
            if (ltContent.Text == "")
            {
                ltContent.Text = "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName("Nội dung bài viết đang được chúng tôi cập nhật. Cảm ơn quý khách đã quan tâm!") + "</div>";
            }
        }
    }
Exemplo n.º 2
0
        /// <summary>
        /// 排序去除Top N
        /// </summary>
        /// <typeparam name="valueType">排序数据类型</typeparam>
        /// <param name="values">待排序数组</param>
        /// <param name="comparer">排序比较器</param>
        /// <param name="count">排序数据数量</param>
        /// <returns>排序后的数据</returns>
        private static valueType[] getRemoveTop <valueType>(this valueType[] values, Func <valueType, valueType, int> comparer, int count)
        {
            valueType[] newValues = new valueType[count];
            count = values.Length - count;
            uint sqrtMod;
            int  length = Math.Min(Math.Max(count << 2, count + (int)NumberExtension.sqrt((uint)values.Length, out sqrtMod)), values.Length);

            valueType[] removeValues = new valueType[length];
            int         readIndex = values.Length - length, copyCount = length - count, removeIndex = copyCount, writeIndex = copyCount;

            Array.Copy(values, readIndex, removeValues, 0, length);
            AutoCSer.Algorithm.RangeQuickSort.Sorter <valueType> sort = new AutoCSer.Algorithm.RangeQuickSort.Sorter <valueType> {
                Array = removeValues, Comparer = comparer, SkipCount = copyCount, GetEndIndex = copyCount
            };
            sort.Sort(0, --length);
            Array.Copy(removeValues, 0, newValues, 0, copyCount);
            for (valueType maxValue = removeValues[copyCount]; readIndex != 0;)
            {
                if (comparer(values[--readIndex], maxValue) <= 0)
                {
                    newValues[writeIndex++] = values[readIndex];
                }
                else
                {
                    removeValues[--removeIndex] = values[readIndex];
                    if (removeIndex == 0)
                    {
                        sort.Sort(0, length);
                        removeIndex = copyCount;
                        maxValue    = removeValues[copyCount];
                        Array.Copy(removeValues, 0, newValues, writeIndex, copyCount);
                        writeIndex += copyCount;
                    }
                }
            }
            if (removeIndex != copyCount)
            {
                sort.Sort(removeIndex, length);
                Array.Copy(removeValues, removeIndex, newValues, writeIndex, copyCount - removeIndex);
            }
            return(newValues);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Hiển thị giá niêm yết, giá khuyến mại. Nếu không có giá khuyến mại thì chỉ hiển thị giá niêm yết
        /// </summary>
        /// <param name="giaNY">dt.Rows[i][ItemsColumns.FipriceColumn].ToString()</param>
        /// <param name="giaKM">dt.Rows[i][ItemsColumns.FisalepriceColumn].ToString()</param>
        /// <returns></returns>
        public static string HienThiGia(string giaNY, string giaKM)
        {
            string s = "";

            if (giaKM != "0")
            {
                s += "<span class='giaKM'>" +
                     NumberExtension.FormatNumber(giaKM, true, LanguageItemExtension.GetnLanguageItemTitleByName("liên hệ"), LanguageItemExtension.GetnLanguageItemTitleByName("đ")) +
                     "</span>";
                s += " <span class='giaNY'>" +
                     NumberExtension.FormatNumber(giaNY, true, LanguageItemExtension.GetnLanguageItemTitleByName("liên hệ"), LanguageItemExtension.GetnLanguageItemTitleByName("đ")) +
                     "</span>";
            }
            else
            {
                s = "<span class='giaKM'>" +
                    NumberExtension.FormatNumber(giaNY, true, LanguageItemExtension.GetnLanguageItemTitleByName("liên hệ"), LanguageItemExtension.GetnLanguageItemTitleByName("đ")) +
                    "</span>";
            }
            return(s);
        }
Exemplo n.º 4
0
    void LoadDetail()
    {
        DataTable dt = (DataTable)Session["dataByTitle"];

        if (dt.Rows.Count > 0)
        {
            UpdateTotalView(dt.Rows[0][ItemsColumns.IidColumn].ToString());
            ltrTitle.Text = dt.Rows[0][ItemsColumns.VititleColumn].ToString();

            ltContent.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 9);

            string price     = dt.Rows[0][ItemsColumns.FipriceColumn].ToString();
            string salePrice = dt.Rows[0][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Đ");
            }

            ltrSalePrice.Text = salePrice;
            ltrPrice.Text     = price;


            if (ltContent.Text == "")
            {
                ltContent.Text = "<div class='emptyresult'>" + LanguageItemExtension.GetnLanguageItemTitleByName("Nội dung bài viết đang được chúng tôi cập nhật. Cảm ơn quý khách đã quan tâm!") + "</div>";
            }
        }
    }
Exemplo n.º 5
0
        /// <summary>
        /// 排序取Top N
        /// </summary>
        /// <typeparam name="valueType">排序数据类型</typeparam>
        /// <param name="values">待排序数组</param>
        /// <param name="comparer">排序比较器</param>
        /// <param name="count">排序数据数量</param>
        /// <returns>排序后的数据</returns>
        private static SubArray <valueType> getTop <valueType>(this valueType[] values, Func <valueType, valueType, int> comparer, int count)
        {
            uint sqrtMod;
            int  length = Math.Min(Math.Max(count << 2, count + (int)NumberExtension.sqrt((uint)values.Length, out sqrtMod)), values.Length);

            valueType[] newValues = new valueType[length];
            int         readIndex = values.Length - length, writeIndex = count;

            Array.Copy(values, readIndex, newValues, 0, length);
            AutoCSer.Algorithm.RangeQuickSort.Sorter <valueType> sort = new AutoCSer.Algorithm.RangeQuickSort.Sorter <valueType> {
                Array = newValues, Comparer = comparer, SkipCount = count - 1, GetEndIndex = count - 1
            };
            sort.Sort(0, --length);
            for (valueType maxValue = newValues[sort.GetEndIndex]; readIndex != 0;)
            {
                if (comparer(values[--readIndex], maxValue) < 0)
                {
                    newValues[writeIndex] = values[readIndex];
                    if (writeIndex == length)
                    {
                        sort.Sort(0, length);
                        writeIndex = count;
                        maxValue   = newValues[sort.GetEndIndex];
                    }
                    else
                    {
                        ++writeIndex;
                    }
                }
            }
            if (writeIndex != count)
            {
                sort.Sort(0, writeIndex - 1);
            }
            if (AutoCSer.DynamicArray <valueType> .IsClearArray)
            {
                Array.Clear(newValues, count, newValues.Length - count);
            }
            return(new SubArray <valueType>(0, count, newValues));
        }
    protected string ThanhTien(string soLuong, string donGia)
    {
        double soluong = 0;
        double dongia  = 0;

        try
        {
            soluong = double.Parse(soLuong);
        }
        catch
        {
        }
        try
        {
            dongia = double.Parse(donGia);
        }
        catch
        {
        }
        dongia *= soluong;

        return(NumberExtension.FormatNumber(dongia.ToString()));
    }
Exemplo n.º 7
0
    private void GetPrice()
    {
        string s   = "Success";
        string iid = Request.Params["iid"];

        string ToTalPrice       = "";
        string ToTalPriceOrigin = "";

        string GiaNguoiLon       = "";
        string GiaTreViThanhNien = "";
        string GiaTreEm          = "";
        string GiaEmBe           = "";

        DataTable dt = GroupsItems.GetAllData("1", "*", ItemsTSql.GetById(iid), ItemsColumns.IiorderColumn + " desc ");

        if (dt.Rows.Count > 0)
        {
            ToTalPriceOrigin = dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString() == "0" ? dt.Rows[0][ItemsColumns.FipriceColumn].ToString() == "0" ? LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ") : dt.Rows[0][ItemsColumns.FipriceColumn].ToString() : dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString();

            if (ToTalPriceOrigin != LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ"))
            {
                ToTalPrice = NumberExtension.FormatNumber(ToTalPriceOrigin);
            }
            else
            {
                ToTalPrice = LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ");
            }

            GiaNguoiLon       = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 1);
            GiaTreViThanhNien = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 2);
            GiaTreEm          = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 3);
            GiaEmBe           = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 4);
        }

        string[] strArrayReturn = { s, ToTalPriceOrigin, ToTalPrice, GiaNguoiLon, GiaTreViThanhNien, GiaTreEm, GiaEmBe };
        Response.Write(js.Serialize(strArrayReturn));
    }
Exemplo n.º 8
0
    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);

        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(), "*", condition, orderby);
        if (dt.Rows.Count > 0)
        {
            string link = "";

            s += @"<h2 class='ttl-comp04 fade-up'><span><b>Tin khác</b></span></h2>
            <div class='other-news'>";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();



                s += @"
<div class='other-news__item fade-up'>
        <div class='other-news__img img'>
           <a class='img__crop' href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn].ToString().Replace("'", "") + @"'>
                " + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
            </a>
        </div>
        <h3 class='other-news__ttl'><a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn].ToString().Replace("'", "") + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a></h3>
        <div class='thongke'>
            <div class='thongke__time'><i class='fa fa-clock-o'></i>" + ((DateTime)dt.Rows[i][ItemsColumns.DiCreateDate]).ToString(LanguageItemExtension.GetnLanguageItemTitleByName("dd/MM/yyyy")) + @"</div>
            <div class='thongke__view'><i class='fa fa-eye'></i>" + NumberExtension.FormatNumber(((int)dt.Rows[i][ItemsColumns.IitotalviewColumn] + 1).ToString()) + @" lượt xem</div>
        </div>
        <p class='txtBase'>" + dt.Rows[i][ItemsColumns.VidescColumn] + @"</p>
    </div>";
            }

            s += @"</div>";
        }
        return(s);
    }
Exemplo n.º 9
0
    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
        }
    }
Exemplo n.º 10
0
    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"));

        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);
        #region Lấy ra danh sách bài viết

        string s  = "";
        string s1 = "";
        string s2 = "";
        if (dt.Rows.Count > 0)
        {
            string link      = "";
            string titleIT   = "";
            string img       = "";
            string detail    = "";
            string dateIT    = "";
            string countView = "";

            string ds_tintucnoibat_right = "";

            s += @"<div class='head_news'>
            <div class='list-news01'>";



            s2 += @"<div class='main-left'>
                <div class='list-news02'>";

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                link      = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
                img       = ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "");
                titleIT   = dt.Rows[i][ItemsColumns.VititleColumn].ToString().Replace("'", "");
                detail    = dt.Rows[i][ItemsColumns.ViDesc].ToString();
                dateIT    = ((DateTime)dt.Rows[i][ItemsColumns.DiCreateDate]).ToString(LanguageItemExtension.GetnLanguageItemTitleByName("dd/MM/yyyy"));
                countView = NumberExtension.FormatNumber(((int)dt.Rows[i][ItemsColumns.IitotalviewColumn]).ToString());

                if (i < 6)
                {
                    s += @"
                    <div class='list-news01__item fade-up'>
                        <div class='img'>
                            <a class='img__crop' href='" + link + "' title='" + titleIT + @"'>" + img + @"</a>
                        </div>
                        <h2 class='list-news01__ttl'><a  href='" + link + "' title='" + titleIT + @"'>" + titleIT + @"</a></h2>
                    </div> ";
                }

                if (i > 5)
                {
                    s2 += @"
                    <div class='list-news02__item fade-up " + (i > 8?"hide":"") + @"'>
                        <div class='list-news02__img img'>
                             <a class='img__crop' href='" + link + "' title='" + titleIT + @"'>" + img + @"</a>
                        </div>
                        <div class='list-news02__content'>
                            <h3 class='list-news02__ttl'><a href='" + link + "' title='" + titleIT + @"'>" + titleIT + @" </a></h3>
                            <p class='txtBase'>" + detail + @"</p>
                        </div>
                    </div>";
                }
            }


            s += @"</div></div>";

            s2 += @"</div> <a href='javascript:void(0)' onclick='showmoreNews(this)' class='btn-view fade-up'>Xem thêm tin</a></div>";
        }
        #endregion
        s1 += @" <h2 class='ttl-comp04 fade-up'><span><b>Tin khác</b></span></h2>
        <div class='main-news'>";
        s1 += s2;
        s1 += GetGroups2("");
        s1 += @"</div></div>";

        ltrList.Text = s + s1;
    }
Exemplo n.º 11
0
    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);

        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 = "";

            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Đ");
                }
                s += @"
        <div class='blog'>
          <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.ViImage].ToString(), dt.Rows[0][ItemsColumns.ViTitle].ToString(), "", true, false, "") + @"
              </a>
            </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);
    }
Exemplo n.º 12
0
    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
        }
    }
Exemplo n.º 13
0
    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);
    }
Exemplo n.º 14
0
    private string BindItemsToHTML(DataTable dt)
    {
        string s = "";

        if (dt.Rows.Count > 0)
        {
            string link = "";
            string price = "", salePrice = "";
            string time  = "";
            int    point = dt.Rows.Count - 4;

            if (point < 1)
            {
                point = 1;
            }

            string layout1 = "";
            string layout2 = "";

            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)
                {
                    layout1 += @"
          <div class='blog'>
            <div class='item item-post item-big'>
              <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 + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='title item-title'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
                </h3>
                <p class='item-text'>" + dt.Rows[i][ItemsColumns.VidescColumn] + @"</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>
          </div>";
                }
                else
                {
                    layout2 += @"
          <div class='colBlog'>
            <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>";
                }
            }

            s = @"
      <div class='colBlog colDouble'>
        <div class='slick-slider' data-slick='{""slidesToShow"": 1, ""slidesToScroll"": 1, ""autoplay"": false, ""dots"": false, ""arrows"":true, ""responsive"": [{""breakpoint"":1025,""settings"": ""unslick""}]}'>
          " + layout1 + @"
        </div>
      </div>
      " + layout2 + @"";
        }
        return(s);
    }
 [TestCase(-8, -15, 1, 4, ExpectedResult = -6)] //-30
 public int Insertion_CorrectInputValues_PositiveTest(int first, int second, int startPosition, int finishPosition)
 {
     return(NumberExtension.Insertion(first, second, startPosition, finishPosition));
 }
Exemplo n.º 16
0
    string GetList(string igid, string top)
    {
        string s = "";

        #region Condition, orderby, fields
        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 ";

        string fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn,
                                                     ItemsColumns.ViimageColumn, ItemsColumns.VISEOLINKSEARCHColumn, ItemsColumns.VidescColumn, ItemsColumns.DiCreateDate, ItemsColumns.IiTotalView, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn, ItemsColumns.VicontentColumn);
        #endregion

        DataTable dt = GroupsItems.GetAllData(top, fields, condition, orderby);

        #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 = dt.Rows.Count - 4;

            if (point < 1)
            {
                point = 1;
            }

            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>";
                }
            }

            s = @"        
      <div class='sublist sublist-1'>
        <div class='sublist-body'>
          <div class='slick-slider' data-slick='{'slidesToShow': 1, 'slidesToScroll': 1, 'autoplay': false, '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

        return(s);
    }
 public void Insertion_InputValuesGreater31OrLess0_ThrowsArgumentException(int first, int second, int startPosition, int finishPosition)
 {
     Assert.Throws <ArgumentException>(() => NumberExtension.Insertion(first, second, startPosition, finishPosition));
 }
 public int NextBiggerNumber_CorrectInputValues_PositiveTest(int number)
 {
     return(NumberExtension.NextBiggerNumber(number));
 }
Exemplo n.º 19
0
        /// <summary>
        /// HTTP 响应头部输出
        /// </summary>
        /// <param name="response"></param>
        /// <returns></returns>
        private bool responseHeader(ref Response response)
        {
            try
            {
                if (!response.IsFile)
                {
                    ResponseError(ResponseState.NotFound404);
                    return true;
                }
                System.Net.Sockets.Socket socket;
                ResponseFlag responseFlag = response.Flag;
                if (response.Body.Length != 0 && Header.IsKeepAlive != 0 && (responseFlag & ResponseFlag.HeaderSize) != 0 && Header.IsRange == 0 && Header.Method != MethodType.HEAD)
                {
                    if ((socket = Socket) == null) return false;
                    Data = response.Body;
                    Data.MoveStart(-response.HeaderSize);
                    SendType = SendType.Next;
                    Timeout = Config.GetTimeout(Data.Length);
#if DOTNET2
                    SocketError socketError;
                    IAsyncResult async = socket.BeginSend(Data.Array, Data.Start, Data.Length, SocketFlags.None, out socketError, onSendAsyncCallback, socket);
                    if (socketError == SocketError.Success)
                    {
                        if (!async.CompletedSynchronously) Http.Header.ReceiveTimeout.Push(this, socket);
                        return true;
                    }
                    return false;
#else
                    sendAsyncLock.EnterSleepFlag();
                    sendAsyncEventArgs.SetBuffer(Data.Array, Data.Start, Data.Length);
                    if (socket.SendAsync(sendAsyncEventArgs))
                    {
                        sendAsyncLock.SleepFlag = 0;
                        Http.Header.ReceiveTimeout.Push(this, socket);
                        sendAsyncLock.Exit();
                        return true;
                    }
                    sendAsyncLock.ExitSleepFlag();
                    if (--sendDepth == 0)
                    {
                        sendDepth = maxSendDepth;
                        OnSendThreadArray.Default.CurrentThread.Add(this);
                        return true;
                    }
                    return onSend();
#endif
                }
                ResponseSize = response.BodySize;
                fixed (byte* headerBufferFixed = Header.Buffer.GetFixedBuffer())
                {
                    byte* responseSizeFixed = headerBufferFixed + (Header.Buffer.StartIndex + Http.Header.ReceiveBufferSize);
                    RangeLength responseSizeIndex, bodySizeIndex = new RangeLength(), rangeStartIndex = new RangeLength(), rangeEndIndex = new RangeLength();
                    ResponseState state = response.ResponseState;
                    if (Header.IsRange != 0 && (responseFlag & ResponseFlag.IsPool) != 0)
                    {
                        if (Header.IsFormatRange != 0 || Header.FormatRange(ResponseSize))
                        {
                            if (state == ResponseState.Ok200)
                            {
                                long rangeStart = Header.RangeStart, rangeEnd = Header.RangeEnd;
                                rangeStartIndex = NumberExtension.ToBytes((ulong)rangeStart, responseSizeFixed + 20 * 2);
                                rangeEndIndex = NumberExtension.ToBytes((ulong)rangeEnd, responseSizeFixed + 20 * 3);
                                bodySizeIndex = NumberExtension.ToBytes((ulong)ResponseSize, responseSizeFixed + 20);
                                response.State = state = ResponseState.PartialContent206;
                                ResponseSize = Header.RangeSize;
                            }
                        }
                        else
                        {
                            ResponseSize = 0;
                            ResponseError(ResponseState.RangeNotSatisfiable416);
                            return true;
                        }
                    }
                    if ((ulong)ResponseSize < 10)
                    {
                        *responseSizeFixed = (byte)((int)ResponseSize + '0');
                        responseSizeIndex = new RangeLength(0, 1);
                    }
                    else responseSizeIndex = NumberExtension.ToBytes((ulong)ResponseSize, responseSizeFixed);
                    ResponseStateAttribute stateAttribute = EnumAttribute<ResponseState, ResponseStateAttribute>.Array((byte)state);
                    if (stateAttribute == null) stateAttribute = EnumAttribute<ResponseState, ResponseStateAttribute>.Array((byte)ResponseState.ServerError500);
                    int index = httpVersionSize + stateAttribute.Text.Length + contentLengthSize + responseSizeIndex.Length + 2 + 2;
                    if (state == ResponseState.PartialContent206)
                    {
                        index += rangeSize + rangeStartIndex.Length + rangeEndIndex.Length + bodySizeIndex.Length + 2 + 2;
                    }
                    Cookie cookie = null;
                    SubBuffer.PoolBufferFull buffer = GetBuffer(index = GetResponseHeaderIndex(response, index, ref cookie));
                    fixed (byte* bufferFixed = buffer.GetFixedBuffer())
                    {
                        byte* bufferStart = bufferFixed + buffer.StartIndex, write = bufferStart + httpVersionSize;
                        writeHttpVersion(bufferStart);
                        stateAttribute.Write(write);
                        writeContentLength(write += stateAttribute.Text.Length);
                        AutoCSer.Memory.Common.SimpleCopyNotNull64(responseSizeFixed + responseSizeIndex.Start, write += contentLengthSize, responseSizeIndex.Length);
                        *(short*)(write += responseSizeIndex.Length) = 0x0a0d;
                        write += sizeof(short);
                        if (state == ResponseState.PartialContent206)
                        {
                            writeRange(write);
                            AutoCSer.Memory.Common.SimpleCopyNotNull64(responseSizeFixed + (rangeStartIndex.Start + 20 * 2), write += rangeSize, rangeStartIndex.Length);
                            *(write += rangeStartIndex.Length) = (byte)'-';
                            AutoCSer.Memory.Common.SimpleCopyNotNull64(responseSizeFixed + (rangeEndIndex.Start + 20 * 3), ++write, rangeEndIndex.Length);
                            *(write += rangeEndIndex.Length) = (byte)'/';
                            AutoCSer.Memory.Common.SimpleCopyNotNull64(responseSizeFixed + (bodySizeIndex.Start + 20), ++write, bodySizeIndex.Length);
                            *(short*)(write += bodySizeIndex.Length) = 0x0a0d;
                            write += sizeof(short);
                        }
                        index = (int)(CreateResponseHeader(response, cookie, write, index) - bufferStart);
                        //                    if (checkIndex != index)
                        //                    {
                        //                        Server.RegisterServer.TcpServer.Log.add(Log.Type.Fatal, "responseHeader checkIndex[" + checkIndex.toString() + "] != index[" + index.toString() + @"]
                        //" + System.Text.Encoding.ASCII.GetString(buffer.Buffer, buffer.StartIndex, index));
                        //                    }
                        if (ResponseSize != 0)
                        {
                            switch (response.Type)
                            {
                                case ResponseType.ByteArray:
                                    if (buffer.Length - index >= (int)ResponseSize)
                                    {
                                        System.Buffer.BlockCopy(response.Body.Array, state == ResponseState.PartialContent206 ? (int)Header.RangeStart : 0, buffer.Buffer, buffer.StartIndex + index, (int)ResponseSize);
                                        index += (int)ResponseSize;
                                        ResponseSize = 0;
                                    }
                                    break;
                                case ResponseType.SubByteArray:
                                    if (Header.IsKeepAlive != 0 && (responseFlag & ResponseFlag.CanHeaderSize) != 0 && index <= response.Body.Start && Header.IsRange == 0)
                                    {
                                        if ((socket = Socket) == null) return false;
                                        fixed (byte* bodyFixed = response.Body.GetFixedBuffer()) AutoCSer.Memory.Common.CopyNotNull(bufferStart, bodyFixed + response.Body.Start - index, index);
                                        response.SetHeaderSize(index);

                                        Data = response.Body;
                                        Data.MoveStart(-response.HeaderSize);
                                        SendType = SendType.Next;
                                        Timeout = Config.GetTimeout(Data.Length);
#if DOTNET2
                                    SocketError socketError;
                                    IAsyncResult async = socket.BeginSend(Data.Array, Data.Start, Data.Length, SocketFlags.None, out socketError, onSendAsyncCallback, socket);
                                    if (socketError == SocketError.Success)
                                    {
                                        if (!async.CompletedSynchronously) Http.Header.ReceiveTimeout.Push(this, socket);
                                        return true;
                                    }
                                    return false;
#else
                                        sendAsyncLock.EnterSleepFlag();
                                        sendAsyncEventArgs.SetBuffer(Data.Array, Data.Start, Data.Length);
                                        if (socket.SendAsync(sendAsyncEventArgs))
                                        {
                                            sendAsyncLock.SleepFlag = 0;
                                            Http.Header.ReceiveTimeout.Push(this, socket);
                                            sendAsyncLock.Exit();
                                            return true;
                                        }
                                        sendAsyncLock.ExitSleepFlag();
                                        if (--sendDepth == 0)
                                        {
                                            sendDepth = maxSendDepth;
                                            OnSendThreadArray.Default.CurrentThread.Add(this);
                                            return true;
                                        }
                                        return onSend();
#endif
                                    }
                                    goto COPY;
                                case ResponseType.SubBuffer:
                                    COPY:
                                    if (buffer.Length - index >= (int)ResponseSize)
                                    {
                                        System.Buffer.BlockCopy(response.Body.Array, state == ResponseState.PartialContent206 ? response.Body.Start + (int)Header.RangeStart : response.Body.Start, buffer.Buffer, buffer.StartIndex + index, (int)ResponseSize);
                                        index += (int)ResponseSize;
                                        ResponseSize = 0;
                                    }
                                    break;
                            }
                        }
                    }
                    if ((socket = Socket) != null)
                    {
                        if (ResponseSize == 0) SendType = SendType.Next;
                        else
                        {
                            this.HttpResponse = response;
                            SendType = SendType.Body;
                            response = null;
                        }
                        Data.Set(buffer.Buffer, buffer.StartIndex, index);
                        Timeout = Config.GetTimeout(Data.Length);
#if DOTNET2
                    SocketError socketError;
                    IAsyncResult async = socket.BeginSend(Data.Array, Data.Start, index, SocketFlags.None, out socketError, onSendAsyncCallback, socket);
                    if (socketError == SocketError.Success)
                    {
                        if (!async.CompletedSynchronously) Http.Header.ReceiveTimeout.Push(this, socket);
                        return true;
                    }
                    return false;
#else
                        sendAsyncLock.EnterSleepFlag();
                        sendAsyncEventArgs.SetBuffer(Data.Array, Data.Start, index);
                        if (socket.SendAsync(sendAsyncEventArgs))
                        {
                            sendAsyncLock.SleepFlag = 0;
                            Http.Header.ReceiveTimeout.Push(this, socket);
                            sendAsyncLock.Exit();
                            return true;
                        }
                        sendAsyncLock.ExitSleepFlag();
                        if (--sendDepth == 0)
                        {
                            sendDepth = maxSendDepth;
                            OnSendThreadArray.Default.CurrentThread.Add(this);
                            return true;
                        }
                        return onSend();
#endif
                    }
                }
            }
            catch (Exception error)
            {
                Server.RegisterServer.TcpServer.Log.Exception(error, null, LogLevel.Exception | LogLevel.AutoCSer);
            }
            finally { Http.Response.Push(ref response); }
            return false;
        }
    void LoadDetail()
    {
        DataTable dt = (DataTable)Session["dataByTitle"];

        if (dt.Rows.Count > 0)
        {
            iid   = dt.Rows[0][ItemsColumns.IidColumn].ToString();
            hotel = dt.Rows[0][ItemsColumns.VititleColumn].ToString();
            price = dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString() == "0" ? LanguageItemExtension.GetnLanguageItemTitleByName("Liên hệ") : NumberExtension.FormatNumber(dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString()) + LanguageItemExtension.GetnLanguageItemTitleByName("VNĐ");
        }
    }