void Bind()
        {
            intArticleId      = Basic.RequestHelper.GetQueryInt("articleid", 0);
            intProfessionalId = Basic.RequestHelper.GetQueryInt("professionalid", 0);

            Entity.Professional infoSP = DAL.Professional.ProfessionalEntityGet(intProfessionalId);
            if (infoSP != null)
            {
                strProfessionalName               = infoSP.ProfessionalName;//专业名称
                ProfessionalBase1.info            = infoSP;
                ProfessionalLeft1.ProfessionalId  = infoSP.Id;
                ProfessionalLeft1.XueKeMenLeiName = infoSP.XueKeMenLeiName;

                Crumb1.NavString = " <span>&gt;</span> <a href=\"/zhuanye.shtml\" title\"高考报考专业库\">高考报考专业库</a> <span>&gt;</span> <a href=\"/zhuanye-jianjie-" + infoSP.Id + ".shtml\" title\"" + infoSP.ProfessionalName + "\">" + infoSP.ProfessionalName + "</a> <span>&gt;</span> <a href=\"/zhuanye-bianxi-" + infoSP.Id + ".shtml\" title\"" + infoSP.ProfessionalName + "专业辨析\">专业辨析</a>";

                Entity.Article info = DAL.Article.ArticleEntityGet(intArticleId);
                if (info != null)
                {
                    Crumb1.NavString += " <span>&gt;</span> " + info.Title;

                    strPageTitle    = info.Title;//标题
                    ltlTitle.Text   = info.Title;
                    ltlContent.Text = info.Content;
                }
                else
                {
                    Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
                }
            }
            else
            {
                Basic.MsgHelper.AlertBackMsg("获取专业信息失败");
            }
        }
예제 #2
0
        protected void Article_Submit_Click(object sender, EventArgs e)
        {
            e_Article = b_Article.Select_Article(g_Article_ClassID, Convert.ToInt32(Article_LanguageID.SelectedValue));

            e_Article.Article_Content = Article_Content.Value;
            b_Article.Update_Article(e_Article.Article_ID, e_Article.Article_ClassID, e_Article.Article_LanguageID, e_Article.Article_Content);

            ResponseSuccess("修改成功", "Article.aspx?Article_ClassID=" + e_Article.Article_ClassID);
        }
예제 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            b_Article = new BLL.Article();

            if (!IsPostBack)
            {
                GetArticleTXT(Article_Name);
                SetLanguageControl(Article_LanguageID);
                e_Article = b_Article.Select_Article(g_Article_ClassID, Convert.ToInt32(Article_LanguageID.SelectedValue));
                Article_Content.Value = e_Article.Article_Content;
            }
        }
예제 #4
0
 public async Task CreateOrEditAsync(Entity.Article model)
 {
     model.TenantId = _AbpSession.TenantId ?? 0;
     if (model.Id <= 0)
     {
         model.UserId = _AbpSession.UserId ?? 0;
         await _Repository.InsertAsync(model);
     }
     else
     {
         await _Repository.UpdateAsync(model);
     }
 }
예제 #5
0
        public async Task <IActionResult> Add(long?id)
        {
            Entity.Article a = new Entity.Article();
            if (id != null)
            {
                a = await _AppService.GetByIdAsync((long)id);
            }

            var list = await _catAppService.GetCategoryDropDownList();

            ViewData.Add("Category", new Microsoft.AspNetCore.Mvc.Rendering.SelectList(list, "Id", "Title"));
            return(View(a));
        }
예제 #6
0
        public static void RebuildPages()
        {
            Pages.Clear();
            var files = System.IO.Directory.GetFiles(System.Web.HttpContext.Current.Server.MapPath("~") + "\\Pages", "*.md");

            foreach (var file in files)
            {
                var article = new Entity.Article();
                article.Title  = System.IO.Path.GetFileNameWithoutExtension(file);
                article.IsPage = true;
                Pages.Add(article);
            }
            Pages.Sort((a, b) => { return(DateTime.Compare(b.CreationTime, a.CreationTime)); });
        }
예제 #7
0
 public static void RebuildArticles()
 {
     Articles.Clear();
     var files = System.IO.Directory.GetFiles(System.Web.HttpContext.Current.Server.MapPath("~") + "\\Articles", "*.md");
     foreach (var file in files)
     {
         var article = new Entity.Article();
         article.Title = System.IO.Path.GetFileNameWithoutExtension(file);
         Articles.Add(article);
     }
     Articles.Sort((a, b) => { return DateTime.Compare(b.CreationTime, a.CreationTime); });
     try
     {
         Begin = Articles[Articles.Count() - 1].CreationTime;
         End = Articles[0].CreationTime;
     }
     catch { }
 }
예제 #8
0
        public static void RebuildArticles()
        {
            Articles.Clear();
            var files = System.IO.Directory.GetFiles(System.Web.HttpContext.Current.Server.MapPath("~") + "\\Articles", "*.md");

            foreach (var file in files)
            {
                var article = new Entity.Article();
                article.Title = System.IO.Path.GetFileNameWithoutExtension(file);
                Articles.Add(article);
            }
            Articles.Sort((a, b) => { return(DateTime.Compare(b.CreationTime, a.CreationTime)); });
            try
            {
                Begin = Articles[Articles.Count() - 1].CreationTime;
                End   = Articles[0].CreationTime;
            }
            catch { }
        }
