/// <summary>
/// 切换cell事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void fpSpread1_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e)
{
if (e.Column == 5)
{
if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE")
{
this.fpSpread1_Sheet1.SetValue(e.Row, 6, false, false);
this.fpSpread1_Sheet1.SetValue(e.Row, 7, false, false);
}
}
else if (e.Column == 6)
{
if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE")
{
this.fpSpread1_Sheet1.SetValue(e.Row, 5, false, false);
this.fpSpread1_Sheet1.SetValue(e.Row, 7, false, false);
}
}
else if (e.Column == 7)
{
if (this.fpSpread1_Sheet1.GetText(e.Row, e.Column).ToUpper() == "TRUE")
{
this.fpSpread1_Sheet1.SetValue(e.Row, 5, false, false);
this.fpSpread1_Sheet1.SetValue(e.Row, 6, false, false);
}
}
}
private void neuSpread1_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e)
{
int rowIdx = 0;
int colIdx = 0;
rowIdx = neuSpread1_Sheet1.ActiveRowIndex;
colIdx = neuSpread1_Sheet1.ActiveColumnIndex;
if (colIdx != 10)
{
#region
//if (System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) +
// System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) +
// System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) -
// System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) -
// System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value) > 0)
//{
#endregion
neuSpread1_Sheet1.Cells[rowIdx, 10].Value =
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value);
#region
//}
//else
//{
// MessageBox.Show("输入有误将会使期末实有病人数为负！");
// neuSpread1.SetActiveCell(e.Row,e.Column);
// neuSpread1.EditMode = true;
//}
#endregion
}
else
{
if (System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 10].Value) !=
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 4].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value))
{
#region
//if (MessageBox.Show("期末实有病人数有误差，是否修改原有病人数！", "错误", MessageBoxButtons.YesNo, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
//{
#endregion
///为保证等式的成立设为原与人数是不确定的，发现存在误差修改原有人数
neuSpread1_Sheet1.Cells[rowIdx, 4].Value =
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 10].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 5].Value) -
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 6].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 7].Value) +
System.Convert.ToInt32(neuSpread1_Sheet1.Cells[rowIdx, 8].Value);
#region
//}
//else
//{
// neuSpread1.SetActiveCell(rowIdx, 10);
// neuSpread1.EditMode = true;
//}
#endregion
}
}
}
private void GrdView_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e)
{
GrdView.ActiveSheet.SetText(e.Row, liColFlag, "1");
GrdView.ActiveSheet.Cells[e.Row, liColCode, e.Row, liColFlag].ForeColor = Color.Red;
GrdView.ActiveSheet.Cells[e.Row, liColCode, e.Row, liColFlag].Font = new Font("Microsoft Sans Serif", 8, FontStyle.Bold);
}
