public int Execute(T obj, string sql, object par) { var conn = GetConn(obj); return(conn.Execute(sql: sql, param: par, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn))); }
public R Get <R>(T obj, string sql, object par) { var conn = GetConn(obj); return(conn.QueryFirstOrDefault <R>(sql: sql, param: par, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn))); }
public Paging <R> GetPaging <R>(ISelectResult <R> query) { var lst = GetList(query); var conn = GetConn(null); var count = conn.QuerySingleOrDefault <long>(sql: query.CountSqlCmd, param: query.Param, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn)); return(new Paging <R>(count, lst)); }
public List <R> GetList <R>(ISelectResult <R> query) { Type typeFromHandle = typeof(R); ConstructorInfo right = typeFromHandle.GetConstructors(BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic).FirstOrDefault((ConstructorInfo x) => x.GetParameters().Length == 0); var conn = GetConn(query.DBModel as T); if (null == right && typeFromHandle.FullName.Contains("AnonymousType")) { using (IDataReader reader = conn.ExecuteReader(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn))) { return(GetList(reader.Parse <R>().ToList())); } } return(GetList(conn.Query <R>(sql: query.SqlCmd, param: query.Param, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn)))); }
public List <R> GetList <R>(T obj, string sql, object par) { var conn = GetConn(obj); return(GetList(conn.Query <R>(sql: sql, param: par, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn)))); }
public List <T> GetList(string sql, object par) { var conn = GetConn(null); var lst = conn.Query <T>(sql: sql, param: par, commandTimeout: CommandTimeout, transaction: DBTool.GetTransaction(conn)); return(GetList(lst)); }