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); //选定行着色 } }