예제 #9
0
 public static void Pop(Entity.Article article)
 {
     System.IO.File.Delete(article.Directory);
     if (!article.IsPage)
     {
         Articles.RemoveAt(Articles.FindIndex(x => x.Title == article.Title));
         try
         {
             Site.Category = null;
             Begin         = Articles[Articles.Count() - 1].CreationTime;
             End           = Articles[0].CreationTime;
         }
         catch { }
     }
     else
     {
         Pages.RemoveAt(Pages.FindIndex(x => x.Title == article.Title));
     }
 }
예제 #10
0
 public static void Push(Entity.Article article)
 {
     article.Save();
     if (article.IsPage)
     {
         Pages.Add(article);
         Pages.Sort((a, b) => { return(DateTime.Compare(b.CreationTime, a.CreationTime)); });
     }
     else
     {
         Articles.Add(article);
         Articles.Sort((a, b) => { return(DateTime.Compare(b.CreationTime, a.CreationTime)); });
     }
     Dal.ArticleDao.Rebuild();
     try
     {
         Site.Category = null;
         Begin         = Articles[Articles.Count() - 1].CreationTime;
         End           = Articles[0].CreationTime;
     }
     catch { }
 }
예제 #11
0
        public static Entity.Article ArticleEntityGetByProfessionalId(int ProfessionalId)
        {
            Entity.Article info = new Entity.Article();
            DataTable      dt   = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [Article] WHERE CategoryId = 2 AND  ProfessionalId = " + ProfessionalId + ";").Tables[0];

            if (dt.Rows.Count > 0)
            {
                info.Id              = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
                info.CategoryId      = Basic.Utils.StrToInt(dt.Rows[0]["CategoryId"].ToString(), 0);
                info.Icon            = dt.Rows[0]["Icon"].ToString();
                info.Title           = dt.Rows[0]["Title"].ToString();
                info.ShortTitle      = dt.Rows[0]["ShortTitle"].ToString();
                info.MetaTitle       = dt.Rows[0]["MetaTitle"].ToString();
                info.MetaKeyWords    = dt.Rows[0]["MetaKeyWords"].ToString();
                info.MetaDescription = dt.Rows[0]["MetaDescription"].ToString();
                info.Summary         = dt.Rows[0]["Summary"].ToString();
                info.Content         = dt.Rows[0]["Content"].ToString();
                info.IsPause         = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
                info.IsTuiJian       = Basic.Utils.StrToInt(dt.Rows[0]["IsTuiJian"].ToString(), 0);
                info.IsNew           = Basic.Utils.StrToInt(dt.Rows[0]["IsNew"].ToString(), 0);
                info.IsZhiDing       = Basic.Utils.StrToInt(dt.Rows[0]["IsZhiDing"].ToString(), 0);
                info.AddWid          = Basic.Utils.StrToInt(dt.Rows[0]["AddWid"].ToString(), 0);
                info.IsCheck         = Basic.Utils.StrToInt(dt.Rows[0]["IsCheck"].ToString(), 0);
                info.CheckWid        = Basic.Utils.StrToInt(dt.Rows[0]["CheckWid"].ToString(), 0);
                info.ClickNum        = Basic.Utils.StrToInt(dt.Rows[0]["ClickNum"].ToString(), 0);
                info.AddTime         = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString());
                info.CheckTime       = Basic.Utils.StrToDateTime(dt.Rows[0]["CheckTime"].ToString());
                info.PublishTime     = Basic.Utils.StrToDateTime(dt.Rows[0]["PublishTime"].ToString());
                info.ZhiDingTime     = Basic.Utils.StrToDateTime(dt.Rows[0]["ZhiDingTime"].ToString());

                return(info);
            }
            else
            {
                return(null);
            }
        }
