/// <summary>
/// 批量添加插入操作
/// </summary>
/// <typeparam name="T">对象类型</typeparam>
/// <param name="model">对象实体</param>
/// <returns></returns>
public static bool Add <T>(this CreateSql <T> createSql, List <T> model) where T : class, new()
{
var result = false;
using (var dt = new DapperTransaction())
{
try
{
if (model != null && model.Count > 0)
{
foreach (var item in model)
{
dt.dbConnection.Execute(createSql.ToSqlString(), item, dt.dbTransaction);
}
}
else
{
return(false);
}
dt.Commit();
result = true;
}
catch (Exception)
{
dt.Rollback();
throw;
}
}
return(result);
}
/// <summary>
/// 执行SQL并返回指定数据事务处理
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="createSql">SQL构造器</param>
/// <param name="dtran">事务</param>
/// <param name="models">参数</param>
/// <returns></returns>
public static object ExeScalar <T>(this CreateSql <T> createSql, DapperTransaction dtran, object models) where T : class, new()
{
object result = null;
if (dtran != null)
{
result = dtran.dbConnection.ExecuteScalar(createSql.ToSqlString(), models, dtran.dbTransaction);
}
return(result);
}
/// <summary>
/// 代事务删除操作
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="dtran">事务</param>
/// <param name="createSql">SQL构造器</param>
/// <param name="models">参数</param>
/// <returns></returns>
public static bool Remove <T>(this CreateSql <T> createSql, DapperTransaction dtran, object models) where T : class, new()
{
var result = false;
if (dtran != null)
{
result = dtran.dbConnection.Execute(createSql.ToSqlString(), models, dtran.dbTransaction) > 0;
}
return(result);
}
/// <summary>
/// 修改更新操作
/// </summary>
/// <typeparam name="T">对象类型</typeparam>
/// <param name="createSql">SQL</param>
/// <param name="models">对象实体</param>
/// <returns></returns>
public static bool Modify <T>(this string createSql, DapperTransaction dtran, object models) where T : class, new()
{
var result = false;
if (dtran != null)
{
result = dtran.dbConnection.Execute(createSql, models, dtran.dbTransaction) > 0;
}
return(result);
}
/// <summary>
/// 添加插入操作
/// </summary>
/// <typeparam name="T">实体对象</typeparam>
/// <param name="dapperTransaction">事任封装</param>
/// <param name="model"></param>
/// <returns></returns>
public static bool Add <T>(this CreateSql <T> createSql, DapperTransaction dapperTransaction, T model) where T : class, new()
{
var result = false;
if (dapperTransaction != null)
{
result = dapperTransaction.dbConnection.Execute(createSql.ToSqlString(), model, dapperTransaction.dbTransaction) > 0;
}
return(result);
}
