public void ShowProduct()
{
int page = 1;
string text = "-1";
string hasImage = "";
try
{
page = int.Parse(Request.QueryString["page"].ToString());
}
catch
{
try
{
text = Request.QueryString["search"].ToString();
hasImage = Request.QueryString["img"].ToString();
}
catch
{
text = "";
hasImage = "";
}
}
CdymanicViewCom ViewProduct = new CdymanicViewCom();
if (Session["SSListComponent"] == null)
{
ViewProduct.SetPageSize(10);
ViewProduct.SetIdType(int.Parse(Application["idtypeproduct"].ToString()));
if (text.Equals("-1"))
{
ViewProduct.BuildWhere();
}
else
{
ViewProduct.SetTextSearch(text);
ViewProduct.SetHasImage(hasImage);
ViewProduct.BuildWhereAdminSearch();
}
ViewProduct.SetNumComQuickSearch();
ViewProduct.SetCurrentPage(page);
Session["SSListComponent"] = ViewProduct;
}
else
{
ViewProduct = (CdymanicViewCom)Session["SSListComponent"];
if (text.Equals("-1"))
{
//ViewProduct.BuildWhere();
}
else
{
ViewProduct.SetTextSearch(text);
ViewProduct.SetHasImage(hasImage);
ViewProduct.BuildWhereAdminSearch();
}
ViewProduct.SetNumComQuickSearch();
ViewProduct.SetCurrentPage(page);
}
if (ViewProduct.GetPages() > 1)
{
BuildPage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages());
}
DataSet ds = ViewProduct.ComponentQuickSearchFromTo();
if (ds.Tables.Count == 0)
{
strlist = "Lỗi kết nối SQL. Không thể hiển thị dữ liệu";
return;
}
int num = ds.Tables[0].Rows.Count;
strlist = "<table border='1' cellpadding='1' cellspacing='0' width='100%' bordercolor='#DFDFDF' style='border-collapse:collapse;'>";
strlist += "<tr class='tlist'><td width='30'>STT</td><td width='50'>Mã SP</td><td width='95'>Tên sản phẩm</td><td width='60'>Nhãn hiệu</td><td width='70'>Ảnh sản phẩm</td><td width='55'>Giá bán</td><td>Mô tản sản phẩm</td></tr>";
for (int i = 1; i <= num; i++)
{
//Id,Name,UrlImage,SellingPrice,WarrantyMonth
strlist += "<tr>";
strlist += "<td align='center'>" + i + "</td>";
strlist += "<td align='center'>" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + "</td>";
strlist += "<td>" + ds.Tables[0].Rows[i - 1]["Name"].ToString() + "</td>";
strlist += "<td align='center'>" + ds.Tables[0].Rows[i - 1]["brand"].ToString() + "</td>";
string nameImage = ds.Tables[0].Rows[i - 1]["UrlImage"].ToString();
string url = nameImage;
if (nameImage.Length == 0)
{
nameImage = "noimage";
}
if (url.Length > 0)
{
url = "<img class='imgpro' src='../image/img_com/" + url + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + nameImage + "','" + ds.Tables[0].Rows[i - 1]["Name"].ToString() + "');\" />";
}
else
{
url = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + nameImage + "','" + ds.Tables[0].Rows[i - 1]["Name"].ToString() + "');\" />";
}
strlist += "<td align='center'>" + url + "</td>";
strlist += "<td align='center'>" + ds.Tables[0].Rows[i - 1]["SellingPrice"].ToString() + "</td>";
strlist += "<td align='left'>" + ds.Tables[0].Rows[i - 1]["Note"].ToString() + "</td>";
strlist += "</tr>";
}
strlist += "</table>";
}
