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); }