private void btn_cancel_Click(object sender, EventArgs e)
{
int iRowidx;
btn_move.Enabled = true;
if (ss1.ActiveSheet.SelectionCount > 0)
{
for (int iRow = ss1.ActiveSheet.RowCount - 1; iRow >= 0; iRow--)
{
if (ss1.ActiveSheet.RowHeader.Rows[iRow].Label == "删除")//钢板号相同且行头是增加才可以取消
{
iRowidx = iRow + 1;
ss1.ActiveSheet.RowHeader.Rows[iRow].Label = iRowidx.ToString(); //行头恢复
SpreadCommon.Gp_Sp_RowColor(ss1, iRow, Color.Black, Color.White); //背景色恢复
}
}
}
if (ss2.ActiveSheet.RowCount > 0)
{
for (int iRow = ss2.ActiveSheet.RowCount - 1; iRow >= 0; iRow--)
{
if (ss2.ActiveSheet.RowHeader.Rows[iRow].Label == "修改") //钢板号相同且行头是增加才可以取消
{
ss2.ActiveSheet.Cells[iRow, iss2_plate_no].Text = ""; //清空钢板号
ss2.ActiveSheet.Cells[iRow, iss2_upd_emp].Text = ""; //清空指定垛位人员
iRowidx = iRow + 1;
ss2.ActiveSheet.RowHeader.Rows[iRow].Label = iRowidx.ToString(); //行头恢复
SpreadCommon.Gp_Sp_RowColor(ss2, iRow, Color.Black, Color.White); //背景色恢复
}
}
sxt_select_cnt.NumValue = 0;
}
}
private void move_mark(int startrow)
{
for (int icnt = 0; icnt < (int)sxt_select_cnt.NumValue; icnt++)
{
ss1.ActiveSheet.RowHeader.Rows[ss1.ActiveSheet.ActiveRowIndex - icnt].Label = "删除";
ss2.ActiveSheet.RowHeader.Rows[startrow - icnt].Label = "修改";
ss2.ActiveSheet.Cells[startrow - icnt, iss2_plate_no].Text = ss1.ActiveSheet.Cells[ss1.ActiveSheet.ActiveRowIndex - icnt, iss1_plate_no].Text;
SpreadCommon.Gp_Sp_RowColor(ss1, ss1.ActiveSheet.ActiveRowIndex - icnt, Color.Black, Color.LightPink); //选定行着色
SpreadCommon.Gp_Sp_RowColor(ss2, startrow - icnt, Color.Black, Color.LightPink); //选定行着色
}
}
