/// <summary> /// only oracle use /// </summary> /// <typeparam name="T"></typeparam> /// <param name="conn"></param> /// <param name="model"></param> /// <param name="sequence"></param> /// <param name="tran"></param> /// <param name="commandTimeout"></param> /// <returns></returns> public static decimal InsertReturnIdForOracle <T>(this IDbConnection conn, T model, string sequence, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); conn.Execute(builder.GetInsertReturnIdSql <T>(sequence), model, tran, commandTimeout); return(GetSequenceCurrent <decimal>(conn, sequence, tran, null)); }
public async static Task <decimal> InsertReturnIdForOracleAsync <T>(this IDbConnection conn, T model, string sequence, IDbTransaction tran = null, int?commandTimeout = null) { return(await Task.Run(() => { var builder = BuilderFactory.GetBuilder(conn); conn.Execute(builder.GetInsertReturnIdSql <T>(sequence), model, tran, commandTimeout); return GetSequenceCurrent <decimal>(conn, sequence, tran, null); })); }
public static async Task <IEnumerable <dynamic> > GetByIdsWithFieldDynamicAsync <T>(this IDbConnection conn, object ids, string field, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null) { if (CommonUtil.ObjectIsEmpty(ids)) { return(Enumerable.Empty <dynamic>()); } var builder = BuilderFactory.GetBuilder(conn); DynamicParameters dpar = new DynamicParameters(); dpar.Add("@ids", ids); return(await conn.QueryAsync(builder.GetByIdsWithFieldSql <T>(field, returnFields), dpar, tran, commandTimeout)); }
public static async Task <int> DeleteByIdsAsync <T>(this IDbConnection conn, object ids, IDbTransaction tran = null, int?commandTimeout = null) { if (CommonUtil.ObjectIsEmpty(ids)) { return(0); } var builder = BuilderFactory.GetBuilder(conn); DynamicParameters dpar = new DynamicParameters(); dpar.Add("@ids", ids); return(await conn.ExecuteAsync(builder.GetDeleteByIdsSql <T>(), dpar, tran, commandTimeout)); }
public static IEnumerable <dynamic> GetByIdsDynamic <T>(this IDbConnection conn, object ids, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null) { if (CommonUtil.ObjectIsEmpty(ids)) { return(Enumerable.Empty <dynamic>()); } var builder = BuilderFactory.GetBuilder(conn); DynamicParameters dpar = new DynamicParameters(); dpar.Add("@ids", ids); return(conn.Query(builder.GetByIdsSql <T>(returnFields), dpar, tran, true, commandTimeout)); }
public static PageEntity <dynamic> GetPageForOracleDynamic <T>(this IDbConnection conn, int pageIndex, int pageSize, string where = null, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); PageEntity <dynamic> pageEntity = new PageEntity <dynamic>(); pageEntity.Total = GetTotal <T>(conn, where, param, tran, commandTimeout); if (pageEntity.Total > 0) { pageEntity.Data = GetByPageIndexDynamic <T>(conn, pageIndex, pageSize, where, param, returnFields, orderBy, tran, commandTimeout); } else { pageEntity.Data = Enumerable.Empty <dynamic>(); } return(pageEntity); }
public static PageEntity <dynamic> GetPageDynamic <T>(this IDbConnection conn, int pageIndex, int pageSize, string where = null, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); PageEntity <dynamic> pageEntity = new PageEntity <dynamic>(); using (var reader = conn.QueryMultiple(builder.GetPageSql <T>(pageIndex, pageSize, where, returnFields, orderBy), param, tran, commandTimeout)) { pageEntity.Total = reader.ReadFirstOrDefault <long>(); if (pageEntity.Total > 0) { pageEntity.Data = reader.Read <dynamic>(); } else { pageEntity.Data = Enumerable.Empty <dynamic>(); } } return(pageEntity); }
/// <summary> /// for sqlserver insert identity /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <param name="updateFields"></param> /// <param name="update"></param> /// <returns></returns> public static int InsertIdentityOrUpdate <T>(this IDbConnection conn, T model, string updateFields = null, bool update = true, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); int effectRow = 0; dynamic total = conn.ExecuteScalar <dynamic>(builder.GetExistsKeySql <T>(), model, tran, commandTimeout); if (total > 0) { if (update) { effectRow += Update(conn, model, updateFields, tran, commandTimeout); } } else { effectRow += InsertIdentity(conn, model, tran, commandTimeout); } return(effectRow); }
public static async Task <dynamic> GetByIdDynamicAsync <T>(this IDbConnection conn, object id, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.QueryFirstOrDefaultAsync <dynamic>(builder.GetByIdSql <T>(returnFields), new { id = id }, tran, commandTimeout)); }
public static int Delete <T>(this IDbConnection conn, object id, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Execute(builder.GetDeleteByIdSql <T>(), new { id = id }, tran, commandTimeout)); }
public static async Task <long> GetTotalAsync <T>(this IDbConnection conn, string where = null, object param = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteScalarAsync <long>(builder.GetTotalSql <T>(where), param, tran, commandTimeout)); }
public static async Task <IEnumerable <dynamic> > GetAllDynamicAsync <T>(this IDbConnection conn, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.QueryAsync(builder.GetAllSql <T>(returnFields, orderBy), null, tran, commandTimeout)); }
public static async Task <IdType> GetIdentityAsync <IdType>(this IDbConnection conn, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteScalarAsync <IdType>(builder.GetIdentitySql(), null, tran, commandTimeout)); }
public static async Task <IdType> GetSequenceNextAsync <IdType>(this IDbConnection conn, string sequence, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteScalarAsync <IdType>(builder.GetSequenceNextSql(sequence), null, tran, commandTimeout)); }
public static async Task <int> DeleteByWhereAsync <T>(this IDbConnection conn, string where, object param, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteAsync(builder.GetDeleteByWhereSql <T>(where), param, tran, commandTimeout)); }
public static async Task <int> DeleteAllAsync <T>(this IDbConnection conn, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteAsync(builder.GetDeleteAllSql <T>(), null, tran, commandTimeout)); }
public static IdType GetSequenceCurrent <IdType>(this IDbConnection conn, string sequence, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.ExecuteScalar <IdType>(builder.GetSequenceCurrentSql(sequence), null, tran, commandTimeout)); }
public static int Update <T>(this IDbConnection conn, T model, string updateFields = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Execute(builder.GetUpdateSql <T>(updateFields), model, tran, commandTimeout)); }
public static async Task <IEnumerable <dynamic> > GetByPageIndexDynamicAsync <T>(this IDbConnection conn, int pageIndex, int pageSize, string where = null, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.QueryAsync(builder.GetByPageIndexSql <T>(pageIndex, pageSize, where, returnFields, orderBy), param, tran, commandTimeout)); }
public static async Task <dynamic> GetByWhereFirstDynamicAsync <T>(this IDbConnection conn, string where, object param = null, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.QueryFirstOrDefaultAsync <dynamic>(builder.GetByWhereFirstSql <T>(where, returnFields), param, tran, commandTimeout)); }
public static IEnumerable <T> GetAll <T>(this IDbConnection conn, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Query <T>(builder.GetAllSql <T>(returnFields, orderBy), null, tran, true, commandTimeout)); }
public static IEnumerable <T> GetByPageIndex <T>(this IDbConnection conn, int pageIndex, int pageSize, string where = null, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Query <T>(builder.GetByPageIndexSql <T>(pageIndex, pageSize, where, returnFields, orderBy), param, tran, true, commandTimeout)); }
public static IEnumerable <dynamic> GetByWhereDynamic <T>(this IDbConnection conn, string where, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Query(builder.GetByWhereSql <T>(where, returnFields, orderBy), param, tran, true, commandTimeout)); }
public static async Task <IEnumerable <T> > GetBySkipTakeAsync <T>(this IDbConnection conn, int skip, int take, string where = null, object param = null, string returnFields = null, string orderBy = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.QueryAsync <T>(builder.GetBySkipTakeSql <T>(skip, take, where, returnFields, orderBy), param, tran, commandTimeout)); }
public static DataTable GetSchemaTable <T>(this IDbConnection conn, string returnFields = null, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(GetDataTable(conn, builder.GetSchemaTableSql <T>(returnFields), null, tran, commandTimeout)); }
public static async Task <dynamic> InsertReturnIdAsync <T>(this IDbConnection conn, T model, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteScalarAsync <dynamic>(builder.GetInsertReturnIdSql <T>(), model, tran, commandTimeout)); }
public static async Task <int> UpdateByWhereAsync <T>(this IDbConnection conn, T model, string where, string updateFields, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteAsync(builder.GetUpdateByWhereSql <T>(where, updateFields), model, tran, commandTimeout)); }
public static async Task <int> InsertIdentityAsync <T>(this IDbConnection conn, T model, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(await conn.ExecuteAsync(builder.GetInsertIdentitySql <T>(), model, tran, commandTimeout)); }
public static int Insert <T>(this IDbConnection conn, T model, IDbTransaction tran = null, int?commandTimeout = null) { var builder = BuilderFactory.GetBuilder(conn); return(conn.Execute(builder.GetInsertSql <T>(), model, tran, commandTimeout)); }