예제 #12
0
 /// <summary>
 /// UpdateArticle
 /// </summary>
 /// <param name="aricle"></param>
 /// <returns></returns>
 public int UpdateArticle(Entity.Article aricle)
 {
     try
     {
         int code = -1;
         using (SqlConnection connection = new SqlConnection(connectString))
         {
             connection.Open();
             using (SqlCommand cmd = new SqlCommand())
             {
                 cmd.CommandTimeout = Constants.TIMOUT_CONNECT_SQL;
                 cmd.Connection     = connection;
                 cmd.CommandType    = CommandType.StoredProcedure;
                 cmd.CommandText    = "sp_UpdateArticle";
                 cmd.Parameters.Add("@ArticleId", SqlDbType.BigInt);
                 cmd.Parameters["@ArticleId"].Value = aricle.id;
                 cmd.Parameters.Add("@CategoryTags", SqlDbType.VarChar, 250);
                 cmd.Parameters["@CategoryTags"].Value = aricle.categoriesTags;
                 cmd.Parameters.Add("@Title", SqlDbType.NVarChar, 150);
                 cmd.Parameters["@Title"].Value = aricle.title;
                 cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 1000);
                 cmd.Parameters["@Description"].Value = aricle.description;
                 cmd.Parameters.Add("@Product_Specifications", SqlDbType.NVarChar, 2000);
                 cmd.Parameters["@Product_Specifications"].Value = aricle.product_Specifications;
                 cmd.Parameters.Add("@Body", SqlDbType.NVarChar, -1);
                 cmd.Parameters["@Body"].Value = aricle.body;
                 cmd.Parameters.Add("@ProductId", SqlDbType.VarChar, 50);
                 cmd.Parameters["@ProductId"].Value = aricle.productCode;
                 cmd.Parameters.Add("@Images", SqlDbType.VarChar, 4000);
                 cmd.Parameters["@Images"].Value = aricle.images;
                 cmd.Parameters.Add("@Videos", SqlDbType.VarChar, 4000);
                 cmd.Parameters["@Videos"].Value = aricle.videos;
                 cmd.Parameters.Add("@Author", SqlDbType.NVarChar, 50);
                 cmd.Parameters["@Author"].Value = aricle.author;
                 cmd.Parameters.Add("@Quote", SqlDbType.NVarChar, 100);
                 cmd.Parameters["@Quote"].Value = aricle.quote;
                 cmd.Parameters.Add("@Tags", SqlDbType.NVarChar, 250);
                 cmd.Parameters["@Tags"].Value = aricle.tags;
                 cmd.Parameters.Add("@Link", SqlDbType.VarChar, 50);
                 cmd.Parameters["@Link"].Value = aricle.link != null ? aricle.link : "";
                 cmd.Parameters.Add("@MetaKeywords", SqlDbType.NVarChar, 250);
                 cmd.Parameters["@MetaKeywords"].Value = aricle.metaKeyword;
                 cmd.Parameters.Add("@MetaDescription", SqlDbType.NVarChar, 250);
                 cmd.Parameters["@MetaDescription"].Value = aricle.metaDescription;
                 cmd.Parameters.Add("@DatePublish", SqlDbType.NVarChar, 20);
                 cmd.Parameters["@DatePublish"].Value = aricle.datePublish;
                 cmd.Parameters.Add("@Status", SqlDbType.TinyInt);
                 cmd.Parameters["@Status"].Value = aricle.status;
                 cmd.Parameters.Add("@AccountId", SqlDbType.Int);
                 cmd.Parameters["@AccountId"].Value = aricle.accountId;
                 cmd.Parameters.Add("@PublisherId", SqlDbType.Int);
                 cmd.Parameters["@PublisherId"].Value = aricle.publisherId;
                 cmd.Parameters.Add("@Key", SqlDbType.VarChar, 100);
                 cmd.Parameters["@Key"].Value = Lib.Constants.KEY_SQL;
                 cmd.Parameters.Add("@Code", SqlDbType.Int);
                 cmd.Parameters["@Code"].Direction = ParameterDirection.Output;
                 cmd.ExecuteNonQuery();
                 code = int.Parse(cmd.Parameters["@Code"].Value.ToString());
             }
         }
         return(code);
     }
     catch (Exception ex)
     {
         Lib.Logs.SaveError("ERROR UpdateArticle: " + ex);
         throw new Exception("lỗi: " + ex.Message);
     }
 }
예제 #13
0
 public static void RebuildPages()
 {
     Pages.Clear();
     var files = System.IO.Directory.GetFiles(System.Web.HttpContext.Current.Server.MapPath("~") + "\\Pages", "*.md");
     foreach (var file in files)
     {
         var article = new Entity.Article();
         article.Title = System.IO.Path.GetFileNameWithoutExtension(file);
         article.IsPage = true;
         Pages.Add(article);
     }
     Pages.Sort((a, b) => { return DateTime.Compare(b.CreationTime, a.CreationTime); });
 }
예제 #14
0
        private bool DoAdd()
        {
            bool result = true;

            BLL.ArticleBll bll = new BLL.ArticleBll();
            Entity.Article model = new Entity.Article();

            model.ChannelID = this.channel_id;
            model.Title = txtTitle.Text.Trim();

            model.LinkURL = txtLinkUrl.Text.Trim();
            model.ImageURL = txtImgUrl.Text.Trim();

            model.SortID = int.Parse(txtSortId.Text.Trim());
            model.ClickCount = int.Parse(txtClick.Text.Trim());
            model.Content = txtContent.Value;

            model.IsRecommend = 0;
            model.IsHot = 0;

            if (cblItem.Items[0].Selected == true)
            {
                model.IsRecommend = 1;
            }

            if (bll.Add(model) < 1)
            {
                result = false;
            }
            return result;
        }
예제 #15
0
 protected void Article_LanguageID_SelectedIndexChanged(object sender, EventArgs e)
 {
     e_Article = b_Article.Select_Article(g_Article_ClassID, Convert.ToInt32(Article_LanguageID.SelectedValue));
     Article_Content.Value = e_Article.Article_Content;
 }