예제 #1
0
        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;
        }