WPF 计算DataGrid每一列的合计数

WPF 计算DataGrid每一列的合计数
作者：邱名涛
撰写时间：2019 年 8 月 8 日

XAML:
  WindowStartupLocation="CenterScreen" Loaded="Window_Loaded">
<StackPanel Orientation="Horizontal" VerticalAlignment="Center">
                        <TextBlock Text="记录数：" Margin="10,0,0,0"></TextBlock>
                        <TextBlock Text="" Foreground="Red" x:Name="txt_JILU"></TextBlock>
                        <TextBlock Text="数量：" Margin="150,0,0,0"></TextBlock>
                        <TextBlock Text="" Foreground="Red" x:Name="txt_SHULiang"></TextBlock>
                        <TextBlock Text="总金额：" Margin="10,0,0,0"></TextBlock>
                        <TextBlock Text="" Foreground="Red" x:Name="txt_HejiJinge"></TextBlock>
                    </StackPanel>

CS:
private void Window_Loaded(object sender, RoutedEventArgs e){
           int JiLushu = 0;//定义int，获取表格有多少条数据
            decimal b = 0;//定义参数b,接收数量总数
            decimal c = 0; //定义参数c,接收总金额数据合计
            DataTable dts = myClients.Select_CaiGouShuLiang().Tables[0];//获取数据数据
            foreach (DataRow item in dts.Rows)//循环数据库行数，获取单价和总数。
            {
                b += Convert.ToDecimal(item["Amount"].ToString());
                c += Convert.ToDecimal(item["HEJI"].ToString());
            }
            JiLushu = dts.Rows.Count;
            txt_JILU.Text= JiLushu.ToString();
            txt_SHULiang.Text = b.ToString();
            txt_HejiJinge.Text = c.ToString() + "￥";
        Data_PurNumber.ItemsSource = dts.DefaultView;
}