public DbQueryResult GetOnlineService(OnlineServiceQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1 ");
if (query.ServiceType.HasValue)
{
stringBuilder.AppendFormat(" and ServiceType = " + query.ServiceType);
}
if (query.ServiceId.HasValue)
{
stringBuilder.AppendFormat(" and Id = " + query.ServiceId);
}
if (query.Status.HasValue)
{
stringBuilder.AppendFormat(" Status = " + query.Status);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_Service", "ID", stringBuilder.ToString(), "*"));
}
public static DbQueryResult GetOnelineService(OnlineServiceQuery query)
{
return(new OnlineServiceDao().GetOnlineService(query));
}
