private void LoadQuangCao41()
 {
     QuangCao qcao = new QuangCao();
     DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(Common.NguoiDungID(), 41);
     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;
        }
    }