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>"; }