//从文件中添加图片
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) { }
}
//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 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();
}
}
/// <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}");
}
}