在web端使用Linq查询

来源：互联网发布：网络设备监控软件编辑：程序博客网时间：2024/06/07 11:17

web端也能使用linq查询,百度一下linq.js.
下面是别人的链接
最新版
老版本

下面是记录自己项目中的具体使用
1. 老版本 (可以舍弃掉使用最新的)

//引入老版本的js<script src="../Script/libs/JSLINQ.js"></script>   ///根据组织ID查询出部门   var selectDe = JSLINQ(Depeart).Where(function (item) {                  return item.ParentID == Organiza[i].OrganizationID;                 }).OrderBy(function (item) {                  return item.Orders;                  }).Select(function (item) {                  return item;                  });

新版本

  <script src="../Script/libs/linq.min.js"></script>//查询是否存在根组织(总公司)  var count = Enumerable.From(data).Select("p=>p.OrganizationID=='" + FirstOrang.OrganizationID + "'").Count();    console.info(count);    if (count<=0) { //不存在根组织 加入                  html += "<div class='list-group'>";                  html += "  <a href='#' class='list-group-item ' style='background-color: #f5f5f5;'>";                  html += "  <h4 class='list-group-item-heading'>" + FirstOrang.OrganizationName + "</h4></a>";                  html += "</div>";                } //将数据根据组织分组  var orangid = ""; var group1 = Enumerable.From(data).Distinct("p=>p.OrganizationName").GroupBy("p=>p.OrganizationName").ToArray(); console.info(group1); //遍历组织 两次循环才能遍历到组织  group1.forEach(function (v,i) {           v.source.forEach(function (sv, si) {           html += "<div class='list-group'>";          html += "  <a href='#' class='list-group-item ' style='background-color: #f5f5f5;'>";          html += "  <h4 class='list-group-item-heading'>" + sv.OrganizationName + "</h4></a>";           orangid = sv.OrganizationID;           //将数据根据部门和组织分组           var Degroup = Enumerable.From(data).Where("p=>p.OrganizationID=='" + orangid + "'").OrderBy("p=>p.Orders").GroupBy("p=>p.DepartmentName").ToArray();console.info(Degroup);              //遍历部门        Degroup.forEach(function (dv, di) {       var depeartid = "";       dv.source.forEach(function (dv1,di1) {        if (depeartid == dv1.DepartmentID) {          depeartid = dv1.DepartmentID;          }         else {          console.info(dv1.DepartmentName);          depeartid = dv1.DepartmentID;        var count = dv.source.length;         //加入部门开始        html += "<div class='dlist'>";       html += " <a href='javascript:void(0)' class='list-group-item depeart' onclick='ShowMedia(" + dv1.DID + ")'>";      html += "<span class='badge' style='background-color:#d9534f'>" + count + "</span>";      if (dv1.DID == '19' || dv1.DID == '17') {      html += "  <h4 class='list-group-item-heading' style='font-size: 12px'>" + dv1.DepartmentName + " </h4>";      } else {      html += "  <h4 class='list-group-item-heading' >" + dv1.DepartmentName + " </h4>";             }           //加入部门结束          //遍历人员开始   html += "<div class='showsuer de" + dv1.DID + "'>";    dv.source.forEach(function (uv,ui) {       var img = uv.UserFaceImage == null || uv.UserFaceImage == "" ? "/Images/headpic.png" : uv.UserFaceImage;      html += ' <div class="media" onclick="UserDetal(' + uv.UserID + ')" >';      html += ' <a class="media-left" href="#">';       html += '  <img class="media-object img-circle" src="' + img + '"  alt="媒体对象">';       html += '   </a>';                                                                    html += '   <div class="media-body">';                                                                    html += '<dl><dt><strong class="title">' + uv.TrueName + '</strong><span class="tel">' + uv.MobilePhone + '</span><span class="oright">人气 <code>' + uv.ClickCount + '</code></span></dt><dt> <code><code class="star-1"></code><code class="star-1"></code><code class="star-1"></code><code class="star-1"></code><code class="star-1"></code><cite>5.0</cite>分<span class="oright" style="color:#888;">成交 <code>0</code></span></code></dt><dt class="ddt"><code><span style=" color:#888;">点评 <code>0</code><span><span style="margin-left:10px; color:#888;">好评 <code>0</code></span><span style="margin-left:10px;color:#888;">差评 <code>0</code></span></span></span></code></dt><dd style="color: rgb(51, 51, 51);"><code><i class="placeIcon"></i><span id="1distanceSupp4">角色:' + uv.RoleName + '</span><span class="oright"> </span></code></dd></dl>';                                                                    html += ' </div>';                                                                    html += '</div>';                                                            });                                                           //遍历人员结束                                                             html += "</div>";                                            }                                        });                                    });                                    html += "</div>";                                });                            });

阅读全文

0 0