public override void Form_Ref() { string sFromLoc = ""; string sToLoc = ""; //if ((txt_f_addr.Text == "" || txt_t_addr.Text == "" )&& txt_slab_no.Text!="") //{ // GeneralCommon.Gp_MsgBoxDisplay("板坯号输入的情况下,起始垛位号以及目的垛位号必须输入", "W", "警告"); // return; //} if (txt_f_addr.Text != "" && txt_t_addr.Text != "") { if (txt_slab_no.Text != "" && txt_slab_no.Text.Length != 10) { GeneralCommon.Gp_MsgBoxDisplay("板坯号长度必须为10位", "W", "警告"); return; } } if (opt_Left_Right.Checked) { sFromLoc = txt_f_addr.Text; sToLoc = txt_t_addr.Text; } else { sFromLoc = txt_t_addr.Text; sToLoc = txt_f_addr.Text; } if (sFromLoc != "" && sToLoc != "") { if (sFromLoc == sToLoc) { GeneralCommon.Gp_MsgBoxDisplay("起始垛位号和目的垛位号相同!请重新选择起始垛位号和目的垛位号!", "W", ""); return; } else if (sFromLoc != "S0A0101") { if (txt_slab_no.Text != "") { GeneralCommon.Gp_MsgBoxDisplay("不是在线板坯入库,板坯号和目的垛位号不能同时输入!", "W", ""); return; } } } //if (txt_f_addr.Text == "S0A0101" || txt_f_addr.Text == "S0Q0101") // SpreadCommon.Gp_Sp_ColHidden(ss1, 0, true); //else // SpreadCommon.Gp_Sp_ColHidden(ss1, 0, false); //if (txt_t_addr.Text == "S0A0101" || txt_t_addr.Text == "S0Q0101") // SpreadCommon.Gp_Sp_ColHidden(ss2, 0, true); //else // SpreadCommon.Gp_Sp_ColHidden(ss2, 0, false); //if (p_Ref(1, 1, true, false)) if (SpreadCommon.Gf_Sp_Refer(GeneralCommon.M_CN1, (Collection)Proc_Sc[1], (Collection)Proc_Mc[1], (Collection)((Collection)Proc_Mc[1])["npControl"], (Collection)((Collection)Proc_Mc[1])["mControl"], false)) { this.ss1.ActiveSheet.Rows.Add(0, 60 - this.ss1.ActiveSheet.Rows.Count); if ((sFromLoc == "S0A0101" || sFromLoc == "S0Q0101" || sFromLoc == "") && (txt_slab_no.Text != "")) { for (int i = 0; i < this.ss1_Sheet1.RowCount; i++) { if (this.ss1_Sheet1.Cells[i, 1].Text == txt_slab_no.Text) { this.ss1_Sheet1.RowHeader.Cells[i, 0].Text = "入库"; proNum = 1; txt_slab_cnt.Text = "1"; this.ss1_Sheet1.Cells[i, 1].BackColor = Color.Red; break; } } } } else { setSpread(ss1); ss1HaveRowCount = 60; } this.ss1.SetViewportTopRow(0, 43); // if (p_Ref(1, 2, true, false)) if (SpreadCommon.Gf_Sp_Refer(GeneralCommon.M_CN1, (Collection)Proc_Sc[2], (Collection)Proc_Mc[1], (Collection)((Collection)Proc_Mc[1])["npControl"], (Collection)((Collection)Proc_Mc[1])["mControl"], false)) { int temp = this.ss2.ActiveSheet.Rows.Count; this.ss2.ActiveSheet.Rows.Add(0, 60 - this.ss2.ActiveSheet.Rows.Count); if (txt_slab_no.Text != "") { if (GeneralCommon.Gf_CodeFind(GeneralCommon.M_CN1, "SELECT YARD_ADDR FROM FP_SLABYARD WHERE SLAB_NO = '" + txt_slab_no.Text + "' AND YARD_KND = '" + CBO_CUR_INV.Text + "'") == "") { this.ss2_Sheet1.RowHeader.Cells[59 - temp, 0].Text = "增加"; this.ss2_Sheet1.Cells[59 - temp, 0].Text = (temp + 1).ToString(); this.ss2_Sheet1.Cells[59 - temp, 1].Text = txt_slab_no.Text; this.ss2_Sheet1.Cells[59 - temp, 1].BackColor = Color.Red; this.ss2_Sheet1.Cells[59 - temp, 3].Text = sToLoc; this.ss2_Sheet1.Cells[59 - temp, 15].Text = sFromLoc; this.ss2_Sheet1.Cells[59 - temp, 14].Text = GeneralCommon.sUserID; ssc_can.Enabled = true; } else { if (sToLoc == "") { for (int i = 0; i < this.ss2_Sheet1.RowCount; i++) { if (this.ss2_Sheet1.Cells[i, 1].Text == txt_slab_no.Text) { this.ss2_Sheet1.Cells[i, 1].BackColor = Color.Red; } } } if (sFromLoc == "S0A0101" || sFromLoc == "S0Q0101") { GeneralCommon.Gp_MsgBoxDisplay("板坯 " + txt_slab_no.Text + " 已经在库中,不需再做入库处理!", "W", ""); txt_slab_no.Text = ""; } } } } else { ss2HaveRowCount = 60; setSpread(ss2); if (txt_slab_no.Text != "" && (sFromLoc == "S0A0101" || sFromLoc == "S0Q0101" || sFromLoc == "")) { if (GeneralCommon.Gf_CodeFind(GeneralCommon.M_CN1, "SELECT YARD_ADDR FROM FP_SLABYARD WHERE SLAB_NO = '" + txt_slab_no.Text + "' AND YARD_KND = '" + CBO_CUR_INV.Text + "'") == "") { this.ss2_Sheet1.RowHeader.Cells[59, 0].Text = "增加"; this.ss2_Sheet1.Cells[59, 0].Text = (1).ToString(); this.ss2_Sheet1.Cells[59, 1].Text = txt_slab_no.Text; this.ss2_Sheet1.Cells[59, 1].BackColor = Color.Red; this.ss2_Sheet1.Cells[59, 3].Text = sToLoc; this.ss2_Sheet1.Cells[59, 15].Text = sFromLoc; this.ss2_Sheet1.Cells[59, 14].Text = GeneralCommon.sUserID; txt_slab_cnt.Text = "1"; ssc_can.Enabled = true; } else { GeneralCommon.Gp_MsgBoxDisplay("板坯 " + txt_slab_no.Text + " 已经在库中,不需再做入库处理!", "W", ""); txt_slab_no.Text = ""; return; } } } this.ss2.SetViewportTopRow(0, 43); for (int i = 0; i < this.ss1_Sheet1.RowCount; i++) { if (this.ss1_Sheet1.Cells[i, 1].Text == "") { this.ss1_Sheet1.Cells[i, 1].Locked = true; this.ss1_Sheet1.Cells[i, 1].BackColor = Color.White; } } for (int i = 0; i < this.ss2_Sheet1.RowCount; i++) { if (this.ss2_Sheet1.Cells[i, 1].Text == "") { this.ss2_Sheet1.Cells[i, 1].Locked = true; this.ss2_Sheet1.Cells[i, 1].BackColor = Color.White; } } ssc_move.Enabled = false; ssc_can.Enabled = false; txt_slab_cnt.Enabled = false; txt_p_row.Enabled = false; for (int i = 0; i < this.ss1_Sheet1.RowCount; i++) { if (this.ss1_Sheet1.Cells[i, 1].Text != "") { ss1HaveRowCount = i; break; } } for (int i = 0; i < this.ss2_Sheet1.RowCount; i++) { if (this.ss2_Sheet1.Cells[i, 1].Text != "") { ss2HaveRowCount = i; break; } } }