//public CatListRepository(DbConnectionFactory dbConnectionFactory) : base(dbConnectionFactory.Master)
//{
//}
public CatList GetById(int id)
{
var sqlbuilder = new SqlBuilderSingle();
sqlbuilder.Equals(nameof(CatList.Id), id);
return(this.GetAll(sqlbuilder).FirstOrDefault());
//string sql = string.Format(@"select * from CatList where Id = '{0}'", id);
//return Master.Query<CatList>(sql).FirstOrDefault();
//return Master.QueryFirst<CatList>(sql);
}
/// <summary>
/// 支出传入SqlBuliderSingle
/// </summary>
/// <param name="sqlBuilderSingle"></param>
/// <returns></returns>
protected int Count(SqlBuilderSingle sqlBuilderSingle)
{
return(Count(sqlBuilderSingle.WhereSQL.ToString(), sqlBuilderSingle.Parameters));
}
/// <summary>
/// 单表分页方法支持传入sqlbuilder
/// </summary>
/// <param name="page"></param>
/// <param name="sqlBuilderSingle"></param>
/// <param name="orderBy"></param>
/// <param name="sort"></param>
/// <returns></returns>
protected PageCollection <TEntity> GetPageCollection(PageParameter page, SqlBuilderSingle sqlBuilderSingle,
string orderBy, string sort = "desc")
{
return(this.GetPageCollection(page, sqlBuilderSingle.ToString(), orderBy, sqlBuilderSingle.Parameters, sort));
}
/// <summary>
/// 适用于单表的查询,支持SqlBuilderSingle
/// </summary>
/// <param name="sqlBuilderSingle"></param>
/// <returns></returns>
protected IEnumerable <TEntity> GetAll(SqlBuilderSingle sqlBuilderSingle)
{
return(GetAll(whereString: sqlBuilderSingle.ToString(), parameters: sqlBuilderSingle.Parameters));
}
