因为BOSS需要查看销售单退货的情况，不只需要看到退货的明细，而且还要看到退货的总计，以及各个单据对应业务员的关系。因此需要对数据进行统计计算。
以下代码是自己根据自己项目开发中需要用到的地方。
/// <summary>
/// 对DATAGRIDVIEW设置汇总统计信息
/// </summary>
private void setSumInfo()
{
double RMBrealInit = 0;
double USDrealInit = 0;
double HKDrealInit = 0;
double EURrealInit = 0;
double totalQty = 0;//总消退数
double totalPcs = 0;//件数
object obj;
Object obj2;
object obj3;
for (int i = 0; i < dgvSummary.Rows.Count; i++)
{
obj = dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value;
//循环计算RMB的值
if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "RMB")
{
if (obj == null)
{
RMBrealInit += 0;
}
else
{
RMBrealInit+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
}
}//循环计算港币
else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "HKD")
{
if (obj == null)
{
HKDrealInit += 0;
}
else
{
HKDrealInit+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
}
}//美金
else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "USD")
{
if (obj == null)
{
USDrealInit += 0;
}
else
{
USDrealInit+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
}
}//欧元
else if (Convert.ToString(dgvSummary.Rows[i].Cells["N_TransactionMoneyTypeDetail"].Value) == "EUR")
{
if (obj == null)
{
EURrealInit += 0;
}
else
{
EURrealInit+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_totalBackMoneyQty"].Value);
}
}
//计算总总量，若需考虑单位，请考虑兑换比例
obj2 = dgvSummary.Rows[i].Cells["N_TotalBackqty"].Value;
if (obj2 == null)
{
totalQty += 0;
}
else
{
totalQty+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_TotalBackqty"].Value);
}
//计算总件数
obj3 = dgvSummary.Rows[i].Cells["N_TotalBackPcs"].Value;
if (obj3 == null)
{
totalPcs += 0;
}
else
{
totalPcs+= Convert.ToDouble(dgvSummary.Rows[i].Cells["N_TotalBackPcs"].Value);
}
}
/*格式化数字为货币形式*/
System.Globalization.CultureInfo rmbCultureInfo= new System.Globalization.CultureInfo("zh-CN");//
System.Globalization.CultureInfo usdCultureInfo = new System.Globalization.CultureInfo("en-US");
System.Globalization.CultureInfo hkdCultureInfo = new System.Globalization.CultureInfo("zh-HK");
this.txtSumRMB.Text = RMBrealInit.ToString("C", rmbCultureInfo);
// this.txtSumHKD.Text = HKDrealInit.ToString("C", hkdCultureInfo);//此代码显示复数的时候，用括号表示，不知何因由
this.txtSumHKD.Text ="HK$"+ HKDrealInit.ToString("N2", hkdCultureInfo);
this.txtSumUSD.Text = USDrealInit.ToString("C", usdCultureInfo);
this.txtSumEUR.Text = "€" + EURrealInit.ToString("N3");
this.txtSumWeightQty.Text = totalQty.ToString("N0");
this.txtTotalPcs.Text = totalPcs.ToString("N0");
}