public static int UpdateCnInterfaceVideo(CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath)
 {
     return ObjectCreate.CreateInterfaceVideoXpath().UpdateCnInterfaceVideo(cnXpath);
 }
        public int UpdateCnInterfaceVideo(CnDataAcess.Entity.CnInterfaceVideoXpath cnxpath)
        {
            int resultcount = 0;
            string sql = @"IF NOT EXISTS(SELECT 1 FROM [Cn_InterfaceVideoXpath] WHERE [CnWebName] = @CnWebName)
            BEGIN
            INSERT INTO [Cn_InterfaceVideoXpath]
               ([CnWebName]
               ,[CnWebUrl]
               ,[CnWebEncode]
               ,[CnVideoTitle001]
               ,[CnVideoHref001]
               ,[CnVideoSrc001]
               ,[CnVideoTitle002]
               ,[CnVideoHref002]
               ,[CnVideoSrc002]
               ,[CnVideoTitle003]
               ,[CnVideoHref003]
               ,[CnVideoSrc003]
               ,[CnVideoTitle004]
               ,[CnVideoHref004]
               ,[CnVideoSrc004]
               ,[CnVideoTitle005]
               ,[CnVideoHref005]
               ,[CnVideoSrc005]
               ,[CnVideoTitle006]
               ,[CnVideoHref006]
               ,[CnVideoSrc006])
             VALUES
               (@CnWebName
               ,@CnWebUrl
               ,@CnWebEncode
               ,@CnVideoTitle001
               ,@CnVideoHref001
               ,@CnVideoSrc001
               ,@CnVideoTitle002
               ,@CnVideoHref002
               ,@CnVideoSrc002
               ,@CnVideoTitle003
               ,@CnVideoHref003
               ,@CnVideoSrc003
               ,@CnVideoTitle004
               ,@CnVideoHref004
               ,@CnVideoSrc004
               ,@CnVideoTitle005
               ,@CnVideoHref005
               ,@CnVideoSrc005
               ,@CnVideoTitle006
               ,@CnVideoHref006
               ,@CnVideoSrc006)
            END
            ELSE
            BEGIN
            UPDATE [Cn_InterfaceVideoXpath]
               SET [CnWebName] = @CnWebName
              ,[CnWebUrl] = @CnWebUrl
              ,[CnWebEncode]=@CnWebEncode
              ,[CnVideoTitle001] = @CnVideoTitle001
              ,[CnVideoHref001] = @CnVideoHref001
              ,[CnVideoSrc001] = @CnVideoSrc001
              ,[CnVideoTitle002] = @CnVideoTitle002
              ,[CnVideoHref002] = @CnVideoHref002
              ,[CnVideoSrc002] = @CnVideoSrc002
              ,[CnVideoTitle003] = @CnVideoTitle003
              ,[CnVideoHref003] = @CnVideoHref003
              ,[CnVideoSrc003] = @CnVideoSrc003
              ,[CnVideoTitle004] = @CnVideoTitle004
              ,[CnVideoHref004] = @CnVideoHref004
              ,[CnVideoSrc004] = @CnVideoSrc004
              ,[CnVideoTitle005] = @CnVideoTitle005
              ,[CnVideoHref005] = @CnVideoHref005
              ,[CnVideoSrc005] = @CnVideoSrc005
              ,[CnVideoTitle006] = @CnVideoTitle006
              ,[CnVideoHref006] = @CnVideoHref006
              ,[CnVideoSrc006] = @CnVideoSrc006
              ,[CnUpdateTime] = getdate()
             WHERE [CnWebName]=@CnWebName
            END";
            string conStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString();
            using (SqlConnection conn = new SqlConnection(conStr))
            {
                conn.Open();
                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;
                cmd.Parameters.AddWithValue("@CnWebName", cnxpath.CnWebName);
                cmd.Parameters.AddWithValue("@CnWebUrl", cnxpath.CnWebUrl);
                cmd.Parameters.AddWithValue("@CnWebEncode", cnxpath.CnWebEncode);
                cmd.Parameters.AddWithValue("@CnVideoTitle001", cnxpath.CnVideoTitle001);
                cmd.Parameters.AddWithValue("@CnVideoHref001", cnxpath.CnVideoHref001);
                cmd.Parameters.AddWithValue("@CnVideoSrc001", cnxpath.CnVideoSrc001);
                cmd.Parameters.AddWithValue("@CnVideoTitle002", cnxpath.CnVideoTitle002);
                cmd.Parameters.AddWithValue("@CnVideoHref002", cnxpath.CnVideoHref002);
                cmd.Parameters.AddWithValue("@CnVideoSrc002", cnxpath.CnVideoSrc002);
                cmd.Parameters.AddWithValue("@CnVideoTitle003", cnxpath.CnVideoTitle003);
                cmd.Parameters.AddWithValue("@CnVideoHref003", cnxpath.CnVideoHref003);
                cmd.Parameters.AddWithValue("@CnVideoSrc003", cnxpath.CnVideoSrc003);
                cmd.Parameters.AddWithValue("@CnVideoTitle004", cnxpath.CnVideoTitle004);
                cmd.Parameters.AddWithValue("@CnVideoHref004", cnxpath.CnVideoHref004);
                cmd.Parameters.AddWithValue("@CnVideoSrc004", cnxpath.CnVideoSrc004);
                cmd.Parameters.AddWithValue("@CnVideoTitle005", cnxpath.CnVideoTitle005);
                cmd.Parameters.AddWithValue("@CnVideoHref005", cnxpath.CnVideoHref005);
                cmd.Parameters.AddWithValue("@CnVideoSrc005", cnxpath.CnVideoSrc005);
                cmd.Parameters.AddWithValue("@CnVideoTitle006", cnxpath.CnVideoTitle006);
                cmd.Parameters.AddWithValue("@CnVideoHref006", cnxpath.CnVideoHref006);
                cmd.Parameters.AddWithValue("@CnVideoSrc006", cnxpath.CnVideoSrc006);

                resultcount = cmd.ExecuteNonQuery();
            }
            return resultcount;
        }
        public void GetWebVideoHtml(CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath,string title,string alt,string src,string hrefpath,string srcpath,string htmlname)
        {
            WebClient wc = new WebClient
            {
                Encoding = Encoding.GetEncoding(cnXpath.CnWebEncode)
            };
            string html = wc.DownloadString(cnXpath.CnWebUrl);

            //string html = "";
            //System.IO.StreamReader sr = new System.IO.StreamReader("D:\\CnInterface\\CnWeb\\html\\buildhtml.txt", Encoding.GetEncoding("gb2312"));
            //lock (sr)
            //{
            //    html = sr.ReadToEnd();
            //    sr.Close();
            //}
            HtmlDocument doc = new HtmlDocument();
            doc.LoadHtml(html);
            string title001 = "";
            string title002 = "";
            string title003 = "";
            string title004 = "";
            string title005 = "";
            string title006 = "";
            if (!title.Equals("") && alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["title"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["title"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["title"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["title"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["title"].Value;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["title"].Value;
            }
            else if (title.Equals("") && !alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["alt"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["alt"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["alt"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["alt"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["alt"].Value;
                title006 =cnXpath.CnVideoTitle006.Equals("")?cnXpath.CnVideoTitle006:doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["alt"].Value;
            }
            else
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).InnerText;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).InnerText;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).InnerText;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).InnerText;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).InnerText;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).InnerText;
            }
            StringBuilder sb = new StringBuilder();
            sb.Append("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"> <html xmlns=\"http://www.w3.org/1999/xhtml\"><head><title>www.CnInterface.com接口天下</title><meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\" /> <meta name=\"keywords\" content=\"接口,接口天下,价值接口,程序接口,网络接口,webservice接口,http接口,ActiveX dll接口,普通dll接口,数据库接口,短信,短信发送,短信在线发送,手机短信,手机短信发送,手机短信在线发送\" /><style type=\"text/css\">a:link {text-decoration:none;color:#666699;}a:visited {text-decoration:none;color:#666699}a:hover {text-decoration:underline; color:#666699; cursor:hand;}a:active {text-decoration:none;color:#666699}</style><link href=\"../css/base.css\" type=\"text/css\" rel=\"Stylesheet\" /></head>");
            sb.Append("<body>");
            sb.Append("<table border=\"0\" cellpadding =\"2\" cellspacing =\"0\"   width=\"100%\" >");
            sb.Append("<tr>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref001.Equals("") ? cnXpath.CnVideoHref001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref001).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc001.Equals("")?cnXpath.CnVideoSrc001:doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc001).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title001 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref002.Equals("") ? cnXpath.CnVideoHref002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref002).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc002.Equals("") ? cnXpath.CnVideoSrc002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc002).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title002 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref003.Equals("") ? cnXpath.CnVideoHref003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref003).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc003.Equals("") ? cnXpath.CnVideoSrc003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc003).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title003 + "\"/></a></td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref001.Equals("") ? cnXpath.CnVideoHref001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref001).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title001 + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref002.Equals("") ? cnXpath.CnVideoHref002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref002).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title002 + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref003.Equals("") ? cnXpath.CnVideoHref003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref003).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title003 + "</font></a></td>");
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref004.Equals("") ? cnXpath.CnVideoHref004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref004).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc004.Equals("") ? cnXpath.CnVideoSrc004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc004).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title004 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref005.Equals("") ? cnXpath.CnVideoHref005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref005).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc005.Equals("") ? cnXpath.CnVideoSrc005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc005).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title005 + "\"/></a></td>");
            if (cnXpath.CnVideoHref006.Equals(""))
            {
                sb.Append("<td>&nbsp;</td>");
            }
            else
            {
                sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref006.Equals("") ? cnXpath.CnVideoHref006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref006).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc006.Equals("") ? cnXpath.CnVideoSrc006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc006).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title006 + "\"/></a></td>");

            }
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref004.Equals("") ? cnXpath.CnVideoHref004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref004).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title004 + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref005.Equals("") ? cnXpath.CnVideoHref005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref005).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title005 + "</font></a></td>");
            if (cnXpath.CnVideoHref006.Equals(""))
            {
                sb.Append("<td>&nbsp;</td>");
            }
            else
            {
                sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref006.Equals("") ? cnXpath.CnVideoHref006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref006).Attributes["href"].Value) + "\" target=\"_blank\"><font size='2'  color='#003399'>" + title006 + "</font></a></td>");
            }
            sb.Append("</tr>");
            sb.Append("</table>");
            sb.Append("</body></html>");

            if (!System.IO.File.Exists(System.Configuration.ConfigurationSettings.AppSettings["CreateHtmlPath"].ToString() + htmlname + ".html"))
            {
                System.IO.File.Create(System.Configuration.ConfigurationSettings.AppSettings["CreateHtmlPath"].ToString() + htmlname + ".html");
            }
            StreamWriter sw = new StreamWriter(System.Configuration.ConfigurationSettings.AppSettings["CreateHtmlPath"].ToString() + htmlname + ".html");
            sw.Write(sb.ToString());
            sw.Close();
            System.Threading.Thread.Sleep(1000);
        }
        public string GetWebImagesXml(CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath, string title, string alt, string src, string hrefpath, string srcpath, string htmlname,int bid,out int id)
        {
            WebClient wc = new WebClient
            {
                Encoding = Encoding.GetEncoding(cnXpath.CnWebEncode)
            };
            string html = wc.DownloadString(cnXpath.CnWebUrl);

            //string html = "";
            //System.IO.StreamReader sr = new System.IO.StreamReader("D:\\CnInterface\\CnWeb\\html\\buildhtml.txt", Encoding.GetEncoding("gb2312"));
            //lock (sr)
            //{
            //    html = sr.ReadToEnd();
            //    sr.Close();
            //}
            HtmlDocument doc = new HtmlDocument();
            doc.LoadHtml(html);
            string title001 = "";
            string title002 = "";
            string title003 = "";
            string title004 = "";
            string title005 = "";
            string title006 = "";
            if (!title.Equals("") && alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["title"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["title"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["title"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["title"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["title"].Value;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["title"].Value;
            }
            else if (title.Equals("") && !alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["alt"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["alt"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["alt"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["alt"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["alt"].Value;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["alt"].Value;
            }
            else
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).InnerText;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).InnerText;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).InnerText;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).InnerText;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).InnerText;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).InnerText;
            }
            HtmlToText ht = new HtmlToText();
            title001 = ht.ConvertHtml(title001).Trim();
            title002 = ht.ConvertHtml(title002).Trim();
            title003 = ht.ConvertHtml(title003).Trim();
            title004 = ht.ConvertHtml(title004).Trim();
            title005 = ht.ConvertHtml(title005).Trim();
            title006 = ht.ConvertHtml(title006).Trim();

            string code = htmlname.Replace("Videos", "");
            htmlname = GetWebInfoByCode(code, 0);
            string weburl = GetWebInfoByCode(code, 1);
            StringBuilder sb = new StringBuilder();
               // int id = 0;
            //第一条
            bid++;
            sb.Append("<img id=\"" + bid + "\">");
            sb.Append("<web>" + htmlname + "</web>");
            sb.Append("<title>" + title001 + "</title>");
            sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref001.Equals("") ? cnXpath.CnVideoHref001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref001).Attributes["href"].Value).Replace("&", "$") + "</url>");
            sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc001.Equals("") ? cnXpath.CnVideoSrc001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc001).Attributes[src].Value).Replace("&", "$") + "</src>");
            sb.Append("<weburl>" + weburl + "</weburl>");
            sb.Append("</img>");
            //第二条
            bid++;
            sb.Append("<img id=\"" + bid + "\">");
            sb.Append("<web>" + htmlname + "</web>");
            sb.Append("<title>" + title002 + "</title>");
            sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref002.Equals("") ? cnXpath.CnVideoHref002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref002).Attributes["href"].Value).Replace("&", "$") + "</url>");
            sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc002.Equals("") ? cnXpath.CnVideoSrc002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc002).Attributes[src].Value).Replace("&", "$") + "</src>");
            sb.Append("<weburl>" + weburl + "</weburl>");
            sb.Append("</img>");
            //第三条
            bid++;
            sb.Append("<img id=\"" + bid + "\">");
            sb.Append("<web>" + htmlname + "</web>");
            sb.Append("<title>" + title003 + "</title>");
            sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref003.Equals("") ? cnXpath.CnVideoHref003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref003).Attributes["href"].Value).Replace("&", "$") + "</url>");
            sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc003.Equals("") ? cnXpath.CnVideoSrc003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc003).Attributes[src].Value).Replace("&", "$") + "</src>");
            sb.Append("<weburl>" + weburl + "</weburl>");
            sb.Append("</img>");
            //第四条
            bid++;
            sb.Append("<img id=\"" + bid + "\">");
            sb.Append("<web>" + htmlname + "</web>");
            sb.Append("<title>" + title004 + "</title>");
            sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref004.Equals("") ? cnXpath.CnVideoHref004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref004).Attributes["href"].Value).Replace("&", "$") + "</url>");
            sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc004.Equals("") ? cnXpath.CnVideoSrc004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc004).Attributes[src].Value).Replace("&", "$") + "</src>");
            sb.Append("<weburl>" + weburl + "</weburl>");
            sb.Append("</img>");
            //第五条
            bid++;
            sb.Append("<img id=\"" + bid + "\">");
            sb.Append("<web>" + htmlname + "</web>");
            sb.Append("<title>" + title005 + "</title>");
            sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref005.Equals("") ? cnXpath.CnVideoHref005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref005).Attributes["href"].Value).Replace("&", "$") + "</url>");
            sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc005.Equals("") ? cnXpath.CnVideoSrc005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc005).Attributes[src].Value).Replace("&", "$") + "</src>");
            sb.Append("<weburl>" + weburl + "</weburl>");
            sb.Append("</img>");
            //第六条
            if (!cnXpath.CnVideoHref006.Equals(""))
            {
                bid++;
                sb.Append("<img id=\"" + bid + "\">");
                sb.Append("<web>" + htmlname + "</web>");
                sb.Append("<title>" + title006 + "</title>");
                sb.Append("<url>" + hrefpath + (cnXpath.CnVideoHref006.Equals("") ? cnXpath.CnVideoHref006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref006).Attributes["href"].Value).Replace("&", "$") + "</url>");
                sb.Append("<src>" + srcpath + (cnXpath.CnVideoSrc006.Equals("") ? cnXpath.CnVideoSrc006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc006).Attributes[src].Value).Replace("&", "$") + "</src>");
                sb.Append("<weburl>" + weburl + "</weburl>");
                sb.Append("</img>");
            }
            id = bid;

            return sb.ToString();
        }
