ef操作类

基于Hi博客的类库 20160811

using Model;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.Runtime.Remoting.Messaging;
using System.Text;

namespace Comm
{
    public class Base<T> where T : class
    {
        //更改为存线程内
        MyContext db = dbEntities;  //;// = new Model.qds114576568_dbEntities();      
        private static MyContext dbEntities
        {
            get
            {
                DbContext dbContext = CallContext.GetData(typeof(Base<T>).Name) as DbContext;
                if (dbContext == null)
                {
                    dbContext = new MyContext();
                    //dbContext.Configuration.ValidateOnSaveEnabled = false;
                    //将新创建的 ef上下文对象 存入线程
                    CallContext.SetData(typeof(Base<T>).Name, dbContext);
                }
                return dbContext as MyContext;
            }
        }

        #region 1.0添加数据 + Add(Tclass model)
        /// <summary>
        /// 1.0添加数据
        /// </summary>
        /// <param name="model"></param>
        public void Add(T model)
        {
            db.Set<T>().Add(model);
        }
        #endregion

        #region  2.0 删除方法1 删除给定的对象 +Del(Tclass model)
        /// <summary>
        /// 2.0 删除方法1 删除给定的对象
        /// </summary>
        /// <param name="model"></param>        
        /// <param name="IsSoftDel">是否软删除[*如果是软删除 则自动保存*]</param>
        /// <param name="Pro">软删除 要修改的删除标志字段</param>
        /// <param name="DelTag">软删除 删除标志值</param>
        /// <returns>如果非软删除则永远返回true 可以忽略</returns>
        public void Del(T model, bool IsSoftDel, string Pro = "IsDel", bool DelTag = true)
        {
            if (!IsSoftDel)
            {
                db.Set<T>().Attach(model);
                db.Set<T>().Remove(model);
            }
            else
            {
                var listPro = typeof(T).GetProperties().ToList();
                for (int i = 0; i < listPro.Count; i++)
                {
                    if (listPro[i].Name == Pro)
                    {
                        listPro[i].SetValue(model, DelTag, null);
                    }
                }
                Up(model, Pro);
            }
        }
        #endregion

        #region  2.1 删除方法2 根据条件删除对象 +Del(Expression<Func<Tclass, bool>> delWhere)
        /// <summary>
        /// 2.1 删除方法2 根据条件删除对象 
        /// </summary>
        /// <param name="delWhere">删除条件</param>
        /// <param name="IsSoftDel">是否软删除</param>
        /// <param name="Pro">软删除 要修改的删除标志字段</param>
        /// <param name="DelTag">软删除 删除标志值</param>
        public void Del(Expression<Func<T, bool>> delWhere, bool IsSoftDel, string Pro = "IsDel", bool DelTag = true)
        {
            var modelS = db.Set<T>().Where(delWhere).ToList();
            if (!IsSoftDel)
            {
                modelS.ForEach(m =>
               {
                   db.Set<T>().Attach(m);
                   db.Set<T>().Remove(m);
               });
            }
            else //软删除
            {
                var listPro = typeof(T).GetProperties().ToList();
                foreach (var mymodel in modelS)
                {
                    for (int i = 0; i < listPro.Count; i++)
                    {
                        if (listPro[i].Name == Pro)
                        {
                            listPro[i].SetValue(mymodel, DelTag, null);
                        }
                        if (listPro[i].Name == "UpTime")
                        {
                            listPro[i].SetValue(mymodel, DateTime.Now, null);
                        }
                    }
                }
            }
        }
        #endregion

        #region 3.0 修改方法1 修改某个实体的 某些属性 +Up(Tclass model, params string[] strparams)
        /// <summary>
        /// 3.0 修改方法1 修改某个实体的 某些属性(根据id修改)【*用这个需要注意关闭检查】
        /// </summary>
        /// <param name="model"></param>
        /// <param name="strparams">可变参数</param>
        public void Up(T model, params string[] strparams)
        {
            var m = db.Entry<T>(model);
            m.State = System.Data.Entity.EntityState.Unchanged;

            for (int i = 0; i < strparams.Length; i++)
            {
                m.Property(strparams[i]).IsModified = true;
            }
            m.Property("UpTime").IsModified = true;
        }

        #endregion

