Example #1
0
        static void SaveNewsPaper2(string connectionString, Newspaper newsPaper)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                return;
            }
            if (newsPaper.ArticleTitle.StartsWith("AD.", true, System.Globalization.CultureInfo.CurrentCulture))
            {
                log.Error("广告新闻不导入:" + newsPaper.ArticleTitle);
                return;
            }

            try
            {
                Regex          regex     = new Regex(@"<br\s*\/?>", RegexOptions.IgnoreCase);
                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@ArticleTitle", regex.Replace(newsPaper.ArticleTitle, "")),                                    //新闻标题
                    new SqlParameter("@ReporterName", newsPaper.Author),                                                             //专栏作家名称
                    new SqlParameter("@SourceName", newsPaper.Name),                                                                 // 来源
                    new SqlParameter("@ArticleThumb", GetNewsThumb(newsPaper.Materials, newsPaper.PeriodDate.ToString("yyyyMMdd"))), //新闻封面图
                    new SqlParameter("@ArticleLength", GetBodyLength(newsPaper.Content)),                                            //新闻长度,文字新闻=字数,图集=图片张数,视频=时长单位秒
                    new SqlParameter("@ArticleNotes", GetNewsNote(newsPaper.Content)),                                               //编者按
                    new SqlParameter("@ArticleBody", removeEmptyStr(newsPaper.Content)),                                             //新闻正文:如果是文字新闻 = 新闻正文   如果是图集 = 图集内图片json  如果是视频 = 视频播放地址
                };

                SqlHelper.ExecteNonQuery(connectionString, System.Data.CommandType.StoredProcedure, "Store_Articles_CreateImport", sqlParams);
            }
            catch (Exception e)
            {
                string dataSource = connectionString.Split(';')[0];
                log.Error(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
                Console.WriteLine(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
            }
        }
Example #2
0
        static void SaveNewsPaper(string connectionString, Newspaper newsPaper)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                return;
            }
            try
            {
                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@NewsType", 1),                                                                             // 新闻类型:1=文字新闻,2=图集,3=视频,5=文字新闻跳链,6=图集跳链,7=视频跳链,8=专题跳链,9=外链
                    new SqlParameter("@NewsTitle", newsPaper.ArticleTitle),                                                       //新闻标题
                    new SqlParameter("@TerminalID", 4),                                                                           //产品端编号:1=一财新媒体APP,4=日报IPAD
                    new SqlParameter("@ChannelRoot", GetChannelRootId(newsPaper.Edition)),                                        //产品端栏目组编号  (如116	A叠)
                    new SqlParameter("@ChannelID", GetSubChannelId(newsPaper.Edition)),                                           //产品端子栏目编号   (如119	A01_第A01版:头版)
                    new SqlParameter("@AdminID", Convert.ToInt32(ConfigurationManager.AppSettings["AdminId"])),                   //发布新闻的编辑ID:10197=胡志新
                    new SqlParameter("@AdminName", ConfigurationManager.AppSettings["AdminName"]),                                //发布新闻的编辑姓名:还是用胡志新吧
                    new SqlParameter("@Categorys", ""),                                                                           //新闻领域,比如“钢铁、房地产、银行”等
                    new SqlParameter("@SourceName", newsPaper.Name),                                                              //来源媒体名称
                    new SqlParameter("@ExpertName", newsPaper.Author),                                                            //专栏作家名称
                    new SqlParameter("@ProgramName", ""),                                                                         //细分的节目名称,如“谈股论金”,为了方便以后按节目汇总调取视频用
                    new SqlParameter("@NewsWeight", System.Data.SqlDbType.Int, 4),                                                //权重
                    new SqlParameter("@NewsLength", GetBodyLength(newsPaper.Content)),                                            //新闻长度,文字新闻=字数,图集=图片张数,视频=时长单位秒
                    new SqlParameter("@Tags", ""),                                                                                //新闻特殊标签,如APP用到的“独家”特殊字样
                    new SqlParameter("@NewsSigns", newsPaper.Author),                                                             //新闻署名
                    new SqlParameter("@NewsNotes", GetNewsNote(newsPaper.Content)),                                               //编者按
                    new SqlParameter("@NewsThumb", GetNewsThumb(newsPaper.Materials, newsPaper.PeriodDate.ToString("yyyyMMdd"))), //新闻封面图
                    new SqlParameter("@ThumbNotes", GetThumbNotes(newsPaper.Materials)),                                          //新闻封面图图说,就是封面图配的文字
                    new SqlParameter("@NewsProvince", -1),                                                                        //省份,默认 -1=未选择
                    new SqlParameter("@StockCode", ""),                                                                           //股票代码,如“600123”
                    new SqlParameter("@Keywords", ""),                                                                            //关键字,如“我擦 牛叉”,用空格分割每个关键词
                    new SqlParameter("@NewsBody", removeEmptyStr(newsPaper.Content)),                                             //新闻正文:如果是文字新闻 = 新闻正文   如果是图集 = 图集内图片json  如果是视频 = 视频播放地址
                    new SqlParameter("@NewsParaStr", ""),                                                                         //备用字段,现在没用
                    new SqlParameter("@NewsParaInt", ""),                                                                         //备用字段,现在没用
                    new SqlParameter("@OuterURL", ""),                                                                            //外链地址,必须以http:// 开头,如果新闻有外链地址,那么在页面或APP打开新闻时会直接打开该地址访问
                    new SqlParameter("@PushState", System.Data.SqlDbType.Int, 4),                                                 //推送状态,暂时没用,默认=0即可
                    new SqlParameter("@IsPub", newsPaper.IsPublish == 2),                                                         //是否发布状态,即是否能被产品接口获取到
                    new SqlParameter("@PartnerID", 100),                                                                          //100=第一财经
                    new SqlParameter("@EBookEvents", newsPaper.PeriodDate.ToString("yyyyMMdd")),                                  //期次
                    new SqlParameter("@EBookParas", newsPaper.ArticleTitle.Contains("导读") ? "1" : "0")                            //电子报类型0:原始状态 1 导读
                };
                sqlParams[11].Value = 0;
                sqlParams[25].Value = 0;

                SqlHelper.ExecteNonQuery(connectionString, System.Data.CommandType.StoredProcedure, "Pub_News_ImportNews", sqlParams);
                //SqlHelper.ExecteNonQueryProducts("Pub_News_ImportNews", sqlParams);
            }
            catch (Exception e)
            {
                string dataSource = connectionString.Split(';')[0];
                log.Error(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
                Console.WriteLine(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
            }
        }
Example #3
0
        static void SaveNewsPaper2(string connectionString, Newspaper newsPaper)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                return;
            }
            if (newsPaper.ArticleTitle.StartsWith("AD.", true, System.Globalization.CultureInfo.CurrentCulture))
            {
                log.Error("广告新闻不导入:" + newsPaper.ArticleTitle);
                return;
            }

            try
            {
                Regex regex = new Regex(@"<br\s*\/?>", RegexOptions.IgnoreCase);
                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@ArticleTitle",regex.Replace(newsPaper.ArticleTitle,"")),//新闻标题
                    new SqlParameter("@ReporterName",newsPaper.Author),//专栏作家名称
                    new SqlParameter("@SourceName",newsPaper.Name),// 来源
                    new SqlParameter("@ArticleThumb",GetNewsThumb(newsPaper.Materials,newsPaper.PeriodDate.ToString("yyyyMMdd"))),//新闻封面图
                    new SqlParameter("@ArticleLength",GetBodyLength(newsPaper.Content)),//新闻长度,文字新闻=字数,图集=图片张数,视频=时长单位秒
                    new SqlParameter("@ArticleNotes",GetNewsNote(newsPaper.Content)),//编者按
                    new SqlParameter("@ArticleBody",removeEmptyStr(newsPaper.Content)),//新闻正文:如果是文字新闻 = 新闻正文   如果是图集 = 图集内图片json  如果是视频 = 视频播放地址
                };

                SqlHelper.ExecteNonQuery(connectionString, System.Data.CommandType.StoredProcedure, "Store_Articles_CreateImport", sqlParams);
            }
            catch (Exception e)
            {
                string dataSource = connectionString.Split(';')[0];
                log.Error(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
                Console.WriteLine(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
            }
        }
Example #4
0
        static void SaveNewsPaper(string connectionString, Newspaper newsPaper)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                return;
            }
            try
            {
                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@NewsType",1),// 新闻类型:1=文字新闻,2=图集,3=视频,5=文字新闻跳链,6=图集跳链,7=视频跳链,8=专题跳链,9=外链
                    new SqlParameter("@NewsTitle",newsPaper.ArticleTitle),//新闻标题
                    new SqlParameter("@TerminalID",4),//产品端编号:1=一财新媒体APP,4=日报IPAD
                    new SqlParameter("@ChannelRoot",GetChannelRootId(newsPaper.Edition)),//产品端栏目组编号  (如116	A叠)
                    new SqlParameter("@ChannelID",GetSubChannelId(newsPaper.Edition)),//产品端子栏目编号   (如119	A01_第A01版:头版)
                    new SqlParameter("@AdminID", Convert.ToInt32(ConfigurationManager.AppSettings["AdminId"])),//发布新闻的编辑ID:10197=胡志新
                    new SqlParameter("@AdminName",ConfigurationManager.AppSettings["AdminName"]),//发布新闻的编辑姓名:还是用胡志新吧
                    new SqlParameter("@Categorys",""),//新闻领域,比如“钢铁、房地产、银行”等
                    new SqlParameter("@SourceName",newsPaper.Name),//来源媒体名称
                    new SqlParameter("@ExpertName",newsPaper.Author),//专栏作家名称
                    new SqlParameter("@ProgramName",""),//细分的节目名称,如“谈股论金”,为了方便以后按节目汇总调取视频用
                    new SqlParameter("@NewsWeight",System.Data.SqlDbType.Int,4),//权重
                    new SqlParameter("@NewsLength", GetBodyLength(newsPaper.Content)),//新闻长度,文字新闻=字数,图集=图片张数,视频=时长单位秒
                    new SqlParameter("@Tags","") ,//新闻特殊标签,如APP用到的“独家”特殊字样
                    new SqlParameter("@NewsSigns",newsPaper.Author),//新闻署名
                    new SqlParameter("@NewsNotes",GetNewsNote(newsPaper.Content)),//编者按
                    new SqlParameter("@NewsThumb",GetNewsThumb(newsPaper.Materials,newsPaper.PeriodDate.ToString("yyyyMMdd"))),//新闻封面图
                    new SqlParameter("@ThumbNotes",GetThumbNotes(newsPaper.Materials)),//新闻封面图图说,就是封面图配的文字
                    new SqlParameter("@NewsProvince",-1),//省份,默认 -1=未选择
                    new SqlParameter("@StockCode",""),//股票代码,如“600123”
                    new SqlParameter("@Keywords",""),//关键字,如“我擦 牛叉”,用空格分割每个关键词
                    new SqlParameter("@NewsBody",removeEmptyStr(newsPaper.Content)),//新闻正文:如果是文字新闻 = 新闻正文   如果是图集 = 图集内图片json  如果是视频 = 视频播放地址
                    new SqlParameter("@NewsParaStr",""),//备用字段,现在没用
                    new SqlParameter("@NewsParaInt",""),//备用字段,现在没用
                    new SqlParameter("@OuterURL",""),//外链地址,必须以http:// 开头,如果新闻有外链地址,那么在页面或APP打开新闻时会直接打开该地址访问
                    new SqlParameter("@PushState",System.Data.SqlDbType.Int,4),//推送状态,暂时没用,默认=0即可
                    new SqlParameter("@IsPub",newsPaper.IsPublish == 2),//是否发布状态,即是否能被产品接口获取到
                    new SqlParameter("@PartnerID",100),//100=第一财经
                    new SqlParameter("@EBookEvents",newsPaper.PeriodDate.ToString("yyyyMMdd")),//期次
                    new SqlParameter("@EBookParas",newsPaper.ArticleTitle.Contains("导读") ? "1" : "0")//电子报类型0:原始状态 1 导读
                };
                sqlParams[11].Value = 0;
                sqlParams[25].Value = 0;

                SqlHelper.ExecteNonQuery(connectionString, System.Data.CommandType.StoredProcedure, "Pub_News_ImportNews", sqlParams);
                //SqlHelper.ExecteNonQueryProducts("Pub_News_ImportNews", sqlParams);
            }
            catch (Exception e)
            {
                string dataSource = connectionString.Split(';')[0];
                log.Error(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
                Console.WriteLine(string.Format("服务器:{0} 导入版面:{1} 时出错:{2}", dataSource, newsPaper.Edition, e.ToString()));
            }
        }