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() + "," + Application["idtypemobile"].ToString()
+ ") and Cansales = 1 AND ProductTypeId IN (SELECT Id FROM tbl_ProductType WHERE 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;
}
