public JsonResult GetAdressList(string adress = "", int number = -1, int status = -1, int pageIndex = 1, int pageSize = 10) { var totalCount = 0; var where = " where IsDelete=0"; if (!String.IsNullOrEmpty(adress)) { where += " and Adress like'%" + adress.ReplaceSql() + "%'"; } if (number == 0) { where += " and Number<20"; } else if (number == 1) { where += " and Number>=20 and Number<=50"; } else if (number == 2) { where += " and Number>50"; } if (status > -1) { where += " and Status=" + status; } var list = _adressManager.GetAdressList(out totalCount, where, pageIndex, pageSize); return(Json(new { dataList = list, recordCount = totalCount }, JsonRequestBehavior.AllowGet)); }