C# foreach循環、Linq循環以後增長彙總行

時間 2019-12-07 標籤 c# foreach 循環 linq 循環以後增長彙總行

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.Select(x => x.zhoujifen).Sum();     //周積分總和
            zm.zong = Datainfo.Select(x => x.zong).Sum();           //各小組回執總和

            List<SumColumnModel> zmlist = new List<SumColumnModel>();
            Datainfo.Add(zm);

            CR.DataSource = Datainfo;
            CR.Height = CR.Rows.Count * CR.RowTemplate.Height + CR.ColumnHeadersHeight;

            CR.ReadOnly = true;

            CR.Columns["rows"].HeaderText = "排名";
            CR.Columns["rows"].Width = 150;
            CR.Columns["BusinessUnitIdName"].HeaderText = "組別";
            CR.Columns["BusinessUnitIdName"].Width = 250;
            CR.Columns["SystemUserIdName"].HeaderText = "完成率（回執總量/本組任務量）";
            CR.Columns["SystemUserIdName"].Width = 300;
            CR.Columns["zhoujifen"].HeaderText = "本週積份量";
            CR.Columns["zhoujifen"].Width = 200;
            CR.Columns["zong"].HeaderText = "總回執量";
            CR.Columns["zong"].Width = CR.Width - 850;
        }

2.foreach循環後增長彙總行

public static void ZuZhou()
        {   
            StringBuilder messb = new StringBuilder();
            if (mrzuznow != null)
            {
                messb.Append(@"<table width=""100%"">");
                messb.Append("<tr>");
                messb.Append(@"<td colspan=""4"">");
                messb.Append("【本週小組排名】：");
                messb.Append("</td>");
                messb.Append("</tr>");
                messb.Append("<tr>");
                messb.Append("<td>");
                messb.Append("排名 ");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append(" 組別");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append("回執總量 ");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append("完成率 ");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append("本週回執量 ");
                messb.Append("</td>");
                messb.Append("</tr>");

                foreach (DataRow item in mrzuznow.Tables[0].Rows)
                {
                    messb.Append("<tr>");
                    messb.Append("<td>");
                    messb.Append("TOP:【" + item["rows"].ToString() + "】");
                    messb.Append("</td>");
                    messb.Append(@"<td>" + item["BusinessUnitIdName"].ToString() + "");
                    messb.Append("</td>");
                    messb.Append(@"<td>" + item["zong"].ToString() + "");
                    double i = Math.Round(Convert.ToDouble(item["bv"]), 2);
                    string ii = (i * 100).ToString() + "%";
                    messb.Append("<td >" + ii + "");
                    messb.Append("</td>");
                    messb.Append(@"<td>" + item["zhoujifen"].ToString() + "");
                    messb.Append("</td>");
                    messb.Append("</tr>");

                }

                int rows = mrzuznow.Tables[0].Rows.Count + 1;

                int sumzhoujifen = 0;
                foreach (DataRow item in mrzuznow.Tables[0].Rows)
                {
                    sumzhoujifen +=Convert.ToInt32( item["zhoujifen"]);
                }
                int Sumzong = 0;
                foreach (DataRow item in mrzuznow.Tables[0].Rows)
                {
                    Sumzong += Convert.ToInt32(item["zong"]);
                }
                

                double d = Convert.ToDouble(Sumzong) / 38291;
                string SumSystemUserIdName = string.Format("{0:0.00%}", d);   //獲得完成率

                messb.Append("<tr>");
                messb.Append("<td>");
                messb.Append("");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append(" 合計");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append("" + Sumzong + "");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append("" + SumSystemUserIdName + " ");
                messb.Append("</td>");
                messb.Append("<td>");
                messb.Append(""+sumzhoujifen+"");
                messb.Append("</td>");
                messb.Append("</tr>");
                messb.Append("</table>");
			}
		}