/// <summary>
/// 增加单个实体
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <int> Add(T entity)
{
using (var db = new SGT_RFID_BaseContext())
{
db.Add(entity);
return(await db.SaveChangesAsync());
}
}
/// <summary>
/// 增加或修改集合，根据指定的条件查找对象是否存在，如存在则修改，否则新增
/// </summary>
/// <param name="list"></param>
/// <param name="selectKey"></param>
/// <param name="updateKey"></param>
/// <param name="defDate"></param>
/// <returns></returns>
public async Task <int> AddUpdateAsync(List <T> list, string[] selectKey, string[] updateKey, string[] defDate)
{
using (SGT_RFID_BaseContext db = new SGT_RFID_BaseContext())
{
try
{
foreach (var current in list)
{
var t = db.Set <T>().Where(EfUtils.And <T>(selectKey, current)).FirstOrDefault <T>();
if (t == null)
{
foreach (var def in defDate)
{
current.GetType().GetProperty(def).SetValue(current, DateTime.Now, null);
}
db.Set <T>().Add(current);
}
else
{
foreach (var k in updateKey)
{
if (k.Equals("UpdateTime"))
{
t.GetType().GetProperty(k).SetValue(t, DateTime.Now, null);
}
else
{
var value = current.GetType().GetProperty(k).GetValue(current, null);
t.GetType().GetProperty(k).SetValue(t, value, null);
}
}
db.Set <T>().Attach(t);
db.Entry <T>(t).State = EntityState.Modified;
}
}
return(await db.SaveChangesAsync());
}
catch (Exception ex)
{
var msg = string.Concat(new object[]
{
"Message：",
ex.Message,
"。 Source:",
ex.Source,
"。 InnerException：",
ex.InnerException
});
return(-22);
}
}
}
/// <summary>
/// 根据指定条件获取集合
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public async Task <T> GetAsync(Expression <Func <T, bool> > predicate)
{
using (SGT_RFID_BaseContext db = new SGT_RFID_BaseContext())
{
if (predicate == null)
{
return(null);
}
return(await db.Set <T>().Where(predicate).FirstOrDefaultAsync <T>());
}
}
/// <summary>
/// 根据指定条件获取单个实体
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public async Task <List <T> > GetAllAsync(Expression <Func <T, bool> > predicate)
{
using (SGT_RFID_BaseContext db = new SGT_RFID_BaseContext())
{
if (predicate == null)
{
return(await db.Set <T>().ToListAsync());
}
return(await db.Set <T>().Where(predicate).ToListAsync());
}
}