public static void Add(string category, string txt, string imageFileName) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { if (en.KBs.Any(x => x.Category == category && x.Txt == txt)) { MessageBox.Show("文本和以前的重复,请修改后再添加!"); return; } KB kb = new KB(); kb.Category = category; kb.Txt = txt; kb.Pic = File.ReadAllBytes(imageFileName); en.KBs.Add(kb); en.SaveChanges(); } MessageBox.Show("添加成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static List <string> GetTxtUnderCategory(string category) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { return(en.KBs.Where(x => x.Category == category).Select(x => x.Txt).Distinct().ToList()); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(new List <string>()); } }
public static KB GetKBByTxt(string txt) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { return(en.KBs.First(x => x.Txt == txt)); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
public static KB GetKnowledge(int id) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { KB kb = en.KBs.First(x => x.ID == id); return(kb); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
public static bool DeleteKBById(int id) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { KB kb = en.KBs.First(x => x.ID == id); en.KBs.Remove(kb); en.SaveChanges(); } MessageBox.Show("删除成功"); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public static bool Update(int id, string category, string txt, string imageFileName) { try { using (KnowledgeEntities en = new KnowledgeEntities()) { KB kb = en.KBs.First(x => x.ID == id); kb.Category = category; kb.Txt = txt; if (!string.IsNullOrWhiteSpace(imageFileName)) { kb.Pic = File.ReadAllBytes(imageFileName); } en.SaveChanges(); } MessageBox.Show("修改成功!"); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }