1.DataGridView增加汇总行(Linq循环获取数据)
private void BMbyBindData()
{
DateTime time1 = DateTime.Parse(DateTime.Now.ToShortDateString() + " 23:59:59");
DateTime time2 = DateTime.Parse(DateTime.Now.ToShortDateString() + " 00:00:00");
var Datainfo = (from name in new ReportTwo().BuMenWeek(time1, time2).AsEnumerable()
select new SumColumnModel
{
rows =(name[0]).ToString(),
BusinessUnitIdName = name[1].ToString(),
SystemUserIdName = name[2].ToString(),
zhoujifen = Convert.ToInt32(name[3]),
zong = Convert.ToInt32(name[4]),
}).ToList();
SumColumnModel zm = new SumColumnModel();//实例化类
zm.rows = ""; //增加汇总行的序号
zm.BusinessUnitIdName = "合计";
int a = Datainfo.Select(x => x.zong).Sum(); //得到各小组回执总和
double d = Convert.ToDouble(a) / 99999;
zm.SystemUserIdName = string.Format("{0:0.00%}", d); //得到完成率
zm.zhoujifen = Datainfo.