public bool Insert(T t)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.Insert <T>(t));
}
}
public IList <T> GetList()
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.GetList <T>().ToList());
}
}
public IList <T> GetList(PredicateGroup group)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.GetList <T>(group).ToList());
}
}
public bool Delete(T t)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.Delete <T>(t));
}
}
public bool Delete(PredicateGroup group)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.Delete <T>(group));
}
}
public T Get(Guid id)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.Get <T>(id));
}
}
public IList <T> GetPager(PredicateGroup group, PageQuery query)
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
return(conn.GetPage <T>(group, query.OrderType.ConvertToSort <T>(), query.PageIndex - 1, query.PageCount).ToList());
}
}
public TResult Get <TResult>(string sql) where TResult : new()
{
using (IDbConnection conn = DbConnectFactory.GetPostgresqlConnection())
{
conn.Open();
conn.BeginTransaction();
IDataReader reader = conn.ExecuteReader(sql);
DataTable table = reader.GetSchemaTable();
return(DataConvertExtension <TResult> .Get(table));
}
}
public void Transaction(Predicate <IDbConnection> action)
{
using (var conn = DbConnectFactory.GetPostgresqlConnection())
{
var transaction = conn.BeginTransaction();
try
{
action(conn);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
public TResult TransactionResult <TResult>(Func <IDbConnection, TResult> funData)
{
using (var conn = DbConnectFactory.GetPostgresqlConnection())
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
var result = funData(conn);
transaction.Commit();
return(result);
}
catch
{
transaction.Rollback();
throw;
}
finally
{
conn.Close();
}
}
}
public bool ExcuteSqlWithTransaction(string sql)
{
using (var conn = DbConnectFactory.GetPostgresqlConnection())
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
int result = conn.Execute(sql);
transaction.Commit();
return(result > 0);
}
catch
{
transaction.Rollback();
return(false);
}
finally
{
conn.Close();
}
}
}
public List <TResult> TransactionResult <TResult>(string sql) where TResult : new()
{
using (var conn = DbConnectFactory.GetPostgresqlConnection())
{
conn.Open();
var transaction = conn.BeginTransaction();
try
{
IDataReader reader = conn.ExecuteReader(sql);
transaction.Commit();
return(new List <TResult>());
}
catch
{
transaction.Rollback();
return(new List <TResult>());
}
finally
{
conn.Close();
}
}
}
