private void InitDataSource()
{
ClassRoomEntities ClassRoomEntities = new ClassRoomEntities();
CollectionViewSource articlesViewSource = ((CollectionViewSource)(this.FindResource("articlesViewSource")));
articlesViewSource.Source = ClassRoomEntities.Articles.Execute(System.Data.Objects.MergeOption.AppendOnly);
}
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());
}
}
