public List <WDT_PqTj> PqGroup(int Id)
{
using (var db = base.NewDB())
{
var a = db.A6dot2Tab2.Where(x => x.isValid == 1 && x.isOilType == 1 && x.Tab1_Id == Id).GroupBy(x => new { x.equip_PqName }).Select(g => new { PqName = g.Key.equip_PqName, ExceedNum = g.Sum(x => x.isExceed) });
List <WDT_PqTj> r = new List <WDT_PqTj>();
foreach (var item in a)
{
WDT_PqTj tmp = new WDT_PqTj();
tmp.pqName = item.PqName;
tmp.tjNum = item.ExceedNum;
r.Add(tmp);
}
return(r);
}
}
public List <WDT_PqTj> PqGroup(string starttime, string endtime)
{
using (var db = base.NewDB())
{
var a = db.A6dot2Tab2.Where(x => x.isValid == 1 && x.isOilType == 1 && x.Tab1_Belong.uploadtime.CompareTo(starttime) >= 0 && x.Tab1_Belong.uploadtime.CompareTo(endtime) <= 0).GroupBy(x => new { x.equip_PqName }).Select(g => new { PqName = g.Key.equip_PqName, ExceedNum = g.Sum(x => x.isExceed) });
//var b = db.A6dot2Tab2.Where(x => x.isValid == 1 && x.isOilType == 1).First().Tab1_Belong.uploadtime;
List <WDT_PqTj> r = new List <WDT_PqTj>();
foreach (var item in a)
{
WDT_PqTj tmp = new WDT_PqTj();
tmp.pqName = item.PqName;
tmp.tjNum = item.ExceedNum;
r.Add(tmp);
}
return(r);
}
}
