Beispiel #1
0
    //专题
    public string CreateZhuantiIndex()
    {
        string       ErrorMessage = "";
        bool         isError      = false;
        int          Count        = 0;
        string       str          = "";
        string       Title        = "";
        string       Url          = "";
        string       Img          = "";
        StreamReader sr           = null;
        StreamWriter sw           = null;
        Encoding     code         = Encoding.GetEncoding("gb2312");

        try
        {
            string Path = Server.MapPath("../Video/index.html");
            sr  = new StreamReader(Path, code);
            str = sr.ReadToEnd();
            if (str.Length > 0)
            {
                DataTable Hot = bll.GetHotVideo(8, 1);
                //热门专题
                Count = Hot.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Hot1 = new StringBuilder();
                    StringBuilder Hot2 = new StringBuilder();
                    Hot1.Append("<ul class=\"ul_pic\">");
                    Hot2.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Hot.Rows[i]["Title"].ToString();
                        Url   = Hot.Rows[i]["VideoUrl"].ToString();
                        Img   = Hot.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Hot1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Hot1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Hot1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Hot2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Hot2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Hot2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Hot1.Append("</ul>");
                    Hot2.Append("</ul>");
                    str = str.Replace("$Hot1$", Hot1.ToString());
                    str = str.Replace("$Hot2$", Hot2.ToString());
                }

                //政府招商
                DataTable Zs = bll.GetZsVideo(12, 1);
                Count = Zs.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Zs1 = new StringBuilder();
                    StringBuilder Zs2 = new StringBuilder();
                    StringBuilder Zs3 = new StringBuilder();
                    Zs1.Append("<ul class=\"ul_pic\">");
                    Zs2.Append("<ul class=\"ul_pic\">");
                    Zs3.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Zs.Rows[i]["Title"].ToString();
                        Url   = Zs.Rows[i]["VideoUrl"].ToString();
                        Img   = Zs.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Zs1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zs1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zs1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else if (i >= 4 && i < 8)
                        {
                            Zs2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zs2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zs2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Zs3.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zs3.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zs3.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Zs1.Append("</ul>");
                    Zs2.Append("</ul>");
                    Zs3.Append("</ul>");
                    str = str.Replace("$Zs1$", Zs1.ToString());
                    str = str.Replace("$Zs2$", Zs2.ToString());
                    str = str.Replace("$Zs3$", Zs3.ToString());
                }

                //融资
                DataTable Rz = bll.GetRzVideo(12, 1);
                Count = Rz.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Rz1 = new StringBuilder();
                    StringBuilder Rz2 = new StringBuilder();
                    StringBuilder Rz3 = new StringBuilder();
                    Rz1.Append("<ul class=\"ul_pic\">");
                    Rz2.Append("<ul class=\"ul_pic\">");
                    Rz3.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Rz.Rows[i]["Title"].ToString();
                        Url   = Rz.Rows[i]["VideoUrl"].ToString();
                        Img   = Rz.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Rz1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Rz1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Rz1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else if (i >= 4 && i < 8)
                        {
                            Rz2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Rz2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Rz2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Rz3.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Rz3.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Rz3.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Rz1.Append("</ul>");
                    Rz2.Append("</ul>");
                    Rz3.Append("</ul>");
                    str = str.Replace("$Rz1$", Rz1.ToString());
                    str = str.Replace("$Rz2$", Rz2.ToString());
                    str = str.Replace("$Rz3$", Rz3.ToString());
                }


                //投资
                DataTable Tz = bll.GetTzVideo(8, 1);
                Count = Tz.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Tz1 = new StringBuilder();
                    StringBuilder Tz2 = new StringBuilder();
                    Tz1.Append("<ul class=\"ul_pic\">");
                    Tz2.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Tz.Rows[i]["Title"].ToString();
                        Url   = Tz.Rows[i]["VideoUrl"].ToString();
                        Img   = Tz.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Tz1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Tz1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Tz1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Tz2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Tz2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Tz2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Tz1.Append("</ul>");
                    Tz2.Append("</ul>");
                    str = str.Replace("$Tz1$", Tz1.ToString());
                    str = str.Replace("$Tz2$", Tz2.ToString());
                }

                //展会
                DataTable Zh = bll.GetZhVideo(12, 1);
                Count = Zh.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Zh1 = new StringBuilder();
                    StringBuilder Zh2 = new StringBuilder();
                    StringBuilder Zh3 = new StringBuilder();
                    Zh1.Append("<ul class=\"ul_pic\">");
                    Zh2.Append("<ul class=\"ul_pic\">");
                    Zh3.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Zh.Rows[i]["Title"].ToString();
                        Url   = Zh.Rows[i]["VideoUrl"].ToString();
                        Img   = Zh.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Zh1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zh1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zh1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else if (i >= 4 && i < 8)
                        {
                            Zh2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zh2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zh2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Zh3.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zh3.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zh3.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Zh1.Append("</ul>");
                    Zh2.Append("</ul>");
                    Zh3.Append("</ul>");
                    str = str.Replace("$Zh1$", Zh1.ToString());
                    str = str.Replace("$Zh2$", Zh2.ToString());
                    str = str.Replace("$Zh3$", Zh3.ToString());
                }

                //资金贷款
                DataTable Zjdk = bll.GetZjdkVideo(8, 1);
                Count = Zjdk.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder Zjdk1 = new StringBuilder();
                    StringBuilder Zjdk2 = new StringBuilder();
                    Zjdk1.Append("<ul class=\"ul_pic\">");
                    Zjdk2.Append("<ul class=\"ul_pic\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = Zjdk.Rows[i]["Title"].ToString();
                        Url   = Zjdk.Rows[i]["VideoUrl"].ToString();
                        Img   = Zjdk.Rows[i]["ImgUrl"].ToString();
                        if (i < 4)
                        {
                            Zjdk1.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zjdk1.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zjdk1.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                        else
                        {
                            Zjdk2.Append("<li><i class=\"iPic\"><a href=\"" + Url + "\" target=\"_blank\">");
                            Zjdk2.Append("<img alt=\"" + Title + "\" src=\"" + Img + "\" width=\"135\" height=\"100\" /></a></i>");
                            Zjdk2.Append("<i class=\"iTit\"><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></i></li>");
                        }
                    }
                    Zjdk1.Append("</ul>");
                    Zjdk2.Append("</ul>");
                    str = str.Replace("$Zjdk1$", Zjdk1.ToString());
                    str = str.Replace("$Zjdk2$", Zjdk2.ToString());
                }


                //热门专题列表
                DataTable HotList = bll.GetHotVideoList(18, 1);
                Count = HotList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder HotStr = new StringBuilder();
                    HotStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = HotList.Rows[i]["Title"].ToString();
                        Url   = HotList.Rows[i]["VideoUrl"].ToString();
                        HotStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    HotStr.Append("</ul>");
                    str = str.Replace("$HotList$", HotStr.ToString());
                }

                //招商专题列表
                DataTable ZsList = bll.GetZsVideoList(18, 1);
                Count = ZsList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder ZsStr = new StringBuilder();
                    ZsStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = ZsList.Rows[i]["Title"].ToString();
                        Url   = ZsList.Rows[i]["VideoUrl"].ToString();
                        ZsStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    ZsStr.Append("</ul>");
                    str = str.Replace("$ZsList$", ZsStr.ToString());
                }

                //资金贷款专题列表
                DataTable ZjdkList = bll.GetZjdkVideoList(18, 1);
                Count = ZjdkList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder ZjdkStr = new StringBuilder();
                    ZjdkStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = ZjdkList.Rows[i]["Title"].ToString();
                        Url   = ZjdkList.Rows[i]["VideoUrl"].ToString();
                        ZjdkStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    ZjdkStr.Append("</ul>");
                    str = str.Replace("$ZjdkList$", ZjdkStr.ToString());
                }

                //融资专题列表
                DataTable RzList = bll.GetRzVideoList(18, 1);
                Count = RzList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder RzStr = new StringBuilder();
                    RzStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = RzList.Rows[i]["Title"].ToString();
                        Url   = RzList.Rows[i]["VideoUrl"].ToString();
                        RzStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    RzStr.Append("</ul>");
                    str = str.Replace("$RzList$", RzStr.ToString());
                }

                //投资专题列表
                DataTable TzList = bll.GetTzVideoList(18, 1);
                Count = TzList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder TzStr = new StringBuilder();
                    TzStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = TzList.Rows[i]["Title"].ToString();
                        Url   = TzList.Rows[i]["VideoUrl"].ToString();
                        TzStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    TzStr.Append("</ul>");
                    str = str.Replace("$TzList$", TzStr.ToString());
                }

                //展会专题列表
                DataTable ZhList = bll.GetZhVideoList(18, 1);
                Count = ZhList.Rows.Count;
                if (Count > 0)
                {
                    StringBuilder ZhStr = new StringBuilder();
                    ZhStr.Append("<ul class=\"ul_text\">");
                    for (int i = 0; i < Count; i++)
                    {
                        Title = ZhList.Rows[i]["Title"].ToString();
                        Url   = ZhList.Rows[i]["VideoUrl"].ToString();
                        ZhStr.Append("<li><a href=\"" + Url + "\" target=\"_blank\">" + Title + "</a></li>");
                    }
                    ZhStr.Append("</ul>");
                    str = str.Replace("$ZhList$", ZhStr.ToString());
                }

                sw = new StreamWriter(@"J:zt/index.html", false, code);
                sw.Write(str);
            }
        }
        catch (Exception ex)
        {
            ErrorMessage = ex.Message;
            isError      = true;
        }
        finally
        {
            if (sr != null)
            {
                sr.Close();
            }
            if (sw != null)
            {
                sw.Close();
            }
        }
        return(ErrorMessage);
    }