/// <summary> /// 根据筛选条件 (获取分页组件) /// </summary> /// <param name="userQuery">筛选条件</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">显示条数</param> /// <returns></returns> public PagingDataSet<UserAddress> GetUserAddress(UserAddressQuery userAddressQuery, int pageIndex, int pageSize) { int totalCount = 0; int totalPage = 0; string whereSql = string.Empty; string orderBy = string.Empty; HandleQueryByString(userAddressQuery, out whereSql);//查询 HandleOrderByEunm(userAddressQuery, out orderBy);//排序 return GetPageListByCache<int>(pageIndex, pageSize, out totalCount, out totalPage, whereSql, orderBy, i => i.Id); }
/// <summary> /// 根据枚举排序 /// </summary> /// <param name="rolesQuery"></param> /// <param name="order"></param> private void HandleOrderByEunm(UserAddressQuery userAddressQuery, out string order) { order = ""; switch (userAddressQuery.UserAddressSortBy) { case UserAddressSortBy.Name: order = "name ASC"; break; case UserAddressSortBy.Name_Desc: order = "name DESC"; break; case UserAddressSortBy.Phone: order = "phone ASC"; break; case UserAddressSortBy.Phone_Desc: order = "phone DESC"; break; } }
/// <summary> /// 查询用户地址 /// </summary> /// <param name="rolesQuery">查询参数</param> /// <param name="sql"></param> private void HandleQueryByString(UserAddressQuery userAddressQuery, out string sql) { sql = "1=1 "; if (userAddressQuery.UserId.HasValue) sql += $"and userid in (select userid from sc_user where userid = \"{userAddressQuery.UserId}\") "; if (userAddressQuery.UserName.IsNotNullAndWhiteSpace()) sql += $"and userid in (select userid from sc_user where username = \"{userAddressQuery.UserName}\") "; if (!string.IsNullOrWhiteSpace(userAddressQuery.Name)) sql += $"and (name like \"%{userAddressQuery.Name}%\")"; if (!string.IsNullOrWhiteSpace(userAddressQuery.Phone)) sql += $"and (phone like \"%{userAddressQuery.Phone}%\")"; if (!string.IsNullOrWhiteSpace(userAddressQuery.Address)) sql += $"and (address like \"%{userAddressQuery.Address}%\")"; if (userAddressQuery.Provinceid.HasValue) sql += $"and provinceid = {userAddressQuery.Provinceid} "; if (userAddressQuery.Cityid.HasValue) sql += $"and cityid = {userAddressQuery.Cityid} "; if (userAddressQuery.Areaid.HasValue) sql += $"and areaid = {userAddressQuery.Areaid} "; if (userAddressQuery.IsDefault.HasValue) sql += $"and is_default = {userAddressQuery.IsDefault} "; if (userAddressQuery.IsDeleted.HasValue) sql += $"and is_deleted = {userAddressQuery.IsDeleted} "; }
public IActionResult ManageAddress(int?pageIndex, int pageSize = 20) { NameValueCollection from = RequestHelper.GetQueryParams(Request); UserAddressQuery userAddressQuery = new UserAddressQuery(); userAddressQuery.Name = from["name"]; userAddressQuery.Phone = from["phone"]; userAddressQuery.Address = from["address"]; userAddressQuery.UserName = from["userName"]; string isDefault = from["isDefault"], isDeleted = from["isDeleted"], provinceid = from["provinceid"], cityid = from["cityid"], areaid = from["areaid"], userId = from["userId"]; if (!string.IsNullOrWhiteSpace(isDefault)) { userAddressQuery.IsDefault = isDefault.AsBool(); } if (!string.IsNullOrWhiteSpace(isDeleted)) { userAddressQuery.IsDeleted = isDeleted.AsBool(); } if (!string.IsNullOrWhiteSpace(userId)) { userAddressQuery.UserId = long.Parse(userId); } if (!string.IsNullOrWhiteSpace(provinceid)) { ViewData["provinceid"] = userAddressQuery.Provinceid = provinceid.AsInt(); } if (!string.IsNullOrWhiteSpace(cityid)) { ViewData["cityid"] = userAddressQuery.Cityid = cityid.AsInt(); } if (!string.IsNullOrWhiteSpace(areaid)) { ViewData["areaid"] = userAddressQuery.Areaid = areaid.AsInt(); } if (!string.IsNullOrWhiteSpace(userAddressQuery.UserName)) { ViewData["userName"] = userAddressQuery.UserName; } if (!string.IsNullOrWhiteSpace(userAddressQuery.Name)) { ViewData["name"] = userAddressQuery.Name; } if (!string.IsNullOrWhiteSpace(userAddressQuery.Phone)) { ViewData["phone"] = userAddressQuery.Phone; } if (!string.IsNullOrWhiteSpace(userAddressQuery.Address)) { ViewData["address"] = userAddressQuery.Address; } Dictionary <bool, string> builtinValues = new Dictionary <bool, string> { { true, "是" }, { false, "否" } }; ViewData["IsDeleted"] = ViewData["IsDefault"] = new SelectList(builtinValues.Select(m => new { text = m.Value, value = m.Key.ToString().ToLower() }), "value", "text", userAddressQuery.IsDefault); pageIndex = pageIndex ?? 1; userAddressQuery.UserAddressSortBy = UserAddressSortBy.Name; PagingDataSet <UserAddress> userAddressPaging = userAddressService.GetUserAddress(userAddressQuery, pageIndex.Value, pageSize); if (pageIndex > 1 && (userAddressPaging == null || userAddressPaging.Count() == 0)) { userAddressPaging = userAddressService.GetUserAddress(userAddressQuery, pageSize, pageIndex.Value - 1); } return(View(userAddressPaging)); }
/// <summary> /// 根据筛选条件 (获取分页组件) /// </summary> /// <param name="userQuery">筛选条件</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">显示条数</param> /// <returns></returns> public PagingDataSet <UserAddress> GetUserAddress(UserAddressQuery userAddressQuery, int pageIndex, int pageSize) { return(userAddressRepository.GetUserAddress(userAddressQuery, pageIndex, pageSize)); }