Question

C# WinForm 数据统计问题

private void GatherFBJF()
{
FBJF info = new FBJF();

info.GatherYear = this.dtpStatDate.Value.Year;
info.GatherMonth = this.dtpStatDate.Value.Month;

foreach (RSTJ data in lsRSTJ)
{
info.ShouFeiBiShu += data.ShouFeiBiShu;
}

info.BiShuTongBi = info.ShouFeiBiShu - 1609;

foreach (RSTJ data in lsRSTJ)
{
info.ShouFeiJinE += data.ShouFeiJinE / 10000; //金额单位为万元
}

info.JinETongBi = (info.ShouFeiJinE - 3023);

foreach (RSTJ data in lsRSTJ)
{
if (data.JieSuanFangShi == "现金")
{
info.XianJinBiShu += data.ShouFeiBiShu;
info.XianJinJinE += data.ShouFeiJinE / 10000; //金额单位为万元
}
if (data.JieSuanFangShi == "转帐支票" | data.JieSuanFangShi == "承兑汇票" | data.JieSuanFangShi == "内部帐单" | data.JieSuanFangShi == "转帐")
{
info.ZhuanZhangBiShu += data.ShouFeiBiShu;
info.ZhuanZhangJinE += data.ShouFeiJinE / 10000; //金额单位为万元
}
}
//info.Add();
lsFBJF.Add(info);

this.bseFBJF.DataSource = lsFBJF;
}
说明：FBJF是目标数据(SQL)类，RSTJ是源数据（Excel）类。在上述统计方法中出现了两个问题。一是金额取万元后怎样四舍五入，这个不会弄；二是怎么把统计出的数据写入数据库？注释掉的“//info.Add();”是FBJF类的添加数据的方法，但结果不对，写入数据库的数据合部变为了整数。请高人指点一下！

Answer 1

扩大数的倍数，这个试过没