        #region 3.1 修改方法2 根据条件 修改指定的 属性 值 +Up(Expression<Func<Tclass, bool>> upWhere, Tclass model, params string[] strparame)
        /// <summary>
        /// 3.1 修改方法2 根据条件 修改指定的 属性 值
        /// </summary>
        /// <param name="upWhere">要修改的数据的 条件</param>
        /// <param name="IsUpDelData">是否修改已经软删除过的数据</param>
        /// <param name="model">要修改的model对象</param>
        /// <param name="strparame">要修改的字段名</param>
        public void Up(Expression<Func<T, bool>> upWhere, bool IsUpDelData, T model, params string[] strparame)
        {
            var modelS = GetList(upWhere, IsUpDelData).ToList();

            var listPro = typeof(T).GetProperties().ToList();
            List<PropertyInfo> dic = new List<PropertyInfo>();

            listPro.ForEach(l =>
            {
                for (int i = 0; i < strparame.Length; i++)
                {
                    if (l.Name == strparame[i].Trim() || l.Name == "UpTime")
                    {
                        dic.Add(l);
                        break;
                    }
                }
            });

            if (dic.Count > 0)
            {
                foreach (var property in dic)
                {
                    var newValue = property.GetValue(model, null);
                    foreach( var mymodel in modelS)
                    {
                        property.SetValue(mymodel, newValue, null);

                    }
                }
            }
        
        }
        #endregion

        #region  4.0 查询方法 +GetList<Tkey>(Expression<Func<Tclass, bool>> strWhere, Expression<Func<Tclass, Tkey>> strOrederBy = null, bool order = true)
        /// <summary>
        /// 4.0 查询方法 
        /// </summary>
        /// <typeparam name="Tkey">如果strOrederBy为null Tkey也可以DBNull</typeparam>
        /// <param name="strWhere">查询条件</param>
        /// <param name="SelectDelData">查询的结果集中 是否包括 已经软删除的数据</param>
        /// <param name="strOrederBy">排序条件</param>
        /// <param name="order">是否升序</param>
        ///  <param name="tableName">连接查询 的表名</param>
        /// <returns></returns>
        public IQueryable<T> GetList(Expression<Func<T, bool>> strWhere, bool SelectDelData = false, bool isAsNoTracking = true, string tableName = null)
        {
            Expression<Func<T, bool>> exp = strWhere;
            //if (!SelectDelData)
            //    AddLinq.And(exp, GetWhereIsDel());

            IQueryable<T> t = null;

            if (isAsNoTracking)
            {
                if (string.IsNullOrEmpty(tableName))
                    t = db.Set<T>().AsNoTracking().Where(exp);
                else
                    t = db.Set<T>().Include(tableName).AsNoTracking().Where(exp);
            }
            else
            {
                if (string.IsNullOrEmpty(tableName))
                    t = db.Set<T>().Where(exp);
                else
                    t = db.Set<T>().Include(tableName).Where(exp);
            }
            return t;
        }
        /// <summary>
        /// 4.0.2 查询方法 
        /// </summary>
        /// <typeparam name="Tkey">如果strOrederBy为null Tkey也可以DBNull</typeparam>
        /// <param name="strWhere">查询条件</param>
        /// <param name="SelectDelData">查询的结果集中 是否包括 已经软删除的数据</param>
        /// <param name="strOrederBy">排序条件</param>
        /// <param name="order">是否升序</param>
        ///  <param name="tableName">连接查询 的表名</param>
        /// <returns></returns>
        public IQueryable<T> GetList<TTb>(Expression<Func<T, bool>> strWhere, bool SelectDelData = false, bool isAsNoTracking = true, Expression<Func<T, TTb>> tableName = null)
        {
            Expression<Func<T, bool>> exp = strWhere;
            //if (!SelectDelData)
            //    exp = AddLinq.And(exp, GetWhereIsDel());//合并 排除一删除查询条件 

            IQueryable<T> t = null;
            if (isAsNoTracking)
                if (null == tableName)
                    t = db.Set<T>().AsNoTracking().Where(exp);
                else
                    t = db.Set<T>().Include(tableName).AsNoTracking().Where(exp);
            else
                if (null == tableName)
                t = db.Set<T>().Where(exp);
            else
                t = db.Set<T>().Include(tableName).Where(exp);

            return t;
        }

