/// <summary>
/// 删除公告信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteBulletinBoard(int id)
{
using (Entities db = new Entities())
{
base_articles article = db.base_articles.FirstOrDefault(t => t.id == id);
if (article != null)
{
article.status = 1;
}
return(db.SaveChanges());
}
}
/// <summary>
/// 新增公告
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddBulletinBoard(BulletinBoardModel model)
{
using (Entities db = new Entities())
{
base_articles article = new base_articles();
article.author = model.author;
article.content = model.content;
article.createtime = model.createtime;
article.createuserid = model.createuserid;
article.seq = model.seq;
article.title = model.title;
article.status = 0; //0：未删除 1：删除
article.filename = model.filename;
article.filepath = model.filepath;
article.filesize = model.filesize;
db.base_articles.Add(article);
return(db.SaveChanges());
}
}
/// <summary>
/// 编辑公告
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditBulletinBoard(BulletinBoardModel model)
{
using (Entities db = new Entities())
{
base_articles article = db.base_articles.Find(model.id);
if (article != null)
{
article.author = model.author;
article.content = model.content;
article.seq = model.seq;
article.title = model.title;
article.createtime = DateTime.Now;
if (model.filename != null && model.filepath != null)
{
//删除替换之前的附件
if (System.IO.File.Exists(article.filepath))
{
System.IO.File.Delete(article.filepath);
}
article.filename = model.filename;
article.filepath = model.filepath;
article.filesize = model.filesize;
}
if (model.filename == null && model.filepath == null && article.filename != null && article.filepath != null)
{
//删除附件
if (System.IO.File.Exists(article.filepath))
{
System.IO.File.Delete(article.filepath);
}
article.filepath = null;
article.filename = null;
article.filesize = null;
}
return(db.SaveChanges());
}
else
{
return(0);
}
}
}
/// <summary>
/// 查看公告详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public BulletinBoardModel ViewBulletinBoard(int id)
{
BulletinBoardModel model = new BulletinBoardModel();
using (Entities db = new Entities())
{
base_articles article = db.base_articles.FirstOrDefault(t => t.id == id);
if (article != null)
{
model.id = article.id;
model.author = article.author;
model.content = article.content;
model.createtime = article.createtime;
model.createuserid = article.createuserid;
model.filename = article.filename;
model.filepath = article.filepath;
model.filesize = article.filesize;
model.seq = article.seq;
model.status = article.status;
model.title = article.title;
}
return(model);
}
}
