datagrid纵列合计

 //纵列合计
                DS_PlanPrice.vi_PlanPriceRow drTotal = vi.Newvi_PlanPriceRow();
                drTotal.ProductId = Convert.ToString(dtProduct.Rows[i][dtProduct.ProductIdColumn.ColumnName]);
                drTotal.PriceTypeName = "Total";

                foreach (DS_PlanPrice.vi_PlanPriceRow vRow in vi.Rows)
                {
                    if (vRow.ProductId == dtProduct.Rows[i][dtProduct.ProductIdColumn.ColumnName].ToString())
                    {
                        drTotal.Budget1 = drTotal.Budget1 + vRow.Budget1;
                        drTotal.Budget2 = drTotal.Budget2 + vRow.Budget2;
                        drTotal.Budget3 = drTotal.Budget3 + vRow.Budget3;
                        drTotal.Budget4 = drTotal.Budget4 + vRow.Budget4;
                        drTotal.Budget5 = drTotal.Budget5 + vRow.Budget5;
                        drTotal.Budget6 = drTotal.Budget6 + vRow.Budget6;
                        drTotal.Budget7 = drTotal.Budget7 + vRow.Budget7;
                        drTotal.Budget8 = drTotal.Budget8 + vRow.Budget8;
                        drTotal.Budget9 = drTotal.Budget9 + vRow.Budget9;
                        drTotal.Budget10 = drTotal.Budget10 + vRow.Budget10;
                        drTotal.Budget11 = drTotal.Budget11 + vRow.Budget11;
                        drTotal.Budget12 = drTotal.Budget12 + vRow.Budget12;

                        drTotal.Act1 = drTotal.Act1 + vRow.Act1;
                        drTotal.Act2 = drTotal.Act2 + vRow.Act2;
                        drTotal.Act3 = drTotal.Act3 + vRow.Act3;
                        drTotal.Act4 = drTotal.Act4 + vRow.Act4;
                        drTotal.Act5 = drTotal.Act5 + vRow.Act5;
                        drTotal.Act6 = drTotal.Act6 + vRow.Act6;
                        drTotal.Act7 = drTotal.Act7 + vRow.Act7;
                        drTotal.Act8 = drTotal.Act8 + vRow.Act8;
                        drTotal.Act9 = drTotal.Act9 + vRow.Act9;
                        drTotal.Act10 = drTotal.Act10 + vRow.Act10;
                        drTotal.Act11 = drTotal.Act11 + vRow.Act11;
                        drTotal.Act12 = drTotal.Act12 + vRow.Act12;

                    }
                }

                vi.Rows.Add(drTotal);