/// <summary>
/// 根据网站名获取一个网站
/// 如果存在这样的网站则返回Site对象，如果不存在则返回Null
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public Site GetSite(string name)
{
Site site = null;
try
{
using (ACSDbContext db = new ACSDbContext ())
{
site = db.Sites.Where(s => s.Name == name).FirstOrDefault();
}
return site;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取名字为name的文章类型
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public szosi.ArticleCollectSystem.Entities.Type GetType(string name)
{
szosi.ArticleCollectSystem.Entities.Type type = null;
try
{
using (ACSDbContext db = new ACSDbContext())
{
type = db.Types.Where(t => t.Name == name).FirstOrDefault();
}
return type;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 删除一个文章
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public bool DelArticle(Article article)
{
try
{
using (ACSDbContext db = new ACSDbContext ())
{
db.Articles.Attach(article);
db.Articles.Remove(article);
db.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
private bool disposedValue = false; // 要检测冗余调用
#endregion Fields
#region Methods
/// <summary>
/// 添加一个新网站
/// </summary>
/// <param name="site"></param>
/// <returns></returns>
public bool AddSite(Site site)
{
try
{
using (ACSDbContext db = new ACSDbContext())
{
db.Sites.Attach(site);
db.Sites.Add(site);
db.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
private bool disposedValue = false; // 要检测冗余调用
#endregion Fields
#region Methods
/// <summary>
/// 添加一个文章类型对象
/// </summary>
/// <param name="type"></param>
/// <returns>返回是否添加成功</returns>
public bool AddType(szosi.ArticleCollectSystem.Entities.Type type)
{
try
{
using (ACSDbContext db = new ACSDbContext ())
{
db.Types.Attach(type);
db.Types.Add(type);
db.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// 获取所有的文章列表
/// 按时间排序
/// </summary>
/// <returns></returns>
public List<Article> GetArticleList()
{
List<Article> articleList = null;
try
{
using (ACSDbContext db = new ACSDbContext())
{
//
//当要生成外键实体时 查询的时候加上.Include(a=>a.外键实体名)即可
//在使用.include()时，要记得using System.Data.Entity;
articleList =
db.Articles.Include(a => a.Site).Include(a=>a.Type)
.OrderByDescending(a => a.Time).ToList();
}
return articleList;
}
catch (Exception)
{
throw;
}
}
public bool UpdateArticle(Article article)
{
try
{
using (ACSDbContext db = new ACSDbContext())
{
DbEntityEntry<Article> entry = db.Entry<Article>(article);
entry.State = EntityState.Unchanged;
entry.Property("Title").IsModified = true;
entry.Property("Content").IsModified = true;
entry.Property("Time").IsModified = true;
db.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// 获取网站列表
/// </summary>
/// <returns></returns>
public List<Site> GetSiteList()
{
List<Site> siteList = null;
try
{
using (ACSDbContext db = new ACSDbContext ())
{
siteList = db.Sites.ToList();
}
return siteList;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 更新网站地址
/// </summary>
/// <param name="site"></param>
/// <param name="address"></param>
/// <returns></returns>
public bool UpdateSiteAddress(Site site, string address)
{
try
{
site.Address = address;
// 这种更新数据的方法不用先查询，直接修改
using (ACSDbContext db = new ACSDbContext())
{
DbEntityEntry<Site> entry = db.Entry<Site>(site);
entry.State = EntityState.Unchanged;
entry.Property("Address").IsModified = true;
db.SaveChanges();
}
return true;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获得类型列表
/// </summary>
/// <returns></returns>
public List<szosi.ArticleCollectSystem.Entities.Type> GetTypeList()
{
List<szosi.ArticleCollectSystem.Entities.Type> typeList = null;
try
{
using (ACSDbContext db = new ACSDbContext ())
{
typeList = db.Types.ToList();
}
return typeList;
}
catch (Exception)
{
throw;
}
}
