protected void Page_Load(object sender, EventArgs e) { if (Common.LoaiNguoiDungID() == 3) { if (!Page.IsPostBack) { if (Request.QueryString["mcid"] != null) { mcid = int.Parse(Request.QueryString["mcid"]); } LoadDanhMuc(); //LoadQuangCao11(); LoadQuangCao12(); LoadQuangCao13(); LoadSanPham11(); LoadSanPham12(); LoadSanPham13(); LoadSanPham14(); LoadGianHang(); NhomSanPham nsp = new NhomSanPham(); DataSet ds = nsp.SelectByID(mcid); if (ds.Tables[0].Rows.Count == 1) lblDanhMuc.Text = ds.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); hidCatId.Value = mcid.ToString(); } else { mcid = int.Parse(hidCatId.Value); } } else { Response.Redirect("../message.aspx?msg=Access denied"); } }
private void LoadNhomSanPham(int nhomsanphamid) { NhomSanPham nsp = new NhomSanPham(); DataSet ds1 = nsp.SelectByID(nhomsanphamid); if (ds1.Tables[0].Rows.Count > 0) txtDanhMucSanPham.Text = ds1.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["pcode"] != null) { promotion_code = Request.QueryString["pcode"]; if (Request.QueryString["cid"] != null) { try { catid = int.Parse(Request.QueryString["cid"]); NhomSanPham nsp = new NhomSanPham(); DataSet ds = nsp.SelectByID(catid); if (ds.Tables[0].Rows.Count >= 0) { lblCatName.Text = "> " + ds.Tables[0].Rows[0]["TenNhomSanPham"]; } } catch (Exception ex) { Response.Redirect("./message.aspx?msg=" + ex.Message); } } } else { Response.Redirect("./message.aspx?msg=Invalid parameter"); } if (!Page.IsPostBack) { //LoadDanhMuc(); LoadMenu(0); if (promotion_code == "moi" || promotion_code == "km" || promotion_code == "gg" || promotion_code == "uc") { if (Request.QueryString["cid"] != null) { LoadSanPham(promotion_code, catid, 1); } else { LoadSanPham(promotion_code, 0, 1); } } else { Response.Redirect("./message.aspx?msg=Invalid parameter"); } } }
private void AddNhomSanPhamToCuaHang(int NhomSanPhamID, int CuaHangID) { CuaHangNhomSanPham chnsp = new CuaHangNhomSanPham(); DataSet dschnsp = chnsp.SelectByNhomSanPhamCuaHangID(CuaHangID, NhomSanPhamID); if (dschnsp.Tables[0].Rows.Count <= 0) { chnsp.Insert(CuaHangID, NhomSanPhamID, ""); NhomSanPham nsp = new NhomSanPham(); DataSet ds = nsp.SelectByID(NhomSanPhamID); int NhomChaID = int.Parse(ds.Tables[0].Rows[0]["NhomChaID"].ToString()); if (NhomChaID != 0) AddNhomSanPhamToCuaHang(NhomChaID, CuaHangID); } }
private void LoadData(string Id) { try { NhomSanPham nhomsanpham = new NhomSanPham(); DataSet ds = nhomsanpham.SelectByID(Convert.ToInt32(Id)); if (ds.Tables[0].Rows.Count > 0) { txtTenNhomCon.Text = ds.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); txtThuTu.Text = ds.Tables[0].Rows[0]["SapXep"].ToString(); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
//private void LoadQuangCao41() //{ //QuangCao qcao = new QuangCao(); //DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(int.Parse(ViewState["NguoiDungID"].ToString()), 41); //HtmlGenericControl spnQuangCao41 = (HtmlGenericControl)this.Master.FindControl("spnQuangCao01"); //if (ds.Tables[0].Rows.Count >= 1) //{ // if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao41.InnerHtml = "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"210\" height=\"75\" title=\"Quang Cao\">" // + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" />" // + "<param name=\"quality\" value=\"high\" />" // + "<embed src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" quality=\"high\"" // + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" // + "width=\"210\" height=\"75\"></embed></object>"; // } // else // { // spnQuangCao41.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"].ToString() // + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"].ToString() // + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" height=\"75px\" width=\"210px\" style=\"Border:none\"/></a>"; // } //} //else //{ // spnQuangCao41.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"75px\" width=\"210px\" style=\"border:none\"/>"; //} //} //private void LoadQuangCao42() //{ //QuangCao qcao = new QuangCao(); //DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(int.Parse(ViewState["NguoiDungID"].ToString()), 42); //int n = ds.Tables[0].Rows.Count; //spnQuangCao42a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao42b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao42c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>"; //if (n >= 1) //{ // if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao42a.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"312\" height=\"122\" title=\"Quang Cao\">" // + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" />" // + "<param name=\"quality\" value=\"high\" />" // + "<embed src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" quality=\"high\"" // + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" // + "width=\"312\" height=\"122\"></embed></object>"; // } // else // { // spnQuangCao42a.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"].ToString() // + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"].ToString() // + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>"; // } // if (n >= 2) // { // if (ds.Tables[0].Rows[1]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao42b.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"312\" height=\"122\" title=\"Quang Cao\">" // + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" />" // + "<param name=\"quality\" value=\"high\" />" // + "<embed src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" quality=\"high\"" // + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" // + "width=\"312\" height=\"122\"></embed></object>"; // } // else // { // spnQuangCao42b.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[1]["DuongDan"].ToString() // + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[1]["NoiDungQuangCao"].ToString() // + "\" src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>"; // } // if (n >= 3) // { // if (ds.Tables[0].Rows[2]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao42c.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"312\" height=\"122\" title=\"Quang Cao\">" // + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" />" // + "<param name=\"quality\" value=\"high\" />" // + "<embed src=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" quality=\"high\"" // + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" // + "width=\"312\" height=\"122\"></embed></object>"; // } // else // { // spnQuangCao42c.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[2]["DuongDan"].ToString() // + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[2]["NoiDungQuangCao"].ToString() // + "\" src=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>"; // } // } // } //} //else //{ // tblQuangCao42.Visible = false; //} //} private void ShowLink(int NhomSanPhamId) { NhomSanPham nsp = new NhomSanPham(); DataSet ds2 = nsp.SelectByID(NhomSanPhamId); if (ds2.Tables[0].Rows.Count == 1) { lblDanhMucCon.Text = ds2.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); } DataSet ds1 = nsp.SelectByID(int.Parse(ds2.Tables[0].Rows[0]["NhomChaID"].ToString())); if (ds1.Tables[0].Rows.Count == 1) { lnkDanhMucCha.Text = ds1.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); lnkDanhMucCha.PostBackUrl = "maincategory.aspx?mcid=" + ds2.Tables[0].Rows[0]["NhomChaID"]; lblArrow.Visible = true; } else { lblArrow.Visible = false; } }
private void LoadDuongDan(int mcid, int scid) { NhomSanPham nsp = new NhomSanPham(); DataSet ds1 = nsp.SelectByID(mcid); if (ds1.Tables[0].Rows.Count == 1) { lnkDanhMucCha.Text = ds1.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); lnkDanhMucCha.NavigateUrl = "subcategory.aspx?mcid=" + ds1.Tables[0].Rows[0]["NhomChaID"] + "&scid=" + mcid; } else { lnkDanhMucCha.Text = ""; } DataSet ds2 = nsp.SelectByID(scid); if (ds2.Tables[0].Rows.Count == 1) { lblDanhMucCon.Text = ds2.Tables[0].Rows[0]["TenNhomSanPham"].ToString(); this.Title = lblDanhMucCon.Text; } else { lblDanhMucCon.Text = ""; } }