/// <summary> /// 根据条件删除 /// </summary> /// <param name="keys">键值集合</param> public virtual bool Delete(PropertyParamGroup paramGroup) { List <SqlParameter> pars = paramGroup.GetParams(); string sql = string.Format("DELETE FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString()); SqlParameter[] paras = pars == null ? null : pars.ToArray(); return(Entities.Database.ExecuteSqlCommand(sql, paras) > 0); }
/// <summary> /// 根据属性键值对查询对象集合 /// </summary> /// <param name="paramGroup">属性键值对</param> /// <returns></returns> public virtual List <TEntity> Get(PropertyParamGroup paramGroup) { List <SqlParameter> paras = paramGroup.GetParams(); SqlParameter[] pars = paras == null ? new SqlParameter[0] : paras.ToArray(); string sql = string.Format("SELECT * FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString()); return(Entities.Database.SqlQuery <TEntity>(sql, pars).ToList()); }
/// <summary> /// 根据属性键值对查询对象集合 /// </summary> /// <param name="properties">属性键值对</param> /// <returns></returns> public virtual List <TEntity> Get(PropertyParamGroup paramGroup) { try { return(Repository.Get(paramGroup)); } catch (Exception ex) { ExceptionHandler.LogExcetion(ex, this.GetType().FullName, System.Reflection.MethodBase.GetCurrentMethod()); return(null); } }
/// <summary> /// 删除部分 /// </summary> /// <param name="keys">键集合</param> public virtual StatusResult Delete(PropertyParamGroup paramGroup) { StatusResult statusMessage = new StatusResult(); try { var result = Repository.Delete(paramGroup); if (!result) { statusMessage.Status = Status.Wrong; statusMessage.Message = "删除发生错误"; } } catch (Exception ex) { statusMessage.Status = Status.Error; statusMessage.Message = "数据访问错误"; ExceptionHandler.LogExcetion(ex, this.GetType().FullName, System.Reflection.MethodBase.GetCurrentMethod()); } return(statusMessage); }