예제 #1
0
        public static bool MainProc(string search, string keyword, string input)
        {
            bool use = false;

            string title     = "";
            string titleText = "";
            string titleLink = "";
            string remark    = "";

            getReg(search, ref title, ref titleText, ref titleLink, ref remark);

            //标题
            Regex           r = new Regex(title, RegexOptions.IgnoreCase);
            MatchCollection matchCollection = r.Matches(input);
            //简介
            string          abstractReg        = remark;
            MatchCollection abstractCollection = Regex.Matches(input, abstractReg, RegexOptions.IgnoreCase);

            for (int i = 0; i < abstractCollection.Count; i++)
            {
                Match  m           = abstractCollection[i];
                string abstractStr = StringHelp.ReplaceHtmlTag(m.Value.Replace("'", ""));
                if (m.Success && ruleJudge(abstractStr, keyword))
                {
                    //标题
                    string          textReg             = titleText;
                    MatchCollection textMatchCollection = Regex.Matches(matchCollection[i].Value, textReg, RegexOptions.IgnoreCase);
                    Match           match2   = textMatchCollection[0];
                    string          titleStr = "";
                    if (match2.Success)
                    {
                        titleStr = StringHelp.ReplaceHtmlTag(match2.Result("$1"));
                    }
                    //标题链接
                    string          LinkReg             = titleLink;
                    MatchCollection linkMatchCollection = Regex.Matches(matchCollection[i].Value, LinkReg, RegexOptions.IgnoreCase);
                    Match           match3       = linkMatchCollection[0];
                    string          titleLinkStr = "";
                    if (match3.Success)
                    {
                        titleLinkStr = match3.Value.Replace("<a href=", "").Replace("\"", "");
                    }

                    #region 创建采集对象
                    TelCollection tel = new TelCollection();
                    tel.Search    = search;
                    tel.Telphone  = keyword;
                    tel.Title     = titleStr;
                    tel.TitleLink = titleLinkStr;
                    tel.Abstract  = abstractStr;
                    #endregion
                    StringHelp.WriteExcel(tel);
                    use = true;
                    break;
                }
            }
            return(use);
        }
예제 #2
0
파일: StringHelp.cs 프로젝트: zhangvs/-
        //public static IFont font = newhssfworkbook.CreateFont();//创建字体样式
        //public static ICellStyle style = newhssfworkbook.CreateCellStyle();//创建单元格样式

        public static void WriteExcel(TelCollection tel)
        {
            #region 设置字体
            font.Color = NPOI.HSSF.Util.HSSFColor.Blue.Index; //设置字体颜色
            style.SetFont(font);                              //设置单元格样式中的字体样式
            #endregion


            //默认数据行
            var newrow = newsheet.CreateRow(newsheet.LastRowNum + 1);//创建新行
            //搜索引擎
            var newcell0 = newrow.CreateCell(0);
            newcell0.SetCellValue(tel.Search);

            #region 号码
            var newcell1 = newrow.CreateCell(1);
            newcell1.SetCellValue(tel.Telphone);                       //手机号
            //设置号码超链接
            HSSFHyperlink link = new HSSFHyperlink(HyperlinkType.Url); //建一个HSSFHyperlink实体,指明链接类型为URL(这里是枚举,可以根据需求自行更改)
            if (tel.Search == "360")
            {
                link.Address = Reg360.url + tel.Telphone;//给HSSFHyperlink的地址赋值
            }
            else
            {
                link.Address = RegBaidu.url + tel.Telphone;
            }
            newcell1.Hyperlink = link;  //将链接方式赋值给单元格的Hyperlink即可将链接附加到单元格上
            //超链接字体
            newcell1.CellStyle = style; //为单元格设置显示样式
            #endregion


            #region 标题
            var newcell2 = newrow.CreateCell(2);
            newcell2.SetCellValue(tel.Title);                               //标题
            //设置标题超链接
            HSSFHyperlink titleLink = new HSSFHyperlink(HyperlinkType.Url); //建一个HSSFHyperlink实体,指明链接类型为URL(这里是枚举,可以根据需求自行更改)
            titleLink.Address  = tel.TitleLink;                             //给HSSFHyperlink的地址赋值
            newcell2.Hyperlink = titleLink;                                 //将链接方式赋值给单元格的Hyperlink即可将链接附加到单元格上
            //设置字体
            newcell2.CellStyle = style;                                     //为单元格设置显示样式
            #endregion

            //简介
            var newcell3 = newrow.CreateCell(3);
            newcell3.SetCellValue(tel.Abstract);

            Object locker = new Object();
            lock (locker)
            {
                try
                {
                    FileStream fs = File.OpenWrite(filePathOut);
                    newhssfworkbook.Write(fs);   //向打开的这个xls文件中写入表并保存。
                    fs.Close();
                }
                catch (Exception ex)
                {
                    StringHelp.Write(StringHelp.pathError, ex.Message + tel.Telphone + "\r\n");
                    System.Threading.Thread.Sleep(1 * 1000);
                    WriteExcel(tel);
                    StringHelp.Write(StringHelp.pathError, tel.Telphone + "重新执行\r\n");
                }
            }
        }