asp.net实现的MVC跨数据库多表联合动态条件查询功能示例_asp.netmvc动态查询

asp.net

跨数据库

164 浏览量更新于2023-03-16 评论 1 收藏 63KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

asp.net实现的实现的MVC跨数据库多表联合动态条件查询功能示例跨数据库多表联合动态条件查询功能示例

主要介绍了asp.net实现的MVC跨数据库多表联合动态条件查询功能,结合实例形式较为详细分析了asp.net基于MVC架构的跨数据库多表联合查询功能实现技巧,需要的朋友可以参考

下

本文实例讲述了asp.net实现的MVC跨数据库多表联合动态条件查询功能。分享给大家供大家参考，具体如下：

一、控制器中方法一、控制器中方法

[HttpGet]

public ActionResult Search()

{

ViewBag.HeadTitle = "搜索";

ViewBag.MetaKey = "\"123\"";

ViewBag.MetaDes = "\"456\"";

string whereText = "";

if (Security.HtmlHelper.GetQueryString("first", true) != string.Empty)

{

whereText += " and a.ParentId='" + StringFilter("first", true)+"'";

}

if (Security.HtmlHelper.GetQueryString("second", true) != string.Empty)

whereText += " and a.categoryId='" + StringFilter("second",true)+"'";

string valueStr = "";

if (Security.HtmlHelper.GetQueryString("theme", true) != string.Empty)

valueStr += StringFilter("theme", true) + ",";

if (Security.HtmlHelper.GetQueryString("size", true) != string.Empty)

valueStr += StringFilter("size", true) + ",";

if (Security.HtmlHelper.GetQueryString("font", true) != string.Empty)

valueStr += StringFilter("font", true) + ",";

if (Security.HtmlHelper.GetQueryString("shape", true) != string.Empty)

valueStr += StringFilter("shape", true) + ",";

if (Security.HtmlHelper.GetQueryString("technique", true) != string.Empty)

valueStr += StringFilter("technique", true) + ",";

if (Security.HtmlHelper.GetQueryString("category", true) != string.Empty)

valueStr += StringFilter("category", true) + ",";

if (Security.HtmlHelper.GetQueryString("place", true) != string.Empty)

valueStr += StringFilter("place", true) + ",";

if (Security.HtmlHelper.GetQueryString("price", true) != string.Empty)

valueStr += StringFilter("price", true) + ",";

if (valueStr != "")

{

valueStr=valueStr.Substring(0, valueStr.Length - 1);

whereText += " and f.valueId in("+valueStr+")";

}

if (Security.HtmlHelper.GetQueryString("searchKeys", true) != string.Empty)

whereText += " and a.SaleTitle like '%'" + StringFilter("searchKes", true) + "'%' or a.SaleDes like '%'" + StringFilter("searchKes", true) + "'%' or a.SaleAuthor like '%'" + StringFilter("searchKes", true) + "'%' or a.KeyWords like '%'" + StringFilter("searchKes", true) + "'%' or g.valueProperty like '%'" + StringFilter("searchKes", true) + "'%'";

int pageSize = 50;

int pageIndex = HttpContext.Request.QueryString["pageIndex"].Toint(1);

List<string> searchInfo = Search(pageIndex, pageSize, whereText, 1);

if (Security.HtmlHelper.GetQueryString("sort", true) != string.Empty)

{

string sort = StringFilter("sort", true);

switch (sort)

{

case "1": //综合即默认按照上架时间降序排列即按照id降序

searchInfo = Search(pageIndex, pageSize, whereText, 1);

break;

case"2": //销量

searchInfo = Search(pageIndex, pageSize, whereText,0, "saleTotal");

break;

case "3": //收藏

searchInfo = Search(pageIndex, pageSize, whereText,0, "favoritesTotal");

break;

case "4": //价格升序

searchInfo = Search(pageIndex, pageSize, whereText,1);

break;

case "5": //价格降序

searchInfo = Search(pageIndex, pageSize, whereText,2);

break;

}

string jsonStr = searchInfo[0];

ViewData["jsondata"] = jsonStr;

int allCount = Utility.Toint(searchInfo[1], 0);

ViewBag.AllCount = allCount;

ViewBag.MaxPages = allCount % pageSize == 0 ? allCount / pageSize : (allCount / pageSize + 1).Toint(1);

return View();

}

[NonAction]

public List<string> Search(int pageIndex, int pageSize, string whereText, int orderByPrice, string orderBy = "SaleId")

{

BLL.Products searchInfoBLL = new BLL.Products();

List<string> searchInfo = searchInfoBLL.GetSearchInfo(pageIndex, pageSize, whereText, orderByPrice,orderBy);

return searchInfo;

}

注：Security.HtmlHelper.GetQueryString(），StringFilter(）为自己封装的方法，用于过滤参数值

二、二、BLL层方法层方法

using System;

using System.Web;

using System.Web.Caching;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.Common;

using System.Web.Script.Serialization;

using FotosayMall.Model;

using FotosayMall.Common;

using System.Text.RegularExpressions;

using System.IO;

using Newtonsoft.Json;

using Newtonsoft.Json.Converters;

using FotosayMall.MVC.Models;

namespace FotosayMall.BLL

{

public class Products

{

private readonly DAL.Products dal = new DAL.Products();

/// <summary>

/// 分页查询，检索页数据

/// </summary>

/// <param name="pageIndex"></param>

/// <param name="pageSize"></param>

/// <param name="orderByPrice">价格排序：0默认，1升序，2降序</param>

/// <returns></returns>

public List<string> GetSearchInfo(int pageIndex, int pageSize, string whereText, int orderByPrice, string orderBy = "SaleId")

{

DataSet searchInfoTables = dal.GetSearchInfo(pageIndex, pageSize, whereText);

//总记录数

int allCount = Utility.Toint(searchInfoTables.Tables[1].Rows[0]["rowsTotal"], 0);

var searchInfo = from list in searchInfoTables.Tables[0].AsEnumerable().OrderByDescending(x => x.Table.Columns[orderBy])

select new SearchModel

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余2页未读，立即下载

weixin_38748721

粉丝: 2
资源: 901

会员权益专享

asp.net实现的MVC跨数据库多表联合动态条件查询功能示例

评论0

会员权益专享

最新资源

asp.net实现的MVC跨数据库多表联合动态条件查询功能示例

评论0

jquery easyUI 实现动态生成多条件查询功能

使用Java 8 Lambda表达式将实体映射到DTO的操作

Asp.Net Core 3.1 MVC+EF Core +SqlSugar ORM框架实例 多层架构示例Demo

实现数据分页功能在ASP.NET MVC4中的应用

在ASP.NET MVC4中使用EasyUI实现数据搜索和过滤功能

使用Entity Framework在ASP.NET MVC5中进行数据库操作

EasyUI拖拽和排序功能的实现在ASP.NET MVC4中

EasyUI的动态表单生成在ASP.NET MVC4中的实现

asp.net mvc 连接数据库的代码

用ASP.NET MVC连接Oracle数据库 将查询表格显示在网页上

使用ASP.NET MVC，连接数据库需注册登录代码

asp.net core mvc学生管理系统

asp.net mvc 数据库存储过程转化到函数内

ASP.NET MVC使用Table显示数据库数据

asp.net mvc学生信息管理系统 mysql

asp.net mvc项目实战

ASP.NET core MVC 向模型中添加list，并保存进数据库

基于asp.net mvc结合数据库字段给我写一个加入购物车功能

asp.net core mvc教务管理系统

ASP.NET MVC导入excel文件到数据库功能

会员权益专享

最新资源

Asp.Net Core 3.1 MVC+EF Core +SqlSugar ORM框架实例多层架构示例Demo

用ASP.NET MVC连接Oracle数据库将查询表格显示在网页上