/// <summary>
/// 根据id获取数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SysSample GetById(string id)
{
using (JProjectDBEntities db = new JProjectDBEntities())
{
return(db.SysSample.SingleOrDefault(a => a.Id == id));
}
}
/// <summary>
/// 创建数据实体
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Create(SysSample entity)
{
using (JProjectDBEntities db = new JProjectDBEntities())
{
db.Set <SysSample>().Add(entity);
return(db.SaveChanges());
}
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Edit(SysSample entity)
{
using (JProjectDBEntities db = new JProjectDBEntities())
{
db.Set <SysSample>().Attach(entity);
db.Entry <SysSample>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
/// <summary>
/// 根据ID删除数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Delete(string id)
{
using (JProjectDBEntities db = new JProjectDBEntities())
{
SysSample entity = db.SysSample.SingleOrDefault(a => a.Id == id);
db.Set <SysSample>().Remove(entity);
return(db.SaveChanges());
}
}
/// <summary>
/// 根据id判断数据是否存在
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool IsExist(string id)
{
using (JProjectDBEntities db = new JProjectDBEntities())
{
SysSample entity = GetById(id);
if (entity != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IQueryable <SysSample> GetList(JProjectDBEntities db)
{
IQueryable <SysSample> list = db.SysSample.AsQueryable();
return(list);
}
