/// <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));
}
