欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

灵活掌握Asp.net MVC中GridView的使用方法

程序员文章站 2023-11-22 10:52:34
本文教程为大家分享了gridview控件的使用方法和具体实现代码,供大家参考,具体内容如下 models文件下实体类: public class custom...

本文教程为大家分享了gridview控件的使用方法和具体实现代码,供大家参考,具体内容如下

models文件下实体类:

 public class customer
 {
 public int id { get; set; } 
 public string companyname { get; set; } 
 public string contacttitle { get; set; }
 public string address { get; set; }
 public string city { get; set; }  
 public string country { get; set; }
 public string phone { get; set; }
 public datetime founded { get; set; }
 }

 public class customersviewmodel

 {
 public iqueryable<customer> customers { get; set; }

 public paginginfo paginginfo { get; set; }

 public string jsonpaginginfo { get; set; }
 }

 public static class expresssionbuilder
 {
 private static readonly methodinfo containsmethod = typeof(string).getmethod("contains");
 private static readonly methodinfo startswithmethod = typeof(string).getmethod("startswith", new type[] { typeof(string) });
 private static readonly methodinfo endswithmethod = typeof(string).getmethod("endswith", new type[] { typeof(string) });


 public static expression<func<t,bool>> getexpression<t>(ilist<filterobject> filters)
 {
  if (filters.count == 0)
  return null;

  parameterexpression param = expression.parameter(typeof(t), "t");
  expression exp = null;

  if (filters.count == 1)
  exp = getexpression<t>(param, filters[0]);
  else if (filters.count == 2)
  exp = getexpression<t>(param, filters[0], filters[1]);
  else
  {
  while (filters.count > 0)
  {
   var f1 = filters[0];
   var f2 = filters[1];

   if (exp == null)
   exp = getexpression<t>(param, filters[0], filters[1]);
   else
   exp = expression.andalso(exp, getexpression<t>(param, filters[0], filters[1]));

   filters.remove(f1);
   filters.remove(f2);

   if (filters.count == 1)
   {
   exp = expression.andalso(exp, getexpression<t>(param, filters[0]));
   filters.removeat(0);
   }
  }
  }

  return expression.lambda<func<t, bool>>(exp, param);
 }

 private static expression getexpression<t>(parameterexpression param, filterobject filter)
 {
  memberexpression member = expression.property(param, filter.column);
  //constantexpression constant = expression.constant(filter.value);

  //新的逻辑来处理可空decimal和datetime值
  unaryexpression constant = null;
  if (member.type == typeof(decimal?))
  {
  constant = expression.convert(expression.constant(decimal.parse(filter.value)) , member.type);
  }
  else if (member.type == typeof(datetime?))
  {
  constant = expression.convert(expression.constant(datetime.parse(filter.value)), member.type);
  }
  else
  {
  constant = expression.convert(expression.constant(filter.value), member.type);
  }


  switch (filter.operator)
  {
  case filteroperator.equals:
   return expression.equal(member, constant);

  case filteroperator.greaterthan:
   return expression.greaterthan(member, constant);

  case filteroperator.greaterthanorequal:
   return expression.greaterthanorequal(member, constant);

  case filteroperator.lessthan:
   return expression.lessthan(member, constant);

  case filteroperator.lessthanorequal:
   return expression.lessthanorequal(member, constant);

  case filteroperator.contains:
   return expression.call(member, containsmethod, constant);

  case filteroperator.startswith:
   return expression.call(member, startswithmethod, constant);

  case filteroperator.endswith:
   return expression.call(member, endswithmethod, constant);

  case filteroperator.notequal:
   return expression.negate(expression.equal(member, constant));
  }

  return null;
 }

 private static binaryexpression getexpression<t> (parameterexpression param, filterobject filter1, filterobject filter2)
 {
  expression bin1 = getexpression<t>(param, filter1);
  expression bin2 = getexpression<t>(param, filter2);

  return expression.andalso(bin1, bin2);
 }
 }

 public class paginginfo
 {
 public list<int> pageoptions { get; set; }

 public bool showpageoptions { get; set; }

 public int totalitems { get; set; }
 public int itemsperpage { get; set; }
 public int currentpage { get; set; }

 public int totalpages
 {
  get { return (int)math.ceiling((decimal)totalitems / (itemsperpage != 0 ? itemsperpage : 1)); }
 }

 public sortobject sort { get; set; }

 public ilist<filterobject> filters { get; set; }

 public string searchterm { get; set; }
 }

 public class sortobject
 {
 public string sortcolumn { get; set; }

 public sortdirection direction { get; set; }
 }

 public class filterobject
 {
 public string column { get; set; } 

 public string value { get; set; }

 public filteroperator operator { get; set; }

 public filterconjunction conjunction { get; set; }
 }


 /********* enums *************/
 public enum sortdirection
 {
 notset,
 ascending,
 descending
 }

 public enum filteroperator
 {
 contains,
 greaterthan,
 greaterthanorequal,
 lessthan,
 lessthanorequal,
 startswith,
 endswith,
 equals,
 notequal
 }

 public enum filterconjunction
 {
 and,
 or
 }

 public class extensions
 {
 public static string getwhereclause(filterobject filterobj, type valuetype)
 {  
  string whereclause = "true";
  if (valuetype != typeof (datetime))
  {
  switch (filterobj.operator)
  {
   case filteroperator.contains:
   if (valuetype == typeof (string))
    whereclause += string.format(" {0} {1}.contains(\"{2}\")", filterobj.conjunction,
    filterobj.column, filterobj.value);
   break;
   case filteroperator.greaterthan:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1} > {2}", filterobj.conjunction, filterobj.column,
    filterobj.value);
   break;
   case filteroperator.greaterthanorequal:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1} >= {2}", filterobj.conjunction, filterobj.column,
    filterobj.value);
   break;
   case filteroperator.lessthan:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1} < {2}", filterobj.conjunction, filterobj.column,
    filterobj.value);
   break;
   case filteroperator.lessthanorequal:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1} <= {2}", filterobj.conjunction, filterobj.column,
    filterobj.value);
   break;
   case filteroperator.startswith:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1}.startswith(\"{2}\")", filterobj.conjunction,
    filterobj.column, filterobj.value);
   break;
   case filteroperator.endswith:
   if (valuetype != typeof (string))
    whereclause += string.format(" {0} {1}.endswith(\"{2}\")", filterobj.conjunction,
    filterobj.column, filterobj.value);
   break;
   case filteroperator.equals:

   whereclause +=
    string.format(valuetype == typeof (string) ? " {0} {1} == \"{2}\"" : " {0} {1} == {2}",
    filterobj.conjunction, filterobj.column, filterobj.value);
   break;
   case filteroperator.notequal:

   whereclause +=
    string.format(valuetype == typeof (string) ? " {0} {1} != \"{2}\"" : " {0} {1} != {2}",
    filterobj.conjunction, filterobj.column, filterobj.value);
   break;
   default:
   throw new argumentoutofrangeexception();
  }
  }
  else
  {
  datetime dt;
  datetime.tryparse(filterobj.value, out dt);

  switch (filterobj.operator)
  {
   case filteroperator.contains:   
   break;
   case filteroperator.greaterthan:

    whereclause += string.format(" {0} {1} > datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   case filteroperator.greaterthanorequal:

   whereclause += string.format(" {0} {1} >= datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   case filteroperator.lessthan:

   whereclause += string.format(" {0} {1} < datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   case filteroperator.lessthanorequal:
   whereclause += string.format(" {0} {1} <= datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   case filteroperator.startswith:   
   break;
   case filteroperator.endswith:   
   break;
   case filteroperator.equals:
   whereclause += string.format(" {0} {1} == datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   case filteroperator.notequal:
   whereclause += string.format(" {0} {1} != datetime(\"{2}\")", filterobj.conjunction, filterobj.column, dt);
   break;
   default:
   throw new argumentoutofrangeexception();
  }
  }
  return whereclause;
 }
 }

 

 public class gridviewmodelprovider
 { 
 internal static customersviewmodel getcustomersviewmodel(mydbcontext db, paginginfo pagingdata)
 { 
  int totalitems = 0;
  var model = new customersviewmodel()
  {

  customers = getresources(db.customers.asqueryable(), pagingdata, out totalitems),  
  paginginfo = new paginginfo()
  {
   currentpage = pagingdata.currentpage,
   itemsperpage = pagingdata.itemsperpage,
   pageoptions = new list<int>() { 10, 25, 50, 100 },
   showpageoptions = true,
   searchterm = pagingdata.searchterm,
   sort = pagingdata.sort,
   filters = pagingdata.filters
  }  
  };

  model.paginginfo.totalitems = totalitems;
  model.jsonpaginginfo = json.encode(model.paginginfo);

  return model;
 }

 private static iqueryable<customer> getresources(iqueryable<customer> customers, paginginfo pagingdata, out int totalitems)
 {
  var customers = customers;

  //search
  if (!string.isnullorempty(pagingdata.searchterm))
  {
  customers = customers.where(x => (x.companyname.contains(pagingdata.searchterm) || x.contacttitle.contains(pagingdata.searchterm)));
  }

  //filter
  if (pagingdata.filters != null)
  {  
  foreach (var filterobj in pagingdata.filters)
  {
   switch (filterobj.column)
   {
   case "city":
    if (filterobj.value.tolower() != "all")
    customers = customers.where(extensions.getwhereclause(filterobj, typeof(string)));
    break;

   //add other filter columns here
   }
  }    
  }


  totalitems = customers.count();

  //sort
  customers = customers.orderby(x => x.id);
  if (pagingdata.sort != null)
  {
  switch (pagingdata.sort.direction)
  {
   case sortdirection.ascending:
   if (pagingdata.sort.sortcolumn == "companyname")
   {
    customers = customers.orderby(x => x.companyname);
   }
   else if (pagingdata.sort.sortcolumn == "contacttitle")
   {
    customers = customers.orderby(x => x.contacttitle);
   }
   break;
   case sortdirection.descending:
   if (pagingdata.sort.sortcolumn == "companyname")
   {
    customers = customers.orderbydescending(x => x.companyname);
   }
   else if (pagingdata.sort.sortcolumn == "contacttitle")
   {
    customers = customers.orderbydescending(x => x.contacttitle);
   }
   break;
   case sortdirection.notset:
   default:
   break;
  }
  }
  customers = customers
  .skip((pagingdata.currentpage - 1) * pagingdata.itemsperpage).take(pagingdata.itemsperpage);

  return customers;
 } 
 }

 /// <summary>
 /// 启用查询谓词的高效,动态组合。
 /// </summary>
 public static class predicatebuilder
 {
 /// <summary>
 /// 创建一个计算结果为true的谓词。
 /// </summary>
 public static expression<func<t, bool>> true<t>() { return param => true; }

 /// <summary>
 /// 创建一个计算结果为false的谓词
 /// </summary>
 public static expression<func<t, bool>> false<t>() { return param => false; }

 /// <summary>
 /// 创建一个从指定的lambda表达式的谓词表达式。
 /// </summary>
 public static expression<func<t, bool>> create<t>(expression<func<t, bool>> predicate) { return predicate; }

 /// <summary>
 /// 结合了第二第一谓词使用逻辑“and”。
 /// </summary>
 public static expression<func<t, bool>> and<t>(this expression<func<t, bool>> first, expression<func<t, bool>> second)
 {
  return first.compose(second, expression.andalso);
 }

 /// <summary>
 /// 结合了第二第一谓词使用逻辑“or”。
 /// </summary>
 public static expression<func<t, bool>> or<t>(this expression<func<t, bool>> first, expression<func<t, bool>> second)
 {
  return first.compose(second, expression.orelse);
 }

 /// <summary>
 ///否定谓词
 /// </summary>
 public static expression<func<t, bool>> not<t>(this expression<func<t, bool>> expression)
 {
  var negated = expression.not(expression.body);
  return expression.lambda<func<t, bool>>(negated, expression.parameters);
 }

 /// <summary>
 /// 使用指定的合并函数,合并第二和第一表达式
 /// </summary>
 static expression<t> compose<t>(this expression<t> first, expression<t> second, func<expression, expression, expression> merge)
 {
  //第二参数映射到第一参数
  var map = first.parameters
  .select((f, i) => new { f, s = second.parameters[i] })
  .todictionary(p => p.s, p => p.f);

  //第一lambda表达式的参数替换在第二lambda表达式参数
  var secondbody = parameterrebinder.replaceparameters(map, second.body);

  //从第一个表达式创建一个带参数的合并lambda表达式
  return expression.lambda<t>(merge(first.body, secondbody), first.parameters);
 }

 class parameterrebinder : expressionvisitor
 {
  readonly dictionary<parameterexpression, parameterexpression> map;

  parameterrebinder(dictionary<parameterexpression, parameterexpression> map)
  {
  this.map = map ?? new dictionary<parameterexpression, parameterexpression>();
  }

  public static expression replaceparameters(dictionary<parameterexpression, parameterexpression> map, expression exp)
  {
  return new parameterrebinder(map).visit(exp);
  }

  protected override expression visitparameter(parameterexpression p)
  {
  parameterexpression replacement;

  if (map.trygetvalue(p, out replacement))
  {
   p = replacement;
  }

  return base.visitparameter(p);
  }
 }
 }

mydbcontext.cs代码:

 public class mydbcontext : dbcontext
 {
 public mydbcontext()
  : base("defaultconnection")
 {

 }

 public dbset<customer> customers { get; set; }

 protected override void onmodelcreating(dbmodelbuilder modelbuilder)
 {  
  modelbuilder.entity<customer>().property(c => c.companyname).hasmaxlength(40);
  modelbuilder.entity<customer>().property(c => c.contacttitle).hasmaxlength(40);
 }
 }

homecontroller.cs控制器:

 public class homecontroller : controller
 {
 public actionresult index()
 {
  var model = new customersviewmodel()
  {
  customers = null,
  paginginfo = new paginginfo()
  {
   currentpage=1,
   itemsperpage= 10,
   pageoptions = new list<int>() { 10,25, 50, 100},
   showpageoptions= true,
   totalitems=1
  }
  };
  return view(model);
 }

 public actionresult getcustomers(paginginfo pagingdata)
 {
  var db = new mydbcontext();
  var model = gridviewmodelprovider.getcustomersviewmodel(db, pagingdata);  
  return partialview("_customerspartial", model);
 }

 public actionresult about()
 {
  viewbag.message = "您的应用程序描述页面。";

  return view();
 }

 public actionresult contact()
 {
  viewbag.message = "您的联系页面。";

  return view();
 }
 }

home视图文件夹下:

_customerspartial.cshtml

@model mesoft.gridview.models.customersviewmodel

@*在这里写下返回的数据的详细信息*@
<span class="gridview-data-details" style="display:none;">@html.raw(model.jsonpaginginfo)</span>

<table class="table table-bordered table-striped">
 <thead>
 <tr class="gridview-list-header">
  <th>
  @(html.displaynamefor(x => x.customers.firstordefault().id))
  </th>
  <th class="sortable" data-sort="companyname">
  @(html.displaynamefor(x => x.customers.firstordefault().companyname))
  </th>
  <th class="sortable" data-sort="contacttitle">
  @(html.displaynamefor(x => x.customers.firstordefault().contacttitle))
  </th>
  <th>
  @(html.displaynamefor(x => x.customers.firstordefault().country))
  </th>
  <th>
  @(html.displaynamefor(x => x.customers.firstordefault().city))
  </th>
  <th>
  @(html.displaynamefor(x => x.customers.firstordefault().address))
  </th>
  <th>
  @(html.displaynamefor(x => x.customers.firstordefault().phone))
  </th>
  <th>
  @html.displaynamefor(x=> x.customers.firstordefault().founded)
  </th>
 </tr>
 </thead>

 <tbody id="customerstable" class="gridview-list-items">
 @if (model.customers.any())
 {
  foreach (var c in model.customers)
  {
  <tr>
   <td class="value">@c.id</td>
   <td class="value">@c.companyname</td>
   <td class="value">@c.contacttitle</td>
   <td class="value">@c.country</td>
   <td class="value">@c.city</td>
   <td class="description">@c.address</td>
   <td class="value">@c.phone</td>
   <td>@c.founded</td>
  </tr>
  }
 }
 else
 {
  <tr>
  <td colspan="8">
   <div class="alert alert-warning alert-dismissable">
   <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
   <strong>警告!</strong> 没有客户找到!
   </div>
  </td>
  </tr>
 }

 @html.raw(viewbag.script)
 </tbody>

</table>

_gridviewpartial.cshtml

@model mesoft.gridview.models.customersviewmodel

<!-- gridview-->
<div class="gridview gridview1">
 <!-- gridview header-->
 <div class="gridview-header">
 <!--gridview的头的左边部分-->
 <div class="col-sm-6">
  <div class="gridview-search">
  <div class="search input-group">
   <input class="form-control" placeholder="search" type="search">
   <span class="input-group-btn">
   <button class="btn btn-default" type="button">
    <span class="fa fa-search"></span>
    <span class="sr-only">search</span>
   </button>
   </span>
  </div>
  </div>
 </div>

 <!-- gridview的头右边部分-->
 <div class="col-sm-6 text-right">
  <!-- 这里添加任何筛选操作-->
  @{
  string[] cityfilters = {"istanbul", "trabzon", "ankara", "izmir", "samsun", "erzurum"};
  }

  根据城市筛选: 
  <div class="btn-group">
  <button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown">
   select city <span class="caret"></span>
  </button>
  <ul class="dropdown-menu filter-parent" role="menu">
   @foreach (var city in cityfilters)
   {
   <li><a href="#" class="filter"
    data-filter-column="city"    
    data-filter-value="@city"
    data-filter-operator="@mesoft.gridview.models.filteroperator.equals"
    data-filter-conjunction="@mesoft.gridview.models.filterconjunction.and">@city</a></li>
   }
   <li class="divider"></li>
   <li class="active"><a href="#" class="filter"
     data-filter-column="city"
     data-filter-value="all">all</a></li>
  </ul>
  </div>
 </div>
 </div>

 <!-- gridview viewport-->
 <div class="gridview-viewport" id="viewport"
  data-getdata-function="@url.action("getcustomers", "home")"
  data-default-pagesize="10">
 <div class="gridview-canvas" style="min-height:400px;">
  @*data will load here*@
 </div>
 <div class="loading gridview gridview-loader">
  <img src="~/content/images/loading.gif" />
 </div>
 </div>
 <!-- gridview的分页区域-->
 <div class="gridview-footer">
 @html.displayfor(x => x.paginginfo, "pager")
 </div>
</div>

about.cshtml

@{
 viewbag.title = "about";
}
<h2>@viewbag.title.</h2>
<h3>@viewbag.message</h3>

<p>#</p>

contact.cshtml

@{
 viewbag.title = "contact";
}
<h2>@viewbag.title.</h2>
<h3>@viewbag.message</h3>

<address>
 <strong>support:</strong> <a href="827937686@qq.com">827937686@qq.com</a><br /> 
</address>

index.cshtml

@model mesoft.gridview.models.customersviewmodel

@{
 viewbag.title = "home page";
}

<div class="jumbotron">
 <h1>gridview</h1>
 <p class="lead">简单易用,开发简单</p>
 <p><a href="#" class="btn btn-primary btn-lg">learn more »</a></p>
</div>
<!-- gridview area-->
<div class="row">
 @html.partial("_gridviewpartial") 
</div>

@section scripts {
 <script>
 $('.gridview1').megridview(); 
 //$('.gridview2').megridview();
 </script>

}

shared文件夹下:

_layout.cshtml

<!doctype html>
<html>
<head>
 <meta charset="utf-8" />
 <meta name="viewport" content="width=device-width, initial-scale=1.0">
 <title>@viewbag.title -gridview的用法示例应用程序</title>
 @styles.render("~/content/css")
 @scripts.render("~/bundles/modernizr")

</head>
<body>
 <div class="navbar navbar-inverse navbar-fixed-top">
 <div class="container">
  <div class="navbar-header">
  <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
   <span class="icon-bar"></span>
   <span class="icon-bar"></span>
   <span class="icon-bar"></span>
  </button>
  @html.actionlink("gridview", "index", "home", new { area = "" }, new { @class = "navbar-brand" })
  </div>
  <div class="navbar-collapse collapse">
  <ul class="nav navbar-nav">
   <li>@html.actionlink("home", "index", "home")</li>
   <li>@html.actionlink("about", "about", "home")</li>
   <li>@html.actionlink("contact", "contact", "home")</li>
  </ul>
  @*@html.partial("_loginpartial")*@
  </div>
 </div>
 </div>
 <div class="container body-content">
 @renderbody()
 <hr />
 <footer>
  <p>© @datetime.now.year - wulex</p>
 </footer>
 </div>

 @scripts.render("~/bundles/jquery")
 @scripts.render("~/bundles/bootstrap")
 @rendersection("scripts", required: false)
</body>
</html>

运行结果如图:

灵活掌握Asp.net MVC中GridView的使用方法

为大家附3个精彩的专题:

asp.net控件使用手册

asp.net数据绑定控件使用汇总

asp.net控件使用汇总

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。