示例#1
0
 /// <summary>
 /// 获取所有
 /// </summary>
 /// <returns>集合</returns>
 public virtual IQueryable <T> GetAll()
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetAll(db));
     }
 }
 /// <summary>
 /// 通过主键id,获取AspNetUsers---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>AspNetUsers</returns>
 public AspNetUsers GetById(string id)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetById(db, id));
     }
 }
 /// <summary>
 /// 获取在该表一条数据中,出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <AspNetRoles> GetRefAspNetRoles(LYProjectEntities db, string id)
 {
     return(from m in db.AspNetUsers
            from f in m.AspNetRoles
            where m.Id == id
            select f);
 }
 /// <summary>
 /// 获取在该表一条数据中,出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <Article> GetRefArticle(LYProjectEntities db, string id)
 {
     return(from m in db.Articles
            from f in db.AspNetUsers
            where m.User.Id == id
            select m);
 }
 /// <summary>
 /// 通过主键id,获取Article---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>Article</returns>
 public Article GetById(string id)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetById(db, id));
     }
 }
 /// <summary>
 /// 获取在该表中出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <AspNetRoles> GetRefAspNetRoles()
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetRefAspNetRoles(db));
     }
 }
 /// <summary>
 /// 创建对象集合
 /// </summary>
 /// <param name="db">实体数据</param>
 /// <param name="entitys">对象集合</param>
 public virtual void Create(LYProjectEntities db, IQueryable <T> entitys)
 {
     foreach (var entity in entitys)
     {
         this.Create(db, entity);
     }
 }
 /// <summary>
 /// 创建
 /// </summary>
 /// <param name="db">实体数据</param>
 /// <param name="entity">将要创建的对象</param>
 public virtual void Create(LYProjectEntities db, T entity)
 {
     if (entity != null)
     {
         db.Set <T>().Add(entity);
     }
 }
 /// <summary>
 /// 编辑对象集合
 /// </summary>
 /// <param name="db">实体数据</param>
 /// <param name="entitys">对象集合</param>
 public virtual void Edit(LYProjectEntities db, IQueryable <T> entitys)
 {
     foreach (T entity in entitys)
     {
         this.Edit(db, entity);
     }
 }
 /// <summary>
 /// 获取在该表中出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <Article> GetRefArticle()
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetRefArticle(db));
     }
 }
示例#11
0
 /// <summary>
 /// 通过主键id,获取AspNetUserClaims---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>AspNetUserClaims</returns>
 public AspNetUserClaims GetById(int id)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetById(db, id));
     }
 }
 /// <summary>
 /// 获取在该表一条数据中,出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <AspNetUsers> GetRefAspNetUsers(string id)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         return(GetRefAspNetUsers(db, id));
     }
 }
 /// <summary>
 /// 创建
 /// </summary>
 /// <param name="entity">一个对象</param>
 /// <returns></returns>
 public virtual int Create(T entity)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         Create(db, entity);
         return(this.Save(db));
     }
 }
 /// <summary>
 /// 确定删除一个对象,调用Save方法
 /// </summary>
 /// <param name="id">一条数据的主键</param>
 /// <returns></returns>
 public int Delete(string id)
 {
     using (LYProjectEntities db = new LYProjectEntities())
     {
         this.Delete(db, id);
         return(Save(db));
     }
 }
 /// <summary>
 /// 编辑一个对象
 /// </summary>
 /// <param name="db">实体数据</param>
 /// <param name="entity">将要编辑的一个对象</param>
 /// <param name="isAttach">是否附加到数据库上下文</param>
 public virtual T Edit(LYProjectEntities db, T entity, bool isAttach = true)
 {
     if (isAttach)
     {
         db.Set <T>().Attach(entity);
     }
     db.SaveChanges();
     return(entity);
 }
        /// <summary>
        /// 删除一个Article
        /// </summary>
        /// <param name="db">实体数据</param>
        /// <param name="id">一条Article的主键</param>
        public void Delete(LYProjectEntities db, string id)
        {
            Article deleteItem = GetById(db, id);

            if (deleteItem != null)
            {
                db.Articles.Remove(deleteItem);
            }
        }
        /// <summary>
        /// 删除一个AspNetUsers
        /// </summary>
        /// <param name="db">实体数据</param>
        /// <param name="id">一条AspNetUsers的主键</param>
        public void Delete(LYProjectEntities db, string id)
        {
            AspNetUsers deleteItem = GetById(db, id);

            if (deleteItem != null)
            {
                db.AspNetUsers.Remove(deleteItem);
            }
        }
示例#18
0
        public static void Initial(LYProjectEntities db)
        {
            Article article = new Article();

            article.Title      = "ddd";
            article.Profile    = "dddd";
            article.Content    = "ddddd";
            article.CreateTime = DateTime.Now;
            db.Set <Article>().Add(article);
            db.SaveChangesAsync();
        }
        /// <summary>
        /// 删除对象集合
        /// </summary>
        /// <param name="db">实体数据</param>
        /// <param name="deleteCollection">主键的集合</param>
        public void Delete(LYProjectEntities db, string[] deleteCollection)
        {
            //数据库设置级联关系,自动删除子表的内容
            IQueryable <AspNetUsers> collection = from f in db.AspNetUsers
                                                  where deleteCollection.Contains(f.Id)
                                                  select f;

            foreach (var deleteItem in collection)
            {
                db.AspNetUsers.Remove(deleteItem);
            }
        }
