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