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