CRM_EasyUI_DAL/CRM_Dept_Repository.cs

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

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

using System;
using System.Linq;
using GroupThink.CRM.IDAL;
using GroupThink.CRM.Model;
using System.Data;
using GroupThink.CRM.Model.Sys;
using System.Collections.Generic;
using EntityFramework.Extended;

namespace GroupThink.CRM.DAL
{
    public class CRM_Dept_Repository : ICRM_Dept_Repository, IDisposable
    {
        public List<P_Dept_Result> GetList1(DBContainer db)
        {
            //IQueryable<CRM_Dept> list = db.CRM_Dept.AsQueryable();
            List<P_Dept_Result> list = db.P_Dept().Where(t => t.IsDelete == false).ToList();
            return list;
        }


        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="db">数据库上下文</param>
        /// <returns>数据列表</returns>
        public IQueryable<CRM_Dept> GetList(DBContainer db)
        {
            IQueryable<CRM_Dept> list = db.CRM_Dept.AsQueryable();
            return list;
        }

        /// <summary>
        /// 创建一个实体
        /// </summary>
        /// <param name="db">数据库上下文</param>
        /// <param name="entity">实体</param>
        public int Create(CRM_Dept entity)
        {
            using (DBContainer db = new DBContainer())
            {
                db.CRM_Dept.AddObject(entity);
                return db.SaveChanges();
            }
        }


        /// <summary>
        /// 删除一个实体
        /// </summary>
        /// <param name="db">数据库上下文</param>
        /// <param name="entity">主键id</param>
        public int Delete(int id)
        {
            using (DBContainer db = new DBContainer())
            {
                    try
                    {
                        CRM_Dept entity = db.CRM_Dept.SingleOrDefault(a => a.DeptID == id);
                        //查询所有的ID