public override void Form_Ref() { if (txt_loc_fr.Text.Trim().Length != 7 && txt_plate_no.Text.Trim().Length != 14) { GeneralCommon.Gp_MsgBoxDisplay("请输入起始垛位", "I", this.Text); return; } btn_move.Enabled = true; if (base.p_Ref(1, 1, true, true)) //如果是按钢板号查询,将该钢板号所在垛位情况同时显示,并且自动滚动到该钢板所在垛层 { if (txt_plate_no.Text.Trim().Length == 14 && ss1.ActiveSheet.RowCount > 0) { for (int iRow = ss1.Sheets[0].RowCount - 1; iRow >= 0; iRow--) { if (ss1.ActiveSheet.Cells[iRow, iss1_plate_no].Text.Trim() == txt_plate_no.Text.Trim()) { ss1.ShowRow(0, iRow, VerticalPosition.Center); //跳转到钢板所在行 ss1.ActiveSheet.Rows.Get(iRow).BackColor = Color.LightSkyBlue; //亮色显示所要查找钢板 break; } } } } if (txt_loc_to.Text.Trim().Length == 7) { //传入后台列着色 base.p_Ref(2, 2, true, false); SpreadCommon.Gp_Sp_ColColor(ss2, iss2_plate_no, Color.Black, Color.White); SpreadCommon.Gp_Sp_ColColor(ss2, iss2_bed_seq, Color.Black, Color.White); SpreadCommon.Gp_Sp_ColColor(ss2, iss2_yarrd, Color.Black, Color.White); SpreadCommon.Gp_Sp_ColColor(ss2, iss2_upd_emp, Color.Black, Color.White); } sxt_select_cnt.NumValue = 0; return; }