private void LoadQuangCaoByNguoiDungID(int NguoiDungID) { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectByNguoiDungID(NguoiDungID); grdAdv.DataSource = ds; grdAdv.DataBind(); }
private void LoadQuangCao23() { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByLoaiNguoiDungID(Common.LoaiNguoiDungID(), 23); if (ds.Tables[0].Rows.Count >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao23.InnerHtml = "<object 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=\"100%\" height=\"216\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"100%\" height=\"216\"></embed></object>"; } else { spnQuangCao23.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" height=\"216px\" width=\"100%\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } else { spnQuangCao23.InnerHtml = "<img alt=\"Moi quang cao\" src=\"../images/advblank.jpg\" height=\"216px\" width=\"596px\" style=\"border:none\"/>"; } }
private void LoadQuangCao22() { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByLoaiNguoiDungID(Common.LoaiNguoiDungID(), 22); int n = 4; if (ds.Tables[0].Rows.Count <= 4) n = ds.Tables[0].Rows.Count; for (int i = 0; i < n; i++) { TableRow tr = new TableRow(); TableCell td = new TableCell(); td.Style.Value = "padding-top: 4px;"; string content = ""; if (ds.Tables[0].Rows[i]["LoaiAnh"].ToString() == "FLASH") { content = "<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=\"220\" height=\"155\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"." + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"." + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"220\" height=\"155\"></embed></object></a>"; } else { content = "<a href=\"" + ds.Tables[0].Rows[i]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[i]["NoiDungQuangCao"] + "\" src=\"." + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" style=\"border:solid 1px #C9C3C3; width:220px;\">"; } td.Text = content; tr.Cells.Add(td); tblQuangCao22.Rows.Add(tr); } }
private int LoadQuangCaoByKhuVuc(int ViTriQuangCao, int KhuVucID) { if (Common.LoaiNguoiDungID() == 3) { //For administrator QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectAllQuangCaoAtViTriQuangCaoByLoaiNguoiDungID(Common.LoaiNguoiDungID(), ViTriQuangCao); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriQuangCao=" + ViTriQuangCao + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } ds.Tables[0].DefaultView.Sort = "QuangCaoID DESC"; grdAdv.DataSource = ds.Tables[0].DefaultView; grdAdv.DataBind(); return selectedRows.Length; } else if (Common.LoaiNguoiDungID() == 2) { //For e-store manager QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectAllQuangCaoAtViTriQuangCaoByNguoiDungID(Common.NguoiDungID(), ViTriQuangCao); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriQuangCao=" + ViTriQuangCao + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } ds.Tables[0].DefaultView.Sort = "QuangCaoID DESC"; grdAdv.DataSource = ds.Tables[0].DefaultView; grdAdv.DataBind(); return selectedRows.Length; } return 0; }
private int LoadQuangCao(int ViTriQuangCao, int NhomSanPhamID) { if (Common.LoaiNguoiDungID() == 3) { //For administrator (11, 12, 13) QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectAllQuangCaoAtViTriQuangCaoByNhomSanPhamID(NhomSanPhamID, ViTriQuangCao); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("KhuVucID is null AND ViTriQuangCao=" + ViTriQuangCao); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } ds.Tables[0].DefaultView.Sort = "QuangCaoID DESC"; grdAdv.DataSource = ds.Tables[0].DefaultView; grdAdv.DataBind(); return selectedRows.Length; } return 0; }
private int LoadCuaHang(int ViTriCuaHang, int KhuVucID) { if (Common.LoaiNguoiDungID() == 3) { //For administrator CuaHang ch = new CuaHang(); DataSet ds = ch.SelectAllCuaHangAtViTriCuaHang(ViTriCuaHang); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } grdStore.DataSource = ds; grdStore.DataBind(); return selectedRows.Length; } else if (Common.LoaiNguoiDungID() == 2) { //For e-store manager QuangCao qcao = new QuangCao(); CuaHang ch = new CuaHang(); DataSet ds = ch.SelectAllCuaHangAtViTriCuaHangByNguoiDungID(Common.NguoiDungID(), ViTriCuaHang); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } grdStore.DataSource = ds; grdStore.DataBind(); return selectedRows.Length; } return 0; }
private void LoadQuangCao(int aid) { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(ChuCuaHangID, aid); switch (aid) { case 54: if (ds.Tables[0].Rows.Count >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao54.InnerHtml = "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"598\" height=\"213\" 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=\"598\" height=\"213\"></embed></object>"; } else { spnQuangCao54.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" height=\"213\" width=\"598\" style=\"border:none\"/></a>"; } } break; } }
private void LoadQuangCao09() { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByLoaiNguoiDungIDAndKhuVuc(3, 9, intKhuVucID); int n = ds.Tables[0].Rows.Count; spnQuangCao09a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"370px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao09b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"370px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao09c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"370px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao09a.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=\"370px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"370px\" height=\"122\"></embed></object>"; } else { spnQuangCao09a.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"370px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (ds.Tables[0].Rows[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao09b.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=\"370px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"370px\" height=\"122\"></embed></object>"; } else { spnQuangCao09b.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[1]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"370px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } //if (n >= 3) //{ // if (ds.Tables[0].Rows[2]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao09c.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=\"370px\" 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=\"370px\" height=\"122\"></embed></object>"; // } // else // { // spnQuangCao09c.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=\"370px\" style=\"border:solid 1px #C9C3C3\"/></a>"; // } //} } } else { tblQuangCao09.Visible = false; } }
private void LoadAllQuangCao() { QuangCao qcao = new QuangCao(); DataSet ds; if (Cache["dsallquangcao"] == null) { ds = qcao.SelectQuangCaoAtViTriQuangCaoByLoaiNguoiDungIDForHomePage(3, "1,2,3,4,5,6,7,8,9,10"); Cache["dsallquangcao"] = ds; } else { ds = (DataSet) Cache["dsallquangcao"]; } if (ds.Tables[0].Rows.Count >= 1) { for (int i = 0; i < 10; i++) { ds.Tables[0].DefaultView.RowFilter = "ViTriQuangCao = " + (i + 1); DataView dv = ds.Tables[0].DefaultView; if (dv.Count > 0) { switch (i) { case 0: if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao01.InnerHtml = "<object 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=\"100%\" height=\"111\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"100%\" height=\"111\"></embed></object>"; } else { spnQuangCao01.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"111px\" width=\"100%\" style=\"border:solid 1px #C9C3C3\"/></a>"; } break; case 1: if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao02.InnerHtml = "<object style=\"z-index:1\" z-index:1 border:solid 1px #C9C3C3 classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "z-index=\"0\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"550\" height=\"216\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<param name=\"wmode\" value=\"transparent\" />" + "<embed wmode=\"transparent\" src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"550\" height=\"216\" style=\"z-index:1\"></embed></object>"; } else { spnQuangCao02.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\" style=\"z-index:1\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"216px\" width=\"550px\" style=\"z-index:1;border:solid 1px #C9C3C3\"/></a>"; } break; case 2: int n = dv.Count; spnQuangCao03a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao03b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao03c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao03a.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao03a.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"365pxpx\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (dv[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao03b.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao03b.InnerHtml = "<a href=\"" + dv[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[1]["NoiDungQuangCao"] + "\" src=\"" + dv[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } } else { tblQuangCao03.Visible = false; } break; case 3: n = 5; if (dv.Count <= 2) n = dv.Count; for (int j = 0; j < n; j++) { TableRow tr = new TableRow(); TableCell td = new TableCell(); td.Style.Value = "padding-top: 4px; padding-left:4px"; string content = ""; if (dv[j]["LoaiAnh"].ToString() == "FLASH") { content = "<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=\"200\" height=\"155\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[j]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[j]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"200\" height=\"155\"></embed></object>"; } else { content = "<a href=\"" + dv[j]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[j]["NoiDungQuangCao"] + "\" src=\"" + dv[j]["DuongDanAnh"] + "\" style=\"border:solid 1px #C9C3C3; width:200px;\"></a>"; } td.Text = content; tr.Cells.Add(td); tblQuangCao04.Rows.Add(tr); } break; case 4: n = dv.Count; spnQuangCao05a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao05b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao05c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao05a.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao05a.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (dv[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao05b.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao05b.InnerHtml = "<a href=\"" + dv[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[1]["NoiDungQuangCao"] + "\" src=\"" + dv[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } } else { tblQuangCao05.Visible = false; } break; case 5: //spn = spnQuangCao06a; //spn1 = spnQuangCao06b; break; case 6: n = dv.Count; spnQuangCao07a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao07b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao07c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao07a.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao07a.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (dv[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao07b.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao07b.InnerHtml = "<a href=\"" + dv[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[1]["NoiDungQuangCao"] + "\" src=\"" + dv[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } } else { tblQuangCao07.Visible = false; } break; case 7: n = dv.Count; spnQuangCao08a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao08b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao08c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao08a.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao08a.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (dv[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao08b.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao08b.InnerHtml = "<a href=\"" + dv[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[1]["NoiDungQuangCao"] + "\" src=\"" + dv[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } } else { tblQuangCao08.Visible = false; } break; case 8: n = dv.Count; spnQuangCao09a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; spnQuangCao09b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; //spnQuangCao09c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/>"; if (n >= 1) { if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao09a.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao09a.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } if (n >= 2) { if (dv[1]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao09b.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=\"365px\" height=\"122\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[1]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[1]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"365px\" height=\"122\"></embed></object>"; } else { spnQuangCao09b.InnerHtml = "<a href=\"" + dv[1]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[1]["NoiDungQuangCao"] + "\" src=\"" + dv[1]["DuongDanAnh"] + "\" height=\"122px\" width=\"365px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } } else { tblQuangCao09.Visible = false; } break; case 9: if (dv[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao10.InnerHtml = "<object 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=\"980\" height=\"111\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + dv[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + dv[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"980\" height=\"216\"></embed></object>"; } else { spnQuangCao10.InnerHtml = "<a href=\"" + dv[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + dv[0]["NoiDungQuangCao"] + "\" src=\"" + dv[0]["DuongDanAnh"] + "\" height=\"111px\" width=\"980px\" style=\"border:solid 1px #C9C3C3\"/></a>"; } break; } } } } }
private void LoadQuangCao11() { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNhomSanPhamID(mcid, 11); HtmlGenericControl spnQuangCao41 = (HtmlGenericControl) 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"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" 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"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" 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 LoadQuangCao(int aid) { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(ChuCuaHangID, aid); switch (aid) { case 51: if (ds.Tables[0].Rows.Count >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao51.InnerHtml = "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "z-index=\"0\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"593\" height=\"117\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<param name=\"wmode\" value=\"transparent\" />" + "<embed wmode=\"transparent\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"593\" height=\"117\"></embed></object>"; } else { spnQuangCao51.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" height=\"117\" width=\"593\" style=\"border:none\"/></a>"; } } break; //case 52: // if (ds.Tables[0].Rows.Count >= 1) // { // if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao52.InnerHtml = "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"628\" height=\"116\" 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=\"628\" height=\"116\"></embed></object>"; // } // else // { // spnQuangCao52.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=\"116px\" width=\"628px\" style=\"border:none\"/></a>"; // } // } // break; //case 53: // if (ds.Tables[0].Rows.Count >= 1) // { // if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") // { // spnQuangCao53.InnerHtml = "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" // + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" // + "width=\"156\" height=\"116\" 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=\"156\" height=\"116\"></embed></object>"; // } // else // { // spnQuangCao53.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=\"116px\" width=\"156px\" style=\"border:none\"/></a>"; // } // } // //else // //{ // // spnQuangCao53.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"116px\" width=\"156px\" style=\"border:none\"/>"; // //} // break; case 54: if (ds.Tables[0].Rows.Count >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao54.InnerHtml = "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"421\" height=\"212\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<param name=\"wmode\" value=\"transparent\" />" + "<embed src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"421\" height=\"212\"></embed></object>"; } else { spnQuangCao54.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" height=\"212\" width=\"421\" style=\"border:none\"/></a>"; } } //else //{ // spnQuangCao54.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"249px\" width=\"490px\" style=\"border:none\"/>"; //} break; case 55: if (ds.Tables[0].Rows.Count >= 1) { spnQuangCao55.InnerHtml = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao55.InnerHtml += "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"110px\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"110px\" ></embed></object>"; } else { spnQuangCao55.InnerHtml += "<a href=\"" + ds.Tables[0].Rows[i]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[i]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" width=\"110px\" style=\"border:none\"/></a>"; } } } break; case 56: if (ds.Tables[0].Rows.Count >= 1) { spnQuangCao56.InnerHtml = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao56.InnerHtml += "<object style=\"border:none\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + "width=\"110\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"110\" ></embed></object>"; } else { spnQuangCao56.InnerHtml += "<a href=\"" + ds.Tables[0].Rows[i]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[i]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[i]["DuongDanAnh"] + "\" width=\"110\" style=\"border:none\"/></a>"; } } } break; case 57: if (ds.Tables[0].Rows.Count >= 1) { if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { spnQuangCao57.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=\"150\" height=\"150\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"150\" height=\"150\"></embed></object>"; } else { spnQuangCao57.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"] + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"] + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" height=\"150\" width=\"150\" style=\"border:solid 1px #C9C3C3\"/></a>"; } } break; } }
protected void Page_Load(object sender, EventArgs e) { if (Common.LoaiNguoiDungID() == 3 || Common.LoaiNguoiDungID() == 2) { if (!Page.IsPostBack) { if (Request.QueryString["id"] != null) { //Edit, show the data from database int id = int.Parse(Request.QueryString["id"]); QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectByQuangCaoID(id); if (ds.Tables[0].Rows.Count == 1) { int NguoiDungID = int.Parse(ds.Tables[0].Rows[0]["NguoiDungID"].ToString()); int LoaiNguoiDungID = int.Parse(ds.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString()); if ((Common.LoaiNguoiDungID() == 3 && LoaiNguoiDungID == 3) || (Common.LoaiNguoiDungID() == 2 && LoaiNguoiDungID == 2 && Common.NguoiDungID() == NguoiDungID)) { txtDuongDan.Text = ds.Tables[0].Rows[0]["DuongDan"].ToString(); txtNoiDung.Text = ds.Tables[0].Rows[0]["NoiDungQuangCao"].ToString(); imgAnhQuangCao.Src = "." + ds.Tables[0].Rows[0]["DuongDanAnh"]; txtGhiChu.Text = ds.Tables[0].Rows[0]["GhiChu"].ToString(); if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH") { rbtFlash.Checked = true; flashQuangCao.Visible = true; flashQuangCao.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=\"300\" height=\"200\" title=\"Quang Cao\">" + "<param name=\"movie\" value=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" />" + "<param name=\"quality\" value=\"high\" />" + "<embed src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"] + "\" quality=\"high\"" + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\"" + "width=\"300\" height=\"200\"></embed></object> "; } else { rbtImage.Checked = true; imgAnhQuangCao.Visible = true; } } else { Response.Redirect("../message.aspx?msg=Access denied"); } } else { Response.Redirect("../message.aspx?msg=Invalid parameter"); } } } } else { Response.Redirect("../message.aspx?msg=Access denied"); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Common.LoaiNguoiDungID() == 3 || Common.LoaiNguoiDungID() == 2) { QuangCao qcao = new QuangCao(); if (Request.QueryString["id"] == null) { //Add new string path = Server.MapPath("../Upload/AdvImages"); string relativePath = ""; string randomString = ""; string mediaType = "IMAGE"; if (rbtFlash.Checked) mediaType = "FLASH"; if (fileQuangCao.PostedFile.FileName != "") { try { if ((fileQuangCao.PostedFile.ContentLength <= 300000) || (Common.LoaiNguoiDungID() == 3)) { int pos = fileQuangCao.PostedFile.FileName.LastIndexOf('\\'); string absolutePath = path + "\\" + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); if (File.Exists(absolutePath)) { randomString = DateTime.Now.Ticks + "_"; absolutePath = path + "\\" + randomString + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); } fileQuangCao.PostedFile.SaveAs(absolutePath); relativePath = "./Upload/AdvImages/" + randomString + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); } else { Response.Redirect("../message.aspx?msg=File size is bigger than 300KB!"); return; } } catch (Exception ex) { Response.Redirect("../message.aspx?msg=" + ex.Message); return; } } qcao.InsertFields(txtDuongDan.Text, txtNoiDung.Text, relativePath, Common.NguoiDungID(), txtGhiChu.Text, mediaType, null, null, null, null, null); } else { //Edit int id = int.Parse(Request.QueryString["id"]); string path = Server.MapPath("../Upload/AdvImages"); string randomString = ""; string relativePath = ""; string mediaType = "IMAGE"; if (rbtFlash.Checked) mediaType = "FLASH"; if (fileQuangCao.PostedFile.FileName != "") { try { if ((fileQuangCao.PostedFile.ContentLength <= 300000) || (Common.LoaiNguoiDungID() == 3)) { int pos = fileQuangCao.PostedFile.FileName.LastIndexOf('\\'); string absolutePath = path + "\\" + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); if (File.Exists(absolutePath)) { randomString = DateTime.Now.Ticks + "_"; absolutePath = path + "\\" + randomString + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); } if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } fileQuangCao.PostedFile.SaveAs(absolutePath); //if (rbtFlash.Checked == true) //{ // fileQuangCao.PostedFile.SaveAs(absolutePath); //} //else //{ // Common.ResizeFromStream(absolutePath, 320, fileQuangCao.PostedFile.InputStream); //} //File.Delete(Server.MapPath(imgAnhQuangCao.Src)); relativePath = "./Upload/AdvImages/" + randomString + fileQuangCao.PostedFile.FileName.Remove(0, pos + 1); } else { Response.Redirect("../message.aspx?msg=File size is too big!"); return; } } catch (Exception ex) { Response.Redirect("../message.aspx?msg=" + ex.Message); return; } } if (relativePath != "") { qcao.UpdateFields(id, txtDuongDan.Text, txtNoiDung.Text, relativePath, null, txtGhiChu.Text, mediaType, null, null, null, null, null); } else { qcao.UpdateFields(id, txtDuongDan.Text, txtNoiDung.Text, null, null, txtGhiChu.Text, mediaType, null, null, null, null, null); } } string strScript = "<script language='JavaScript'>" + "window.parent.Refresh();</script>"; ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript); } else { Response.Redirect("../message.aspx?msg=Access denied"); } }
protected void btnXoa_Click(object sender, EventArgs e) { try { switch (ViewState["TYPE"].ToString()) { case "thuoctinh": if (Common.LoaiNguoiDungID() == 3) { ThuocTinh tt = new ThuocTinh(); tt.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "nhomsanpham": if (Common.LoaiNguoiDungID() == 3) { NhomSanPham nhomsanpham = new NhomSanPham(); nhomsanpham.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "vitrisanpham": if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2)) { ViTriSanPham vtsp = new ViTriSanPham(); vtsp.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "cuahangnhomsanpham": if (Common.LoaiNguoiDungID() == 2) { deleteCuaHangNhomSanPham(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "nhomsanphamcuahang": if (Common.LoaiNguoiDungID() == 2) { deleteNhomSanPhamCuaHang(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "nhanxetsanpham": if (Common.LoaiNguoiDungID() != 1) { NhanXetSanPham nhanxet = new NhanXetSanPham(); nhanxet.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "tintuc": if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2)) { TinTuc tt = new TinTuc(); tt.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "hotrotructuyen": if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2)) { HoTroTrucTuyen ht = new HoTroTrucTuyen(); ht.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "hoidapsanpham": if (Common.LoaiNguoiDungID() != 1) { HoiDapSanPham hoidap = new HoiDapSanPham(); hoidap.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "nguoidung": if (Common.LoaiNguoiDungID() == 3) { if (CheckExistCuaHang(id) != true) { NguoiDung nguoidung = new NguoiDung(); nguoidung.Delete(id); } else { Response.Redirect("../message.aspx?msg=Không thể xóa người dùng đã có cửa hàng", false); } } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "hangsanxuat": if (Common.LoaiNguoiDungID() == 3) { HangSanXuat hsx = new HangSanXuat(); hsx.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "khuvuc": if (Common.LoaiNguoiDungID() == 3) { KhuVuc kv = new KhuVuc(); kv.Delete(id); } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "quangcao": if (Common.LoaiNguoiDungID() == 2 || Common.LoaiNguoiDungID() == 3) { QuangCao qcao = new QuangCao(); DataSet ds = qcao.SelectByQuangCaoID(id); if (ds.Tables[0].Rows.Count == 1) { if (Common.LoaiNguoiDungID() == 3) { //Administrator if (ds.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() == "3") qcao.Delete(id); } else { //e-Store if (ds.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() == "2" && ds.Tables[0].Rows[0]["NguoiDungID"].ToString() == Common.NguoiDungID().ToString()) qcao.Delete(id); } } } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; case "sanpham": { SanPham sanpham = new SanPham(); DataSet dssp = sanpham.SelectBySanPhamID(id); if (Common.LoaiNguoiDungID() == 2) { if (dssp.Tables[0].Rows.Count == 1) { //e-Store if (dssp.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() == Common.LoaiNguoiDungID().ToString() && dssp.Tables[0].Rows[0]["NguoiDungID"].ToString() == Common.NguoiDungID().ToString()) { sanpham.Delete(id); } } } else if (Common.LoaiNguoiDungID() == 3) { if (dssp.Tables[0].Rows.Count == 1) { sanpham.Delete(id); } } else { Response.Redirect("../message.aspx?msg=Access denied"); } } break; case "sanphammau": { SanPhamMau sanpham = new SanPhamMau(); DataSet dssp = sanpham.SelectByID(id); if (Common.LoaiNguoiDungID() == 3) { if (dssp.Tables[0].Rows.Count == 1) { sanpham.Delete(id); } } else { Response.Redirect("../message.aspx?msg=Access denied"); } } break; case "anhsanpham": if ((Common.LoaiNguoiDungID() == 2) || (Common.LoaiNguoiDungID() == 3)) { Anh anhsanpham = new Anh(); DataSet dssp = anhsanpham.SelectByID(id); if (dssp.Tables[0].Rows.Count == 1) { anhsanpham.Delete(id); if (File.Exists(Server.MapPath(Request.QueryString["src"]))) { File.Delete(Server.MapPath(Request.QueryString["src"])); } } } else { Response.Redirect("../message.aspx?msg=Access denied"); } break; } string strScript = "<script language='JavaScript'>" + "window.parent.Refresh();</script>"; ClientScript.RegisterStartupScript(Type.GetType("System.String"), "Refresh", strScript); } catch (Exception ex) { Response.Write(ex.ToString()); } }