OA.DAL/BaseDal.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//引用命名空间
using OA.IDAL;
using OA.Model;
using System.Linq.Expressions;
using System.Data.Entity;

namespace OA.DAL
{
    /// <summary>
    /// 基本CURD方法实现
    /// </summary>
    public class BaseDal<T> where T :class,new()
    {
        //EF上下文
        //OAEntities db = new OAEntities();
        DbContext db = DbContextFactory.CreateDbContext();//完成EF上下文创建
        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public T AddEntities(T entity)
        {
            db.Set<T>().Add(entity);
            //db.SaveChanges();
            return entity;
        }
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <returns></returns>
        public bool DeleteEntities(T entity)
        {
            db.Entry<T>(entity).State = System.Data.EntityState.Deleted;
            // return db.SaveChanges() > 0;
            return true;
        }
        /// <summary>
        /// 查询方法
        /// </summary>
        /// <param name="whereLambda"></param>
        /// <returns></returns>
        public IQueryable<T> LoadEntities(Expression<Func<T, bool>> whereLambda)
        {
            return db.Set<T>().Where<T>(whereLambda);
        }
        /// <summary>
        /// 分页方法 
        /// </summary>
        /// <typeparam name="s">排序的约束</typeparam>
        /// <param name="pageIndex">当前页码</param>
        /// <param name="pageSize">每页显示的记录数</param>
        /// <param name="totalCount">总条数</param>
        /// <param name="whereLambda">过滤条件</param>
        /// <param name="orderbyLambda">排序条件</param>