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