private void btnSaveArticle_Click(object sender, RoutedEventArgs e)
{
//if (_documentManager.SaveDocument())
//{
// MessageBox.Show("保存成功！");
//}
//TextRange range = new TextRange(body.Document.ContentStart, body.Document.ContentEnd);
Article article = new Article();
article.ArticleTitle = tbArticleTitle.Text;
article.ArticleContent = rtbArticleBody.RTF();
//article.AUserID = ClassRoom.Common.TicketInfo.UserNO;
article.AUserID = 4;
article.UploadTime = DateTime.Now;
ClassRoomEntities entities = new ClassRoomEntities();
try
{
entities.Articles.AddObject(article);
int result =entities.SaveChanges();
if (result > 0)
MessageBox.Show("保存成功");
}
catch (Exception ee)
{
throw ee.InnerException;
}
}
//public NoteBLL()
//{
// try
// {
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.InnerException.ToString());
// }
//}
public List<NoteView> GetUserNotes(int ID)
{
List<NoteView> noteList = new List<NoteView>();
try
{
using (ClassRoomEntities entities = new ClassRoomEntities())
{
var notes = from m in entities.Notes
where m.NUserID == ID
select m;
List<Note> list = notes.ToList();
list.ForEach(m =>
{
NoteView view = new NoteView ();
Note entityInfo = view.Clone(m);
view.Clone(m);
noteList.Add(view);
});
}
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.ToString());
}
return noteList;
}
public List<Class> GetClasses()
{
ClassRoomEntities entities = new ClassRoomEntities();
var query = from c in entities.Classes
select c;
return query.ToList();
}
public User GetUser(int iD)
{
ClassRoomEntities entities = new ClassRoomEntities();
var u = from m in entities.Users
where m.UserID == Common.UserTicket.UserInfo.UserID
select m;
return u.FirstOrDefault();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
InitDataSource();
try
{
entities = new ClassRoomEntities();
var articles = from m in entities.Articles
where m.User.UserID == 4
select m;
Article article = articles.ToList().Last();
this.ArticleItems.ItemsSource = articles.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.ToString());
}
}
private void InitDataSource()
{
ClassRoomEntities ClassRoomEntities = new ClassRoomEntities();
CollectionViewSource articlesViewSource = ((CollectionViewSource)(this.FindResource("articlesViewSource")));
articlesViewSource.Source = ClassRoomEntities.Articles.Execute(System.Data.Objects.MergeOption.AppendOnly);
}
