/// <summary>
/// 附加where条件
/// </summary>
/// <param name="initSqlString">sql字符串</param>
/// <param name="tableAlias">topic表在查询中的别名</param>
/// <param name="searchEntity">查询条件实体</param>
/// <returns></returns>
public Sql AppendSqlWhere(string initSqlString, string tableAlias, SearchShip searchEntity)
{
Sql sql = Sql.Builder.Append(initSqlString);
if (!string.IsNullOrEmpty(searchEntity.ShipNameLike))
{
sql.Where(string.Format(" {0}.Name like '%{1}%'", tableAlias, searchEntity.ShipNameLike));
}
return(sql);
}
/// <summary>
/// 获取轮船列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="searchEntity"></param>
/// <param name="orderEnums"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <Ship> GetListByPager(int pageIndex, int pageSize, SearchShip searchEntity, IEnumerable <ShipEnum> orderEnums, out int recordCount)
{
string sqlStr =
@"select * from ship t";
Sql sql = AppendSqlWhere(sqlStr, "t", searchEntity);
if (orderEnums != null && orderEnums.Any())
{
sql = sql.OrderByT(orderEnums);
}
return(DatabaseProvider.GetEntitiesByPager <Ship>(pageIndex, pageSize, sql, out recordCount));
}
/// <summary>
/// 分页获取轮船列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="searchEntity"></param>
/// <param name="orderEnums"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <Ship> GetListByPager(int pageIndex, int pageSize, SearchShip searchEntity, IEnumerable <ShipEnum> orderEnums, out int recordCount)
{
return(_shipDAL.GetListByPager(pageIndex, pageSize, searchEntity, orderEnums, out recordCount));
}
