Example #1
0
        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));
        }