public IEnumerable <T> QueryByPage(int startNumber, int endNumber, out int totleRecords, Dictionary <string, object> querys) { try { var items = new List <T>(); var number = 0; var sqlBuild = QueryByPageSql.Invoke(Sql.QueryByPage, querys); var parameters = sqlBuild.Parameters; parameters.AddDynamicParams(new { StartNumber = startNumber, EndNumber = endNumber }); DatabaseProxy.QueryMulti(sqlBuild.RawSql, parameters, reader => { items = reader.Read <T>().ToList(); number = reader.Read <int>().Single(); return(true); }); totleRecords = number; return(items); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public IEnumerable <T> QueryByPage(int startNumber, int endNumber, out int totleRecords) { try { var items = new List <T>(); var number = 0; DatabaseProxy.QueryMulti(Sql.QueryByPage, new { StartNumber = startNumber, EndNumber = endNumber }, reader => { items = reader.Read <T>().ToList(); number = reader.Read <int>().Single(); return(true); }); totleRecords = number; return(items); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public IEnumerable <T> GetAll() { try { return(DatabaseProxy.Query <T>(Sql.QueryAll)); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public T Get(int id) { try { return(DatabaseProxy.Query <T>(Sql.QueryOne, new { Id = id }).First()); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public int Delete(int id) { try { var count = DatabaseProxy.Delete(Sql.Delete, id); return(count); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public int Update(T t) { if (t == null) { throw new ArgumentNullException(typeof(T).Name); } try { var count = DatabaseProxy.Update(Sql.Update, t); return(count); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }
public int AddBatch(IList <T> items) { if (items == null) { throw new ArgumentNullException(typeof(T).Name); } try { var count = DatabaseProxy.InsertList(Sql.Add, items); return(count); } catch (SqlException sqlException) { throw RepositoryException.DatabaseError(sqlException); } catch (Exception exception) { throw RepositoryException.GeneralError(exception); } }