8,497
社区成员
发帖
与我相关
我的任务
分享
List<AFileTools.Model.ItemDataBase> lst = new List<AFileTools.Model.ItemDataBase>();
lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 20:00:00", Value = "1.1" });
lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 21:00:00", Value = "2.2" });
lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 20:00:00", Value = "3.1" });
lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 21:00:00", Value = "111.1" });
var query = from q in db.GetList
group q by DateTime.Parse(q.DT).ToString("yyyy-MM-dd") into g
select new {DT=g.Key,Value=g.Average(r=>float.Parse(r.NValue) ) };
dataGridView1.DataSource=query.ToList();
//List<AFileTools.Model.ItemDataBase> lst = new List<AFileTools.Model.ItemDataBase>();
//lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 20:00:00", Value = "1.1" });
//lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 21:00:00", Value = "2.2" });
//lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 20:00:00", Value = "3.1" });
//lst.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 21:00:00", Value = "111.1" });
var query = from q in db.GetList
group q by DateTime.Parse(q.DT).ToString("yyyy-MM-dd") into g
select new {DT=g.Key,Value=g.Sum(r=>float.Parse(r.NValue) ) };
dataGridView1.DataSource=query.ToList();
public class db
{
string dT;
string nValue;
public string DT
{
set { dT = value; }
get { return dT; }
}
public string NValue
{
set { nValue = value; }
get { return nValue; }
}
public static List<db> GetList
{
get
{
return new List<db>() {
new db(){ DT = "2010-1-1 20:00:00", NValue = "1.1" },
new db(){ DT = "2010-1-1 21:00:00", NValue = "2.2" },
new db(){ DT = "2010-1-2 20:00:00", NValue = "3.1" },
new db(){ DT = "2010-1-2 21:00:00", NValue = "111.1" }
};
}
}
}
List<Model.ItemDataBase> lstData = new List<AFileTools.Model.ItemDataBase>();
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 20:00:00", Value = "1.1" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 21:00:00", Value = "2.2" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 20:00:00", Value = "3.1" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 21:00:00", Value = "111.1" });
IEnumerable<IGrouping<string, string>> query =
from Data in lstData
group Data by Data.DT.Substring(0, Data.DT.IndexOf(' ')) into g
select g.Average(s => float.Parse(s.Value));
List<Model.ItemDataBase> lstData = new List<AFileTools.Model.ItemDataBase>();
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 20:00:00", Value = "1.1" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-1 21:00:00", Value = "2.2" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 20:00:00", Value = "3.1" });
lstData.Add(new AFileTools.Model.ItemDataBase() { DT = "2010-1-2 21:00:00", Value = "111.1" });
IEnumerable<IGrouping<string, string>> query =
from Data in lstData
group Data.Value by Data.DT.Substring(0, Data.DT.IndexOf(' '));
foreach (IGrouping<string, string> q in query)
{
MessageBox.Show(q.Key);
float avg = q.Average(s => float.Parse(s));
MessageBox.Show(Utils.Utilitys.Round(avg, 1).ToString());
}