/// <summary> /// 删除7天前的日志数据 /// </summary> public int Delete(int dayCount) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "manager_log "); strSql.Append(" where DATEDIFF(day, add_time, getdate()) > " + dayCount); return(WriteDataBase.Delete(strSql.ToString())); }
/// <summary> /// 根据实体进行删除 /// </summary> /// <param name="t"></param> /// <returns></returns> public virtual bool Delete(T t) { bool isSuccess = true; try { WriteDataBase.BeginTransaction(); isSuccess = WriteDataBase.Delete(TableName, "id", t) > 0; WriteDataBase.CompleteTransaction(); } catch (Exception ex) { LogHelper.Error(ex); WriteDataBase.CloseSharedConnection(); isSuccess = false; } finally { WriteDataBase.CloseSharedConnection(); } return(isSuccess); }
/// <summary> /// 根据实体进行删除 /// </summary> /// <param name="t"></param> /// <returns></returns> public bool Delete(T t) { bool isSuccess = true; try { WriteDataBase.BeginTransaction(); isSuccess = WriteDataBase.Delete(t) > 0; WriteDataBase.CompleteTransaction(); } catch (Exception ex) { log.Info("Delete(T):" + ex); isSuccess = false; WriteDataBase.AbortTransaction(); WriteDataBase.CloseSharedConnection(); } finally { WriteDataBase.CloseSharedConnection(); } return(isSuccess); }