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
{
}
try
{
CDynamicViewProduct ViewProduct = new CDynamicViewProduct();
if (Session["SSListmultiImgPro"] == 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.BuildWhereMultiImg();
}
ViewProduct.SetNumMultiImg();
ViewProduct.SetCurrentPage(page);
Session["SSListmultiImgPro"] = ViewProduct;
}
else
{
ViewProduct = (CDynamicViewProduct)Session["SSListmultiImgPro"];
if (text.Equals("-1"))
{
//ViewProduct.BuildWhere();
}
else
{
ViewProduct.SetTextSearch(text);
ViewProduct.SetHasImage(state);
ViewProduct.BuildWhereMultiImg();
}
ViewProduct.SetNumMultiImg();
ViewProduct.SetCurrentPage(page);
}
if (ViewProduct.GetPages() > 1)
{
BuildPage(ViewProduct.GetCurrentPage(), ViewProduct.GetPages());
}
DataSet ds = ViewProduct.ProductMultiImgFromTo();
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='70'>Ảnh 1</td><td width='70'>Ảnh 2</td><td width='70'>Ảnh 3</td><td width='70'>Ảnh 4</td><td width='70'>Ảnh 5</td><td width='70'>Quảng cáo thêm</td><td width='50'>Mã SP</td><td width='70'>Tên sản phẩm</td><td width='70'>Giá bán</td></tr>";
for (int i = 1; i <= num; i++)
{
//Id,Name,UrlImage,SellingPrice,WarrantyMonth
strlist += "<tr>";
//strlist += "<td align='center'>" + ds.Tables[0].Rows[i - 1]["brand"].ToString() + "</td>";
string img1 = ds.Tables[0].Rows[i - 1]["img1"].ToString();
if (img1.Length > 0)
{
img1 = "<img class='imgpro' src='../image/multiimg/" + img1 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img1 + "','1');\" />";
}
else
{
img1 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img1 + "','1');\" />";
}
string img2 = ds.Tables[0].Rows[i - 1]["img2"].ToString();
if (img2.Length > 0)
{
img2 = "<img class='imgpro' src='../image/multiimg/" + img2 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img2 + "','2');\" />";
}
else
{
img2 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img2 + "','2');\" />";
}
string img3 = ds.Tables[0].Rows[i - 1]["img3"].ToString();
if (img3.Length > 0)
{
img3 = "<img class='imgpro' src='../image/multiimg/" + img3 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img3 + "','3');\" />";
}
else
{
img3 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img3 + "','3');\" />";
}
string img4 = ds.Tables[0].Rows[i - 1]["img4"].ToString();
if (img4.Length > 0)
{
img4 = "<img class='imgpro' src='../image/multiimg/" + img4 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img4 + "','4');\" />";
}
else
{
img4 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img4 + "','4');\" />";
}
string img5 = ds.Tables[0].Rows[i - 1]["img5"].ToString();
if (img5.Length > 0)
{
img5 = "<img class='imgpro' src='../image/multiimg/" + img5 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img5 + "','5');\" />";
}
else
{
img5 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img5 + "','5');\" />";
}
string img7 = ds.Tables[0].Rows[i - 1]["img7"].ToString();
if (img7.Length > 0)
{
img7 = "<img class='imgpro' src='../image/multiimg/" + img7 + "' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img7 + "','7');\" />";
}
else
{
img7 = "<img class='imgpro' src='../image/common/notimgpro.png' onclick=\"OnChoicePro(" + ds.Tables[0].Rows[i - 1]["Id"].ToString() + ",event,'" + img7 + "','7');\" />";
}
strlist += "<td align='center'>" + i + "</td>";
strlist += "<td align='center'>" + img1 + "</td>";
strlist += "<td align='center'>" + img2 + "</td>";
strlist += "<td align='center'>" + img3 + "</td>";
strlist += "<td align='center'>" + img4 + "</td>";
strlist += "<td align='center'>" + img5 + "</td>";
strlist += "<td align='center'>" + img7 + "</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]["SellingPrice"].ToString() + "</td>";
strlist += "</tr>";
}
strlist += "</table>";
}
catch
{
strlist = "";
}
}
