/// <summary>
/// 构造
/// </summary>
public DapperRepository()
{
//改string映射
//SqlMapper.AddTypeMap(typeof(string), System.Data.DbType.AnsiString);
Conn = DataBasePool.getInstance().getConnection();//DbConnectionFactory.CreateDbConnection();
unitOfWork = new UnitOfWork <T>(Conn);
}
//===========================通用方法==============================
public static DataTable Query(string cmd)
{
mySqlC = DataBasePool.getInstance().getConnection();
MySqlDataReader sdr = new MySqlCommand(cmd, mySqlC).ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sdr);
mySqlC.Close();
return(dt);
}
public long Count(string sql, object paramPairs = null)
{
var conn = DataBasePool.getInstance().getConnection();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var result = conn.Query <long>(sql, paramPairs).SingleOrDefault();
DataBasePool.getInstance().releaseConnection(conn);
return(result);
}
public int Execute(string sql, object paramPairs = null)
{
var conn = DataBasePool.getInstance().getConnection();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var result = conn.Execute(sql, paramPairs);
DataBasePool.getInstance().releaseConnection(conn);
return(result);
}
public bool IsExist(string sql)
{
try {
var conn = DataBasePool.getInstance().getConnection();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var result = conn.ExecuteScalar(sql) != null;
DataBasePool.getInstance().releaseConnection(conn);
return(result);
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public T QueryBuild <T>(Func <IDbConnection, T> callback) where T : class
{
try
{
var conn = DataBasePool.getInstance().getConnection();
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var result = callback(conn);
DataBasePool.getInstance().releaseConnection(conn);
return(result);
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}