三层架构实现分页查询

 public IList<Customer> GetPage(CustomerSearchVO vo, int pageIndex, int pageSize, out int totalCount)
        {
            IList<Customer> list = new List<Customer>();
            Customer customer = null;

            string where = "";
            if (Regex.IsMatch(vo.Name, "^[a-zA-Z]+$") && vo.Name != "")
            {
                where += " and pinyin like '%" + vo.Name + "%'";
                where += " or pinyin_abbr like '%" + vo.Name + "%'";
            }
            else
            {
                where += " and name like '%" + vo.Name + "%'";
            }
            if (vo.Phone != "")
            {
                where += "