        #endregion
        #region 4.1 查询方法2 分页查询 +GetList<Tkey>(int indexPage, int sizePage, Expression<Func<Tclass, bool>> strWhere, Expression<Func<Tclass, Tkey>> strOrederBy = null, bool order = true)
        /// <summary>
        /// 4.1 查询方法2 分页查询
        /// </summary>
        /// <typeparam name="Tkey">如果strOrederBy为null Tkey也可以DBNull</typeparam>
        /// <param name="indexPage">页码(从1开始）</param>
        /// <param name="sizePage">页容量</param>
        /// <param name="total">总页数</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="SelectDelData">查询的结果集中 是否包括 已经软删除的数据</param>
        /// <param name="strOrederBy">排序字段</param>
        /// <param name="order">是否升序</param>
        ///  <param name="tableName">连接查询 的表名</param>
        /// <returns></returns>
        public IQueryable<T> GetList<Tkey>(int indexPage, int sizePage, out int total, Expression<Func<T, bool>> strWhere, bool SelectDelData = false, Expression<Func<T, Tkey>> strOrederBy = null, bool order = true, bool isAsNoTracking = true, string tableName = null)
        {
            Expression<Func<T, bool>> exp = strWhere;
            //if (!SelectDelData)
            //    exp = AddLinq.And(exp, GetWhereIsDel());//合并 排除一删除查询条件 

            IQueryable<T> t = null;
            if (isAsNoTracking)
                if (string.IsNullOrEmpty(tableName))
                    t = db.Set<T>().AsNoTracking().Where(exp);
                else
                    t = db.Set<T>().Include(tableName).AsNoTracking().Where(exp);
            else
                if (string.IsNullOrEmpty(tableName))
                t = db.Set<T>().Where(exp);
            else
                t = db.Set<T>().Include(tableName).Where(exp);

            if (strOrederBy != null)
            {
                if (order)
                    t = t.OrderBy(strOrederBy);
                else
                    t = t.OrderByDescending(strOrederBy);
            }
            int count = t.Count();
            total = count / sizePage + (count % sizePage > 0 ? 1 : 0);
            return t.Skip((indexPage - 1) * sizePage).Take(sizePage);
        }

        /// <summary>
        /// 4.1.2 查询方法2 分页查询
        /// </summary>
        /// <typeparam name="Tkey">如果strOrederBy为null Tkey也可以DBNull</typeparam>
        /// <param name="indexPage">页码(从1开始）</param>
        /// <param name="sizePage">页容量</param>
        /// <param name="total">总页数</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="SelectDelData">查询的结果集中 是否包括 已经软删除的数据</param>
        /// <param name="strOrederBy">排序字段</param>
        /// <param name="order">是否升序</param>
        ///  <param name="tableName">连接查询 的表名</param>
        /// <returns></returns>
        public IQueryable<T> GetList<Tkey, TTb>(int indexPage, int sizePage, out int total, Expression<Func<T, bool>> strWhere, bool SelectDelData = false, Expression<Func<T, Tkey>> strOrederBy = null, bool order = true, bool isAsNoTracking = true, Expression<Func<T, TTb>> tableName = null)
        {
            Expression<Func<T, bool>> exp = strWhere;
            //if (!SelectDelData)
            //    exp = AddLinq.And(exp, GetWhereIsDel());//合并 排除一删除查询条件 

            IQueryable<T> t = null;
            if (isAsNoTracking)
                if (null == tableName)
                    t = db.Set<T>().AsNoTracking().Where(exp);
                else
                    t = db.Set<T>().Include(tableName).AsNoTracking().Where(exp);
            else
                if (null == tableName)
                t = db.Set<T>().Where(exp);
            else
                t = db.Set<T>().Include(tableName).Where(exp);

            if (strOrederBy != null)
            {
                if (order)
                    t = t.OrderBy(strOrederBy);
                else
                    t = t.OrderByDescending(strOrederBy);
            }
            int count = t.Count();
            total = count / sizePage + (count % sizePage > 0 ? 1 : 0);
            return t.Skip((indexPage - 1) * sizePage).Take(sizePage);
        }


        #endregion
        #region 5.0 返回 已经删除的 linq 拼接条件
        /// <summary>
        /// 返回 已经删除的 linq 拼接条件
        /// </summary>
        /// <returns></returns>
        //private static Expression<Func<T, bool>> GetWhereIsDel()
        //{
        //    return t => t.IsDel == false;
        //}
        #endregion

        #region 提交 +save()
        /// <summary>
        /// 提交
        /// </summary>
        /// <param name="ValidateOnSaveEnabled">是否打开验证</param>
        /// <returns></returns>
        public int save(bool ValidateOnSaveEnabled = true)
        {
            db.Configuration.ValidateOnSaveEnabled = ValidateOnSaveEnabled;
            return db.SaveChanges();
        }

        public static int StaticSave(bool ValidateOnSaveEnabled = true)
        {
            dbEntities.Configuration.ValidateOnSaveEnabled = ValidateOnSaveEnabled;
            return dbEntities.SaveChanges();
        }

        #endregion
    }
}