public Tuple <IEnumerable <A>, IEnumerable <B> > Muilt <A, B>(string muilSql, object paramObj = null) { using (var muilt = CurConn.QueryMultiple(muilSql, paramObj)) { var one = muilt.Read <A>(); var two = muilt.Read <B>(); return(Tuple.Create <IEnumerable <A>, IEnumerable <B> >(one, two)); } }
public IDbTransaction BeginTran() { if (CurTran != null) { return(CurTran); } CurConn.Open(); CurTran = CurConn.BeginTransaction(); return(CurTran); }
public Tuple <IEnumerable <T>, int> Page <T>(string countSql, string dataSql, object paramObj = null) { using (var muilt = CurConn.QueryMultiple(string.Format("{0};{1}", countSql, dataSql), paramObj)) { int count = muilt.Read <int>().FirstOrDefault(); if (count <= 0) { return(new Tuple <IEnumerable <T>, int>(new List <T>(), 0)); } var data = muilt.Read <T>(); return(new Tuple <IEnumerable <T>, int>(data, count)); } }
public void Dispose() { //销毁事务 if (CurTran != null) { CurTran.Dispose(); CurTran = null; } //销毁连接 if (CurConn != null && CurConn.State == ConnectionState.Open) { CurConn.Dispose(); CurConn.Close(); CurConn = null; } }
public bool Clear <T>() where T : class, new() { return(CurConn.DeleteAll <T>()); }
public long Add <T>(T model) where T : class, new() { return(CurConn.Insert <T>(model)); }
public Task <bool> RemoveAsync <T>(T model) where T : class, new() { return(CurConn.DeleteAsync <T>(model)); }
public Task <bool> ClearAsync <T>() where T : class, new() { return(CurConn.DeleteAllAsync <T>()); }
public bool Modify <T>(T model) where T : class, new() { return(CurConn.Update <T>(model)); }
public bool Remove <T>(T model) where T : class, new() { return(CurConn.Delete <T>(model)); }
public Task <T> ScalarAsync <T>(string sql, object paramObj = null, IDbTransaction CurTran = null) { return(CurConn.ExecuteScalarAsync <T>(sql, paramObj, CurTran)); }
public Task <int> ExecuteAsync(string sql, object paramObj = null, IDbTransaction CurTran = null) { return(CurConn.ExecuteAsync(sql, paramObj, CurTran)); }
public Task <T> FindAsync <T>(string sql, object paramObj = null, IDbTransaction CurTran = null) { return(CurConn.QueryFirstOrDefaultAsync <T>(sql, paramObj, CurTran)); }
public Task <IEnumerable <T> > FindAllAsync <T>() where T : class, new() { return(CurConn.GetAllAsync <T>()); }
public IEnumerable <T> FindAll <T>() where T : class, new() { return(CurConn.GetAll <T>()); }
public Task <T> FindAsync <T>(object id) where T : class, new() { return(CurConn.GetAsync <T>(id)); }
public T Find <T>(object id) where T : class, new() { return(CurConn.Get <T>(id)); }
public Task <int> AddAsync <T>(T model) where T : class, new() { return(CurConn.InsertAsync <T>(model)); }
public Task <bool> ModifyAsync <T>(T model) where T : class, new() { return(CurConn.UpdateAsync <T>(model)); }
public Task <IEnumerable <T> > QueryAsync <T>(string sql, object paramObj = null, IDbTransaction CurTran = null) { return(CurConn.QueryAsync <T>(sql, paramObj, CurTran)); }
public int Execute(string sql, object paramObj = null, IDbTransaction CurTran = null) { return(CurConn.Execute(sql, paramObj, CurTran)); }