private void DBGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
if (e.RowIndex == -1)
{
return;
}
if (e.ColumnIndex == -1)
{
return;
}
if (DBGrid.Columns[e.ColumnIndex].Name == "SalesManMny" || DBGrid.Columns[e.ColumnIndex].Name == "PaidSalesMny")
{
modSalesManMny mod = (modSalesManMny)DBGrid.Rows[e.RowIndex].DataBoundItem;
bool ret = false;
switch (mod.ShipType)
{
case "送货单":
case "收营单":
case "退货单":
ret = _dal.UpdateSalesManMny(mod.ShipId, mod.Seq, mod.SalesManMny, mod.PaidSalesMny, Util.UserId, out Util.emsg);
break;
case "设计服务":
case "来料加工":
case "设计服务退货":
case "来料加工退货":
dalSalesDesignForm dal = new dalSalesDesignForm();
ret = dal.UpdateSalesManMny(Convert.ToInt32(mod.ShipId), mod.SalesManMny, mod.PaidSalesMny, Util.UserId, out Util.emsg);
break;
default:
MessageBox.Show("无法识别该种单据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (ret)
{
GetDetailSum();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void GetDetailSum()
{
decimal sum = 0;
decimal salesmny = 0;
decimal paidsalesmny = 0;
if (DBGrid.RowCount == 0)
{
return;
}
for (int i = 0; i < DBGrid.RowCount; i++)
{
modSalesManMny mod = (modSalesManMny)DBGrid.Rows[i].DataBoundItem;
sum += mod.SumMny * mod.AdFlag;
salesmny += mod.SalesManMny * mod.AdFlag;
paidsalesmny += mod.PaidSalesMny * mod.AdFlag;
}
StatusLabel1.Text = "共 " + DBGrid.RowCount.ToString() + " 行数据， 合计金额为: " + string.Format("{0:C2}", sum);
StatusLabel2.Text = "业务提成: " + string.Format("{0:C2}", salesmny);
StatusLabel3.Text = "已付提成: " + string.Format("{0:C2}", paidsalesmny);
}