示例#20
0
 /// <summary>
 /// 通过主键id,获取AspNetUserLogins---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>AspNetUserLogins</returns>
 public AspNetUserLogins GetById(LYProjectEntities db, string id)
 {
     return(db.AspNetUserLogins.SingleOrDefault(s => s.LoginProvider == id));
 }
 /// <summary>
 /// 提交保存,持久化到数据库
 /// </summary>
 /// <param name="db">实体数据</param>
 /// <returns>受影响行数</returns>
 public int Save(LYProjectEntities db)
 {
     return(db.SaveChanges());
 }
 /// <summary>
 /// 获取在该表中出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <Article> GetRefArticle(LYProjectEntities db)
 {
     return(from m in db.Articles
            select m);
 }
        /// <summary>
        /// 查询的数据
        /// </summary>
        /// <param name="LYProjectEntities">数据访问的上下文</param>
        /// <param name="order">排序字段</param>
        /// <param name="sort">升序asc(默认)还是降序desc</param>
        /// <param name="search">查询条件</param>
        /// <param name="listQuery">额外的参数</param>
        /// <returns></returns>
        public IQueryable <AspNetUsers> DaoChuData(LYProjectEntities db, string order, string sort, string search, params object[] listQuery)
        {
            string where = string.Empty;
            int flagWhere = 0;

            Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString());

            if (queryDic != null && queryDic.Count > 0)
            {
                foreach (var item in queryDic)
                {
                    if (flagWhere != 0)
                    {
                        where += " and ";
                    }
                    flagWhere++;



                    if (queryDic.ContainsKey("AspNetRoles") && !string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key == "AspNetRoles")
                    {//查询多对多关系的列名
                        where += "EXISTS(select p from it.AspNetRoles as p where p.Id='" + item.Value + "')";
                        continue;
                    }
                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Time)) //需要查询的列名
                    {
                        where += "it. " + item.Key.Remove(item.Key.IndexOf(Start_Time)) + " >=  CAST('" + item.Value + "' as   System.DateTime)";
                        continue;
                    }
                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Time))  //需要查询的列名
                    {
                        where += "it." + item.Key.Remove(item.Key.IndexOf(End_Time)) + " <  CAST('" + Convert.ToDateTime(item.Value).AddDays(1) + "' as   System.DateTime)";
                        continue;
                    }
                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Int))  //需要查询的列名
                    {
                        where += "it." + item.Key.Remove(item.Key.IndexOf(Start_Int)) + " >= " + item.Value.GetInt();
                        continue;
                    }
                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Int))  //需要查询的列名
                    {
                        where += "it." + item.Key.Remove(item.Key.IndexOf(End_Int)) + " <= " + item.Value.GetInt();
                        continue;
                    }

                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_String))  //需要查询的列名
                    {
                        where += "it." + item.Key.Remove(item.Key.IndexOf(End_String)) + " = '" + item.Value + "'";
                        continue;
                    }

                    if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_String))  //需要查询的列名
                    {
                        where += "it." + item.Key.Remove(item.Key.IndexOf(DDL_String)) + " = '" + item.Value + "'";
                        continue;
                    }
                    where += "it." + item.Key + " like '%" + item.Value + "%'";
                }
            }
            return(db.AspNetUsers
                   .Where(string.IsNullOrEmpty(where) ? "true" : where)
                   .OrderBy("it." + sort.GetString() + " " + order.GetString())
                   .AsQueryable());
        }
 /// <summary>
 /// 获取在该表中出现的所有外键实体
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>外键实体集合</returns>
 public IQueryable <AspNetRoles> GetRefAspNetRoles(LYProjectEntities db)
 {
     return(from m in db.AspNetUsers
            from f in m.AspNetRoles
            select f);
 }
示例#25
0
 /// <summary>
 /// 通过主键id,获取AspNetUserClaims---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>AspNetUserClaims</returns>
 public AspNetUserClaims GetById(LYProjectEntities db, int id)
 {
     return(db.AspNetUserClaims.SingleOrDefault(s => s.Id == id));
 }
 /// <summary>
 /// 通过主键id,获取AspNetUsers---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>AspNetUsers</returns>
 public AspNetUsers GetById(LYProjectEntities db, string id)
 {
     return(db.AspNetUsers.SingleOrDefault(s => s.Id == id));
 }
示例#27
0
 /// <summary>
 /// 根据UserId,获取所有AspNetUserClaims数据
 /// </summary>
 /// <param name="id">外键的主键</param>
 /// <returns></returns>
 public IQueryable <AspNetUserClaims> GetByRefUserId(LYProjectEntities db, string id)
 {
     return(from c in db.AspNetUserClaims
            where c.UserId == id
            select c);
 }
示例#28
0
 /// <summary>
 /// 获取所有
 /// </summary>
 /// <returns>集合</returns>
 public virtual IQueryable <T> GetAll(LYProjectEntities db)
 {
     return(db.Set <T>().AsQueryable());
 }
 /// <summary>
 /// 通过主键id,获取Article---查看详细,首次编辑
 /// </summary>
 /// <param name="id">主键</param>
 /// <returns>Article</returns>
 public Article GetById(LYProjectEntities db, string id)
 {
     return(db.Articles.SingleOrDefault(s => s.ArticleId == id));
 }