解决: c# dataTable添加列 添加平均值

c# dataTable添加列 添加平均值

原因: 导出excel 中缺少字段 “平均值” ,是sql 查询中返回的datatable 没有该字段,只能后计算添加

1.添加列

                System.Data.DataColumn column = new DataColumn("FAvgDay", typeof(int));
                dt.Columns.Add(column);

2.然后遍历每个row,遍历每行各列 求和 最后求平均值 完成赋值给列字段

                foreach (DataRow dr in dt.Rows)
                    {
                        int sumCount = 0;
                        foreach (DataColumn dc in dt.Columns)
                        {
                            if (dc.ColumnName.ToString() != "FAssetID" && dc.ColumnName.ToString() != "FAvgDay") {
                                sumCount = sumCount + int.Parse(dr[dc].ToString());
                            }
                        }
                        dr["FAvgDay"] = sumCount / (dt.Columns.Count - 2);
                    }

3.完整代码

DataTable dt = sReport.SQueryReportDayTrackPoint(this._Token.FSqlConnectString, General.Instance.GetStrArray2StrIn(this._Parameter.FGUIDs)
                            , this._Parameter.FStartTime, this._Parameter.FEndTime, _Parameter.FPageIndex, _Parameter.FPageSize);
                    dt.Columns.Remove("FGUID");
                    dt.Columns.Remove("RowNo");
                    System.Data.DataColumn column = new DataColumn("FAvgDay", typeof(int));
                    dt.Columns.Add(column);
                    dt.Columns["FAvgDay"].SetOrdinal(1);
                   foreach (DataRow dr in dt.Rows)
                    {
                        int sumCount = 0;
                        foreach (DataColumn dc in dt.Columns)
                        {
                            if (dc.ColumnName.ToString() != "FAssetID" && dc.ColumnName.ToString() != "FAvgDay") {
                                sumCount = sumCount + int.Parse(dr[dc].ToString());
                            }
                        }
                        dr["FAvgDay"] = sumCount / (dt.Columns.Count - 2);
                    }
                    ExportCommon export = new ExportCommon();
                    string cPath = "/Files/" + DateTime.Now.ToString("yyyyMMdd");//子目录
                    string fileName = "日轨迹数量报表";
                    string result = export.ExportData(dt, cPath, fileName, this._Parameter.FLanguage, this._Parameter.FExportType);