/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="valueType">数据类型</typeparam>
/// <typeparam name="modelType">模型类型</typeparam>
/// <param name="sqlTool">SQL操作工具</param>
/// <param name="connection">SQL连接</param>
/// <param name="value">添加数据</param>
/// <param name="query">添加数据查询信息</param>
/// <returns></returns>
internal override ReturnType Delete <valueType, modelType>(Sql.Table <valueType, modelType> sqlTool, ref DbConnection connection, valueType value, ref InsertQuery query)
{
//sqlTool.Log.Error(query.Sql, LogLevel.Error | LogLevel.AutoCSer);
if (query.NotQuery)
{
ReturnValue <int> returnValue = executeNonQuery(ref connection, query.Sql);
if (returnValue.ReturnType == ReturnType.Success)
{
if (returnValue.Value > 0)
{
sqlTool.CallOnDeleted(value);
return(ReturnType.Success);
}
return(ReturnType.NotFoundData);
}
return(returnValue.ReturnType);
}
else
{
GetQuery <modelType> getQuery = new GetQuery <modelType> {
MemberMap = sqlTool.SelectMemberMap, Sql = query.Sql
};
ReturnType returnType = Get(sqlTool, ref connection, value, ref getQuery);
if (returnType == ReturnType.Success)
{
sqlTool.CallOnDeleted(value);
}
return(returnType);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="valueType">数据类型</typeparam>
/// <typeparam name="modelType">模型类型</typeparam>
/// <param name="sqlTool">SQL操作工具</param>
/// <param name="transaction">事务操作</param>
/// <param name="value">添加数据</param>
/// <param name="query">添加数据查询信息</param>
/// <returns></returns>
internal override bool Delete <valueType, modelType>(Sql.Table <valueType, modelType> sqlTool, Transaction transaction, valueType value, ref InsertQuery query)
{
if (sqlTool.CallOnDelete(value) && executeNonQuery(transaction, query.InsertSql) > 0)
{
sqlTool.CallOnDeleted(transaction, value);
return(true);
}
return(false);
}
/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="valueType">数据类型</typeparam>
/// <typeparam name="modelType">模型类型</typeparam>
/// <param name="sqlTool">SQL操作工具</param>
/// <param name="transaction">事务操作</param>
/// <param name="value">添加数据</param>
/// <param name="query">添加数据查询信息</param>
/// <returns></returns>
internal override ReturnType Delete <valueType, modelType>(Sql.Table <valueType, modelType> sqlTool, Transaction transaction, valueType value, ref InsertQuery query)
{
if (sqlTool.CallOnDelete(value))
{
if (executeNonQuery(transaction, query.Sql) > 0)
{
sqlTool.CallOnDeleted(transaction, value);
return(ReturnType.Success);
}
return(ReturnType.NotFoundData);
}
return(ReturnType.EventCancel);
}
/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="valueType">数据类型</typeparam>
/// <typeparam name="modelType">模型类型</typeparam>
/// <param name="sqlTool">SQL操作工具</param>
/// <param name="connection">SQL连接</param>
/// <param name="value">添加数据</param>
/// <param name="query">添加数据查询信息</param>
/// <returns></returns>
internal override bool Delete <valueType, modelType>(Sql.Table <valueType, modelType> sqlTool, ref DbConnection connection, valueType value, ref InsertQuery query)
{
GetQuery <modelType> getQuery = new GetQuery <modelType> {
MemberMap = sqlTool.SelectMemberMap, Sql = query.Sql
};
if (Get(sqlTool, ref connection, value, ref getQuery) && executeNonQuery(connection, query.InsertSql) > 0)
{
sqlTool.CallOnDeleted(value);
return(true);
}
return(false);
}
/// <summary>
/// 删除数据
/// </summary>
/// <typeparam name="valueType">数据类型</typeparam>
/// <typeparam name="modelType">模型类型</typeparam>
/// <param name="sqlTool">SQL操作工具</param>
/// <param name="connection">SQL连接</param>
/// <param name="value">添加数据</param>
/// <param name="query">添加数据查询信息</param>
/// <returns></returns>
internal override bool Delete <valueType, modelType>(Sql.Table <valueType, modelType> sqlTool, ref DbConnection connection, valueType value, ref InsertQuery query)
{
sqlTool.Log.Add(AutoCSer.Log.LogType.Error, query.Sql);
if (query.NotQuery)
{
if (executeNonQuery(ref connection, query.Sql) > 0)
{
sqlTool.CallOnDeleted(value);
return(true);
}
}
else
{
GetQuery <modelType> getQuery = new GetQuery <modelType> {
MemberMap = sqlTool.SelectMemberMap, Sql = query.Sql
};
if (Get(sqlTool, ref connection, value, ref getQuery))
{
sqlTool.CallOnDeleted(value);
return(true);
}
}
return(false);
}
