//从文件中添加图片 public static void AddEmoji(Emoji emoji) { //席诺&马草原 try { using (var db = new EmojiContext()) { string src = emoji.Path; string filename = Path.GetFileName(src); string dest = @"D:\projects\.netprojects\DouTu\test\" + filename; //File.Copy(src, dest); //string pLocalFilePath = "";//要复制的文件路径 // string pSaveFilePath = "";//指定存储的路径 if (File.Exists(src)) //必须判断要复制的文件是否存在 { File.Copy(src, dest, true); //三个参数分别是源文件路径,存储路径,若存储路径有相同文件是否替换 } emoji.Path = dest; db.Emojis.Add(emoji); db.SaveChanges(); } } catch (Exception e) { } }
//返回数据库中为收藏的表情 马草原 public static List <Emoji> FavoriteEmoji() { using (var db = new EmojiContext()) { var query = AllEmojis(db).Where(emo => emo.IsFavorite == true); return(query.ToList()); } }
public static List <Emoji> GetAllEmojis() { using (var db = new EmojiContext()) { var query = AllEmojis(db).ToList(); return(query); } }
//根据表情热度进行排序的结果 马草原 public static List <Emoji> SortbyFrequency() { using (var db = new EmojiContext()) { var query = AllEmojis(db).ToList(); query.Sort(); return(query); } }
//按目标人群搜索 public static List <Emoji> SearchByTargetPeople(string info) { //张智敏&马草原 using (var db = new EmojiContext()) { var query = AllEmojis(db) .Where(e => e.TargetPeople == info); return(query.ToList()); } }
//这个是一个综合的搜索,先空着 public static List <Emoji> SearchEmoji(string info) { //张智敏&马草原 using (var db = new EmojiContext()) { var query = AllEmojis(db) .Where(e => e.Keyword == info); return(query.ToList()); } }
//Frequency++ 蒋沁月 public static void FrequencyPlus(Emoji e) { using (var db = new EmojiContext()) { var query = db.Emojis.Where(o => o.Id == e.Id); foreach (Emoji ee in query) { ee.Frequency++; } db.SaveChanges(); } }
//因为要用所以我先写了 蒋沁月 public static void ModifyEmoji(Emoji e, string key, string target, string series) { using (var db = new EmojiContext()) { var query = db.Emojis.Where(o => o.Id == e.Id); foreach (Emoji ee in query) { ee.Keyword = key; ee.TargetPeople = target; ee.Series = series; } db.SaveChanges(); } }
//导出表情 public static void ExportEmoji(List <Emoji> emojis) { using (var db = new EmojiContext()) { var queary = db.Emojis; foreach (Emoji ee in queary) { if (ee.Path != null) { try { string src = ee.Path; string filename = Path.GetFileName(src); string dest = @"..\..\..\Export\" + filename; if (File.Exists(src)) //必须判断要复制的文件是否存在 { File.Copy(src, dest, true); //三个参数分别是源文件路径,存储路径,若存储路径有相同文件是否替换 } ee.Path = dest; } catch (Exception ep) { } } } } using (var db = new EmojiContext()) { try { using (System.IO.StringWriter stringWriter = new StringWriter(new StringBuilder())) { XmlSerializer xmlSerializer = new XmlSerializer(typeof(List <Emoji>)); xmlSerializer.Serialize(stringWriter, emojis); FileStream fs = new FileStream("export.xml", FileMode.OpenOrCreate); StreamWriter sw = new StreamWriter(fs); sw.Write(stringWriter.ToString()); sw.Close(); fs.Close(); MessageBox.Show("导出文件成功!"); string src = @"..\..\..\EmojiForm\bin\Debug\export.xml"; string filename = Path.GetFileName(src); string dest = @"..\..\..\Export\" + filename; File.Copy(src, dest, true); } } catch (System.Exception ex) { } } }
//通过路径判断数据库中是否存在当前表情。马草原 public static bool Emojiexist(string path) { using (var db = new EmojiContext()) { var queary = db.Emojis.Where(o => o.Path == path); if (queary == null) { return(false);//不存在返回false } else { return(true); } } }
public static void DeleteEmoji() { //张智敏&马草原 try { using (var db = new EmojiContext()) { } } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"删除订单错误!"); } }
//这个是一个综合的搜索,先空着 public static List <Emoji> SearchEmoji(string info) { //张智敏&马草原 using (var db = new EmojiContext()) { var query1 = AllEmojis(db) .Where(e => e.Keyword == info); var query2 = AllEmojis(db) .Where(e => e.Series == info); var query3 = AllEmojis(db) .Where(e => e.TargetPeople == info); var query = query1.Concat(query2); query = query.Concat(query3); return(query.ToList()); } }
public static void DeleteNull() { using (var db = new EmojiContext()) { var query = db.Emojis.Where(o => o.Id == null || o.IsFavorite == null || o.Path == "" || o.Keyword == null); foreach (Emoji e in query) { db.Emojis.Remove(e); } foreach (Emoji e in db.Emojis) { Console.WriteLine(e); } db.SaveChanges(); } }
//按系列搜索 public static List <Emoji> SearchBySeries(string info) { //张智敏&马草原 if (info == "全部") { using (var db = new EmojiContext()) { var query = AllEmojis(db); return(query.ToList()); } } using (var db = new EmojiContext()) { var query = AllEmojis(db) .Where(e => e.Series.Contains(info)); return(query.ToList()); } }
/// <summary> /// 修改IsFavorite,参数i为0改为true,参数i为1改为false /// 蒋沁月 /// </summary> public static void ModifyIsFavorite(Emoji e, int i) { using (var db = new EmojiContext()) { var query = db.Emojis.Where(o => o.Id == e.Id); foreach (Emoji ee in query) { if (i == 0) { ee.IsFavorite = true; } else if (i == 1) { ee.IsFavorite = false; } } db.SaveChanges(); } }
public static void DeleteEmoji(Emoji emoji) { //张智敏&马草原 try { using (var db = new EmojiContext()) { var query = db.Emojis.Where(o => o.Id == emoji.Id); foreach (Emoji ee in query) { db.Emojis.Remove(ee); } db.SaveChanges(); } } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"删除订单错误!"); } }
//从文件中添加图片 public static void AddEmoji(Emoji emoji) { //席诺&马草原 try { using (var db = new EmojiContext()) { //拷贝图片到指定文件夹 string picPath = emoji.Path;//这里记得传入图片的路径,通过可视化操作选中图片传参,参数记得改一下奥席诺同学 string filename = Path.GetFileName(picPath); string str = System.Environment.CurrentDirectory; string targetPath = @"str" + filename; //在数据库里添加这个表情的信息 db.Emojis.Add(emoji); db.SaveChanges(); } return; } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 //throw new ApplicationException($"添加错误: {e.Message}"); } }
//返回所有表情 马草原 public static IQueryable <Emoji> AllEmojis(EmojiContext db) { return(db.Emojis); }