/// <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 (DafujianContext db = new DafujianContext())
{
try
{
foreach (var current in list)
{
var t = await db.Set <T>().Where(EfUtils.And <T>(selectKey, current)).FirstOrDefaultAsync <T>();
if (t == null)
{
foreach (var def in defDate)
{
current.GetType().GetProperty(def).SetValue(current, DateTime.Now, null);
}
current.GetType().GetProperty("IsDelete").SetValue(current, 0, 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,
"。 TargetSite:",
ex.TargetSite,
"。 InnerException：",
ex.InnerException
});
Error.WriteLog("Repository-AddUpdateAsync-01", msg);
return(-22);
}
}
}
public void Dispose(bool disposing)
{
if (!isDisposed && disposing)
{
if (db2 != null)
{
db2.Dispose();
db2 = null;
}
}
isDisposed = true;
}
public async Task <T> GetAsync(Expression <Func <T, bool> > predicate)
{
using (DafujianContext db = new DafujianContext())
{
if (predicate == null)
{
return(null);
}
return(await db.Set <T>().Where(predicate).FirstOrDefaultAsync <T>());
}
}
public DataTable QueryByTablde(string sql)
{
using (DafujianContext db = new DafujianContext())
{
var conn = new SqlConnection();
conn = (SqlConnection)db.Database.Connection;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
adapter.Fill(table);
conn.Close();//连接需要关闭
conn.Dispose();
return(table);
}
}
/// <summary>
/// 业务删除
/// </summary>
/// <param name="predicate"></param>
/// <returns></returns>
public async Task <int> DeleteVirtualAsync(Guid[] ids, string idKey)
{
using (DafujianContext db = new DafujianContext())
{
try
{
foreach (var id in ids)
{
var model = await db.Set <T>().Where(EfUtils.AndByGuid <T>(idKey, id)).FirstOrDefaultAsync <T>();
if (model == null)
{
continue;
}
model.GetType().GetProperty("UpdateTime").SetValue(model, DateTime.Now, null);
model.GetType().GetProperty("IsDelete").SetValue(model, 99, null);
db.Set <T>().Attach(model);
db.Entry <T>(model).State = EntityState.Modified;
}
return(await db.SaveChangesAsync());
}
catch (Exception ex)
{
var msg = string.Concat(new object[]
{
"Message：",
ex.Message,
"。 Source:",
ex.Source,
"。 TargetSite:",
ex.TargetSite,
"。 InnerException：",
ex.InnerException
});
Error.WriteLog("Repository-DeleteVirtualAsync-01", msg);
return(-22);
}
}
}
