public static PetaPoco.Page<PetapocoOrm.MonitorLog.FileWatch> GetList(int pageSize, int pageIndex, int serverId, string filename) { PetaPoco.Sql sb = new Sql(); sb.Append("select * from FileWatch where 1=1"); if (serverId >= 1) { sb.Append(" and ServerName in ( select ServerName from ServerList where id=" + serverId + ") ", serverId); } if (!string.IsNullOrEmpty(filename)) { sb.Append(" and filename like '%" + WXQ.Common.StringPlus.SQLSafe(filename) + "%'"); } sb.Append(" order by filename asc , adddate desc "); PetaPoco.Page<PetapocoOrm.MonitorLog.FileWatch> result = PetapocoOrm.MonitorLog.Db.GetInstance().Page<PetapocoOrm.MonitorLog.FileWatch>(pageIndex, pageSize, sb.ToString()); return result; }