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)); }