ASP.NET C#帮助我了解金额的和或减

本文关键字：金额了解 NET 帮助 ASP | 更新日期: 2023-09-27 18:12:27

<table style="width:80%">
  <tr align="Left">
    <th>Member_No</th>
    <th>Member_Name</th> 
    <th>Amount</th>
    <th>Entry_Type</th>
  </tr>
  <tr>
    <td>A-251</td>
    <td>Alpesh</td> 
    <td>2000</td>
    <td>Credit</td>
  </tr>
  <tr>
    <td>A-252</td>
    <td>Haresh</td> 
    <td>2000</td>
    <td>Debit</td>
  </tr>
  <tr>
    <td>A-253</td>
    <td>Suresh</td> 
    <td>2000</td>
    <td>Debit</td>
  </tr>
  <tr>
    <td>A-254</td>
    <td>Johny</td> 
    <td>5000</td>
    <td>Credit</td>
  </tr>
  <tr>
    <td>A-255</td>
    <td>Vishal</td> 
    <td>1000</td>
    <td>Debit</td>
  </tr>
</table>

我正在将DataGridView用于显示表数据单击合计按钮时，我需要TextBox或Label中上述列Amount的合计金额
但当CCD_ 5是CCD_
&当entry_Type是Debit时，则其进行减法

请帮我做上面的事C#Winform

试试这个：

var total = dataGridView1.Rows.Cast<DataGridViewRow>()
            .AsEnumerable()
            .Sum(x => x.Cells[3].Value.ToString() == "Credit"? int.Parse(x.Cells[2].Value.ToString()) :  -(int.Parse(x.Cells[2].Value.ToString())))
            .ToString();
textBox1.Text = total;