public BasePageList<BaseDepartmentViewModel> GetManageCityList(BaseDepartmentQueryModel query) { return _baseservice.GetManageCityList(query); }
/// <summary> /// 获取部门列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public BasePageList<BaseDepartmentViewModel> GetManageCityList(BaseDepartmentQueryModel query) { const string spName = "sp_common_pager"; const string tableName = @"sys_department "; const string fields = "`id`, `name`, `areaid`, `tel`, `email`, `sort`, `remark`, `code`"; var orderField = string.IsNullOrWhiteSpace(query.Order) ? " sort asc " : query.Order; var sqlWhere = new StringBuilder("1=1"); //菜单名称 if (!string.IsNullOrWhiteSpace(query.name)) { sqlWhere.AppendFormat(" and name like '%{0}%' ", query.name); } var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize, query.PageIndex); var list = Helper.ExecutePaging<BaseDepartmentViewModel>(model, query.Echo); return list; }