linq.js使用

1.引用 linq.min.js

 语法：http://neue.cc/reference.htm

常用写法：

1.普通Where

var picList = Enumerable.From(self.subProcess())
.Where(function (x) { return x.OrderID() == vOrderID && x.OrderNum() == vOrderNum && x.ProcessID() == vProcessID && x.ProcessDetailID() == vProcessDetailID; })
.FirstOrDefault().PictureList();

2.动态where查询

var funfilter;
if (!!searchVal || (vcluetype != "" && vcluetype != null) || vcluelevel != null) {
funfilter = ""
var str = "((x.Mobile || '').indexOf('" + searchVal + "') > -1 || (x.UserName || '').indexOf('" + searchVal + "') > -1 || (x.ClueName || '').indexOf('" + searchVal + "') > -1)";

if (vcluetype != '' && vcluetype != null) {
str += " && x.MaintainType == '" + vcluetype + "' ";
}
if (vcluelevel != null) {
str += " && x.ClueLevel == '" + vcluelevel + "'";
}

funfilter = "x => (" + str + ")";;

var newList = Enumerable.From(self.list_all()).Where(funfilter).ToArray();

3.Any存在判断

 

4.ForEach

   Enumerable.From(picList).ForEach(function (val, index) {
                imgSrc=imgs.eq(index).css("backgroundImage");
                val.PicUrl(imgSrc.slice(5, imgSrc.length - 2));
                val.PicStatus("loaded");
                val.PicFullName(val.ProcessDetailID() + "_" + val.PicName());
            });

 5.Group By 分组统计

 var objects = [
        { cnt: 2, id: 1,name:'a',xcnt: 21  },
        { cnt: 3, id: 2,name:'b',xcnt: 21  },
         { cnt: 1, id: 2,name:'b',xcnt: 1  },
        { cnt: 2, id: 3 ,name:'c',xcnt: 1 }
       ];

        
var rst = Enumerable.From(objects).GroupBy("{id:$.id,name:$.name}",
    null,
    function (key, g) {
        var result = {
            id: key.id,
            name: key.name,
            total: g.Sum("$.cnt"),
            xCount:g.Sum("$.xcnt")
        }
        return result;
    }, 
    "$.id + '-'+ $.name").ToArray();
    
var rst2= Enumerable.From(objects)
               .GroupBy("{id:$.id,name:$.name}",
                      null,  
                           "{id:$.id,name:$.name,Amounts: $$.Sum('$.cnt'),XAmounts: $$.Sum('$.xcnt')}",
                           "$.id + '-'+ $.name").ToArray();