Пример #1
0
        public Product_data ProductSearchFromTo(string where, int from, int to)
        {
            Product_data ds = new Product_data();

            try
            {
                //w_product_for_quick_search
                string sqlselect   = "";
                int    num_Row_Get = to - from;
                sqlselect = "SELECT * FROM ( ";
                sqlselect = sqlselect + "SELECT TOP " + num_Row_Get.ToString();
                sqlselect = sqlselect + " * FROM( SELECT TOP " + to.ToString() + " Id,Name,state,UrlImage,SellingPrice,WarrantyMonth,ShortNote,promotion,Isspec FROM v_web_product_advance_search " + where;
                sqlselect = sqlselect + " order by SellingPrice,id) as t1 ";
                sqlselect = sqlselect + " order by SellingPrice desc,id desc) as t2 ";
                sqlselect = sqlselect + " order by SellingPrice,id";
                SqlConnection  con = new SqlConnection(dataaccess.configsql.strcon);
                SqlDataAdapter da  = new SqlDataAdapter(sqlselect, con);
                da.Fill(ds, Product_data._table);
                con.Close();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(ds);
        }
Пример #2
0
        public Product_data ProductWithBrandFromTo(int idtype, int IdBrand, int from, int to)
        {
            Product_data ds = new Product_data();

            try
            {
                //w_product_with_brand
                string sqlselect   = "";
                int    num_Row_Get = to - from;
                sqlselect = "SELECT * FROM ( ";
                sqlselect = sqlselect + "SELECT TOP " + num_Row_Get.ToString();
                sqlselect = sqlselect + " * FROM( SELECT TOP " + to.ToString() + " Id,Name,state,StateId,UrlImage,SellingPrice,WarrantyMonth,ShortNote,promotion,isSpec FROM v_web_product_quick_view where ProductTypeid=" + idtype.ToString() + " and BrandId=" + IdBrand + "";
                sqlselect = sqlselect + " order by SellingPrice,id) as t1 ";
                sqlselect = sqlselect + " order by SellingPrice desc,id desc) as t2 ";
                sqlselect = sqlselect + " order by SellingPrice,id";
                SqlConnection  con = new SqlConnection(dataaccess.configsql.strcon);
                SqlDataAdapter da  = new SqlDataAdapter(sqlselect, con);
                da.Fill(ds, Product_data._table);
                con.Close();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(ds);
        }
Пример #3
0
 public void ViewPage()
 {
     try
     {
         int page = 1;
         int size = 30;
         CDynamicViewProduct Products = new CDynamicViewProduct();
         if (Request.QueryString["advance"] != null)
         {
             if (Session["ssadvancesearchpro"] == null)
             {
                 Response.Redirect("Default.aspx?menu=asp");
             }
             try
             {
                 if (Request.QueryString["page"] != null)
                 {
                     page = int.Parse(Request.QueryString["page"].ToString());
                     if (page < 1)
                     {
                         page = 1;
                     }
                 }
                 if (Request.QueryString["size"] != null)
                 {
                     size = int.Parse(Request.QueryString["size"].ToString());
                     if (size > 40 || size < 10)
                     {
                         size = 30;
                     }
                 }
             }
             catch
             {
             }
             Products = (CDynamicViewProduct)Session["ssadvancesearchpro"];
             Products.SetPageSize(size);
             Products.SetCurrentPage(page);
         }
         else
         {
             string where = "";
             string brand     = "";
             float  price1    = 0;
             float  price2    = 0;
             string cpu       = "";
             string hdd       = "";
             string ram       = "";
             string screen    = "";
             string color     = "";
             string txtsearch = "";
             string urlPage   = Request.RawUrl;
             if (Request.QueryString["brand"] != null)
             {
                 brand = Request.QueryString["brand"].ToString();
                 if (brand.Length > 0)
                 {
                     where += " and idbrand=" + brand;
                 }
             }
             if (Request.QueryString["price1"] != null)
             {
                 try
                 {
                     price1 = float.Parse(Request.QueryString["price1"].ToString());
                     if (Application["currency"].Equals("VND"))
                     {
                         price1 = price1 * 1000000;
                         price1 = price1 / (float)Application["ratepromain"];
                     }
                 }
                 catch
                 {
                 }
                 if (price1 > 0)
                 {
                     where += " and SellingPrice>=" + price1;
                 }
             }
             if (Request.QueryString["price2"] != null)
             {
                 try
                 {
                     price2 = float.Parse(Request.QueryString["price2"].ToString());
                     if (Application["currency"].Equals("VND"))
                     {
                         price2 = price2 * 1000000;
                         price2 = price2 / (float)Application["ratepromain"];
                     }
                 }
                 catch
                 { }
                 if (price2 > 0)
                 {
                     where += " and SellingPrice<=" + price2;
                 }
             }
             if (Request.QueryString["cpu"] != null)
             {
                 cpu = Request.QueryString["cpu"].ToString();
                 string[] arrvalue = cpu.Split(',');
                 int      num      = arrvalue.Length;
                 if (num > 7)
                 {
                     num = 7;
                 }
                 string sub = "";
                 for (int i = 0; i < num - 1; i++)
                 {
                     if (arrvalue[i].Length > 0)
                     {
                         sub += "note like '%" + arrvalue[i] + " ghz%' or ";
                     }
                 }
                 if (arrvalue[num - 1].Length > 0)
                 {
                     sub += "note like '%" + arrvalue[num - 1] + " ghz%'";
                 }
                 if (sub.Length > 0)
                 {
                     where += " and (" + sub + ")";
                 }
             }
             if (Request.QueryString["hdd"] != null)
             {
                 hdd = Request.QueryString["hdd"].ToString();
                 string[] arrvalue = hdd.Split(',');
                 int      num      = arrvalue.Length;
                 if (num > 7)
                 {
                     num = 7;
                 }
                 string sub = "";
                 for (int i = 0; i < num - 1; i++)
                 {
                     if (arrvalue[i].Length > 0)
                     {
                         sub += "note like '%" + arrvalue[i] + " gb%' or ";
                     }
                 }
                 if (arrvalue[num - 1].Length > 0)
                 {
                     sub += "note like '%" + arrvalue[num - 1] + " gb%'";
                 }
                 if (sub.Length > 0)
                 {
                     where += " and (" + sub + ")";
                 }
             }
             if (Request.QueryString["ram"] != null)
             {
                 ram = Request.QueryString["ram"].ToString();
                 string[] arrvalue = ram.Split(',');
                 int      num      = arrvalue.Length;
                 if (num > 7)
                 {
                     num = 7;
                 }
                 string sub = "";
                 for (int i = 0; i < num - 1; i++)
                 {
                     if (arrvalue[i].Length > 0)
                     {
                         sub += "note like '%, " + arrvalue[i] + " mb%' or ";
                     }
                 }
                 if (arrvalue[num - 1].Length > 0)
                 {
                     sub += "note like '%, " + arrvalue[num - 1] + " mb%'";
                 }
                 if (sub.Length > 0)
                 {
                     where += " and (" + sub + ")";
                 }
             }
             if (Request.QueryString["screen"] != null)
             {
                 screen = Request.QueryString["screen"].ToString();
                 string[] arrvalue = screen.Split(',');
                 int      num      = arrvalue.Length;
                 if (num > 7)
                 {
                     num = 7;
                 }
                 string sub = "";
                 for (int i = 0; i < num - 1; i++)
                 {
                     if (arrvalue[i].Length > 0)
                     {
                         sub += "note like '%" + arrvalue[i] + "\"%' or ";
                     }
                 }
                 if (arrvalue[num - 1].Length > 0)
                 {
                     sub += "note like '%" + arrvalue[num - 1] + "\"%'";
                 }
                 if (sub.Length > 0)
                 {
                     where += " and (" + sub + ")";
                 }
             }
             if (Request.QueryString["color"] != null)
             {
                 color = Request.QueryString["color"].ToString();
                 string[] arrvalue = color.Split(',');
                 int      num      = arrvalue.Length;
                 if (num > 7)
                 {
                     num = 7;
                 }
                 string sub = "";
                 for (int i = 0; i < num - 1; i++)
                 {
                     if (arrvalue[i].Length > 0)
                     {
                         sub += "note like N'%" + arrvalue[i] + "%' or ";
                     }
                 }
                 if (arrvalue[num - 1].Length > 0)
                 {
                     sub += "note like N'%" + arrvalue[num - 1] + "%'";
                 }
                 if (sub.Length > 0)
                 {
                     where += " and (" + sub + ")";
                 }
             }
             if (Request.QueryString["text"] != null)
             {
                 txtsearch = Request.QueryString["text"].ToString();
                 txtsearch = txtsearch.Replace("\"", "");
                 txtsearch = txtsearch.Replace("'", "");
                 if (txtsearch.Length > 0)
                 {
                     if (brand.Length > 0)
                     {
                         where += " and (Name like N'%" + txtsearch + "%' or note like N'%" + txtsearch + "%')";
                     }
                     else
                     {
                         where += " and (Name like N'%" + txtsearch + "%' or brand like N'%" + txtsearch + "%' or note like N'%" + txtsearch + "%')";
                     }
                 }
             }
             //strProduct = where;
             Products.SetPageSize(size);
             Products.SetIdType((int)Application["idtypeproduct"]);
             Products.SetAdvance(where);
             Products.SetWhere();
             Products.SetNumAdvanceSearch();
             Products.SetCurrentPage();
             Session["ssadvancesearchpro"] = Products;
         }
         blSearchPro = string.Format(blSearchPro, "<u>" + Products.GetNumberRecord() + "</u>");
         Product_data product = Products.ProductAdvanceSearchFromTo();
         DataTable    table   = product.Tables[Product_data._table];
         int          numPro  = table.Rows.Count;
         Boolean      iseven  = true;
         if (Products.GetPages() > 1)
         {
             strpage1 = CreatePage(Products.GetCurrentPage(), Products.GetPages(), Products.GetPageSize(), 1);
             strpage2 = CreatePage(Products.GetCurrentPage(), Products.GetPages(), Products.GetPageSize(), 2);
         }
         else if (Products.GetPages() == 1)
         {
             strpage1 = ButtonCompare(true);
             strpage2 = ButtonCompare(false);
         }
         strproduct  = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
         strproduct += "<tr height='5'><td colspan='3'></td></tr>";
         string    id        = "";
         string    name      = "";
         string    url       = "";
         string    price     = "";
         string    warranty  = "";
         Boolean   istest    = false;
         ArrayList list      = new ArrayList();
         float     rate      = (float)Application["ratepromain"];
         float     price11   = 1;
         string    substring = "";
         string    madein    = "";
         string    isspec    = "";
         if (Products.GetCurrentPage() == 1)
         {
             istest = true;
         }
         for (int i = 0; i < numPro; i++)
         {
             id   = table.Rows[i][Product_data._id].ToString();
             name = table.Rows[i][Product_data._name].ToString() + " " + table.Rows[i][Product_data._state].ToString();
             url  = table.Rows[i][Product_data._urlImage].ToString();
             if (url.Length > 0)
             {
                 url = "image/img_pro/" + url;
             }
             else
             {
                 url = "image/common/notimgpro.png";
             }
             //price = table.Rows[i][Product_data._price].ToString();
             price11  = float.Parse(table.Rows[i][Product_data._price].ToString());
             price11  = price11 * rate;
             price    = price11.ToString("N").Split('.')[0];
             warranty = table.Rows[i][Product_data._WarrantyMonth].ToString();
             madein   = table.Rows[i][Product_data._shortnote].ToString();
             isspec   = table.Rows[i][Product_data._ispec].ToString();
             if (istest == true && price.Equals("0"))
             {
                 substring  = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                 substring += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                 if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                 {
                     substring += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                 }
                 substring += "<a href='?menu=dp&id=" + id + "'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                 substring += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                 substring += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                 substring += tupdate + "</span><br />";
                 substring += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                 if (madein.Length > 0)
                 {
                     substring += "<br /><span class='text_title'>" + madein + "</span>";
                 }
                 substring += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                 //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                 substring += "</table>";
                 list.Add(substring);
                 continue;
             }
             if (iseven)
             {
                 if (isspec.Equals("1"))
                 {
                     strproduct += "<tr><td width='278' class='cl1'>";
                 }
                 else
                 {
                     strproduct += "<tr><td width='278'>";
                 }
                 strproduct += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                 strproduct += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                 if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                 {
                     strproduct += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                 }
                 strproduct += "<a href='?menu=dp&id=" + id + "'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                 strproduct += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                 strproduct += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                 if (price.Equals("0"))
                 {
                     strproduct += tupdate + "</span><br />";
                 }
                 else
                 {
                     strproduct += price + " " + unitPrice + "</span><br />";
                 }
                 strproduct += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                 if (madein.Length > 0)
                 {
                     strproduct += "<br /><span class='text_title'>" + madein + "</span>";
                 }
                 strproduct += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                 //strproduct += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                 strproduct += "</table></td>";
                 strproduct += "<td class='bg_line4'></td>";
                 iseven      = false;
                 if (i + 1 == numPro)
                 {
                     if (list.Count == 0)
                     {
                         strproduct += "<td width='278'>&nbsp;</td>";
                         strproduct += "</tr>";
                     }
                 }
             }
             else
             {
                 if (isspec.Equals("1"))
                 {
                     strproduct += "<td width='278' class='cl1'>";
                 }
                 else
                 {
                     strproduct += "<td width='278'>";
                 }
                 strproduct += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                 strproduct += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                 if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                 {
                     strproduct += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                 }
                 strproduct += "<a href='?menu=dp&id=" + id + "'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                 strproduct += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                 strproduct += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                 if (price.Equals("0"))
                 {
                     strproduct += tupdate + "</span><br />";
                 }
                 else
                 {
                     strproduct += price + " " + unitPrice + "</span><br />";
                 }
                 strproduct += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                 if (madein.Length > 0)
                 {
                     strproduct += "<br /><span class='text_title'>" + madein + "</span>";
                 }
                 strproduct += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                 //strproduct += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                 strproduct += "</table></td></tr>";
                 if (i + 1 < numPro)
                 {
                     strproduct += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
                 }
                 iseven = true;
             }
         }
         int numpro = list.Count;
         for (int i = 0; i < numpro; i++)
         {
             if (iseven)
             {
                 strproduct += "<tr><td width='278'>";
                 strproduct += list[i].ToString();
                 strproduct += "</td><td class='bg_line4'></td>";
                 iseven      = false;
                 if (i + 1 == numpro)
                 {
                     strproduct += "<td width='278'>&nbsp;</td>";
                     strproduct += "</tr>";
                 }
             }
             else
             {
                 strproduct += "<td width='278'>";
                 strproduct += list[i].ToString();
                 strproduct += "</td></tr>";
                 if (i + 1 < numPro)
                 {
                     strproduct += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
                 }
                 iseven = true;
             }
         }
         strproduct += "<tr height='5'><td colspan='3'></td></tr>";
         strproduct += "</table>";
     }
     catch
     {
     }
 }
Пример #4
0
    public string ShowProductWithBrand()
    {
        CDynamicViewProduct ViewProduct;
        int    currentpage = 0;
        int    size        = 30;
        int    idBrand     = 0;
        string nameBrand   = "";

        try
        {
            idBrand     = int.Parse(Request.QueryString["brand"].ToString());
            currentpage = int.Parse(Request.QueryString["page"].ToString());
            size        = int.Parse(Request.QueryString["size"].ToString());
            if (size > 40 || size < 10)
            {
                size = 30;
            }
        }
        catch
        {
        }
        if (Session["SSMobileBrand"] != null)
        {
            ViewProduct = (CDynamicViewProduct)Session["SSMobileBrand"];
            ViewProduct.SetPageSize(size);
            if (idBrand != ViewProduct.GetIdBrand())
            {
                ViewProduct.SetIdBrand(idBrand);
                ViewProduct.SetNumProductWithBrand();
            }
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetNumProductWithBrand();
                ViewProduct.SetCurrentPage();
            }
        }
        else
        {
            ViewProduct = new CDynamicViewProduct();
            ViewProduct.SetIdType((int)Application["idtypemobile"]);
            ViewProduct.SetIdBrand(idBrand);
            ViewProduct.SetNumProductWithBrand();
            ViewProduct.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetCurrentPage();
            }
            Session["SSMobileBrand"] = ViewProduct;
        }
        nameBrand = ViewProduct.GetNameBrand();
        if (nameBrand.Length > 0)
        {
            tCurrentAccess += " &raquo; " + nameBrand;
        }
        blpro = string.Format(blpro, "<u>" + ViewProduct.GetNumberRecord() + "</u>");
        Product_data product = ViewProduct.ProductWithBrandFromTo();
        DataTable    table   = product.Tables[Product_data._table];
        int          numPro  = table.Rows.Count;
        Boolean      iseven  = true;

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

        if (numPro > 0)
        {
            strAdvertise = GetAdvertiseWithBrand(idBrand.ToString());
            strProMain   = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
            string    id        = "";
            string    name      = "";
            string    url       = "";
            string    price     = "";
            string    warranty  = "";
            float     rate      = (float)Application["ratepromobi"];
            float     price1    = 1;
            Boolean   istest    = false;
            ArrayList list      = new ArrayList();
            string    substring = "";
            string    madein    = "";
            string    isSpec    = "";
            if (ViewProduct.GetCurrentPage() == 1)
            {
                istest = true;
            }
            for (int i = 0; i < numPro; i++)
            {
                id   = table.Rows[i][Product_data._id].ToString();
                name = table.Rows[i][Product_data._name].ToString() + " " + table.Rows[i][Product_data._state].ToString();
                url  = table.Rows[i][Product_data._urlImage].ToString();
                if (url.Length > 0)
                {
                    url = "image/img_pro/" + url;
                }
                else
                {
                    url = "image/common/notimgpro.png";
                }
                //price = table.Rows[i][Product_data._price].ToString();
                price1   = float.Parse(table.Rows[i][Product_data._price].ToString());
                price1   = price1 * rate;
                price    = price1.ToString("N").Split('.')[0];
                warranty = table.Rows[i][Product_data._WarrantyMonth].ToString();
                madein   = table.Rows[i][Product_data._shortnote].ToString();
                isSpec   = table.Rows[i][Product_data._ispec].ToString();
                if (istest == true && price.Equals("0"))
                {
                    substring  = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                    substring += "<tr><td rowspan='2' width='95' align='center'>";
                    substring += "<a href='?menu=dp&id=" + id + "'><img class='img2' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                    substring += "<td class='txt2' colspan='2'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                    substring += "<tr valign='top'><td width='159'>" + tprice + ": <span class='txt4'>";
                    substring += tupdate + "</span><br />";
                    substring += twarranty + ": <span class='txt4'>" + warranty + " " + tmonth + "</span><br />";
                    if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                    {
                        substring += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                    }
                    substring += "</td><td width='25'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                    substring += "</table>";
                    list.Add(substring);
                    continue;
                }
                if (iseven)
                {
                    if (isSpec.Equals("1"))
                    {
                        strProMain += "<tr><td width='279' class='bgcl8'>";
                    }
                    else
                    {
                        strProMain += "<tr><td width='279'>";
                    }
                    strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                    strProMain += "<tr><td rowspan='2' width='95' align='center'>";
                    strProMain += "<a href='?menu=dp&id=" + id + "'><img class='img2' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                    strProMain += "<td class='txt2' colspan='2'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                    strProMain += "<tr valign='top'><td width='159'>" + tprice + ": <span class='txt4'>";
                    if (price.Equals("0"))
                    {
                        strProMain += tupdate + "</span><br />";
                    }
                    else
                    {
                        strProMain += price + " " + unitPrice + "</span><br />";
                    }
                    strProMain += twarranty + ": <span class='txt4'>" + warranty + " " + tmonth + "</span><br />";
                    if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                    {
                        strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                    }
                    strProMain += "</td><td width='25'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                    //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                    strProMain += "</table></td>";
                    strProMain += "<td class='line2'></td>";
                    iseven      = false;
                    if (i + 1 == numPro)
                    {
                        if (list.Count == 0)
                        {
                            strProMain += "<td width='279'>&nbsp;</td>";
                            strProMain += "</tr>";
                        }
                    }
                }
                else
                {
                    if (isSpec.Equals("1"))
                    {
                        strProMain += "<td width='279' class='bgcl8'>";
                    }
                    else
                    {
                        strProMain += "<td width='279'>";
                    }
                    strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                    strProMain += "<tr><td rowspan='2' width='95' align='center'>";
                    strProMain += "<a href='?menu=dp&id=" + id + "'><img class='img2' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                    strProMain += "<td class='txt2' colspan='2'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                    strProMain += "<tr valign='top'><td width='159'>" + tprice + ": <span class='txt4'>";
                    if (price.Equals("0"))
                    {
                        strProMain += tupdate + "</span><br />";
                    }
                    else
                    {
                        strProMain += price + " " + unitPrice + "</span><br />";
                    }
                    strProMain += twarranty + ": <span class='txt4'>" + warranty + " " + tmonth + "</span><br />";
                    if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                    {
                        strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                    }
                    strProMain += "</td><td width='25'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                    //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                    strProMain += "</table></td></tr>";
                    if (i + 1 < numPro)
                    {
                        strProMain += "<tr><td class='line1'></td><td></td><td class='line1'></td></tr>";
                    }
                    iseven = true;
                }
            }
            int numpro = list.Count;
            for (int i = 0; i < numpro; i++)
            {
                if (iseven)
                {
                    strProMain += "<tr><td width='279'>";
                    strProMain += list[i].ToString();
                    strProMain += "</td><td class='line2'></td>";
                    iseven      = false;
                    if (i + 1 == numpro)
                    {
                        strProMain += "<td width='279'>&nbsp;</td>";
                        strProMain += "</tr>";
                    }
                }
                else
                {
                    strProMain += "<td width='279'>";
                    strProMain += list[i].ToString();
                    strProMain += "</td></tr>";
                    if (i + 1 < numPro)
                    {
                        strProMain += "<tr><td class='line1'></td><td></td><td class='line1'></td></tr>";
                    }
                    iseven = true;
                }
            }
            strProMain += "</table>";
        }
        else
        {
            strProMain = tnotpro;
        }
        return(strProMain);
    }
    public string ShowProductSearch()
    {
        CDynamicViewProduct ViewSearch;
        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
        {
        }
        try
        {
            text = Request.QueryString["text"].ToString();
            text = text.Replace('"', ' ');
            text = text.Trim();
            if (text.Length > 0)
            {
                if (text.Length > 30)
                {
                    text = text.Substring(0, 30);
                }
            }
        }
        catch
        {
            Response.Redirect("?menu=product");
        }
        if (Session["SSQSProduct"] == null)
        {
            ViewSearch = new CDynamicViewProduct();
            ViewSearch.SetTextSearch(text);
            ViewSearch.SetIdType((int)Application["idtypeproduct"]);
            ViewSearch.BuildWhere();
            ViewSearch.SetNumQuickSearch();
            ViewSearch.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewSearch.SetCurrentPage(currentpage);
            }
            else
            {
                ViewSearch.SetCurrentPage();
            }
            Session["SSQSProduct"] = ViewSearch;
        }
        else
        {
            ViewSearch = (CDynamicViewProduct)Session["SSQSProduct"];
            ViewSearch.SetPageSize(size);
            if (!text.Equals(ViewSearch.GetTextSearch()))
            {
                ViewSearch.SetTextSearch(text);
                ViewSearch.BuildWhere();
                ViewSearch.SetNumQuickSearch();
            }
            if (currentpage > 0)
            {
                ViewSearch.SetCurrentPage(currentpage);
            }
            else
            {
                ViewSearch.SetCurrentPage();
            }
        }
        blpro = string.Format(blpro, ViewSearch.GetNumberRecord());
        Product_data product = ViewSearch.ProductQuickSearchFromTo();
        DataTable    table   = product.Tables[Product_data._table];
        int          numPro  = table.Rows.Count;
        Boolean      iseven  = true;

        if (ViewSearch.GetPages() > 1)
        {
            strpage1 = CreatePage(ViewSearch.GetCurrentPage(), ViewSearch.GetPages(), ViewSearch.GetPageSize(), 1);
            strpage2 = CreatePage(ViewSearch.GetCurrentPage(), ViewSearch.GetPages(), ViewSearch.GetPageSize(), 2);
        }
        else if (ViewSearch.GetPages() == 1)
        {
            strpage1 = ButtonCompare(true);
            strpage2 = ButtonCompare(false);
        }
        string strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";

        strProMain += "<tr height='5'><td colspan='3'></td></tr>";
        string id       = "";
        string name     = "";
        string url      = "";
        string price    = "";
        string warranty = "";

        for (int i = 0; i < numPro; i++)
        {
            id   = table.Rows[i][Product_data._id].ToString();
            name = table.Rows[i][Product_data._name].ToString();
            url  = table.Rows[i][Product_data._urlImage].ToString();
            if (url.Length > 0)
            {
                url = "image/img_pro/" + url;
            }
            else
            {
                url = "image/common/notimgpro.png";
            }
            price    = table.Rows[i][Product_data._price].ToString();
            warranty = table.Rows[i][Product_data._WarrantyMonth].ToString();
            if (iseven)
            {
                strProMain += "<tr><td width='272'>";
                strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                strProMain += "<tr><td rowspan='2' width='100' height='90' align='center'>";
                if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                {
                    strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                }
                strProMain += "<a href='?menu=dp&id=" + id + "'><img class='border_img' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                strProMain += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                strProMain += "<tr><td>" + tprice + ": <span class='price'>" + price + " " + unitPrice + "</span><br />" + twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                strProMain += "</td><td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                strProMain += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                strProMain += "</table></td>";
                iseven      = false;
                if (i + 1 == numPro)
                {
                    strProMain += "<td class='bg_line4' width='11'></td>";
                    strProMain += "<td width='272'>&nbsp;</td>";
                    strProMain += "</tr>";
                }
            }
            else
            {
                strProMain += "<td class='bg_line4' width='11'></td>";
                strProMain += "<td width='272'>";
                strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                strProMain += "<tr><td rowspan='2' width='100' height='90' align='center'>";
                if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                {
                    strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                }
                strProMain += "<a href='?menu=dp&id=" + id + "'><img class='border_img' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                strProMain += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dp&id=" + id + "' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                strProMain += "<tr><td>" + tprice + ": <span class='price'>" + price + " " + unitPrice + "</span><br />" + twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                strProMain += "</td><td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                strProMain += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                strProMain += "</table></td></tr>";
                if (i + 1 < numPro)
                {
                    strProMain += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
                }
                iseven = true;
            }
        }
        if (numPro == 0)
        {
            strProMain += "<tr><td colspan='3' align='center'>" + tnotpro + "</td></tr>";
        }
        strProMain += "<tr height='5'><td colspan='3'></td></tr>";
        strProMain += "</table>";
        return(strProMain);
    }
