/// <summary>
/// 查找指定主键的实体记录
/// </summary>
/// <param name="key"> 指定主键 </param>
/// <returns> 符合编号的记录，不存在返回null </returns>
public virtual TEntity GetByKey(object key)
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
return(Set <TEntity>(ctx).Find(key));
}
}
/// <summary>
/// 批量添加
/// </summary>
/// <typeparam name="TEntity"> 要注册的类型 </typeparam>
/// <param name="entities"> 要注册的对象集合 </param>
public virtual OperationResult AddNew <TEntity>(IEnumerable <TEntity> entities) where TEntity : EntityBase
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
EntityState state;
//不跟踪变化，提高效率
ctx.Configuration.AutoDetectChangesEnabled = false;
foreach (TEntity entity in entities)
{
state = ctx.Entry(entity).State;
if (state == EntityState.Detached)
{
ctx.Entry(entity).State = EntityState.Added;
}
}
ctx.SaveChanges();
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
/// <summary>
/// add by masu 2016年3月17日09:10:11 批量更新
/// </summary>
/// <typeparam name="TEntity"> 要注册的类型 </typeparam>
/// <param name="entity"> 要注册的对象 </param>
public virtual OperationResult Update <TEntity>(IEnumerable <TEntity> entities) where TEntity : EntityBase
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
// EntityState state;
//不跟踪变化，提高效率
ctx.Configuration.AutoDetectChangesEnabled = false;
foreach (TEntity entity in entities)
{
if (ctx.Entry(entity).State == EntityState.Detached)
{
ctx.Entry(entity).State = EntityState.Modified;
}
}
ctx.SaveChanges();
////批量
//foreach (TEntity entity in entities)
//{
// if (ctx.Entry(entity).State == EntityState.Detached)
// {
// try
// {
// #region 云推送添加
// BaseCloudService cloud = BaseCloudService.GetInstance();
// cloud.SyncInfo(entity, EnumCloudDataOperation.Update);
// #endregion
// }
// catch (Exception ex)
// {
// LogHelper.WriteLog(ex);
// }
// finally
// {
// }
// //Thread thread = new Thread(YunyiThreadHelper.YunyiUpdate);
// //thread.Start(entity);
// }
//}
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
//add by iLine 20160427 增加条件查询
/// <summary>
/// 根据条件获取数据
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="predicate"></param>
/// <param name="isTracking"></param>
/// <returns></returns>
public virtual IList <TEntity> GetDatas <TEntity>(Expression <Func <TEntity, bool> > predicate) where TEntity : EntityBase
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
if (predicate != null)
{
return(ctx.Set <TEntity>().Where(predicate).ToList());
}
else
{
return(null);
}
}
}
/// <summary>
/// 更新
/// </summary>
/// <typeparam name="TEntity"> 要注册的类型 </typeparam>
/// <param name="entity"> 要注册的对象 </param>
public virtual OperationResult Update <TEntity>(TEntity entity) where TEntity : EntityBase
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
if (ctx.Entry(entity).State == EntityState.Detached)
{
ctx.Set <TEntity>().Attach(entity);
}
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
//try
//{
// #region 云推送添加
// BaseCloudService cloud = BaseCloudService.GetInstance();
// cloud.SyncInfo(entity, EnumCloudDataOperation.Update);
// #endregion
//}
//catch (Exception ex)
//{
// LogHelper.WriteLog(ex);
//}
//finally
//{
//}
#region 云平台修改 Multi Thread
//Thread thread = new Thread(YunyiThreadHelper.YunyiUpdate);
//thread.Start(entity);
#endregion
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
exMsg = ex.Message;
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
/// <summary>
/// 直接执行SQL
/// </summary>
/// <param name="sql"></param>
public OperationResult ExecuteSqlCommand(string sql, SqlParameter[] para)
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
ctx.Database.ExecuteSqlCommand(sql, para);
//try
//{
// Thread thread = null;
// //删除设备
// if (sql.Contains("SP_DeleteDevice"))
// {
// thread = new Thread(YunyiThreadHelper.YunyiDelete);
// Device device = new Device();
// int id = 0;
// int.TryParse(para[0].ToString(), out id);
// device.DevID = id;
// thread.Start(device.DevID);
// }
//}
//catch(Exception ex)
//{
//}
//finally
//{
//}
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
//Context.Database.ExecuteSqlCommand(sql);
//return new OperationResult(OperationResultType.Success, "操作成功！");
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
public OperationResult SqlQuery <T>(string sql, SqlParameter[] para)
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
var sqlQuery = ctx.Database.SqlQuery <T>(sql, para).ToList();
return(new OperationResult(EnumOperationResultType.Success, "操作成功！", sqlQuery));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
/// <summary>
/// 删除指定编号的记录
/// </summary>
/// <param name="id"> 实体记录编号 </param>
/// <returns> 操作影响的行数 </returns>
public virtual OperationResult Delete <TEntity>(int id) where TEntity : EntityBase
{
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
TEntity entity = Set <TEntity>(ctx).Find(id);
ctx.Entry(entity).State = EntityState.Deleted;
ctx.SaveChanges();
// return Delete<TEntity>(entities);
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
return(new OperationResult(EnumOperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 删除所有符合特定表达式的数据
/// </summary>
/// <param name="predicate"> 查询条件谓语表达式 </param>
/// <returns> 操作影响的行数 </returns>
public virtual OperationResult Delete(Expression <Func <TEntity, bool> > predicate)
{
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
List <TEntity> entities = Set <TEntity>(ctx).Where(predicate).ToList();
foreach (TEntity entity in entities)
{
ctx.Entry(entity).State = EntityState.Deleted;
}
ctx.SaveChanges();
// return Delete<TEntity>(entities);
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
return(new OperationResult(EnumOperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 直接执行SQL
/// </summary>
/// <param name="sql"></param>
public OperationResult ExecuteSqlCommand(string sql)
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
ctx.Database.ExecuteSqlCommand(sql);
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
//Context.Database.ExecuteSqlCommand(sql);
//return new OperationResult(OperationResultType.Success, "操作成功！");
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
/// <summary>
/// 事务操作
/// </summary>
/// <param name="models"></param>
/// <returns></returns>
public OperationResult TranMethod(Dictionary <EntityBase, EntityState> models)
{
string exMsg = string.Empty;
try
{
using (iCMSDbContext ctx = new iCMSDbContext())
{
foreach (var model in models)
{
ctx.Entry(model.Key).State = model.Value;
}
ctx.SaveChanges();
//#region 云平台推送
//try
//{
// Thread thread = null;
// BaseCloudService cloud = BaseCloudService.GetInstance();
// foreach (var model in models)
// {
// switch (model.Value)
// {
// case EntityState.Added:
// #region 云推送添加
// cloud.SyncInfo(model.Key, EnumCloudDataOperation.Add);
// #endregion
// break;
// case EntityState.Deleted:
// #region 云推送删除
// cloud.SyncInfo(model.Key, EnumCloudDataOperation.Delete);
// #endregion
// break;
// case EntityState.Modified:
// #region 云推送删除
// cloud.SyncInfo(model.Key, EnumCloudDataOperation.Update);
// #endregion
// break;
// }
// }
//}
//catch (Exception ex)
//{
// LogHelper.WriteLog(ex);
//}
//finally
//{
//}
//#endregion
return(new OperationResult(EnumOperationResultType.Success, "操作成功！"));
}
}
catch (Exception ex)
{
LogHelper.WriteLog("数据库操作错误：" + ex.Message);
exMsg = ex.Message;
}
finally
{
// Context.Configuration.AutoDetectChangesEnabled = true;
}
return(new OperationResult(EnumOperationResultType.Error, exMsg));
}
private IQueryable <TEntity> Set <TEntity>(iCMSDbContext ctx, Expression <Func <TEntity, bool> > predicate) where TEntity : EntityBase
{
return(ctx.Set <TEntity>().Where(predicate).AsQueryable());
}
/// <summary>
/// 为指定的类型返回 System.Data.Entity.DbSet，这将允许对上下文中的给定实体执行 CRUD 操作。
/// </summary>
/// <typeparam name="TEntity"> 应为其返回一个集的实体类型。 </typeparam>
/// <returns> 给定实体类型的 System.Data.Entity.DbSet 实例。 </returns>
private DbSet <TEntity> Set <TEntity>(iCMSDbContext ctx) where TEntity : EntityBase
{
return(ctx.Set <TEntity>());
}