/// <summary> /// 创建一个实体 /// </summary> /// <param name="entity">数据库上下文</param> /// <returns>执行返回结果影响行数</returns> public int Create(test_sys_sample entity) { using (DBContainer db = new DBContainer()) { db.Set <test_sys_sample>().Add(entity); return(db.SaveChanges()); } }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="entity">数据库上下文</param> /// <returns>执行返回结果影响行数</returns> public int Edit(test_sys_sample entity) { using (DBContainer db = new DBContainer()) { db.Set <test_sys_sample>().Attach(entity); db.Entry(entity).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 删除一个实体 /// </summary> /// <param name="id">主键ID</param> /// <returns>执行返回结果影响行数</returns> public int Delete(long id) { using (DBContainer db = new DBContainer()) { test_sys_sample entity = db.test_sys_sample.SingleOrDefault(a => a.Id == id); db.Set <test_sys_sample>().Remove(entity); return(db.SaveChanges()); } }
/// <summary> /// 判断实体是否存在 /// </summary> /// <param name="id">主键ID</param> /// <returns>返回结果</returns> public bool IsExist(long id) { using (DBContainer db = new DBContainer()) { test_sys_sample entity = GetById(id); if (entity != null) { return(true); } return(false); } }
/// <summary> /// 根据ID获得一个实体 /// </summary> /// <param name="id">id</param> /// <returns>实体</returns> public test_sys_sample GetById(long id) { if (IsExist(id)) { test_sys_sample entity = _iSysSampleDAL.GetById(id); return(entity); } else { return(null); } }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="errors">持久的错误信息</param> /// <param name="model">模型</param> /// <returns>是否成功</returns> public bool Edit(test_sys_sample entity) { try { if (_iSysSampleDAL.Edit(entity) == 1) { return(true); } else { return(false); } } catch (Exception ex) { //ExceptionHander.WriteException(ex); return(false); } }