public void ShowProduct()
{
int page = 1;
string text = "-1";
string state = "";
try
{
if (Request.QueryString["page"] != null)
{
page = int.Parse(Request.QueryString["page"].ToString());
}
if (Request.QueryString["search"] != null)
{
text = Request.QueryString["search"].ToString();
}
if (Request.QueryString["state"] != null)
{
state = Request.QueryString["state"].ToString();
}
if (Request.QueryString["viewall"] != null)
{
page = 1;
text = "";
}
}
catch
{
}
CDynamicViewProduct ViewProduct = new CDynamicViewProduct();
if (Session["SSListProduct"] == null)
{
ViewProduct.SetPageSize(10);
ViewProduct.SetIdType(int.Parse(Application["idtypeproduct"].ToString()));
if (text.Equals("-1"))
{
ViewProduct.BuildWhere();
}
else
{
ViewProduct.SetTextSearch(text);
ViewProduct.SetHasImage(state);
ViewProduct.BuildWhereAdminSearch();
}
ViewProduct.SetNumQuickSearch();
ViewProduct.SetCurrentPage(page);
Session["SSListProduct"] = ViewProduct;
}
else
{
ViewProduct = (CDynamicViewProduct)Session["SSListProduct"];
if (text.Equals("-1"))
{
//ViewProduct.BuildWhere();
}
else
{
ViewProduct.SetTextSearch(text);
ViewProduct.SetHasImage(state);
ViewProduct.BuildWhereAdminSearch();
}
ViewProduct.SetNumQuickSearch();
ViewProduct.SetCurrentPage(page);
}
if (ViewProduct.GetPages() > 1)
{
BuildPage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages());
}
DataSet ds = ViewProduct.ProductUploadImageFromTo();
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ả 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><a href='?menu=updateDes&back=imgpro&id=" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + "'>" + ds.Tables[0].Rows[i - 1]["Name"].ToString() + "</a></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_pro/" + 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>";
string strdes = "";
strdes = ds.Tables[0].Rows[i - 1]["Des"].ToString();
if (strdes.Length > 0)
{
strdes = "Phần thông tin mô tả thêm đã được cập nhật";
}
strlist += "<td align='left'>" + strdes + "</td>";
strlist += "</tr>";
}
strlist += "</table>";
}
