protected void tmDanhMuc_Tick(object sender, EventArgs e) { NhomSanPham nsp = new NhomSanPham(); DataSet ds; ds = nsp.SelectRanDomNhomSanPhamShowed(); if (Cache["dmnsp"] != null) Cache.Remove("dmnsp"); Cache["dmnsp"] = ds; LoadSanPham04(); }
private void LoadSanPham04() { //LoadDanhMuc04 tblDanhMuc04.Controls.Clear(); tblSanPham04.Controls.Clear(); NhomSanPham nsp = new NhomSanPham(); DataSet ds; if (Cache["dmnsp"] == null) { ds = nsp.SelectRanDomNhomSanPhamShowed(); Cache["dmnsp"] = ds; } else { ds = (DataSet)Cache["dmnsp"]; } DataRow[] dr = ds.Tables[0].Select(); int n = 4; if (dr.Length < 4) n = dr.Length; TableRow tr = new TableRow(); for (int i = 0; i < n; i++) { if ((!Page.IsPostBack && i == 0) || hidCatId.Value == "0" || hidCatId.Value == "") hidCatId.Value = dr[0]["NhomSanPhamID"].ToString(); TableCell td = new TableCell(); td.Width = Unit.Percentage(100 / n); if (hidCatId.Value.Trim().Length > 0) { if (dr[i]["NhomSanPhamID"].ToString() == hidCatId.Value) { string content = ""; content += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"; content += "<tr><td width=\"12\"></td>"; content += "<td class=\"nd2\">" + dr[i]["TenNhomSanPham"].ToString() + "</td>"; content += "<td width=\"12\"></td></tr></table>"; td.VerticalAlign = VerticalAlign.Bottom; td.Text = content; tr.Cells.Add(td); //LoadSanPham04 SanPham sp = new SanPham(); DataSet sds = sp.SelectSanPhamAtViTriSanPhamInNhomSanPhamID(4, int.Parse(dr[i]["NhomSanPhamID"].ToString())); int sn = sds.Tables[0].Rows.Count; for (int j = 0; j < 2; j++) { TableRow str = new TableRow(); for (int si = 0; si < 5; si++) { TableCell std = new TableCell(); string scontent = ""; if (j * 5 + si < sn) { string tensanpham = sds.Tables[0].Rows[j * 5 + si]["TenSanPham"].ToString() + " " + sds.Tables[0].Rows[j * 5 + si]["TenSanPhamPhu"].ToString(); if (tensanpham.Length > 20) tensanpham = tensanpham.Substring(0, 20) + "..."; scontent += "<table class=\"product\" width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">"; scontent += "<tr><td align=\"center\"><a href=\"productdetail.aspx?id=" + sds.Tables[0].Rows[j * 5 + si]["SanPhamID"].ToString() + "\">" + tensanpham + "<br><img src=\"" + sds.Tables[0].Rows[j * 5 + si]["AnhSanPham"].ToString() + "\" alt=\"" + sds.Tables[0].Rows[j * 5 + si]["TenSanPham"].ToString() + "\" width=\"99\" height=\"89\" border=\"0\" style=\"border:#CCCCCC 1px solid\" /></a></td>"; scontent += "</tr><tr><td align=\"center\"><a href=\"productdetail.aspx?id=" + sds.Tables[0].Rows[j * 5 + si]["SanPhamID"].ToString() + "\">" + "</a>"; scontent += "<span class=\"price\">" + String.Format("{0:0,0}", sds.Tables[0].Rows[j * 5 + si]["GiaSanPham"]).Replace(",", ".") + "</span>" + sds.Tables[0].Rows[j * 5 + si]["DonViTienTe"].ToString() + "</td></tr></table>"; } std.Text = scontent; if (j == 0) std.Width = Unit.Percentage(16); str.Cells.Add(std); } tblSanPham04.Rows.Add(str); } } else { string content = "<a href=\"javascript:RefreshProduct04(" + dr[i]["NhomSanPhamID"].ToString() + ")\">" + dr[i]["TenNhomSanPham"].ToString() + "</a>"; td.CssClass = "nd1"; td.Text = content; tr.Cells.Add(td); } } else { td.Text = "Selected Tab parameter is misisng!"; tr.Cells.Add(td); } } tblDanhMuc04.Rows.Add(tr); }