/// <summary> /// Create an Article and insert it in the DB /// </summary> /// <param name="blogID">Id of the blog containing the T_Article.</param> /// <param name="mediaUrl">Link to the media includes into the article, or text if the media is a quote.</param> /// <param name="mediaTypeId">Type of the media.</param> /// <param name="text">A caption for the media, or the content of the article if there is no media.</param> /// <param name="tags">The tags, separated by a space</param> /// <returns>Nothing</returns> public static void Create(long blogID, String mediaUrl, long mediaTypeId, String text, String tags) { T_Article article = new T_Article() { BlogId = blogID, MediaUrl = mediaUrl, MediaTypeId = mediaTypeId, Text = text, CreationDate = DateTime.Now }; List <T_Tag> newtags = new List <T_Tag>(); if (!String.IsNullOrEmpty(tags)) { string[] tabTags = tags.Split(new Char[] { ' ' }); foreach (string tag in tabTags) { newtags.Add(new T_Tag() { Name = tag }); } } ArticleCRUD.CreateAndAddTags(article, newtags); }
public JsonResult Edit(T_Article edit) { string s = Session["userName"].ToString(); if (edit.Id == 0) { edit.PublishTime = System.DateTime.Now.ToString(); edit.userName = s; edit.PublishName = user.GetLists(a => a.UserName == s)[0].UserPet; if (article.Add(edit)) { return(Json(new { msg = "添加成功", success = true })); } else { return(Json(new { msg = "添加失败", success = false })); } } else { if (article.Updata(edit)) { return(Json(new { msg = "修改成功", success = true })); } else { return(Json(new { msg = "修改失败", success = false })); } } }
protected void btn_Click(object sender, EventArgs e) { string id = Request["id"] ?? "00000000"; T_Article model = new T_Article(); model = bll.GetArticleById(id); model.ArticleId = txtid.Text.Trim();; model.ArticleTitle = title.Text.Trim(); model.ArticlePostStaff = writer.Text.Trim(); model.ArticleTime = time.Text.Trim(); model.ArticleSector = resourse.Text.Trim(); model.ArticleContent = txtcontent.Text.Trim(); if (bll.Update(model)) { Response.Write("文章内容修改成功,请关闭窗口~"); } else { Response.Write("文章内容修改失败"); } }
//心理美文 public string loadmeiwenNews() { List <T_Article> list = bll.GetListByContent(4, 5); StringBuilder sb = new StringBuilder(); foreach (T_Article model in list) { //获得文章内容的简介 T_Article first = new T_Article(); first = bll.GetArticleById(model.ArticleId); string ab = Regex.Replace(first.ArticleContent, @"<.*?>", ""); //如果文字没有超过100个字 if (ab.Length > 70) { ab = ab.Substring(0, 70); } ab = ab + "..."; //girdview,前端代码 //获得图片的地址 string imgurl = ImgHelper.getImgUrl(first.ArticleContent, @"<img[^>]+src=\s*(?:'(?<src>[^']+)'|""(?<src>[^""]+)""|(?<src>[^>\s]+))\s*[^>]*>", "src")[0].ToString(); sb.AppendFormat("<a href='articleDetail.aspx?articleId={1}' class='grid-block'><figure class='grid-item'><img src='{3}'/><figcaption><h3>{2}</h3></figcaption></figure></a>", model.ArticleContent, model.ArticleId, model.ArticleTitle, imgurl); } return(sb.ToString()); }
//根据日期时间模糊查询获取编号 public string GetIdByTime(string dateTime) { T_Article AricleModel = new T_Article(); DataTable articl = dal.GetIdByTime(dateTime); string str = null; if (articl.Rows.Count == 0) { str = dateTime + "001"; } else { AricleModel.ArticleId = articl.Rows[0]["C_ArticleId"].ToString().Trim(); int strId = Int32.Parse(AricleModel.ArticleId.Substring(8, 3)) + 1; if (strId >= 10) { str = dateTime + "0" + strId.ToString().Trim(); } else if (strId >= 100) { str = dateTime + "0" + strId.ToString().Trim(); } else { str = dateTime + "00" + strId.ToString().Trim(); } } return(str); }
//心协动态 public string loadXinxieNews() { List <T_Article> list = bll.GetListByContent(4, 3); StringBuilder sb = new StringBuilder(); foreach (T_Article model in list) { //获得文章内容的简介 T_Article first = new T_Article(); first = bll.GetArticleById(model.ArticleId); string ab = Regex.Replace(first.ArticleContent, @"<.*?>", ""); //如果文字没有超过100个字 if (ab.Length > 70) { ab = ab.Substring(0, 70); } ab = ab + "..."; //girdview,前端代码 //获得图片的地址 string imgurl = ImgHelper.getImgUrl(first.ArticleContent, @"<img[^>]+src=\s*(?:'(?<src>[^']+)'|""(?<src>[^""]+)""|(?<src>[^>\s]+))\s*[^>]*>", "src")[0].ToString(); sb.AppendFormat("<div class='newsbottom'><a href='articleDetail.aspx?articleId={2}' class='imglink'><img src='{4}'></a><a href='articleDetail.aspx?articleId={2}'><p class='newtitle'>{1}</p></a><p class='newtext'>{3}</p></div>", first.ArticleContent, first.ArticleTitle, first.ArticleId, ab, imgurl); } return(sb.ToString()); }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string articleId = bll.GetIdByTime(DateTime.Now.ToString("yyyyMMdd")); string articleTitle = context.Request.Form["txtTitle"] ?? "未设置标题".ToString(); int articleCategory = int.Parse(context.Request.Form["txtCategory"].ToString()); string articleSector = context.Request.Form["txtSector"] ?? "未设置来源".ToString(); // (context.Session["model"] as T_InfoAdmin).InfoAdminSector; int articleTopic = 0; string articleContent = context.Request.Form["txtcontent"].ToString(); string articlePostStaff = context.Request.Form["txtPostStaff"] ?? "未设置作者".ToString(); //(context.Session["model"] as T_stuplazaInfoAdmin).InfoAdminName; string articleAnnexAddr = context.Request.Form["txtAnnex"].ToString(); string articleTime = context.Request.Form["act_start_time"].ToString(); if (String.IsNullOrEmpty(articleTime.Trim())) { articleTime = DateTime.Now.ToString(); } string articleColumn = "00000000"; T_Article article = new T_Article(); article = GetModel(articleId, articleTitle, articleCategory, articleSector, articleTopic, articleContent, articlePostStaff, articleAnnexAddr, articleTime, articleColumn); bll.InsertArticle(article); context.Response.Write("文章添加成功,请关闭此窗口~"); } catch { throw; } }
public bool Updata(T_Article edit) { var ar = article.T_Article.Where(a => a.Id == edit.Id).FirstOrDefault(); ar.Title = edit.Title; ar.Content = edit.Content; return(article.SaveChanges() > 0); }
/// <summary> /// Insert /// </summary> /// <param name="article"></param> /// <returns></returns> public long Insert(T_Article article) { return(_sqlMapper.ExecuteScalar <long>(new RequestContext { Scope = "Article", SqlId = "Insert", Request = article })); }
/// <summary> /// Update /// </summary> /// <param name="article"></param> /// <returns></returns> public int Update(T_Article article) { return(_sqlMapper.Execute(new RequestContext { Scope = "Article", SqlId = "Update", Request = article })); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(T_Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Article set "); strSql.Append("C_ArticleId=@id,"); strSql.Append("C_ArticleTitle=@title,"); strSql.Append("C_ArticleSector=@sector,"); strSql.Append("C_ArticleCategory=@category,"); strSql.Append("C_ArticleTopic=@topic,"); strSql.Append("C_ArticleContent=@content,"); strSql.Append("C_ArticlePostStaff=@poststaff,"); strSql.Append("C_ArticleAnnexAddr=@annexaddr,"); strSql.Append("C_ArticleColumn=@column"); strSql.Append(" where C_ArticleId=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Char, 11), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@sector", SqlDbType.NVarChar, 40), new SqlParameter("@category", SqlDbType.Int), new SqlParameter("@topic", SqlDbType.Int), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@poststaff", SqlDbType.NVarChar, 20), new SqlParameter("@annexaddr", SqlDbType.NVarChar, 200), new SqlParameter("@column", SqlDbType.Char, 8) }; parameters[0].Value = model.ArticleId; parameters[1].Value = model.ArticleTitle; parameters[2].Value = model.ArticleSector; parameters[3].Value = model.ArticleCategory; if (model.topic != null) { parameters[4].Value = model.topic.TopicId; } else { parameters[4].Value = DBNull.Value; } parameters[5].Value = model.ArticleContent; parameters[6].Value = model.ArticlePostStaff; parameters[7].Value = model.ArticleAnnexAddr; parameters[8].Value = model.ArticleColumn; int flag = SqlHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters); if (flag > 0) { return(true); } else { return(false); } }
//public List<T_xljkArticle> GetArticleList(int i) //{ //List<T_xljkArticle> list = new List<T_xljkArticle>(); //if(i==1) //{ //string sql = "select top 3 from" ; //using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text)) //{ // if (reader.HasRows) // { // //reader.GetOrdinal("clsName"); // while (reader.Read()) // { // //Fid, FName, FAge, FGender, FMath, FEnglish, FClassId, FBirthday // MyStudent model = new MyStudent(); // model.FId = reader.GetInt32(0); // model.FName = reader.GetString(1); // model.FAge = reader.GetInt32(2); // model.FGender = reader.GetString(3); // model.FMath = reader.IsDBNull(4) ? null : (int?)reader.GetInt32(4); // model.FEnglish = reader.GetInt32(5); // model.ClassModel = new MyClass(); // model.ClassModel.ClassId = reader.GetInt32(6); // model.ClassModel.ClassName = reader.GetString(8); // model.FBirthday = reader.GetDateTime(7); // list.Add(model); // } // } //} //return list; //} /// <summary> /// 转化datarow 到文章实体 /// </summary> /// <param name="row"></param> /// <returns></returns> public T_Article DataRowToModel(DataRow row) { T_Article model = new T_Article(); if (row != null) { if (row["C_ArticleId"] != null && row["C_ArticleId"].ToString() != "") { model.ArticleId = row["C_ArticleId"].ToString(); } if (row["C_ArticleTitle"] != null) { model.ArticleTitle = row["C_ArticleTitle"].ToString(); } if (row["C_ArticleSector"] != null) { model.ArticleSector = row["C_ArticleSector"].ToString(); } if (row["C_ArticleCategory"] != null) { model.ArticleCategory = int.Parse(row["C_ArticleCategory"].ToString()); } if (row["C_ArticleContent"] != null) { model.ArticleContent = row["C_ArticleContent"].ToString(); } if (row["C_ArticleColumn"] != null && row["C_ArticleColumn"].ToString() != "") { model.ArticleColumn = row["C_ArticleColumn"].ToString(); } if (row["C_ArticleTopic"] != null && row["C_ArticleTopic"].ToString() != "") { model.topic = new T_Topic(); model.topic.TopicId = int.Parse(row["C_ArticleTopic"].ToString()); } if (row["C_ArticlePostStaff"] != null) { model.ArticlePostStaff = row["C_ArticlePostStaff"].ToString(); } if (row["C_ArticleAnnexAddr"] != null) { model.ArticleAnnexAddr = row["C_ArticleAnnexAddr"].ToString(); } else { model.ArticleAnnexAddr = ""; } if (row["C_ArticleTime"] != null) { DateTime time = DateTime.Parse(row["C_ArticleTime"].ToString()); model.ArticleTime = time.ToString("yyyy-MM-dd"); //model.ArticleTime = Convert.ToDateTime((DateTime.Parse(row["C_ArticleTime"].ToString()).ToShortDateString().ToString())); } } return(model); }
//删除 public bool Delete(int id) { var ar = new T_Article { Id = id }; article.T_Article.Attach(ar); article.T_Article.Remove(ar); return(article.SaveChanges() > 0); }
/// <summary> /// 根据id来获取文章实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public T_Article GetArticleById(string id) { SqlParameter[] sp = { new SqlParameter("@id", id) }; string sql = "select * from T_Article where C_ArticleId=@id"; T_Article model = new T_Article(); DataTable tb = SqlHelper.ExecuteDataTable(sql, CommandType.Text, sp); if (tb.Rows.Count > 0) { model = DataRowToModel(tb.Rows[0]); } return(model); }
public bool Delete(List <int> ids) { foreach (int id in ids) { var ar = new T_Article { Id = id }; article.T_Article.Attach(ar); article.T_Article.Remove(ar); } return(article.SaveChanges() > 0); }
public JsonResult Add(T_Article arcitle) { string name = Session["userName"].ToString(); arcitle.userName = name; arcitle.PublishTime = System.DateTime.Now.ToString(); arcitle.PublishName = user.GetLists(a => a.UserName == name)[0].UserPet; if (publish.Add(arcitle)) { return(Json(new { msg = "发布成功", success = true })); } else { return(Json(new { msg = "发布失败", success = false })); } }
/// <summary> /// 插入数据 /// </summary> /// <param name="model">传入model类</param> /// <returns></returns> public int Insert(T_Article model) { //C_ArticleId, C_ArticleTitle, C_ArticleSector, C_ArticleCategory, C_ArticleTopic, C_ArticleContent, C_ArticlePostStaff, C_ArticleAnnexAddr, C_ArticleTime string sql = "insert into T_Article values(@id,@title,@sector,@category,@topic,@content,@poststaff,@annexaddr,@time,@column)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@id", model.ArticleId), new SqlParameter("@title", model.ArticleTitle), new SqlParameter("@sector", model.ArticleSector), new SqlParameter("@category", model.ArticleCategory), new SqlParameter("@topic", model.topic == null?DBNull.Value:(object)model.topic.TopicId), new SqlParameter("@content", model.ArticleContent), new SqlParameter("@poststaff", model.ArticlePostStaff), new SqlParameter("@annexaddr", model.ArticleAnnexAddr), new SqlParameter("@time", model.ArticleTime), new SqlParameter("@column", model.ArticleColumn == ""?"00000000":model.ArticleColumn) }; return(SqlHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, pms)); }
public T_Article GetModel(string id, string title, int category, string sector, int topic, string content, string poststaff, string annexaddr, string time, string column) { T_Article model = new T_Article(); model.ArticleId = id; model.ArticleTitle = title; model.ArticleCategory = category; model.ArticleSector = sector; //model.topic = ""; 用不到 model.ArticleContent = content; model.ArticlePostStaff = poststaff; model.ArticleAnnexAddr = annexaddr; model.ArticleTime = time; model.ArticleColumn = column; return(model); }
public override void AfterOnLoad() { HiddenField hf_txtarea = this.Page.GetControlById <HiddenField>("hf_EditorValue"); HtmlTextArea txtarea = this.Page.GetControlById <HtmlTextArea>("editor"); if (!Page.IsPostBack) { int id = 0; if (Request["id"] != null) { Int32.TryParse(Request["id"].ToString(), out id); } T_Article model = this.Page.GenericHelper.FindById <T_Article>(id); if (model != null) { if (hf_txtarea != null && txtarea != null) { txtarea.Value = model.Content; hf_txtarea.Value = model.Content; } } } }
//中心动态,搜的都是要有图片的新闻 public string LoadToutiaoNews() { List <T_Article> list = bll.GetListByContent(5, 2); StringBuilder sb = new StringBuilder(); int i = 0; foreach (var model in list) { //获得文章内容的简介 T_Article first = new T_Article(); first = bll.GetArticleById(model.ArticleId); string ab = Regex.Replace(first.ArticleContent, @"<.*?>", ""); //如果文字没有超过100个字 if (ab.Length > 70) { ab = ab.Substring(0, 70); } ab = ab + "..."; if (i == 0) { //第一张提取图片 //精简文章主题内容 string imgurl = ImgHelper.getImgUrl(first.ArticleContent, @"<img[^>]+src=\s*(?:'(?<src>[^']+)'|""(?<src>[^""]+)""|(?<src>[^>\s]+))\s*[^>]*>", "src")[0].ToString(); sb.AppendFormat("<a href='articleDetail.aspx?articleId={0}'><img src='{1}'/></a><h3>{2}</h3><p>{3}</p>", model.ArticleId, imgurl, model.ArticleTitle, ab); sb.AppendFormat("</div><div class='newsright'>"); } else { sb.AppendFormat("<a href='articleDetail.aspx?articleId={0}'> <p class='nrtitle'>{1}</p></a><p class='nrtxt' style='font-size:0.84vw;'>{2}</p>", model.ArticleId, model.ArticleTitle, ab); } i++; } return(sb.ToString()); }
public bool Update([FromBody] T_Article article) { return(_articleDataAccess.Update(article) > 0); }
public T_Article Add([FromBody] T_Article article) { article.Id = _articleDataAccess.Insert(article); return(article); }
public bool Updata(T_Article edit) { return(article.Updata(edit)); }
//增加 public bool Add(T_Article a) { return(article.Add(a)); }
public bool Add(T_Article a) { return(publish.Add(a)); }
//增加 public bool Add(T_Article a) { article.T_Article.Add(a); return(article.SaveChanges() > 0); }
//根据栏目id获取文章list集合 public List <T_Article> GetListByColId(string columnid) { DataTable tb = new DataTable(); tb = dal.GetListByColId(columnid); List <T_Article> list = new List <T_Article>(); if (tb.Rows.Count > 0) { for (int i = 0; i < tb.Rows.Count; i++) { T_Article model = new T_Article(); if (tb.Rows[i]["C_ArticleId"] != null && tb.Rows[i]["C_ArticleId"].ToString() != "") { model.ArticleId = tb.Rows[i]["C_ArticleId"].ToString(); } if (tb.Rows[i]["C_ArticleTitle"] != null) { model.ArticleTitle = tb.Rows[i]["C_ArticleTitle"].ToString(); } if (tb.Rows[i]["C_ArticleSector"] != null) { model.ArticleSector = tb.Rows[i]["C_ArticleSector"].ToString(); } if (tb.Rows[i]["C_ArticleCategory"] != null) { model.ArticleCategory = int.Parse(tb.Rows[i]["C_ArticleCategory"].ToString()); } if (tb.Rows[i]["C_ArticleContent"] != null) { model.ArticleContent = tb.Rows[i]["C_ArticleContent"].ToString(); } if (tb.Rows[i]["C_ArticleColumn"] != null && tb.Rows[i]["C_ArticleColumn"].ToString() != "") { model.ArticleColumn = tb.Rows[i]["C_ArticleColumn"].ToString(); } if (tb.Rows[i]["C_ArticleTopic"] != null && tb.Rows[i]["C_ArticleTopic"].ToString() != "") { model.topic = new T_Topic(); model.topic.TopicId = int.Parse(tb.Rows[i]["C_ArticleTopic"].ToString()); } if (tb.Rows[i]["C_ArticlePostStaff"] != null) { model.ArticlePostStaff = tb.Rows[i]["C_ArticlePostStaff"].ToString(); } if (tb.Rows[i]["C_ArticleAnnexAddr"] != null) { model.ArticleAnnexAddr = tb.Rows[i]["C_ArticleAnnexAddr"].ToString(); } model.ArticleAnnexAddr = "0"; if (tb.Rows[i]["C_ArticleTime"] != null) { DateTime time = DateTime.Parse(tb.Rows[i]["C_ArticleTime"].ToString()); model.ArticleTime = time.ToString("yyyy-MM-dd"); //model.ArticleTime = Convert.ToDateTime((DateTime.Parse(row["C_ArticleTime"].ToString()).ToShortDateString().ToString())); } list.Add(model); } } return(list); }
public bool Update([FromBody] T_Article article) { return(_articleRepository.Update(article) > 0); }
/// <summary> /// 业务逻辑层添加model方法 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertArticle(T_Article model) { ArticleDAL dal = new ArticleDAL(); return(dal.Insert(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(T_Article model) { return(dal.Update(model)); }