/// <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));
}
}
/// <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);
}
}
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);
}
}
/// <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);
}
/// <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));
}
/// <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);
}
/// <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));
}