- //合計金額計算
- Decimal Objectnum=0;
- for (int j = 0;j < fpSpreadVend.ActiveSheet.Rows.Count;j++)
- {
- if(this.fpSpreadVend.ActiveSheet.Cells[j,2].Text=="")
- {
- Objectnum = Objectnum + Convert.ToDecimal("0");
- }
- else
- {
- Objectnum = Objectnum + Convert.ToDecimal(this.fpSpreadVend.ActiveSheet.Cells[j,2].Text.Trim());
- }
- }
- if(Objectnum == 0)
- {
- this.txtSumMoney.Text = Objectnum.ToString();
- }
- else
- {
- this.txtSumMoney.Text = string.Format("{0,0:#,###,###,###}",Objectnum);
- }
合计金额计算
最新推荐文章于 2021-12-01 19:39:46 发布