public string ShowProductAll()
    {
        CDynamicViewProduct ViewProduct;
        int currentpage = 0;
        int size        = 20;

        try
        {
            currentpage = int.Parse(Request.QueryString["page"].ToString());
            size        = int.Parse(Request.QueryString["size"].ToString());
            if (size > 40 || size < 10)
            {
                size = 20;
            }
        }
        catch
        {
        }
        if (Session["SSProductOther"] != null)
        {
            ViewProduct = (CDynamicViewProduct)Session["SSProductOther"];
            ViewProduct.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetNumberOther();
                ViewProduct.SetCurrentPage();
            }
        }
        else
        {
            ViewProduct  = new CDynamicViewProduct();
            string where = "where producttypeid not in (" + Application["idtypeproduct"].ToString() + "," + Application["apppda"].ToString() + ") and cansales=1";
            ViewProduct.SetWhere(where);
            ViewProduct.SetNumberOther();
            ViewProduct.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetCurrentPage();
            }
            Session["SSProductOther"] = ViewProduct;
        }
        blpro = string.Format(blpro, "<u>" + ViewProduct.GetNumberRecord() + "</u>");
        DataSet   product = ViewProduct.ProductOtherFromTo();
        DataTable table   = product.Tables[0];
        int       numPro  = table.Rows.Count;

        if (ViewProduct.GetPages() > 1)
        {
            strpage1 = CreatePage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 1);
            strpage2 = CreatePage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 2);
        }
        string strProMain = "";

        if (numPro > 0)
        {
            string id       = "";
            string name     = "";
            string url      = "";
            string price    = "";
            string warranty = "";
            string note     = "";
            string brand    = "";
            strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
            for (int i = 0; i < numPro; i++)
            {
                id   = table.Rows[i]["Id"].ToString();
                name = table.Rows[i]["Name"].ToString();
                url  = table.Rows[i]["UrlImage"].ToString();
                note = table.Rows[i]["Note"].ToString();
                if (url.Length > 0)
                {
                    url = "image/img_pro/" + url;
                }
                else
                {
                    url = "image/common/notimgpro.png";
                }
                price       = table.Rows[i]["SellingPrice"].ToString();
                warranty    = table.Rows[i]["WarrantyMonth"].ToString();
                brand       = table.Rows[i]["brand"].ToString();
                strProMain += "<tr><td width='300'>";
                strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                strProMain += "<tr><td rowspan='2' width='80' align='center'><a href='?menu=dother&id=" + id + "'><img class='img1' src='" + url + "'/></a></td>";
                strProMain += "<td class='text_title'><a href='?menu=dother&id=" + id + "'>" + name + "</a></td></tr>";
                strProMain += "<tr><td>" + tbrand + ": <span class='price'>" + brand + "</span><br />" + tprice + ": <span class='price'>" + price + " " + table.Rows[i]["currency"].ToString() + "</span><br />" + twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                if (table.Rows[i]["promotion"].ToString().Length > 0)
                {
                    strProMain += "<br /><img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/>";
                }
                strProMain += "</td></tr>";
                strProMain += "<tr><td colspan='2' align='center'><div class='button3' onclick='AddCart(" + id + ",4);'>" + torder + "</div></td></tr>";
                strProMain += "</table></td>";
                strProMain += "<td>" + note + "</td></tr>";
                if (i < numPro - 1)
                {
                    strProMain += "<tr><td colspan='2' class='bg_line3'></td></tr>";
                }
            }
            strProMain += "</table>";
        }
        return(strProMain);
    }