/// <summary>
/// 绑定正则表达式列表，根据网站
/// </summary>
/// <param name="site"></param>
public void BindRegularList(Site site)
{
using (RegularDAL dal = new RegularDAL())
{
regularList = dal.GetRegularList(site);
}
//清理原来数据
lv_ExpressionList.Items.Clear();
lv_ExpressionList.Columns.Clear();
//初始化listview的列头
UIHelper.InitListView(lv_ExpressionList, "正则表达式", "文章类型");
try
{
foreach (var item in regularList)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = item.Name;
lvi.SubItems.Add(item.Type.Name);
lvi.Name = item.ID.ToString();
lv_ExpressionList.Items.Add(lvi);
}
}
catch (Exception)
{
throw;
}
}
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;
}
}
/// <summary>
/// 初始化数据库数据
/// </summary>
public ACSDbContext()
{
if (!this.Database.Exists())
{
this.Database.Create();
Site site = new Site()
{
ID = Guid.NewGuid(),
Address = "http://www.jrkz.com",
Name = "金融客栈"
};
this.Sites.Add(site);
Type type = new Type() {
ID = Guid.NewGuid(),
Name = "时事"
};
this.Articles.Add(new Article()
{
ID = Guid.NewGuid(),
Title = "hehe",
Time = DateTime.Now,
Site = site,
Content = "hehehee",
Type = type
});
this.Regulars.Add(new Regular
{
ID = Guid.NewGuid(),
Name = @"<h1[\s\S]*?</h1>",
Site = site,
Type = type
});
// 记住要保存
this.SaveChanges();
}
}
private void btn_SiteAdd_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txt_NewSiteName.Text) && !String.IsNullOrEmpty(txt_NewSiteAddress.Text))
{
using (SiteDAL dal = new SiteDAL())
{
if (dal.GetSite(txt_NewSiteName.Text)==null)
{
Site site = new Entities.Site()
{
ID = Guid.NewGuid(),
Address = txt_NewSiteAddress.Text.Trim(),
Name = txt_NewSiteName.Text
};
if (dal.AddSite(site))
{
siteList.Add(site);
BindSiteList();
MessageBox.Show("添加网站成功！");
}
else
{
MessageBox.Show("添加失败！");
}
}
else
{
MessageBox.Show("此网站已存在！");
}
}
}
else
{
MessageBox.Show("请添加完整信息！");
}
}
/// <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;
}
}