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