示例#5
0
        public string GetWebVideoHtml(CnDataAcess.Entity.CnInterfaceVideoXpath cnXpath, string title, string alt, string src, string hrefpath, string srcpath)
        {
            WebClient wc = new WebClient
            {
                Encoding = Encoding.GetEncoding(cnXpath.CnWebEncode)
            };
            string html = wc.DownloadString(cnXpath.CnWebUrl);

            //string html = "";
            //System.IO.StreamReader sr = new System.IO.StreamReader(System.Configuration.ConfigurationSettings.AppSettings["CreateHtmlPath"].ToString()+ "buildhtml.txt", Encoding.GetEncoding("gb2312"));
            //lock (sr)
            //{
            //    html = sr.ReadToEnd();
            //    sr.Close();
            //}
            HtmlDocument doc = new HtmlDocument();
            doc.LoadHtml(html);
            string title001 = "";
            string title002 = "";
            string title003 = "";
            string title004 = "";
            string title005 = "";
            string title006 = "";
            if (!title.Equals("") && alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["title"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["title"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["title"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["title"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["title"].Value;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["title"].Value;
            }
            else if (title.Equals("") && !alt.Equals(""))
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).Attributes["alt"].Value;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).Attributes["alt"].Value;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).Attributes["alt"].Value;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).Attributes["alt"].Value;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).Attributes["alt"].Value;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).Attributes["alt"].Value;
            }
            else
            {
                title001 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle001).InnerText;
                title002 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle002).InnerText;
                title003 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle003).InnerText;
                title004 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle004).InnerText;
                title005 = doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle005).InnerText;
                title006 = cnXpath.CnVideoTitle006.Equals("") ? cnXpath.CnVideoTitle006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoTitle006).InnerText;
            }
            StringBuilder sb = new StringBuilder();
            sb.Append("<table border=\"0\" cellpadding =\"2\" cellspacing =\"4\"   width=\"100%\" >");
            sb.Append("<tr align=\"center\">");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref001.Equals("") ? cnXpath.CnVideoHref001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref001).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc001.Equals("") ? cnXpath.CnVideoSrc001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc001).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title001 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref002.Equals("") ? cnXpath.CnVideoHref002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref002).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc002.Equals("") ? cnXpath.CnVideoSrc002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc002).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title002 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref003.Equals("") ? cnXpath.CnVideoHref003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref003).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc003.Equals("") ? cnXpath.CnVideoSrc003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc003).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title003 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref004.Equals("") ? cnXpath.CnVideoHref004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref004).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc004.Equals("") ? cnXpath.CnVideoSrc004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc004).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title004 + "\"/></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref005.Equals("") ? cnXpath.CnVideoHref005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref005).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc005.Equals("") ? cnXpath.CnVideoSrc005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc005).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title005 + "\"/></a></td>");
            if (cnXpath.CnVideoHref006.Equals(""))
            {
                sb.Append("<td>&nbsp;</td>");
            }
            else
            {
                sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref006.Equals("") ? cnXpath.CnVideoHref006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref006).Attributes["href"].Value) + "\" target=\"_blank\"><img border=\"0\"  src=\"" + srcpath + (cnXpath.CnVideoSrc006.Equals("") ? cnXpath.CnVideoSrc006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoSrc006).Attributes[src].Value) + "\" width=\"130px\" height=\"88px\" alt=\"" + title006 + "\"/></a></td>");

            }
            sb.Append("</tr>");
            sb.Append("<tr>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref001.Equals("") ? cnXpath.CnVideoHref001 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref001).Attributes["href"].Value) + "\" target=\"_blank\"  title=\""+title001+"\"><font size='2'  color='#003399'>" + getStr(title001,20) + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref002.Equals("") ? cnXpath.CnVideoHref002 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref002).Attributes["href"].Value) + "\" target=\"_blank\"  title=\"" + title002 + "\"><font size='2'  color='#003399'>" + getStr(title002,20) + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref003.Equals("") ? cnXpath.CnVideoHref003 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref003).Attributes["href"].Value) + "\" target=\"_blank\"  title=\"" + title003 + "\"><font size='2'  color='#003399'>" + getStr(title003, 20) + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref004.Equals("") ? cnXpath.CnVideoHref004 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref004).Attributes["href"].Value) + "\" target=\"_blank\"  title=\"" + title004 + "\"><font size='2'  color='#003399'>" + getStr(title004, 20) + "</font></a></td>");
            sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref005.Equals("") ? cnXpath.CnVideoHref005 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref005).Attributes["href"].Value) + "\" target=\"_blank\"  title=\"" + title005 + "\"><font size='2'  color='#003399'>" + getStr(title005, 20) + "</font></a></td>");
            if (cnXpath.CnVideoHref006.Equals(""))
            {
                sb.Append("<td>&nbsp;</td>");
            }
            else
            {
                sb.Append(" <td><a href=\"" + hrefpath + (cnXpath.CnVideoHref006.Equals("") ? cnXpath.CnVideoHref006 : doc.DocumentNode.SelectSingleNode(cnXpath.CnVideoHref006).Attributes["href"].Value) + "\" target=\"_blank\"  title=\"" + title006 + "\"><font size='2'  color='#003399'>" + getStr(title006, 20) + "</font></a></td>");
            }
            sb.Append("</tr>");
            sb.Append("</table>");

            return sb.ToString();
        }