/// <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));
}