Пример #6
0
    public string ShowProductAll()
    {
        CDynamicViewProduct ViewProduct;
        int currentpage = 0;
        int size        = 30;

        try
        {
            currentpage = int.Parse(Request.QueryString["page"].ToString());
            size        = int.Parse(Request.QueryString["size"].ToString());
            if (size > 40 || size < 10)
            {
                size = 30;
            }
        }
        catch
        {
        }
        if (Session["SSProductWillHave"] != null)
        {
            ViewProduct = (CDynamicViewProduct)Session["SSProductWillHave"];
            ViewProduct.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetNumWillHave();
                ViewProduct.SetCurrentPage();
            }
        }
        else
        {
            ViewProduct = new CDynamicViewProduct();
            ViewProduct.SetIdType((int)Application["idtypeproduct"]);
            ViewProduct.SetNumWillHave();
            ViewProduct.SetPageSize(size);
            if (currentpage > 0)
            {
                ViewProduct.SetCurrentPage(currentpage);
            }
            else
            {
                ViewProduct.SetCurrentPage();
            }
            Session["SSProductWillHave"] = ViewProduct;
        }
        blpro = string.Format(blpro, "<u>" + ViewProduct.GetNumberRecord() + "</u>");
        Product_data product = ViewProduct.ProductWillHaveFromTo();
        DataTable    table   = product.Tables[Product_data._table];
        int          numPro  = table.Rows.Count;
        Boolean      iseven  = true;

        if (ViewProduct.GetPages() > 1)
        {
            strpage1 = CreatePage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 1);
            strpage2 = CreatePage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 2);
        }
        else if (ViewProduct.GetPages() == 1)
        {
            strpage1 = ButtonCompare(true);
            strpage2 = ButtonCompare(false);
        }
        string strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";

        strProMain += "<tr height='5'><td colspan='3'></td></tr>";
        string    id        = "";
        string    name      = "";
        string    url       = "";
        string    price     = "";
        string    warranty  = "";
        Boolean   istest    = false;
        ArrayList list      = new ArrayList();
        string    substring = "";
        float     rate      = (float)Application["ratepromain"];
        float     price1    = 1;
        string    price2    = "";

        if (ViewProduct.GetCurrentPage() == 1)
        {
            istest = true;
        }
        for (int i = 0; i < numPro; i++)
        {
            id   = table.Rows[i][Product_data._id].ToString();
            name = table.Rows[i][Product_data._name].ToString() + " " + table.Rows[i][Product_data._state].ToString();
            url  = table.Rows[i][Product_data._urlImage].ToString();
            string namepro = table.Rows[i][Product_data._name].ToString();
            namepro = namepro.Replace("/", "");
            namepro = namepro.Replace("#", "");
            if (url.Length > 0)
            {
                url = "image/img_pro/" + url;
            }
            else
            {
                url = "image/common/notimgpro.png";
            }
            price2   = table.Rows[i][Product_data._price].ToString();
            price1   = float.Parse(table.Rows[i][Product_data._price].ToString());
            price1   = price1 * rate;
            price    = price1.ToString("N").Split('.')[0];
            warranty = table.Rows[i][Product_data._WarrantyMonth].ToString();
            if (istest == true && price.Equals("0"))
            {
                substring  = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                substring += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                {
                    substring += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                }
                substring += "<a href='" + namepro + "-dp-" + id + ".html'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                substring += "<td colspan='2' valign='top' class='text_title'><a href='" + namepro + "-dp-" + id + ".html' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                substring += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                substring += tupdate + "</span><br />";
                substring += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                substring += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                substring += "</table>";
                list.Add(substring);
                continue;
            }
            if (iseven)
            {
                strProMain += "<tr><td width='278'>";
                strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                strProMain += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                {
                    strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                }
                strProMain += "<a href='" + namepro + "-dp-" + id + ".html'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                strProMain += "<td colspan='2' valign='top' class='text_title'><a href='" + namepro + "-dp-" + id + ".html' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                strProMain += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                if (price.Equals("0"))
                {
                    strProMain += tupdate + "</span><br />";
                }
                else
                {
                    if (unitPrice.Equals("$"))
                    {
                        strProMain += price + " VND</span><br />";
                        strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + "</span><br />";
                    }
                    else if (unitPrice.Equals("$$"))
                    {
                        strProMain += price + " VND</span><br />";
                        strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + " USD</span><br />";
                    }
                    else
                    {
                        strProMain += price + " " + unitPrice + "</span><br />";
                    }
                }
                strProMain += "<span class='tvat'>" + strMVAT + "</span><br />";
                strProMain += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                strProMain += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                strProMain += "</table></td>";
                strProMain += "<td class='bg_line4'></td>";
                iseven      = false;
                if (i + 1 == numPro)
                {
                    if (list.Count == 0)
                    {
                        strProMain += "<td width='278'>&nbsp;</td>";
                        strProMain += "</tr>";
                    }
                }
            }
            else
            {
                strProMain += "<td width='278'>";
                strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
                strProMain += "<tr><td rowspan='2' width='88' align='center' valign='top'>";
                if (table.Rows[i][Product_data._ispromotion].ToString().Length > 0)
                {
                    strProMain += "<img src='image/common/khuyenmai.gif' style='cursor:pointer;' onmouseover='showDivMessage(2," + id + "," + i + ",event);' onmouseout='OnMOut(event)'/><br />";
                }
                strProMain += "<a href='" + namepro + "-dp-" + id + ".html'><img class='img1' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)' src='" + url + "'/></a></td>";
                strProMain += "<td colspan='2' valign='top' class='text_title'><a href='" + namepro + "-dp-" + id + ".html' onmouseover='showDivMessage(1," + id + "," + i + ",event);' onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
                strProMain += "<tr><td valign='middle' width='165' height='48'>" + tprice + ": <span class='price'>";
                if (price.Equals("0"))
                {
                    strProMain += tupdate + "</span><br />";
                }
                else
                {
                    if (unitPrice.Equals("$"))
                    {
                        strProMain += price + " VND</span><br />";
                        strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + "</span><br />";
                    }
                    else if (unitPrice.Equals("$$"))
                    {
                        strProMain += price + " VND</span><br />";
                        strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + " USD</span><br />";
                    }
                    else
                    {
                        strProMain += price + " " + unitPrice + "</span><br />";
                    }
                }
                strProMain += "<span class='tvat'>" + strMVAT + "</span><br />";
                strProMain += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span>";
                strProMain += "</td><td width='25' align='right'><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
                //strProMain += "<tr><td colspan='3' align='center' height='32'><div class='button3' onclick='AddCart(" + id + ",1);'>" + torder + "</div></td></tr>";
                strProMain += "</table></td></tr>";
                if (i + 1 < numPro)
                {
                    strProMain += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
                }
                iseven = true;
            }
        }
        int numpro = list.Count;

        for (int i = 0; i < numpro; i++)
        {
            if (iseven)
            {
                strProMain += "<tr><td width='278'>";
                strProMain += list[i].ToString();
                strProMain += "</td><td class='bg_line4'></td>";
                iseven      = false;
                if (i + 1 == numpro)
                {
                    strProMain += "<td width='278'>&nbsp;</td>";
                    strProMain += "</tr>";
                }
            }
            else
            {
                strProMain += "<td width='278'>";
                strProMain += list[i].ToString();
                strProMain += "</td></tr>";
                if (i + 1 < numPro)
                {
                    strProMain += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
                }
                iseven = true;
            }
        }
        strProMain += "<tr height='5'><td colspan='3'></td></tr>";
        strProMain += "</table>";
        return(strProMain);
    }
 public Task RemoveAsync(Product_data product_Data)
 {
     _context.Remove(product_Data);
     return(_context.SaveChangesAsync());
 }
 public Task ModifiedAsync(Product_data product_Data)
 {
     _context.Entry(product_Data).State = EntityState.Modified;
     return(_context.SaveChangesAsync());
 }
 public Task AddAsync(Product_data product_Data)
 {
     _context.Product_datas.AddAsync(product_Data);
     return(_context.SaveChangesAsync());
 }