GridControl改变单元格内容，另一单元格随之变化

最新推荐文章于 2021-11-20 15:43:57 发布

倾听雨霁

最新推荐文章于 2021-11-20 15:43:57 发布

阅读量2.7k

点赞数

分类专栏： C# 文章标签： GridControl

本文链接：https://blog.csdn.net/yc147258/article/details/91867890

版权

C# 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

/// <summary>
/// 单元格改变事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grvShowList_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
if (grvShowList.RowCount > 0 && e.RowHandle >= 0)
{
if (grvShowList.FocusedColumn.FieldName == "PrimaxQty" || grvShowList.FocusedColumn.FieldName == "PACKRATE")
{
try
{
int handle = e.RowHandle;
decimal i = 0;
decimal PrimaxQty = 0;
//decimal PACKRATE = 0;

if (decimal.TryParse(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "PrimaxQty").ToString(), out i))
{
PrimaxQty = Convert.ToDecimal(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "PrimaxQty").ToString());
}

SearchCondition con = new SearchCondition();
con.AddCondition("PO", grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "PO").ToString(),SqlOperator.Equal);
con.AddCondition("Item", grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "Item").ToString(), SqlOperator.Equal);
MST_ASN_PRINTDATAInfo info = BLLFactory<MST_ASN_PRINTDATA>.Instance.FindSingle(con.BuildConditionSql());
if (info==null)
{
return;
}

//if (decimal.TryParse(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "PACKRATE").ToString(), out i))
//{
// PACKRATE = Convert.ToDecimal(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "PACKRATE").ToString());
//}

decimal SulQty = PrimaxQty - (info.PrimaxQty - info.DoneQty);
if (SulQty >= 0)
{
if (grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "SulQty").ToString() == "" || SulQty != Convert.ToDecimal(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "SulQty").ToString()))
{
grvShowList.SetRowCellValue(grvShowList.FocusedRowHandle, "SulQty", SulQty);
}//此处判断很重要
}
else {
SulQty = 0;
if (grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "SulQty").ToString() == "" || SulQty != Convert.ToDecimal(grvShowList.GetRowCellValue(grvShowList.FocusedRowHandle, "SulQty").ToString()))
{
grvShowList.SetRowCellValue(grvShowList.FocusedRowHandle, "SulQty", SulQty);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}